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