$PBExportHeader$f_init_cttbinfo_2.srf global type f_init_cttbinfo_2 from function_object end type forward prototypes global function integer f_init_cttbinfo_2 (datetime arg_ctdt, long arg_bg_int, long arg_ed_int, ref s_yfct s_ctmx[]) end prototypes global function integer f_init_cttbinfo_2 (datetime arg_ctdt, long arg_bg_int, long arg_ed_int, ref s_yfct s_ctmx[]);//s_ctmx[].etbname :表英文名 //s_ctmx[].ctbname :表中文名 //s_ctmx[].wherestr :截数串 //s_ctmx[].checkstr :检查串 //s_ctmx[].delstr :删除串 //s_ctmx[].fromstr : //s_ctmx[].linkstr :关联串 //s_ctmx[].delid:删除id //***删除工资月 Long ls_del_wagemth,ls_pdint Date ls_del_date DateTime ls_del_wagemth_date ls_pdint = Long(String(arg_ctdt,'yyyymmdd')) //**工资删除前月***************************** ls_del_date = Date(String(arg_ctdt,'yyyy-mm-dd')) IF Month(ls_del_date) = 1 THEN ls_del_wagemth = (Year(ls_del_date) - 1) * 100 + 12 ELSE ls_del_wagemth = Year(ls_del_date) * 100 + Month(ls_del_date) - 1 END IF ls_del_wagemth_date = DateTime(Date(Left(String(ls_del_wagemth),4)+'-'+Right(String(ls_del_wagemth),2)+'-01'),Time(0)) //**结存要后5天************************* DateTime ll_datetime Date ll_date ll_date = RelativeDate (Date(String(arg_ctdt,'yyyy-mm-dd')),5) ll_datetime = DateTime(ll_date,Time('23:59')) //************************************************************** //********************************************* //s_ctmx[51].etbname = 'u_orderworkgroup_time' //s_ctmx[51].ctbname = '工组调整时间单表' //s_ctmx[51].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[51].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[51].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[51].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[51].delid = "billid" //s_ctmx[51].fromstr = " from u_orderworkgroup_time" //s_ctmx[51].linkstr = "" s_ctmx[51].etbname = 'u_spt_price_changemx' s_ctmx[51].ctbname = '调价单表明细' s_ctmx[51].wherestr = " where u_spt_price_change.flag = 1 and u_spt_price_change.ctmint = 0 and u_spt_price_change.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[51].checkstr = " where u_spt_price_change.flag = 0 and u_spt_price_change.ctmint = 0 and u_spt_price_change.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[51].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[51].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[51].delid = "billid" s_ctmx[51].fromstr = " from u_spt_price_change,u_spt_price_changemx" s_ctmx[51].linkstr = " and u_spt_price_change.scid = u_spt_price_changemx.scid and u_spt_price_change.billid = u_spt_price_changemx.billid" s_ctmx[52].etbname = 'u_spt_price_change' s_ctmx[52].ctbname = '调价单表' s_ctmx[52].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[52].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[52].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[52].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[52].delid = "billid" s_ctmx[52].fromstr = " from u_spt_price_change" s_ctmx[52].linkstr = "" s_ctmx[53].etbname = 'u_spt_amerce' s_ctmx[53].ctbname = '罚款单表' s_ctmx[53].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[53].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[53].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[53].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[53].delid = "billid" s_ctmx[53].fromstr = " from u_spt_amerce" s_ctmx[53].linkstr = "" s_ctmx[54].etbname = 'u_order_wfjg_wasteMx' s_ctmx[54].ctbname = '损耗单明细表' s_ctmx[54].wherestr = " where u_order_wfjg_waste.flag = 1 and u_order_wfjg_waste.ctmint = 0 and u_order_wfjg_waste.wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[54].checkstr = " where u_order_wfjg_waste.flag = 0 and u_order_wfjg_waste.ctmint = 0 and u_order_wfjg_waste.wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[54].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[54].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[54].delid = "wasteid" s_ctmx[54].fromstr = " from u_order_wfjg_waste,u_order_wfjg_wasteMx" s_ctmx[54].linkstr = " and u_order_wfjg_waste.scid = u_order_wfjg_wasteMx.scid and u_order_wfjg_waste.wasteid = u_order_wfjg_wasteMx.wasteid" s_ctmx[55].etbname = 'u_order_wfjg_waste' s_ctmx[55].ctbname = '损耗单表' s_ctmx[55].wherestr = " where flag = 1 and ctmint = 0 and wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[55].checkstr = " where flag = 0 and ctmint = 0 and wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[55].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[55].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[55].delid = "wasteid" s_ctmx[55].fromstr = " from u_order_wfjg_waste" s_ctmx[55].linkstr = "" s_ctmx[56].etbname = 'u_updatecostmx' s_ctmx[56].ctbname = '仓库成本调整单明细' s_ctmx[56].wherestr = " where u_updatecost.flag = 1 and u_updatecost.ctmint = 0 and u_updatecost.moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[56].checkstr = " where u_updatecost.flag = 0 and u_updatecost.ctmint = 0 and u_updatecost.moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[56].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[56].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[56].delid = "wareid" s_ctmx[56].fromstr = " from u_updatecost,u_updatecostmx" s_ctmx[56].linkstr = " and u_updatecost.scid = u_updatecostmx.scid and u_updatecost.wareid = u_updatecostmx.wareid" s_ctmx[57].etbname = 'u_updatecost' s_ctmx[57].ctbname = '仓库成本调整单' s_ctmx[57].wherestr = " where flag = 1 and ctmint = 0 and moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[57].checkstr = " where flag = 0 and ctmint = 0 and moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[57].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[57].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[57].delid = "wareid" s_ctmx[57].fromstr = " from u_updatecost" s_ctmx[57].linkstr = "" //s_ctmx[58].etbname = 'u_saletaskmx_mtrlchange' //s_ctmx[58].ctbname = '销售订单换料单明细表' //s_ctmx[58].wherestr = " where (u_saletask.status = 3 or u_saletask.status = 5) and u_saletask.ctmint = 0 and u_saletask.taskdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[58].checkstr = " where (u_saletask.status <> 3 and u_saletask.status <> 5) and u_saletask.ctmint = 0 and u_saletask.taskdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[58].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[58].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[58].delid = "taskid" //s_ctmx[58].fromstr = " from u_saletaskmx_mtrlchange,u_saletask" //s_ctmx[58].linkstr = " and u_saletask.scid = u_saletaskmx_mtrlchange.scid and u_saletask.taskid = u_saletaskmx_mtrlchange.taskid" s_ctmx[59].etbname = 'u_mtrlware_transmx' s_ctmx[59].ctbname = '客户库存调整单明细表' s_ctmx[59].wherestr = " where u_mtrlware_trans.flag = 1 and u_mtrlware_trans.ctmint = 0 and u_mtrlware_trans.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[59].checkstr = " where u_mtrlware_trans.flag = 0 and u_mtrlware_trans.ctmint = 0 and u_mtrlware_trans.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[59].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[59].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[59].delid = "billid" s_ctmx[59].fromstr = " from u_mtrlware_trans,u_mtrlware_transmx" s_ctmx[59].linkstr = " and u_mtrlware_trans.scid = u_mtrlware_transmx.scid and u_mtrlware_trans.billid = u_mtrlware_transmx.billid" s_ctmx[60].etbname = 'u_mtrlware_trans' s_ctmx[60].ctbname = '客户库存调整单表' s_ctmx[60].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[60].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[60].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[60].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[60].delid = "billid" s_ctmx[60].fromstr = " from u_mtrlware_trans" s_ctmx[60].linkstr = "" s_ctmx[61].etbname = 'u_warepdb' s_ctmx[61].ctbname = '盘点表' s_ctmx[61].wherestr = " where ctmint = 0 and pdbdate <> '' and pdbdate<='" + String(ls_pdint)+"'" s_ctmx[61].checkstr = " where ctmint = 0 and pdbdate <> '' and pdbdate<='" + String(ls_pdint)+"'" s_ctmx[61].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[61].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[61].delid = "mtrlid" s_ctmx[61].fromstr = " from u_warepdb" s_ctmx[61].linkstr = "" s_ctmx[62].etbname = 'u_quotemx' s_ctmx[62].ctbname = '报价单明细表' s_ctmx[62].wherestr = " where u_quote.flag = 1 and u_quote.ctmint = 0 and u_quote.quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[62].checkstr = " where u_quote.flag = 0 and u_quote.ctmint = 0 and u_quote.quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[62].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[62].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[62].delid = "quoteid" s_ctmx[62].fromstr = " from u_quote,u_quotemx" s_ctmx[62].linkstr = " and u_quote.scid = u_quotemx.scid and u_quote.quoteid = u_quotemx.quoteid" s_ctmx[63].etbname = 'u_quote' s_ctmx[63].ctbname = '报价单表' s_ctmx[63].wherestr = " where flag = 1 and ctmint = 0 and quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[63].checkstr = " where flag = 0 and ctmint = 0 and quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[63].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[64].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[63].delid = "quoteid" s_ctmx[63].fromstr = " from u_quote" s_ctmx[63].linkstr = "" //s_ctmx[64].etbname = 'u_scwg_taskwork' //s_ctmx[64].ctbname = '工作组计件单' //s_ctmx[64].wherestr = " where Auditingflag = 1 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'" //s_ctmx[64].checkstr = " where Auditingflag = 0 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'" //s_ctmx[64].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[64].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[64].delid = "ctmint" //s_ctmx[64].fromstr = " from u_scwg_taskwork" //s_ctmx[64].linkstr = "" // //s_ctmx[65].etbname = 'u_scwg_taskwork_money' //s_ctmx[65].ctbname = '工作组计件单工资' //s_ctmx[65].wherestr = " where Auditingflag = 1 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'" //s_ctmx[65].checkstr = " where Auditingflag = 0 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'" //s_ctmx[65].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[65].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[65].delid = "ctmint" //s_ctmx[65].fromstr = " from u_scwg_taskwork_money" //s_ctmx[65].linkstr = "" //s_ctmx[66].etbname = 'u_spt_wfjgMx' //s_ctmx[66].ctbname = '加工费分摊单明细表' //s_ctmx[66].wherestr = " where u_spt_wfjg.flag = 1 and u_spt_wfjg.ctmint = 0 and u_spt_wfjg.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[66].checkstr = " where u_spt_wfjg.flag = 0 and u_spt_wfjg.ctmint = 0 and u_spt_wfjg.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[66].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[66].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[66].delid = "billid" //s_ctmx[66].fromstr = " from u_spt_wfjg,u_spt_wfjgMx" //s_ctmx[66].linkstr = " and u_spt_wfjg.scid = u_spt_wfjgMx.scid and u_spt_wfjg.billid = u_spt_wfjgMx.billid" // //s_ctmx[67].etbname = 'u_spt_wfjg' //s_ctmx[67].ctbname = '加工费分摊单表' //s_ctmx[67].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[67].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[67].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[67].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[67].delid = "billid" //s_ctmx[67].fromstr = " from u_spt_wfjg" //s_ctmx[67].linkstr = "" s_ctmx[68].etbname = 'u_invoicemx' s_ctmx[68].ctbname = '发票明细表' s_ctmx[68].wherestr = " where u_invoice.flag = 1 and u_invoice.ctmint = 0 and u_invoice.invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[68].checkstr = " where u_invoice.flag = 0 and u_invoice.ctmint = 0 and u_invoice.invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[68].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[68].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[68].delid = "invoiceid" s_ctmx[68].fromstr = " from u_invoice,u_invoicemx" s_ctmx[68].linkstr = " and u_invoice.scid = u_invoicemx.scid and u_invoice.invoiceid = u_invoicemx.invoiceid" s_ctmx[69].etbname = 'u_invoice' s_ctmx[69].ctbname = '发票表' s_ctmx[69].wherestr = " where flag = 1 and ctmint = 0 and invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[69].checkstr = " where flag = 0 and ctmint = 0 and invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[69].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[69].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[69].delid = "invoiceid" s_ctmx[69].fromstr = " from u_invoice" s_ctmx[69].linkstr = "" s_ctmx[70].etbname = 'u_givebackmx' s_ctmx[70].ctbname = '返利单明细表' s_ctmx[70].wherestr = " where u_giveback.flag = 1 and u_giveback.ctmint = 0 and u_giveback.givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[70].checkstr = " where u_giveback.flag = 0 and u_giveback.ctmint = 0 and u_giveback.givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[70].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[70].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[70].delid = "givebackid" s_ctmx[70].fromstr = " from u_giveback,u_givebackmx" s_ctmx[70].linkstr = " and u_giveback.scid = u_givebackmx.scid and u_giveback.givebackid = u_givebackmx.givebackid" s_ctmx[71].etbname = 'u_giveback' s_ctmx[71].ctbname = '返利单表' s_ctmx[71].wherestr = " where flag = 1 and ctmint = 0 and givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[71].checkstr = " where flag = 0 and ctmint = 0 and givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[71].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[71].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[71].delid = "givebackid" s_ctmx[71].fromstr = " from u_giveback" s_ctmx[71].linkstr = "" //s_ctmx[72].etbname = 'u_reissuemx' //s_ctmx[72].ctbname = '补件单明细表' //s_ctmx[72].wherestr = " where u_reissue.flag = 1 and u_reissue.ctmint = 0 and u_reissue.reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[72].checkstr = " where u_reissue.flag = 0 and u_reissue.ctmint = 0 and u_reissue.reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[72].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[72].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[72].delid = "reissueid" //s_ctmx[72].fromstr = " from u_reissue,u_reissuemx" //s_ctmx[72].linkstr = " and u_reissue.scid = u_reissuemx.scid and u_reissue.reissueid = u_reissuemx.reissueid" // //s_ctmx[73].etbname = 'u_reissue' //s_ctmx[73].ctbname = '补件单表' //s_ctmx[73].wherestr = " where flag = 1 and ctmint = 0 and reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[73].checkstr = " where flag = 0 and ctmint = 0 and reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" //s_ctmx[73].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[73].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " //s_ctmx[73].delid = "reissueid" //s_ctmx[73].fromstr = " from u_reissue" //s_ctmx[73].linkstr = "" s_ctmx[74].etbname = 'u_buybillmx' s_ctmx[74].ctbname = '支出单明细表' s_ctmx[74].wherestr = " where u_buybill.ctmint = 0 and u_buybill.paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[74].checkstr = " where u_buybill.ctmint = 0 and u_buybill.paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[74].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[74].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[74].delid = "buybillid" s_ctmx[74].fromstr = " from u_buybill,u_buybillmx" s_ctmx[74].linkstr = " and u_buybill.buybillid = u_buybillmx.buybillid" s_ctmx[75].etbname = 'u_buybill' s_ctmx[75].ctbname = '支出单表' s_ctmx[75].wherestr = " where ctmint = 0 and paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[75].checkstr = " where ctmint = 0 and paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[75].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[75].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[75].delid = "buybillid" s_ctmx[75].fromstr = " from u_buybill" s_ctmx[75].linkstr = "" s_ctmx[76].etbname = 'u_salebillmx' s_ctmx[76].ctbname = '支出单明细表' s_ctmx[76].wherestr = " where u_salebill.ctmint = 0 and u_salebill.takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[76].checkstr = " where u_salebill.ctmint = 0 and u_salebill.takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[76].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[76].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[76].delid = "salebillid" s_ctmx[76].fromstr = " from u_salebill,u_salebillmx" s_ctmx[76].linkstr = " and u_salebill.salebillid = u_salebillmx.salebillid" s_ctmx[77].etbname = 'u_salebill' s_ctmx[77].ctbname = '支出单表' s_ctmx[77].wherestr = " where ctmint = 0 and takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[77].checkstr = " where ctmint = 0 and takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[77].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[77].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[77].delid = "salebillid" s_ctmx[77].fromstr = " from u_salebill" s_ctmx[77].linkstr = "" s_ctmx[78].etbname = 'u_inwaremx' s_ctmx[78].ctbname = '进仓单明细表{采购,加工}' IF sys_option_use_mstpay = 1 THEN s_ctmx[78].wherestr = " where ( billtype = 1 or billtype = 4 ) and u_inware.ctmint = 0 and u_inware.balcflag = 1 and u_inware.flag=1 and u_inware.secflag = 1 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[78].checkstr = " where ( billtype = 1 or billtype = 4 ) and (u_inware.balcflag = 0 or u_inware.flag = 0 or u_inware.secflag = 0 ) and u_inware.ctmint = 0 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" ELSE s_ctmx[78].wherestr = " where ( billtype = 1 or billtype = 4 ) and u_inware.ctmint = 0 and u_inware.balcflag = 1 and u_inware.flag=1 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[78].checkstr = " where ( billtype = 1 or billtype = 4 ) and (u_inware.balcflag = 0 or u_inware.flag = 0 ) and u_inware.ctmint = 0 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" END IF s_ctmx[78].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[78].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[78].delid = "inwareid" s_ctmx[78].fromstr = " from u_inwaremx,u_inware" s_ctmx[78].linkstr = " and u_inwaremx.scid = u_inware.scid and u_inwaremx.inwareid = u_inware.inwareid" s_ctmx[79].etbname = 'u_inware' s_ctmx[79].ctbname = '进仓单表{采购,加工}' IF sys_option_use_mstpay = 1 THEN s_ctmx[79].wherestr = " where ( billtype = 1 or billtype = 4 ) and ctmint = 0 and balcflag = 1 and flag=1 and secflag = 1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[79].checkstr = " where ( billtype = 1 or billtype = 4 ) and (balcflag = 0 or flag = 0 or secflag = 0) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" ELSE s_ctmx[79].wherestr = " where ( billtype = 1 or billtype = 4 ) and ctmint = 0 and balcflag = 1 and flag=1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[79].checkstr = " where ( billtype = 1 or billtype = 4 ) and (balcflag = 0 or flag = 0) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" END IF s_ctmx[79].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[79].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[79].delid = "inwareid" s_ctmx[79].fromstr = " from u_inware" s_ctmx[79].linkstr = "" s_ctmx[80].etbname = 'u_outwaremx' s_ctmx[80].ctbname = '出仓单明细表{领料}' s_ctmx[80].wherestr = " where u_outware.billtype =3 and u_outware.ctmint = 0 and u_outware.balcflag = 1 and u_outware.flag = 1 and u_outware.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[80].checkstr = " where u_outware.billtype =3 and (u_outware.balcflag = 0 or u_outware.flag = 0) and u_outware.ctmint = 0 and u_outware.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[80].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[80].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[80].delid = "outwareid" s_ctmx[80].fromstr = " from u_outwaremx,u_outware" s_ctmx[80].linkstr = " and u_outwaremx.scid = u_outware.scid and u_outwaremx.outwareid = u_outware.outwareid" s_ctmx[81].etbname = 'u_outware' s_ctmx[81].ctbname = '出仓单表{领料}' s_ctmx[81].wherestr = " where billtype =3 and ctmint = 0 and balcflag = 1 and flag = 1 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[81].checkstr = " where billtype =3 and (balcflag = 0 or flag = 0 ) and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[81].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[81].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[81].delid = "outwareid" s_ctmx[81].fromstr = " from u_outware" s_ctmx[81].linkstr = "" s_ctmx[82].etbname = 'ow_wfjgmx_out' s_ctmx[82].ctbname = '外协出仓单明细表' s_ctmx[82].wherestr = " where ow_wfjg_out.ctmint = 0 and ow_wfjg_out.balcflag = 1 and ow_wfjg_out.flag = 1 and ow_wfjg_out.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[82].checkstr = " where (ow_wfjg_out.flag = 0 or ow_wfjg_out.balcflag = 0 ) and ow_wfjg_out.ctmint = 0 and ow_wfjg_out.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[82].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[82].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[82].delid = "outwareid" s_ctmx[82].fromstr = " from ow_wfjgmx_out,ow_wfjg_out" s_ctmx[82].linkstr = " and ow_wfjgmx_out.scid = ow_wfjg_out.scid and ow_wfjgmx_out.outwareid = ow_wfjg_out.outwareid" s_ctmx[83].etbname = 'ow_wfjg_out' s_ctmx[83].ctbname = '外协出仓单表' s_ctmx[83].wherestr = " where ctmint = 0 and balcflag = 1 and flag = 1 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[83].checkstr = " where (flag = 0 or balcflag=0 ) and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[83].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[83].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[83].delid = "outwareid" s_ctmx[83].fromstr = " from ow_wfjg_out" s_ctmx[83].linkstr = "" s_ctmx[84].etbname = 'ow_wfjgmx_in_aft' s_ctmx[84].ctbname = '外协进仓单(收货)明细表' IF sys_option_use_mstpay = 1 THEN s_ctmx[84].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.secflag = 1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[84].checkstr = " where ( ow_wfjg_in.flag = 0 or ow_wfjg_in.secflag = 0 or ow_wfjg_in.balcflag= 0 ) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" ELSE s_ctmx[84].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[84].checkstr = " where (ow_wfjg_in.flag = 0 or ow_wfjg_in.balcflag= 0) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" END IF s_ctmx[84].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[84].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[84].delid = "inwareid" s_ctmx[84].fromstr = " from ow_wfjgmx_in_aft,ow_wfjg_in" s_ctmx[84].linkstr = " and ow_wfjgmx_in_aft.scid = ow_wfjg_in.scid and ow_wfjgmx_in_aft.inwareid = ow_wfjg_in.inwareid" s_ctmx[85].etbname = 'ow_wfjgmx_in_bef' s_ctmx[85].ctbname = '外协进仓单(库存)明细表' IF sys_option_use_mstpay = 1 THEN s_ctmx[85].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.secflag = 1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[85].checkstr = " where ( ow_wfjg_in.flag = 0 or ow_wfjg_in.balcflag=1 or ow_wfjg_in.secflag = 0 ) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" ELSE s_ctmx[85].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[85].checkstr = " where ( ow_wfjg_in.flag = 0 or ow_wfjg_in.balcflag=1 ) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" END IF s_ctmx[85].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[85].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[85].delid = "inwareid" s_ctmx[85].fromstr = " from ow_wfjgmx_in_bef,ow_wfjg_in" s_ctmx[85].linkstr = " and ow_wfjgmx_in_bef.scid = ow_wfjg_in.scid and ow_wfjgmx_in_bef.inwareid = ow_wfjg_in.inwareid" s_ctmx[86].etbname = 'ow_wfjg_in' s_ctmx[86].ctbname = '外协进仓单表' IF sys_option_use_mstpay = 1 THEN s_ctmx[86].wherestr = " where ctmint = 0 and balcflag = 1 and flag=1 and secflag = 1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[86].checkstr = " where ( flag = 0 or secflag = 0 or balcflag=0 ) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" ELSE s_ctmx[86].wherestr = " where ctmint = 0 and balcflag = 1 and flag=1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[86].checkstr = " where ( flag = 0 or balcflag=0 ) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" END IF s_ctmx[86].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[86].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[86].delid = "inwareid" s_ctmx[86].fromstr = " from ow_wfjg_in" s_ctmx[86].linkstr = "" s_ctmx[87].etbname = 'ow_wfjgbalc' s_ctmx[87].ctbname = '外协结存表' s_ctmx[87].wherestr = " where balcdate<='" + String(ll_datetime,'yyyy-mm-dd hh:mm') + "'" s_ctmx[87].checkstr = " where balcdate<='" + String(ll_datetime,'yyyy-mm-dd hh:mm') + "'" s_ctmx[87].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[87].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[87].delid = "mtrlid" s_ctmx[87].fromstr = " from ow_wfjgbalc" s_ctmx[87].linkstr = "" s_ctmx[88].etbname = 'u_warepdb_billmx' s_ctmx[88].ctbname = '盘点单明细表' s_ctmx[88].wherestr = " where u_warepdb_bill.flag = 1 and u_warepdb_bill.ctmint = 0 and u_warepdb_bill.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[88].checkstr = " where u_warepdb_bill.flag = 0 and u_warepdb_bill.ctmint = 0 and u_warepdb_bill.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[88].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[88].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[88].delid = "billid" s_ctmx[88].fromstr = " from u_warepdb_bill,u_warepdb_billmx" s_ctmx[88].linkstr = " and u_warepdb_bill.scid = u_warepdb_billmx.scid and u_warepdb_bill.billid = u_warepdb_billmx.billid" s_ctmx[89].etbname = 'u_warepdb_bill' s_ctmx[89].ctbname = '盘点单表' s_ctmx[89].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[89].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[89].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[89].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[89].delid = "billid" s_ctmx[89].fromstr = " from u_warepdb_bill" s_ctmx[89].linkstr = "" s_ctmx[90].etbname = 'u_income_expenses' s_ctmx[90].ctbname = '其他收入支出单' s_ctmx[90].wherestr = " where flag = 1 and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[90].checkstr = " where flag = 0 and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'" s_ctmx[90].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[90].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" " s_ctmx[90].delid = "billid" s_ctmx[90].fromstr = " from u_income_expenses" s_ctmx[90].linkstr = "" RETURN 1 end function