private void btnImport_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want save change?", "Cortek", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { IWorkbook workbook = spreadSheet.Document; try { using (FileStream stream = new FileStream(txtPath.Text, FileMode.Create, FileAccess.ReadWrite)) { if (extension == ".xls") { workbook.SaveDocument(stream, DocumentFormat.Xls); } else { workbook.SaveDocument(stream, DocumentFormat.Xlsx); } } Bus_INSPECTION_HISTORY_Excel excelBus = new Bus_INSPECTION_HISTORY_Excel(); RW_INSPECTION_HISTORY_BUS busHistory = new RW_INSPECTION_HISTORY_BUS(); List <RW_INSPECTION_HISTORY> list = excelBus.getListInsp(txtPath.Text); for (int i = 0; i < list.Count; i++) { busHistory.add(list[i]); } this.Close(); } catch { MessageBox.Show("This file is opened in another program!", "Cortek RBI", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } }
private List <RW_INSPECTION_DETAIL> getDataInspectionHistory() { RW_INSPECTION_HISTORY_BUS busInspHis = new RW_INSPECTION_HISTORY_BUS(); List <RW_INSPECTION_DETAIL> listInspHis = busInspHis.getDataSource(); List <RW_INSPECTION_DETAIL> listData = new List <RW_INSPECTION_DETAIL>(); EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS(); SITES_BUS busSite = new SITES_BUS(); FACILITY_BUS busFacility = new FACILITY_BUS(); foreach (RW_INSPECTION_DETAIL inspHis in listInspHis) { int eqID = inspHis.EquipmentID; RW_INSPECTION_DETAIL rwInspHis = inspHis; rwInspHis.SiteName = busSite.getSiteName(busEqMaster.getSiteID(eqID)); rwInspHis.FacilityName = busFacility.getFacilityName(busEqMaster.getFacilityID(eqID)); listData.Add(rwInspHis); } return(listData); }
private List <RW_INSPECTION_HISTORY> getData() { RW_INSPECTION_HISTORY_BUS busInspHis = new RW_INSPECTION_HISTORY_BUS(); List <RW_INSPECTION_HISTORY> listInspHis = busInspHis.getDataSource(); List <RW_INSPECTION_HISTORY> listData = new List <RW_INSPECTION_HISTORY>(); EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS(); SITES_BUS busSite = new SITES_BUS(); FACILITY_BUS busFacility = new FACILITY_BUS(); foreach (RW_INSPECTION_HISTORY inspHis in listInspHis) { String eqNumber = inspHis.EquipmentNumber; int eqID = busEqMaster.getIDbyNumber(inspHis.EquipmentNumber); RW_INSPECTION_HISTORY rwInspHis = inspHis; rwInspHis.SiteName = busSite.getSiteName(busEqMaster.getSiteID(eqID)); rwInspHis.FacilityName = busFacility.getFacilityName(busEqMaster.getFacilityID(eqID)); listData.Add(rwInspHis); } return(listData); }
private void btnAddInspectionPlan_Click(object sender, EventArgs e) { RW_INSPECTION_HISTORY_BUS rwInsHisBus = new RW_INSPECTION_HISTORY_BUS(); RW_ASSESSMENT_BUS rwAssBus = new RW_ASSESSMENT_BUS(); int n = rwInsHisBus.getDataComp(rwAssBus.getComponentID(IDAss)).Count; if (n > 0) { dtgvInsHis.Rows.Add("-", DateTime.Now.ToShortDateString(), "Corrosion Under Insulation", "", "", "E", 0, DateTime.Now.ToShortDateString()); } else { if (dtgvInsHis.RowCount > 0) { dtgvInsHis.Rows.Add("-", DateTime.Now.ToShortDateString(), "Corrosion Under Insulation", "", "", "E", 0, DateTime.Now.ToShortDateString()); } else { MessageBox.Show("This proposal does not have mitigation plan, please add mitigation planning.", "Inspection / Mitigation", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } } }
private void UCInspectionHistorySubform_Load(object sender, EventArgs e) { DataGridViewTextBoxColumn dtvcInsPlan = new DataGridViewTextBoxColumn(); dtvcInsPlan.HeaderText = "Inspection Plan"; DataGridViewTextBoxColumn dtvcInsDate = new DataGridViewTextBoxColumn(); dtvcInsDate.HeaderText = "Inspection Date"; DataGridViewComboBoxColumn dtvcDamaMechan = new DataGridViewComboBoxColumn(); dtvcDamaMechan.HeaderText = "Damage Mechanism"; //add items cho dtvcDamaMechan DM_ITEMS_BUS dmItemsBus = new DM_ITEMS_BUS(); List <string> listDMItems = dmItemsBus.getDMDescription(); foreach (String dm in listDMItems) { dtvcDamaMechan.Items.Add(dm); } dtvcDamaMechan.MaxDropDownItems = 4; DataGridViewTextBoxColumn dtvcInsSum = new DataGridViewTextBoxColumn(); dtvcInsSum.HeaderText = "Inspection Summary"; DataGridViewButtonColumn dtvcSumDetail = new DataGridViewButtonColumn(); dtvcSumDetail.HeaderText = "Summary Detail"; dtvcSumDetail.Name = "dtvcSumDetail"; DataGridViewComboBoxColumn dtvcEffective = new DataGridViewComboBoxColumn(); dtvcEffective.Items.Add("A"); dtvcEffective.Items.Add("B"); dtvcEffective.Items.Add("C"); dtvcEffective.Items.Add("D"); dtvcEffective.Items.Add("E"); dtvcEffective.HeaderText = "Effectiveness"; DataGridViewCheckBoxColumn dtvcCarriedOut = new DataGridViewCheckBoxColumn(); dtvcCarriedOut.HeaderText = "Carried Out"; DataGridViewTextBoxColumn dtvcICarriedOutDate = new DataGridViewTextBoxColumn(); dtvcICarriedOutDate.HeaderText = "Carried Out Date"; DataGridViewButtonColumn dtvcDelete = new DataGridViewButtonColumn(); dtvcDelete.HeaderText = ""; dtvcDelete.Name = "dtvcDelete"; dtgvInsHis.Columns.Add(dtvcInsPlan); dtvcInsPlan.Width = 100; dtgvInsHis.Columns.Add(dtvcInsDate); dtvcInsDate.Width = 80; dtgvInsHis.Columns.Add(dtvcDamaMechan); dtvcDamaMechan.Width = 150; dtgvInsHis.Columns.Add(dtvcInsSum); dtvcInsSum.Width = 200; dtgvInsHis.Columns.Add(dtvcSumDetail); dtvcSumDetail.Width = 50; dtgvInsHis.Columns.Add(dtvcEffective); dtvcEffective.Width = 70; dtgvInsHis.Columns.Add(dtvcCarriedOut); dtvcCarriedOut.Width = 60; dtgvInsHis.Columns.Add(dtvcICarriedOutDate); dtvcICarriedOutDate.Width = 80; dtgvInsHis.Columns.Add(dtvcDelete); dtvcDelete.Width = 50; RW_INSPECTION_HISTORY_BUS rwInspHisBus = new RW_INSPECTION_HISTORY_BUS(); List <RW_INSPECTION_DETAIL> lstRwInsDe = rwInspHisBus.getDataSourcebyDetailID(IDAss); foreach (RW_INSPECTION_DETAIL de in lstRwInsDe) { dtgvInsHis.Rows.Add(de.InspPlanName, de.InspectionDate.ToShortDateString(), dmItemsBus.getDMDescriptionbyDMItemID(de.DMItemID), de.InspectionSummary, "...", de.EffectivenessCode, de.IsCarriedOut, de.CarriedOutDate, "Delete"); } dtgvInsHis.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; dtgvInsHis.AllowUserToAddRows = false; }