public static int updateSm_Set(basicSetModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update sm_set set paravalue=@paravalue ,remark=@ramark where paraname=@paraname ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@paravalue", model.Paravalue), new SqlParameter("@ramark", model.Remark), new SqlParameter("@paraname", model.Paraname) };
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public static int addSm_Set(basicSetModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into sm_set values(@paraid,@paraname,@paravalue,@remark)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@paraid", SqlDbType.NVarChar, 50), new SqlParameter("@paraname", SqlDbType.NVarChar, 100), new SqlParameter("@paravalue", SqlDbType.NVarChar, 100), new SqlParameter("@remark", SqlDbType.NVarChar, 200) };
commandParameters[0].Value = Guid.NewGuid().ToString();
commandParameters[1].Value = model.Paraname;
commandParameters[2].Value = model.Paravalue;
commandParameters[3].Value = model.Remark;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public static int update(basicSetModel model)
{
return(basicSetDal.updateSm_Set(model));
}
public static int add(basicSetModel model)
{
return(basicSetDal.addSm_Set(model));
}
