public static string QueryMzOrder(string sid) { string r = ""; B_QbqqSaleOrder bms = new B_QbqqSaleOrder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (sid == "") { Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); bms.id = 0; bms.city = sd.dpname; bms.citycode = sd.dpcode; bms.dcode = iv.u.dcode; bms.dname = iv.u.dname; bms.maker = iv.u.ename; } else { bms = bmsob.Query("and sid='" + sid + "'"); //bms.ztimg = bosb.QueryOrderStateImg(sid); } r = js.Serialize(bms); } else { r = iv.badstr; } return(r); }
public JsonResult InitAddr(string id, string dcode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_AddressList sal = new Sys_AddressList(); if (id != "") { sal = salb.Query(" and id=" + id + ""); } else { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sal.id = 0; sal.adcode = sd == null ? "" : sd.dcode; sal.adname = sd == null ? "" : sd.dname; } d.d = js.Serialize(sal); } else { d.d = iv.badstr; } return(Json(d)); }
public static string InitAddOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); B_AfterApplyOrder ao = new B_AfterApplyOrder(); if (iv.f) { #region//存在原单 if (sid != "") { ao = bsob.Query(" and sid='" + sid + "'"); } #endregion #region//不存在原单 if (sid == "") { Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); ao.id = 0; ao.dcode = iv.u.dcode; ao.dname = iv.u.dname; ao.city = sd.dpname; ao.citycode = sd.dpcode; ao.maker = iv.u.ename; } #endregion r = js.Serialize(ao); } else { r = iv.badstr; } return(r); }
public JsonResult InitAddr(string dcode, string sacode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_CityGetAddress sal = new Sys_CityGetAddress(); if (sacode != "") { sal = scgab.Query(" and sacode='" + sacode + "'"); } else { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sal.id = 0; sal.sacode = scgab.CreateCode().ToString().PadLeft(4, '0'); sal.dcode = sd == null ? "" : sd.dcode; sal.dname = sd == null ? "" : sd.dname; } d.d = js.Serialize(sal); } else { d.d = iv.badstr; } return(Json(d)); }
public JsonResult InitAccount(string dcode, string acode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sbk_Account sal = new Sbk_Account(); if (acode != "") { sal = sab.Query(" and acode='" + acode + "'"); } else { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sal.id = 0; sal.dcode = sd == null ? "" : sd.dcode; sal.dname = sd == null ? "" : sd.dname; sal.acode = sab.CreateCode().ToString().PadLeft(4, '0'); sal.aname = "A" + DateTime.Now.ToString("yyyyMMdd") + sal.acode; } d.d = js.Serialize(sal); } else { d.d = iv.badstr; } return(Json(d)); }
public JsonResult InitACapacity(string dcode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_ProduceAllCapacity sal = new Sys_ProduceAllCapacity(); sal = spacb.Query(" and dcode='" + dcode + "'"); if (sal != null) { d.d = js.Serialize(sal); } else { Sys_ProduceAllCapacity sal1 = new Sys_ProduceAllCapacity(); Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sal1.dcode = sd.dcode; sal1.dname = sd.dname; sal1.id = 0; d.d = js.Serialize(sal1); } } else { d.d = iv.badstr; } return(Json(d)); }
public JsonResult InitProduce(string dcode, string cccode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_ProductionCapacity sal = new Sys_ProductionCapacity(); if (cccode != "") { sal = spscb.Query(" and cccode='" + cccode + "'"); d.d = js.Serialize(sal); } else { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sal.cccode = spscb.CreateCode().ToString().PadLeft(4, '0'); sal.dcode = dcode; sal.dname = sd.dname; sal.id = 0; d.d = js.Serialize(sal); } } else { d.d = iv.badstr; } return(Json(d)); }
public static ArrayList QueryDayWorkSchedule(string dcode, string wdate) { ArrayList r = new ArrayList(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); if (sd != null) { List <B_WorkSchedule> lbw = bwsb.QueryList(" and dcode='" + sd.dcode + "' and curdate='" + wdate + "'"); if (lbw != null) { foreach (B_WorkSchedule b in lbw) { ArrayList al = new ArrayList(); al.Add(b.id); al.Add(b.title); al.Add(b.btime); al.Add(b.etime); al.Add(b.color); al.Add(b.classname); r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryList(string ptcode) { ArrayList r = new ArrayList(); Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); List <Sys_AgentFee> lsf = new List <Sys_AgentFee>(); Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); lsf = srb.QueryList(" and acode='" + ptcode + "'"); if (lsf != null) { foreach (Sys_AgentFee s in lsf) { ArrayList al = new ArrayList(); Sys_InventoryCategory sic = sicb.Query(" and iccode='" + s.icode + "'"); Sys_Depment dt = sdb.Query(" and dcode='" + s.acode + "'"); al.Add(s.id); al.Add(dt == null?"":dt.dname); al.Add(sic == null?"":sic.icname); al.Add(s.fmoney); al.Add(s.tfmoney); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryList(string dcode) { ArrayList r = new ArrayList(); Sys_EmployeeBll seb = new Sys_EmployeeBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); Sys_RoleBll srb = new Sys_RoleBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); List <Sys_Employee> ls = seb.QueryList(" and dcode='" + dcode + "' and estate='true'"); if (ls != null) { foreach (Sys_Employee s in ls) { Sys_Depment dep = sdb.Query(" and dcode='" + s.dcode + "'"); Sys_Role sr = srb.Query(" and rcode='" + s.rcode + "'"); ArrayList al = new ArrayList(); al.Add(s.eno); al.Add(s.ename); al.Add(dep == null?"":dep.dname); al.Add(sr == null ? "" :sr.rname); al.Add(s.estate == true ? "是" : "否"); al.Add(s.elogin == true?"是":"否"); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public static string CustDel(string dcode) { string r = ""; Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_Depment psd = sdb.Query(" and dcode='" + dcode + "'"); if (psd.dread) { r = "R"; } else { if (sdb.Delete(dcode)) { r = "S"; } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public static string QueryCustomerOrder(string sid) { string r = ""; Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_CustormOrder bco = new B_CustormOrder(); if (sid != "") { bco = bcob.Query(" and csid='" + sid + "'"); } else { Sys_Depment shop = sdb.Query(" and dcode='" + iv.u.dcode + "'"); if (shop != null) { bco.dname = shop.dname; bco.dcode = shop.dcode; bco.e_city = shop.dpname; bco.e_citycode = shop.dpcode; } bco.otype = "销售预定单"; } r = js.Serialize(bco); } else { r = iv.badstr; } return(r); }
public static string QueryYyApi(string dcode) { string r = ""; API_yyBll ayb = new API_yyBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { API_yy ay = new API_yy(); if (ayb.Exists(" and dcode='" + dcode + "'")) { ay = ayb.Query(" and dcode='" + dcode + "'"); } else { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); if (sd != null) { ay.dname = sd.dname; ay.dcode = sd.dcode; ay.yycode = ""; } } r = js.Serialize(ay); } else { r = iv.badstr; } return(r); }
public static string initCustomer() { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_Customer bc = new B_Customer(); Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); if (sd != null) { Sys_Depment ct = sdb.Query(" and dcode='" + sd.dpcode + "'"); if (ct != null) { bc.aprovince = ct.dpname; bc.acity = ct.dcity; } } r = js.Serialize(bc); } else { r = iv.badstr; } return(r); }
public static string SaveFactory(string bcode, string fcode, string fline, string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { int dn = 0; Sys_Depment sd = sdb.Query(" and dcode='" + fcode + "'"); B_OrderFacotory bf = new B_OrderFacotory(); B_YqAfterSaleOrder baso = bsob.Query(" and sid='" + sid + "'"); B_OrderFacotory bof = bofb.Query(" and sid='" + sid + "'"); List <Sys_ProduceCyc> lc = spcb.QueryCheckList(" and emcode='0006' and dcode='" + fcode + "'"); if (lc != null) { dn = lc[0].cnum; } bf.dname = sd != null ? sd.dname : ""; bf.dcode = fcode; bf.maker = iv.u.ename; bf.sid = sid; bf.overdate = DateTime.Now.AddDays(dn).ToString("yyyy-MM-dd"); bf.otype = baso == null ? "" : baso.otype; bf.cdate = DateTime.Now.ToString(); if (bof != null) { if (bofb.Update(bf)) { r = "S"; bppb.SetProduceProcess(sid, fline); BaseSet.WorkFlowManage.EventBtnDo.FireEventBtn(sid, bcode, "1", "分单"); //bcpb.OrderCgComputePrice(sid); } else { r = "F"; } } else { if (bofb.Add(bf) > 0) { r = "S"; bppb.SetProduceProcess(sid, fline); BaseSet.WorkFlowManage.EventBtnDo.FireEventBtn(sid, bcode, "1", "分单"); //bcpb.OrderCgComputePrice(sid); } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public static string SaveWorkSchedule(string dcode, string wdate, string wtype) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); if (sd != null) { int year = Convert.ToDateTime(wdate).Year; int month = Convert.ToDateTime(wdate).Month; B_WorkSchedule bws = new B_WorkSchedule(); bws.dcode = sd.dcode; bws.dname = sd.dname; bws.color = "green"; bws.cmonth = month; bws.cyear = year; bws.classname = ""; bws.cdate = DateTime.Now.ToString(); bws.curdate = wdate; if (wtype == "上午生产") { bws.title = "上午生产"; bws.btime = wdate + " 07:30:00"; bws.etime = wdate + " 11:30:00"; } if (wtype == "下午生产") { bws.title = "下午生产"; bws.btime = wdate + " 13:30:00"; bws.etime = wdate + " 17:30:00"; } if (wtype == "晚上生产") { bws.title = "晚上生产"; bws.btime = wdate + " 19:00:00"; bws.etime = wdate + " 23:00:00"; } bwsb.Delete(" and dcode='" + sd.dcode + "' and curdate='" + wdate + "' and title='" + wtype + "'"); if (bwsb.Add(bws) > 0) { r = "S"; } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public static string LoadSaleOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_YqSaleOrder bco = bsob.Query(" and sid='" + sid + "'"); if (bco != null) { B_CustormOrder bdj = bcob.Query(" and csid='" + bco.csid + "'"); r = js.Serialize(bco); } else { Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); B_SaleOrder kco = new B_SaleOrder(); if (sd != null) { if (sd.dattr == "cs") { Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + sd.dcode + "'"); kco.city = sd.dpname; kco.citycode = sd.dpcode; kco.dname = sd.dname; kco.dcode = sd.dcode; kco.stelephone = sdd != null ? sdd.dcontact : ""; } else if (sd.dattr == "dm") { Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + sd.dcode.Substring(0, sd.dcode.Length - 4) + "'"); kco.city = sd.dpname; kco.citycode = sd.dpcode; kco.dname = sd.dname; kco.dcode = sd.dcode; kco.stelephone = sdd != null ? sdd.dcontact : ""; } else { kco.city = ""; kco.citycode = ""; kco.dname = ""; kco.dcode = ""; } } kco.maker = iv.u.ename; r = js.Serialize(kco); } } else { r = iv.badstr; } return(r); }
public static string initOrder(string sid, string asid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); B_AfterReModifyOrder ao = new B_AfterReModifyOrder(); if (iv.f) { if (sid != "") { ao = basob.Query(" and sid='" + sid + "'"); r = js.Serialize(ao); } else { if (asid != "") { B_AfterFreeBackOrder bo = bsob.Query(" and sid='" + asid + "'"); ao.city = bo.city; ao.citycode = bo.citycode; ao.dcode = bo.dcode; ao.dname = bo.dname; ao.acity = bo.acity; ao.aprovince = bo.aprovince; ao.areason = bo.areason; ao.ascode = bo.scode; ao.asid = bo.sid; ao.osid = bo.osid; ao.otype = bo.otype; ao.customer = bo.customer; ao.telephone = bo.telephone; ao.remark = bo.remark; ao.maker = iv.u.ename; ao.oscode = bo.oscode; } else { Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); ao.id = 0; ao.dcode = iv.u.dcode; ao.dname = iv.u.dname; ao.city = sd.dpname; ao.citycode = sd.dpcode; ao.maker = iv.u.ename; } r = js.Serialize(ao); } } else { r = iv.badstr; } return(r); }
public static ArrayList InitWorkSchedule(string mnum) { ArrayList r = new ArrayList(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); int year = DateTime.Now.Year; int month = DateTime.Now.Month; Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); if (sd != null) { if (sd.dattr == "gc") { if (!bwsb.Exists(" and dcode='" + sd.dcode + "' and cyear=" + year + " and cmonth=" + month + "")) { bwsb.SaveList(sd.dname, sd.dcode, year, month); } } if (mnum != "") { month = Convert.ToInt32(mnum); if (mnum == "1") { year = year + 1; } } List <B_WorkSchedule> lbw = bwsb.QueryList(" and dcode='" + sd.dcode + "' and cyear=" + year + " and cmonth=" + month + ""); if (lbw != null) { foreach (B_WorkSchedule b in lbw) { ArrayList al = new ArrayList(); al.Add(b.id); al.Add(b.title); al.Add(b.btime); al.Add(b.etime); al.Add(b.color); al.Add(b.classname); r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static string InitCustomeAccount(string id, string ptype) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { A_CustomeAccount sd = new A_CustomeAccount(); if (id == "") { Sys_Depment sdm = sdb.Query(" and dcode='" + iv.u.dcode + "' and dattr='d'"); if (sdm != null) { Sys_Depment sc = sdb.Query(" and dcode='" + sdm.dcode.Substring(0, sdm.dcode.Length - 2) + "' and dattr='s'"); if (ptype == "g") { sd.pcate = "补款"; } if (ptype == "p") { sd.pcate = "退款"; } sd.citycode = sc.dcode; sd.cityname = sc.dname; sd.dcode = sdm.dcode; sd.dname = sdm.dname; sd.customer = ""; sd.telephone = ""; sd.address = ""; sd.pmoney = 0; sd.id = 0; } else { r = "PB"; } } else { sd = acab.Query(" and gsid='" + id + "'"); } r = js.Serialize(sd); } else { r = iv.badstr; } return(r); }
public JsonResult SavePeriod(string fcode, string gqcode, string gqid, string gqname, string gqnum) { JsonData d = new JsonData(); Sys_ProductionPeriod sb = new Sys_ProductionPeriod(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_Depment sd = sdb.Query("and dcode='" + fcode + "'"); if (sd != null) { sb.fcode = sd.dcode; sb.fname = sd.dname; } sb.gqname = gqname; sb.gqcode = gqcode; sb.gqnum = Convert.ToInt32(gqnum); sb.maker = iv.u.ename; sb.cdate = DateTime.Now.ToString(); if (gqid == "0") { if (sltb.Add(sb) > 0) { d.d = "S"; } else { d.d = "F"; } } else { if (sltb.Update(sb)) { d.d = "S"; } else { d.d = "F"; } } } else { d.d = iv.badstr; } return(Json(d)); }
public static string CustQueryDepmentByDepCode(string dcode) { string r = ""; VDepment vsd = new VDepment(); Sys_Depment sd = new Sys_Depment(); Sys_DepmentBll sdb = new Sys_DepmentBll(); Sys_DepmentDpt sdd = new Sys_DepmentDpt(); Sys_DepmentDptBll sddb = new Sys_DepmentDptBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { sd = sdb.Query(" and dcode='" + dcode + "'"); sdd = sddb.Query(" and dcode='" + dcode + "'"); if (sd != null) { vsd.dcode = sd.dcode; vsd.dname = sd.dname; vsd.dpname = sd.dpname; vsd.dpcode = sd.dpcode; vsd.id = sd.id; vsd.khcode = sd.khcode; vsd.dattr = sd.dattr; if (sdd != null) { vsd.dmanager = sdd.dmanager; vsd.dcontact = sdd.dcontact; } if (sd.dread) { r = "R"; } else { r = js.Serialize(vsd); } } else { r = iv.badstr; } } else { r = iv.badstr; } return(r); }
public static string SaveOrder(string sid, string ncity, string nprovince, string nad) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { string dc = iv.u.dcode; Sys_Depment sd = sdb.Query(" and dcode='" + dc + "'"); B_Customer bc = bcb.Query(" and sid='" + sid + "'"); if (bc != null) { B_Orders bs = new B_Orders(); bs.address = nad.Trim() == "" ? bs.address : nad; bs.community = ""; bs.cdate = DateTime.Now.ToString(); bs.city = bc.city; bs.citycode = bc.citycode; bs.csid = bc.sid; bs.customer = bc.customer; bs.dcode = bc.dcode; bs.dname = bc.dname; bs.telephone = bc.telephone; bs.sid = CommonBll.GetSid(); bs.acity = ncity; bs.aprovince = nprovince; bs.zcode = "Z" + DateTime.Now.ToString("yyyyMMddHHmmss"); if (bob.Add(bs) > 0) { r = "S"; } else { r = "F"; } } else { r = "F"; } } else { r = iv.badstr; } return(r); }
public static string QueryCompany(string dcode) { string r = ""; Sys_Depment sd = new Sys_Depment(); Sys_DepmentDpt sdd = new Sys_DepmentDpt(); Sys_DepmentBll sdb = new Sys_DepmentBll(); Sys_DepmentDptBll sddb = new Sys_DepmentDptBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { VDepment vd = new VDepment(); if (dcode == "") { vd.dcode = "0001" + sdb.CreateCode("0001").ToString().PadLeft(4, '0'); vd.id = 0; } else { sd = sdb.Query(" and dcode='" + dcode + "'"); sdd = sddb.Query(" and dcode='" + dcode + "'"); vd.id = sd.id; vd.dcode = sd.dcode; vd.dname = sd.dname; vd.dabc = sd.dabc; vd.dattr = sd.dattr; vd.daddress = sdd.daddress; vd.dcontact = sdd.dcontact; vd.dmanager = sdd.dmanager; vd.disused = sd.disused; vd.iadmin = sdd.iadmin == true ? "1" : "0"; vd.idepment = sdd.idepment; vd.logo = sdd.logo; vd.iproduction = sdd.iproduction == true ? "1" : "0"; } r = js.Serialize(vd); } else { r = iv.badstr; } return(r); }
public static ArrayList CustQueryList() { ArrayList r = new ArrayList(); Sys_EventMenuBll srb = new Sys_EventMenuBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); string where = ""; if (iv.u.rcode == "xtgl") { } else { where = " and dcode like '" + iv.u.dcode.Substring(0, 8) + "%'"; } List <Sys_ProduceCyc> ls = spcb.QueryList(where); if (ls != null) { foreach (Sys_ProduceCyc s in ls) { Sys_Depment d = sdb.Query(" and dcode='" + s.fcode + "'"); Sys_EventMenu em = srb.Query(" and emcode='" + s.emcode + "'"); ArrayList al = new ArrayList(); al.Add(s.ccode); al.Add(s.cname); al.Add(em == null ? "" : em.emname); al.Add(d == null ? "" : d.dname); al.Add(s.cnum); al.Add(s.otype); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public static string InitDepmentEx(string pdepcode, string cdcode) { string r = ""; Sys_Depment psd = new Sys_Depment(); Sys_Depment sd = new Sys_Depment(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (cdcode == "") { psd = sdb.Query(" and dcode='" + pdepcode + "'"); if (psd != null) { sd.dpname = psd.dname; sd.dpcode = psd.dcode; sd.dcode = pdepcode + sdb.CreateCode(psd.dcode).ToString().PadLeft(4, '0'); sd.id = 0; r = js.Serialize(sd); } else { sd.dpname = ""; sd.dpcode = ""; sd.dcode = sdb.CreateCode("").ToString().PadLeft(4, '0'); sd.id = 0; r = js.Serialize(sd); } } else { sd = sdb.Query(" and dcode='" + cdcode + "'"); r = js.Serialize(sd); } } else { r = iv.badstr; } return(r); }
public static string QueryLoginUser() { string r = ""; Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_Depment lay = sdb.Query(" and dcode='" + iv.u.dcode + "'"); if (lay != null) { r = js.Serialize(lay); } } else { r = iv.badstr; } return(r); }
public static string InitAfterOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); B_YqAfterSaleOrder ao = new B_YqAfterSaleOrder(); Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); if (iv.f) { ao = basob.Query(" and sid='" + sid + "'"); ao.cdate = CommonBll.GetBdate(ao.cdate); // ao.ztimg = bosb.QueryOrderStateImg(sid); r = js.Serialize(ao); } else { r = iv.badstr; } return(r); }
public static string InitFee(string ptcode, string pcode, string id) { string r = ""; Sys_AgentFee sr = new Sys_AgentFee(); Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_InventoryCategory ic = new Sys_InventoryCategory(); Sys_Depment dt = new Sys_Depment(); if (id == "0" || id == "") { ic = sicb.Query(" and iccode='" + pcode + "'"); dt = sdb.Query(" and dcode='" + ptcode + "'"); sr.acode = ptcode; sr.aname = dt.dname; sr.iname = ic.icname; sr.icode = pcode; sr.id = 0; r = js.Serialize(sr); } else { sr = srb.Query(" and id=" + id + ""); sr.iname = sicb.Query(" and iccode='" + sr.icode + "'").icname; sr.aname = sdb.Query(" and dcode='" + sr.acode + "'").dname; r = js.Serialize(sr); } } else { r = iv.badstr; } return(r); }
public static string SetOrderPrint(string sid, string bcode) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); if (sd != null) { if (sd.dattr == "gc") { cosb.UpState(sid, "iprint", 1); LionVERP.UIServer.BaseSet.WorkFlowManage.EventBtnDo.FireEventBtn(sid, bcode, "1", ""); } } } else { r = iv.badstr; } return(r); }