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");
}
