public static ArrayList QueryPayImgList(string sid, string ptype)
{
ArrayList r = new ArrayList();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add("S");
if (sid != "")
{
where.AppendFormat(" and sid='{0}' and ptype='{1}'", sid, ptype);
}
List <B_PayImg> lbsp = bpb.QueryList(where.ToString());
if (lbsp != null)
{
foreach (B_PayImg b in lbsp)
{
ArrayList al = new ArrayList();
al.Add(b.id);
al.Add("<img id='" + b.id + "' src='" + b.url + "' onclick='nck(this.id)'/>");
al.Add(b.remark);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string QueryMzOrderPrice(string sid)
{
string r = "";
B_QbqqSaleOrder bms = new B_QbqqSaleOrder();
VMzOrderPrice vmp = new VMzOrderPrice();
StringBuilder djh = new StringBuilder();
StringBuilder omh = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
bms = bmsob.Query("and sid='" + sid + "'");
vmp.omoney = bms.omoney.ToString("#0.00");
vmp.dmoney = bms.dmoney.ToString("#0.00");
B_MzPriceFile bmpf = bmpfb.Query(" and sid='" + sid + "'");
if (bmpf != null)
{
vmp.pfname = bmpf.fname;
vmp.bshow = "1";
vmp.pfid = bmpf.id.ToString();
}
List <B_PayImg> ldbpi = bpib.QueryList(" and sid='" + sid + "' and ptype='dj'");
if (ldbpi != null)
{
djh.Append("<table style='width:100%;border:none'>");
foreach (B_PayImg bpi in ldbpi)
{
djh.AppendFormat("<tr><td><img id='{0}' src='{1}' alt='' onclick='nck(this.id)'/></td></tr>", bpi.id, bpi.url);
}
djh.Append("<table>");
}
List <B_PayImg> lobpi = bpib.QueryList(" and sid='" + sid + "' and ptype='o'");
if (lobpi != null)
{
omh.Append("<table style='width:100%;border:none'>");
foreach (B_PayImg bpi in lobpi)
{
omh.AppendFormat("<tr><td><img id='{0}' src='{1}' alt='' onclick='nck(this.id)'/></td></tr>", bpi.id, bpi.url);
}
omh.Append("<table>");
}
vmp.djhtm = djh.ToString();
vmp.omhtm = omh.ToString();
r = js.Serialize(vmp);
}
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 string QueryAfterMoney(string sid)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
VAOrderPrice vaop = new VAOrderPrice();
StringBuilder omh = new StringBuilder();
B_AfterSaleOrder bafo = abasob.Query("and sid='" + sid + "'");
if (bafo != null)
{
vaop.omoney = bafo.omoney.ToString("#0.00");
B_AfterPriceFile bapf = abpfb.Query("and sid='" + sid + "'");
if (bapf != null)
{
vaop.bshow = "1";
vaop.fname = bapf.fname;
vaop.pfid = bapf.id.ToString();
}
List <B_PayImg> lobpi = bpib.QueryList(" and sid='" + sid + "' and ptype='o'");
if (lobpi != null)
{
omh.Append("<table style='width:100%;border:none'>");
foreach (B_PayImg bpi in lobpi)
{
omh.AppendFormat("<tr><td><img id='{0}' src='{1}' alt='' onclick='nck(this.id)'/></td></tr>", bpi.id, bpi.url);
}
omh.Append("<table>");
}
vaop.ohtm = omh.ToString();
r = js.Serialize(vaop);
}
}
else
{
r = iv.badstr;
}
return(r);
}
