public static int UpdateAllPart(Model.mg_allpartModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update mg_allpart set "); strSql.Append("all_no=@all_no,"); strSql.Append("all_rateid=@all_rateid,"); strSql.Append("all_colorid=@all_colorid,"); strSql.Append("all_metaid=@all_metaid,"); strSql.Append("all_desc=@all_desc"); strSql.Append(" where all_id=@all_id "); SqlParameter[] parameters = { new SqlParameter("@all_id", SqlDbType.Int), new SqlParameter("@all_no", SqlDbType.NVarChar), new SqlParameter("@all_rateid", SqlDbType.Int), new SqlParameter("@all_colorid", SqlDbType.Int), new SqlParameter("@all_metaid", SqlDbType.Int), new SqlParameter("@all_desc", SqlDbType.NVarChar) }; parameters[0].Value = model.all_id; parameters[1].Value = model.all_no; parameters[2].Value = model.all_rateid; parameters[3].Value = model.all_colorid; parameters[4].Value = model.all_metaid; parameters[5].Value = model.all_desc; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, strSql.ToString(), parameters); return(rows); }
/* * 姜任鹏 * * */ public static int AddAllPart(Model.mg_allpartModel model) { string maxid = @"declare @i int; SELECT @i=max([all_id]) FROM [mg_allpart]; if @i is null begin set @i=1 end else begin set @i=@i+1 end; "; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into mg_allpart("); strSql.Append("all_id,all_no,all_rateid,all_colorid,all_metaid,all_desc)"); strSql.Append(" values ("); strSql.Append("@i,@all_no,@all_rateid,@all_colorid,@all_metaid,@all_desc)"); SqlParameter[] parameters = { new SqlParameter("@all_no", SqlDbType.NVarChar), new SqlParameter("@all_rateid", SqlDbType.Int), new SqlParameter("@all_colorid", SqlDbType.Int), new SqlParameter("@all_metaid", SqlDbType.Int), new SqlParameter("@all_desc", SqlDbType.NVarChar) }; parameters[0].Value = model.all_no; parameters[1].Value = model.all_rateid; parameters[2].Value = model.all_colorid; parameters[3].Value = model.all_metaid; parameters[4].Value = model.all_desc; int rows = SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, maxid + strSql, parameters); return(rows); }