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 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 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 ArrayList QueryProdutionList(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 (fname != "") //{ // where.AppendFormat(" and fname like '%{0}%'", fname); //} if (dname != "") { where.AppendFormat(" and dname like '%{0}%'", dname); } if (bdate != "" && bdate != null) { where.AppendFormat(" and edate >='{0}'", CommonBll.GetBdate(bdate)); } if (edate != "" && edate != null) { where.AppendFormat(" and edate <='{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 = bsob.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), sfield, where.ToString(), " substring(scode,len(scode)-4,5) 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 QueryOrderList(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 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) { switch (column.Caption) { case "zt": al.Add("<span style='color:blue; font-weight:bolder'>" + cbeb.GetOrderState(dr[1].ToString()) + "</span>"); break; case "acode": break; case "rowId": break; default: al.Add(dr[column].ToString()); break; } } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }