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