/// <summary> /// 比较当前对象和同一类型的另一对象。用于排序。 /// </summary> /// <param name="other">与此对象进行比较的对象。</param> /// <returns>一个 32 位有符号整数,指示要比较的对象的相对顺序。</returns> public int CompareTo(QiAttachCategory other) { int s = this.Sort.CompareTo(other.Sort); if (s == 0) { return(this.Code.CompareTo(other.Code)); } else { return(s); } }
public static void Delete(QiAttachCategory entry) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(String.Format(@"DELETE FROM {1} WHERE [Code] = N'{0}'", entry.Code, DataDictionaryEntryDa.GetDictionaryTableName(DictionaryName.QiAttachCategory))); try { db.ExecuteNonQuery(dbCommand); } catch (System.Data.SqlClient.SqlException sex) // 只捕获SqlException,其余抛出继续传播 { DBHelper.ParseSqlException(sex, true); } }
public static void Insert(QiAttachCategory entry) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(String.Format(@"INSERT INTO {5} VALUES (N'{0}', N'{1}', {2}, {3}, N'{4}', GETDATE(), 0)", entry.Code, entry.Title, entry.ReportAttach ? "1" : "0", entry.Sort, entry.Updator, DataDictionaryEntryDa.GetDictionaryTableName(DictionaryName.QiAttachCategory))); try { db.ExecuteNonQuery(dbCommand); } catch (System.Data.SqlClient.SqlException sex) // 只捕获SqlException,其余抛出继续传播 { DBHelper.ParseSqlException(sex, false); } }
public static void Update(QiAttachCategory entry) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(String.Format(@"UPDATE {6} SET [Title] = N'{1}' ,[Purpose] = {2} ,[Sort] = {3} ,[Optor] = N'{4}',[OpTime] = GETDATE(), [Deleted] = {5} WHERE [Code] = N'{0}'", entry.Code, entry.TitleT, entry.ReportAttachT ? "1" : "0", entry.SortT, entry.UpdatorT, entry.VisibleT ? 0 : 1, DataDictionaryEntryDa.GetDictionaryTableName(DictionaryName.QiAttachCategory))); try { db.ExecuteNonQuery(dbCommand); } catch (System.Data.SqlClient.SqlException sex) // 只捕获SqlException,其余抛出继续传播 { DBHelper.ParseSqlException(sex, false); } }
/// <summary> /// 比较当前对象和同一类型的另一对象。用于排序。 /// </summary> /// <param name="obj">与此对象进行比较的对象。</param> /// <returns>一个 32 位有符号整数,指示要比较的对象的相对顺序。</returns> /// <remarks>也可以添加一个范型实现。</remarks> public override int CompareTo(object obj) { if (obj is QiAttachCategory) { QiAttachCategory temp = (QiAttachCategory)obj; int s = this.Sort.CompareTo(temp.Sort); if (s == 0) { return(this.Code.CompareTo(temp.Code)); } else { return(s); } } throw new ArgumentException("object is not a WarranyEntry"); }
public void Remove(QiAttachCategory entry) { QiAttachCategoryDa.Delete(entry); }
public void Edit(QiAttachCategory entry) { QiAttachCategoryDa.Update(entry); }
public void Add(QiAttachCategory entry) { QiAttachCategoryDa.Insert(entry); }
/// <summary> /// 比较当前对象和同一类型的另一对象。用于排序。 /// </summary> /// <param name="other">与此对象进行比较的对象。</param> /// <returns>一个 32 位有符号整数,指示要比较的对象的相对顺序。</returns> public int CompareTo(QiAttachCategory other) { int s = this.Sort.CompareTo(other.Sort); if (s == 0) return this.Code.CompareTo(other.Code); else return s; }