private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
BLL.daikuan_repay bll = new BLL.daikuan_repay();
var list = bll.GetList("daikuan_id IN(select id FROM daikuan WHERE member_id=" + this.id + ")");
rptList.DataSource = list;
rptList.DataBind();
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
BLL.daikuan_repay bll = new BLL.daikuan_repay();
var list = bll.GetList(@" daikuan_id IN(select id FROM daikuan WHERE CONVERT(NVARCHAR(50),member_id) IN(
select * from dbo.f_split((select TOP 1 lb_person from daikuan where member_id=" + this.id + "),',')))");
rptList.DataSource = list;
rptList.DataBind();
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
BLL.daikuan_repay bll = new BLL.daikuan_repay();
var list = bll.GetList("daikuan_id=" + this.id);
rptList.DataSource = list;
rptList.DataBind();
var albumsList = new List <Model.daikuan_repay_albums>();
var dt = list.Tables[0];
foreach (DataRow item in dt.Rows)
{
var model = bll.GetModel(Utils.StrToInt(item["id"].ToString(), 0));
albumsList.AddRange(model.albums);
}
this.rptList2.DataSource = albumsList;
this.rptList2.DataBind();
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
BLL.daikuan bll = new BLL.daikuan();
BLL.daikuan_repay repayBll = new BLL.daikuan_repay();
var model = bll.GetModel(id);
var repayModel = new Model.daikuan_repay();
repayModel.daikuan_id = id;
repayModel.amount = Utils.StrToDecimal(txtAmount.Text.Trim(), 0);
repayModel.add_time = DateTime.Now;
model.yh_amount += repayModel.amount;
model.wh_amount = model.amount + model.zy_amount - model.yh_amount;
if (repayModel.amount == 0)
{
JscriptMsg("请填写正确金额！", "daikuan_repay.aspx?id=" + this.id);
return;
}
if (model.yh_amount > model.amount + model.zy_amount)
{
JscriptMsg("已还金额超出借款金额！", "daikuan_repay.aspx?id=" + this.id);
return;
}
if (model.wh_amount > 0)
{
model.hk_status = 0;
}
if (model.wh_amount == 0)
{
model.hk_status = 1;
}
#region 保存相册====================
string[] albumArr = Request.Form.GetValues("hid_photo_name");
string[] remarkArr = Request.Form.GetValues("hid_photo_remark");
string[] link_urlArr = Request.Form.GetValues("hid_photo_link_url");
if (albumArr != null && albumArr.Length > 0)
{
List <Model.daikuan_repay_albums> ls = new List <Model.daikuan_repay_albums>();
for (int i = 0; i < albumArr.Length; i++)
{
string[] imgArr = albumArr[i].Split('|');
if (imgArr.Length == 3)
{
if (!string.IsNullOrEmpty(link_urlArr[i]))
{
ls.Add(new Model.daikuan_repay_albums {
original_path = imgArr[1], thumb_path = imgArr[2], link_url = link_urlArr[i]
});
}
if (!string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.daikuan_repay_albums {
original_path = imgArr[1], thumb_path = imgArr[2], remark = remarkArr[i]
});
}
else
{
ls.Add(new Model.daikuan_repay_albums {
original_path = imgArr[1], thumb_path = imgArr[2]
});
}
}
}
repayModel.albums = ls;
}
#endregion
repayBll.Add(repayModel);
if (bll.Update(model))
{
JscriptMsg("还款成功！", "daikuan_manager_list.aspx");
}
}
