/// <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));
}
