摘要:
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[Rpts_GetGoldIndentOrdersInfo]-- Add the parameters for the stored procedure here@IndetOrdNum varchar(50)='',@IsAmount varchar='1'ASBEG... 阅读全文
摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
var item = document.getElementById("<%=drpGroupType.ClientID %>"); var index = item.selectedIndex; var Text = item.options[index].text; if (Text == "Private" || Text == "Platinum Private") { do... 阅读全文