/// <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);
}
}
/// <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);
}
}
/// <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);
}
}