/// <summary> /// 验证是否能够存档 /// </summary> /// <param name="orderid"></param> /// <param name="fileStatus"></param> /// <param name="iscancel"></param> /// <returns></returns> public bool isCanFile(object orderid, object fileStatus, object iscancel) { if (iscancel.ToString() == "Y") { return(true); } else { int id = 0; int.TryParse(orderid.ToString(), out id); DataTable ordercollect = To_OrderCollectDetialManager.getList(id); DataTable orderpay = To_OrderPayDetialManager.getList(id); List <string> collectstatus = new List <string>(); List <string> paystatus = new List <string>(); for (int i = 0; i < ordercollect.Rows.Count; i++) { collectstatus.Add(ordercollect.Rows[i]["collectStatus"].ToString()); } for (int i = 0; i < orderpay.Rows.Count; i++) { paystatus.Add(orderpay.Rows[i]["payStatus"].ToString()); } if ((collectstatus.All <string>(x => x == "完成收款") && paystatus.All <string>(x => x == "完成付款")) && fileStatus.ToString() == "0") { return(true); } else { return(false); } } }
/// <summary> /// 得到付款明细 /// </summary> /// <param name="orderid"></param> /// <returns></returns> public string getPayDetail(object orderid) { StringBuilder str = new StringBuilder(); str.Append("<table border='1' >"); str.Append("<tr><th width='200px'>付款单位</th><th width='80px'>付款类别</th><th width='80px'>应付金额</th><th width='80px'>已付金额</th><th width='80px'>未付金额</th></tr>"); DataTable dt = To_OrderPayDetialManager.getList(int.Parse(orderid.ToString())); for (int i = 0; i < dt.Rows.Count; i++) { double money = Convert.IsDBNull(dt.Rows[i]["money"]) ? 0.0 : Convert.ToDouble(dt.Rows[i]["money"]); //应付金额 double payAmount = Convert.IsDBNull(dt.Rows[i]["payAmount"]) ? 0.0 : Convert.ToDouble(dt.Rows[i]["payAmount"]); str.Append("<tr><td>" + dt.Rows[i]["supName"].ToString() + "</td>"); //付款单位 str.Append("<td>" + dt.Rows[i]["payType"].ToString() + "</td>"); //付款类别 str.Append("<td>" + money.ToString() + "</td>"); //应付金额 str.Append("<td>" + payAmount.ToString() + "</td>"); //已付金额 str.Append("<td>" + (money - payAmount).ToString() + "</td></tr>"); //未付金额 } str.Append("</table>"); return(str.ToString()); }
/// <summary> /// 付款 /// </summary> /// <param name="id"></param> private decimal LoadPay(int id) { decimal moneyAmount = 0; decimal outmoney = 0; decimal hasAmount = 0; DataTable dt = To_OrderPayDetialManager.getList(id); if (dt.Rows.Count > 0) { HtmlTableRow row = null; HtmlTableCell cell = null; for (int i = 0; i < dt.Rows.Count; i++) { //string[] result = GetPayStatusAndMoney(dt.Rows[i]["orderid"].ToString(), dt.Rows[i]["factid"].ToString(), dt.Rows[i]["payType"].ToString(), dt.Rows[i]["money"].ToString()); row = new HtmlTableRow(); cell = new HtmlTableCell(); //单位名称 //cell.Style.Add("height", "20px"); cell.Attributes.CssStyle.Add("height", "20px"); cell.InnerHtml = dt.Rows[i]["supName"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //付款类别 cell.InnerHtml = dt.Rows[i]["payType"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //联系人 cell.Attributes.Add("onclick", "getLink('" + dt.Rows[i]["factid"].ToString() + "','" + dt.Rows[i]["linkID"].ToString() + "')"); cell.InnerHtml = dt.Rows[i]["linkName"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //成人数 cell.InnerHtml = dt.Rows[i]["payNum"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //儿童数 cell.InnerHtml = dt.Rows[i]["payChildNum"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //金额 cell.InnerHtml = dt.Rows[i]["money"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //付款申请单 cell.InnerHtml = dt.Rows[i]["payConfirm"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //支付状态 cell.InnerHtml = dt.Rows[i]["payStatus"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //已支付金额 cell.InnerHtml = dt.Rows[i]["payAmount"].ToString(); row.Controls.Add(cell); cell = new HtmlTableCell(); //剩余金额 double symoney = getSurplus(dt.Rows[i]["money"].ToString(), dt.Rows[i]["payAmount"].ToString()); cell.InnerHtml = symoney.ToString("F2"); row.Controls.Add(cell); cell = new HtmlTableCell(); //备注 cell.InnerHtml = dt.Rows[i]["remark"].ToString(); row.Controls.Add(cell); this.tablebank.Controls.Add(row); //应付金额合计 outmoney = 0; decimal.TryParse(dt.Rows[i]["money"].ToString(), out outmoney); moneyAmount += outmoney; //实际支付金额合计 outmoney = 0; decimal.TryParse(dt.Rows[i]["payAmount"].ToString(), out outmoney); hasAmount += outmoney; } this.lblPayAmount.InnerText = moneyAmount.ToString("F2"); this.lblPayHasAmount.InnerText = hasAmount.ToString("F2"); } return(hasAmount); }