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); }