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