/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
MSGInputDts entity = (MSGInputDts)p_BE;
MSGInputDtsCtl control = new MSGInputDtsCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.SMS_MSGInputDts, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
YieldRecord entity = (YieldRecord)p_BE;
YieldRecordCtl control = new YieldRecordCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_YieldRecord, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
WinListAttachFile entity = (WinListAttachFile)p_BE;
WinListAttachFileCtl control = new WinListAttachFileCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID(45, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
SaleOrderFabricCompSite entity = (SaleOrderFabricCompSite)p_BE;
SaleOrderFabricCompSiteCtl control = new SaleOrderFabricCompSiteCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Sale_SaleOrderFabricCompSite, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemCheckStandardPhy entity = (ItemCheckStandardPhy)p_BE;
ItemCheckStandardPhyCtl control = new ItemCheckStandardPhyCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_ItemCheckStandardPhy, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
AddressList entity = (AddressList)p_BE;
AddressListCtl control = new AddressListCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_AddressList, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CheckOrder entity = (CheckOrder)p_BE;
CheckOrderCtl control = new CheckOrderCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Chk_CheckOrder, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
TowelProductionPlanDtsStepProducts entity = (TowelProductionPlanDtsStepProducts)p_BE;
TowelProductionPlanDtsStepProductsCtl control = new TowelProductionPlanDtsStepProductsCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_TowelProductionPlanDtsStepProducts, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
FabricProcess entity = (FabricProcess)p_BE;
PrintingProcessCtl control = new PrintingProcessCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_PrintingProcess, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
FabricProcess entity = (FabricProcess)p_BE;
FabricProcessCtl control = new FabricProcessCtl(sqlTrans);
string sql = "SELECT FormNo FROM WO_FabricProcess WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("单号已存在，请重新生成");
}
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_FabricProcess, sqlTrans);
control.AddNew(entity);
FormNoControlRule fnrule = new FormNoControlRule();
fnrule.RAddSort("WO_FabricProcess", "FormNo", entity.ProcessTypeID, sqlTrans);
///回填生产通知单总数量
if (entity.ProductionID != 0)
{
//sql = "select SUM(ISNULL(TotalQty,0)) TotalQty from WO_FabricProcess where 1=1";
//sql += " AND ProductionID=" + entity.ProductionID;
//DataTable dtP = sqlTrans.Fill(sql);
//if(dtP.Rows.Count!=0)
//{
//}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd2(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BProductCheckDts entity = (BProductCheckDts)p_BE;
BProductCheckDtsCtl control = new BProductCheckDtsCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_BProductCheckDts, sqlTrans);
control.AddNew(entity);
RCalcMZJZ(entity, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
IOFormDtsPack entity = (IOFormDtsPack)p_BE;
IOFormDtsPackCtl control = new IOFormDtsPackCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WH_IOFormDtsPack, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
SampleSale entity = (SampleSale)p_BE;
SampleSaleCtl control = new SampleSaleCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Sale_SampleSale, sqlTrans);
control.AddNew(entity);
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 RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CSBGItem entity = (CSBGItem)p_BE;
string sql = "SELECT * FROM Data_CSBGItem WHERE Code=" + SysString.ToDBString(entity.Code);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("测试项目编号已存在,请检查后重新输入!");
}
sql = "SELECT * FROM Data_CSBGItem WHERE Name=" + SysString.ToDBString(entity.Name);
dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("测试项目名称已存在,请检查后重新输入!");
}
CSBGItemCtl control = new CSBGItemCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_CSBGItem, sqlTrans);
control.AddNew(entity);
for (int i = 0; i < p_BE2.Length; i++)
{
CSBGItemDtsRule rule = new CSBGItemDtsRule();
CSBGItemDts entityDts = (CSBGItemDts)p_BE2[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
rule.RAdd(entityDts, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BugForm entity = (BugForm)p_BE;
BugFormCtl control = new BugFormCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_BugForm, sqlTrans);
control.AddNew(entity);
FormNoControlRule frule = new FormNoControlRule();
//frule.RAddSort((int)FormNoControlEnum.异常管理单单号, sqlTrans);
frule.RAddSort("Data_BugForm", "FormNo", 0, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
SampleSO entity = (SampleSO)p_BE;
SampleSOCtl control = new SampleSOCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Dev_SampleSO, sqlTrans);
control.AddNew(entity);
FormNoControlRule rulest = new FormNoControlRule();
//rulest.RAddSort((int)FormNoControlEnum.打样指示单单号, sqlTrans);
rulest.RAddSort("Dev_SampleSO", "FormNo", 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CostRegister entity = (CostRegister)p_BE;
CostRegisterCtl control = new CostRegisterCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Finance_CostRegister, sqlTrans);
control.AddNew(entity);
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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
RecPayHXDts entity = (RecPayHXDts)p_BE;
RecPayHXDtsCtl control = new RecPayHXDtsCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Finance_RecPayHXDts, sqlTrans);
string sql = string.Empty;
entity.Seq = SysConvert.ToInt32(sqlTrans.Fill("SELECT ISNULL(MAX(Seq),0)+1 AS MSeq FROM Finance_RecPayHXDts WHERE MainID=" + entity.MainID).Rows[0][0]);
//取最大SEQ值
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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
FabricWHOutForm entity = (FabricWHOutForm)p_BE;
string o_ErrorMSG = string.Empty;
if (!RAddCheck(entity.MainID, out o_ErrorMSG, sqlTrans))
{
throw new BaseException(o_ErrorMSG);
}
string sql = "SELECT FormNo FROM WO_FabricWHOutForm WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("单号已存在，请重新生成");
}
FabricWHOutFormCtl control = new FabricWHOutFormCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_FabricWHOutForm, sqlTrans);
control.AddNew(entity);
FormNoControlRule fnrule = new FormNoControlRule();
fnrule.RAddSort("WO_FabricWHOutForm", "FormNo", 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
FVendorForm entity = (FVendorForm)p_BE;
string sql = "SELECT ID FROM Data_FVendorForm WHERE Name=" + SysString.ToDBString(entity.Name);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("名称已存在，请检查");
}
sql = "SELECT ID FROM Data_FVendorForm WHERE CLSA=" + SysString.ToDBString(entity.CLSA);
sql += " AND CLSB=" + SysString.ToDBString(entity.CLSB);
sql += " AND VendorTypeID=" + SysString.ToDBString(entity.VendorTypeID);
dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("此类型已存在，请检查");
}
if (dt.Rows.Count > 0)
{
throw new BaseException("名称已存在，请检查");
}
FVendorFormCtl control = new FVendorFormCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_FVendorForm, 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 RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
LYGL entity = (LYGL)p_BE;
string sql = "SELECT FormNo FROM Dev_LYGL WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("留样单单号已存在，请双击重新生成");
}
LYGLCtl control = new LYGLCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Dev_LYGL, sqlTrans);
control.AddNew(entity);
for (int i = 0; i < p_BE2.Length; i++)
{
LYGLDtsRule rule = new LYGLDtsRule();
LYGLDts entityDts = (LYGLDts)p_BE2[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
entityDts.LYType = (int)EnumLYType.新单;
rule.RAdd(entityDts, sqlTrans);
}
FormNoControlRule rulest = new FormNoControlRule();
//rulest.RAddSort((int)FormNoControlEnum.留样单号, sqlTrans);
rulest.RAddSort("Dev_LYGL", "FormNo", 0, 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 RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
WeaveProcess entity = (WeaveProcess)p_BE;
string sql = "SELECT FormNo FROM WO_WeaveProcess WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("印花加工单号已存在，请重新生成");
}
WeaveProcessCtl control = new WeaveProcessCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_WeaveProcess, sqlTrans);
control.AddNew(entity);
for (int i = 0; i < p_BE2.Length; i++)
{
WeaveProcessDtsRule rule = new WeaveProcessDtsRule();
WeaveProcessDts entityDts = (WeaveProcessDts)p_BE2[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
rule.RAdd(entityDts, sqlTrans);
}
FormNoControlRule rulest = new FormNoControlRule();
rulest.RAddSort((int)FormNoControlEnum.白坯织造加工单号, sqlTrans);
//ItemBuyCapDtsRule capRule = new ItemBuyCapDtsRule();
//capRule.RSaveBuyCap(entity, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
FHForm entity = (FHForm)p_BE;
string sql = "SELECT FormNo FROM Sale_FHForm WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("单号已存在，请重新生成");
}
sql = "SELECT SendCode FROM Sale_FHForm WHERE SendCode=" + SysString.ToDBString(entity.SendCode);
dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("送货单号已存在，请重新生成");
}
FHFormCtl control = new FHFormCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Sale_FHForm, sqlTrans);
control.AddNew(entity);
FormNoControlRule rulest = new FormNoControlRule();
rulest.RAddSort((int)FormNoControlEnum.发货单号, sqlTrans);
FormNCVendorRule rulencv = new FormNCVendorRule();
rulencv.RAddSort((int)FormNoControlEnum.发货单送货单号, (int)EnumFNCV.发货单送货单号, entity.VendorID, 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ReportManage entity = (ReportManage)p_BE;
ReportManageCtl control = new ReportManageCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID(27, sqlTrans);//(long)SysEntity.Data_ReportManage
control.AddNew(entity);
WFormNoControlRule noControlRule = new WFormNoControlRule();
noControlRule.RAddSort(39, sqlTrans);//(int)FormNoControlEnum.报表流水号
//noControlRule.RAddSort( ("Data_ReportManage", "FileName", 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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
InfoType entity = (InfoType)p_BE;
string sql = "SELECT * FROM Enum_InfoType WHERE Code=" + SysString.ToDBString(entity.Code);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("编码已存在，请重新输入！");
}
sql = "SELECT * FROM Enum_InfoType WHERE Name=" + SysString.ToDBString(entity.Name);
dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("名称已存在，请重新输入！");
}
sql = "SELECT * FROM Enum_InfoType";
dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 7)
{
throw new BaseException("标签已满不能继续编辑");
}
InfoTypeCtl control = new InfoTypeCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Enum_InfoType, 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 RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CapPlan entity = (CapPlan)p_BE;
CapPlanCtl control = new CapPlanCtl(sqlTrans);
string sql = "SELECT FormNo FROM Finance_CapPlan WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("编号已存在，请重新生成");
}
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Finance_CapPlan, sqlTrans);
control.AddNew(entity);
for (int i = 0; i < p_BE2.Length; i++)
{
CapPlanDtsRule rule = new CapPlanDtsRule();
CapPlanDts entityDts = (CapPlanDts)p_BE2[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
rule.RAdd(entityDts, sqlTrans);
}
FormNoControlRule rulest = new FormNoControlRule();
rulest.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 RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, BaseEntity[] p_BE3, BaseEntity[] p_BE4, int p_Flag, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
Item entity = (Item)p_BE;
string sql = "SELECT ItemCode FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entity.ItemCode);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("编码已存在，请重新生成");
}
ItemCtl control = new ItemCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Data_Item, sqlTrans);
control.AddNew(entity);
ItemColorDtsRule rule2 = new ItemColorDtsRule();
rule2.RSave(entity, p_BE2, sqlTrans);
ItemAddRule ruleItemAdd = new ItemAddRule();
for (int i = 0; i < p_BE3.Length; i++)
{
ItemAdd entityDts = (ItemAdd)p_BE3[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
ruleItemAdd.RAdd(entityDts, sqlTrans);
ruleItemAdd.UpdateFiledSet(entity.ID, entityDts.FiledSetID, entityDts.Value, sqlTrans);
}
ItemPicRule ruleItemPic = new ItemPicRule();
for (int i = 0; i < p_BE4.Length; i++)
{
ItemPic entityDts = (ItemPic)p_BE4[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
ruleItemPic.RAdd(entityDts, sqlTrans);
}
#region cost自动计算
entity = new Item(sqlTrans);
entity.ID = ((Item)p_BE).ID;
entity.SelectByID();
decimal Cost = 0;
decimal PBPrice = entity.PBPrice;//坯价格
decimal RShrinkage = GetDecimalByString(entity.RShrinkage, '%');
decimal RSAmount = entity.RSAmount;
decimal RSSH = GetDecimalByString(entity.RSSH, '%');
decimal JGAmount = entity.JGAmount;
decimal JGSH = GetDecimalByString(entity.JGSH, '%');
decimal HZAmount = entity.HZAmount;
decimal ProfitMargin = GetDecimalByString(entity.ProfitMargin, '%');
decimal Quot = GetDecimalByString(entity.COST, '/') * (1m + (ProfitMargin / 100m));
Cost = (((PBPrice * (1m + (RShrinkage / 100m)) + RSAmount) * (1m + (RSSH / 100m)) + JGAmount) * (1m + (JGSH / 100m)) + HZAmount) * 1.06m + 0.2m;
Cost = SysConvert.ToDecimal(Cost, 2);
//Quot = SysConvert.ToDecimal(Quot,2);
sql = "UPDATE Data_Item SET COSTA=" + SysString.ToDBString(Cost.ToString() + "/M");
//sql += ",QUOT=" + SysString.ToDBString(Quot.ToString() + "/M");
sql += " WHERE ID=" + SysString.ToDBString(entity.ID);
sqlTrans.ExecuteNonQuery(sql);
sql = "UPDATE Data_ItemAdd SET Value=" + SysString.ToDBString(Cost.ToString() + "/M");
sql += " WHERE FiledName='COSTA'";// +SysString.ToDBString(entity.ID);
sql += " AND MainID=" + SysString.ToDBString(entity.ID);
sqlTrans.ExecuteNonQuery(sql);
//sql = "UPDATE Data_ItemAdd SET Value=" + SysString.ToDBString(Quot.ToString() + "/M");
//sql += " WHERE FiledName='QUOT'";// +SysString.ToDBString(entity.ID);
//sql += " AND MainID=" + SysString.ToDBString(entity.ID);
//sqlTrans.ExecuteNonQuery(sql);
#endregion
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
