/// <summary> /// 更新一条数据 /// </summary> public bool UpdateLoanType(DimLoanTypeModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DimLoanType set "); strSql.Append(" Name = @Name "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 20) { Value = model.Name }, }; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocal, CommandType.Text, strSql.ToString(), parameters); return(rows > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public DimLoanTypeModel GetLoanTypeModel(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID, Name "); strSql.Append(" from DimLoanType "); if (!string.IsNullOrEmpty(strWhere)) { strSql.Append(" where " + strWhere); } DimLoanTypeModel model = new DimLoanTypeModel(); DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocal, CommandType.Text, strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { #region 给对象赋值 if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["Name"].ToString() != "") { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); } #endregion return(model); } return(null); }
public string AddLoanType(DimLoanTypeModel model, int type) { if (type == 1) //添加 { return(_bll.AddLoanType(model.Name) > 0 ? JsonConvert.SerializeObject(AlertHelper.SuccessMessage()) : JsonConvert.SerializeObject(AlertHelper.ErrorMessage())); } return(_bll.UpdateLoanType(model) ? JsonConvert.SerializeObject(AlertHelper.SuccessMessage("修改成功")) : JsonConvert.SerializeObject(AlertHelper.ErrorMessage("修改失败"))); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateLoanType(DimLoanTypeModel model) { return(_dal.UpdateLoanType(model)); }