/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
PackOrder entity = (PackOrder)p_BE;
string sql = "SELECT * FROM WO_PackOrder WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
if (sqlTrans.Fill(sql).Rows.Count != 0)
{
throw new Exception("单号" + entity.FormNo + "已存在，请检查");
}
PackOrderCtl control = new PackOrderCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_PackOrder, sqlTrans);
control.AddNew(entity);
FormNoControlRule fnrule = new FormNoControlRule();
fnrule.RAddSort("WO_PackOrder", "FormNo", sqlTrans);
//FormNoControlRule FRule = new FormNoControlRule();
//FRule.RAddSort((int)FormNoControlEnum.包装单号, sqlTrans);
}
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);
PackOrder entity = (PackOrder)p_BE;
PackOrderCtl control = new PackOrderCtl(sqlTrans);
string sql = "DELETE FROM WO_PackOrderDts WHERE MainID=" + entity.ID.ToString();
sqlTrans.ExecuteNonQuery(sql);//删除原单据明细数据
control.Delete(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);
PackOrder entity = (PackOrder)p_BE;
string sql = "SELECT * FROM WO_PackOrder WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
sql += " AND ID<>" + SysString.ToDBString(entity.ID);
if (sqlTrans.Fill(sql).Rows.Count != 0)
{
throw new Exception("单号" + entity.FormNo + "已存在，请检查");
}
PackOrderCtl control = new PackOrderCtl(sqlTrans);
control.Update(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
