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