public static PutawayTicketItem ReceiptTicketItemToPutawayTicketItem(ReceiptTicketItem receiptTicketItem, int putawayTicketID) { PutawayTicketItem putawayTicketItem = new PutawayTicketItem(); putawayTicketItem.PutawayTicketID = putawayTicketID; putawayTicketItem.ReceiptTicketItemID = receiptTicketItem.ID; putawayTicketItem.State = "待上架"; putawayTicketItem.ID = 0; return(putawayTicketItem); }
public static StockInfo PutawayTicketItemToStockInfo(PutawayTicketItem putawayTicketItem) { WMSEntities wmsEntities = new WMSEntities(); StockInfo stockInfo = new StockInfo(); stockInfo.ID = 0; stockInfo.ReceiptTicketItemID = putawayTicketItem.ReceiptTicketItemID; stockInfo.OverflowAreaAmount = 10000; ReceiptTicketItemView receiptTicketItemView = (from rti in wmsEntities.ReceiptTicketItemView where rti.ID == putawayTicketItem.ReceiptTicketItemID select rti).FirstOrDefault(); //TODO stockInfo.ProjectID = receiptTicketItemView.ReceiptTicketProjectID; //TODO stockInfo.WarehouseID = receiptTicketItemView.ReceiptTicketWarehouse; return(stockInfo); }
private void buttonReceiptCancel_Click(object sender, EventArgs e) { var worksheet = this.reoGridControlUser.Worksheets[0]; List <ReceiptTicketItem> ids = new List <ReceiptTicketItem>(); bool result; for (int i = 0; i < this.countRow; i++) { result = (worksheet[i, this.checkColumn] as bool?) ?? false; if (result == true) { int id; if (int.TryParse(worksheet[i, 0].ToString(), out id) == false) { MessageBox.Show(worksheet[i, 0].ToString() + "加入失败"); } else { ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == id select rti).FirstOrDefault(); if (receiptTicketItem.State != "已收货") { MessageBox.Show(receiptTicketItem.ID + "没有收货"); return; } else { ids.Add(receiptTicketItem); } } } } if (ids.Count == 0) { MessageBox.Show("请选择一项取消收货"); return; } else { foreach (ReceiptTicketItem i in ids) { //PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ID == i && pti.State != "已收货" && pti.State != "送检中" select pti).FirstOrDefault(); if (i == null) { MessageBox.Show(i + "不能取消"); } else { PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ReceiptTicketItemID == i.ID select pti).FirstOrDefault(); if (putawayTicketItem == null) { MessageBox.Show("不能取消"); } else { putawayTicketItem.State = "作废"; } i.State = "待收货"; } } new Thread(() => { try { wmsEntities.SaveChanges(); } catch { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } this.Invoke(new Action(() => { this.Search(); })); MessageBox.Show("已取消"); }).Start(); } /* * var worksheet = this.reoGridControlUser.Worksheets[0]; * bool result; * for (int i = 0; i < this.countRow; i++) * { * result = (worksheet[i, this.checkColumn] as bool?) ?? false; * if (result == true) * { * int id; * if (int.TryParse(worksheet[i, 0].ToString(), out id) == false) * { * MessageBox.Show(worksheet[i, 0].ToString() + "取消失败"); * } * else * { * ReceiptTicketItem receiptTicketItem = (from rti in this.wmsEntities.ReceiptTicketItem where rti.ID == id && rti.State != "作废" select rti).FirstOrDefault(); * PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ReceiptTicketItemID == id && pti.State != "作废" select pti).FirstOrDefault(); * if (putawayTicketItem != null) * { * putawayTicketItem.State = "作废"; * receiptTicketItem.State = "待检"; * } * else * { * MessageBox.Show(id.ToString() +"收货单条目没有上架"); * return; * } * } * } * } * new Thread(() => * { * * wmsEntities.SaveChanges(); * this.Invoke(new Action(() => * { * this.Search(); * })); * MessageBox.Show("取消成功"); * }).Start(); */ }
private void buttonPutaway_Click(object sender, EventArgs e) { var worksheet = this.reoGridControlUser.Worksheets[0]; List <ReceiptTicketItem> ids = new List <ReceiptTicketItem>(); bool result; for (int i = 0; i < this.countRow; i++) { result = (worksheet[i, this.checkColumn] as bool?) ?? false; if (result == true) { int id; if (int.TryParse(worksheet[i, 0].ToString(), out id) == false) { MessageBox.Show(worksheet[i, 0].ToString() + "加入失败"); } else { ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == id select rti).FirstOrDefault(); if (receiptTicketItem.State != "已收货") { MessageBox.Show(receiptTicketItem.ID + " " + receiptTicketItem.State + ",请先收货"); return; } else { ids.Add(receiptTicketItem); } } } } if (ids.Count == 0) { MessageBox.Show("请选择一项上架"); return; } else { foreach (ReceiptTicketItem i in ids) { //PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ID == i && pti.State != "已收货" && pti.State != "送检中" select pti).FirstOrDefault(); if (i == null) { MessageBox.Show(i + "不能添加此条目上架"); } else { PutawayTicketItem putawayTicketItem = new PutawayTicketItem(); putawayTicketItem.ReceiptTicketItemID = i.ID; putawayTicketItem.PutawayTicketID = this.putawayTicketID; putawayTicketItem.State = "待上架"; //putawayTicketItem.DisplacementPositionNo = "No"; //putawayTicketItem.TargetStorageLocation = "Location"; wmsEntities.PutawayTicketItem.Add(putawayTicketItem); i.State = "已收货"; } } new Thread(() => { try { wmsEntities.SaveChanges(); } catch { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } this.Invoke(new Action(() => { this.Search(); })); MessageBox.Show("添加成功"); }).Start(); } /* * bool result; * for (int i = 0; i < this.countRow; i++) * { * result = (worksheet[i, this.checkColumn] as bool?) ?? false; * if (result == true) * { * int id; * if (int.TryParse(worksheet[i, 0].ToString(), out id) == false) * { * MessageBox.Show(worksheet[i, 0].ToString() + "加入失败"); * } * else * { * * PutawayTicketItem putawayTicketItem = new PutawayTicketItem(); * ReceiptTicketItemView receiptTicketItemView = (from rti in this.wmsEntities.ReceiptTicketItemView where rti.ID == id select rti).FirstOrDefault(); * if (receiptTicketItemView != null) * { * if (receiptTicketItemView.State == "送检中") * { * MessageBox.Show("此条目已送检,不能收货"); * } * else * { * putawayTicketItem.ReceiptTicketItemID = id; * putawayTicketItem.PutawayTicketID = this.putawayTicketID; * putawayTicketItem.State = "待上架"; * putawayTicketItem.DisplacementPositionNo = "No"; * putawayTicketItem.TargetStorageLocation = "Location"; * wmsEntities.PutawayTicketItem.Add(putawayTicketItem); * } * } * else * { * MessageBox.Show(id.ToString() + "无此送检单条目"); * return; * } * } * } * } * new Thread(() => * { * * wmsEntities.SaveChanges(); * this.Invoke(new Action(() => * { * this.Search(); * })); * MessageBox.Show("添加成功"); * }).Start();*/ }
private void buttonFInished_Click(object sender, EventArgs e) { var worksheet = this.reoGridControlPutaway.Worksheets[0]; try { if (worksheet.SelectionRange.Rows != 1) { MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } int putawayTicketItemID; try { putawayTicketItemID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString()); } catch { MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ID == putawayTicketItemID select pti).FirstOrDefault(); decimal oldPutawayAmount = 0; if (putawayTicketItem.PutawayAmount == null) { if (putawayTicketItem.PutawayAmount == null) { putawayTicketItem.PutawayAmount = 0; } } oldPutawayAmount = (decimal)putawayTicketItem.PutawayAmount; if (putawayTicketItem == null) { MessageBox.Show("此上架单条目不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { if (this.Controls.Find("textBoxOperateTime", true)[0].Text == "") { this.Controls.Find("textBoxOperateTime", true)[0].Text = DateTime.Now.ToString(); } string errorInfo; if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicketItem, ReceiptMetaData.putawayTicketItemKeyName, out errorInfo) == false) { MessageBox.Show(errorInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { if (Utilities.CopyComboBoxsToProperties(this, putawayTicketItem, ReceiptMetaData.putawayTicketItemKeyName) == false) { MessageBox.Show("下拉框获取失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (putawayTicketItem.PutawayAmount == null) { MessageBox.Show("实际上架数量不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == putawayTicketItem.ReceiptTicketItemID select rti).FirstOrDefault(); if (putawayTicketItem.UnitAmount == null) { if (receiptTicketItem != null) { putawayTicketItem.UnitAmount = receiptTicketItem.UnitAmount; } } if (putawayTicketItem.PutawayAmount > putawayTicketItem.ScheduledMoveCount) { MessageBox.Show("实际上架数量不能大于计划上架数量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //putawayTicketItem.PutawayAmount = putawayTicketItem.UnitAmount * putawayTicketItem.MoveCount; putawayTicketItem.MoveCount = putawayTicketItem.PutawayAmount / putawayTicketItem.UnitAmount; StockInfo stockInfo = (from si in wmsEntities.StockInfo where si.ReceiptTicketItemID == putawayTicketItem.ReceiptTicketItemID select si).FirstOrDefault(); if (stockInfo != null) { stockInfo.OverflowAreaAmount -= putawayTicketItem.PutawayAmount - oldPutawayAmount; stockInfo.ShipmentAreaAmount += putawayTicketItem.PutawayAmount - oldPutawayAmount; } if (putawayTicketItem.ScheduledMoveCount == putawayTicketItem.PutawayAmount) { putawayTicketItem.State = "已上架"; } else if (putawayTicketItem.PutawayAmount == 0) { putawayTicketItem.State = "待上架"; } else { putawayTicketItem.State = "部分上架"; } wmsEntities.SaveChanges(); this.modifyMode(putawayTicketItem.PutawayTicketID); MessageBox.Show("上架成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Search(); if (CallBack != null) { CallBack(); } } } } catch (Exception) { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } }
private void buttonDelete_Click(object sender, EventArgs e) { var worksheet = this.reoGridControlPutaway.Worksheets[0]; try { if (worksheet.SelectionRange.Rows != 1) { MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } int putawayTicketItemID; try { putawayTicketItemID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString()); } catch { MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ID == putawayTicketItemID select pti).FirstOrDefault(); if (putawayTicketItem == null) { MessageBox.Show("错误 无法修改此条目", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (putawayTicketItem.State != "待上架") { MessageBox.Show("改上架单状态为" + putawayTicketItem.State + ",无法删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == putawayTicketItem.ReceiptTicketItemID select rti).FirstOrDefault(); if (receiptTicketItem != null) { receiptTicketItem.HasPutwayAmount -= putawayTicketItem.ScheduledMoveCount; } new Thread(() => { wmsEntities.SaveChanges(); PutawayTicket putawayTicket = putawayTicketItem.PutawayTicket; int n = 0; int m = 0; foreach (PutawayTicketItem pti in putawayTicket.PutawayTicketItem) { ReceiptTicketItem rtii = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == pti.ReceiptTicketItemID select rti).FirstOrDefault(); if (rtii != null) { if (pti.ScheduledMoveCount == rtii.HasPutwayAmount) { n++; } if (rtii.HasPutwayAmount == 0) { m++; } } } if (m == putawayTicket.PutawayTicketItem.Count) { ReceiptTicket receiptTicket = (from rt in wmsEntities.ReceiptTicket where rt.ID == putawayTicket.ReceiptTicketID select rt).FirstOrDefault(); if (receiptTicket != null) { receiptTicket.HasPutawayTicket = "没有生成上架单"; } } else { ReceiptTicket receiptTicket = (from rt in wmsEntities.ReceiptTicket where rt.ID == putawayTicket.ReceiptTicketID select rt).FirstOrDefault(); if (receiptTicket != null) { receiptTicket.HasPutawayTicket = "部分生成上架单"; } wmsEntities.SaveChanges(); wmsEntities.Database.ExecuteSqlCommand("DELETE FROM PutawayTicketItem WHERE ID = @putawayTicketItemID", new SqlParameter("putawayTicketItemID", putawayTicketItem.ID)); } this.Invoke(new Action(() => { this.pagerWidget.Search(); })); MessageBox.Show("成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); }).Start(); } } catch (Exception) { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } }
/* * private void Search() * { * this.labelStatus.Text = "搜索中..."; * try * { * new Thread(new ThreadStart(() => * { * var wmsEntities = new WMSEntities(); * //ReceiptTicketView[] receiptTicketViews = null; * PutawayTicketItemView[] putawayTicketItemView = null; * // * //try * //{ * // putawayTicketItemView = wmsEntities.Database.SqlQuery<PutawayTicketItemView>("SELECT * FROM PutawayTicketItemView WHERE PutawayTicketID=@putawayTicketID", new SqlParameter("putawayTicketID", putawayTicketID)).ToArray(); * //} * //catch * //{ * // MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); * // return; * //} * * PutawayTicketItemView[] putawayTicketItemViews1; * if (this.key != null && this.value != null) * { * putawayTicketItemViews1 = wmsEntities.Database.SqlQuery<PutawayTicketItemView>(string.Format("SELECT * FROM PutawayTicketItemView WHERE {0}=@value AND PutawayTicketWarehouseID = @warehouseID AND PutawayTicketProjectID = @projectID", key), new SqlParameter[] { new SqlParameter("value", value), new SqlParameter("warehouseID", this.warehouseID), new SqlParameter("projectID", this.projectID) }).ToArray(); * } * else * { * putawayTicketItemViews1 = wmsEntities.Database.SqlQuery<PutawayTicketItemView>("SELECT * FROM PutawayTicketItemView WHERE PutawayTicketWarehouseID = @warehouseID AND PutawayTicketProjectID = @projectID", new SqlParameter[] { new SqlParameter("warehouseID", this.warehouseID), new SqlParameter("projectID", this.projectID) }).ToArray(); * } * putawayTicketItemView = * (from ptiv in putawayTicketItemViews1 * where ptiv.PutawayTicketProjectID == this.projectID && ptiv.PutawayTicketWarehouseID == this.warehouseID * orderby ptiv.StockInfoShipmentAreaAmount / (ptiv.ComponentDailyProduction * ptiv.ComponentSingleCarUsageAmount) ascending, * ptiv.ReceiptTicketItemInventoryDate ascending * select ptiv).ToArray(); * S * // * //string sql = (from ptiv in wmsEntities.PutawayTicketItemView * // where ptiv.PutawayTicketProjectID == this.projectID && ptiv.PutawayTicketWarehouseID == this.warehouseID * // orderby ptiv.StockInfoShipmentAreaAmount / (ptiv.ComponentDailyProduction * ptiv.ComponentSingleCarUsageAmount) ascending, * // ptiv.ReceiptTicketItemInventoryDate ascending * // select ptiv).ToString(); * //Console.WriteLine(sql); * this.reoGridControlPutaway.Invoke(new Action(() => * { * this.labelStatus.Text = "搜索完成"; * var worksheet = this.reoGridControlPutaway.Worksheets[0]; * worksheet.DeleteRangeData(RangePosition.EntireRange); * int n = 0; * for (int i = 0; i < putawayTicketItemView.Length; i++) * { * if (putawayTicketItemView[i].State == "作废") * { * continue; * } * PutawayTicketItemView curputawayTicketItemView = putawayTicketItemView[i]; * object[] columns = Utilities.GetValuesByPropertieNames(curputawayTicketItemView, (from kn in ReceiptMetaData.putawayTicketItemKeyName select kn.Key).ToArray()); * for (int j = 0; j < worksheet.Columns; j++) * { * worksheet[n, j] = columns[j]; * } * n++; * } * })); * this.Invoke(new Action(() => { this.RefreshTextBoxes(); })); * })).Start(); * } * catch * { * MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); * return; * } * * }*/ private void buttonModify_Click(object sender, EventArgs e) { var worksheet = this.reoGridControlPutaway.Worksheets[0]; try { if (worksheet.SelectionRange.Rows != 1) { MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } int putawayTicketItemID; try { putawayTicketItemID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString()); } catch { MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ID == putawayTicketItemID select pti).FirstOrDefault(); if (putawayTicketItem == null) { MessageBox.Show("修改失败,该收货单可能已被删除,请刷新后查看!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } decimal oldPutawayAmount = 0; if (putawayTicketItem.PutawayAmount == null) { if (putawayTicketItem.PutawayAmount == null) { putawayTicketItem.PutawayAmount = 0; } } oldPutawayAmount = (decimal)putawayTicketItem.PutawayAmount; if (putawayTicketItem == null) { MessageBox.Show("此上架单条目不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { string errorInfo; if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicketItem, ReceiptMetaData.putawayTicketItemKeyName, out errorInfo) == false) { MessageBox.Show(errorInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { if (Utilities.CopyComboBoxsToProperties(this, putawayTicketItem, ReceiptMetaData.putawayTicketItemKeyName) == false) { MessageBox.Show("下拉框获取失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (putawayTicketItem.PutawayAmount == null) { MessageBox.Show("实际上架数量不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == putawayTicketItem.ReceiptTicketItemID select rti).FirstOrDefault(); if (putawayTicketItem.UnitAmount == null) { if (receiptTicketItem != null) { putawayTicketItem.UnitAmount = receiptTicketItem.UnitAmount; } } if (putawayTicketItem.PutawayAmount > putawayTicketItem.ScheduledMoveCount) { MessageBox.Show("实际上架数量不能大于计划上架数量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //putawayTicketItem.PutawayAmount = putawayTicketItem.UnitAmount * putawayTicketItem.MoveCount; putawayTicketItem.MoveCount = putawayTicketItem.PutawayAmount / putawayTicketItem.UnitAmount; StockInfo stockInfo = (from si in wmsEntities.StockInfo where si.ReceiptTicketItemID == putawayTicketItem.ReceiptTicketItemID select si).FirstOrDefault(); if (stockInfo != null) { stockInfo.OverflowAreaAmount -= putawayTicketItem.PutawayAmount - oldPutawayAmount; stockInfo.ShipmentAreaAmount += putawayTicketItem.PutawayAmount - oldPutawayAmount; } if (putawayTicketItem.ScheduledMoveCount == putawayTicketItem.PutawayAmount) { putawayTicketItem.State = "已上架"; } else if (putawayTicketItem.PutawayAmount == 0) { putawayTicketItem.State = "待上架"; } else { putawayTicketItem.State = "部分上架"; } wmsEntities.SaveChanges(); this.modifyMode(putawayTicketItem.PutawayTicketID); MessageBox.Show("上架成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Search(); } } } catch (Exception) { MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } /* * decimal oldPutawayAmount = 0; * var worksheet = this.reoGridControlPutaway.Worksheets[0]; * try * { * if (worksheet.SelectionRange.Rows != 1) * { * MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); * return; * } * int putawayTicketItemID; * try * { * putawayTicketItemID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString()); * } * catch * { * MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); * return; * } * PutawayTicketItem putawayTicketItem = (from pti in wmsEntities.PutawayTicketItem where pti.ID == putawayTicketItemID select pti).FirstOrDefault(); * if (putawayTicketItem.ScheduledMoveCount != null) * { * oldPutawayAmount = (decimal)putawayTicketItem.ScheduledMoveCount; * //return; * } * if (putawayTicketItem == null) * { * MessageBox.Show("错误 无法修改此条目", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); * } * else * { * string errorInfo; * if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicketItem, ReceiptMetaData.putawayTicketItemKeyName, out errorInfo) == false) * { * MessageBox.Show(errorInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); * return; * } * else * { * if (Utilities.CopyComboBoxsToProperties(this, putawayTicketItem,ReceiptMetaData.putawayTicketItemKeyName) == false) * { * MessageBox.Show("下拉框获取失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); * return; * } * ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == putawayTicketItem.ReceiptTicketItemID select rti).FirstOrDefault(); * if (receiptTicketItem != null) * { * receiptTicketItem.HasPutwayAmount += putawayTicketItem.ScheduledMoveCount - oldPutawayAmount; * } * if (this.JobPersonIDGetter() != -1) * { * this.jobPersonID = JobPersonIDGetter(); * } * if (this.ConfirmIDGetter() != -1) * { * this.confirmPersonID = ConfirmIDGetter(); * } * * putawayTicketItem.JobPersonID = this.jobPersonID; * putawayTicketItem.ConfirmPersonID = this.confirmPersonID; * new Thread(() => * { * * wmsEntities.SaveChanges(); * this.Invoke(new Action(() => * { * this.pagerWidget.Search(); * })); * MessageBox.Show("成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); * * * }).Start(); * } * } * } * * catch (Exception) * { * MessageBox.Show("无法连接到数据库,请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error); * return; * }*/ }