private void ItemClickEventHandler_TRACE(object sender, EventArgs e)
{
R_OF_Tracebility RTR = new R_OF_Tracebility();
RTR.OF = gridView2.GetFocusedRowCellValue("CD_OF").ToString();
RTR.Show();
}
private void ItemClickEventHandler_Report(object sender, EventArgs e)
{
if (lkeCD_OF.EditValue.ToString() != "[Please click and select Production Order]")
{
try
{
R_OF_Tracebility RTR = new R_OF_Tracebility();
RTR.OF = lkeCD_OF.EditValue.ToString();
RTR.Show();
}
catch (Exception ex)
{
throw ex;
}
}
}
public F_OF_List()
{
InitializeComponent();
Load += (s, e) =>
{
gridControl1.DataSource = _oFBUS.F_OF_List();
gridView1.BestFitColumns();
//2018-09-25
//Load OF từ Nutriciel
//DataTable dt2 = new DataTable();
//dt2 = OFB.F_OF_Finished();
//gridControl2.DataSource = dt2;
//sYNC_NUTRICIELDataSet.tbl_OF_Finished.Clear();
//gridControl2.DataSource = tbl_OF_FinishedTableAdapter.Fill(sYNC_NUTRICIELDataSet.tbl_OF_Finished);
gridControl2.DataSource = _oFBUS.F_OF_Finished();
gridView2.BestFitColumns();
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////Load dữ liệu từ MF lên grid
////gridControl2.DataSource = CSV.ConvertCsvStringToDataTable(true, @"D:\\Eresis\\EXCHANGES\\OUT\\MP_1199.CSV");
////gridControl2.DataSource =CSV.OpenCsvFileAsDataTable(@"D:\\Eresis\\EXCHANGES\\OUT\\MP_1199.CSV", false);
this.repositoryItemLookUpEdit1.DataSource = _oFBUS.CD_OF_Finished();
};
action1.View(new DevExpress.XtraBars.ItemClickEventHandler(ItemClickEventHandler_View));
action1.CSV(new DevExpress.XtraBars.ItemClickEventHandler(ItemClickEventHandler_CSV));
action1.Report(new DevExpress.XtraBars.ItemClickEventHandler(ItemClickEventHandler_Report));
//action_Function1.PKN(new DevExpress.XtraBars.ItemClickEventHandler(ItemClickEventHandler_PKN));
//action_Function1.COA(new DevExpress.XtraBars.ItemClickEventHandler(ItemClickEventHandler_COA));
//action_Function1.TRACE(new DevExpress.XtraBars.ItemClickEventHandler(ItemClickEventHandler_TRACE));
gridView1.DoubleClick += (s, e) =>
{
////Lưu ý phải lớn hơn 1, >0 bị lỗi
//if (CSV.ConvertCsvStringToDataTable(true, @"D:\\Eresis\\EXCHANGES\\OUT\\MP_" +
// gridView1.GetFocusedRowCellValue("CD_OF").ToString() + ".CSV").Rows.Count > 1)
//{
// gridControl2.DataSource = CSV.ConvertCsvStringToDataTable(true, @"D:\\Eresis\\EXCHANGES\\OUT\\MP_" +
// gridView1.GetFocusedRowCellValue("CD_OF").ToString() + ".CSV");
// //Kiểm tra có lưu trong database chưa
// //Nếu chưa thì lưu
// if (RMB.RMUSED_Find(gridView1.GetFocusedRowCellValue("CD_OF").ToString()).Rows.Count <= 0)
// {
// //MessageBox.Show("gridView2.DataRowCount :" + gridView2.DataRowCount.ToString());
// for (int i = 0; i < gridView2.DataRowCount; i++)
// {
// //MessageBox.Show("i :" + i.ToString());
// RMB.RMUSED_INSERT(gridView2.GetDataRow(i));
// }
// }
//}
//else
// gridControl2.DataSource = null;
};
gridView2.DoubleClick += (s, e) =>
{
//if (gridView2.GetFocusedRowCellValue("CD_OF").ToString().Length > 0)
//{
// gridControl3.DataSource = OFB.OF_ListBatch(gridView2.GetFocusedRowCellValue("CD_OF").ToString());
// gridView3.BestFitColumns();
// gridControl4.DataSource = COB.COA_Search_ByWO(gridView2.GetFocusedRowCellValue("CD_OF").ToString());
// gridView4.BestFitColumns();
//}
};
btnUpdate.Click += (s, e) =>
{
foreach (OF item in OFList)
{
_oFBUS.OF_Finished_UPDATE(
item.CD_OF,
item.TOL_QTY_PAK,
item.FUL_PAK_TYPE,
item.FUL_PAK_BAG,
item.LST_PAK_TYPE,
item.LST_PAK_BAG,
item.CONTAMINATION_PAK,
item.FRM_CD_OF,
item.REMAIN_PREV_CD_OF_QTY
);
}
};
btnTracertbility.Click += (s, e) =>
{
R_OF_Tracebility RTR = new R_OF_Tracebility();
RTR.OF = gridView2.GetFocusedRowCellValue("CD_OF").ToString();
RTR.Show();
};
btnPrintPreview.Click += (s, e) =>
{
// Open the Preview window.
gridControl2.ShowPrintPreview();
};
btnExportToXslx.Click += (s, e) =>
{
// Open the Preview window.
gridControl2.ExportToXlsx(@"X:\\Display_OF_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx");
XtraMessageBox.Show("Your file has been exported as the following path : Z:\\Display_OF_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx");
};
gridView2.CellValueChanged += (s, e) =>
{
OFList.Add(new OF(
gridView2.GetFocusedRowCellValue("CD_OF").ToString(),
gridView2.GetFocusedRowCellValue("TOL_QTY_PAK").ToString().Length == 0 ? 0 : float.Parse(gridView2.GetFocusedRowCellValue("TOL_QTY_PAK").ToString()),
gridView2.GetFocusedRowCellValue("FUL_PAK_TYPE").ToString(),
gridView2.GetFocusedRowCellValue("FUL_PAK_BAG").ToString().Length == 0 ? 0 : float.Parse(gridView2.GetFocusedRowCellValue("FUL_PAK_BAG").ToString()),
gridView2.GetFocusedRowCellValue("LST_PAK_TYPE").ToString(),
gridView2.GetFocusedRowCellValue("LST_PAK_BAG").ToString().Length == 0 ? 0 : float.Parse(gridView2.GetFocusedRowCellValue("LST_PAK_BAG").ToString()),
gridView2.GetFocusedRowCellValue("CONTAMINATION_PAK").ToString().Length == 0 ? 0 : float.Parse(gridView2.GetFocusedRowCellValue("CONTAMINATION_PAK").ToString()),
gridView2.GetFocusedRowCellValue("FRM_CD_OF").ToString(),
gridView2.GetFocusedRowCellValue("REMAIN_PREV_CD_OF_QTY").ToString().Length == 0 ? 0 : float.Parse(gridView2.GetFocusedRowCellValue("REMAIN_PREV_CD_OF_QTY").ToString())
));
};
//gridView3.DoubleClick += (s, e) =>
//{
// if(gridView3.GetFocusedRowCellValue("SoPKN").ToString()!="0")
// {
// frm_PKN PKN = new frm_PKN();
// PKN.KQKNTemplateID = int.Parse(gridView1.GetFocusedRowCellValue("KQKNTemplateID").ToString());
// PKN.ActStatus = "V";
// PKN.ID = int.Parse(gridView1.GetFocusedRowCellValue("ID").ToString());
// PKN.SoPKN = gridView1.GetFocusedRowCellValue("SoPKN").ToString();
// PKN.SoPNK = gridView1.GetFocusedRowCellValue("SoPNK").ToString();
// PKN.Show();
// }
//};
//gridView4.RowClick += (s, e) =>
//{
// frm_COA COA = new frm_COA();
// COA.SoCOA = gridView4.GetFocusedRowCellValue("SoCOA").ToString();
// COA.ActStatus = "V";
// COA.CD_OF = gridView4.GetFocusedRowCellValue("WO").ToString();
// COA.Show();
//};
//gridView3.CustomDrawEmptyForeground += (s, e) =>
//{
// DevExpress.XtraGrid.Views.Grid.GridView view = s as DevExpress.XtraGrid.Views.Grid.GridView;
// if (view.RowCount != 0) return;
// StringFormat drawFormat = new StringFormat();
// drawFormat.Alignment = drawFormat.LineAlignment = StringAlignment.Center;
// e.Graphics.DrawString("Vui lòng chọn WO bên trên ", e.Appearance.Font, SystemBrushes.ControlDark, new RectangleF(e.Bounds.X, e.Bounds.Y, e.Bounds.Width, e.Bounds.Height), drawFormat);
//};
//gridView4.CustomDrawEmptyForeground += (s, e) =>
//{
// DevExpress.XtraGrid.Views.Grid.GridView view = s as DevExpress.XtraGrid.Views.Grid.GridView;
// if (view.RowCount != 0) return;
// StringFormat drawFormat = new StringFormat();
// drawFormat.Alignment = drawFormat.LineAlignment = StringAlignment.Center;
// e.Graphics.DrawString("Vui lòng chọn WO bên trên ", e.Appearance.Font, SystemBrushes.ControlDark, new RectangleF(e.Bounds.X, e.Bounds.Y, e.Bounds.Width, e.Bounds.Height), drawFormat);
//};
}