public static ArrayList QuerySapOrderList(string bdate, string code, string curpage, string customer, 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 (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", Convert.ToDateTime(edate).AddDays(1).ToString("yyyy-MM-dd")); } 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 = bsb.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) { al.Add(dr[column].ToString()); } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QuerySapPackage(string bcode, string code, string curpage, 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 (bcode != "") { where.AppendFormat(" and id like '%{0}%'", bcode.Replace("B", "")); } if (code != "") { where.AppendFormat(" and scode like '%{0}%'", code); } 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 = bpisb.QueryViewList(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 == "id") { al.Add("B" + dr[column].ToString().PadLeft(8, '0')); } else { al.Add(dr[column].ToString()); } } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryNextProcess(string id, string emcode, 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; Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { CB_ProductionProcess copp = cbppb.Query(" and id=" + id + ""); if (copp != null) { where.Append(" and sid='" + copp.sid + "'"); } where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = cbppb.QueryList(1, 15, sfield, where.ToString(), " scode desc", ref rcount, ref pcount); if (lsr != null) { 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 == "gstate") { int i = Convert.ToInt32(dr[column].ToString()); al.Add(bppb.ProduceProcessState(i)); } else { al.Add(dr[column].ToString()); } } 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); }
public static ArrayList QueryPackageList(string emcode, string sid, 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); where.Append(" and sid='" + sid + "' "); 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 = bpb.QueryVList(sfield, where.ToString(), " order by bnum asc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); al.Add(i); foreach (DataColumn column in lsr.Columns) { if (column.Caption == "bzid") { al.Add("B" + dr[column].ToString().PadLeft(8, '0')); } else { al.Add(dr[column].ToString()); } } r.Add(al); i++; } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryListOrder(string curpage, string emcode, string pagesize, string sstr) { ArrayList r = new ArrayList(); SessionUserValidate iv = SysValidateBll.ValidateSession(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); if (iv.f) { r.Add(iv.badstr); int rcount = 0; int pcount = 0; if (sstr != "") { where.AppendFormat(" and (customer like '%{0}%' or scode like '%{0}%' or city like '%{0}%' or dname like '%{0}%' or telephone like '%{0}%')", sstr); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, "a", iv.u.rcode); if (svt == null || sstr == "") { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = ctrb.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "cdate 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) { al.Add(dr[column].ToString()); } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QuerySapOrderList(string curpage, 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; 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) { al.Add(dr[column].ToString()); } r.Add(al); } } } } else { r.Add(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 QuerySetlmentList(string bdate, string code, string curpage, string edate, string emcode, string pagesize, string platform, string tabcode, string zt) { 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 (platform != "") { where.AppendFormat(" and dname like '%{0}%'", platform); } if (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", edate); } if (zt == "2") { where.AppendFormat(" and isetlment ={0}", zt); } 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(); foreach (DataColumn column in lsr.Columns) { switch (column.Caption) { case "ysmoney": al.Add(0); break; default: al.Add(dr[column].ToString()); break; } } al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].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 static ArrayList QuerySubmitTj(string bdate, string dcode, string edate, string emcode, 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); Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { string b = ""; string e = ""; if (bdate == null || bdate == "") { b = CommonBll.GetBdate2(); } else { b = CommonBll.GetBdate(bdate); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); } else { e = CommonBll.GetEdate(edate); } if (dcode == "") { } else { where.AppendFormat(" and dcode = '{0}'", dcode); } string sqlw = svt.sqlcondition.Replace("[BDATE]", b).Replace("[EDATE]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, sfield, where.ToString(), " order by substring(scode,len(scode)-4,5) asc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { string sid = dr[0].ToString(); string[] wjarr = bgpb.Sjtj(sid, "0401"); string[] gdarr = bgpb.Sjtj(sid, "0402"); ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { switch (column.Caption) { case "xh": al.Add(i); break; case "sjname": al.Add(wjarr[0]); break; case "sjnum": al.Add(wjarr[1]); break; case "gdname": al.Add(gdarr[0]); break; case "gdnum": al.Add(gdarr[1]); break; default: al.Add(dr[column].ToString()); break; } } i++; r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryCheckRedoTj(string bdate, string edate, string emcode, 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); Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { string b = ""; string e = ""; string dn = ""; if (bdate == null || bdate == "") { b = CommonBll.GetBdate2(); } else { b = CommonBll.GetBdate(bdate); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); } else { e = CommonBll.GetEdate(edate); } string sqlw = svt.sqlcondition.Replace("[DNAME]", dn).Replace("[bdate]", b).Replace("[edate]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, sfield, where.ToString(), " order by sdate desc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { string sid = dr[0].ToString(); switch (column.Caption) { case "xh": al.Add(i); break; case "plist": string pl = bagpb.QueryStrList(sid); al.Add(pl); break; default: al.Add(dr[column].ToString()); break; } } i++; r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryOrderTj(string bdate, string dname, string edate, string emcode, 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); Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { string b = ""; string e = ""; string dn = ""; if (bdate == null || bdate == "") { b = CommonBll.GetBdate2(); } else { b = CommonBll.GetBdate(bdate); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); } else { e = CommonBll.GetEdate(edate); } if (dname == "") { } else { dn = " and dname like '" + dname + "%'"; } string sqlw = svt.sqlcondition.Replace("[DNAME]", dn).Replace("[BDATE]", b).Replace("[EDATE]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, sfield, where.ToString(), " order by scode desc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { string sid = dr[0].ToString(); switch (column.Caption) { case "xh": al.Add(i); break; case "money": al.Add(0); break; case "pmoney": al.Add(0); break; case "mss": al.Add(bgb.TjProductionMsNum(sid)); break; case "mts": al.Add(bgb.TjProductionCNum(" and sid='" + sid + "' and substring(icode,1,2)='02'")); break; case "cts": al.Add(bgb.TjProductionCNum(" and sid='" + sid + "' and substring(icode,1,2)='06'")); break; case "yks": al.Add(bgb.TjProductionCNum(" and sid='" + sid + "' and substring(icode,1,2)='07'")); break; case "wjs": al.Add(bgb.TjProductionQtNum(" and sid='" + sid + "' and substring(icode,1,2)='04'")); break; case "qts": al.Add(bgb.TjProductionQtNum(" and sid='" + sid + "' and( substring(icode,1,2)='08'or substring(icode,1,2)='09'")); break; case "azfs": al.Add(""); break; default: al.Add(dr[column].ToString()); break; } } i++; r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryafterTj(string bdate, string duty, string edate, string fname, string emcode, string stype, 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); Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { string b = ""; string e = ""; string dn = ""; if (bdate == null || bdate == "") { b = CommonBll.GetBdate2(); } else { b = CommonBll.GetBdate(bdate); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); } else { e = CommonBll.GetEdate(edate); } if (duty != "" && duty != null) { string rs = ""; string[] ar = duty.Split(';'); for (int i = 0; i < ar.Length; i++) { if (i == 0) { rs = " aduty='" + ar[i] + "'"; } else { rs = " or aduty='" + ar[i] + "'"; } } where.AppendFormat(" and ({0})", rs); } if (fname != "" && fname != null) { where.AppendFormat(" and fname='{0}'", fname); } if (stype != "" && stype != null) { where.AppendFormat(" and sendtype='{0}'", stype); } string sqlw = svt.sqlcondition.Replace("[DNAME]", dn).Replace("[BDATE]", b).Replace("[EDATE]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, sfield, where.ToString(), " order by senddate desc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { string sid = dr[0].ToString(); switch (column.Caption) { case "xh": al.Add(i); break; default: al.Add(dr[column].ToString()); break; } } i++; r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList BlQueryProductions(string bdate, string emcode, 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); Sys_RptTemp srt = srtb.Query(" and emcode='" + emcode + "'"); if (srt != null) { DateTime dv = DateTime.Now; if (bdate != null && bdate != "") { where.AppendFormat(" and edate='{0}' ", CommonBll.GetBdate(bdate)); } else { where.AppendFormat(" and edate='{0}' ", CommonBll.GetBdate(DateTime.Now.ToString())); } if (iv.u.dcode != "") { string sqlw = srt.dbwhere.Replace("[dcode]", iv.u.dcode.Substring(0, iv.u.dcode.Length - 4)); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); } string sfield = srt.dbcol; lsr = tsb.QueryList(srt.dbtname, sfield, where.ToString(), " order by edate asc"); if (lsr != null) { int xh = 1; foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { switch (column.Caption) { case "xh": al.Add(xh); break; case "sid": break; default: al.Add(dr[column].ToString()); break; } } xh++; r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryReceiptTj(string bdate, string dcode, string edate, string emcode, string pzt, 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); Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { string b = ""; string e = ""; string dn = ""; if (bdate == null || bdate == "") { b = CommonBll.GetBdate(); where.AppendFormat(" and cdate >= '{0}'", b); } else { b = CommonBll.GetBdate(bdate); where.AppendFormat(" and cdate >= '{0}'", b); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); where.AppendFormat(" and cdate <= '{0}'", e); } else { e = CommonBll.GetEdate(edate); where.AppendFormat(" and cdate <= '{0}'", e); } if (dcode == "") { } else { where.AppendFormat(" and dcode = '{0}'", dcode); } if (pzt == "") { } else { where.AppendFormat(" and imoney = {0}", pzt); } string sqlw = svt.sqlcondition.Replace("[DNAME]", dn).Replace("[BDATE]", b).Replace("[EDATE]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, sfield, where.ToString(), "order by scode desc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); foreach (DataColumn column in lsr.Columns) { string sid = dr[0].ToString(); decimal gm = bpb.GetSkMoney(sid); switch (column.Caption) { case "xh": al.Add(i); break; case "fkdh": al.Add(""); break; case "gmoney": al.Add(gm.ToString()); break; case "pmethod": al.Add(""); break; case "cmoney": al.Add(Convert.ToDecimal(dr[column].ToString()) - gm); break; case "sxfax": al.Add("0"); break; case "qts": al.Add(""); break; case "azfs": al.Add(""); break; default: al.Add(dr[column].ToString()); break; } } i++; r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryAfterSaleList(string bdate, string city, string code, string curpage, string customer, string edate, string emcode, string pagesize, string platform, 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 (platform != "") { where.AppendFormat(" and dname like '%{0}%'", platform); } 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 "zt": al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); break; case "rrcode": Sys_RepairReason srr = srrb.Query(" and rcode='" + dr[column].ToString() + "'"); al.Add(srr == null ? "" : srr.rdetail); break; default: al.Add(dr[column].ToString()); break; } } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryBalanceTj(string bdate, string city, string dcode, string edate, string emcode, string tabcode) { ArrayList r = new ArrayList(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); StringBuilder htmstr = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); string b = ""; string e = ""; int rcount = 0; int pcount = 0; if (bdate == null || bdate == "") { b = CommonBll.GetBdate2(); } else { b = CommonBll.GetBdate(bdate); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); } else { e = CommonBll.GetEdate(edate); } if (dcode == "") { } else { where.AppendFormat(" and dcode = '{0}'", dcode); } if (city == "") { } else { where.AppendFormat(" and e_city like '%{0}%'", city); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); string sqlw = svt.sqlcondition.Replace("[BDATE]", b).Replace("[EDATE]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); lsr = bsob.QueryList(1, 1000, " * ", where.ToString(), " substring(scode,len(scode)-4,5) asc", ref rcount, ref pcount); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { int k = 1; DataTable plistfwj = new DataTable(); DataTable plistwj = new DataTable(); DataTable allplist = new DataTable(); string sqlfwj = "[iname],[sid], [psid], [gnum],[icode],[uname], [mname], [psize],[place],[direction], [fix], [locktype],[gmoney] , [govermoney],[gothermoney],[pnum]"; string sqlwj = "distinct([iname]),'' as [sid],'' as [psid],0 as [gnum],'' as [icode],[uname],'' as [mname],'' as [psize],'' as [place],'' as [direction],'' as [fix],'' as [locktype],sum([gmoney]) as [gmoney],sum([govermoney])as [govermoney],sum([gothermoney]) as[gothermoney],sum([pnum]) as[pnum]"; decimal omoney = 0; plistfwj = tsb.QueryList("View_Tj_SaleBalance", sqlfwj + ", gmoney+govermoney+gothermoney as mm ", " and sid='" + dr["sid"].ToString() + "' and substring(icode,1,2)<>'04'", ""); plistwj = tsb.QueryList("View_Tj_SaleBalance", sqlwj + ", sum(gmoney+govermoney+gothermoney) as mm", " and sid='" + dr["sid"].ToString() + "' and substring(icode,1,2)='04' group by [iname] ,[uname] ", ""); if (plistfwj != null) { k = k + plistfwj.Rows.Count; allplist = plistfwj.Clone(); object[] obj = new object[allplist.Columns.Count]; if (plistfwj != null) { for (int ii = 0; ii < plistfwj.Rows.Count; ii++) { plistfwj.Rows[ii].ItemArray.CopyTo(obj, 0); allplist.Rows.Add(obj); } } if (plistwj != null) { k = k + plistwj.Rows.Count; for (int ii = 0; ii < plistwj.Rows.Count; ii++) { plistwj.Rows[ii].ItemArray.CopyTo(obj, 0); allplist.Rows.Add(obj); } } } else { if (plistwj != null) { //k = k + plistwj.Rows.Count; //allplist = plistwj.Clone(); k = k + plistwj.Rows.Count; allplist = plistwj.Clone(); object[] obj = new object[allplist.Columns.Count]; for (int ii = 0; ii < plistwj.Rows.Count; ii++) { plistwj.Rows[ii].ItemArray.CopyTo(obj, 0); allplist.Rows.Add(obj); } } } #region htmstr.AppendFormat("<tr>"); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, i); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, dr["dname"].ToString()); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, dr["scode"].ToString()); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, dr["customer"].ToString()); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, dr["gzname"].ToString()); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, dr["e_city"].ToString()); htmstr.AppendFormat("<td rowspan='{0}'>{1}</td>", k, dr["address"].ToString()); if (k == 1) { htmstr.AppendFormat("<td colspan='11' style='background:#cccccc'>{0}</td>", "小计"); htmstr.AppendFormat("<td>{0}</td>", "0"); htmstr.AppendFormat("</tr>"); } else { if (allplist.Rows.Count > 0) { htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["place"].ToString()); htmstr.AppendFormat("<td>{0}</td>", "派的门"); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["iname"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["mname"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["uname"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["psize"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["pnum"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["gmoney"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["govermoney"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["gothermoney"].ToString()); htmstr.AppendFormat("<td>{0}</td>", "0"); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[0]["mm"].ToString()); htmstr.AppendFormat("</tr>"); omoney = omoney + Convert.ToDecimal(allplist.Rows[0]["mm"].ToString()); for (int l = 1; l < allplist.Rows.Count; l++) { htmstr.AppendFormat("<tr>"); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["place"].ToString()); htmstr.AppendFormat("<td>{0}</td>", "派的门"); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["iname"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["mname"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["uname"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["psize"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["pnum"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["gmoney"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["govermoney"].ToString()); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["gothermoney"].ToString()); htmstr.AppendFormat("<td>{0}</td>", "0"); htmstr.AppendFormat("<td>{0}</td>", allplist.Rows[l]["mm"].ToString()); htmstr.AppendFormat("</tr>"); omoney = omoney + Convert.ToDecimal(allplist.Rows[l]["mm"].ToString()); } htmstr.AppendFormat("<tr>"); htmstr.AppendFormat("<td colspan='11' style='background:#cccccc'>{0}</td>", "小计"); htmstr.AppendFormat("<td>{0}</td>", omoney.ToString()); htmstr.AppendFormat("</tr>"); htmstr.AppendFormat("</tr>"); } } #endregion i = i + 1; } } r.Add(htmstr.ToString()); } else { r.Add(iv.badstr); } return(r); }
public static string QueryOrderTj(string bdate, string edate, string emcode, string pzt, string tabcode) { string r = ""; StringBuilder hstr = new StringBuilder(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { string b = ""; string e = ""; if (bdate == null || bdate == "") { b = CommonBll.GetBdate2(); } else { b = CommonBll.GetBdate(bdate); } if (edate == null || edate == "") { e = CommonBll.GetEdate(); } else { e = CommonBll.GetEdate(edate);; } if (pzt != "") { if (pzt == "scz") { where.Append(" and sid in (select sid from CB_orderflow where wcode='0094' and state<1)"); } if (pzt == "ysc") { where.Append(" and sid in (select sid from CB_orderflow where wcode='0094' and state=1)"); } } string sqlw = svt.sqlcondition.Replace("[dcode]", iv.u.dcode).Replace("[bdate]", b).Replace("[edate]", e); where.Append(CommonBll.SqlWhereReplace(iv.u, sqlw)); string sfield = svt.sqlcols; lsr = tsb.QueryList(svt.tname, sfield, where.ToString(), " order by scode desc"); if (lsr != null) { int i = 1; foreach (DataRow dr in lsr.Rows) { int rnum = 0; List <B_AfterGroupProduction> lbp = bgb.QueryList(" and sid='" + dr["sid"].ToString() + "' order by id asc"); if (lbp != null) { rnum = lbp.Count; } hstr.Append("<tr>"); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, i.ToString()); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, dr["scode"].ToString()); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, dr["oscode"].ToString()); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, dr["dname"].ToString()); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, dr["customer"].ToString()); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, dr["isfc"].ToString() == "True"?"是":"否"); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, dr["adremark"].ToString()); if (rnum > 0) { hstr.AppendFormat("<td>{0}</td>", "1." + lbp[0].place); hstr.AppendFormat("<td>{0}</td>", lbp[0].itype); hstr.AppendFormat("<td>{0}</td>", lbp[0].sitype); hstr.AppendFormat("<td>{0}</td>", lbp[0].msname); hstr.AppendFormat("<td>{0}</td>", lbp[0].direction); hstr.AppendFormat("<td>{0}</td>", lbp[0].stype); hstr.AppendFormat("<td>{0}</td>", lbp[0].height.ToString() + "*" + lbp[0].width.ToString() + "*" + lbp[0].deep.ToString()); if (lbp[0].itype == "门板") { hstr.AppendFormat("<td>{0}</td>", lbp[0].deep.ToString()); } else { hstr.AppendFormat("<td>{0}</td>", lbp[0].pmsd.ToString()); } // hstr.AppendFormat("<td>{0}</td>", lbp[0].pnum.ToString()); hstr.AppendFormat("<td>{0}</td>", lbp[0].mname); hstr.AppendFormat("<td>{0}</td>", lbp[0].glass); hstr.AppendFormat("<td>{0}</td>", lbp[0].gsize); hstr.AppendFormat("<td>{0}</td>", lbp[0].fixs); hstr.AppendFormat("<td>{0}</td>", lbp[0].locks); hstr.AppendFormat("<td>{0}</td>", lbp[0].workform); hstr.AppendFormat("<td>{0}</td>", lbp[0].pname + lbp[0].remark); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, CommonBll.GetBdate(dr["scdate"].ToString())); hstr.AppendFormat("<td rowspan='{0}'>{1}</td>", rnum, CommonBll.GetBdate(dr["sodate"].ToString())); } else { hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); hstr.AppendFormat("<td>{0}</td>", ""); } hstr.Append("</tr>"); if (rnum > 1) { int pxh = 2; for (int k = 1; k < rnum; k++) { hstr.Append("<tr>"); hstr.AppendFormat("<td>{0}</td>", pxh.ToString() + "." + lbp[k].place); hstr.AppendFormat("<td>{0}</td>", lbp[k].itype); hstr.AppendFormat("<td>{0}</td>", lbp[k].sitype); hstr.AppendFormat("<td>{0}</td>", lbp[k].msname); hstr.AppendFormat("<td>{0}</td>", lbp[k].direction); hstr.AppendFormat("<td>{0}</td>", lbp[k].stype); hstr.AppendFormat("<td>{0}</td>", lbp[k].height.ToString() + "*" + lbp[k].width.ToString() + "*" + lbp[k].deep.ToString()); if (lbp[k].itype == "门板") { hstr.AppendFormat("<td>{0}</td>", lbp[k].deep.ToString()); } else { hstr.AppendFormat("<td>{0}</td>", lbp[k].pmsd.ToString()); } hstr.AppendFormat("<td>{0}</td>", lbp[k].mname); hstr.AppendFormat("<td>{0}</td>", lbp[k].glass); hstr.AppendFormat("<td>{0}</td>", lbp[k].gsize); hstr.AppendFormat("<td>{0}</td>", lbp[k].fixs); hstr.AppendFormat("<td>{0}</td>", lbp[k].locks); hstr.AppendFormat("<td>{0}</td>", lbp[k].workform); hstr.AppendFormat("<td>{0}</td>", lbp[k].pname + lbp[k].remark); hstr.Append("</tr>"); pxh++; } } i++; } } r = hstr.ToString(); } } else { r = iv.badstr; } return(r); }
public static string QueryMzSetlmentStr(string bdate, string code, string curpage, string edate, string emcode, string pagesize, string platform, string tabcode, string zt) { DataTable lsr = new DataTable(); string r = ""; StringBuilder trstr = new StringBuilder(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { int rcount = 0; int pcount = 0; if (code != "") { where.AppendFormat(" and scode like '%{0}%'", code); } if (platform != "") { where.AppendFormat(" and dname like '%{0}%'", platform); } if (bdate != "" && bdate != null) { where.AppendFormat(" and cdate >='{0}'", bdate); } if (edate != "" && edate != null) { where.AppendFormat(" and cdate <='{0}'", edate); } if (zt == "1") { where.AppendFormat(" and isetlment ={0}", zt); } else { where.AppendFormat(" and isetlment ={0}", "0"); } 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 = bmsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), "id desc", ref rcount, ref pcount); if (lsr != null) { foreach (DataRow dr in lsr.Rows) { trstr.Append("<tr>"); foreach (DataColumn column in lsr.Columns) { switch (column.Caption) { case "ysmoney": trstr.AppendFormat("<td>{0}</td>", bprb.GetSkMoneyEx(" and sid='" + dr[1].ToString())); break; case "sid": break; case "rowId": break; default: trstr.AppendFormat("<td>{0}</td>", dr[column].ToString()); break; } } trstr.Append("</tr>"); } r = trstr.ToString(); } } } else { r = iv.badstr; } return(r); }
public static ArrayList QueryAfterSaleReceiptList(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 (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 "symoney": al.Add(bsob.Query(" and sid='" + dr[1].ToString() + "'").omoney - bpb.GetSkMoney(dr[1].ToString())); break; default: al.Add(dr[column].ToString()); break; } } r.Add(al); } } } } else { r.Add(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 ArrayList QueryMtPlanItem(string bdate, string gycode, string emcode, string pbcode) { ArrayList r = new ArrayList(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); if (bdate != "" && bdate != null) { bdate = CommonBll.GetBdate(bdate); where.AppendFormat(" and bdate >= '{0}' and bdate<='{1}'", bdate + " 00:00:00", bdate + " 23:59:59"); } if (gycode != "") { where.AppendFormat(" and gcode = '{0}'", gycode); } if (pbcode != "") { where.AppendFormat(" and mname in (select mname from [LvErpBase].[dbo].[Sys_RBrandsMaterial] where pbcode='{0}' )", pbcode); } Sys_ViewTable svt = svtb.QuerySelCols(emcode, "a", iv.u.rcode); if (svt == null) { } else { where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); DataTable dt = tsb.QueryList(svt.tname, svt.sqlcols, where.ToString(), " order by id asc"); if (dt != null) { int xh = 1; foreach (DataRow dr in dt.Rows) { ArrayList al = new ArrayList(); al.Add(xh); foreach (DataColumn column in dt.Columns) { switch (column.Caption) { case "id": break; case "acode": break; case "sid": break; case "rowId": break; default: al.Add(dr[column].ToString()); break; } } al.Add("<a href='#'>打印标签</a>"); r.Add(al); xh++; } } } } else { r.Add(iv.badstr); } return(r); }