/// <summary>
/// 得到已经认领的金额
/// </summary>
/// <param name="collecId"></param>
/// <returns></returns>
protected string GetHasAmount(object collectid)
{
To_ClaimDetailManager to_claimDetail = new To_ClaimDetailManager();
double hasAmount = to_claimDetail.GetHasAmount(collectid.ToString());
return(hasAmount.ToString("F2"));
}
public void Del(HttpContext context)
{
string id = context.Request.QueryString["claimDetailId"];
To_ClaimDetailManager claimDetailManager = new To_ClaimDetailManager();
claimDetailManager.Delete(int.Parse(id));
}
/// <summary>
/// 根据收款单据ID查询认领明细
/// </summary>
/// <param name="collcetingID"></param>
/// <returns></returns>
private void LoadClaimDetail(int collcetingID)
{
To_ClaimManager claimManager = new To_ClaimManager();
To_ClaimDetailManager claimDetailManager = new To_ClaimDetailManager();
string claimId = claimManager.GetFiledValue(collcetingID, "ID");
if (claimId != "")
{
RpClaimDetail.DataSource = claimDetailManager.GetHasDetail(" claimID=" + claimId);
RpClaimDetail.DataBind();
}
}
/// <summary>
/// 加载已经认领过的认领明细数据
/// </summary>
/// <param name="claimId"></param>
private void LoadClaimDetail(string claimId)
{
To_ClaimDetailManager claimDetailManager = new To_ClaimDetailManager();
DataTable dt = claimDetailManager.GetHasDetail("claimID = " + claimId);
this.RpClaimDetailList.DataSource = dt;
this.RpClaimDetailList.DataBind();
double hasSum = 0.00;
for (int i = 0; i < dt.Rows.Count; i++)
{
hasSum += Convert.ToDouble(dt.Rows[i]["realAmount"]);
}
this.hasSumBox.InnerText = hasSum.ToString("F2");
}
/// <summary>
/// 得到可认领金额
/// </summary>
/// <param name="money"></param>
/// <param name="collecId"></param>
/// <param name="CusId"></param>
/// <returns></returns>
protected string GetCanAmount(object money, object collectid)
{
To_ClaimDetailManager to_claimDetail = new To_ClaimDetailManager();
double hasAmount = to_claimDetail.GetHasAmount(collectid.ToString());
double Amount = double.Parse(money.ToString());
if (Amount != 0)
{
return((Amount - hasAmount).ToString("F2"));
}
else
{
return(Amount.ToString());
}
}
/// <summary>
/// 取消认领
/// </summary>
/// <param name="id"></param>
private void CancelClaim(int id)
{
To_ClaimManager b_claim = new To_ClaimManager();
To_ClaimDetailManager b_claimDetail = new To_ClaimDetailManager();
string claimID = b_claim.GetID(id);
if (claimID != "" && b_claim.Delete(int.Parse(claimID)))
{
b_claimDetail.DeleteByClaim(claimID);
}
To_CollectingManager.ChangeClaim(id, 0);
}
/// <summary>
/// 取消认领
/// </summary>
/// <param name="id"></param>
private void CancelClaim(int id)
{
To_ClaimManager b_claim = new To_ClaimManager();
To_ClaimDetailManager b_claimDetail = new To_ClaimDetailManager();
string claimID = b_claim.GetID(id);
DataTable dt = b_claimDetail.GetHasDetail(" claimID=" + claimID);
if (claimID != "" && b_claim.Delete(int.Parse(claimID)))
{
b_claimDetail.DeleteByClaim(claimID);
}
To_CollectingManager.ChangeClaim(id, 0);
UpdateOrderColect(dt);
}
protected void ibtnDeleteAll_Click(object sender, ImageClickEventArgs e)
{
string delId = "";
//先遍历取得选中项
for (int i = 0; i < this.rpCollecting.Items.Count; i++)
{
CheckBox cbx = (CheckBox)(rpCollecting.Items[i].FindControl("cbx"));
Label lbl = (Label)rpCollecting.Items[i].FindControl("lbl");
if (cbx != null || cbx.Text != "")
{
if (cbx.Checked)
{
delId += lbl.Text + ",";
}
}
}
//去掉最后一个,
delId = (delId + ")").Replace(",)", "");
IList check = delId.Split(',');
To_ClaimManager b_claim = new To_ClaimManager();
To_ClaimDetailManager b_claimDetail = new To_ClaimDetailManager();
for (int i = 0; i < check.Count; i++)
{
To_Collecting to_Collecting = To_CollectingManager.getTo_CollectingById(Convert.ToInt32(check[i]));
if (to_Collecting != null)
{
To_CollectingManager.deleteTo_Collecting(Convert.ToInt32(check[i]));
}
string claimID = b_claim.GetID(Convert.ToInt32(check[i]));
if (claimID != "" && b_claim.Delete(int.Parse(claimID)))
{
b_claimDetail.DeleteByClaim(claimID);
}
}
dataBind();
}
/// <summary>
/// 得到已经收款的明细数据
/// </summary>
/// <param name="ordercollectid"></param>
/// <returns></returns>
public string getHasCollectDetail(object ordercollectid)
{
StringBuilder str = new StringBuilder();
str.Append("<table border='1' >");
str.Append("<tr><th width='90px'>收款日期</th><th width='200px'>收款单位</th><th width='70px'>收款金额</th><th width='70px'>收款方式</th><th width='70px'>总金额</th><th width='200px'>银行名称</th><th width='200px'>备注</th></tr>");
DataTable dt = new To_ClaimDetailManager().GetCollectDetail(" orderCollectId =" + ordercollectid);
for (int i = 0; i < dt.Rows.Count; i++)
{
double money = Convert.IsDBNull(dt.Rows[i]["realAmount"]) ? 0.0 : Convert.ToDouble(dt.Rows[i]["realAmount"]);
str.Append("<tr><td>" + Convert.ToDateTime(dt.Rows[i]["receiptDate"]).ToString("yyyy-MM-dd") + "</td>"); //收款日期
str.Append("<td>" + dt.Rows[i]["payer"].ToString() + "</td>"); //收款单位
str.Append("<td>" + money.ToString("F2") + "</td>"); //收款金额
str.Append("<td>" + getPayModel(dt.Rows[i]["paymentMode"]) + "</td>"); //收款方式
str.Append("<td>" + Convert.ToDouble(dt.Rows[i]["receiptAmount"]).ToString("F2") + "</td>"); //总金额
str.Append("<td>" + dt.Rows[i]["payBank"].ToString() + "</td>"); //银行名称
str.Append("<td>" + dt.Rows[i]["mark"].ToString() + "</td></tr>"); //备注
}
str.Append("</table>");
return(str.ToString());
}
protected void rpCollecting_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument);
int count = To_CollectingManager.deleteTo_Collecting(id);
To_ClaimManager b_claim = new To_ClaimManager();
To_ClaimDetailManager b_claimDetail = new To_ClaimDetailManager();
if (count <= 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "page", "alert('删除失败')", true);
return;
}
string claimID = b_claim.GetID(id);
if (claimID != "" && b_claim.Delete(int.Parse(claimID)))
{
b_claimDetail.DeleteByClaim(claimID);
}
}
dataBind();
}
/// <summary>
/// 得到状态
/// </summary>
/// <param name="ordercolid"></param>
/// <param name="money"></param>
/// <returns></returns>
public string getStatus(string ordercolid, string money)
{
To_ClaimDetailManager manager = new To_ClaimDetailManager();
double hasAmount = manager.GetHasAmount(ordercolid);
double shouldAmount = 0;
double.TryParse(money, out shouldAmount);
if (hasAmount == 0)
{
return("0");
}
else
{
if (shouldAmount > hasAmount)
{
return("1");
}
else
{
return("2");
}
}
}
/// <summary>
/// 得到收款状态和收款金额
/// </summary>
/// <param name="orderid"></param>
/// <param name="cusid"></param>
/// <param name="money"></param>
/// <returns></returns>
private string GetColStatusAndAmount(string colid, string money)
{
To_ClaimDetailManager claimDetailManager = new To_ClaimDetailManager();
double hasAmount = claimDetailManager.GetHasAmount(colid);
double shouldAmount = 0;
double.TryParse(money, out shouldAmount);
if (hasAmount == 0)
{
return("未收款," + hasAmount.ToString("F2"));
}
else
{
if (shouldAmount > hasAmount)
{
return("部分收款," + hasAmount.ToString("F2"));
}
else
{
return("完成收款," + hasAmount.ToString("F2"));
}
}
}
/// <summary>
/// 更新订单的收款信息
/// </summary>
/// <param name="dt"></param>
private void UpdateOrderColect(DataTable dt)
{
To_ClaimDetailManager manage = new To_ClaimDetailManager();
for (int i = 0; i < dt.Rows.Count; i++)
{
double hasAmount = manage.GetHasAmount(dt.Rows[i]["orderCollectId"].ToString());
double shouldAmount = Convert.IsDBNull(dt.Rows[i]["money"]) ? 0 : Convert.ToDouble(dt.Rows[i]["money"]);
string getstatsu = "";
if (hasAmount == 0)
{
getstatsu = "未收款";
}
else if (shouldAmount > hasAmount)
{
getstatsu = "部分收款";
}
else
{
getstatsu = "完成收款";
}
To_OrderCollectDetialManager.updateDetialStatusAndMoney(dt.Rows[i]["orderCollectId"].ToString(), getstatsu, hasAmount.ToString());
}
}
protected void BtnSubmit_Click(object sender, ImageClickEventArgs e)
{
To_ClaimManager b_claim = new To_ClaimManager();
To_Claim m_claim = new To_Claim();
Step1 step1 = Context.Handler as Step1;
m_claim.collectingID = Convert.ToInt32(Request.QueryString["id"]);
m_claim.costType = HidReceiptType.Value;
m_claim.payer = HidPayer.Value;
m_claim.payerID = int.Parse(HidPayerID.Value);
m_claim.payerType = int.Parse(HidPayerType.Value);
m_claim.salesman = HidSalesman.Value;
m_claim.salesmanID = int.Parse(HidSalesmanID.Value);
m_claim.makerID = (Session["login"] as LoginInfo).Id;
int claimID = b_claim.Add(m_claim);
if (claimID != 0)
{
To_CollectingManager.ChangeClaim(Convert.ToInt32(Request.QueryString["id"]), chkFinish.Checked ? 2 : 1);
if (chkFinish.Checked)
{
SendMessage(m_claim.collectingID, HidSalesman.Value, 1);
}
else
{
SendMessage(m_claim.collectingID, HidSalesman.Value, 0);
}
if (HidClaimDetail.Value.Trim() != string.Empty)
{
string[] items = HidClaimDetail.Value.Trim().TrimEnd('@').Split('@');
if (items.Length > 0)
{
To_ClaimDetailManager b_claimDetail = new To_ClaimDetailManager();
To_ClaimDetail m_claimDetail = new To_ClaimDetail();
foreach (string item in items)
{
string[] detail = item.Trim().Split('$');
if (detail.Length > 0)
{
int policyID = int.Parse(detail[0].Trim());
decimal amount = decimal.Parse(detail[1].Trim().TrimStart('¥').TrimStart('￥'));
decimal realAmount = decimal.Parse(detail[2].Trim());
m_claimDetail.claimID = claimID;
m_claimDetail.mark = "";
m_claimDetail.policyID = policyID;
m_claimDetail.realAmount = realAmount;
m_claimDetail.receiptAmount = amount;
m_claimDetail.receiptStatusCode = 0;
b_claimDetail.Add(m_claimDetail);
}
}
}
}
ClientScript.RegisterClientScriptBlock(this.GetType(), "page", "alert('认领成功');self.location.href='../FundsAllocation.aspx';", true);
}
}
/// <summary>
/// 保存收款认领明细数据的方法
/// </summary>
/// <param name="claimId">收款认领单id</param>
/// <param name="collectId">收款单id</param>
private void SaveClaimDetail(int claimId, int collectId)
{
IList <string> orderColectIDs = new List <string>();
To_CollectingManager.ChangeClaim(Convert.ToInt32(Request.QueryString["id"]), chkFinish.Checked ? 2 : 1);
if (chkFinish.Checked)
{
SendMessage(collectId, LblMaker.Text, 1);
}
else
{
SendMessage(collectId, LblMaker.Text, 0);
}
if (HidClaimDetail.Value.Trim() != string.Empty)
{
To_ClaimDetailManager claimDetailManager = new To_ClaimDetailManager();
string[] items = HidClaimDetail.Value.Trim().TrimEnd('@').Split('@');
if (items.Length > 0)
{
To_ClaimDetail claimDetail = new To_ClaimDetail();
foreach (string item in items)
{
string[] detail = item.Trim().Split('$');
if (detail.Length > 0)
{
claimDetail.claimID = claimId; //收款单id
claimDetail.orderCollectId = int.Parse(detail[0]); //订单表收款信息明细表id
if (!orderColectIDs.Contains(detail[0]))
{
orderColectIDs.Add(detail[0]);
}
claimDetail.orderCusId = int.Parse(hidComID.Value); //付款单位id
claimDetail.orderNum = detail[1]; //订单编号
claimDetail.receiptAmount = decimal.Parse(detail[2]); //应收金额（在编辑的时候还是要去该订单表收款明细的应收金额，因为这个应收金额可能会变）
claimDetail.realAmount = decimal.Parse(detail[3]); //本次收款金额
claimDetail.mark = detail[4]; //备注
claimDetailManager.Add(claimDetail);
}
}
}
//更新收款信息明细表的收款状态和实际收款金额
for (int i = 0; i < orderColectIDs.Count; i++)
{
if (orderColectIDs[i] != "")
{
double hasAmount = claimDetailManager.GetHasAmount(orderColectIDs[i]); //得到该收款信息明细表关联的所有认领过的金额
double shouldAmount = To_OrderCollectDetialManager.getTo_OrderCollectDetialById(int.Parse(orderColectIDs[i])).Money; //得到应收金额
string getstatus = "";
if (hasAmount == 0)
{
getstatus = "未收款";
}
else if (shouldAmount > hasAmount)
{
getstatus = "部分收款";
}
else
{
getstatus = "完成收款";
}
To_OrderCollectDetialManager.updateDetialStatusAndMoney(orderColectIDs[i], getstatus, hasAmount.ToString());
}
}
}
}
