private void btn_exportExcel_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 (*.xls)|*.xls"; saveFileDialog.CheckPathExists = true; if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { pathsave = saveFileDialog.FileName; saveFileDialog.RestoreDirectory = true; if (dtgv_ExportSummary.Rows.Count > 0) { Class.ToolSupport toolSupport = new Class.ToolSupport(); toolSupport.dtgvExport2Excel(dtgv_ExportSummary, pathsave); } } }
public bool ExportExcelToReport(string pathSave, string version) { try { GetDataBackLogToExport(); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, " It's function : GetDataBackLogToExport() : Fail", ex.Message); return(false); } if (listBackLog != null && listBackLog.Count > 0) { try { Class.ToolSupport exportExcel = new Class.ToolSupport(); string strUser = Class.valiballecommon.GetStorage().UserName; return(exportExcel.ExportToTemplate(pathSave, path, listBackLog, DateTime.Now.ToString("yyyy-MM-dd"), strUser, version, DateTime.Now.ToString("yyyy"))); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "Export excel error !", ex.Message); return(false); } } else { return(false); } }
private void Button1_Click(object sender, EventArgs e) { DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); DateTime date_to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30, 0, 0, 0); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReport(date_from, date_to, "B01", "0010"); Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplateMQCDefect(pathMonth, @"C:\ERP_Temp\Temp2" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); // exportExcel.ExportToTemplateMQCDefect(@"D:\AN\Report\Template\Testy.xlsx", @"C:\ERP_Temp\Temp2" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); }
private void Lb_Lot_Click(object sender, EventArgs e) { DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = DateTime.Now; DateTime date_to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30, 0, 0, 0); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReportByLot(date_from, date_to, "B01", "0010", mQCItem1.PO); Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplateMQCDefectTop16(MQCForm, @"C:\ERP_Temp\MQC_" + mQCItem1.PO + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); }
private void M_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { try { string ItemClick = e.ClickedItem.ToString(); if (ItemClick == "Defect Export") { Class.ToolSupport toolSupport = new Class.ToolSupport(); var dataRow = dtgv_data.Rows[RowIndexClick].DataBoundItem as MQCItemSummary; string pathsave = ""; string pathMonth = Environment.CurrentDirectory + @"\Resources\Month.xls"; 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; toolSupport.ExportToTemplateTop5Defect(pathMonth, pathsave, dataRow); 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); } } } } else if (ItemClick == "Rework Export") { } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, " M_ItemClicked(object sender, ToolStripItemClickedEventArgs e)", ex.Message); } }
private void Btn_ExportExcel_Click(object sender, EventArgs e) { string pathsave = ""; try { 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; Class.ToolSupport toolSupport = new Class.ToolSupport(); if (ListPlanning != null && ListPlanning.Count > 0) { toolSupport.ExportProductionPlan(Class.valiballecommon.GetStorage().Language, ListPlanning, pathsave); 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); } } } } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } }
private void Btn_Summary_Click(object sender, EventArgs e) { // LoadDataSummary loadDataSummary = new LoadDataSummary(); //List<MQCItemSummary> itemSummaries = loadDataSummary.GetMQCItemSummaries(dateTimeFrom, dateTimeTo, dept, process); // SummaryWindow summary = new SummaryWindow(itemSummaries); // summary.Show(); DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); DateTime date_to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30, 0, 0, 0); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReport(date_from, date_to, "B01", "0010"); Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplateMQCDefect(pathMonth, @"C:\ERP_Temp\MQC_Report" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); }
public bool ExportReportProductionDaiLy(PeriodProduction period, string Pathsave) { try { DefectRateReport defectRateReport = new DefectRateReport(); List <DefectRateData> defectRateDatas = new List <DefectRateData>(); defectRateDatas = defectRateReport.GetListDefectRateReportAmountOfTimeDaily("B01", "0010", period); if (defectRateDatas.Count == 0) { return(false); } Class.ToolSupport exportExcel = new Class.ToolSupport(); return(true); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "ExportReportProductionDaiLy()", ex.Message); return(false); } }
public bool ExportReportProductionFromTo(DateTime from, DateTime To, string Pathsave) { try { DefectRateReport defectRateReport = new DefectRateReport(); List <DefectRateData> defectRateDatas = new List <DefectRateData>(); defectRateDatas = defectRateReport.GetListDefectRateReportFromTo("B01", "0010", from, To); if (defectRateDatas.Count == 0) { return(false); } Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplateMQCDefectDaily(pathDaily, Pathsave, defectRateDatas, from, To); return(true); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "ExportReportProductionDaiLy()", ex.Message); return(false); } }
private void Btn_uploadfile_Click(object sender, EventArgs e) { try { if (txt_SettingFile.Text != "") { DataTable dt = new DataTable(); Class.ToolSupport toolSupport = new Class.ToolSupport(); dt = toolSupport.ReadexcelToDatatable("SettingLanguage", txt_SettingFile.Text); for (int i = 0; i < dt.Rows.Count; i++) { LanguageClass language = new LanguageClass(); language.functionGroup = dt.Rows[i][0].ToString(); language.functionName = dt.Rows[i][1].ToString(); language.Tiengviet = dt.Rows[i][2].ToString(); language.English = dt.Rows[i][3].ToString(); language.Chinese = dt.Rows[i][4].ToString(); LanguageSetting languageSetting = new LanguageSetting(); languageSetting.InsertLanguageSetting(language); // languageClasses.Add(language); string sqlQuerry = "select FunctionGroup,FunctionName,TiengViet,English,Chinese from t_language "; sqlCON sqlcon = new sqlCON(); DataTable dta = new DataTable(); sqlcon.sqlDataAdapterFillDatatable(sqlQuerry, ref dta); dtgv_SettingLanguage.DataSource = null; dtgv_SettingLanguage.DataSource = dta; } // toolSupport.openExcelList("SettingLanguage", txt_SettingFile.Text, ref dt); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "Btn_uploadfile_Click(object sender, EventArgs e)", ex.Message); } }
private void Btn_ExportExcel_Click(object sender, EventArgs e) { Class.ToolSupport toolSupport = new Class.ToolSupport(); toolSupport.dtgvExport2Excel(dtgv_material, @"C:\Users\Tech-Link\Downloads\test3.xls"); }
public void ExportExcelAbsenceReport(string PathSave, List <EmployeeAbsence> employeeAbsences, DateTime date) { Class.ToolSupport toolSupport = new Class.ToolSupport(); toolSupport.ExportAbsenceDaily(employeeAbsences, PathSave, PathAbsenceDaily, date); }
public void ExportExcelHRAttendaceReport(string PathSave, List <AttendanceDept> attendanceDepts, DateTime date) { Class.ToolSupport toolSupport = new Class.ToolSupport(); toolSupport.ExportAttendanceDaily(attendanceDepts, PathSave, PathAttendanceDaily, date); }
private void Btn_ExportExcel_Click(object sender, EventArgs e) { Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplate(path, @"C:\ERP_Temp\Temp2.xlsx", dtgv_summary); // exportExcel.dtgvExport2Excel(dtgv_summary, @"C:\ERP_Temp\Temp2.xls"); }