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