예제 #1
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);
         SBit    entity  = (SBit)p_BE;
         SBitCtl control = new SBitCtl(sqlTrans);
         //entity.ID=EntityIDTable.GetID((long)SysEntity.WH_SBit,sqlTrans);
         string    sql = "SELECT SBitID FROM WH_SBit WHERE SBitID=" + SysString.ToDBString(entity.SBitID) + " AND SectionID=" + SysString.ToDBString(entity.SectionID) + " AND WHID=" + SysString.ToDBString(entity.WHID);
         DataTable dt  = SysUtils.Fill(sql);
         if (dt.Rows.Count != 0)
         {
             throw new Exception("该仓库位编码已经存在,请重新输入");
         }
         FormNoControlRule rule = new FormNoControlRule();
         entity.SBitISN = rule.RGetFormNo(1026, sqlTrans);
         control.AddNew(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 RUpdate(BaseEntity p_BE, IDBTransAccess sqlTrans)
 {
     try
     {
         this.CheckCorrect(p_BE);
         SBit    entity  = (SBit)p_BE;
         SBitCtl control = new SBitCtl(sqlTrans);
         //string sql = "SELECT SBitID FROM WH_SBit WHERE SBitID=" + SysString.ToDBString(entity.SBitID) +" AND SectionID=" + SysString.ToDBString(entity.SectionID) + " AND WHID=" + SysString.ToDBString(entity.WHID);
         //sql+=" AND SBitID<>"+SysString.ToDBString(entity.OldSBitID);
         //DataTable dt = sqlTrans.Fill(sql);
         //if(dt.Rows.Count!=0)
         //{
         //    throw new Exception("该仓库位编码已经存在,请重新输入");
         //}
         control.Update(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 RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
 {
     try
     {
         this.CheckCorrect(p_BE);
         SBit    entity  = (SBit)p_BE;
         SBitCtl control = new SBitCtl(sqlTrans);
         control.Delete(entity);
     }
     catch (BaseException)
     {
         throw;
     }
     catch (Exception E)
     {
         throw new BaseException(E.Message);
     }
 }