public JsonResult SaveYySend(string psbz, string psdate, string psy, string sid)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_YySend bfm = new B_YySend();
bfm.sid = sid;
bfm.sperson = psy;
bfm.pdate = CommonBll.GetBdate(psdate);
bfm.pbz = psbz;
bfm.maker = iv.u.ename;
bfm.cdate = DateTime.Now.ToString();
if (bysb.Add(bfm) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public static string ProductionOrder(string sid)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
VProduceOrder vpo = new VProduceOrder();
B_YqSaleOrder bso = bsob.Query(" and sid='" + sid + "'");
CB_OrderFlow cof = bwfb.QueryAttrExWorkFlow(sid, "sc");
B_OrderFacotory bof = bofb.Query(" and sid='" + sid + "'");
vpo.code = bso.scode;
vpo.ycode = bso.ycode;
vpo.customer = bso.customer;
vpo.address = bso.address;
vpo.dname = bso.dname;
vpo.otype = bso.otype;
vpo.fname = bof == null ? "" : bof.dname;
vpo.scdate = cof.edate;
vpo.overdate = bof == null ? "" : CommonBll.GetBdate(bof.overdate);
vpo.bz = bso.remark;
r = js.Serialize(vpo);
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryInHouseList(string sid)
{
ArrayList r = new ArrayList();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <B_InHouseOrder> lbo = bihob.QueryList(" and sid='" + sid + "'");
if (lbo != null)
{
foreach (B_InHouseOrder o in lbo)
{
ArrayList al = new ArrayList();
al.Add(o.isid);
al.Add(o.icode);
al.Add(o.maker);
al.Add(CommonBll.GetBdate(o.cdate));
al.Add(o.ps);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string UpdateAppointment(string sid, string cv, string gv, string vv, string sv)
{
string r = "";
B_AfterFreeBackOrder b = new B_AfterFreeBackOrder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
b.sid = sid;
b.sdate = CommonBll.GetBdate(cv);
b.gofee = Convert.ToDecimal(gv);
b.servfee = Convert.ToDecimal(vv);
b.stext = sv;
if (bsob.UpdateAppointment(b))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryMeasureList(string sid, string emcode)
{
ArrayList r = new ArrayList();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <B_MzMeasureFile> lbp = bmmfb.QueryList(" and sid='" + sid + "'");
if (lbp != null)
{
foreach (B_MzMeasureFile b in lbp)
{
string cz = bebb.ItemsBtnList(sid, b.id.ToString(), emcode, iv.u.rcode);
ArrayList al = new ArrayList();
al.Add(b.mname);
al.Add(CommonBll.GetBdate(b.cdate));
al.Add(cz);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryQualityList(string sid, string qtype)
{
ArrayList r = new ArrayList();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <B_PartQualityOrder> bpqo = bpqob.QueryList(" and sid='" + sid + "' and qstate=" + qtype + "");
if (bpqo != null)
{
foreach (B_PartQualityOrder b in bpqo)
{
ArrayList al = new ArrayList();
al.Add(b.qsid);
al.Add(b.qcode);
al.Add(b.maker);
al.Add(CommonBll.GetBdate(b.cdate));
al.Add(b.remark);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string SaveGatherOrder(string gdate, string gmoney, string gmethod, string gperson, string gremark, string sid)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_CustormOrder bco = bcob.Query(" and csid='" + sid + "'");
A_CustomeAccount bcg = new A_CustomeAccount();
bcg.gsid = CommonBll.GetSid();
bcg.address = bco.address;
bcg.customer = bco.customer;
bcg.telephone = bco.telephone;
bcg.citycode = bco.e_citycode;
bcg.cityname = bco.e_city;
bcg.dcode = bco.dcode;
bcg.dname = bco.dname;
bcg.pcate = "订金";
bcg.scode = bco.wcode;
bcg.ptype = 1;
bcg.pstate = 0;
bcg.pmethod = gmethod;
bcg.pmoney = Convert.ToDecimal(gmoney);
bcg.maker = gperson;
bcg.remark = gremark;
bcg.ddate = CommonBll.GetBdate(gdate);
bcg.cdate = DateTime.Now.ToString();
bcg.sid = sid;
if (acab.Exists(" and sid='" + sid + "'"))
{
if (acab.UpdateEx(bcg))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
if (acab.Add(bcg) > 0)
{
bwfb.CreateWorkFlow(bcg.gsid, "0092");
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string QueryPayOrder(string sid)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
VCPaymentOrder vp = new VCPaymentOrder();
B_CityPayOrder bcp = new B_CityPayOrder();
if (sid != "")
{
StringBuilder mhtm = new StringBuilder();
CB_OrderState cos = cosb.Query(" and sid='" + sid + "'");
bcp = bcpob.Query(" and sid='" + sid + "'");
vp.caccount = bcp.caccount;
vp.cbank = bcp.cbank;
vp.cdate = CommonBll.GetBdate(bcp.cdate);
vp.ctype = bcp.ctype;
vp.dname = bcp.dname;
vp.kj = "";
vp.maker = bcp.maker;
vp.paccount = bcp.paccount;
vp.pbank = bcp.pbank;
vp.pcode = bcp.pcode;
vp.pdate = CommonBll.GetBdate(bcp.pdate);
vp.pmethod = bcp.pmethod;
vp.pmoney = bcp.pmoney.ToString();
vp.remark = bcp.remark;
if (cos.iover > 0)
{
vp.zt = "取消";
}
else
{
vp.zt = "正常";
}
List <B_PayImg> lbp = bpib.QueryList(" and sid='" + sid + "' and ptype='cp'");
if (lbp != null)
{
foreach (B_PayImg b in lbp)
{
mhtm.AppendFormat("<img id='{0}' onclick='nck(this.id)' src='{1}' alt='' style='width:100%'/><br>", b.id, b.url);
}
}
vp.ming = mhtm.ToString();
}
r = js.Serialize(vp);
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryPayOrderList(string account, string bdate, string edate)
{
ArrayList r = new ArrayList();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
if (bdate != null)
{
where.AppendFormat(" and cdate>='{0}'", CommonBll.GetBdate(bdate));
}
else
{
where.AppendFormat(" and cdate>='{0}'", CommonBll.GetBdate());
}
if (edate != null)
{
where.AppendFormat(" and cdate<'{0}'", CommonBll.GetEdate(edate));
}
else
{
where.AppendFormat(" and cdate<'{0}'", CommonBll.GetEdate());
}
if (account != "")
{
where.AppendFormat(" and sacode='{0}'", account);
}
where.AppendFormat(" order by cdate desc");
List <B_ExchangeRecord> blr = barb.QueryList(where.ToString());
if (blr != null)
{
foreach (B_ExchangeRecord ba in blr)
{
ArrayList al = new ArrayList();
Sbk_Account sa = sab.Query(" and acode='" + ba.sacode + "'");
al.Add(ba.sacode);
al.Add(sa != null?sa.aname:"");
al.Add(ba.oscode);
al.Add(ba.otype);
al.Add(ba.emoney);
al.Add(ba.umoney);
al.Add(ba.cdate);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public JsonResult SaveTjProduction(string acode, string bdate, string bjprice, string edate, string tarea, string tcode, string tctype, string tid, string tname, string ttj, string wfprice)
{
JsonData d = new JsonData();
Sys_SpecialProduction sb = new Sys_SpecialProduction();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_SaleDiscount ss = ssdb.Query(" and dcode='" + acode + "'");
if (ss != null)
{
sb.aname = ss.dname;
sb.acode = ss.dcode;
}
sb.tjname = tname;
sb.tjcode = tcode;
sb.bdate = CommonBll.GetBdate(bdate);
sb.edate = CommonBll.GetBdate(edate);
sb.bjprice = Convert.ToDecimal(bjprice);
sb.wfprice = Convert.ToDecimal(wfprice);
sb.ctype = tctype;
sb.econdition = ttj == null?"":ttj;
sb.tjarea = tarea;
sb.maker = iv.u.ename;
sb.cdate = DateTime.Now.ToString();
if (tid == "0")
{
if (sspb.Add(sb) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (sspb.Update(sb))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult SaveSm(string bjprice, string cgprice, string tcarea, string tcbdate, string tccode, string tcedate, string tcid, string tcname, string tcnum, string wbprice)
{
JsonData d = new JsonData();
Sys_SetMeal sb = new Sys_SetMeal();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sb.tcname = tcname;
sb.tccode = tccode;
sb.tcbdate = CommonBll.GetBdate(tcbdate);
sb.tcedate = CommonBll.GetBdate(tcedate);
sb.bjprice = Convert.ToDecimal(bjprice);
sb.wbprice = Convert.ToDecimal(wbprice);
sb.cgprice = Convert.ToDecimal(cgprice);
sb.tcnum = Convert.ToInt32(tcnum);
sb.tcarea = tcarea;
sb.maker = iv.u.ename;
sb.cdate = DateTime.Now.ToString();
if (tcid == "0")
{
if (salb.Add(sb) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (salb.Update(sb))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult SaveDiscount(string bdate, string dcode, string dname, string dremark, string edate, string id)
{
JsonData d = new JsonData();
Sys_SaleDiscount sa = new Sys_SaleDiscount();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sa.dcode = dcode;
sa.dname = dname;
sa.dtype = "";
sa.dedate = CommonBll.GetBdate(edate);
sa.dbdate = CommonBll.GetBdate(bdate);
sa.cdate = DateTime.Now.ToString();
sa.drange = "0";
sa.dproduction = "0";
sa.maker = iv.u.ename;
if (id == "0")
{
if (ssdb.Add(sa) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (ssdb.Update(sa))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public static string SaveLongTime(string id, string ldate, string remark)
{
string r = "";
BusiWorkFlowBll snsb = new BusiWorkFlowBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
CB_ProcessRecord cpr = new CB_ProcessRecord();
CB_OrderProduceProcess p = coppb.Query(" and id=" + id + "");
DateTime d1 = Convert.ToDateTime(ldate);
DateTime d2 = Convert.ToDateTime(CommonBll.GetBdate(p.ydate));
TimeSpan ts = d1 - d2;
int d = ts.Days;
cpr.cdate = DateTime.Now.ToString();
cpr.jdname = p.jdname;
cpr.jid = p.id;
cpr.maker = iv.u.ename;
cpr.rtext = p.jdname + "预计完成日期" + p.ydate + "延期到" + ldate + ";延期说明：" + remark;
cpr.sid = p.sid;
cprb.Add(cpr);
List <CB_OrderProduceProcess> plist = coppb.QueryList(" and id>=" + p.id + " and sid='" + p.sid + "'");
if (plist != null)
{
foreach (CB_OrderProduceProcess cp in plist)
{
cp.ydate = Convert.ToDateTime(cp.ydate).AddDays(d).ToString();
coppb.SetLongTime(cp);
}
}
if (coppb.UpState(id, -1))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SetBatch(string pdate, string ptype)
{
string r = "";
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (pdate == null || pdate == "")
{
pdate = DateTime.Now.ToString();
}
if (ptype == "ms")
{
if (bppb.SetMsBtach(CommonBll.GetBdate(pdate)))
{
r = "S";
}
else
{
r = "F";
}
}
if (ptype == "mt")
{
if (bppb.SetMtBtach(CommonBll.GetBdate(pdate)))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string InitAfterOrder(string sid)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
B_YqAfterSaleOrder ao = new B_YqAfterSaleOrder();
Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'");
if (iv.f)
{
ao = basob.Query(" and sid='" + sid + "'");
ao.cdate = CommonBll.GetBdate(ao.cdate);
// ao.ztimg = bosb.QueryOrderStateImg(sid);
r = js.Serialize(ao);
}
else
{
r = iv.badstr;
}
return(r);
}
public static string UpdateAppointment(string sid, string cv, string gv, string vv, string sv, string sdv)
{
string r = "";
B_AfterReModifyOrder b = new B_AfterReModifyOrder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
b.sid = sid;
if (cv == null || cv == "")
{
b.sdate = "2000-01-01";
}
else
{
b.sdate = CommonBll.GetBdate(cv);
}
b.senddate = CommonBll.GetBdate(sdv);
b.gofee = Convert.ToDecimal(gv);
b.servfee = Convert.ToDecimal(vv);
b.stext = sv;
if (basob.SetAppointment(b))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = 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 string SaveCustomerOrder(string address, string citycode, string cityname, string cmoney, string colortype, string distype, string customer, string gzname, string gztelephone,
string lxtype, string mname, string otype, string remark, string shopcode, string shopname, string sid, string source, string telephone, string wcode, string yxdate)
{
string r = "";
BusiWorkFlowBll bwfb = new BusiWorkFlowBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_SaleDiscount ssd = ssdb.Query(" and dcode='" + distype + "'");
B_CustormOrder bco = new B_CustormOrder();
bco.ccode = "";
bco.wcode = wcode;
bco.cmoney = Convert.ToDecimal(cmoney);
bco.customer = customer;
bco.telephone = telephone;
bco.community = "";
bco.address = address;
bco.aname = "";
bco.acode = "";
bco.dname = shopname;
bco.dcode = shopcode;
bco.e_city = cityname;
bco.e_citycode = citycode;
bco.e_citytype = "";
bco.gzname = gzname;
bco.gztelephone = gztelephone;
bco.saletelephone = "";
bco.otype = otype;
bco.state = false;
bco.mname = mname;
bco.source = source;
bco.ps = remark;
bco.maker = iv.u.ename;
bco.cdate = DateTime.Now.ToString();
bco.istax = false;
bco.isdf = false;
bco.yxdate = CommonBll.GetBdate(yxdate);
bco.lxtype = lxtype;
bco.colorpane = colortype;
if (distype != "")
{
bco.disactname = ssd != null ? ssd.dname : "";
bco.disactcode = distype;
}
else
{
bco.disactname = "";
bco.disactcode = "";
}
if (sid == "")
{
bco.csid = CommonBll.GetSid();
bco.ccode = cocb.SetCustomerOrderCode();
if (bcob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.csid, "0001");
r = bco.csid;
}
else
{
r = "F";
}
}
else
{
bco.csid = sid;
if (bcob.Update(bco))
{
r = bco.csid;
}
else
{
r = "F";
}
}
}
else
{
r = 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 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 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 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 string SaveOrder(string acity, string address, string aprovince, string areason, string asid, string bcode, string customer, string dcode, string emcode, string gofee, string maker, string oscode, string osid, string remark, string sdate, string servfee, string sid, string sscode, string stext, string telephone)
{
string r = "";
B_AfterFreeBackOrder b = new B_AfterFreeBackOrder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'");
Sys_Depment cs = sdb.Query(" and dcode='" + dcode.Substring(0, dcode.Length - 4) + "'");
b.osid = osid;
b.asid = asid;
b.address = address;
b.acity = acity;
b.aprovince = aprovince;
b.customer = customer;
b.telephone = telephone;
b.dcode = dcode;
b.dname = sd.dname;
b.city = cs.dname;
b.citycode = cs.dcode;
b.maker = iv.u.ename;
b.oscode = oscode;
b.sscode = sscode;
b.gofee = Convert.ToDecimal(gofee);
b.servfee = Convert.ToDecimal(servfee);
b.sdate = CommonBll.GetBdate(sdate);
b.stext = stext;
b.remark = remark;
b.scode = "HAS" + DateTime.Now.ToString("yyMM") + bsob.GetOrderNum().ToString().PadLeft(5, '0');
b.areason = areason;
b.telephone = telephone;
b.cdate = DateTime.Now.ToString("yyyy-MM-dd");
if (sid == "")
{
b.sid = CommonBll.GetSid();
if (bsob.Add(b) > 0)
{
r = b.sid;
CB_OrderState cos = new CB_OrderState();
cos.sid = b.sid;
cosb.Add(cos);
bwfb.CreateWorkFlow(b.sid, emcode);
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(b.sid, bcode, "1", "创建售后单");
}
else
{
b.sid = sid;
if (bsob.Update(b))
{
r = b.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(b.sid, bcode, "1", "更新售后单");
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveFactory(string bcode, string fcode, string fdate, string sid, string emcode)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
// int dn = 0;
Sys_Depment sd = sdb.Query(" and dcode='" + fcode + "'");
B_OrderFacotory bf = new B_OrderFacotory();
B_OrderFacotory bof = bofb.Query(" and sid='" + sid + "'");
bf.dname = sd != null ? sd.dname : "";
bf.dcode = fcode;
bf.maker = iv.u.ename;
bf.sid = sid;
bf.overdate = CommonBll.GetBdate(fdate);
bf.fdate = DateTime.Now.ToString();
bf.otype = "";
bf.cdate = DateTime.Now.ToString();
if (bof != null)
{
if (bofb.Update(bf))
{
r = "S";
//if (fline != "")
//{
// bppb.SetProduceProcess(sid, fline);
//}
//bcpb.OrderCgComputePrice(sid);
BaseSet.WorkFlowManage.EventBtnDo.FireEventBtn(sid, bcode, "1", "分单");
}
else
{
r = "F";
}
}
else
{
if (bofb.Add(bf) > 0)
{
r = "S";
//if (fline != "")
//{
// bppb.SetProduceProcess(sid, fline);
//}
//bcpb.OrderCgComputePrice(sid);
BaseSet.WorkFlowManage.EventBtnDo.FireEventBtn(sid, bcode, "1", "分单");
}
else
{
r = "F";
}
}
bcnof.CreateNewOrders(sid, emcode);
}
else
{
r = 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 QueryTTaskTj(string bdate, string emcode)
{
ArrayList r = new ArrayList();
DataTable lsr = new DataTable();
StringBuilder where = new StringBuilder();
StringBuilder wh2 = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
DateTime dv = DateTime.Now;
if (bdate != null && bdate != "")
{
wh2.AppendFormat(" and bdate='{0}'", CommonBll.GetBdate(bdate));
}
else
{
wh2.AppendFormat(" and bdate='{0}'", DateTime.Now.ToString("yyyy-MM-dd"));
}
Sys_RptTemp srt = srtb.Query(" and emcode='" + emcode + "'");
if (srt != null)
{
lsr = tsb.QueryList(srt.dbtname, srt.dbcol, wh2.ToString() + srt.dbwhere, " ");
if (lsr != null)
{
int i = 1;
foreach (DataRow dr in lsr.Rows)
{
ArrayList al = new ArrayList();
if (lsr.Columns.Contains("xh"))
{
al.Add(i);
}
foreach (DataColumn column in lsr.Columns)
{
switch (column.Caption)
{
case "id":
break;
case "xh":
break;
default:
al.Add(dr[column].ToString());
break;
}
}
r.Add(al);
i++;
}
}
}
}
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 QueryProdutionList(string bdate, string code, string curpage, string customer, string edate, string emcode, string fname, 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 (fname != "")
{
where.AppendFormat(" and fname like '%{0}%'", fname);
}
if (platform != "")
{
where.AppendFormat(" and dname like '%{0}%'", platform);
}
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 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 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);
}