private void modifyMode(int putawayTicketID)
{
WMSEntities wmsEntities = new WMSEntities();
PutawayTicket putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == putawayTicketID select pt).FirstOrDefault();
if (putawayTicket == null)
{
return;
}
int all = (from pti in wmsEntities.PutawayTicketItem where pti.PutawayTicketID == putawayTicketID select pti).ToArray().Length;
int yes = (from pti in wmsEntities.PutawayTicketItem where pti.PutawayTicketID == putawayTicketID && pti.State == "已上架" select pti).ToArray().Length;
int part = (from pti in wmsEntities.PutawayTicketItem where pti.PutawayTicketID == putawayTicketID && pti.State == "部分上架" select pti).ToArray().Length;
int no = (from pti in wmsEntities.PutawayTicketItem where pti.PutawayTicketID == putawayTicketID && pti.State == "待上架" select pti).ToArray().Length;
if (all == yes)
{
putawayTicket.State = "已上架";
}
else if (all == no)
{
putawayTicket.State = "待上架";
}
else
{
putawayTicket.State = "部分上架";
}
wmsEntities.SaveChanges();
}
private void buttonModify_Click(object sender, EventArgs e)
{
var worksheet = this.reoGridControlPutaway.Worksheets[0];
try
{
if (worksheet.SelectionRange.Rows != 1)
{
throw new Exception();
}
int putawayTicketID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString());
PutawayTicket putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == putawayTicketID select pt).Single();
string errorInfo;
if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicket, ReceiptMetaData.putawayTicketKeyName, out errorInfo) == false)
{
putawayTicket.LastUpdateTime = DateTime.Now;
putawayTicket.LastUpdateUserID = this.userID;
MessageBox.Show(errorInfo);
Search();
return;
}
else
{
new Thread(() =>
{
try
{
wmsEntities.SaveChanges();
Search();
MessageBox.Show("成功");
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
}).Start();
}
}
catch
{
MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
private void FormPutawayModify_Load(object sender, EventArgs e)
{
//InitComponent();
Utilities.CreateEditPanel(this.tableLayoutPanelTextBoxes, ReceiptMetaData.putawayTicketKeyName);
this.PersonIDGetter = Utilities.BindTextBoxSelect <FormSelectPerson, Person>(this, "textBoxPersonName", "Name");
putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == this.putawayTicketID select pt).FirstOrDefault();
PutawayTicketView putawayTicketView = (from ptv in wmsEntities.PutawayTicketView where ptv.ID == this.putawayTicketID select ptv).FirstOrDefault();
if (putawayTicketView == null)
{
MessageBox.Show("找不到该上架单", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this);
Utilities.CopyPropertiesToComboBoxes(putawayTicketView, this);
}
}
private void buttonCreatePutaway_Click(object sender, EventArgs e)
{
PutawayTicket putawayTicket = new PutawayTicket();
string errorInfo;
if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicket, ReceiptMetaData.putawayTicketKeyName, out errorInfo) == false)
{
MessageBox.Show(errorInfo);
return;
}
else
{
putawayTicket.ReceiptTicketID = this.receiptTicketID;
putawayTicket.CreateTime = DateTime.Now;
putawayTicket.CreateUserID = this.userID;
putawayTicket.LastUpdateTime = DateTime.Now;
putawayTicket.LastUpdateUserID = this.userID;
putawayTicket.WarehouseID = this.warehouseID;
putawayTicket.ProjectID = this.projectID;
putawayTicket.State = "待上架";
new Thread(() =>
{
try
{
wmsEntities.PutawayTicket.Add(putawayTicket);
wmsEntities.SaveChanges();
putawayTicket.No = Utilities.GenerateNo("P", putawayTicket.ID);
wmsEntities.SaveChanges();
this.Invoke(new Action(() => Search()));
MessageBox.Show("成功");
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
}).Start();
}
}
private void buttonOK_Click(object sender, EventArgs e)
{
WMSEntities wmsEntities = new WMSEntities();
PutawayTicket putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == putawayTicketID select pt).FirstOrDefault();
if (putawayTicket == null)
{
MessageBox.Show("该上架单已被删除");
return;
}
string errorInfo;
if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicket, ReceiptMetaData.putawayTicketKeyName, out errorInfo) == false)
{
MessageBox.Show(errorInfo);
return;
}
else
{
if (this.PersonIDGetter() != -1)
{
putawayTicket.PersonID = PersonIDGetter();
}
new Thread(() =>
{
wmsEntities.SaveChanges();
MessageBox.Show("修改成功");
CallBack();
}).Start();
}
/*
* PutawayTicket putawayTicket;
* if (this.formMode == FormMode.ADD)
* {
* putawayTicket = new PutawayTicket();
* }
* else
* {
* putawayTicket = (from pt in this.wmsEntities.PutawayTicket where pt.ID == this.putawayTicketID select pt).Single();
* }
* string errorInfo;
* if (Utilities.CopyTextBoxTextsToProperties(this, putawayTicket, ReceiptMetaData.putawayTicketKeyName, out errorInfo) == false)
* {
* MessageBox.Show(errorInfo);
* CallBack();
* }
* else
* {
* new Thread(() =>
* {
*
* if (this.formMode == FormMode.ADD)
* {
* this.wmsEntities.PutawayTicket.Add(putawayTicket);
* wmsEntities.SaveChanges();
* wmsEntities.Database.ExecuteSqlCommand(String.Format("UPDATE ReceiptTicket SET State='收货' WHERE ID={0}", this.receiptTicketID));
* ReceiptTicketItem[] receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ReceiptTicketID == this.receiptTicketID && rti.State != "作废" select rti).ToArray();
* PutawayTicket putawayTicket1 = (from pt in wmsEntities.PutawayTicket where pt.ReceiptTicketID == receiptTicketID select pt).FirstOrDefault();
* foreach (ReceiptTicketItem rti in receiptTicketItem)
* {
* rti.State = "收货";
*
* wmsEntities.PutawayTicketItem.Add(ReceiptUtilities.ReceiptTicketItemToPutawayTicketItem(rti, putawayTicket1.ID));
* try
* {
* wmsEntities.SaveChanges();
* }
* catch
* {
* MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
* return;
* }
* }
*
* }
* else
* {
* try
* {
* this.wmsEntities.SaveChanges();
* }
* catch
* {
* MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
* return;
* }
* }
* }).Start();
* }
*
* this.CallBack();
* this.Close();*/
}
private void buttonCancel_Click(object sender, EventArgs e)
{
int putawayTicketID;
if (int.TryParse(this.value, out putawayTicketID) == false)
{
MessageBox.Show("system error!", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.putawayTicketID == -1)
{
return;
}
if (MessageBox.Show("是否将此上架单中所有上架单条目上架？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
PutawayTicket putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == putawayTicketID select pt).FirstOrDefault();
if (putawayTicket == null)
{
MessageBox.Show("该上架单已被删除，请刷新后查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PutawayTicketItem[] putawayTicketItems = putawayTicket.PutawayTicketItem.ToArray();
int n = 0;
foreach (PutawayTicketItem pti in putawayTicketItems)
{
if (pti.State == "已上架")
{
n++;
}
}
if (n == putawayTicketItems.Length)
{
MessageBox.Show("该上架单已全部上架！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
foreach (PutawayTicketItem pti in putawayTicketItems)
{
decimal oldPutawayAmount = (pti.PutawayAmount == null ? 0 : (decimal)pti.PutawayAmount);
pti.PutawayAmount = pti.ScheduledMoveCount;
//pti.PutawayAmount = pti.UnitAmount * pti.MoveCount;
pti.UnitCount = pti.PutawayAmount / pti.UnitAmount;
pti.OperateTime = DateTime.Now.ToString();
pti.State = "已上架";
//ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == pti.ReceiptTicketItemID select rti).FirstOrDefault();
StockInfo stockInfo = (from si in wmsEntities.StockInfo where si.ReceiptTicketItemID == pti.ReceiptTicketItemID select si).FirstOrDefault();
if (stockInfo != null)
{
stockInfo.OverflowAreaAmount -= pti.PutawayAmount - oldPutawayAmount;
stockInfo.ShipmentAreaAmount += pti.PutawayAmount - oldPutawayAmount;
}
}
putawayTicket.State = "已上架";
wmsEntities.SaveChanges();
MessageBox.Show("上架成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Search();
CallBack();
/*
* 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();
* new Thread(() =>
* {
* if (putawayTicketItem == null)
* {
* MessageBox.Show("找不到该上架单，可能已被删除");
* return;
* }
* else
* {
* putawayTicketItem.State = "待上架";
* wmsEntities.SaveChanges();
* int count = wmsEntities.Database.SqlQuery<int>(
* "SELECT COUNT(*) FROM PutawayTicketItem " +
* "WHERE PutawayTicketID = @putawayTicketID AND State <> '待上架'",
* new SqlParameter("putawayTicketID", putawayTicketItem.PutawayTicketID)).FirstOrDefault();
*
* if (count == 0)
* {
* wmsEntities.Database.ExecuteSqlCommand(
* "UPDATE PutawayTicket SET State = '待上架' " +
* "WHERE ID = @putawayTicketID",
* new SqlParameter("putawayTicketID", putawayTicketItem.PutawayTicketID));
* }
* else
* {
* wmsEntities.Database.ExecuteSqlCommand(
* "UPDATE PutawayTicket SET State = '部分上架' " +
* "WHERE ID = @putawayTicketID",
* new SqlParameter("putawayTicketID", putawayTicketItem.PutawayTicketID));
* }
* }
* StockInfo stockInfo = (from si in wmsEntities.StockInfo where si.ReceiptTicketItemID == putawayTicketItem.ReceiptTicketItemID select si).FirstOrDefault();
* if (stockInfo != null)
* {
* if (stockInfo.OverflowAreaAmount != null)
* {
* int amount = (int)stockInfo.OverflowAreaAmount;
* if (stockInfo.ReceiptAreaAmount != null)
* {
* stockInfo.ReceiptAreaAmount += amount;
* }
* else
* {
* stockInfo.ReceiptAreaAmount = amount;
* }
* stockInfo.OverflowAreaAmount = 0;
* }
* }
* wmsEntities.SaveChanges();
* //MessageBox.Show("成功");
* this.Invoke(new Action(() =>
* {
* this.pagerWidget.Search();
* CallBack();
* }));
* }).Start();
* }
*
* 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 toolStripButton1_Click(object sender, EventArgs e)
{
var worksheet = this.reoGridControlUser.Worksheets[0];
StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("上架单预览");
WMSEntities wmsEntities = new WMSEntities();
int[] ids = Utilities.GetSelectedIDs(this.reoGridControlUser);
if (ids.Length == 0)
{
MessageBox.Show("请选择一项预览", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
foreach (int id in ids)
{
try
{
PutawayTicketView putawayTicketView = (from ptv in wmsEntities.PutawayTicketView where ptv.ID == id select ptv).FirstOrDefault();
PutawayTicketItemView[] putawayTicketItemView = (from ptiv in wmsEntities.PutawayTicketItemView where ptiv.PutawayTicketID == putawayTicketView.ID select ptiv).ToArray <PutawayTicketItemView>();
string worksheetName = id.ToString();
if (putawayTicketView == null)
{
MessageBox.Show("上架单不存在，请重新查询！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//ReceiptTicketView receiptTicketView = (from rtv in wmsEntities.ReceiptTicketView where rtv.ID == submissionTicketView.ReceiptTicketID select rtv).FirstOrDefault();
if (formPreview.AddPatternTable(@"Excel\PutawayTicket.xlsx", worksheetName) == false)
{
this.Close();
return;
}
if (putawayTicketView != null)
{
formPreview.AddData("PutawayTicket", putawayTicketView, worksheetName);
}
formPreview.AddData("PutawayTicketItem", putawayTicketItemView, worksheetName);
formPreview.SetPrintScale(1.0F, worksheetName);
}
catch
{
MessageBox.Show("搜索失败，请检查网络连接！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
formPreview.SetPrintedCallback(new Action(() =>
{
WMSEntities wmsEntities2 = new WMSEntities();
foreach (int id in ids)
{
PutawayTicket putawayTicket = (from pt in wmsEntities2.PutawayTicket where pt.ID == id select pt).FirstOrDefault();
if (putawayTicket != null)
{
if (putawayTicket.PrintTimes == null)
{
putawayTicket.PrintTimes = 0;
}
putawayTicket.PrintTimes++;
}
}
new Thread(() =>
{
wmsEntities2.SaveChanges();
Search();
}).Start();
}));
//formPreview.AddData("SubmissionTicketItem", submissionTicketItemView);
formPreview.Show();
}
private void toolStripButtonDelete_Click(object sender, EventArgs e)
{
var worksheet = this.reoGridControlUser.Worksheets[0];
List <int> deleteIDs = new List <int>();
for (int i = 0; i < worksheet.SelectionRange.Rows; i++)
{
try
{
int curID = int.Parse(worksheet[i + worksheet.SelectionRange.Row, 0].ToString());
deleteIDs.Add(curID);
}
catch
{
continue;
}
}
if (deleteIDs.Count == 0)
{
MessageBox.Show("请选择您要删除的记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("您真的要删除这些记录吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
WMSEntities wmsEntities = new WMSEntities();
foreach (int id in deleteIDs)
{
//if (MessageBox.Show("确定删除该上架单？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
//{
PutawayTicket putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == id select pt).FirstOrDefault();
if (putawayTicket == null)
{
MessageBox.Show("该上架单已被删除，请刷新查看!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
return;
}
//if (putawayTicket.State != "待上架")
//{
// MessageBox.Show("该上架单已有部分或者全部上架，无法删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
// continue;
//}
ReceiptTicket receiptTicket = (from rt in wmsEntities.ReceiptTicket where rt.ID == putawayTicket.ReceiptTicketID select rt).FirstOrDefault();
PutawayTicketItem[] putawayTicketItems = putawayTicket.PutawayTicketItem.ToArray();
int n = 0;
foreach (PutawayTicketItem pti in putawayTicketItems)
{
ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == pti.ReceiptTicketItemID select rti).FirstOrDefault();
if (receiptTicketItem != null)
{
receiptTicketItem.HasPutwayAmount -= (pti.ScheduledMoveCount == null ? 0 : pti.ScheduledMoveCount) - (pti.PutawayAmount == null ? 0 : pti.PutawayAmount);
//receiptTicketItem.HasPutwayAmount += pti.PutawayAmount;
if (receiptTicketItem.HasPutwayAmount == 0)
{
n++;
}
}
}
if (n == putawayTicketItems.Length)
{
receiptTicket.HasPutawayTicket = "未生成上架单";
}
else
{
receiptTicket.HasPutawayTicket = "部分生成上架单";
}
try
{
wmsEntities.Database.ExecuteSqlCommand("DELETE FROM PutawayTicket WHERE ID = @putawayTicketID", new SqlParameter("putawayTicketID", id));
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
//}
}
MessageBox.Show("成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
try
{
new Thread(() =>
{
wmsEntities.SaveChanges();
this.Invoke(new Action(() =>
{
if (this.key != null || this.value != null)
{
pagerWidget.AddCondition(this.key, this.value);
}
pagerWidget.Search();
}));
}).Start();
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
//var worksheet = this.reoGridControlUser.Worksheets[0];
//try
//{
/*
* if (worksheet.SelectionRange.Rows != 1)
* {
* MessageBox.Show("请选择一项进行查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* return;
* }
* int putawayTicketID;
* try
* {
* putawayTicketID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString());
* }
* catch
* {
* MessageBox.Show("请选择一项进行查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* return;
* } */
//FormShelvesItem formShelvesItem = new FormShelvesItem(putawayTicketID);
/*
* if (MessageBox.Show("确定删除该上架单？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
* {
* PutawayTicket putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == putawayTicketID select pt).FirstOrDefault();
* if (putawayTicket == null)
* {
* MessageBox.Show("该上架单已被删除，请刷新查看!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
* return;
* }
* if (putawayTicket.State != "待上架")
* {
* MessageBox.Show("该上架单已有部分或者全部上架，无法删除", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
* return;
* }
* ReceiptTicket receiptTicket = (from rt in wmsEntities.ReceiptTicket where rt.ID == putawayTicket.ReceiptTicketID select rt).FirstOrDefault();
* PutawayTicketItem[] putawayTicketItems = putawayTicket.PutawayTicketItem.ToArray();
* int n = 0;
* foreach (PutawayTicketItem pti in putawayTicketItems)
* {
* ReceiptTicketItem receiptTicketItem = (from rti in wmsEntities.ReceiptTicketItem where rti.ID == pti.ReceiptTicketItemID select rti).FirstOrDefault();
* if (receiptTicketItem != null)
* {
* receiptTicketItem.HasPutwayAmount -= pti.ScheduledMoveCount;
* if (receiptTicketItem.HasPutwayAmount == 0)
* {
* n++;
* }
* }
* }
* if (n == putawayTicketItems.Length)
* {
* receiptTicket.HasPutawayTicket = "未生成上架单";
* }
* else
* {
* receiptTicket.HasPutawayTicket = "部分生成上架单";
* }
* try
* {
* new Thread(() =>
* {
* wmsEntities.Database.ExecuteSqlCommand("DELETE FROM PutawayTicket WHERE ID = @putawayTicketID", new SqlParameter("putawayTicketID", putawayTicketID));
* wmsEntities.SaveChanges();
* MessageBox.Show("成功");
* this.Invoke(new Action(() =>
* {
* if (this.key != null || this.value != null)
* {
* pagerWidget.AddCondition(this.key, this.value);
* }
* pagerWidget.Search();
* }));
* }).Start();
* }
* catch (EntityException)
* {
* MessageBox.Show("该上架单已被删除!");
* }
* catch (Exception)
* {
* MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
* return;
* }
* }
* }
* catch
* {
* MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
* return;
* }*/
}
private void toolStripButtonItem_Click(object sender, EventArgs e)
{
var worksheet = this.reoGridControlUser.Worksheets[0];
try
{
WMSEntities wmsEntities = new WMSEntities();
if (worksheet.SelectionRange.Rows != 1)
{
MessageBox.Show("请选择一项进行修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int putawayTicketID;
try
{
putawayTicketID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString());
}
catch
{
MessageBox.Show("请选择一项进行查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PutawayTicket putawayTicket = (from rt in wmsEntities.PutawayTicket where rt.ID == putawayTicketID select rt).FirstOrDefault();
if (putawayTicket == null)
{
MessageBox.Show("该收货单不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
string key = "上架单ID";
string name = (from r in ReceiptMetaData.receiptNameKeys where r.Key == key select r.Name).FirstOrDefault();
string value = putawayTicket.ID.ToString();
//ToPutaway(key, value);
FormShelvesItem formShelvesItem = new FormShelvesItem(this.projectID, this.warehouseID, this.userID, "上架单ID", value);
formShelvesItem.SetCallBack(new Action(() =>
{
this.Search();
}));
formShelvesItem.Show();
}
}
catch (Exception)
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
/*
* var worksheet = this.reoGridControlUser.Worksheets[0];
* try
* {
* if (worksheet.SelectionRange.Rows != 1)
* {
* MessageBox.Show("请选择一项进行查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* return;
* }
* int putawayTicketID;
* try
* {
* putawayTicketID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString());
* }
* catch
* {
* MessageBox.Show("请选择一项进行查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
* return;
* }
* FormShelvesItem formShelvesItem = new FormShelvesItem(putawayTicketID);
* formShelvesItem.SetCallBack(new Action(() =>
* {
* this.Search(null, null);
* }));
* formShelvesItem.Show();
* }
*
* catch (Exception)
* {
* MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
* return;
* } */
}
