private bool Execute4NewsPublicTypes(int id, List<int> newsTypes)
{
bool ret = false;
List<CommandInfo> strSqlNewsTypes = new List<CommandInfo>();
try
{
string delSql = "delete from T_ADM_NewsPublicTypes where ID=@ID
";
SqlParameter[] cmdParmsDel = new SqlParameter[1];
cmdParmsDel[0] = new SqlParameter("@ID ", id);
strSqlNewsTypes.Add(new CommandInfo(delSql, cmdParmsDel));
foreach (var i in newsTypes)
{
string insertSql = "insert into T_ADM_NewsPublicTypes values (@ID, @Type)
";
SqlParameter[] cmdParmsInsert = new SqlParameter[2];
cmdParmsInsert[0] = new SqlParameter("@ID ", id);
cmdParmsInsert[1] = new SqlParameter("@Type ", i);
strSqlNewsTypes.Add(new CommandInfo(insertSql, cmdParmsInsert));
}
DbPortalHelper.ExecuteSqlTran(strSqlNewsTypes);
ret = true;
}
catch (Exception)
{
ret = false;
}
return ret;
}