private void button1_Click(object sender, EventArgs e)
{
Report.Backlog.BacklogReport backlog = new BacklogReport();
dtOrder = backlog.GetDataProductionOrder2(dtpk_To.Value);
DicOrderStock = new Dictionary <string, Planning.SemiFinishedGoods>();
DicListSemiFGs = new Dictionary <string, List <Planning.SemiFinishedGoods> >();
DicProductionOrder = new Dictionary <string, DataTable>();
for (int i = 0; i < dtOrder.Rows.Count; i++)
{
string CO_Code = dtOrder.Rows[i]["Code_Type"].ToString().Trim();
string CO_No = dtOrder.Rows[i]["Code_No"].ToString().Trim();
string CO_STT = dtOrder.Rows[i]["STT"].ToString().Trim();
string product = dtOrder.Rows[i]["Product_Code"].ToString().Trim();
string ClientOrder = dtOrder.Rows[i]["Code_Type"].ToString().Trim() + "-" + dtOrder.Rows[i]["Code_No"].ToString().Trim() + "-" + dtOrder.Rows[i]["STT"].ToString().Trim();
Planning.SemiFinishedGoods semiFinishedGoods = new Planning.SemiFinishedGoods();
Planning.Controler.GetSemiFinishedgoods getSemi = new Planning.Controler.GetSemiFinishedgoods();
semiFinishedGoods = getSemi.GetStockGoodsONSFT("", product);
List <Planning.SemiFinishedGoods> semis = getSemi.ListGetSemiFinishedGoods("", product);
Planning.Controler.GetProductionOrder getProductionOrder = new Planning.Controler.GetProductionOrder();
var dtPO = getProductionOrder.GetProductionOrderStatus(CO_Code, CO_No, CO_STT);
DicOrderStock.Add(ClientOrder, semiFinishedGoods);
DicListSemiFGs.Add(ClientOrder, semis);
DicProductionOrder.Add(ClientOrder, dtPO);
}
dataGridView1.DataSource = dtOrder;
}
private void Btn_backlogReport_Click(object sender, EventArgs e)
{
string pathsave = "";
System.Windows.Forms.SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "Browse Excel Files";
saveFileDialog.DefaultExt = "Excel";
saveFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx";
saveFileDialog.CheckPathExists = true;
if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
pathsave = saveFileDialog.FileName;
saveFileDialog.RestoreDirectory = true;
Report.Backlog.BacklogReport backlogReport = new Report.Backlog.BacklogReport();
backlogReport.ExportExcelToReport(pathsave, Class.valiballecommon.GetStorage()._version);
var resultMessage = MessageBox.Show("Production Plan export to excel sucessful ! \n\r Do you want to open this file ?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (resultMessage == DialogResult.Yes)
{
FileInfo fi = new FileInfo(pathsave);
if (fi.Exists)
{
System.Diagnostics.Process.Start(pathsave);
}
else
{
MessageBox.Show("File doestn't exist !", "warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}