private void LoadPolicyList(int salesman, int payerID, int payerType, string receiptType)
{
ViewBudgetIncomeManager budgetBLL = new ViewBudgetIncomeManager();
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" policySalesman={0} ", salesman);
sql.AppendFormat(" and {0} is not null ", receiptType);
sql.AppendFormat(" and auditstatus = '04' ");
if (payerType == 1)
{
sql.AppendFormat(" and company={0} ", payerID);
}
else
{
sql.AppendFormat(" and customer={0} ", payerID);
}
sql.AppendFormat(" and ({0} >realAmount or realAmount is null) ", receiptType);
//Data data = new Data();
//DataSet ds = data.DataPage("ViewClaim", "policyID", "*", sql.ToString(), "policyID", true, 10, 5, pages);
RpPolicyList.DataSource = budgetBLL.GetListByPage(sql.ToString());
RpPolicyList.DataBind();
}
/// <summary>
/// 绑定订单信息中的退款信息
/// </summary>
/// <param name="payer"></param>
private void LoadOrderReturnDetail()
{
string payer = Request.QueryString["payer"];
string sql = " cusid= " + payer + " and iscancel='N' ";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
sql += " order by outTime desc";
sql += strsql;
RpPolicyList.DataSource = To_OrderInfoManager.GetViewOrderReturn("", sql);
RpPolicyList.DataBind();
}
/// <summary>
/// 得到订单信息
/// </summary>
/// <param name="payer"></param>
/// <param name="paytype"></param>
private void To_OrderCollectDetial()
{
string payer = Request.QueryString["payer"];
string paytype = Request.QueryString["type"];
string sql = " factid = " + payer + " and payType='" + paytype + "' and iscancel='N' ";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
sql += strsql;
sql += " order by outTime desc";
RpPolicyList.DataSource = To_OrderInfoManager.GetViewOrder("", sql.ToString());
RpPolicyList.DataBind();
}
/// <summary>
/// 加载所要选择的认领订单
/// </summary>
private void LoadOrderList()
{
string payerId = Request.QueryString["payer"];
string sql = " iscancel='N'";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
if (payerId != "")
{
sql += " and cusId = " + payerId;
}
sql += " order by outTime desc ";
DataTable dt = new DataTable();
dt = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
RpPolicyList.DataSource = dt;
RpPolicyList.DataBind();
}
/// <summary>
/// 加载保单数据
/// </summary>
/// <param name="payer">付款单位ID</param>
/// <param name="payerType">付款单位类别，0：客户；1：公司</param>
/// <param name="payFor">付款单位名称</param>
private void LoadPolicyList(string payer, string payerType, string payFor)
{
To_PaymentManager b_payment = new To_PaymentManager();
StringBuilder whereBuilder = new StringBuilder();
string payerField = payerType == "0" ? "customer" : "company";
whereBuilder.AppendFormat("AND {0}={1} AND ( payerType = {2} or payerType is null or payFor is null ) ", payerField, payer, payerType);
//if (withInvoice == "1")
//{
// whereBuilder.Append("AND invoiceID IS NOT NULL ");
//}
RpPolicyList.DataSource = b_payment.GetPaymentInvoice(whereBuilder.ToString(), payFor);
RpPolicyList.DataBind();
}
/// <summary>
/// 根据收款单据ID查询认领明细
/// </summary>
/// <param name="collcetingID"></param>
/// <returns></returns>
private void LoadClaimDetail(int collcetingID)
{
RpPolicyList.DataSource = To_CollectingManager.GetClaimDetail(collcetingID);
RpPolicyList.DataBind();
}