public static string CopyTree(string tcode)
{
string r = "";
Sys_ViewTableBll svb = new Sys_ViewTableBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_ViewTable sv = svb.Query(" and tcode='" + tcode + "'");
sv.id = 0;
sv.cols = sv.cols.Replace("\n", "");
sv.sqlcols = sv.sqlcols.Replace("\n", "");
sv.sqlcondition = sv.sqlcondition.Replace("\n", "");
sv.cdate = DateTime.Now.ToString();
sv.maker = iv.u.ename;
sv.ecols = sv.ecols.Replace("\n", "");
sv.esqlcols = sv.esqlcols.Replace("\n", "");
sv.tcode = svb.CreateCode().ToString().PadLeft(4, '0');
if (svb.Add(sv) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
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 string InitTree(string emcode, string tcode)
{
string r = "";
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_ViewTable st = new Sys_ViewTable();
Sys_EventMenuBll seb = new Sys_EventMenuBll();
Sys_EventMenu sem = new Sys_EventMenu();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (emcode != "")
{
st.tcode = svb.CreateCode().ToString().PadLeft(4, '0');
st.tname = "";
st.emcode = emcode;
st.emname = seb.Query(" and emcode='" + emcode + "'").emname;
st.id = 0;
}
else
{
st = svb.Query(" and tcode='" + tcode + "'");
}
r = js.Serialize(st);
}
else
{
r = 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 string SaveTree(string dcsql, string dctitle, string lbemcode, string lbemname, string lbid, string lbrole, string lbsql, string lbtable, string lbtcode, string lbtitle, string lbtj, string lbyq, string lbyqname)
{
string r = "";
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_ViewTable sv = new Sys_ViewTable();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sv.emname = lbemname;
sv.emcode = lbemcode;
sv.tcode = lbtcode;
sv.cols = lbtitle.Replace("\n", "");
sv.sqlcols = lbsql.Replace("\n", "");
sv.sqlcondition = lbtj.Replace("\n", "");
sv.tabcode = lbyq;
sv.tabname = lbyqname;
sv.tname = lbtable;
sv.rcode = lbrole;
sv.cdate = DateTime.Now.ToString();
sv.maker = iv.u.ename;
sv.ecols = dctitle.Replace("\n", "");
sv.esqlcols = dcsql.Replace("\n", "");
if (lbid == "0")
{
if (svb.Add(sv) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
if (svb.Update(sv))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = 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 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 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 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 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 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 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 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 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 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 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 ArrayList QueryProductions(string emcode, string tabcode, string bdate, string edate)
{
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)
{
where.AppendFormat(" and scdate >='{0}'", bdate);
}
else
{
where.AppendFormat(" and scdate>='{0}'", CommonBll.GetBdate2());
}
if (edate != "" && edate != null)
{
where.AppendFormat(" and scdate <='{0}'", edate);
}
else
{
DateTime dv = DateTime.Now.AddDays(1);
where.AppendFormat(" and scdate<='{0}'", dv.ToString("yyyy-MM-dd"));
}
Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode);
lsr = tsb.QueryList(svt.tname, svt.sqlcols, where.ToString(), " order by pid ");
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 "e_ptype":
switch (dr[column].ToString())
{
case "f":
case "s":
al.Add("门扇");
break;
case "mt":
al.Add("横挺");
break;
case "lb":
al.Add("立挺");
break;
case "stl":
al.Add("横L线");
break;
case "ltl":
al.Add("竖L线");
break;
default:
al.Add(" ");
break;
}
break;
default:
al.Add(dr[column].ToString());
break;
}
}
xh++;
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 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 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 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);
}
