private void button2_Click(object sender, EventArgs e) { M_ImportPlan m_ImportPlan = new M_ImportPlan(); int count = Convert.ToInt16(dataGridView1.Rows.Count.ToString()); for (int i = 0; i < count; i++) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)dataGridView1.Rows[i].Cells[0]; Boolean flag = Convert.ToBoolean(checkCell.Value); if (flag == true) //查找被选择的数据行 { m_ImportPlan.id += dataGridView1.Rows[i].Cells["id"].Value.ToString() + ","; } else { continue; } } if (string.IsNullOrEmpty(m_ImportPlan.id)) { ToastNotification.CustomGlowColor = Color.FromArgb(48, 32, 22); ToastNotification.Show(this, "请勾选要删除的数据", BLL.B_GetMethod.ReadImageFile(@"../../Images/Error.png"), 2000, eToastGlowColor.Red, eToastPosition.MiddleCenter); return; } string img = string.Empty; string returnInfo = b_GetMethod.HandleM_ImportPlan(m_ImportPlan, M_SQLType.Delete); GetTable(); img = returnInfo.Equals("删除成功") ? @"../../Images/success.png" : @"../../Images/Error.png"; ToastNotification.CustomGlowColor = Color.FromArgb(48, 32, 22); ToastNotification.Show(this, returnInfo, BLL.B_GetMethod.ReadImageFile(img), 2000, eToastGlowColor.Red, eToastPosition.MiddleCenter); }
public static M_ImportPlan GetExcelToM_ImportPlan(string filePath) { ISheet sheet; FileStream fs; IWorkbook workbook; M_ImportPlan m_ImportPlan; try { fs = new FileStream(filePath, FileMode.Open, FileAccess.Read); if (filePath.IndexOf(".xlsx") > 0) {// 2007版本 workbook = new XSSFWorkbook(fs); } else {// 2003版本 workbook = new HSSFWorkbook(fs); } m_ImportPlan = new M_ImportPlan(); sheet = workbook.GetSheetAt(0); m_ImportPlan.orderNumber = sheet.GetRow(0).GetCell(1).StringCellValue.ToString(); int count = 2; m_ImportPlan.m_ListWorkOrderInfo = new List <M_ListPlanInfo>(); int lastCell = sheet.GetRow(2).Cells.Count; while (true) { IRow rows = sheet.GetRow(count); if (rows != null && rows.Cells.Count == lastCell) { M_ListPlanInfo m_ListPlanInfo = new M_ListPlanInfo(); m_ListPlanInfo.productName = rows.GetCell(0).StringCellValue.ToString(); m_ListPlanInfo.deliveryDate = DateTime.Parse(rows.GetCell(1).DateCellValue.ToString()); m_ListPlanInfo.client = rows.GetCell(2).StringCellValue.ToString(); m_ListPlanInfo.productNumber = int.Parse(rows.GetCell(3).NumericCellValue.ToString()); m_ImportPlan.m_ListWorkOrderInfo.Add(m_ListPlanInfo); count++; } else { break; } } workbook.Close(); } catch (Exception e) { throw e; } return(m_ImportPlan); }
public string HandleM_ImportPlan(M_ImportPlan m_ImportPlan, M_SQLType m_SQLType) { return(d_GetMethod.HandleM_ImportPlan(m_ImportPlan, m_SQLType)); }