向android虚拟机中push文件提示Read-only file system
摘要：在cmd窗口一条命令就可以了： adb shell mount -o remount rw /
阅读全文
posted @
2012-02-11 18:16
prayforsmile
阅读(1153)
推荐(0) 编辑
存储
摘要：string rptURL = this.frmReportServicesPath + "BatarRpts/RepInStorage" + "&rc:ToolBar=true&rc:Parameters=true" + "&strIds=" + dr["InStor_id"].ToString(); FormManager.OpenReportViewForm("入库单", rptURL);
阅读全文
posted @
2011-03-07 09:52
prayforsmile
阅读(148)
推荐(0) 编辑
时间对应多条记录
摘要：SELECT A.*,B.TotalWeight,B.TotalMoneyFROM(SELECT CONVERT(varchar(10),A.AccountDt,120) AS AccountDt,A.[NetWeight],A.[Fee]FROM [BtProduceManage].[dbo].[Tst_Material] as A inner join Bse_Depart AS B ON B...
阅读全文
posted @
2010-11-17 14:11
prayforsmile
阅读(171)
推荐(0) 编辑
=iif(RowNumber("table6_Group3")=1,"Solid","None")
摘要：=iif(RowNumber("table6_Group3")=1,"Solid","None")
阅读全文
posted @
2010-09-13 14:49
prayforsmile
阅读(236)
推荐(0) 编辑
StringSplitToTable
摘要：SELECT * FROM dbo.Tst_Move AINNER JOIN StringSplitToTable(@Move_Ids,',') AS B ON B.Id=A.Move_IdWHERE A.From_Dept<>@EDept_Id
阅读全文
posted @
2010-09-09 10:05
prayforsmile
阅读(206)
推荐(0) 编辑
SP 拼音
摘要：SELECT [CustId] ,[CustName] as [Name] ,[State] ,[dbo].[GetPinYin]([CustName]) as Number FROM [Customer] set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER function [dbo].[GetPinYin] ( @str nvarchar(400...
阅读全文
posted @
2010-08-17 15:19
prayforsmile
阅读(227)
推荐(0) 编辑
临时表 调用另一个存储过程
摘要：DECLARE @Number VARCHAR(30) CREATE TABLE #table(Number VARCHAR(30))INSERT INTO #table EXEC Get_Sys_Series_Number 'SCK','ShopCheckOrd','CkOrdNum',3,@Sp_IdSELECT * FROM #table DROP TABLE #table
阅读全文
posted @
2010-07-15 09:50
prayforsmile
阅读(280)
推荐(0) 编辑
时间
摘要：DATEDIFF(DAY, A.CreateTime, @StartTime) <= 0 AND DATEDIFF(DAY, A.CreateTime, @EndTime) >= 0
阅读全文
posted @
2010-06-11 15:02
prayforsmile
编辑
1
摘要：-- =============================================-- Author:<Author,,Name>-- Create date: <Create Date,,>-- Description:获得入库单表头信息-- =============================================ALTER PROCEDU...
阅读全文
posted @
2010-05-19 16:20
prayforsmile
阅读(163)
推荐(0) 编辑
SP插入
摘要：INSERT CheckTemp (ChkCode,BarCode,ChkState, ChkTime,CounterID,ChkUserID,Sp_Id)(SELECT @ChkCode,A.BarCode,0,getdate(),@Sc_Id,@ChkUserID,@Sp_IdFROM ShopCounterStorage A left join ProductModelInfo B on A...
阅读全文
posted @
2010-05-17 17:19
prayforsmile
阅读(202)
推荐(0) 编辑
rrr
摘要：UPDATE ProductModelInfo SETExStone=CASE WHEN Sto_Id IS NULL THEN 0 ELSE 1 END,DisEnable=CASE WHEN SUBSTRING(B.Number,1,1)='2' THEN 1 ELSE 0 ENDFROM ProductModelInfo ALEFT OUTER JOIN DepartmentInfo B O...
阅读全文
posted @
2010-04-27 14:12
prayforsmile
阅读(160)
推荐(0) 编辑
ddl
摘要：var item = document.getElementById("<%=drpGroupType.ClientID %>"); var index = item.selectedIndex; var Text = item.options[index].text; if (Text == "Private" || Text == "Platinum Private") { do...
阅读全文
posted @
2010-02-03 10:33
prayforsmile
阅读(79)
推荐(0) 编辑
关于Case项目
摘要：Hi,Rex: Case这个项目终于结束了。很内疚，没有迅速的做好。记得刚开始的时候，你问我，做到啥程度了，我说，接近结尾。因为那个时候，我真的以为只有六大任务，而当时我已经完成了五个任务了，而且比较快,只剩下一个任务了～ 后来证明我错了，错的原因是，我拿到的是一份错误的源代码，不是服务器上的版本！当然这个在一开始是不知道的，我以为这套系统本来就是运行不起来的，因为太多幼稚的错误在里面了，然后一直...
阅读全文
posted @
2009-11-18 17:07
prayforsmile
阅读(285)
推荐(0) 编辑
第一次真正意思上写的js
摘要：以后可以常用js来写代码了。嘿嘿。。。。年轻在于积累。。。
阅读全文
posted @
2009-07-23 15:41
prayforsmile
阅读(247)
推荐(0) 编辑
sp语句
摘要： DECLARE @ApplicationId uniqueidentifier
SELECT @ApplicationId = NULL
SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
IF (@ApplicationId IS NULL)
RETURN(1)
DECLARE @UserId uniqueidentifier
SELECT @UserId = NULL
阅读全文
posted @
2009-07-14 14:05
prayforsmile
阅读(324)
推荐(0) 编辑
