public static string QueryCustomeMoney(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_CustomeMoneyOrder bcmo = bcmob.Query(" and csid='" + sid + "'"); bcmo.ostate = cbeb.GetOrderState(sid); r = js.Serialize(bcmo); } else { r = iv.badstr; } return(r); }
public static ArrayList QueryOrderList(string bdate, string city, string code, string curpage, string dname, string edate, string emcode, string pagesize, string tabcode) { ArrayList r = new ArrayList(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); int rcount = 0; int pcount = 0; if (code != "") { where.AppendFormat(" and scode like '%{0}%'", code); } if (city != "") { where.AppendFormat(" and city like '%{0}%'", city); } if (dname != "") { where.AppendFormat(" and dname like '%{0}%'", dname); } if (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", edate); } where.AppendFormat(" and bdcode='{0}'", iv.u.dcode.Substring(0, 8)); Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = bsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "id desc", ref rcount, ref pcount); if (lsr != null) { r.Add(pcount); foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString())); foreach (DataColumn column in lsr.Columns) { if (column.Caption == "zt") { al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); } else { al.Add(dr[column].ToString()); } } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static string ExportSaleOrder(string bdate, string city, string code, string customer, string dname, string edate, string emcode, string otype, string tabcode) { string r = ""; DataTable lsr = new DataTable(); ArrayList row = new ArrayList(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (customer != "") { where.AppendFormat(" and customer like '%{0}%'", customer); } if (code != "") { where.AppendFormat(" and scode like '%{0}%'", code); } if (city != "") { where.AppendFormat(" and e_city like '%{0}%'", city); } if (dname != "") { where.AppendFormat(" and dname like '%{0}%'", dname); } if (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", edate); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, svt.esqlcols, svt.sqlcondition, " order by id desc"); if (lsr != null) { foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { if (column.Caption == "zt") { al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); } else { if (column.Caption == "sid") { } else { al.Add(dr[column].ToString()); } } } row.Add(al); } } } r = beb.ExportHtm(otype, svt.ecols, row); } else { r = iv.badstr; } return(r); }
public JsonResult QueryFixOrderList(string bdate, string city, string code, string curpage, string customer, string edate, string emcode, string pagesize, string platform, string tabcode, string telephone) { JsonData d = new JsonData(); StringBuilder where = new StringBuilder(); DataTable lsr = new DataTable(); ArrayList r = new ArrayList(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); int rcount = 0; int pcount = 0; if (customer != "") { where.AppendFormat(" and customer like '%{0}%'", customer); } if (code != "") { where.AppendFormat(" and scode like '%{0}%'", code); } if (platform != "") { where.AppendFormat(" and dname like '%{0}%'", platform); } if (telephone != "") { where.AppendFormat(" and telephone like '%{0}%'", telephone); } if (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", edate); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = bfb.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "id desc", ref rcount, ref pcount); if (lsr != null) { r.Add(pcount); foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { if (column.Caption == "zt") { al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); } else { al.Add(dr[column].ToString()); } } al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString())); r.Add(al); } } } d.d = js.Serialize(r); } else { d.d = iv.badstr; } return(Json(d)); }
public static ArrayList QueryMzReceiptList(string bdate, string city, string code, string curpage, string customer, string dname, string edate, string emcode, string pagesize, string tabcode) { ArrayList r = new ArrayList(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); int rcount = 0; int pcount = 0; if (customer != "") { where.AppendFormat(" and customer like '%{0}%'", customer); } if (code != "") { where.AppendFormat(" and scode like '%{0}%'", code); } if (city != "") { where.AppendFormat(" and e_city like '%{0}%'", city); } if (dname != "") { where.AppendFormat(" and dname like '%{0}%'", dname); } //if (telephone != "") //{ // where.AppendFormat(" and telephone like '%{0}%'", telephone); //} if (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", edate); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = bsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "id desc", ref rcount, ref pcount); if (lsr != null) { r.Add(pcount); foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString())); foreach (DataColumn column in lsr.Columns) { switch (column.Caption) { case "ysmoney": al.Add(0); break; case "symoney": al.Add(bsob.Query(" and sid='" + dr[1].ToString() + "'").omoney - bprb.GetSkMoneyEx(" and sid='" + dr[1].ToString() + "'")); break; case "zt": al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); break; default: al.Add(dr[column].ToString()); break; } } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryOrderList(string emcode, string scode) { ArrayList r = new ArrayList(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); int rcount = 0; int pcount = 0; if (scode != "") { where.AppendFormat(" and scode like '%{0}%'", scode); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, "a", iv.u.rcode); if (svt == null) { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = asob.QueryList(1, 50, sfield, where.ToString(), "id desc", ref rcount, ref pcount); if (lsr != null) { r.Add(pcount); foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { if (column.Caption == "zt") { al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); } else { al.Add(dr[column].ToString()); } } al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString())); r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }