/// <summary> /// 得到一个对象实体 /// </summary> public M_Overdue_repayment DataRowToModel(DataRow row) { M_Overdue_repayment model = new M_Overdue_repayment(); if (row != null) { if (row["overdue_repayment_id"] != null && row["overdue_repayment_id"].ToString() != "") { model.overdue_repayment_id = int.Parse(row["overdue_repayment_id"].ToString()); } if (row["repayment_plan_id"] != null && row["repayment_plan_id"].ToString() != "") { model.repayment_plan_id = int.Parse(row["repayment_plan_id"].ToString()); } if (row["membertable_registerid"] != null && row["membertable_registerid"].ToString() != "") { model.membertable_registerid = int.Parse(row["membertable_registerid"].ToString()); } if (row["targetid"] != null && row["targetid"].ToString() != "") { model.targetid = int.Parse(row["targetid"].ToString()); } if (row["loan_management_fee"] != null && row["loan_management_fee"].ToString() != "") { model.loan_management_fee = decimal.Parse(row["loan_management_fee"].ToString()); } if (row["ordinary_overdue_management_fees"] != null && row["ordinary_overdue_management_fees"].ToString() != "") { model.ordinary_overdue_management_fees = decimal.Parse(row["ordinary_overdue_management_fees"].ToString()); } if (row["seriously_overdue_management_fees"] != null && row["seriously_overdue_management_fees"].ToString() != "") { model.seriously_overdue_management_fees = decimal.Parse(row["seriously_overdue_management_fees"].ToString()); } if (row["ordinary_overdue_penalty"] != null && row["ordinary_overdue_penalty"].ToString() != "") { model.ordinary_overdue_penalty = decimal.Parse(row["ordinary_overdue_penalty"].ToString()); } if (row["seriously_overdue_penalty"] != null && row["seriously_overdue_penalty"].ToString() != "") { model.seriously_overdue_penalty = decimal.Parse(row["seriously_overdue_penalty"].ToString()); } if (row["actual_repayment_time"] != null && row["actual_repayment_time"].ToString() != "") { model.actual_repayment_time = DateTime.Parse(row["actual_repayment_time"].ToString()); } if (row["overdue_days"] != null && row["overdue_days"].ToString() != "") { model.overdue_days = int.Parse(row["overdue_days"].ToString()); } if (row["interest_state"] != null && row["interest_state"].ToString() != "") { model.interest_state = int.Parse(row["interest_state"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(M_Overdue_repayment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Overdue_repayment set "); strSql.Append("repayment_plan_id=@repayment_plan_id,"); strSql.Append("membertable_registerid=@membertable_registerid,"); strSql.Append("targetid=@targetid,"); strSql.Append("loan_management_fee=@loan_management_fee,"); strSql.Append("ordinary_overdue_management_fees=@ordinary_overdue_management_fees,"); strSql.Append("seriously_overdue_management_fees=@seriously_overdue_management_fees,"); strSql.Append("ordinary_overdue_penalty=@ordinary_overdue_penalty,"); strSql.Append("seriously_overdue_penalty=@seriously_overdue_penalty,"); strSql.Append("actual_repayment_time=@actual_repayment_time,"); strSql.Append("overdue_days=@overdue_days,"); strSql.Append("interest_state=@interest_state"); strSql.Append(" where overdue_repayment_id=@overdue_repayment_id"); SqlParameter[] parameters = { new SqlParameter("@repayment_plan_id", SqlDbType.Int, 4), new SqlParameter("@membertable_registerid", SqlDbType.Int, 4), new SqlParameter("@targetid", SqlDbType.Int, 4), new SqlParameter("@loan_management_fee", SqlDbType.Decimal, 17), new SqlParameter("@ordinary_overdue_management_fees", SqlDbType.Decimal, 17), new SqlParameter("@seriously_overdue_management_fees", SqlDbType.Decimal, 17), new SqlParameter("@ordinary_overdue_penalty", SqlDbType.Decimal, 17), new SqlParameter("@seriously_overdue_penalty", SqlDbType.Decimal, 17), new SqlParameter("@actual_repayment_time", SqlDbType.DateTime), new SqlParameter("@overdue_days", SqlDbType.Int, 4), new SqlParameter("@interest_state", SqlDbType.Int, 4), new SqlParameter("@overdue_repayment_id", SqlDbType.Int, 4) }; parameters[0].Value = model.repayment_plan_id; parameters[1].Value = model.membertable_registerid; parameters[2].Value = model.targetid; parameters[3].Value = model.loan_management_fee; parameters[4].Value = model.ordinary_overdue_management_fees; parameters[5].Value = model.seriously_overdue_management_fees; parameters[6].Value = model.ordinary_overdue_penalty; parameters[7].Value = model.seriously_overdue_penalty; parameters[8].Value = model.actual_repayment_time; parameters[9].Value = model.overdue_days; parameters[10].Value = model.interest_state; parameters[11].Value = model.overdue_repayment_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(M_Overdue_repayment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Overdue_repayment("); strSql.Append("repayment_plan_id,membertable_registerid,targetid,loan_management_fee,ordinary_overdue_management_fees,seriously_overdue_management_fees,ordinary_overdue_penalty,seriously_overdue_penalty,actual_repayment_time,overdue_days,interest_state)"); strSql.Append(" values ("); strSql.Append("@repayment_plan_id,@membertable_registerid,@targetid,@loan_management_fee,@ordinary_overdue_management_fees,@seriously_overdue_management_fees,@ordinary_overdue_penalty,@seriously_overdue_penalty,@actual_repayment_time,@overdue_days,@interest_state)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@repayment_plan_id", SqlDbType.Int, 4), new SqlParameter("@membertable_registerid", SqlDbType.Int, 4), new SqlParameter("@targetid", SqlDbType.Int, 4), new SqlParameter("@loan_management_fee", SqlDbType.Decimal, 17), new SqlParameter("@ordinary_overdue_management_fees", SqlDbType.Decimal, 17), new SqlParameter("@seriously_overdue_management_fees", SqlDbType.Decimal, 17), new SqlParameter("@ordinary_overdue_penalty", SqlDbType.Decimal, 17), new SqlParameter("@seriously_overdue_penalty", SqlDbType.Decimal, 17), new SqlParameter("@actual_repayment_time", SqlDbType.DateTime), new SqlParameter("@overdue_days", SqlDbType.Int, 4), new SqlParameter("@interest_state", SqlDbType.Int, 4) }; parameters[0].Value = model.repayment_plan_id; parameters[1].Value = model.membertable_registerid; parameters[2].Value = model.targetid; parameters[3].Value = model.loan_management_fee; parameters[4].Value = model.ordinary_overdue_management_fees; parameters[5].Value = model.seriously_overdue_management_fees; parameters[6].Value = model.ordinary_overdue_penalty; parameters[7].Value = model.seriously_overdue_penalty; parameters[8].Value = model.actual_repayment_time; parameters[9].Value = model.overdue_days; parameters[10].Value = model.interest_state; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public M_Overdue_repayment GetModel(int overdue_repayment_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 overdue_repayment_id,repayment_plan_id,membertable_registerid,targetid,loan_management_fee,ordinary_overdue_management_fees,seriously_overdue_management_fees,ordinary_overdue_penalty,seriously_overdue_penalty,actual_repayment_time,overdue_days,interest_state from Overdue_repayment "); strSql.Append(" where overdue_repayment_id=@overdue_repayment_id"); SqlParameter[] parameters = { new SqlParameter("@overdue_repayment_id", SqlDbType.Int, 4) }; parameters[0].Value = overdue_repayment_id; M_Overdue_repayment model = new M_Overdue_repayment(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(M_Overdue_repayment model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(M_Overdue_repayment model) { return(dal.Add(model)); }