软件由直营店切换成加盟店解决方案(龚建情、廖诚).docx

国泽堂直营店切换成加盟店解决方案前景部分门店在软件里走的直营模式，走配送退仓单！现在软件里又走了配送单，现由于想对直营店各门店配送价进价加价或低价处理。技术分析门店把所有的单据都处理完（门店验收确认单、配送单、退仓单、店间调拨单等）单据处理完毕后，得把DIS,DIR修改成ADD,ADR------第一步、业务机构编码，配送类型修改为（加价配送）；机构类型修改为（本区域加盟店）总部updatec_org_busisetorgtype=30,sendtype=2,whlgroup=001wherebusno0001------第二步、配送单屏蔽触发器处理（总部与门店都得处理）,更新门店验收确认单回写u_dist_c验收数量（更新u_dist_c里md_wareqty）ifobject_id(tempdb..#disable_u_dist_m)isnullcreatetable#disable_u_dist_m(idint)updateu_dist_msetbillcode=casewhenbillcode=ADDthenDISwhenbillcode=ADRthenDIRelsebillcodeend,distype=casewhenbillcode=addthendiswhenbillcode=adrthendirelsebillcodeenddroptable#disable_u_dist_mifobject_id(tempdb..#disable_u_dist_C)isnullcreatetable#disable_u_dist_C(idint)updateu_dist_Csetaddpurprice=purprice,avgpurprice=purprice,md_wareqty=wareqty----门店验收确认单回写u_dist_c验收数量droptable#disable_u_dist_C关于之前产生的ACC批次处理的处理，不再产生新批次，直接修改u_store_i表里（总部）------第三步、修改批准里srcbatchno、srcidnoupdateu_store_isetsrcbatchno=batchno,srcidno=idno第四步------------登记门店往来账u_busno_account（总部）-----门店财务往来登记存储过程ifOBJECT_ID(p_busno_account)isnotnulldropprocp_busno_accountgo------------登记门店往来账u_busno_accountcreateprocp_busno_accountasselectsrcbusno=casewhena.billcodein(ADD,DIS)THENa.srcbusnoelsea.objbusnoend,direct=casewhena.billcodein(ADD,DIS)THEN 1 else-1 end,objbusno=casewhena.billcodein(ADD,DIS)THENa.objbusnoelsea.srcbusnoend,a.billcode,billno=a.distno,b.wareid,batchno=casewhena.billcode=ADRTHENb.objbatchnoelseb.batchnoend,idno=casewhena.billcode=ADRTHENb.objidnoelseb.idnoend,stallno=casewhena.billcodein(ADD,DIS)THENb.srcstallnoelseb.objstallnoend,b.wareqty,a.execdate,a.paytype,payedqty= 0,status= 0,purprice=casewhendbo.f_sys_ini(2693)=2thenisnull(d.distprice,b.purprice)elsecasewhena.billcodein(ADD,ADR)THENb.addpurpriceelseb.purpriceendend,b.purtax,notes=nullinto#afromu_dist_ma,u_dist_cb,c_org_busic,u_store_idwherea.distno=b.distnoanda.billcodein(ADD,ADR,DIS,DIR)andcasewhena.billcodein(ADD,DIS)THENa.objbusnoelsea.srcbusnoend=c.busnoandc.orgtype=30andb.wareid=d.wareidandb.batchno=d.batchnoandb