/// <summary> /// 删除 /// </summary> /// <param name="p_BE">要删除的实体</param> /// <param name="sqlTrans">事务类</param> public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); BProductCheckDtsModifyLog entity = (BProductCheckDtsModifyLog)p_BE; BProductCheckDtsModifyLogCtl control = new BProductCheckDtsModifyLogCtl(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); BProductCheckDtsModifyLog entity = (BProductCheckDtsModifyLog)p_BE; BProductCheckDtsModifyLogCtl control = new BProductCheckDtsModifyLogCtl(sqlTrans); entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WO_BProductCheckDtsModifyLog, sqlTrans); control.AddNew(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 检查将要操作的数据是否符合业务规则 /// </summary> /// <param name="p_BE"></param> private void CheckCorrect(BaseEntity p_BE) { BProductCheckDtsModifyLog entity = (BProductCheckDtsModifyLog)p_BE; }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void ModifyLog(BProductCheckDts p_BE, BProductCheckDtsModifyLog p_BE2, IDBTransAccess sqlTrans) { try { if (p_BE.StatusID != (int)EnumBoxStatus.未入库) { throw new Exception("不是已经出库的条码,不能修改"); } if (p_BE.KF24 == 1) { throw new Exception("此匹布已经修改过一次了,不能在此修改"); } #region 备份的老条码 BProductCheckDts entityold = new BProductCheckDts(sqlTrans); entityold.ID = p_BE.ID; entityold.SelectByID();//复制的老条码 #endregion #region 更新老的条码为新的条码,只换条码号,和修改的内容,其他信息不变 if (p_BE2.CompactNo != string.Empty) { p_BE2.OldCompactNo = p_BE.CompactNo; p_BE.CompactNo = p_BE2.CompactNo; string sqlcheck = "SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(p_BE2.CompactNo) + " AND SubmitFlag=1"; DataTable dtcheck = sqlTrans.Fill(sqlcheck); if (dtcheck.Rows.Count != 1) { throw new Exception("变更的合同号不存在,请检查"); } } if (p_BE2.JarNum != string.Empty) { p_BE2.OldJarNum = p_BE.JarNum; p_BE.JarNum = p_BE2.JarNum; } if (p_BE2.Seq != 0) { p_BE2.OldSeq = p_BE.Seq; p_BE.Seq = p_BE2.Seq; } p_BE.KF24 = 0; p_BE.KF22 = 1;//退货冲销后产生的新的条码 p_BE.DISN = GetDISN(sqlTrans); p_BE.StatusID = (int)EnumBoxStatus.未入库; RUpdate2(p_BE, sqlTrans); #endregion #region 备份老的条码,标志为不可修改,并增加Log日志 p_BE2.ModifyID = p_BE.ID; entityold.StatusID = (int)EnumBoxStatus.未入库; entityold.KF24 = 1;//修改后新产生条码 entityold.ID = 0; RAdd2(entityold, sqlTrans); p_BE2.NewISNID = entityold.ID;//新产生条码的ID BProductCheckDtsModifyLogRule rule = new BProductCheckDtsModifyLogRule(); rule.RAdd(p_BE2, 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 AddNew(BaseEntity p_Entity) { try { BProductCheckDtsModifyLog MasterEntity = (BProductCheckDtsModifyLog)p_Entity; if (MasterEntity.ID == 0) { return(0); } //新增主表数据 StringBuilder MasterField = new StringBuilder(); StringBuilder MasterValue = new StringBuilder(); MasterField.Append("INSERT INTO WO_BProductCheckDtsModifyLog("); MasterValue.Append(" VALUES("); MasterField.Append("ID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ","); MasterField.Append("ModifyID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ModifyID) + ","); MasterField.Append("ModifyDay" + ","); if (MasterEntity.ModifyDay != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.ModifyDay.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("OldCompactNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OldCompactNo) + ","); MasterField.Append("OldJarNum" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OldJarNum) + ","); MasterField.Append("OldSeq" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OldSeq) + ","); MasterField.Append("CompactNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CompactNo) + ","); MasterField.Append("JarNum" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.JarNum) + ","); MasterField.Append("Seq" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ","); MasterField.Append("NewISNID" + ")"); MasterValue.Append(SysString.ToDBString(MasterEntity.NewISNID) + ")"); //执行 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); } }