//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("daikuan_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限
int sucCount = 0;
int errorCount = 0;
BLL.daikuan bll = new BLL.daikuan();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
if (bll.Delete(id))
{
sucCount += 1;
}
else
{
errorCount += 1;
}
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除协会会员" + sucCount + "条，失败" + errorCount + "条"); //记录日志
JscriptMsg("删除成功" + sucCount + "条，失败" + errorCount + "条！", Utils.CombUrlTxt("daikuan_list.aspx", "keywords={0}", this.keywords));
}
private void ShowInfo(int _id)
{
BLL.daikuan bll = new BLL.daikuan();
BLL.member memberBll = new BLL.member();
Model.daikuan model = bll.GetModel(_id);
txtName.Text = model.name;
if (!string.IsNullOrWhiteSpace(model.gender))
{
txtGender.Text = model.gender == "0" ? "男" : "女";
}
txtLevelName.Text = new BLL.member_level().GetName(Utils.StrToInt(model.level, 0));
txtIdCard.Text = model.id_card;
txtLevel.Text = model.level;
txtTel.Text = model.tel;
txtMember.Text = model.member_no;
txtCanAmount.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.can_amount), 0).ToString();
txtAmount.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.amount), 0).ToString();
txtMemberAmount.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.member_amount), 0).ToString();
txtPurpose.Text = model.purpose;
txtAddTime.Text = model.add_time.Value.ToString("yyyy-MM-dd HH:mm:ss");
txtMemberId.Text = model.member_id.ToString();
txtMonth.Text = model.month.ToString();
ddlChanYe.SelectedValue = model.chanye;
txtRemark.Text = model.remark;
if (!string.IsNullOrEmpty(model.lb_person))
{
txtLbIds.Text = model.lb_person;
txtLbNames.Text = model.lb_person_names;
}
//绑定图片相册
rptAlbumList.DataSource = model.albums;
rptAlbumList.DataBind();
}
private void RptBind(string _strWhere, string _orderby)
{
BLL.daikuan bll = new BLL.daikuan();
this.rptList.DataSource = bll.GetList("");
this.rptList.DataBind();
//绑定页码
string pageUrl = Utils.CombUrlTxt("center.aspx", "keywords={0}&page={1}", "", "__id__");
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
BLL.daikuan bll = new BLL.daikuan();
bll.UpdateField(id, "status=2");
var reason = txtReason.Text.Trim();
bll.UpdateField(id, "reason='" + reason + "'");
JscriptMsg("驳回借款成功！", Utils.CombUrlTxt("daikuan_audit_list.aspx", "keywords={0}", this.keywords));
}
protected void Page_Load(object sender, EventArgs e)
{
this.id = Utils.StrToInt(DTRequest.GetQueryString("id"), 0);
BLL.daikuan bll = new BLL.daikuan();
var model = bll.GetModel(id);
txtDkAmount.Text = model.amount.ToString();
txtYhAmount.Text = model.yh_amount.ToString();
txtWhAmount.Text = model.wh_amount.ToString();
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
BLL.daikuan bll = new BLL.daikuan();
this.rptList.DataSource = bll.GetWarnList(this.pageSize, this.page, "status=1 and hk_status<>1 and DATEDIFF(day, getdate(),(DATEADD(month,[month],audit_time))) <=31", _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("daikuan_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.daikuan bll = new BLL.daikuan();
this.rptList.DataSource = bll.GetMemberList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("member_exit_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
protected void Page_Load(object sender, EventArgs e)
{
this.keywords = DTRequest.GetQueryString("keywords");
this.id = Utils.StrToInt(DTRequest.GetQueryString("id"), 0);
if (!Page.IsPostBack)
{
BLL.daikuan bll = new BLL.daikuan();
Model.daikuan model = bll.GetModel(this.id);
//绑定图片相册
rptList2.DataSource = model.albums;
rptList2.DataBind();
var lbIds = model.lb_person;
RptBind("id>0 and id in(" + lbIds + ")", "add_time asc,id desc");
}
}
//批量审核
protected void btnAudit_Click(object sender, EventArgs e)
{
BLL.daikuan bll = new BLL.daikuan();
Repeater rptList = new Repeater();
rptList = this.rptList;
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
bll.UpdateField(id, "status=1");
bll.UpdateField(id, "audit_time='" + DateTime.Now + "'");
}
}
AddAdminLog(DTEnums.ActionEnum.Audit.ToString(), "审核频道内容信息"); //记录日志
JscriptMsg("批量审核成功！", Utils.CombUrlTxt("daikuan_audit_list.aspx", "keywords={0}", this.keywords));
}
private List <TotalEntity> GetStatisList()
{
BLL.daikuan bll = new BLL.daikuan();
BLL.member memberBll = new BLL.member();
//已通过贷款数量
var daikuanCount = bll.GetRecordCount(" status=1");
//会员数量
var memberCount = memberBll.GetRecordCount("");
//新增会员数量
var newMemberCount = memberBll.GetRecordCount(" add_time>='" + DateTime.Now.Date + "'");
var exitCount = memberBll.GetRecordCount(" is_delete=1");
var list = new List <TotalEntity>()
{
new TotalEntity()
{
DaikuanCount = daikuanCount, MemberCount = memberCount, NewMemCount = newMemberCount, ExitCount = exitCount
}
};
return(list);
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.daikuan bll = new BLL.daikuan();
Model.daikuan model = bll.GetModel(_id);
model.member_id = Utils.StrToInt(txtMemberId.Text, 0);
model.name = txtName.Text.Trim();
model.level = txtLevel.Text.Trim();
if (!string.IsNullOrWhiteSpace(txtGender.Text.Trim()))
{
model.gender = txtGender.Text.Trim() == "男" ? "0" : "1";
}
model.id_card = txtIdCard.Text.Trim();
model.tel = txtTel.Text.Trim();
model.member_no = txtMember.Text.Trim();
model.can_amount = Utils.StrToDecimal(txtCanAmount.Text, 0);
model.amount = Utils.StrToDecimal(txtAmount.Text, 0);
model.member_amount = Utils.StrToDecimal(txtMemberAmount.Text, 0);
model.purpose = txtPurpose.Text.Trim();
model.add_time = Utils.StrToDateTime(txtAddTime.Text.Trim());
model.lb_person = txtLbIds.Text.ToString();
model.lb_person_names = txtLbNames.Text.ToString();
model.month = Utils.StrToInt(txtMonth.Text, 0);
model.chanye = ddlChanYe.SelectedValue;
model.remark = txtRemark.Text.Trim().ToString();
#region 保存相册====================
//检查是否有自定义图片
if (model.albums != null)
{
model.albums.Clear();
}
string[] albumArr = Request.Form.GetValues("hid_photo_name");
string[] remarkArr = Request.Form.GetValues("hid_photo_remark");
string[] linkUrlArr = Request.Form.GetValues("hid_photo_link_url");
if (albumArr != null)
{
List <Model.daikuan_albums> ls = new List <Model.daikuan_albums>();
for (int i = 0; i < albumArr.Length; i++)
{
string[] imgArr = albumArr[i].Split('|');
int img_id = Utils.StrToInt(imgArr[0], 0);
if (imgArr.Length == 3)
{
if (linkUrlArr != null && !string.IsNullOrEmpty(linkUrlArr[i]) && !string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.daikuan_albums {
id = img_id, daikuan_id = _id, original_path = imgArr[1], thumb_path = imgArr[2], remark = remarkArr[i], link_url = linkUrlArr[i]
});
}
else if (linkUrlArr != null && !string.IsNullOrEmpty(remarkArr[i]) && string.IsNullOrEmpty(linkUrlArr[i]))
{
ls.Add(new Model.daikuan_albums {
id = img_id, daikuan_id = _id, original_path = imgArr[1], thumb_path = imgArr[2], remark = remarkArr[i]
});
}
else if (linkUrlArr != null && !string.IsNullOrEmpty(linkUrlArr[i]) && string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.daikuan_albums {
id = img_id, daikuan_id = _id, original_path = imgArr[1], thumb_path = imgArr[2], link_url = linkUrlArr[i]
});
}
else
{
ls.Add(new Model.daikuan_albums {
id = img_id, daikuan_id = _id, original_path = imgArr[1], thumb_path = imgArr[2]
});
}
}
}
model.albums = ls;
}
#endregion
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改借款信息:" + model.name); //记录日志
result = true;
}
return(result);
}
private bool DoAdd()
{
Model.daikuan model = new Model.daikuan();
BLL.daikuan bll = new BLL.daikuan();
model.member_id = Utils.StrToInt(txtMemberId.Text, 0);
model.name = txtName.Text.Trim();
if (!string.IsNullOrWhiteSpace(txtGender.Text.Trim()))
{
model.gender = txtGender.Text.Trim() == "男" ? "0" : "1";
}
model.id_card = txtIdCard.Text.Trim();
model.tel = txtTel.Text.Trim();
model.level = txtLevel.Text.Trim();
model.member_no = txtMember.Text.Trim();
model.can_amount = Utils.StrToDecimal(txtCanAmount.Text, 0);
model.amount = Utils.StrToDecimal(txtAmount.Text, 0);
model.purpose = txtPurpose.Text.Trim();
model.add_time = Utils.StrToDateTime(txtAddTime.Text.Trim());
model.lb_person = txtLbIds.Text.ToString();
model.lb_person_names = txtLbNames.Text.ToString();
model.month = Utils.StrToInt(txtMonth.Text, 0);
model.member_amount = Utils.StrToDecimal(txtMemberAmount.Text, 0);
model.chanye = ddlChanYe.SelectedValue;
model.remark = txtRemark.Text.Trim().ToString();
BLL.daikuan_set setBll = new BLL.daikuan_set();
var isExsit = setBll.Exists(1);
Model.daikuan_set setModel = new Model.daikuan_set();
if (isExsit)
{
setModel = setBll.GetModel(1);
model.zy_amount = model.amount * (setModel.rate * 0.01m);
model.wh_amount = model.amount + model.zy_amount;
}
#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_albums> ls = new List <Model.daikuan_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_albums {
original_path = imgArr[1], thumb_path = imgArr[2], link_url = link_urlArr[i]
});
}
if (!string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.daikuan_albums {
original_path = imgArr[1], thumb_path = imgArr[2], remark = remarkArr[i]
});
}
else
{
ls.Add(new Model.daikuan_albums {
original_path = imgArr[1], thumb_path = imgArr[2]
});
}
}
}
model.albums = ls;
}
#endregion
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加借款信息:" + model.name); //记录日志
return(true);
}
return(false);
}
//保存
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");
}
}
