private void GetEmployeeInfo(RailExam.Model.Employee obj)
{
txtEmployeeNameEdit.Text = obj.EmployeeName;
txtWorkNoEdit.Text = obj.WorkNo;
if(obj.WorkNo == null)
{
ViewState["OldWorkNo"] = "";
}
else
{
ViewState["OldWorkNo"] = obj.WorkNo;
}
txtAddress.Text = obj.Address;
dateBeginDate.DateValue = obj.BeginDate.ToString("yyyy-MM-dd");
dateBirthday.DateValue = obj.Birthday.ToString("yyyy-MM-dd");
txtFolk.Text = obj.Folk;
ddlSex.SelectedValue = obj.Sex;
txtNativePlace.Text = obj.NativePlace;
rblWedding.SelectedValue = obj.Wedding.ToString();
txtWorkPhoneEdit.Text = obj.WorkPhone;
txtHomePhone.Text = obj.HomePhone;
txtPostCode.Text = obj.PostCode;
chDimission.Checked = !obj.IsOnPost;
ddlTech.SelectedValue = obj.TechnicianTypeID.ToString();
ddlIsGroup.SelectedValue = obj.IsGroupLeader.ToString();
txtPostNo.Text = obj.PostNo;
if(obj.EmployeeID != 0)
{
txtPostNameEdit.Text = obj.PostName;
hfPostID.Value = obj.PostID.ToString();
txtOrgNameEdit.Text = obj.OrgName;
hfOrgID.Value = obj.OrgID.ToString();
}
}
protected void FillHeading(string strId)
{
ExamResultBLL examResultBLL = new ExamResultBLL();
PaperBLL kBLL = new PaperBLL();
RailExam.Model.ExamResult examResult = examResultBLL.GetExamResultByOrgID(Convert.ToInt32(strId), Convert.ToInt32(ViewState["OrgID"].ToString()));
RailExam.Model.Paper paper = null;
EmployeeBLL ebLL = new EmployeeBLL();
RailExam.Model.Employee Employee = ebLL.GetEmployee(examResult.ExamineeId);
string strOrgName = Employee.OrgName;
string strStationName = "";
string strOrgName1 = "";
int n = strOrgName.IndexOf("-");
if (n != -1)
{
strStationName = strOrgName.Substring(0, n);
strOrgName1 = strOrgName.Substring(n + 1);
}
else
{
strStationName = strOrgName;
strOrgName1 = "";
}
lblOrg.Text = strStationName;
lblWorkShop.Text = strOrgName1;
lblPost.Text = Employee.PostName;
lblName.Text = Employee.EmployeeName;
lblTime.Text = examResult.BeginDateTime.ToString("yyyy-MM-dd HH:mm");
lblScore.Text = examResult.Score.ToString();
if (examResult != null)
{
paper = kBLL.GetPaper(examResult.PaperId);
}
PaperItemBLL paperItemBLL = new PaperItemBLL();
IList <RailExam.Model.PaperItem> paperItems = paperItemBLL.GetItemsByPaperId(paper.PaperId);
int nItemCount = paperItems.Count;
decimal nTotalScore = 0;
for (int i = 0; i < paperItems.Count; i++)
{
nTotalScore += paperItems[i].Score;
}
if (paper != null)
{
lblTitle.Text = paper.PaperName;
lblTitleRight.Text = "总共 " + nItemCount + " 题，共 " + nTotalScore + " 分";
}
}
protected void btnSaveAdd_Click(object sender, EventArgs e)
{
EmployeeBLL objBll = new EmployeeBLL();
if (hfType.Value != "Edit")
{
if (objBll.GetEmployeeByWorkNo(txtWorkNoEdit.Text.Trim()) > 0)
{
SessionSet.PageMessage = "该员工编码已经存在！";
return;
}
}
else
{
if (ViewState["OldWorkNo"].ToString() != txtWorkNoEdit.Text.Trim())
{
if (objBll.GetEmployeeByWorkNo(txtWorkNoEdit.Text.Trim()) > 0)
{
SessionSet.PageMessage = "该员工编码已经存在！";
return;
}
}
}
SaveEmployeeInfo();
if (hfType.Value != "Edit")
{
Response.Write("<script>window.opener.frames['ifEmployeeInfo'].form1.Refresh.value='true';window.opener.frames['ifEmployeeInfo'].form1.submit();</script>");
}
else
{
Response.Write("<script>window.opener.form1.Refresh.value='true';window.opener.form1.submit();</script>");
}
RailExam.Model.Employee obj = new RailExam.Model.Employee();
GetEmployeeInfo(obj);
ddlRoleNameEdit.SelectedValue = "0";
if(hfType.Value =="Insert")
{
if(txtPostNameEdit.Text == string.Empty)
{
PostBLL objPostBll = new PostBLL();
txtPostNameEdit.Text = objPostBll.GetPost(Convert.ToInt32(hfPostID.Value)).PostName;
}
if(txtOrgNameEdit.Text == string.Empty)
{
OrganizationBLL objOrgBll = new OrganizationBLL();
txtOrgNameEdit.Text = objOrgBll.GetOrganization(Convert.ToInt32(hfOrgID.Value)).ShortName;
}
}
dateBirthday.DateValue = DateTime.Today.ToString("yyyy-MM-dd");
dateBeginDate.DateValue = DateTime.Today.ToString("yyyy-MM-dd");
hfType.Value = "Insert";
}
protected void Page_Load(object sender, EventArgs e)
{
if (PrjPub.CurrentLoginUser == null)
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统！");
return;
}
hfNowEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString();
if (!string.IsNullOrEmpty(hfEmployeeID.Value))
{
EmployeeBLL objEmployeeBll = new EmployeeBLL();
string[] strID = hfEmployeeID.Value.Split(',');
string strName = string.Empty;
for (int i = 0; i < strID.Length; i++)
{
RailExam.Model.Employee objEmployee = objEmployeeBll.GetEmployee(Convert.ToInt32(strID[i]));
if (strName == string.Empty)
{
strName = objEmployee.EmployeeName;
}
else
{
strName = strName + "," + objEmployee.EmployeeName;
}
}
txtEmployee.Text = strName;
}
if (!IsPostBack)
{
ddlOrg.Items.Clear();
OrganizationBLL organizationBLL = new OrganizationBLL();
IList <RailExam.Model.Organization> organizationList = organizationBLL.GetOrganizationsByLevel(2);
foreach (RailExam.Model.Organization organization in organizationList)
{
if (organization.OrganizationId != 1 && organization.OrganizationId != PrjPub.CurrentLoginUser.StationOrgID)
{
ListItem item = new ListItem();
item.Value = organization.OrganizationId.ToString();
item.Text = organization.ShortName;
ddlOrg.Items.Add(item);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (PrjPub.CurrentLoginUser == null)
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统！");
return;
}
hfType.Value = Request.QueryString.Get("mode").ToString();
if(PrjPub.CurrentLoginUser.SuitRange == 1 && PrjPub.CurrentLoginUser.IsAdmin && PrjPub.CurrentLoginUser.UseType == 0)
{
hfSuitRange.Value = "1";
}
else
{
hfSuitRange.Value = "0";
}
EmployeeBLL objEmployeeBll = new EmployeeBLL();
switch (hfType.Value)
{
case "Edit":
btnSave.Visible = true;
btnSaveNew.Visible = true;
btnClose.Visible = true;
string strEmployeeID = Request.QueryString.Get("id");
RailExam.Model.Employee obj = objEmployeeBll.GetEmployee(Convert.ToInt32(strEmployeeID));
GetEmployeeInfo(obj);
GetRoleInfo(obj.EmployeeID);
if (Request.QueryString.Get("type") == "Org" && SessionSet.OrganizationID !=1)
{
img1.Visible = false;
}
if(!PrjPub.CurrentLoginUser.IsAdmin)
{
ddlRoleNameEdit.Enabled = false;
}
break;
case "Insert":
btnSave.Visible = true;
btnSaveNew.Visible = true;
btnClose.Visible = true;
string strOrgID = Request.QueryString.Get("OrgID");
if(strOrgID != null && strOrgID != string.Empty)
{
OrganizationBLL objBll = new OrganizationBLL();
if (SessionSet.OrganizationID != 1)
{
img1.Visible = false;
}
txtOrgNameEdit.Text = objBll.GetOrganization(Convert.ToInt32(strOrgID)).ShortName;
hfOrgID.Value = strOrgID;
}
string strPostID = Request.QueryString.Get("Post");
if(strPostID != null && strPostID != string.Empty)
{
if(SessionSet.OrganizationID !=1)
{
img1.Visible = false;
hfOrgID.Value = SessionSet.OrganizationID.ToString();
txtOrgNameEdit.Text = SessionSet.OrganizationName;
}
PostBLL objBll = new PostBLL();
//img2.Visible = false;
txtPostNameEdit.Text = objBll.GetPost(Convert.ToInt32(strPostID)).PostName;
hfPostID.Value = strPostID;
}
dateBirthday.DateValue = DateTime.Today.ToString("yyyy-MM-dd");
dateBeginDate.DateValue = DateTime.Today.ToString("yyyy-MM-dd");
if (!PrjPub.CurrentLoginUser.IsAdmin)
{
ddlRoleNameEdit.Enabled = false;
}
break;
case "ReadOnly":
btnSave.Visible = false;
btnSaveNew.Visible = false;
btnClose.Visible = true;
RailExam.Model.Employee objEmployee = objEmployeeBll.GetEmployee(Convert.ToInt32(Request.QueryString.Get("id")));
GetEmployeeInfo(objEmployee);
GetRoleInfo(objEmployee.EmployeeID);
break;
}
}
}
private void SaveEmployeeInfo()
{
EmployeeBLL objBll =new EmployeeBLL();
RailExam.Model.Employee obj = new RailExam.Model.Employee();
obj.EmployeeName = txtEmployeeNameEdit.Text;
obj.WorkNo = txtWorkNoEdit.Text;
obj.Address = txtAddress.Text;
obj.BeginDate = DateTime.Parse(dateBeginDate.DateValue.ToString());
obj.Birthday = DateTime.Parse(dateBirthday.DateValue.ToString());
obj.Folk = txtFolk.Text;
obj.PostID = Convert.ToInt32(hfPostID.Value);
obj.OrgID = Convert.ToInt32(hfOrgID.Value);
obj.Sex = ddlSex.SelectedValue;
obj.NativePlace = txtNativePlace.Text;
obj.Wedding = Convert.ToInt32(rblWedding.SelectedValue);
obj.WorkPhone = txtWorkPhoneEdit.Text;
obj.HomePhone = txtHomePhone.Text;
obj.MobilePhone = txtMobilePhone.Text;
obj.PostCode = txtPostCode.Text;
obj.IsOnPost = !chDimission.Checked;
obj.Memo = txtMemoEdit.Text;
obj.IsGroupLeader = Convert.ToInt32(ddlIsGroup.SelectedValue);
obj.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue);
obj.PostNo = txtPostNo.Text;
obj.PinYinCode = Pub.GetChineseSpell(obj.EmployeeName);
SystemUserBLL objSystemBll = new SystemUserBLL();
if (hfType.Value == "Edit")
{
obj.EmployeeID = Convert.ToInt32(Request.QueryString.Get("id"));
objBll.UpdateEmployee(obj);
RailExam.Model.SystemUser objSystem = objSystemBll.GetUserByEmployeeID(obj.EmployeeID);
if(objSystem != null)
{
objSystem.RoleID = Convert.ToInt32(ddlRoleNameEdit.SelectedValue);
objSystem.UserID = obj.WorkNo;
objSystemBll.UpdateUser(objSystem);
}
else
{
objSystem = new SystemUser();
objSystem.EmployeeID = obj.EmployeeID;
objSystem.Memo = "";
objSystem.Password = "******";
objSystem.RoleID = Convert.ToInt32(ddlRoleNameEdit.SelectedValue);
objSystem.UserID = obj.WorkNo;
objSystemBll.AddUser(objSystem);
}
}
else
{
obj.LoginTime = 0;
obj.LoginCount = 0;
int id = objBll.AddEmployee(obj);
RailExam.Model.SystemUser objSystem = new SystemUser();
objSystem.EmployeeID = id;
objSystem.Memo = "";
objSystem.Password = "******";
objSystem.RoleID = Convert.ToInt32(ddlRoleNameEdit.SelectedValue);
objSystem.UserID = obj.WorkNo;
objSystemBll.AddUser(objSystem);
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (File1.FileName == "")
{
SessionSet.PageMessage = "请浏览选择Excel文件！";
return;
}
string strFileName = Path.GetFileName(File1.PostedFile.FileName);
string strPath = Server.MapPath("/RailExamBao/Excel/" + strFileName);
if (File.Exists(strPath))
{
File.Delete(strPath);
}
((HttpPostedFile)File1.PostedFile).SaveAs(strPath);
string strSql;
string strODConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + "; Extended Properties=Excel 8.0;";
strSql = "select 顺号,站段名称,车间,班组,姓名,系统,工种,职名,性别,工作证号,是否班组长,技能等级 from [Sheet1$]";
OleDbConnection ODcon = new OleDbConnection(strODConn);
DataSet ds = new DataSet();
try
{
ODcon.Open();
OleDbCommand OCom = new OleDbCommand(strSql, ODcon);
OleDbDataAdapter ODA = new OleDbDataAdapter(OCom);
ODA.Fill(ds);
}
catch
{
SessionSet.PageMessage = "请核对Excel文件的格式！";
return;
}
finally
{
ODcon.Close();
}
IList <RailExam.Model.Employee> objEmployeeList = new List <RailExam.Model.Employee>();
try
{
DataTable dt = new DataTable();
DataColumn dcnew1 = dt.Columns.Add("ExcelNo");
DataColumn dcnew2 = dt.Columns.Add("WorkNo");
DataColumn dcnew3 = dt.Columns.Add("EmployeeName");
DataColumn dcnew4 = dt.Columns.Add("Sex");
DataColumn dcnew5 = dt.Columns.Add("OrgPath");
DataColumn dcnew6 = dt.Columns.Add("PostPath");
DataColumn dcnew7 = dt.Columns.Add("IsGroup");
DataColumn dcnew8 = dt.Columns.Add("Tech");
OrganizationBLL objOrgBll = new OrganizationBLL();
PostBLL objPostBll = new PostBLL();
EmployeeBLL objBll = new EmployeeBLL();
SystemUserBLL objSystemBll = new SystemUserBLL();
if (ds.Tables[0].Rows.Count == 0)
{
SessionSet.PageMessage = "Excel中没有任何记录，请核对！";
return;
}
if (ds.Tables[0].Rows[0]["站段名称"].ToString() != txtOrg.Text.Substring(txtOrg.Text.IndexOf('/') + 1))
{
SessionSet.PageMessage = "站段选择错误，请核对！";
return;
}
//objBll.DeleteEmployeeByOrgID(Convert.ToInt32(hfOrg.Value));
Hashtable htOrg = GetOrgHash(Convert.ToInt32(hfOrg.Value));
Hashtable htPost = GetPostHash();
DataColumn dc1 = ds.Tables[0].Columns.Add("OrgPath");
DataColumn dc2 = ds.Tables[0].Columns.Add("PostPath");
DataColumn dc3 = ds.Tables[0].Columns.Add("OrgID");
DataColumn dc4 = ds.Tables[0].Columns.Add("PostID");
DataColumn dc5 = ds.Tables[0].Columns.Add("IsGroup");
DataColumn dc6 = ds.Tables[0].Columns.Add("TechID");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["班组"].ToString() != "")
{
dr["OrgPath"] = dr["站段名称"].ToString().Trim() + "-" + dr["车间"].ToString().Trim() + "-" + dr["班组"].ToString().Trim();
}
else
{
dr["OrgPath"] = dr["站段名称"].ToString().Trim() + "-" + dr["车间"].ToString().Trim();
}
dr["PostPath"] = dr["系统"].ToString().Trim() + "-" + dr["工种"].ToString().Trim() + "-" + dr["职名"].ToString().Trim();
//dr["OrgID"] = objOrgBll.GetOrgIDByOrgNamePath(dr["OrgPath"].ToString()).ToString();
//dr["PostID"] = objPostBll.GetPostIDByPostNamePath(dr["PostPath"].ToString()).ToString();
if (dr["是否班组长"].ToString() == "是")
{
dr["IsGroup"] = "1";
}
else
{
dr["IsGroup"] = "0";
}
if (dr["技能等级"].ToString() == "高级技师")
{
dr["TechID"] = "3";
}
else if (dr["技能等级"].ToString() == "技师")
{
dr["TechID"] = "2";
}
else
{
dr["TechID"] = "1";
}
if (!htOrg.ContainsKey(dr["OrgPath"].ToString()) || !htPost.ContainsKey(dr["PostPath"].ToString()) || dr["工作证号"].ToString() == "")
{
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["顺号"].ToString();
drnew["WorkNo"] = dr["工作证号"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["OrgPath"].ToString();
drnew["PostPath"] = dr["PostPath"].ToString();
drnew["IsGroup"] = dr["是否班组长"].ToString();
drnew["Tech"] = dr["技能等级"].ToString();
dt.Rows.Add(drnew);
}
else
{
dr["OrgID"] = htOrg[dr["OrgPath"].ToString()].ToString();
dr["PostID"] = htPost[dr["PostPath"].ToString()].ToString();
RailExam.Model.Employee obj = new RailExam.Model.Employee();
obj.EmployeeName = dr["姓名"].ToString().Trim();
obj.OrgID = Convert.ToInt32(dr["OrgID"].ToString());
obj.PostID = Convert.ToInt32(dr["PostID"].ToString());
obj.Sex = dr["性别"].ToString().Trim();
obj.WorkNo = dr["工作证号"].ToString().Trim();
obj.IsGroupLeader = Convert.ToInt32(dr["IsGroup"].ToString());
obj.TechnicianTypeID = Convert.ToInt32(dr["TechID"].ToString());
obj.PinYinCode = Pub.GetChineseSpell(obj.EmployeeName);
obj.IsOnPost = true;
objEmployeeList.Add(obj);
}
}
Grid1.DataSource = dt;
Grid1.DataBind();
lbltitle.Visible = true;
Grid1.Visible = true;
btnExcel.Visible = false;
objBll.AddEmployeeImport(objEmployeeList);
}
catch
{
SessionSet.PageMessage = "导入失败！";
return;
}
}
protected void btnModify_Click(object sender, EventArgs e)
{
//不符合数据的数据源
DataTable dt = new DataTable();
DataColumn dcnew1 = dt.Columns.Add("ExcelNo");
DataColumn dcnew2 = dt.Columns.Add("WorkNo");
DataColumn dcnew3 = dt.Columns.Add("EmployeeName");
DataColumn dcnew4 = dt.Columns.Add("Sex");
DataColumn dcnew5 = dt.Columns.Add("OrgPath");
DataColumn dcnew6 = dt.Columns.Add("PostPath");
DataColumn dcnew7 = dt.Columns.Add("IsGroup");
DataColumn dcnew8 = dt.Columns.Add("Tech");
DataColumn dcnew9 = dt.Columns.Add("ErrorReason");
Hashtable htOrg = GetOrgHash(0);
Hashtable htPost = GetPostHash();
#region 读取Excel文件
if (File1.FileName == "")
{
SessionSet.PageMessage = "请浏览选择Excel文件！";
return;
}
string strFileName = Path.GetFileName(File1.PostedFile.FileName);
string strPath = Server.MapPath("/RailExamBao/Excel/" + strFileName);
if (File.Exists(strPath))
{
File.Delete(strPath);
}
((HttpPostedFile)File1.PostedFile).SaveAs(strPath);
string strSql;
string strODConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + "; Extended Properties=Excel 8.0;";
strSql = "select 序号,员工编码,工作证号,性别,姓名,单位,工作岗位,员工编码,是否离职 from [Sheet1$]";
OleDbConnection ODcon = new OleDbConnection(strODConn);
DataSet ds = new DataSet();
try
{
ODcon.Open();
OleDbCommand OCom = new OleDbCommand(strSql, ODcon);
OleDbDataAdapter ODA = new OleDbDataAdapter(OCom);
ODA.Fill(ds);
}
catch
{
SessionSet.PageMessage = "请核对Excel文件的格式！";
return;
}
finally
{
ODcon.Close();
}
#endregion
#region 检验数据合理性
try
{
if (ds.Tables[0].Rows.Count == 0)
{
SessionSet.PageMessage = "Excel中没有任何记录，请核对！";
return;
}
DataColumn dc1 = ds.Tables[0].Columns.Add("OrgID");
DataColumn dc2 = ds.Tables[0].Columns.Add("PostID");
DataColumn dc3 = ds.Tables[0].Columns.Add("Dimission");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["是否离职"].ToString() == "是")
{
dr["Dimission"] = "1";
}
else
{
dr["Dimission"] = "0";
}
if (!htOrg.ContainsKey(dr["单位"].ToString()))
{
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["序号"].ToString();
drnew["WorkNo"] = dr["员工编码"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["单位"].ToString();
drnew["PostPath"] = dr["工作岗位"].ToString();
drnew["IsGroup"] = "";
drnew["Tech"] = "";
drnew["ErrorReason"] = "组织机构（单位）在系统中不存在";
dt.Rows.Add(drnew);
}
if (!htPost.ContainsKey(dr["工作岗位"].ToString()))
{
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["序号"].ToString();
drnew["WorkNo"] = dr["员工编码"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["单位"].ToString();
drnew["PostPath"] = dr["工作岗位"].ToString();
drnew["IsGroup"] = "";
drnew["Tech"] = "";
drnew["ErrorReason"] = "工作岗位在系统中不存在";
dt.Rows.Add(drnew);
}
if (dr["员工编码"].ToString() == "")
{
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["序号"].ToString();
drnew["WorkNo"] = dr["员工编码"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["单位"].ToString();
drnew["PostPath"] = dr["工作岗位"].ToString();
drnew["IsGroup"] = "";
drnew["Tech"] = "";
drnew["ErrorReason"] = "员工编码不能为空";
dt.Rows.Add(drnew);
}
}
}
catch
{
SessionSet.PageMessage = "请检查单位和工作岗位是否设置正确！";
return;
}
#endregion
#region 检验Excel中员工编码
string str = "";
string strLen = "";
Hashtable htWorkNo = new Hashtable();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (htWorkNo.ContainsKey(dr["员工编码"].ToString().Trim()))
{
if (str == "")
{
str += dr["员工编码"].ToString();
}
else
{
str += "," + dr["员工编码"].ToString();
}
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["序号"].ToString();
drnew["WorkNo"] = dr["员工编码"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["单位"].ToString();
drnew["PostPath"] = dr["工作岗位"].ToString();
drnew["IsGroup"] = "";
drnew["Tech"] = "";
drnew["ErrorReason"] = "员工编码在Excel中重复";
dt.Rows.Add(drnew);
}
else
{
if (dr["员工编码"].ToString() != "")
{
htWorkNo[dr["员工编码"].ToString()] = dr["员工编码"].ToString();
}
}
if (dr["员工编码"].ToString().Trim().Length > 10)
{
if (strLen == "")
{
strLen += dr["员工编码"].ToString();
}
else
{
strLen += "," + dr["员工编码"].ToString();
}
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["序号"].ToString();
drnew["WorkNo"] = dr["员工编码"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["单位"].ToString();
drnew["PostPath"] = dr["工作岗位"].ToString();
drnew["IsGroup"] = "";
drnew["Tech"] = "";
drnew["ErrorReason"] = "员工编码不能大于10位";
dt.Rows.Add(drnew);
}
}
#endregion
#region 检验全局员工编码
str = "";
EmployeeBLL objBll = new EmployeeBLL();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["员工编码"].ToString().Trim() != null)
{
int count = objBll.GetEmployeeByWorkNo(dr["员工编码"].ToString());
if (count > 0)
{
if (str == "")
{
str += dr["员工编码"].ToString();
}
else
{
str += "," + dr["员工编码"].ToString();
}
DataRow drnew = dt.NewRow();
drnew["ExcelNo"] = dr["序号"].ToString();
drnew["WorkNo"] = dr["员工编码"].ToString();
drnew["EmployeeName"] = dr["姓名"].ToString();
drnew["Sex"] = dr["性别"].ToString();
drnew["OrgPath"] = dr["单位"].ToString();
drnew["PostPath"] = dr["工作岗位"].ToString();
drnew["IsGroup"] = "";
drnew["Tech"] = "";
drnew["ErrorReason"] = "员工编码在系统中重复";
dt.Rows.Add(drnew);
}
}
}
lbltitle.Text = "不符合要求的数据！";
lbltitle.Visible = true;
Grid1.Visible = true;
//if (str != "")
//{
// SessionSet.PageMessage = "有重复的工作证号：" + str;
// return;
//}
#endregion
int n = 0;
foreach (DataRow dr in dt.Rows)
{
if (dr["ExcelNo"].ToString() != "" || dr["WorkNo"].ToString() != "" || dr["OrgPath"].ToString() != "" || dr["PostPath"].ToString() != "")
{
n = n + 1;
}
}
if (n > 0)
{
Grid1.DataSource = dt;
Grid1.DataBind();
lbltitle.Text = "不符合要求的数据";
lbltitle.Visible = true;
Grid1.Visible = true;
SessionSet.PageMessage = "请核对Excel数据后，再重新导入！";
return;
}
else
{
lbltitle.Text = "";
}
#region 导入数据
//try
//{
IList <RailExam.Model.Employee> objEmployeeUpdateList = new List <RailExam.Model.Employee>();
IList <RailExam.Model.Employee> objEmployeeAddList = new List <RailExam.Model.Employee>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["员工编码"].ToString() != "")
{
dr["OrgID"] = htOrg[dr["单位"].ToString().Trim()].ToString();
dr["PostID"] = htPost[dr["工作岗位"].ToString().Trim()].ToString();
RailExam.Model.Employee obj = new RailExam.Model.Employee();
obj.EmployeeID = Convert.ToInt32(dr["员工编码"].ToString());
obj.EmployeeName = dr["姓名"].ToString().Trim();
obj.OrgID = Convert.ToInt32(dr["OrgID"].ToString());
obj.PostID = Convert.ToInt32(dr["PostID"].ToString());
obj.Sex = dr["性别"].ToString().Trim();
obj.WorkNo = dr["员工编码"].ToString().Trim();
obj.PostNo = dr["工作证号"].ToString();
obj.PinYinCode = Pub.GetChineseSpell(obj.EmployeeName);
if (dr["Dimission"].ToString() == "1")
{
obj.IsOnPost = false;
}
else
{
obj.IsOnPost = true;
}
objEmployeeUpdateList.Add(obj);
}
else
{
dr["OrgID"] = htOrg[dr["单位"].ToString().Trim()].ToString();
dr["PostID"] = htPost[dr["工作岗位"].ToString().Trim()].ToString();
RailExam.Model.Employee obj = new RailExam.Model.Employee();
obj.EmployeeName = dr["姓名"].ToString().Trim();
obj.OrgID = Convert.ToInt32(dr["OrgID"].ToString());
obj.PostID = Convert.ToInt32(dr["PostID"].ToString());
obj.Sex = dr["性别"].ToString().Trim();
obj.WorkNo = dr["员工编码"].ToString().Trim();
obj.PostNo = dr["工作证号"].ToString();
obj.PinYinCode = Pub.GetChineseSpell(obj.EmployeeName);
obj.IsOnPost = true;
obj.TechnicianTypeID = 1;
obj.IsGroupLeader = 0;
objEmployeeAddList.Add(obj);
}
}
objBll.UpdateEmployee(objEmployeeUpdateList, objEmployeeAddList);
SessionSet.PageMessage = "导入成功！";
dt.Clear();
Grid1.DataSource = dt;
Grid1.DataBind();
//}
//catch(Exception ex)
//{
// SessionSet.PageMessage = "导入失败：" + ex.Message;
// return;
//}
#endregion
}
private string GetExamOutString(string strId, string orgid)
{
ExamResultBLL examResultBLL = new ExamResultBLL();
PaperBLL kBLL = new PaperBLL();
RailExam.Model.ExamResult examResult = new RailExam.Model.ExamResult();
if (ViewState["NowOrgID"].ToString() == orgid)
{
examResult = examResultBLL.GetExamResult(Convert.ToInt32(strId));
}
else
{
examResult = examResultBLL.GetExamResultByOrgID(Convert.ToInt32(strId), Convert.ToInt32(orgid));
}
RailExam.Model.Paper paper = null;
EmployeeBLL ebLL = new EmployeeBLL();
RailExam.Model.Employee Employee = ebLL.GetEmployee(examResult.ExamineeId);
paper = kBLL.GetPaper(examResult.PaperId);
PaperItemBLL paperItemBLL = new PaperItemBLL();
IList <RailExam.Model.PaperItem> paperItems = paperItemBLL.GetItemsByPaperId(paper.PaperId);
int nItemCount = paperItems.Count;
decimal nTotalScore = 0;
for (int i = 0; i < paperItems.Count; i++)
{
nTotalScore += paperItems[i].Score;
}
string strOrgName = Employee.OrgName;
string strStationName = "";
string strOrgName1 = "";
int n = strOrgName.IndexOf("-");
if (n != -1)
{
strStationName = strOrgName.Substring(0, n);
strOrgName1 = strOrgName.Substring(n + 1);
}
else
{
strStationName = strOrgName;
strOrgName1 = "";
}
string str = "<div style='text-align:center;font-size:18pt;'>" + PrjPub.GetRailName() + "考试试卷</div>";
str += "<div style='text-align:left;font-size:10.5pt;'>考试名称:" + paper.PaperName + " </div>";
str += "<div style='text-align:right;font-size:10.5pt;'>总共" + nItemCount + "题，共 " + nTotalScore + "分</div>";
str += "<div style='text-align:center;'><table width='100%' border='1' cellpadding='0' cellspacing='0' >";
str += "<tr><td width='7%' style='font-size:10.5pt' >单位:</td>";
str += "<td width='26%' style='font-size:10.5pt' align='left' >" + strStationName + "</td>";
str += "<td width='7%' style='font-size:10.5pt' >车间:</td>";
str += "<td width='27%' style='font-size:10.5pt' align='left' >" + strOrgName1 + "</td>";
str += "<td width='7%' style='font-size:10.5pt' >职名:</td>";
str += "<td width='26%' style='font-size:10.5pt' align='left' >" + Employee.PostName + "</td></tr>";
str += "<tr><td width='7%' style='font-size:10.5pt' >姓名:</td>";
str += "<td width='26%' style='font-size:10.5pt' align='left' >" + Employee.EmployeeName + "</td>";
str += "<td width='7%' style='font-size:10.5pt' >时间:</td>";
str += "<td width='27%' style='font-size:10.5pt' align='left' >" + examResult.BeginDateTime.ToString("yyyy-MM-dd HH:mm") + "</td>";
str += "<td width='7%' style='font-size:10.5pt' >成绩:</td>";
str += "<td width='26%' style='font-size:10.5pt' align='left' >" + examResult.Score + "</td></tr></table></div>";
str += "<br>";
str += GetFillExamPaperString(strId, orgid);
string strReplace;
if (PrjPub.IsServerCenter)
{
strReplace = "http://" + ConfigurationManager.AppSettings["ServerIP"] + "/RailExamBao/";
}
else
{
strReplace = "http://" + ConfigurationManager.AppSettings["StationIP"] + "/RailExamBao/";
}
str = str.Replace("/RailExamBao/", strReplace);
return(str);
}
