📄 ttt.txt
字号:
[bAccessary],
[iTaxRate],
[iInvWeight],
[iVolume],
[iInvRCost],
[iInvSPrice],
[iInvSCost],
[iInvLSCost],
[iInvNCost],
[iInvAdvance],
[iInvBatch],
[iSafeNum],
[iTopSum],
[iLowSum],
[iOverStock],
[cInvABC],
[bInvQuality],
[bInvBatch],
[bInvEntrust],
[bInvOverStock],
[dSDate],
[dEDate],
[bFree1],
[bFree2],
[cInvDefine1],
[cInvDefine2],
[cInvDefine3],
[bInvType],
[iInvMPCost],
[cQuality],
[iInvSaleCost],
[iInvSCost1],
[iInvSCost2],
[iInvSCost3],
[bFree3],
[bFree4],
[bFree5],
[bFree6],
[bFree7],
[bFree8],
[bFree9],
[bFree10],
[cCreatePerson],
[cModifyPerson],
[dModifyDate],
[fSubscribePoint],
[fVagQuantity],
[cValueType],
[bFixExch],
[fOutExcess],
[fInExcess],
[iMassDate],
[iWarnDays],
[fExpensesExch],
[bTrack],
[bSerial],
[bBarCode],
[iId],
[cBarCode],
[cInvDefine4],
[cInvDefine5],
[cInvDefine6],
[cInvDefine7],
[cInvDefine8],
[cInvDefine9],
[cInvDefine10],
[cInvDefine11],
[cInvDefine12],
[cInvDefine13],
[cInvDefine14],
[cInvDefine15],
[cInvDefine16],
[iGroupType],
[cGroupCode],
[cComUnitCode],
[cAssComUnitCode],
[cSAComUnitCode],
[cPUComUnitCode],
[cSTComUnitCode],
[cCAComUnitCode],
[cFrequency],
[iFrequency],
[iDays],
[dLastDate],
[iWastage],
[bSolitude],
[cEnterprise],
[cAddress],
[cFile],
[cLabel],
[cCheckOut],
[cLicence],
[bSpecialties],
[cDefWareHouse],
[iHighPrice],
[iExpSaleRate],
[cPriceGroup],
[cOfferGrade],
[iOfferRate],
[cMonth],
[iAdvanceDate],
[cCurrencyName],
[cProduceAddress],
[cProduceNation],
[cRegisterNo],
[cEnterNo],
[cPackingType],
[cEnglishName],
[bPropertyCheck],
[cPreparationType],
[cCommodity],
[iRecipeBatch],
[cNotPatentName],
[pubufts],
[bPromotSales],
[iPlanPolicy],
[iROPMethod],
[iBatchRule],
[fBatchIncrement],
[iAssureProvideDays],
[iTestStyle],
[iDTMethod],
[fDTRate],
[fDTNum],
[cDTUnit],
[iDTStyle],
[iQTMethod],
-- [PictureGUID],
[bPlanInv],
[bProxyForeign],
[bATOModel],
[bCheckItem],
[bPTOModel],
[bEquipment],
[cProductUnit],
[fOrderUpLimit],
[cMassUnit],
[fRetailPrice],
[cInvDepCode],
[iAlterAdvance],
[fAlterBaseNum],
[cPlanMethod],
[bMPS],
[bROP],
[bRePlan],
[cSRPolicy],
[bBillUnite],
[iSupplyDay],
[fSupplyMulti],
[fMinSupply],
[bCutMantissa],
[cInvPersonCode],
[iInvTfId],
[cEngineerFigNo],
[bInTotalCost],
[iSupplyType],
[bConfigFree1],
[bConfigFree2],
[bConfigFree3],
[bConfigFree4],
[bConfigFree5],
[bConfigFree6],
[bConfigFree7],
[bConfigFree8],
[bConfigFree9],
[bConfigFree10],
[iDTLevel],
[cDTAQL],
[bPeriodDT],
[cDTPeriod],
[iBigMonth],
[iBigDay],
[iSmallMonth],
[iSmallDay],
[bOutInvDT],
[bBackInvDT],
[iEndDTStyle],
[bDTWarnInv],
[fBackTaxRate],
[cCIQCode],
[cWGroupCode],
[cWUnit],
[fGrossW],
[cVGroupCode],
[cVUnit],
[fLength],
[fWidth],
[fHeight],
[iDTUCounter],
[iDTDCounter],
[iBatchCounter],
[cShopUnit],
[cPurPersonCode],
[bImportMedicine],
[bFirstBusiMedicine],
[bForeExpland],
[cInvPlanCode],
[fConvertRate],
[dReplaceDate],
[bInvModel],
[bKCCutMantissa],
[bReceiptByDT],
[iImpTaxRate],
[iExpTaxRate],
[bExpSale],
[iDrawBatch],
[bCheckBSATP],
[cInvProjectCode],
[iTestRule],
[cRuleCode],
[bCheckFree1],
[bCheckFree2],
[bCheckFree3],
[bCheckFree4],
[bCheckFree5],
[bCheckFree6],
[bCheckFree7],
[bCheckFree8],
[bCheckFree9],
[bCheckFree10],
[bBomMain],
[bBomSub],
[bProductBill],
[iCheckATP],
[iInvATPId],
[iPlanTfDay],
[iOverlapDay],
[bPiece],
[bSrvItem],
[bSrvFittings],
[fMaxSupply],
[fMinSplit],
-- [bSpecialOrder],
[bTrackSaleBill])
VALUES
( @cInvCode,
Null,--cInvAddCode_2,
@cInvName,--cInvName_3,
@cInvStd,--cInvStd_4,
@cInvCCode,--cInvCCode_5,
@cVenCode,--cVenCode_6,
Null,--cReplaceItem_7,
Null,--cPosition_8,
-1,--bSale_9,
-1,--bPurchase_10,
0,--bSelf_11,
0,--bComsume_12,
0,--bProducing_13,
0,--bService_14,
0,--bAccessary_15,
0,--iTaxRate_16,
Null,--iInvWeight_17,
0,--iVolume_18,
0,--iInvRCost_19,
@iInvSPrice,--iInvSPrice_20,
@iInvSCost,--iInvSCost_21,
@iInvLSCost,--iInvLSCost_22,
@iInvSPrice,--iInvNCost_23,
0,--iInvAdvance_24,
Null,--iInvBatch_25,
Null,--iSafeNum_26,
Null,--iTopSum_27,
Null,--iLowSum_28,
Null,--iOverStock_29,
Null,--cInvABC_30,
0,--bInvQuality_31,
0,--bInvBatch_32,
0,--bInvEntrust_33,
0,--bInvOverStock_34,
@dSDate,--dSDate_35,
Null,--dEDate_36,
-1,--bFree1_37,
-1,--bFree2_38,
@bMyLabel,--cInvDefine1_39,
Null,--cInvDefine2_40,
Null,--cInvDefine3_41,
0,--bInvType_43,
Null,--iInvMPCost_44,
Null,--cQuality_45,
Null,--iInvSaleCost_46,
Null,--iInvSCost1_47,
Null,--iInvSCost2_48,
Null,--iInvSCost3_49,
0,--bFree3_50,
0,--bFree4_51,
0,--bFree5_52,
0,--bFree6_53,
0,--bFree7_54,
0,--bFree8_55,
0,--bFree9_56,
0,--bFree10_57,
@Person,--cCreatePerson_58,
@Person,--cModifyPerson_59,
@dSDate,--dModifyDate_60,
Null,--fSubscribePoint_61,
Null,--fVagQuantity_62,
Null,--cValueType_63,
0,--bFixExch_64,
Null,--fOutExcess_65,
1000,--fInExcess_66,
Null,--iMassDate_67,
Null,--iWarnDays_68,
Null,--fExpensesExch_69,
0,--bTrack_70,
0,--bSerial_71,
-1,--bBarCode_72,
Null,--iId_73,
@cInvCode,--cBarCode_74,
Null,--cInvDefine4_75,
Null,--cInvDefine5_76,
Null,--cInvDefine6_77,
Null,--cInvDefine7_78,
Null,--cInvDefine8_79,
Null,--cInvDefine9_80,
@bControl,--cInvDefine10_81,
@iPlanCust,--cInvDefine11_82,
Null,--cInvDefine12_83,
@iInvSPrice,--cInvDefine13_84,
@iInvSCost,--cInvDefine14_85,
Null,--cInvDefine15_86,
Null,--cInvDefine16_87,
1,--iGroupType_88,
@cUnitCode,--cGroupCode_89,
@cUnitCode+'01',--cComUnitCode_90,
Null,--cAssComUnitCode_91,
@cUnitCode+'02',--cSAComUnitCode_92,
@cUnitCode+'02',--cPUComUnitCode_93,
@cUnitCode+'02',--cSTComUnitCode_94,
@cUnitCode+'02',--cCAComUnitCode_95,
Null,--cFrequency_96,
Null,--iFrequency_97,
Null,--iDays_98,
@dSDate,--dLastDate_99,
Null,--iWastage_100,
0,--bSolitude_101,
Null,--cEnterprise_102,
Null,--cAddress_103,
Null,--cFile_104,
@cLabel,--cLabel_105,
Null,--cCheckOut_106,
Null,--cLicence_107,
0,--bSpecialties_108,
@DefWH,--cDefWareHouse_109,
Null,--iHighPrice_110,
Null,--iExpSaleRate_111,
Null,--cPriceGroup_112,
Null,--cOfferGrade_113,
Null,--iOfferRate_114,
'200800',--cMonth_115,
Null,--iAdvanceDate_116,
@cSouName,--cCurrencyName_117,
Null,--cProduceAddress_118,
Null,--cProduceNation_119,
Null,--cRegisterNo_120,
Null,--cEnterNo_121,
Null,--cPackingType_122,
@cLabel,--cEnglishName_123,
0,--bPropertyCheck_124,
Null,--cPreparationType_125,
Null,--cCommodity_126,
0,--iRecipeBatch_127,
Null,--cNotPatentName_128,
Null,--pubufts_129,
0,--bPromotSales_130,
Null,--iPlanPolicy_131,
Null,--iROPMethod_132,
Null,--iBatchRule_133,
Null,--fBatchIncrement_134,
Null,--iAssureProvideDays_135,
-1,--iTestStyle_136,
-1,--iDTMethod_137,
Null,--fDTRate_138,
Null,--fDTNum_139,
Null,--cDTUnit_140,
-1,--iDTStyle_141,
Null,--iQTMethod_142,
-- Null,--PictureGUID_143,
0,--bPlanInv_144,
0,--bProxyForeign_145,
0,--bATOModel_146,
0,--bCheckItem_147,
0,--bPTOModel_148,
0,--bEquipment_149,
@cUnitCode+'02',--cProductUnit_150,
1000,--fOrderUpLimit_151,
Null,--cMassUnit_152,
@fRetailPrice,--fRetailPrice_153,
Null,--cInvDepCode_154,
Null,--iAlterAdvance_155,
Null,--fAlterBaseNum_156,
'R',--cPlanMethod_157,
0,--bMPS_158,
0,--bROP_159,
0,--bRePlan_160,
'PE',--cSRPolicy_161,
0,--bBillUnite_162,
Null,--iSupplyDay_163,
Null,--fSupplyMulti_164,
Null,--fMinSupply_165,
0,--bCutMantissa_166,
Null,--cInvPersonCode_167,
Null,--iInvTfId_168,
Null,--cEngineerFigNo_169,
-1,--bInTotalCost_170,
0,--iSupplyType_171,
0,--bConfigFree1_172,
0,--bConfigFree2_173,
0,--bConfigFree3_174,
0,--bConfigFree4_175,
0,--bConfigFree5_176,
0,--bConfigFree6_177,
0,--bConfigFree7_178,
0,--bConfigFree8_179,
0,--bConfigFree9_180,
0,--bConfigFree10_181,
-1,--iDTLevel_182,
Null,--cDTAQL_183,
0,--bPeriodDT_184,
Null,--cDTPeriod_185,
Null,--iBigMonth_186,
Null,--iBigDay_187,
Null,--iSmallMonth_188,
Null,--iSmallDay_189,
0,--bOutInvDT_190,
0,--bBackInvDT_191,
-1,--iEndDTStyle_192,
0,--bDTWarnInv_193,
0,--fBackTaxRate_194,
Null,--cCIQCode_195,
Null,--cWGroupCode_196,
Null,--cWUnit_197,
Null,--fGrossW_198,
Null,--cVGroupCode_199,
Null,--cVUnit_200,
Null,--fLength_201,
Null,--fWidth_202,
Null,--fHeight_203,
Null,--iDTUCounter_204,
Null,--iDTDCounter_205,
Null,--iBatchCounter_206,
@cUnitCode+'01',--cShopUnit_207,
Null,--cPurPersonCode_208,
0,--bImportMedicine_209,
0,--bFirstBusiMedicine_210,
0,--bForeExpland_211,
Null,--cInvPlanCode_212,
1,--fConvertRate_213,
Null,--dReplaceDate_214,
0,--bInvModel_215,
0,--bKCCutMantissa_216,
0,--bReceiptByDT_217,
0,--iImpTaxRate_218,
Null,--iExpTaxRate_219,
0,--bExpSale_220,
Null,--iDrawBatch_221,
0,--bCheckBSATP_222,
Null,--cInvProjectCode_223,
-1,--iTestRule_224,
Null,--cRuleCode_225,
0,--bCheckFree1_226,
0,--bCheckFree2_227,
0,--bCheckFree3_228,
0,--bCheckFree4_229,
0,--bCheckFree5_230,
0,--bCheckFree6_231,
0,--bCheckFree7_232,
0,--bCheckFree8_233,
0,--bCheckFree9_234,
0,--bCheckFree10_235,
0,--bBomMain_236,
0,--bBomSub_237,
0,--bProductBill_238,
0,--iCheckATP_239,
Null,--iInvATPId_240,
Null,--iPlanTfDay_241,
Null,--iOverlapDay_242,
0,--bPiece_243,
0,--bSrvItem_244,
0,--bSrvFittings_245,
Null,--fMaxSupply_246,
Null,--fMinSplit_247,
0,--bSpecialOrder_248,
0)--bTrackSaleBill_249
*/
--商品条码的建录
DECLARE
@tmpSize [nvarchar](500), @temSize [nvarchar](20),@tmpColor [nvarchar](500),@temColor [nvarchar](20)
--指定色指定码建档
IF @cInvCCode Like '10%' AND @cInvCCode<>'1086'
begin
INSERT INTO ColorSize (cInvCode, sColor, sSize) VALUES (@cInvCode,'Z_指定色','指定码')
end
--颜色尺码建档
IF CHARINDEX(',',@tmpSize)=0 AND CHARINDEX(',',@tmpColor)=0
begin
INSERT INTO ColorSize (cInvCode, sColor, sSize) VALUES (@cInvCode,Replace('''','',@cColor),Replace('''','',@cSize))
end
Else
begin
Select @tmpSize=@cSize
While CHARINDEX(',',@tmpSize)<>0
begin
Select @temSize = Left(@tmpSize,CHARINDEX(',',@tmpSize)-1)
Select @tmpSize = Right(@tmpSize,Len(@tmpSize)-CHARINDEX(',',@tmpSize))
Select @tmpColor=@cColor
While CHARINDEX(',',@tmpColor)<>0
begin
Select @temColor = Left(@tmpColor,CHARINDEX(',',@tmpColor)-1)
Select @tmpColor = CASE WHEN Len(@tmpColor)>CHARINDEX(',',@tmpColor) THEN Right(@tmpColor,Len(@tmpColor)-CHARINDEX(',',@tmpColor)) ELSE @tmpColor END
Print @cInvCode+@temColor+@temSize
INSERT INTO ColorSize (cInvCode, sColor, sSize)
VALUES (@cInvCode,@temColor,@temSize)
end
Print @cInvCode+@tmpColor+@temSize
INSERT INTO ColorSize (cInvCode, sColor, sSize)
VALUES (@cInvCode,@tmpColor,@temSize)
end
Print @cInvCode+@temColor+@temSize
INSERT INTO ColorSize (cInvCode, sColor, sSize)
VALUES (@cInvCode,@temColor,@temSize)
begin
Select @temSize = @tmpSize
Select @tmpColor=@cColor
While CHARINDEX(',',@tmpColor)<>0
begin
Select @temColor = Left(@tmpColor,CHARINDEX(',',@tmpColor)-1)
Select @tmpColor = CASE WHEN Len(@tmpColor)>CHARINDEX(',',@tmpColor) THEN Right(@tmpColor,Len(@tmpColor)-CHARINDEX(',',@tmpColor)) ELSE @tmpColor END
Print @cInvCode+@temColor+@temSize
INSERT INTO ColorSize (cInvCode, sColor, sSize)
VALUES (@cInvCode,@temColor,@temSize)
end
Print @cInvCode+@tmpColor+@temSize
INSERT INTO ColorSize (cInvCode, sColor, sSize)
VALUES (@cInvCode,@tmpColor,@temSize)
end
end
Select @tmpColor=@cInvStd+' '+@cSize+' '+@cColor+' '+@iInvSCost
--新款铺货计划建档
IF @iPlanCust<>'0'
begin
ExeCute _PM_P_Plan_Insert @cInvCode,'1',@Person,@tmpColor,@iPlanCust
end
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -