资源描述：
《软件由直营店切换成加盟店解决方案(龚建情、廖诚)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、国泽堂直营店切换成加盟店解决方案前景1、部分门店在软件里走的直营模式，走配送退仓单！现在软件里又走了配送单，现由于想对直营店各门店配送价进价加价或低价处理。技术分析1、门店把所有的单据都处理完（门店验收确认单、配送单、退仓单、店间调拨单等）2、单据处理完毕后，得把DIS,DIR修改成ADD,ADR------第一步、业务机构编码，配送类型修改为（加价配送）；机构类型修改为（本区域加盟店）总部updatec_org_busisetorgtype='30',sendtype='2',whlgroup='001'wherebusno<>'0001'------第二步、配送单屏蔽触发器处理（总
2、部与门店都得处理）,更新门店验收确认单回写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='ADD'then'DIS'whenbillcode='ADR'then'DIR'elsebillcodeend,distype=casewhenbillcode='add'then'dis'whenbillcode='adr'th
3、en'dir'elsebillcodeenddroptable#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_C3、关于之前产生的ACC批次处理的处理，不再产生新批次，直接修改u_store
4、_i表里（总部）------第三步、修改批准里srcbatchno、srcidnoupdateu_store_isetsrcbatchno=batchno,srcidno=idno4、第四步------------登记门店往来账u_busno_account（总部）-----门店财务往来登记存储过程ifOBJECT_ID('p_busno_account')isnotnulldropprocp_busno_accountgo------------登记门店往来账u_busno_accountcreateprocp_busno_accountasselectsrcbusno=casewh
5、ena.billcodein('ADD','DIS')THENa.srcbusnoelsea.objbusnoend,direct=casewhena.billcodein('ADD','DIS')THEN1else-1end,objbusno=casewhena.billcodein('ADD','DIS')THENa.objbusnoelsea.srcbusnoend,a.billcode,billno=a.distno,b.wareid,batchno=casewhena.billcode='ADR'THENb.objbatchnoelseb.batchnoend,idno=ca
6、sewhena.billcode='ADR'THENb.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')='2'thenisnull(d.distprice,b.purprice)elsecasewhena.billcodein('ADD','ADR')THENb.
7、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.src
