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