public static ArrayList QueryCanalSaleOrderList(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.CanalQueryList(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);
}