摘要： 在cmd窗口一条命令就可以了： adb shell mount -o remount rw / 阅读全文

摘要： string rptURL = this.frmReportServicesPath + "BatarRpts/RepInStorage" + "&rc:ToolBar=true&rc:Parameters=true" + "&strIds=" + dr["InStor_id"].ToString(); FormManager.OpenReportViewForm("入库单", rptURL); 阅读全文

摘要： 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... 阅读全文

摘要： =iif(RowNumber("table6_Group3")=1,"Solid","None") 阅读全文

摘要： SELECT * FROM dbo.Tst_Move AINNER JOIN StringSplitToTable(@Move_Ids,',') AS B ON B.Id=A.Move_IdWHERE A.From_Dept<>@EDept_Id 阅读全文

摘要： 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... 阅读全文

摘要： 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 阅读全文

摘要： select @@identity 阅读全文

摘要： DATEDIFF(DAY, A.CreateTime, @StartTime) <= 0 AND DATEDIFF(DAY, A.CreateTime, @EndTime) >= 0 阅读全文

摘要： DELETE Bse_U_R_RelFROM Bse_U_R_Rel AS AINNER JOIN [dbo].[StringSplitToTable](@DelRoleIds,',') AS B ON B.Id=A.Role_IdWHERE [User_Id]=@User_IdINSERT INTO Bse_U_R_Rel([User_Id],Role_Id)SELECT @User_Id,B.... 阅读全文