public Entity DeleteEntityByUniqueWithOperator(int intUnique, int intWoodID, int operatorID, string greenCardNumber, string redCardNumber, string bangCid) { try { this._Dal.BeginTransaction(); ExecuteForDeleteEntity(intWoodID); int affectedRows = this._Dal.DeleteEntityByUniqueWithOperator(intUnique, intWoodID, operatorID); // 删除车辆还未离厂的记录 if (affectedRows > 0) { RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); int affRows = cardStateBll.UpdateState(greenCardNumber, (int)CardType.Green, (int)CardState.Balance); affRows = cardStateBll.UpdateState(redCardNumber, (int)CardType.Red, (int)CardState.Sample); } this._Dal.CommitTransaction(); Entity operateResult; if (affectedRows > 0) { operateResult = Helper.GetEntity(true, "删除记录成功"); SyncDeleteEmptyVolumeData(intWoodID); SimpleProperty BangCID = new SimpleProperty("BangCID", typeof(string)); SimpleProperty BangID = new SimpleProperty("BangID", typeof(string)); Entity entity = new Entity(new PropertyCollection() { BangCID, BangID }); entity.SetValue(BangCID, bangCid); entity.SetValue(BangID, ""); SyncVolumeDataForERP(entity, "DEL"); } else { operateResult = Helper.GetEntity(false, "删除失败,可能该车辆已经驶出厂区大门,不能再删除"); } return(operateResult); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity SaveEntityByOperator(Entity entity) { string strCrateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string msg = ""; try { this._Dal.BeginTransaction(); UniqueDal unique = new UniqueDal(this._Dal.SqlTransaction); entity.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\",\"People\":\"" + entity.GetValue("Operator").ToString() + "\"}"); int affectedRows; /* 新增 */ if (entity.GetValue("Unique").TryInt32() == 0) { RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); object cardNumber = entity.GetValue("CardNumber"); bool hasUseRecord = CheckForSaveEntityInsert(cardNumber, cardStateBll); int newUnique = unique.GetValueByName(this._Dal.Table); entity.SetValue("Unique", newUnique); entity.Add(new SimpleProperty("BarrierID", typeof(int)), null); entity.Add(new SimpleProperty("ArriveDate", typeof(DateTime)), strCrateDate); entity.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entity.Add(new SimpleProperty("Version", typeof(int)), 1); affectedRows = this._Dal.InsertEntity(entity); if (hasUseRecord) { affectedRows = cardStateBll.UpdateState(cardNumber.ToString(), (int)CardType.Green, (int)CardState.Door, newUnique, (int)CardComeFrom.Factry); } else { affectedRows = cardStateBll.Insert(cardNumber.ToString(), (int)CardType.Green, (int)CardState.Door, newUnique, (int)CardComeFrom.Factry); } msg = "发卡成功"; } // 修改 else { CheckForSaveEntityUpdate(entity.GetValue("Unique")); affectedRows = this._Dal.UpdateEntityByUniqueWithOperator(entity); msg = "修改成功"; } this._Dal.CommitTransaction(); return(Helper.GetEntity(true, msg, entity.GetValue("Unique").ToString())); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity DeleteEntityByUniqueWithOperator(int intUnique, int intWoodID, int operatorID, string greenCardNumber, string redCardNumber) { try { this._Dal.BeginTransaction(); ExecuteForDeleteEntity(intWoodID); int affectedRows = this._Dal.DeleteEntityByUniqueWithOperator(intUnique, intWoodID, operatorID); // 删除还未被料厂取样的记录 if (affectedRows > 0) { RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); int affRows = cardStateBll.UpdateState(greenCardNumber, (int)CardType.Green, (int)CardState.Door); affRows = cardStateBll.UpdateState(redCardNumber, (int)CardType.Red, (int)CardState.UnUse); } this._Dal.CommitTransaction(); Entity operateResult; if (affectedRows > 0) { operateResult = Helper.GetEntity(true, "删除记录成功"); SyncDeleteFullVolumeData(intWoodID); } else { operateResult = Helper.GetEntity(false, "删除失败,可能该车辆已经到达料厂卸货并取样完毕,不能再删除"); } return(operateResult); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity DeleteEntityByUniqueWithOperator(int intUnique, int intWoodID, int operatorID, string redCardNumber) { try { this._Dal.BeginTransaction(); ExecuteForDeleteEntity(intWoodID); int affectedRows = this._Dal.DeleteEntityByUniqueWithOperator(intUnique, intWoodID, operatorID); // 删除还未地磅回皮的记录 if (affectedRows > 0) { string strFileName = "WoodID"; object objFileValue = intWoodID; string connect = "="; string table = "Factory"; /* 判断当前记录在料厂处的取样记录是否已删除完 */ EntityCollection hasRecord = this._Dal.SelectRecordComeFromDataOfNextStepOperate(strFileName, objFileValue, connect, table); if (hasRecord.Count == 0) { /* 料厂处的取样记录已删除完,则需要变更该红卡的状态 */ RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); int affRows = cardStateBll.UpdateState(redCardNumber, (int)CardType.Red, (int)CardState.Balance); } } this._Dal.CommitTransaction(); Entity operateResult; if (affectedRows > 0) { operateResult = Helper.GetEntity(true, "删除记录成功"); } else { operateResult = Helper.GetEntity(false, "删除失败,可能该车辆已经到地磅并回皮完毕,不能再删除"); } return(operateResult); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity SaveEntityByOperator(Entity entity, string greenCardNumber) { string strCrateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string msg = ""; try { this._Dal.BeginTransaction(); CheckForSaveEntityInsert(entity.GetValue("WoodID")); UniqueDal unique = new UniqueDal(this._Dal.SqlTransaction); // 新增 entity.SetValue("Unique", unique.GetValueByName(this._Dal.Table)); entity.Add(new SimpleProperty("RecoverTime", typeof(DateTime)), strCrateDate); entity.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entity.Add(new SimpleProperty("Version", typeof(int)), 1); entity.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\",\"People\":\"" + entity.GetValue("Operator").ToString() + "\"}"); int affectedRows; RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); affectedRows = this._Dal.InsertEntity(entity); affectedRows = cardStateBll.UpdateState(greenCardNumber, (int)CardType.Green, (int)CardState.UnUse); this._Dal.CommitTransaction(); msg = "回收成功"; return(Helper.GetEntity(true, msg, entity.GetValue("Unique").ToString())); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity DeleteEntityByUniqueWithOperator(int intUnique, int operatorID, string cardNumber) { try { this._Dal.BeginTransaction(); ExecuteForDeleteEntity(intUnique); int affectedRows = this._Dal.DeleteEntityByUniqueWithOperator(intUnique, operatorID); // 删除还未首磅的记录 if (affectedRows > 0) { RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); int affRows = cardStateBll.UpdateState(cardNumber, (int)CardType.Green, (int)CardState.UnUse); } this._Dal.CommitTransaction(); Entity operateResult; if (affectedRows > 0) { operateResult = Helper.GetEntity(true, "删除成功"); } else { operateResult = Helper.GetEntity(false, "删除失败,可能该车辆已经到达地磅并首磅完毕,不能再删除"); } return(operateResult); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity SaveEntityByOperator(Entity entity) { string strCrateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string msg = ""; try { CheckForSaveEntityInsert(entity.GetValue("BarrierID")); object greenCardNumber = entity.GetValue("CardNumber"); /* 这里获取数据,为了在验收电子卡的同时,模拟新发一张工厂入门电子卡记录 */ SimpleProperty property = new SimpleProperty("CardNumber", typeof(string)); Entity entityOfWood = new Entity(new PropertyCollection() { property }); entityOfWood.SetValue(property, greenCardNumber); entityOfWood.Add(new SimpleProperty("BarrierID", typeof(int)), entity.GetValue("BarrierID")); entityOfWood.Add(new SimpleProperty("ArriveDate", typeof(DateTime)), strCrateDate); entityOfWood.Add(new SimpleProperty("Operator", typeof(int)), entity.GetValue("Operator")); entityOfWood.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entityOfWood.Add(new SimpleProperty("Version", typeof(int)), 1); entityOfWood.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\",\"People\":\"" + entity.GetValue("Operator").ToString() + "\"}"); this._Dal.BeginTransaction(); UniqueDal unique = new UniqueDal(this._Dal.SqlTransaction); RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); int newUnique = unique.GetValueByName("Wood"); // 注意这里,获取木材表的唯一字段 if (newUnique <= 0) { throw new Exception("验收失败,网络原因,请重试"); } entityOfWood.Add(new SimpleProperty("Unique", typeof(int)), newUnique); /* 新增 */ newUnique = unique.GetValueByName(this._Dal.Table); if (newUnique <= 0) { throw new Exception("验收失败,网络原因,请重试"); } entity.SetValue("Unique", newUnique); entity.Add(new SimpleProperty("CheckDate", typeof(DateTime)), strCrateDate); entity.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entity.Add(new SimpleProperty("Version", typeof(int)), 1); entity.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\"}"); int affectedRows; affectedRows = this._Dal.InsertEntity(entity); // 添加记录到电子卡验收Check if (affectedRows > 0) { affectedRows = this._Dal.InsertBaseDataByOperator(entityOfWood); // 添加记录到木材表Wood } else { throw new Exception("验收失败,网络原因,请重试"); } if (affectedRows > 0) { affectedRows = cardStateBll.UpdateState(greenCardNumber.ToString(), (int)CardType.Green, (int)CardState.Door, entityOfWood.GetValue("Unique").ToInt32()); } else { throw new Exception("验收失败,网络原因,请重试"); } if (affectedRows > 0) { msg = "验收成功"; } else { throw new Exception("验收失败,网络原因,请重试"); } this._Dal.CommitTransaction(); return(Helper.GetEntity(true, msg, entity.GetValue("Unique").ToString())); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity SaveEntityByOperator(Entity entity, string greenCardNumber) { string strCrateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string msg = ""; string CtrlType = "NEW"; try { if (entity.GetValue("FullVolume") != null && entity.GetValue("FullVolume").ToString().Trim() == "") { entity.SetValue("FullVolume", null); } entity.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\",\"People\":\"" + entity.GetValue("Operator").ToString() + "\"}"); this._Dal.BeginTransaction(); UniqueDal unique = new UniqueDal(this._Dal.SqlTransaction); int affectedRows; /* 新增 */ if (entity.GetValue("Unique").TryInt32() == 0) { object woodID = entity.GetValue("WoodID"); object cardNumber = entity.GetValue("CardNumber"); RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); bool hasUseRecord = CheckForSaveEntityInsert(woodID, cardNumber, cardStateBll); entity.SetValue("Unique", unique.GetValueByName(this._Dal.Table)); entity.Add(new SimpleProperty("WeighTime", typeof(DateTime)), strCrateDate); entity.Add(new SimpleProperty("Printed", typeof(bool)), 0); entity.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entity.Add(new SimpleProperty("Version", typeof(int)), 1); affectedRows = this._Dal.InsertEntity(entity); affectedRows = cardStateBll.UpdateState(greenCardNumber, (int)CardType.Green, (int)CardState.Balance); if (hasUseRecord) { affectedRows = cardStateBll.UpdateState(cardNumber.ToString(), (int)CardType.Red, (int)CardState.Balance, woodID.ToInt32()); } else { affectedRows = cardStateBll.Insert(cardNumber.ToString(), (int)CardType.Red, (int)CardState.Balance, woodID.ToInt32(), (int)CardComeFrom.Weighbridge); } msg = "添加记录成功#" + strCrateDate; } /* 修改 */ else { CheckForSaveEntityUpdate(entity.GetValue("WoodID")); affectedRows = this._Dal.UpdateEntityByUniqueWithOperator(entity); msg = "修改记录成功"; CtrlType = "EDIT"; } this._Dal.CommitTransaction(); SyncFullVolumeData(entity, CtrlType); return(Helper.GetEntity(true, msg, entity.GetValue("Unique").ToString())); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity SaveEntityByOperator(Entity entity, string redCardNumber) { string strCrateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string msg = ""; try { string weightime = entity.GetValue("WeighTime").TryString(); string Key = entity.GetValue("Key").TryString(); this._Dal.BeginTransaction(); UniqueDal unique = new UniqueDal(this._Dal.SqlTransaction); entity.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\",\"People\":\"" + entity.GetValue("Operator").ToString() + "\"}"); int affectedRows; // 新增 if (entity.GetValue("Unique").TryInt32() == 0) { CheckForSaveEntityInsert(entity.GetValue("WoodID"), entity.GetValue("Operator")); if (this._Dal.IsExistsFactoryKey(weightime, Key) > 0) { throw new ValueDuplicatedException("添加失败,密码出现重复。"); } entity.SetValue("Unique", unique.GetValueByName(this._Dal.Table)); entity.Add(new SimpleProperty("SampleTime", typeof(DateTime)), strCrateDate); entity.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entity.Add(new SimpleProperty("Version", typeof(int)), 1); RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); affectedRows = this._Dal.InsertEntity(entity); affectedRows = cardStateBll.UpdateState(redCardNumber, (int)CardType.Red, (int)CardState.Sample); msg = "添加记录成功"; } // 修改 else { //CheckForSaveEntityUpdate(entity.GetValue("WoodID")); string OldKey = entity.GetValue("OldKey").TryString(); if (Key != OldKey) { if (this._Dal.IsExistsFactoryKey(weightime, Key) > 0) { throw new ValueDuplicatedException("修改失败,密码出现重复。"); } } affectedRows = this._Dal.UpdateEntityByUniqueWithOperator(entity); msg = "修改记录成功"; } this._Dal.CommitTransaction(); return(Helper.GetEntity(true, msg, entity.GetValue("Unique").ToString())); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }
public Entity SaveEntityByOperator(Entity entity, string greenCardNumber, string redCardNumber) { string strCrateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string msg = ""; try { if (entity.GetValue("EmptyVolume") != null && entity.GetValue("EmptyVolume").ToString().Trim() == "") { entity.SetValue("EmptyVolume", null); } if (entity.GetValue("HandVolume") != null && entity.GetValue("HandVolume").ToString().Trim() == "") { entity.SetValue("HandVolume", null); } if (entity.GetValue("RebateVolume") != null && entity.GetValue("RebateVolume").ToString().Trim() == "") { entity.SetValue("RebateVolume", null); } entity.Add(new SimpleProperty("Log", typeof(string)), "{\"Date\":\"" + strCrateDate + "\",\"People\":\"" + entity.GetValue("Operator").ToString() + "\"}"); this._Dal.BeginTransaction(); UniqueDal unique = new UniqueDal(this._Dal.SqlTransaction); int affectedRows; /* 新增 */ if (entity.GetValue("Unique").TryInt32() == 0) { CheckForSaveEntityInsert(entity.GetValue("WoodID")); entity.SetValue("Unique", unique.GetValueByName(this._Dal.Table)); //entity.Add(new SimpleProperty("BackWeighTime", typeof(DateTime)), strCrateDate); entity.SetValue("BackWeighTime", strCrateDate); entity.Add(new SimpleProperty("State", typeof(int)), StateEnum.Default); entity.Add(new SimpleProperty("Version", typeof(int)), 1); RfidCardBll cardStateBll = new RfidCardBll(this._Dal.SqlTransaction); affectedRows = this._Dal.InsertEntity(entity); affectedRows = cardStateBll.UpdateState(redCardNumber, (int)CardType.Red, (int)CardState.UnUse); affectedRows = cardStateBll.UpdateState(greenCardNumber, (int)CardType.Green, (int)CardState.EmptyBalance); msg = "添加记录成功"; } /* 修改 */ else { CheckForSaveEntityUpdate(entity.GetValue("WoodID")); affectedRows = this._Dal.UpdateEntityByUniqueWithOperator(entity); msg = "修改记录成功"; } this._Dal.CommitTransaction(); if (affectedRows > 0) { SyncEmptyVolumeData(entity); SyncVolumeDataForERP(entity, "ADDOREDIT"); } return(Helper.GetEntity(true, msg, entity.GetValue("Unique").ToString())); } catch (Exception exception) { this._Dal.RollbackTransaction(); return(Helper.GetEntity(false, exception.Message)); } }