public int UpdateTemp(TempData message, int userId)
{
SqlParameter[] parms = {
new SqlParameter("@temp_id",SqlDbType.Int,4),
new SqlParameter("@temp_type",SqlDbType.Int,4),
new SqlParameter("@temp_name",SqlDbType.VarChar,50),
new SqlParameter("@temp_html",SqlDbType.Text,999999999),
new SqlParameter("@flag",SqlDbType.Int,4),
new SqlParameter("@user",SqlDbType.Int,4)
};
parms[0].Value = message.TempId;
parms[1].Value = message.TempType;
parms[2].Value = message.TempName;
parms[3].Value = message.TempHtml;
parms[4].Value = message.Flag;
parms[5].Value = userId;
int resuleNum = cmddal.RunProc("zcms_temp_update", parms);
return resuleNum;
}
{
SqlParameter[] parms = {
new SqlParameter("@temp_id",SqlDbType.Int,4),
new SqlParameter("@temp_type",SqlDbType.Int,4),
new SqlParameter("@temp_name",SqlDbType.VarChar,50),
new SqlParameter("@temp_html",SqlDbType.Text,999999999),
new SqlParameter("@flag",SqlDbType.Int,4),
new SqlParameter("@user",SqlDbType.Int,4)
};
parms[0].Value = message.TempId;
parms[1].Value = message.TempType;
parms[2].Value = message.TempName;
parms[3].Value = message.TempHtml;
parms[4].Value = message.Flag;
parms[5].Value = userId;
int resuleNum = cmddal.RunProc("zcms_temp_update", parms);
return resuleNum;
}
// Text类型的最大长度为 2147483647 个字符