private void ShowPreview(bool qualifiedOnly)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
string strIDs = serializer.Serialize(inspectionNoteIDs);
var previewData = RestClient.Get <List <IDictionary <string, object> > >(Defines.ServerURL + "/warehouse/WMS_Template/inspection_note/preview/" + (qualifiedOnly ? "qualified/" : "") + strIDs); if (previewData == null)
{
return;
}
StandardFormPreviewExcel formPreviewExcel = new StandardFormPreviewExcel("送检单预览" + (qualifiedOnly ? " - 仅合格条目" : ""));
foreach (IDictionary <string, object> noteAndItem in previewData)
{
IDictionary <string, object> inspectionNote = (IDictionary <string, object>)noteAndItem["inspectionNote"];
object[] inspectionNoteItems = (object[])noteAndItem["inspectionNoteItems"];
string no = (string)inspectionNote["no"];
if (!formPreviewExcel.AddPatternTable("Excel/InspectionNote.xlsx", no))
{
return;
}
formPreviewExcel.AddData("inspectionNote", inspectionNote, no);
formPreviewExcel.AddData("inspectionNoteItems", inspectionNoteItems, no);
formPreviewExcel.SetPrintScale(0.8f, no);
}
formPreviewExcel.Show();
this.Close();
}
private void buttonCover_Click(object sender, EventArgs e)
{
StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("发货单预览");
WMSEntities wmsEntities = new WMSEntities();
foreach (int id in this.putOutStorageTicketIDs)
{
PutOutStorageTicketView putOutStorageTicketView = null;
ShipmentTicketView shipmentTicketView = null;
PutOutStorageTicketItemView[] putOutStorageTicketItemViews = null;
try
{
putOutStorageTicketView = (from p in wmsEntities.PutOutStorageTicketView
where p.ID == id
select p).FirstOrDefault();
putOutStorageTicketItemViews =
(from p in wmsEntities.PutOutStorageTicketItemView
where p.PutOutStorageTicketID == putOutStorageTicketView.ID
select p).ToArray();
if (putOutStorageTicketView == null)
{
MessageBox.Show("出库单" + putOutStorageTicketView.No + "不存在，可能已被删除，请重新查询！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
shipmentTicketView =
wmsEntities.Database.SqlQuery <ShipmentTicketView>(string.Format(@"SELECT * FROM ShipmentTicketView WHERE ID =
(SELECT ShipmentTicketID FROM JobTicket
WHERE JobTicket.ID = {0})", putOutStorageTicketView.JobTicketID)).FirstOrDefault();
}
catch
{
MessageBox.Show("加载失败，请检查网络连接！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string worksheetName = id.ToString();
if (formPreview.AddPatternTable(@"Excel\patternPutOutStorageTicketNormal.xlsx", worksheetName) == false)
{
this.Close();
return;
}
formPreview.AddData("putOutStorageTicket", putOutStorageTicketView, worksheetName);
formPreview.AddData("putOutStorageTicketItems", putOutStorageTicketItemViews, worksheetName);
formPreview.AddData("shipmentTicket", shipmentTicketView, worksheetName);
formPreview.SetPrintScale(0.9F, worksheetName);
}
formPreview.Show();
this.Close();
}
private void buttonZhongDuFlow_Click(object sender, EventArgs e)
{
StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("出库流水预览");
WMSEntities wmsEntities = new WMSEntities();
List <PutOutStorageTicketItemView> items = new List <PutOutStorageTicketItemView>();
foreach (int id in putOutStorageTicketIDs)
{
PutOutStorageTicketItemView[] putOutStorageTicketItemViews =
(from p in wmsEntities.PutOutStorageTicketItemView
where p.PutOutStorageTicketID == id
select p).ToArray();
items.AddRange(putOutStorageTicketItemViews);
}
if (formPreview.AddPatternTable(@"Excel\patternPutOutStorageTicketZhongDuFlow.xlsx") == false)
{
this.Close();
return;
}
formPreview.AddData("putOutStorageTicketItems", items.ToArray());
formPreview.SetPrintScale(1.2f);
formPreview.Show();
this.Close();
}
private void buttonAll_Click(object sender, EventArgs e)
{
WMSEntities wmsEntities = new WMSEntities();
StandardFormPreviewExcel standardFormPreviewExcel = new StandardFormPreviewExcel("送检单预览");
SubmissionTicket[] submissionTicket = idsToSubmissionTickets(this.ids);
try
{
foreach (SubmissionTicket st in submissionTicket)
{
string worksheetName = st.ID.ToString();
SubmissionTicketView submissionTicketView = (from stv in wmsEntities.SubmissionTicketView where stv.ID == st.ID select stv).FirstOrDefault();
SubmissionTicketItemView[] submissionTicketItemView =
(from p in wmsEntities.SubmissionTicketItemView
where p.SubmissionTicketID == st.ID
select p).ToArray();
ReceiptTicketView receiptTicketView = (from rt in wmsEntities.ReceiptTicketView where rt.ID == st.ReceiptTicketID select rt).FirstOrDefault();
if (standardFormPreviewExcel.AddPatternTable(@"Excel\SubmissionTicket.xlsx", worksheetName) == false)
{
this.Close();
return;
}
if (st != null)
{
standardFormPreviewExcel.AddData("SubmissionTicket", submissionTicketView, worksheetName);
}
if (receiptTicketView != null)
{
standardFormPreviewExcel.AddData("ReceiptTicket", receiptTicketView, worksheetName);
}
standardFormPreviewExcel.AddData("SubmissionTicketItem", submissionTicketItemView, worksheetName);
standardFormPreviewExcel.SetPrintScale(0.82f, worksheetName);
}
standardFormPreviewExcel.Show();
this.Close();
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
//StartPreview(submissionTicketItemView);
}
private void buttonPreview_Click(object sender, EventArgs e)
{
if (this.model1.SelectionRange == null)
{
MessageBox.Show("请选择要预览的入库单！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
List <int> ids = new List <int>();
for (int i = 0; i < this.model1.SelectionRange.Rows; i++)
{
int curRow = this.model1.SelectionRange.Row + i;
if (this.model1[curRow, "id"] == null)
{
continue;
}
ids.Add((int)this.model1[curRow, "id"]);
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string strIDs = serializer.Serialize(ids);
var previewData = RestClient.Get <List <IDictionary <string, object> > >(Defines.ServerURL + "/warehouse/WMS_Template/warehouse_entry/preview/" + strIDs);
if (previewData == null)
{
return;
}
StandardFormPreviewExcel formPreviewExcel = new StandardFormPreviewExcel("入库单预览");
foreach (IDictionary <string, object> entryAndItem in previewData)
{
IDictionary <string, object> warehouseEntry = (IDictionary <string, object>)entryAndItem["warehouseEntry"];
object[] warehouseEntryItems = (object[])entryAndItem["warehouseEntryItems"];
string no = (string)warehouseEntry["no"];
if (!formPreviewExcel.AddPatternTable("Excel/WarehouseEntry.xlsx", no))
{
return;
}
formPreviewExcel.AddData("warehouseEntry", warehouseEntry, no);
formPreviewExcel.AddData("warehouseEntryItems", warehouseEntryItems, no);
}
formPreviewExcel.Show();
//ushort height = 50;
//formPreviewExcel.SetAllCowsHeigth(5,5,height);
}
private void buttonPreview_Click(object sender, EventArgs e)
{
if (this.model1.SelectionRange == null)
{
MessageBox.Show("请选择要预览的盘点单！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
List <int> ids = new List <int>();
for (int i = 0; i < this.model1.SelectionRange.Rows; i++)
{
int curRow = this.model1.SelectionRange.Row + i;
if (this.model1[curRow, "id"] == null)
{
continue;
}
ids.Add((int)this.model1[curRow, "id"]);
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string strIDs = serializer.Serialize(ids);
var previewData = RestClient.Get <List <IDictionary <string, object> > >(Defines.ServerURL + "/warehouse/WMS_Template/transfer_order/preview/" + strIDs);
if (previewData == null)
{
return;
}
StandardFormPreviewExcel formPreviewExcel = new StandardFormPreviewExcel("上架单预览");
foreach (IDictionary <string, object> entryAndItem in previewData)
{
IDictionary <string, object> transferOrder = (IDictionary <string, object>)entryAndItem["transferOrder"];
object[] transferOrderItems = (object[])entryAndItem["transferOrderItems"];
string no = (string)transferOrder["no"];
if (!formPreviewExcel.AddPatternTable("Excel/PutAwayNote.xlsx", no))
{
return;
}
formPreviewExcel.AddData("putAwayTicket", transferOrder, no);
formPreviewExcel.AddData("putAwayTicketItems", transferOrderItems, no);
}
formPreviewExcel.Show();
}
private void buttonMoBiSi_Click(object sender, EventArgs e)
{
StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("出库单预览");
WMSEntities wmsEntities = new WMSEntities();
if (putOutStorageTicketIDs.Length > 1)
{
MessageBox.Show("摩比斯格式暂不支持批量打印", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
return;
}
int id = putOutStorageTicketIDs[0];
PutOutStorageTicketView putOutStorageTicketView = (from p in wmsEntities.PutOutStorageTicketView
where p.ID == id
select p).FirstOrDefault();
PutOutStorageTicketItemView[] putOutStorageTicketItemViews =
(from p in wmsEntities.PutOutStorageTicketItemView
where p.PutOutStorageTicketID == putOutStorageTicketView.ID
select p).ToArray();
if (putOutStorageTicketView == null)
{
MessageBox.Show("出库单不存在，请重新查询！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShipmentTicketView shipmentTicketView =
wmsEntities.Database.SqlQuery <ShipmentTicketView>(string.Format(@"SELECT * FROM ShipmentTicketView WHERE ID =
(SELECT ShipmentTicketID FROM JobTicket
WHERE JobTicket.ID = {0})", putOutStorageTicketView.JobTicketID)).FirstOrDefault();
int[] supplierIDs = (from item in putOutStorageTicketItemViews
where item.SupplierID != null
select item.SupplierID.Value).ToArray();
Supplier[] suppliers = (from s in wmsEntities.Supplier
where supplierIDs.Contains(s.ID)
select s).ToArray();
foreach (Supplier supplier in suppliers)
{
formPreview.AddPatternTable(@"Excel\patternPutOutStorageTicketMoBiSi.xlsx", supplier.Name);
formPreview.AddData("ticket", putOutStorageTicketView, supplier.Name);
formPreview.AddData("items", (from item in putOutStorageTicketItemViews where item.SupplierID == supplier.ID select item).ToArray(), supplier.Name);
formPreview.AddData("shipmentTicket", shipmentTicketView, supplier.Name);
formPreview.AddData("supplier", supplier, supplier.Name);
}
//没有供应商信息的单独显示一个tab（非正常情况）
PutOutStorageTicketItemView[] noSupplierItems = (from item in putOutStorageTicketItemViews
where item.SupplierID == null
select item).ToArray();
if (noSupplierItems.Length > 0)
{
formPreview.AddPatternTable(@"Excel\patternPutOutStorageTicketMoBiSi.xlsx", "无供应商");
formPreview.AddData("ticket", putOutStorageTicketView, "无供应商");
formPreview.AddData("items", noSupplierItems, "无供应商");
formPreview.AddData("shipmentTicket", shipmentTicketView, "无供应商");
formPreview.AddData("supplier", default(Supplier), "无供应商");
}
formPreview.Show();
this.Close();
}
private void buttonPreview_Click(object sender, EventArgs e)
{
var worksheet = this.reoGridControlMain.Worksheets[0];
StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("盘点单预览");
if (formPreview.SetPatternTable(@"Excel\StockInfoCheckTicket.xlsx") == false)
{
this.Close();
return;
}
WMSEntities wmsEntities = new WMSEntities();
if (worksheet.SelectionRange.Rows != 1)
{
MessageBox.Show("请选择一项进行预览", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int stockInfoCheckID;
try
{
stockInfoCheckID = int.Parse(worksheet[worksheet.SelectionRange.Row, 0].ToString());
}
catch
{
MessageBox.Show("请选择一项导出", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
StockInfoCheckTicket stockInfoCheck1 = null;
try
{
wmsEntities = new WMSEntities();
stockInfoCheck1 = (from s in wmsEntities.StockInfoCheckTicket
where s.ID == stockInfoCheckID
select s).FirstOrDefault();
}
catch
{
MessageBox.Show("加载盘点单数据失败，请检查网络连接", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
return;
}
if (stockInfoCheck1 == null)
{
MessageBox.Show("要查看的项目已不存在，请确认后操作！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
return;
}
StockInfoCheckTicketView StockInfoCheckTicketView = (from stv in wmsEntities.StockInfoCheckTicketView
where stv.ID == stockInfoCheckID
select stv).FirstOrDefault();
StockInfoCheckTicketItemView [] StockInfoCheckTicketItemView =
(from p in wmsEntities.StockInfoCheckTicketItemView
where p.StockInfoCheckTicketID == StockInfoCheckTicketView.ID
select p).ToArray();
if (StockInfoCheckTicketView == null)
{
MessageBox.Show("盘点单不存在，请重新查询！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (StockInfoCheckTicketView != null)
{
formPreview.AddData("StockInfoCheckTicket", StockInfoCheckTicketView);
}
formPreview.AddData("StockInfoCheckTicketItem", StockInfoCheckTicketItemView);
formPreview.Show();
}