private void toolStripButton1_Click(object sender, EventArgs e) { try { this.toolStripStatusLabel1.Text = ""; string sql = this.richTextBox1.SelectedText; if (string.IsNullOrWhiteSpace(sql)) { sql = this.richTextBox1.Text; } BLL.ProjectBLL bll = new BLL.ProjectBLL(); if (sql.ToLower().Trim().StartsWith("select")) { DataTable table = bll.Query(sql); this.dataGridView1.DataSource = table; this.tabControl1.SelectedIndex = 0; } else { int n = bll.Excute(sql); this.richTextBox2.Clear(); this.richTextBox2.Text = string.Format("{0}行受影响", n); this.tabControl1.SelectedIndex = 1; } } catch (Exception ex) { this.toolStripStatusLabel1.Text = ex.Message; } }
private List <Models.Project> GetDefaultList(string text, int level = 1, string parentProjectId = null) { BLL.ProjectBLL bll = new BLL.ProjectBLL(); string Where = " ProjectLevel=@ProjectLevel "; List <OleDbParameter> Paralist = new List <OleDbParameter>(); Paralist.Add(new OleDbParameter("ProjectLevel", level)); if (!Utils.IsEmptyOrNull(parentProjectId)) { Where += " and parentProjectId=@parentProjectId"; Paralist.Add(new OleDbParameter("@parentProjectId", parentProjectId)); } Where += " order by ProjectId"; DataTable table = bll.GetData(Where, Paralist.ToArray()); List <Models.Project> list = new List <Models.Project>() { new Models.Project() { ProjectId = "", ProjectName = text } }; list.AddRange(ListSupport.ToList <Models.Project>(table)); return(list); }
private bool excute(string sql, string errorMessage) { BLL.ProjectBLL bll = new BLL.ProjectBLL(); try { bll.Excute(sql); } catch { MessageBox.Show(errorMessage); } return(true); }
private bool work(BackgroundWorker bk) { try { BLL.ProjectBLL Bll_Project = new BLL.ProjectBLL(); string fileName = this.textBox4.Text; IWorkbook workbook = null; FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read); if (fileName.IndexOf(".xlsx") > 0) // 2007版本 { workbook = new XSSFWorkbook(fs); } else if (fileName.IndexOf(".xls") > 0) // 2003版本 { workbook = new HSSFWorkbook(fs); } int n = workbook.NumberOfSheets; showMessage("发现" + n + "个sheet页"); for (int i = 0; i < n; i++) { int order = 1; showMessage("正在处理" + (i + 1) + "个sheet页"); ISheet sheet = workbook.GetSheetAt(i); int start = sheet.FirstRowNum; int end = sheet.LastRowNum; for (int r = 2; r <= end; r++) { IRow row = sheet.GetRow(r); if (row == null || row.FirstCellNum == -1) { continue; } try { #region string p1Name = row.GetCell(0).StringCellValue; string p2Name = row.GetCell(1).StringCellValue; string p3Name = row.GetCell(2).StringCellValue; if (!Utils.IsEmptyOrNull(p1Name)) { AddProject(p1Name, 1, i); } if (!Utils.IsEmptyOrNull(p2Name)) { AddProject(p2Name, 2, i, Level_1_List.Last().ProjectId); } if (!Utils.IsEmptyOrNull(p3Name)) { AddProject(p3Name, 3, i, Level_2_List.Last().ProjectId); } int CIndex = 3; Models.Project tempProject = Level_3_List.Last(); int index = order++; Models.ProjectDetails details = new Models.ProjectDetails() { DetailsTilte = row.GetCell(3).GetValue(out CIndex), //.StringCellValue, SerialNumber = row.GetCell(CIndex).GetValue(out CIndex), //.StringCellValue, Mileage = row.GetCell(CIndex).GetValue(out CIndex), //.StringCellValue, Intensity = row.GetCell(CIndex).GetValue(out CIndex), //.StringCellValue, CementContent = row.GetCell(CIndex).GetValue(out CIndex), //.StringCellValue.ToString(), MixDesign = row.GetCell(CIndex).GetValue(out CIndex), //.NumericCellValue.ToString(), DetailsId = ProjectCode + "_" + biaoduanCode + "_M4_" + index + "_" + Utils.getGUID(), // Utils.getGUID(), DisplayOrder = index, ProjectId = tempProject.ProjectId, Project = tempProject }; this.Details.Add(details); #endregion } catch (Exception ex) { showMessage("第" + i + "页,第" + r + "行:" + ex.Message); } } } } catch (Exception ex) { showMessage(ex.Message); } finally { this.Invoke(new EventHandler((a, b) => { this.dataGridView1.DataSource = Details.Select(p => new { 一级菜单 = p.Project.ParentProject.ParentProject.ProjectName, 二级菜单 = p.Project.ParentProject.ProjectName, 级菜单 = p.Project.ProjectName, 四级菜单 = p.DetailsTilte, 分项工程编号 = p.SerialNumber, 取样里程 = p.Mileage, 设计强度 = p.Intensity, 每立方水泥用量 = p.CementContent, 设计配合比 = p.MixDesign }).ToList(); })); } return(true); }