public static void Delete(RcMailGroup entry) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(String.Format(@"DELETE FROM {1} WHERE [Code] = N'{0}'", entry.Code, DataDictionaryEntryDa.GetDictionaryTableName(DictionaryName.RcMailGroup))); try { db.ExecuteNonQuery(dbCommand); } catch (System.Data.SqlClient.SqlException sex) // 只捕获SqlException,其余抛出继续传播 { DBHelper.ParseSqlException(sex, true); } }
public static void Insert(RcMailGroup entry) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(String.Format(@"INSERT INTO {6} VALUES (N'{0}', N'{1}', N'{2}', N'{3}', {4}, N'{5}', GETDATE(), 0)", entry.Code, entry.Title, entry.BU, entry.MailList, entry.Sort, entry.Updator, DataDictionaryEntryDa.GetDictionaryTableName(DictionaryName.RcMailGroup))); try { db.ExecuteNonQuery(dbCommand); } catch (System.Data.SqlClient.SqlException sex) // 只捕获SqlException,其余抛出继续传播 { DBHelper.ParseSqlException(sex, false); } }
public static void Update(RcMailGroup entry) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(String.Format(@"UPDATE {7} SET [Title] = N'{1}' ,[BU] = N'{2}' ,[MailList] = N'{3}' ,[Sort] = {4} ,[Optor] = N'{5}',[OpTime] = GETDATE(), [Deleted] = {6} WHERE [Code] = N'{0}'", entry.Code, entry.TitleT, entry.BUT, entry.MaillistT, entry.SortT, entry.UpdatorT, entry.VisibleT ? 0 : 1, DataDictionaryEntryDa.GetDictionaryTableName(DictionaryName.RcMailGroup))); try { db.ExecuteNonQuery(dbCommand); } catch (System.Data.SqlClient.SqlException sex) // 只捕获SqlException,其余抛出继续传播 { DBHelper.ParseSqlException(sex, false); } }
public void Remove(RcMailGroup entry) { RcMailGroupDa.Delete(entry); }
public void Edit(RcMailGroup entry) { RcMailGroupDa.Update(entry); }
public void Add(RcMailGroup entry) { RcMailGroupDa.Insert(entry); }