Пример #1
0
 /// <summary>
 /// 删除
 /// </summary>
 /// <param name="p_BE">要删除的实体</param>
 /// <param name="sqlTrans">事务类</param>
 public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
 {
     try
     {
         this.CheckCorrect(p_BE);
         OrderLevel    entity  = (OrderLevel)p_BE;
         OrderLevelCtl control = new OrderLevelCtl(sqlTrans);
         control.Delete(entity);
     }
     catch (BaseException)
     {
         throw;
     }
     catch (Exception E)
     {
         throw new BaseException(E.Message);
     }
 }
Пример #2
0
 /// <summary>
 /// 新增(传入事务处理)
 /// </summary>
 /// <param name="p_BE">要新增的实体</param>
 /// <param name="sqlTrans">事务类</param>
 public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
 {
     try
     {
         this.CheckCorrect(p_BE);
         OrderLevel entity = (OrderLevel)p_BE;
         string     sql    = "SELECT * FROM Enum_OrderLevel WHERE ID=" + SysString.ToDBString(entity.ID);
         DataTable  dt     = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级ID已存在,请检查后重新输入");
         }
         sql = "SELECT * FROM Enum_OrderLevel WHERE Code=" + SysString.ToDBString(entity.Code);
         dt  = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级编号已存在,请检查后重新输入");
         }
         sql = "SELECT * FROM Enum_OrderLevel WHERE Name=" + SysString.ToDBString(entity.Name);
         dt  = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级名称已存在,请检查后重新输入");
         }
         sql = "SELECT * FROM Enum_OrderLevel WHERE ColorStr=" + SysString.ToDBString(entity.ColorStr);
         dt  = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级颜色设置已存在,请检查后重新输入");
         }
         OrderLevelCtl control = new OrderLevelCtl(sqlTrans);
         //entity.ID=(int)EntityIDTable.GetID((long)SysEntity.Enum_OrderLevel,sqlTrans);
         control.AddNew(entity);
     }
     catch (BaseException)
     {
         throw;
     }
     catch (Exception E)
     {
         throw new BaseException(E.Message);
     }
 }
Пример #3
0
 /// <summary>
 /// 修改
 /// </summary>
 /// <param name="p_BE">要修改的实体</param>
 /// <param name="sqlTrans">事务类</param>
 public void RUpdate(BaseEntity p_BE, IDBTransAccess sqlTrans)
 {
     try
     {
         this.CheckCorrect(p_BE);
         OrderLevel entity = (OrderLevel)p_BE;
         string     sql    = "SELECT * FROM Enum_OrderLevel WHERE Code=" + SysString.ToDBString(entity.Code) + " AND ID<>" + entity.ID;
         DataTable  dt     = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级编号已存在,请检查后重新输入");
         }
         sql = "SELECT * FROM Enum_OrderLevel WHERE Name=" + SysString.ToDBString(entity.Name) + " AND ID<>" + entity.ID;
         dt  = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级名称已存在,请检查后重新输入");
         }
         sql = "SELECT * FROM Enum_OrderLevel WHERE ColorStr=" + SysString.ToDBString(entity.ColorStr) + " AND ID<>" + entity.ID;
         dt  = sqlTrans.Fill(sql);
         if (dt.Rows.Count > 0)
         {
             throw new BaseException("订单等级颜色设置已存在,请检查后重新输入");
         }
         OrderLevelCtl control = new OrderLevelCtl(sqlTrans);
         control.Update(entity);
     }
     catch (BaseException)
     {
         throw;
     }
     catch (Exception E)
     {
         throw new BaseException(E.Message);
     }
 }