private void btnOk_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); bool blnResult = false; // get the report start's date and end date startDate = dateTimePicker1.Value; endDate = dateTimePicker2.Value; if (startDate.CompareTo(endDate) > 0) { if (DateTime.Compare(startDate.Date, endDate.Date) != 0) { MessageBox.Show("結束日期需大於等於起始日期"); return; } } string result = cboReportType.SelectedValue == null ? "" : cboReportType.SelectedValue.ToString(); if (result.Length == 0) { MessageBox.Show("Please choice the report type"); return; } // Find the report type DefinedReport.ErpReportType reportList = DefinedReport.ErpReportType.NONE; try { reportList = (DefinedReport.ErpReportType)Enum.Parse(typeof(DefinedReport.ErpReportType), result); } catch (ArgumentException) { } MvExcelReport report = new MvExcelReport(); switch (reportList) { case DefinedReport.ErpReportType.MocP10Auto: endDate = System.DateTime.Now; startDate = DateTime.Parse(endDate.AddMonths(-4).ToShortDateString()); fileNameAndPath = string.Format("{0}{1}_{2}.xlsx", workingDirectory, DefinedReport.ErpReportType.MocP10Auto.ToString(), endDate.ToString("yyyyMMdd")); Console.WriteLine(System.DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss.fff") + " start report"); ds = MvDbDao.collectData_MocP10Auto_VB6(System.DateTime.Now); blnResult = report.generateMocP10Auto(fileNameAndPath, ds); if (blnResult == false) { MessageBox.Show("generate MocP10Auto fail"); } else { MessageBox.Show(string.Format("generate {0} done {1}{2}", DefinedReport.ErpReportType.MocP10Auto.ToString(), Environment.NewLine, fileNameAndPath)); } break; case DefinedReport.ErpReportType.BomP09: result = cboBomType.SelectedValue == null ? "" : cboBomType.SelectedValue.ToString(); if (result.Length == 0) { MessageBox.Show("Please choice the BOM type"); return; } ds = MvDbDao.collectData_BomP09_VB6(new string[] { result }); fileNameAndPath = string.Format("{0}{1}_{2}.xlsx", workingDirectory, DefinedReport.ErpReportType.BomP09.ToString(), endDate.ToString("yyyyMMdd")); blnResult = report.generateBomP09_NoPrice(fileNameAndPath, ds); if (blnResult == false) { MessageBox.Show("generate MocP10Auto fail"); } else { MessageBox.Show(string.Format("generate {0} done {1}{2}", DefinedReport.ErpReportType.BomP09.ToString(), Environment.NewLine, fileNameAndPath)); } break; case DefinedReport.ErpReportType.BomP09_Multi: if (chkBomListBox.CheckedItems.Count <= 0) { MessageBox.Show("please checked more than one"); return; } List <string> selectedList = new List <string>(); foreach (var itemChecked in chkBomListBox.CheckedItems) { var row = (itemChecked as DataRowView).Row; selectedList.Add(row["MC001"].ToString()); } ds = MvDbDao.collectData_BomP09_VB6(selectedList.ToArray <string>()); fileNameAndPath = string.Format("{0}{1}_{2}.xlsx", workingDirectory, DefinedReport.ErpReportType.BomP09_Multi.ToString(), endDate.ToString("yyyyMMdd")); blnResult = report.generateBomP09_NoPrice(fileNameAndPath, ds); if (blnResult == false) { MessageBox.Show("generate MocP10Auto fail"); } else { MessageBox.Show(string.Format("generate {0} done {1}{2}", DefinedReport.ErpReportType.BomP09_Multi.ToString(), Environment.NewLine, fileNameAndPath)); } break; default: MessageBox.Show("Can't find the report type as " + result); break; } }
private void cboReportType_SelectedIndexChanged(object sender, EventArgs e) { // 如果沒被選取, 則直接離開 if (cboReportType.SelectedIndex < 0) { return; } string result = cboReportType.SelectedValue.ToString(); // 如果有值再判斷是否要intial value if (result.Length == 0) { return; } // Find the report type DataTable tmpDt = null; DefinedReport.ErpReportType reportList = DefinedReport.ErpReportType.NONE; try { reportList = (DefinedReport.ErpReportType)Enum.Parse(typeof(DefinedReport.ErpReportType), result); } catch (ArgumentException) { } switch (reportList) { case DefinedReport.ErpReportType.MocP10Auto: groupBom.Enabled = false; chkBomListBox.Enabled = false; groupDate.Enabled = true; enableObject(true, false, false); break; case DefinedReport.ErpReportType.BomP09: // initial button value tmpDt = MvDbDao.collectData_BomList(); cboBomType.DataSource = tmpDt; cboBomType.ValueMember = "MC001"; cboBomType.DisplayMember = "MB0012"; cboBomType.Text = ""; cboBomType.SelectedValue = ""; enableObject(false, true, false); break; case DefinedReport.ErpReportType.BomP09_Multi: // initial button value tmpDt = MvDbDao.collectData_BomList(); chkBomListBox.DataSource = tmpDt; chkBomListBox.ValueMember = "MC001"; chkBomListBox.DisplayMember = "MB0012"; enableObject(false, false, true); break; default: enableObject(false, false, false); // do nothing return; } }