/// <summary> /// 得到一个对象实体 /// </summary> public Model.daikuan_set DataRowToModel(DataRow row) { Model.daikuan_set model = new Model.daikuan_set(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["rate"] != null && row["rate"].ToString() != "") { model.rate = decimal.Parse(row["rate"].ToString()); } if (row["over_rate"] != null && row["over_rate"].ToString() != "") { model.over_rate = decimal.Parse(row["over_rate"].ToString()); } if (row["amount"] != null && row["amount"].ToString() != "") { model.amount = decimal.Parse(row["amount"].ToString()); } if (row["xiehui_id"] != null && row["xiehui_id"].ToString() != "") { model.xiehui_id = int.Parse(row["xiehui_id"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.daikuan_set model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update daikuan_set set "); strSql.Append("rate=@rate,"); strSql.Append("over_rate=@over_rate,"); strSql.Append("amount=@amount,"); strSql.Append("xiehui_id=@xiehui_id"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@rate", SqlDbType.Decimal, 9), new SqlParameter("@over_rate", SqlDbType.Decimal, 9), new SqlParameter("@amount", SqlDbType.Decimal, 9), new SqlParameter("@xiehui_id", SqlDbType.Int), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.rate; parameters[1].Value = model.over_rate; parameters[2].Value = model.amount; parameters[3].Value = model.xiehui_id; parameters[4].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int _id) { BLL.daikuan_set bll = new BLL.daikuan_set(); Model.daikuan_set model = bll.GetModel(_id); ddlXieHui.SelectedValue = model.xiehui_id.ToString(); txtRate.Text = model.rate.ToString(); txtOverRate.Text = model.over_rate.ToString(); txtAmount.Text = model.amount.ToString(); }
private void ShowInfo() { BLL.daikuan_set bll = new BLL.daikuan_set(); Model.daikuan_set model = bll.GetModel(1); if (model != null) { txtRate.Text = model.rate.ToString(); txtOverRate.Text = model.over_rate.ToString(); txtAmount.Text = model.amount.ToString(); } }
private bool DoAdd() { Model.daikuan_set model = new Model.daikuan_set(); BLL.daikuan_set bll = new BLL.daikuan_set(); model.xiehui_id = Utils.StrToInt(ddlXieHui.SelectedValue, 0); model.rate = Utils.StrToDecimal(txtRate.Text, 0); model.over_rate = Utils.StrToDecimal(txtOverRate.Text, 0); model.amount = Utils.StrToDecimal(txtAmount.Text, 0); if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加利率:" + model.rate); //记录日志 return(true); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.daikuan_set model) { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { #region 添加主表数据==================== StringBuilder strSql = new StringBuilder(); strSql.Append("insert into daikuan_set("); strSql.Append("rate,over_rate,amount,xiehui_id)"); strSql.Append(" values ("); strSql.Append("@rate,@over_rate,@amount,@xiehui_id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@rate", SqlDbType.Decimal, 9), new SqlParameter("@over_rate", SqlDbType.Decimal, 9), new SqlParameter("@amount", SqlDbType.Decimal, 9), new SqlParameter("@xiehui_id", SqlDbType.Int) }; parameters[0].Value = model.rate; parameters[1].Value = model.over_rate; parameters[2].Value = model.amount; parameters[3].Value = model.xiehui_id; //添加主表数据 object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务 model.id = Convert.ToInt32(obj); #endregion trans.Commit(); } catch { trans.Rollback(); return(0); } } } return(model.id); }
private bool DoEdit(int _id) { bool result = false; BLL.daikuan_set bll = new BLL.daikuan_set(); Model.daikuan_set model = bll.GetModel(_id); model.xiehui_id = Utils.StrToInt(ddlXieHui.SelectedValue, 0); model.rate = Utils.StrToDecimal(txtRate.Text, 0); model.over_rate = Utils.StrToDecimal(txtOverRate.Text, 0); model.amount = Utils.StrToDecimal(txtAmount.Text, 0); if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改利率:" + model.rate); //记录日志 result = true; } return(result); }
/// <summary> /// 保存配置信息 /// </summary> protected void btnSubmit_Click(object sender, EventArgs e) { BLL.daikuan_set bll = new BLL.daikuan_set(); var isExsit = bll.Exists(1); Model.daikuan_set model = new Model.daikuan_set(); if (isExsit) { model = bll.GetModel(1); } model.rate = Utils.ObjToDecimal(txtRate.Text, 0); model.over_rate = Utils.ObjToDecimal(txtOverRate.Text, 0); model.amount = Utils.ObjToDecimal(txtAmount.Text, 0); if (isExsit) { if (!bll.Update(model)) { JscriptMsg("保存过程中发生错误!", ""); return; } else { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改借款事项信息"); //记录日志 JscriptMsg("修改借款事项成功!", "daikuan_set.aspx"); } } else { if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加借款事项信息:"); //记录日志 } else { JscriptMsg("保存过程中发生错误!", ""); return; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.daikuan_set GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,rate,over_rate,amount,xiehui_id from daikuan_set "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.daikuan_set model = new Model.daikuan_set(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
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); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.daikuan_set model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.daikuan_set model) { return(dal.Add(model)); }