/// <summary>
/// 新增
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public int RSaveFault(BProductCheckDtsFault p_BE, BProductCheckDts entity, int MainID, int PackDtsID)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
int TempID = this.RSaveFault(p_BE, entity, MainID, PackDtsID, sqlTrans);
sqlTrans.CommitTrans();
return(TempID);
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
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(int p_BE, IDBTransAccess sqlTrans)
{
try
{
BProductCheckDtsFault entity = new BProductCheckDtsFault(sqlTrans);
entity.ID = p_BE;
entity.SelectByID();
RDelete(entity, sqlTrans);
BProductCheckDts en = new BProductCheckDts(sqlTrans);
en.ID = entity.MainID;
en.SelectByID();
en.CY -= entity.CYQty;
string sql = "";
en.RCKF = 0m;
en.CJRC = 0m;
en.FMRC = 0m;
en.ZCKF = 0m;
en.CJZC = 0m;
en.FMZC = 0m;
en.MQty3 = 0m;
#region 统计合计数据
sql = "SELECT SUM(DQuantity) DQuantity,SUM(Deduction) Deduction,SUM(DYM) DYM,B.CDType FROM WO_BProductCheckDtsFault AS A,Data_CDGL AS B WHERE A.FaultDes=B.Code AND A.MainID=" + entity.MainID + " GROUP BY B.CDType";
DataTable dt = sqlTrans.Fill(sql);
foreach (DataRow dr in dt.Rows)
{
if (dr["CDType"].ToString() == "染疵")
{
// DQuantity// 放码
//Deduction扣分
//DYM 裁剪
en.RCKF = SysConvert.ToDecimal(dr["Deduction"]);
en.CJRC = SysConvert.ToDecimal(dr["DYM"]);
en.FMRC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else if (dr["CDType"].ToString() == "织疵")
{
en.ZCKF = SysConvert.ToDecimal(dr["Deduction"]);
en.CJZC = SysConvert.ToDecimal(dr["DYM"]);
en.FMZC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else
{
en.MQty3 = SysConvert.ToDecimal(dr["DQuantity"]);
}
}
BProductCheckDtsRule rulebp2 = new BProductCheckDtsRule();
rulebp2.RUpdate(en, sqlTrans);
#endregion
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
BProductCheckDtsFault MasterEntity = (BProductCheckDtsFault)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM WO_BProductCheckDtsFault WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(Sql);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BProductCheckDtsFault entity = (BProductCheckDtsFault)p_BE;
BProductCheckDtsFaultCtl control = new BProductCheckDtsFaultCtl(sqlTrans);
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 RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
BProductCheckDtsFault entity = (BProductCheckDtsFault)p_BE;
BProductCheckDtsFaultCtl control = new BProductCheckDtsFaultCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_BProductCheckDtsFault, 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 int RSaveFault(BProductCheckDtsFault p_BE, BProductCheckDts entityMain, int MainID, int PackDtsID, IDBTransAccess sqlTrans)
{
try
{
if (PackDtsID == 0)
{
throw new Exception("请先选择检验指示单");
}
BProductCheckDtsFault entity = p_BE as BProductCheckDtsFault;
if (MainID == 0)
{
entityMain.MainID = PackDtsID;
BProductCheckDtsRule rulebp = new BProductCheckDtsRule();
if (entity.DQuantity == 0m && entity.Deduction == 0m && entity.DYM == 0m && entity.CYQty == 0m)//统匹毛病
{
entityMain.VColorName = entity.FaultDes;
entity.Position = "统匹";
}
entityMain.CY += entity.CYQty;
rulebp.RAdd(entityMain, sqlTrans);
entity.MainID = entityMain.ID;
}
else
{
BProductCheckDtsRule rulebp = new BProductCheckDtsRule();
if (entity.DQuantity == 0m && entity.Deduction == 0m && entity.DYM == 0m && entity.CYQty == 0m)//统匹毛病
{
entityMain.VColorName = entity.FaultDes;
entity.Position = "统匹";
}
entityMain.CY += entity.CYQty;
rulebp.RUpdate(entityMain, sqlTrans);
}
RAdd(entity, sqlTrans);
string sql = "";
#region 统计合计数据
sql = "SELECT SUM(DQuantity) DQuantity,SUM(Deduction) Deduction,SUM(DYM) DYM,B.CDType,SUM(CYQty) CYQty FROM WO_BProductCheckDtsFault AS A,Data_CDGL AS B WHERE A.FaultDes=B.Code AND A.MainID=" + entityMain.ID + " GROUP BY B.CDType";
DataTable dt = sqlTrans.Fill(sql);
entityMain.RCKF = 0m;
entityMain.CJRC = 0m;
entityMain.FMRC = 0m;
entityMain.ZCKF = 0m;
entityMain.CJZC = 0m;
entityMain.FMZC = 0m;
entityMain.MQty3 = 0m;
foreach (DataRow dr in dt.Rows)
{
if (dr["CDType"].ToString() == "染疵")
{
// DQuantity// 放码
//Deduction扣分
//DYM 裁剪
entityMain.RCKF = SysConvert.ToDecimal(dr["Deduction"]);
entityMain.CJRC = SysConvert.ToDecimal(dr["DYM"]);
entityMain.FMRC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else if (dr["CDType"].ToString() == "织疵")
{
entityMain.ZCKF = SysConvert.ToDecimal(dr["Deduction"]);
entityMain.CJZC = SysConvert.ToDecimal(dr["DYM"]);
entityMain.FMZC = SysConvert.ToDecimal(dr["DQuantity"]);
}
else
{
entityMain.MQty3 = SysConvert.ToDecimal(dr["DQuantity"]);
}
}
BProductCheckDtsRule rulebp2 = new BProductCheckDtsRule();
rulebp2.RUpdate(entityMain, sqlTrans);
#endregion
return(entity.MainID);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
BProductCheckDtsFault entity = (BProductCheckDtsFault)p_BE;
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
BProductCheckDtsFault MasterEntity = (BProductCheckDtsFault)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO WO_BProductCheckDtsFault(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("MainID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ",");
MasterField.Append("Seq" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ",");
MasterField.Append("FaultType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FaultType) + ",");
MasterField.Append("BLength" + ",");
if (MasterEntity.BLength != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.BLength) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ELength" + ",");
if (MasterEntity.ELength != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ELength) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("FaultDes" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FaultDes) + ",");
MasterField.Append("Deduction" + ",");
if (MasterEntity.Deduction != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.Deduction) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("DQuantity" + ",");
if (MasterEntity.DQuantity != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.DQuantity) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("Position" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Position) + ",");
MasterField.Append("MaxIndex" + ",");
if (MasterEntity.MaxIndex != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MaxIndex) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("DYM" + ",");
if (MasterEntity.DYM != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.DYM) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CYQty" + ")");
if (MasterEntity.CYQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CYQty) + ")");
}
else
{
MasterValue.Append("null)");
}
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
BProductCheckDtsFault MasterEntity = (BProductCheckDtsFault)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE WO_BProductCheckDtsFault SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ",");
UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ",");
UpdateBuilder.Append(" FaultType=" + SysString.ToDBString(MasterEntity.FaultType) + ",");
if (MasterEntity.BLength != 0)
{
UpdateBuilder.Append(" BLength=" + SysString.ToDBString(MasterEntity.BLength) + ",");
}
else
{
UpdateBuilder.Append(" BLength=null,");
}
if (MasterEntity.ELength != 0)
{
UpdateBuilder.Append(" ELength=" + SysString.ToDBString(MasterEntity.ELength) + ",");
}
else
{
UpdateBuilder.Append(" ELength=null,");
}
UpdateBuilder.Append(" FaultDes=" + SysString.ToDBString(MasterEntity.FaultDes) + ",");
if (MasterEntity.Deduction != 0)
{
UpdateBuilder.Append(" Deduction=" + SysString.ToDBString(MasterEntity.Deduction) + ",");
}
else
{
UpdateBuilder.Append(" Deduction=null,");
}
if (MasterEntity.DQuantity != 0)
{
UpdateBuilder.Append(" DQuantity=" + SysString.ToDBString(MasterEntity.DQuantity) + ",");
}
else
{
UpdateBuilder.Append(" DQuantity=null,");
}
UpdateBuilder.Append(" Position=" + SysString.ToDBString(MasterEntity.Position) + ",");
if (MasterEntity.MaxIndex != 0)
{
UpdateBuilder.Append(" MaxIndex=" + SysString.ToDBString(MasterEntity.MaxIndex) + ",");
}
else
{
UpdateBuilder.Append(" MaxIndex=null,");
}
if (MasterEntity.DYM != 0)
{
UpdateBuilder.Append(" DYM=" + SysString.ToDBString(MasterEntity.DYM) + ",");
}
else
{
UpdateBuilder.Append(" DYM=null,");
}
if (MasterEntity.CYQty != 0)
{
UpdateBuilder.Append(" CYQty=" + SysString.ToDBString(MasterEntity.CYQty));
}
else
{
UpdateBuilder.Append(" CYQty=null");
}
UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
