//批量删除 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"); } }