protected void btnSave_Click(object sender, EventArgs e) { DimensionBLL dimensionBll = new DimensionBLL(); Dimension temp = new Dimension(); if (Request.QueryString["dimension_id"] != null) { temp.Dimension_id = int.Parse(Request.QueryString["dimension_id"]); } temp.Dimnm =txtbDimnm.Text.Trim(); temp.Dimension_descrip = txtbDescrip.Text.Trim(); temp.Dimension_classid=int.Parse(ddlType.SelectedValue); temp.Time_min = int.Parse(txtbTime.Text.Trim());//界面输入值为分,DB存储秒 temp.Linterval = float.Parse(txtbQ3.Text.Trim()); temp.Minterval = float.Parse(txtbQ2.Text.Trim()); temp.Sinterval = float.Parse(txtbQ1.Text.Trim()); temp.Dimension_2 = float.Parse(txtb2.Text.Trim()); temp.Dimension_8 = float.Parse(txtb8.Text.Trim()); temp.Dimension_17 = float.Parse(txtb17.Text.Trim()); temp.Dimension_32 = float.Parse(txtb32.Text.Trim()); temp.Dimension_50 = float.Parse(txtb50.Text.Trim()); temp.Dimension_68 = float.Parse(txtb68.Text.Trim()); temp.Dimension_83 = float.Parse(txtb83.Text.Trim()); temp.Dimension_92 = float.Parse(txtb92.Text.Trim()); temp.Dimension_98 = float.Parse(txtb98.Text.Trim()); //维度上限时间,下限时间 temp.Time_xiaxian = int.Parse(txtXiaXianTime.Text.Trim()); temp.Time_shangxian = int.Parse(txtShangXianTime.Text.Trim()); if (dimensionBll.Exists(temp.Dimension_id)) { int n = dimensionBll.Update(temp); if (n > 0) { MessageBox.ShowAndRedirect(this, "维度修改成功", "DimensionList.aspx"); } } else { if (dimensionBll.Add(temp) != -1) { MessageBox.ShowAndRedirect(this, "维度添加成功", "DimensionList.aspx"); } } }
private bool ImportDimension(string xlsFileNm) { try { if (!File.Exists(xlsFileNm)) return false; Workbook book = Workbook.Load(xlsFileNm); Worksheet sheet = book.Worksheets[0]; DimensionBLL dimBll = new DimensionBLL(); Dimension dimModel = new Dimension(); // traverse rows by Index for (int rowIndex = sheet.Cells.FirstRowIndex + 1;//忽略第一行(标题行) rowIndex <= sheet.Cells.LastRowIndex; rowIndex++) { Row row = sheet.Cells.GetRow(rowIndex); dimModel.Dimnm = row.GetCell(1).StringValue; dimModel.Dimension_descrip = row.GetCell(2).StringValue; switch (row.GetCell(3).StringValue) { case "职业能力/技能类": dimModel.Dimension_classid = 1; break; case "职业行为风格类": dimModel.Dimension_classid = 2; break; case "职业智力/潜能类": dimModel.Dimension_classid = 3; break; case "职业态度/动机类": dimModel.Dimension_classid = 4; break; case "质量检测类": dimModel.Dimension_classid = 5; break; case "职业心理基础类": dimModel.Dimension_classid = 6; break; default: break; } dimModel.Time_min = (int)float.Parse(row.GetCell(4).StringValue) ; dimModel.Sinterval = (int)float.Parse(row.GetCell(5).StringValue); dimModel.Minterval = (int)float.Parse(row.GetCell(6).StringValue); dimModel.Linterval = (int)float.Parse(row.GetCell(7).StringValue); dimModel.Dimension_2 = float.Parse(row.GetCell(8).StringValue); dimModel.Dimension_8 = float.Parse(row.GetCell(9).StringValue); dimModel.Dimension_17 = float.Parse(row.GetCell(10).StringValue); dimModel.Dimension_32 = float.Parse(row.GetCell(11).StringValue); dimModel.Dimension_50 = float.Parse(row.GetCell(12).StringValue); dimModel.Dimension_68 = float.Parse(row.GetCell(13).StringValue); dimModel.Dimension_83 = float.Parse(row.GetCell(14).StringValue); dimModel.Dimension_92 = float.Parse(row.GetCell(15).StringValue); dimModel.Dimension_98 = float.Parse(row.GetCell(16).StringValue); dimBll.Add(dimModel); } return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }