protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string struesrId = PrjPub.StudentID;
hfEmployeeID.Value = struesrId;
try
{
lblName.Text = PrjPub.CurrentStudent.EmployeeName;
}
catch
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=超时时间已到，请重新登录");
}
OrganizationBLL objOrgBll = new OrganizationBLL();
lblOrg.Text = objOrgBll.GetOrganization(PrjPub.CurrentStudent.StationOrgID).ShortName;
lblPost.Text = PrjPub.CurrentStudent.PostName;
//foreach (RailExam.Model.Exam exam in ExamList)
//{
// exam.ExamName = "<a onclick=AttendExam('" + exam.ExamId + "','" + exam.paperId + "','" + exam.ExamType + "') href=# title='参加考试' > " + exam.ExamName + " </a>";
//}
//gvExam.DataSource = ExamList;
//gvExam.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strStationID = ConfigurationManager.AppSettings["StationID"];
if (strStationID == "200")
{
lblDate.Text = PrjPub.GetRailName() + "·þÎñÆ÷";
}
else
{
OrganizationBLL orgBll = new OrganizationBLL();
Organization organization = orgBll.GetOrganization(Convert.ToInt32(strStationID));
lblDate.Text = organization.ShortName + "·þÎñÆ÷";
}
string strSql = "select * from Computer_Server where Computer_Server_No='" + PrjPub.ServerNo + "'";
OracleAccess db = new OracleAccess();
DataSet ds = db.RunSqlDataSet(strSql);
if (ds.Tables[0].Rows.Count > 0)
{
lblServerName.Text = ds.Tables[0].Rows[0]["Computer_Server_Name"].ToString();
}
lblServerNo.Text = PrjPub.ServerNo.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblName.Text = PrjPub.CurrentStudent.EmployeeName;
OrganizationBLL objOrgBll = new OrganizationBLL();
lblOrg.Text = objOrgBll.GetOrganization(PrjPub.CurrentStudent.StationOrgID).ShortName;
lblPost.Text = PrjPub.CurrentStudent.PostName;
ExamResultBLL objBll = new ExamResultBLL();
ViewState["NowOrgID"] = Convert.ToInt32(ConfigurationManager.AppSettings["StationID"]);
IList <RailExam.Model.ExamResult> objList = objBll.GetExamResults(PrjPub.StudentID, 0);
gvExam.DataSource = objList;
gvExam.DataBind();
hfOrgID.Value = ConfigurationManager.AppSettings["StationID"].ToString();
hfIsServer.Value = PrjPub.IsServerCenter.ToString();
BindGrid();
}
else
{
if (Request.Form.Get("OutPut") != null && Request.Form.Get("OutPut") != "")
{
OutputData(Request.Form.Get("OutPut"), Request.Form.Get("OutPutOrg"));
}
if (Request.Form.Get("OutPutRandom") != null && Request.Form.Get("OutPutRandom") != "")
{
OutputRandomExam(Request.Form.Get("OutPutRandom"));
}
}
}
private void BindOrgTree(string selectId)
{
OrganizationBLL organizationsBLL = new OrganizationBLL();
if (PrjPub.CurrentLoginUser.SuitRange == 1)
{
IList <RailExam.Model.Organization> organizations = organizationsBLL.GetOrganizationsByLevel(2);
foreach (RailExam.Model.Organization organization in organizations)
{
if (organization.LevelNum == 1)
{
continue;
}
TreeViewNode tvNode = new TreeViewNode();
tvNode.ID = organization.OrganizationId.ToString();
tvNode.Text = organization.ShortName;
tvView.Nodes.Add(tvNode);
}
}
else
{
TreeViewNode tvNode = new TreeViewNode();
tvNode.ID = PrjPub.CurrentLoginUser.StationOrgID.ToString();
tvNode.Text = organizationsBLL.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
tvView.Nodes.Add(tvNode);
}
}
public ActionResult OrganizationDetail(int id)
{
OrganizationMessageModel model = new OrganizationMessageModel();
model.Organization = organizationBLL.GetOrganization(id);
return(View(model));
}
private void DownloadExamInfoExcel()
{
string filename = Server.MapPath("/RailExamBao/Excel/Count.xls");
int _OrgId = Convert.ToInt32(Request.QueryString["OrgID"]);
OrganizationBLL orgBll = new OrganizationBLL();
Organization org = orgBll.GetOrganization(_OrgId);
if (File.Exists(filename))
{
FileInfo file = new FileInfo(filename);
this.Response.Clear();
this.Response.Buffer = true;
this.Response.Charset = "utf-7";
this.Response.ContentEncoding = Encoding.UTF7;
// 添加头信息，为"文件下载/另存为"对话框指定默认文件名
this.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(org.ShortName + "考试列表") + ".xls");
// 添加头信息，指定文件大小，让浏览器能够显示下载进度
this.Response.AddHeader("Content-Length", file.Length.ToString());
// 指定返回的是一个不能被客户端读取的流，必须被下载
this.Response.ContentType = "application/ms-excel";
// 把文件流发送到客户端
this.Response.WriteFile(file.FullName);
}
}
public void GetInexistentOrganization()
{
//Prueba el comportamiento cuando no existe organización.
OrganizationBLL organizationBll = new OrganizationBLL();
ResultBM result = organizationBll.GetOrganization(99999);
Assert.IsNull(result.GetValue(), "No debería existir");
}
public void GetOrganization()
{
//Prueba el comportamiento cuando existe organización.
OrganizationBLL organizationBll = new OrganizationBLL();
ResultBM result = organizationBll.GetOrganization(1);
Assert.IsNotNull(result.GetValue(), "Debería existir");
Assert.AreEqual(result.GetValue <OrganizationBM>().name, "Organización 01", "Debería ser Organización 01");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (PrjPub.HasEditRight("微机教室信息") && PrjPub.IsServerCenter)
{
HfUpdateRight.Value = "True";
}
else
{
HfUpdateRight.Value = "False";
}
if (PrjPub.HasDeleteRight("微机教室信息") && PrjPub.IsServerCenter)
{
HfDeleteRight.Value = "True";
}
else
{
HfDeleteRight.Value = "False";
}
//string orgid = Request.QueryString["id"];
//initComputerRoomInfo(orgid);
if (PrjPub.CurrentLoginUser == null)
{
Response.Redirect("../Common/Error.aspx?error=Session过期请重新登录本系统！");
return;
}
string strQuery = Request.QueryString.Get("strQuery");
if (string.IsNullOrEmpty(strQuery))
{
GetSql();
}
else
{
string[] str = strQuery.Split('|');
if (!string.IsNullOrEmpty(str[0]))
{
hfSelectOrg.Value = str[0];
OrganizationBLL orgbll = new OrganizationBLL();
txtOrg.Text = orgbll.GetOrganization(Convert.ToInt32(str[0])).ShortName;
}
txtCOMPUTER_ROOM.Text = str[1];
txtAddress.Text = str[2];
ddl.SelectedValue = str[3];
btnQuery_Click(null, null);
}
hfOrgID.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString();
hfRoleID.Value = PrjPub.CurrentLoginUser.RoleID.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (PrjPub.CurrentLoginUser == null)
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统！");
return;
}
txtOrg.Text = hfOrgName.Value;
if (!IsPostBack && !Grid1.IsCallback)
{
lbltitle.Visible = false;
Grid1.Visible = false;
btnExcel.Visible = false;
btnModify.Visible = false;
btnInput.Visible = false;
btnBind.Visible = true;
btnExamOther.Visible = false;
excel.Visible = false;
Grid1.Levels[0].Columns[1].HeadingText = "上岗证号";
if (PrjPub.CurrentLoginUser.SuitRange != 1)
{
ImgSelectOrg.Visible = false;
OrganizationBLL objbll = new OrganizationBLL();
txtOrg.Text = objbll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
hfOrg.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString();
}
if (Session["EmployeeTable"] != null)
{
Session.Remove("EmployeeTable");
}
}
else
{
if (!string.IsNullOrEmpty(hfOrg.Value))
{
OrganizationBLL objbll = new OrganizationBLL();
txtOrg.Text = objbll.GetOrganization(Convert.ToInt32(hfOrg.Value)).ShortName;
}
}
string str = Request.Form.Get("Refresh");
if (str != null && str == "refresh")
{
EmployeeErrorBLL objErrorBll = new EmployeeErrorBLL();
Grid1.DataSource = objErrorBll.GetEmployeeErrorByOrgIDAndImportTypeID(Convert.ToInt32(hfOrg.Value));
Grid1.DataBind();
Grid1.Visible = true;
}
}
public ActionResult OrganizationDetail(int id)
{
Organizations organization = organizationBLL.GetOrganization(id);
Session["Organization"] = organization;
OrganizationParticipantModel model = new OrganizationParticipantModel
{
organizations = organization
};
return(View(model));
}
//站段树绑定
private void BindTree()
{
int railSystemID = PrjPub.GetRailSystemId();
OrganizationBLL organizationsBLL = new OrganizationBLL();
if (PrjPub.CurrentLoginUser.SuitRange == 1)
{
string strOwnIDs = string.Empty;
if (railSystemID != 0)
{
IList <RailExam.Model.Organization> organizationList1 = organizationsBLL.GetOrganizations(PrjPub.CurrentLoginUser.StationOrgID);
foreach (RailExam.Model.Organization organization in organizationList1)
{
strOwnIDs += strOwnIDs == string.Empty
? organization.OrganizationId.ToString()
: "," + organization.OrganizationId;
}
}
IList <RailExam.Model.Organization> organizations = organizationsBLL.GetOrganizationsByLevel(2);
foreach (RailExam.Model.Organization organization in organizations)
{
if (organization.LevelNum == 1)
{
continue;
}
if ((organization.IdPath + "/").IndexOf("/1/") >= 0 && organization.LevelNum != 1 && railSystemID != 0 && railSystemID != organization.RailSystemID)
{
continue;
}
if (organization.LevelNum != 1 && strOwnIDs != string.Empty && (organization.IdPath + "/").IndexOf("/1/") < 0 && ("," + strOwnIDs + ",").IndexOf("," + organization.OrganizationId + ",") < 0)
{
continue;
}
TreeViewNode tvNode = new TreeViewNode();
tvNode.ID = organization.OrganizationId.ToString();
tvNode.Text = organization.ShortName;
tvView.Nodes.Add(tvNode);
}
}
else
{
TreeViewNode tvNode = new TreeViewNode();
tvNode.ID = PrjPub.CurrentLoginUser.StationOrgID.ToString();
tvNode.Text = organizationsBLL.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
tvView.Nodes.Add(tvNode);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strID = Request.QueryString.Get("RandomExamID");
ViewState["ExamID"] = strID;
ViewState["ExamOrgID"] = Request.QueryString.Get("OrgID");
OrganizationBLL objOrgBll = new OrganizationBLL();
ViewState["ExamOrgName"] = objOrgBll.GetOrganization(Convert.ToInt32(ViewState["ExamOrgID"])).ShortName;
BindGrid();
}
}
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;
}
txtOrg.Text = hfOrgName.Value;
if (!IsPostBack && !Grid1.IsCallback)
{
lbltitle.Visible = false;
Grid1.Visible = false;
if (PrjPub.CurrentLoginUser.SuitRange != 1)
{
ImgSelectOrg.Visible = false;
OrganizationBLL objbll = new OrganizationBLL();
txtOrg.Text = objbll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
hfOrg.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString();
}
}
else
{
OrganizationBLL objbll = new OrganizationBLL();
txtOrg.Text = objbll.GetOrganization(Convert.ToInt32(hfOrg.Value)).ShortName;
}
string str = Request.Form.Get("Refresh");
if (str != null && str == "refresh")
{
BindGrid();
}
string strAdd = Request.Form.Get("add");
if (!string.IsNullOrEmpty(strAdd))
{
Import(1, strAdd);
BindGrid();
}
string strUpdate = Request.Form.Get("update");
if (!string.IsNullOrEmpty(strUpdate))
{
Import(2, strUpdate);
BindGrid();
}
}
private DonorBM create_donor()
{
//Crea un donador
OrganizationBLL organizationBll = new OrganizationBLL();
ResultBM result = organizationBll.GetOrganization(1);
PersonBM personBm = create_person();
DonorBM donorBm = new DonorBM(true, personBm, result.GetValue <OrganizationBM>());
DonorBLL donorBll = new DonorBLL();
ResultBM saveResult = donorBll.SaveDonor(donorBm);
Assert.IsTrue(saveResult.IsValid(), "El donador debería haberse creado.");
return(saveResult.GetValue <DonorBM>());
}
protected void Page_Load(object sender, EventArgs e)
{
if (fvOrganization.CurrentMode == FormViewMode.Insert)
{
if (hfInsert.Value == "-1")
{
((HiddenField)fvOrganization.FindControl("hfParentId")).Value = Request.QueryString["id"];
}
else
{
((HiddenField)fvOrganization.FindControl("hfParentId")).Value = hfInsert.Value;
}
}
string strDeleteID = Request.Form.Get("DeleteID");
if (strDeleteID != "" && strDeleteID != null)
{
OrganizationBLL objBll = new OrganizationBLL();
RailExam.Model.Organization organization = objBll.GetOrganization(Convert.ToInt32(strDeleteID));
int code = 0;
string sqlStr = "select count(*) from item where org_id=" + strDeleteID;
DataTable dt = new OracleAccess().RunSqlDataSet(sqlStr).Tables[0];
if (dt != null && Convert.ToInt32(dt.Rows[0][0]) > 0)
{
SessionSet.PageMessage = "该组织机构已被引用，不能删除！";
}
else
{
objBll.DeleteOrganization(Convert.ToInt32(strDeleteID), ref code);
if (code != 0) //code=2292
{
SessionSet.PageMessage = "该组织机构已被引用，不能删除！";
}
else
{
ClientScript.RegisterStartupScript(GetType(),
"jsSelectFirstNode",
@"window.parent.tvOrganizationChangeCallBack.callback(" + organization.ParentId +
@", 'Delete');
if(window.parent.tvOrganization.get_nodes().get_length() > 0)
{
window.parent.tvOrganization.get_nodes().getNode(0).select();
}",
true);
}
}
}
}
protected void btnClose_Click(object sender, EventArgs e)
{
string OrgID = this.hfOrgID.Value;
OrganizationBLL objBll = new OrganizationBLL();
string idpath = objBll.GetOrganization(Convert.ToInt32(OrgID)).IdPath;
if (string.IsNullOrEmpty(Request.QueryString.Get("style")))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "OK", "this.location.href='EmployeeInfo.aspx?ID=" + OrgID + "&idpath=" + idpath + "&type=Org';", true);
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "OK", "top.returnValue='true';top.close();", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OrganizationBLL orgBll = new OrganizationBLL();
hfOrg.Value = Request.QueryString.Get("OrgID");
txtOrg.Text = orgBll.GetOrganization(Convert.ToInt32(hfOrg.Value)).ShortName;
}
string str = Request.Form.Get("Refresh");
if (str != null && str == "refresh")
{
if (Session["table"] != null)
{
Grid1.DataSource = (DataTable)Session["table"];
Grid1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (!PrjPub.IsShowOnline())
//{
// Response.Redirect("/RailExamBao/Common/Error.aspx?error=您当前时间无权使用此功能");
//}
if (!PrjPub.IsServerCenter)
{
hfOrgID.Value = ConfigurationManager.AppSettings["StationID"];
if (!string.IsNullOrEmpty(hfOrgID.Value))
{
OrganizationBLL objbll = new OrganizationBLL();
txtOrg.Text = objbll.GetOrganization(Convert.ToInt32(hfOrgID.Value)).ShortName;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strStationID = ConfigurationManager.AppSettings["StationID"];
lbl.Text = "当前服务器为：";
if (strStationID == "200")
{
lbl.Text += PrjPub.GetRailName() + "服务器";
}
else
{
OrganizationBLL orgBll = new OrganizationBLL();
RailExam.Model.Organization organization = orgBll.GetOrganization(Convert.ToInt32(strStationID));
lbl.Text += organization.ShortName + "服务器";
}
lbl.Text += " 服务器编号为：" + PrjPub.ServerNo;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !CallBack1.IsCallback)
{
string struesrId = PrjPub.StudentID;
hfEmployeeID.Value = struesrId;
try
{
lblName.Text = PrjPub.CurrentStudent.EmployeeName;
}
catch
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=超时时间已到，请重新登录");
}
OrganizationBLL objOrgBll = new OrganizationBLL();
lblOrg.Text = objOrgBll.GetOrganization(PrjPub.CurrentStudent.StationOrgID).ShortName;
lblPost.Text = PrjPub.CurrentStudent.PostName;
int orgID;
if (PrjPub.IsServerCenter)
{
orgID = 0;
}
else
{
orgID = Convert.ToInt32(ConfigurationManager.AppSettings["StationID"]);
}
ExamBLL bkLL = new ExamBLL();
IList <RailExam.Model.Exam> ExamList = bkLL.GetExamByUserId(struesrId, orgID, PrjPub.ServerNo);
foreach (RailExam.Model.Exam exam in ExamList)
{
exam.ExamName = "<a onclick=AttendExam('" + exam.ExamId + "','" + exam.paperId + "','" + exam.ExamType + "') href=# title='参加考试' > " + exam.ExamName + " </a>";
}
gvExam.DataSource = ExamList;
gvExam.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//给FileUpLoad控件添加即时显示图片的事件
this.fileUpload1.Attributes.Add("onchange", "showSelectedImage()");
if (!IsPostBack)
{
initXiaLa();
string type = Request.QueryString["Type"];
string employeeid = Request.QueryString["ID"];
if (!string.IsNullOrEmpty(type))
{
int typeBool = int.Parse(type);
isReadOnly = typeBool == 0 ? true : false;
if (isReadOnly)
{
setReadOnlyControl();
}
}
if (!string.IsNullOrEmpty(employeeid))
{
OracleAccess ora = new OracleAccess();
DataSet ds = ora.RunSqlDataSet(" select * from employee where EMPLOYEE_ID = " + employeeid);
loadData(ds);
}
else
{
txtPinYin.Enabled = false;
imgORG.Visible = true;
ddlSafe.Enabled = true;
ddlTECHNICIAN_TYPE_ID.Enabled = true;
datePost.Enabled = true;
dateTechnicalDate.Enabled = true;
Image2.Visible = true;
DDLeducation_level_id.Enabled = true;
string orgID = Request.QueryString.Get("OrgID");
OrganizationBLL orgBll = new OrganizationBLL();
Organization org = orgBll.GetOrganization(Convert.ToInt32(orgID));
txtORG.Text = org.ShortName;
hfOrgID.Value = org.OrganizationId.ToString();
hfStationOrgID.Value = orgBll.GetStationOrgID(org.OrganizationId).ToString();
ddlISREGISTERED.SelectedValue = "1";
ddlIsGroup.SelectedValue = "0";
cbISONPOST.Checked = true;
}
}
if (!string.IsNullOrEmpty(hfOrgID.Value))
{
DataSet ds = new DataSet();
OracleAccess ora = new OracleAccess();
ds = ora.RunSqlDataSet("select a.*,GetOrgName(org_id) orgPath from ORG a where ORG_ID=" + Convert.ToInt32(hfOrgID.Value));
//OrganizationBLL orgBll = new OrganizationBLL();
//Organization org = orgBll.GetOrganization(Convert.ToInt32(hfOrgID.Value));
if (ds.Tables.Count > 0)
{
txtORG.Text = ds.Tables[0].Rows[0]["orgPath"].ToString();
//txtORG.Text = org.ShortName;
}
}
if (!string.IsNullOrEmpty(hfPostID.Value))
{
PostBLL postBll = new PostBLL();
Post post = postBll.GetPost(Convert.ToInt32(hfPostID.Value));
txtPOST.Text = post.PostName;
}
if (!string.IsNullOrEmpty(hfNowPostID.Value))
{
PostBLL postBll = new PostBLL();
Post post = postBll.GetPost(Convert.ToInt32(hfNowPostID.Value));
txtNowPost.Text = post.PostName;
}
}
private int SaveNewBook()
{
if (this.txtPageCount.Text == "")
{
this.txtPageCount.Text = "0";
}
if (this.txtWordCount.Text == "")
{
this.txtWordCount.Text = "0";
}
BookBLL kBLL = new BookBLL();
string strId = Request.QueryString.Get("knowledgeId");
RailExam.Model.Book book = new RailExam.Model.Book();
book.Memo = txtMemo.Text;
if (PrjPub.CurrentLoginUser.SuitRange == 1)
{
book.bookName = txtBookName.Text;
}
else
{
OrganizationBLL orgBll = new OrganizationBLL();
string orgName = orgBll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
book.bookName = orgName + txtBookName.Text;
}
book.Description = txtDescription.Text;
book.pageCount = int.Parse(txtPageCount.Text);
book.wordCount = int.Parse(txtWordCount.Text);
book.revisers = txtRevisers.Text;
book.authors = hfEmployeeID.Value;
book.bookmaker = txtBookMaker.Text;
book.bookNo = txtBookNo.Text;
book.coverDesigner = txtCoverDesigner.Text;
book.keyWords = txtKeyWords.Text;
book.knowledgeName = txtKnowledgeName.Text;
book.knowledgeId = int.Parse(hfKnowledgeID.Value);
book.publishOrg = int.Parse(hfPublishOrgID.Value);
book.publishDate = DateTime.Parse(datePublishDate.DateValue.ToString());
book.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue);
book.IsGroupLearder = Convert.ToInt32(ddlIsGroup.SelectedValue);
ArrayList alTrainTypeID = new ArrayList();
string strTrainTypeID = hfTrainTypeID.Value;
string[] str1 = strTrainTypeID.Split(new char[] { ',' });
for (int i = 0; i < str1.Length; i++)
{
if (!string.IsNullOrEmpty(str1[i]))
{
alTrainTypeID.Add(str1[i]);
}
}
book.trainTypeidAL = alTrainTypeID;
ArrayList al = new ArrayList();
book.orgidAL = GetOrg(tvOrg.Nodes, al);
ArrayList al1 = new ArrayList();
foreach (TreeViewNode tn in tvPost.Nodes)
{
if (tn.Checked)
{
al1.Add(tn.ID);
}
if (tn.Nodes.Count > 0)
{
foreach (TreeViewNode tns in tn.Nodes)
{
if (tns.Checked)
{
al1.Add(tns.ID);
}
if (tns.Nodes.Count > 0)
{
foreach (TreeViewNode tnss in tns.Nodes)
{
if (tnss.Checked)
{
al1.Add(tnss.ID);
}
}
}
}
}
}
book.postidAL = al1;
string strNewID = kBLL.AddBook(book).ToString();
string strPath = Server.MapPath("../Online/Book/" + strNewID);
Directory.CreateDirectory(strPath);
Directory.CreateDirectory(strPath + "/Upload");
CopyTemplate(Server.MapPath("../Online/Book/template/"), Server.MapPath("../Online/Book/" + strNewID + "/"));
SaveBookCover(strNewID);
return(Convert.ToInt32(strNewID));
}
private void BindOrganizationTree(ArrayList orgidAL)
{
OrganizationBLL organizationBLL = new OrganizationBLL();
IList <Organization> organizationList = new List <Organization>();
if (PrjPub.CurrentLoginUser.SuitRange == 1)
{
organizationList = organizationBLL.GetOrganizationsByLevel(2);
}
else
{
//if (string.IsNullOrEmpty(Request.QueryString.Get("id")))
//{
// organizationList = organizationBLL.GetOrganizations(PrjPub.CurrentLoginUser.StationOrgID);
//}
//else
//{
// string strSql = "select a.* from ("
// + "select b.Org_ID,b.Level_Num,b.Order_Index from Book_Range_Org a "
// + "inner join Org b on a.Org_ID=b.Org_ID "
// + " where Book_ID=" + Request.QueryString.Get("id")
// + " and GetStationOrgID(a.org_id) <> " + PrjPub.CurrentLoginUser.StationOrgID
// + " union "
// + " select Org_ID,Level_Num,Order_Index "
// + " from Org where GetStationOrgID(org_id)=" + PrjPub.CurrentLoginUser.StationOrgID
// + ") a order by Level_Num,Order_Index";
// OracleAccess db = new OracleAccess();
// DataSet ds = db.RunSqlDataSet(strSql);
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// Organization organization = organizationBLL.GetOrganization(Convert.ToInt32(dr["Org_ID"]));
// organizationList.Add(organization);
// }
//}
//string strSql = "select Org_ID,Level_Num,Order_Index from Org where Rail_System_ID=" +
// PrjPub.CurrentLoginUser.RailSystemID + " and level_num=2 order by Level_Num,Order_Index";
string strSql = "select Org_ID,Level_Num,Order_Index from Org where Org_ID=" +
PrjPub.CurrentLoginUser.StationOrgID;
OracleAccess db = new OracleAccess();
DataSet ds = db.RunSqlDataSet(strSql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Organization organization = organizationBLL.GetOrganization(Convert.ToInt32(dr["Org_ID"]));
organizationList.Add(organization);
}
}
if (organizationList.Count > 0)
{
TreeViewNode tvn = null;
foreach (Organization organization in organizationList)
{
if (!organization.IsEffect)
{
continue;
}
tvn = new TreeViewNode();
tvn.ID = organization.OrganizationId.ToString();
tvn.Value = organization.OrganizationId.ToString();
tvn.Text = organization.ShortName;
tvn.ToolTip = organization.FullName;
tvn.ShowCheckBox = true;
if (orgidAL.Count > 0)
{
if (orgidAL.IndexOf(organization.OrganizationId) != -1)
{
tvn.Checked = true;
}
}
if (PrjPub.CurrentLoginUser.SuitRange == 1)
{
if (organization.ParentId == 0)
{
tvOrg.Nodes.Add(tvn);
}
else
{
try
{
tvOrg.FindNodeById(organization.ParentId.ToString()).Nodes.Add(tvn);
}
catch
{
tvOrg.Nodes.Clear();
SessionSet.PageMessage = "数据错误！";
return;
}
}
}
else
{
if (organization.ParentId == 1)
{
tvOrg.Nodes.Add(tvn);
}
else
{
try
{
tvOrg.FindNodeById(organization.ParentId.ToString()).Nodes.Add(tvn);
}
catch
{
tvOrg.Nodes.Clear();
SessionSet.PageMessage = "数据错误！";
return;
}
}
}
}
}
tvOrg.DataBind();
//tvOrg.ExpandAll();
if (tvOrg.Nodes.Count > 0)
{
tvOrg.Nodes[0].Expanded = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (PrjPub.CurrentLoginUser == null)
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统！");
return;
}
hfIsWuhan.Value = PrjPub.IsWuhan().ToString();
string strBookID = Request.QueryString.Get("id");
ViewState["BookID"] = strBookID;
hfMode.Value = Request.QueryString.Get("mode");
if (strBookID != null && strBookID != "")
{
if (PrjPub.CurrentLoginUser.RoleID == 1)
{
ImgSelectEmployee.Visible = true;
}
else
{
ImgSelectEmployee.Visible = false;
}
if (hfMode.Value == "ReadOnly")
{
SaveButton.Visible = false;
CancelButton.Visible = true;
SaveNextButton.Visible = false;
SaveExitButton.Visible = false;
//ClientScript.RegisterStartupScript(GetType(), "jsHide", "<script>document.all.ImgSelectKnowledge.style.display='none';</script>");
//Response.Write("<script>document.all.ImgSelectKnowledge.style.display='none';</script>");
}
else if (hfMode.Value == "Edit")
{
btnCover.Visible = false;
btnChapter.Visible = true;
SaveButton.Visible = true;
CancelButton.Visible = false;
SaveExitButton.Visible = false;
SaveNextButton.Visible = false;
}
FillPage(int.Parse(strBookID));
}
else
{
if (PrjPub.CurrentLoginUser.RoleID != 1)
{
ImgSelectEmployee.Visible = false;
}
SaveButton.Visible = false;
SaveNextButton.Visible = true;
SaveExitButton.Visible = true;
CancelButton.Visible = false;
datePublishDate.DateValue = DateTime.Today.ToString("yyyy-MM-dd");
string strKnowledgeID = Request.QueryString.Get("knowledgeId");
if (strKnowledgeID != null && strKnowledgeID != string.Empty)
{
hfKnowledgeID.Value = strKnowledgeID;
KnowledgeBLL objBll = new KnowledgeBLL();
RailExam.Model.Knowledge obj = objBll.GetKnowledge(Convert.ToInt32(strKnowledgeID));
txtKnowledgeName.Text = txtKnowledgeName.Text + GetKnowledgeName("/" + obj.KnowledgeName, obj.ParentId);
ImgSelectKnowledge.Visible = false;
}
ArrayList objOrgList = new ArrayList();
if (PrjPub.CurrentLoginUser.SuitRange == 0)
{
OrganizationBLL orgBll = new OrganizationBLL();
txtPublishOrgName.Text = orgBll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
hfPublishOrgID.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString();
IList <Organization> objOrganizationList =
orgBll.GetOrganizationsByWhereClause("ID_Path || '/' like '/1/" + PrjPub.CurrentLoginUser.StationOrgID + "/%' ");
foreach (Organization organization in objOrganizationList)
{
objOrgList.Add(organization.OrganizationId);
}
}
txtAuthors.Text = PrjPub.CurrentLoginUser.EmployeeName;
hfEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString();
//txtPublishOrgName.Text = PrjPub.CurrentLoginUser.OrgName;
//hfPublishOrgID.Value = PrjPub.CurrentLoginUser.OrgID.ToString();
BindOrganizationTree(objOrgList);
ArrayList objList = new ArrayList();
if (!string.IsNullOrEmpty(Request.QueryString.Get("PostId")))
{
objList.Add(Convert.ToInt32(Request.QueryString.Get("PostId")));
}
BindPostTree(objList);
ddlTech.SelectedValue = "1";
}
}
if (!string.IsNullOrEmpty(hfTrainTypeID.Value))
{
TrainTypeBLL objBll = new TrainTypeBLL();
string[] str = hfTrainTypeID.Value.Split(',');
string strTypeName = "";
for (int i = 0; i < str.Length; i++)
{
TrainType obj = objBll.GetTrainTypeInfo(Convert.ToInt32(str[i]));
if (i == 0)
{
strTypeName = GetTrainTypeName("/" + obj.TypeName, obj.ParentID);
}
else
{
strTypeName = strTypeName + "," + GetTrainTypeName("/" + obj.TypeName, obj.ParentID);
}
}
txtTrainTypeName.Text = strTypeName;
}
if (!string.IsNullOrEmpty(hfPublishOrgID.Value))
{
OrganizationBLL orgbll = new OrganizationBLL();
txtPublishOrgName.Text = orgbll.GetOrganization(Convert.ToInt32(hfPublishOrgID.Value)).ShortName;
}
string strRefresh = Request.Form.Get("RefreshCover");
if (strRefresh != null && strRefresh != "")
{
//string strPath = "../Book/" + ViewState["BookID"].ToString() + "/cover.htm";
//BookBLL objBill = new BookBLL();
//objBill.UpdateBookUrl(Convert.ToInt32(ViewState["BookID"].ToString()), strPath);
//string strBookName = objBill.GetBook(Convert.ToInt32(ViewState["BookID"].ToString())).bookName;
//string srcPath = "../Online/Book/" + ViewState["BookID"].ToString() + "/Cover.htm";
//string str = File.ReadAllText(Server.MapPath(srcPath), System.Text.Encoding.UTF8);
//if (str.IndexOf("booktitle") < 0)
//{
// str = "<link href='book.css' type='text/css' rel='stylesheet' />"
// + "<div id='booktitle'>" + strBookName + "</div>" + "<br>"
// + str;
// File.WriteAllText(Server.MapPath(srcPath), str, System.Text.Encoding.UTF8);
//BookChapterBLL objChapterBll = new BookChapterBLL();
//objChapterBll.GetIndex(ViewState["BookID"].ToString());
//SystemLogBLL objLogBll = new SystemLogBLL();
//objLogBll.WriteLog("编辑教材《" + strBookName + "》前言");
//FillPage(Convert.ToInt32(ViewState["BookID"].ToString()));
}
}
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 ImportEmployeeExcel()
{
EmployeeBLL objEmployeeBll = new EmployeeBLL();
EmployeeDetailBLL objEmployeeDetailBll = new EmployeeDetailBLL();
EmployeeErrorBLL objErrorBll = new EmployeeErrorBLL();
IList <EmployeeError> objErrorList = new List <EmployeeError>();
string orgID = Request.QueryString.Get("OrgID");
OrganizationBLL orgBll = new OrganizationBLL();
RailExam.Model.Organization org = orgBll.GetOrganization(Convert.ToInt32(orgID));
string strUnitName = org.ShortName;
string strFileName = Server.UrlDecode(Request.QueryString.Get("FileName"));
string jsBlock = string.Empty;
string strPath = Server.MapPath("/RailExamBao/Excel/" + strFileName);
bool isClose = false;
string strMessage;
objErrorBll.DeleteEmployeeErrorByOrgIDAndImportTypeID(Convert.ToInt32(orgID));
#region 验证准备工作
Hashtable htOrg = GetOrgInfo();
Hashtable htPost = GetPostInfo();
Hashtable htEducationLevel = GetEducationLevel();
Hashtable htPoliticalStatus = GetPoliticalStatus();
Hashtable htShopNeedAdd = new Hashtable();
Hashtable htPostNeedAdd = new Hashtable();
Hashtable htIdentityCardNo = new Hashtable();
Hashtable htERP = new Hashtable();
PostBLL objPostBll = new PostBLL();
ArrayList objPostNewList = new ArrayList();
IList <RailExam.Model.EmployeeDetail> objEmployeeInsert = new List <RailExam.Model.EmployeeDetail>();
IList <RailExam.Model.EmployeeDetail> objEmployeeUpdate = new List <RailExam.Model.EmployeeDetail>();
#endregion
// 获取Excel列头数据
ISheet sheet = GetSheet(strPath);
// 验证列头
DataTable headLine = GetHeadLine(sheet);
string error;
if (!ValidateHeadLine(headLine, out error))
{
Response.Write("<script>window.returnValue='" + error + "',window.close();</script>");
return;
}
// 获取Excel数据行信息
DataTable excelDataRows = GetDataRows(sheet, jsBlock);
// 遍历、验证、保存
// 添加滚动条效果
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正准备检测Excel数据','0.00'); </script>";
Response.Write(jsBlock);
Response.Flush();
if (excelDataRows.Rows.Count == 0)
{
Response.Write("<script>window.returnValue='Excel中没有任何记录，请核对',window.close();</script>");
return;
}
for (int i = 0; i < excelDataRows.Rows.Count; i++)
{
// 滚动条效果
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在检测Excel数据','" +
((double)((i + 1) * 100) / (double)excelDataRows.Rows.Count).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
RailExam.Model.EmployeeDetail objEmployee = new RailExam.Model.EmployeeDetail();
bool isUpdate = false;
DataRow dr = excelDataRows.Rows[i];
//if (dr["员工ID"] != DBNull.Value && dr["员工ID"].ToString().Trim() != string.Empty)
//{
// isUpdate = false;
// try
// {
// objEmployee.EmployeeID = Convert.ToInt32(dr["员工ID"].ToString().Trim());
// }
// catch
// {
// AddError(objErrorList, dr, "员工ID填写错误");
// continue;
// }
//}
//else
//{
// isUpdate = true;
//}
// 单位
if (dr["单位"].ToString().Trim() != strUnitName &&
dr["单位"].ToString().Trim().Replace("神华包神铁路有限责任公司", "") != strUnitName)
{
AddError(objErrorList, dr, "单位填写错误");
continue;
}
// 部门
if (dr["部门"].ToString().Trim() == "")
{
AddError(objErrorList, dr, "部门不能为空");
continue;
}
string strWorkShop = dr["部门"].ToString().Trim();
if (strWorkShop.IndexOf("包神铁路公司" + strUnitName) >= 0)
{
strWorkShop = dr["部门"].ToString().Trim().Replace("包神铁路公司" + strUnitName, "");
}
//组织机构
string strOrg;
if (dr["员工组"].ToString().Trim() == string.Empty)
{
strOrg = strUnitName + "-" + strWorkShop;
}
else
{
strOrg = strUnitName + "-" + strWorkShop + "-" + dr["员工组"].ToString().Trim();
}
// 判断上面拼接的字符串是否存在于组织机构中
if (!htOrg.ContainsKey(strOrg))
{
if (dr["员工组"].ToString().Trim() == string.Empty)
{
if (!htShopNeedAdd.ContainsKey(strWorkShop))
{
htShopNeedAdd.Add(strWorkShop, new Hashtable());
}
//如果组织机构需要新增
objEmployee.Memo = strOrg;
}
else
{
if (!htShopNeedAdd.ContainsKey(strWorkShop))
{
htShopNeedAdd.Add(strWorkShop, new Hashtable());
}
Hashtable htGroupNeedAdd = (Hashtable)htShopNeedAdd[strWorkShop];
if (!htGroupNeedAdd.ContainsKey(dr["员工组"].ToString().Trim()))
{
htGroupNeedAdd.Add(dr["员工组"].ToString().Trim(), dr["员工组"].ToString().Trim());
htShopNeedAdd[strWorkShop] = htGroupNeedAdd;
}
//如果组织机构需要新增
objEmployee.Memo = strOrg;
}
}
else
{
objEmployee.OrgID = Convert.ToInt32(htOrg[strOrg]);
objEmployee.Memo = string.Empty;
}
// 姓名
if (dr["姓名"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "员工姓名不能为空");
continue;
}
else
{
if (dr["姓名"].ToString().Trim().Length > 20)
{
AddError(objErrorList, dr, "员工姓名不能超过20位");
continue;
}
objEmployee.EmployeeName = dr["姓名"].ToString().Trim();
objEmployee.PinYinCode = Pub.GetChineseSpell(dr["姓名"].ToString().Trim());
}
//身份证件号
if (dr["身份证件号"].ToString().Trim() == string.Empty && dr["员工编码"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "身份证件号和员工编码不能同时为空");
continue;
}
else if (dr["身份证件号"].ToString().Trim() != string.Empty)
{
if (dr["员工编码"].ToString().Trim() != string.Empty)
{
IList <RailExam.Model.Employee> objOldList =
objEmployeeBll.GetEmployeeByWhereClause("Work_NO='" + dr["员工编码"].ToString().Trim() + "' and Employee_Name='" + dr["姓名"].ToString().Trim() + "' and Identity_CardNo='" + dr["身份证件号"].ToString().Trim() + "'");
if (objOldList.Count > 0)
{
isUpdate = true;
objEmployee.EmployeeID = objOldList[0].EmployeeID;
}
else
{
isUpdate = false;
}
if (!isUpdate)
{
IList <RailExam.Model.Employee> objNowList = objEmployeeBll.GetEmployeeByWhereClause("Work_NO='" + dr["员工编码"].ToString().Trim() + "'");
if (objNowList.Count > 0)
{
AddError(objErrorList, dr, "员工编码与系统中【" + objNowList[0].OrgName + "的" + objNowList[0].EmployeeName + "】的员工编号重复");
continue;
}
}
//员工编码在Excel中不能重复
if (htERP.ContainsKey(dr["员工编码"].ToString().Trim()))
{
AddError(objErrorList, dr, "员工编码在Excel中与序号为" + htERP[dr["员工编码"].ToString().Trim()] + "的员工编码重复");
continue;
}
else
{
htERP.Add(dr["员工编码"].ToString().Trim(), dr["序号"].ToString().Trim());
}
objEmployee.WorkNo = dr["员工编码"].ToString().Trim();
}
else
{
IList <RailExam.Model.Employee> objOldList =
objEmployeeBll.GetEmployeeByWhereClause("Employee_Name='" + dr["姓名"].ToString().Trim() + "' and Identity_CardNo='" + dr["身份证件号"].ToString().Trim() + "'");
if (objOldList.Count > 0)
{
isUpdate = true;
objEmployee.EmployeeID = objOldList[0].EmployeeID;
}
else
{
isUpdate = false;
}
}
if (dr["身份证件号"].ToString().Trim().Length > 18)
{
AddError(objErrorList, dr, "身份证件号不能超过18位");
continue;
}
//身份证件号在Excel中不能重复
if (htIdentityCardNo.ContainsKey(dr["身份证件号"].ToString().Trim()))
{
AddError(objErrorList, dr, "身份证件号在Excel中与序号为" + htIdentityCardNo[dr["身份证件号"].ToString().Trim()] + "的身份证件号重复");
continue;
}
else
{
htIdentityCardNo.Add(dr["身份证件号"].ToString().Trim(), dr["序号"].ToString().Trim());
}
IList <RailExam.Model.Employee> objList =
objEmployeeBll.GetEmployeeByWhereClause("identity_CardNo='" + dr["身份证件号"].ToString().Trim() + "'");
if (objList.Count > 0)
{
if (isUpdate)
{
if (objList.Count > 1)
{
AddError(objErrorList, dr, "与该员工身份证件号完全相同的员工已经存在");
continue;
}
}
else
{
AddError(objErrorList, dr, "该员工身份证件号与【" + objList[0].OrgName + "】中【" + objList[0].EmployeeName + "】的身份证件号完全相同");
continue;
}
}
objEmployee.IdentifyCode = dr["身份证件号"].ToString().Trim();
}
else if (dr["身份证件号"].ToString().Trim() == string.Empty)
{
IList <RailExam.Model.Employee> objOldList =
objEmployeeBll.GetEmployeeByWhereClause("Work_NO='" + dr["员工编码"].ToString().Trim() + "' and Employee_Name='" + dr["姓名"].ToString().Trim() + "'");
if (objOldList.Count > 0)
{
isUpdate = true;
objEmployee.EmployeeID = objOldList[0].EmployeeID;
}
else
{
isUpdate = false;
}
//员工编码在Excel中不能重复
if (htERP.ContainsKey(dr["员工编码"].ToString().Trim()))
{
AddError(objErrorList, dr, "员工编码在Excel中与序号为" + htERP[dr["员工编码"].ToString().Trim()] + "的员工编码重复");
continue;
}
else
{
htERP.Add(dr["员工编码"].ToString().Trim(), dr["序号"].ToString().Trim());
}
objEmployee.WorkNo = dr["员工编码"].ToString().Trim();
}
//性别
if (dr["性别"].ToString().Trim() != "男" && dr["性别"].ToString().Trim() != "女")
{
AddError(objErrorList, dr, "性别必须为男或女");
continue;
}
else
{
objEmployee.Sex = dr["性别"].ToString().Trim();
}
//籍贯
if (dr["籍贯"].ToString().Trim().Length > 20)
{
AddError(objErrorList, dr, "籍贯不能超过20位");
continue;
}
else
{
objEmployee.NativePlace = dr["籍贯"].ToString().Trim();
}
//最高学历
if (dr["最高学历"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "最高学历不能为空");
continue;
}
else
{
if (!htEducationLevel.ContainsKey(dr["最高学历"].ToString().Trim()))
{
AddError(objErrorList, dr, "最高学历在系统中不存在");
continue;
}
else
{
objEmployee.EducationLevelID = Convert.ToInt32(htEducationLevel[dr["最高学历"].ToString().Trim()]);
}
}
//政治面貌
if (dr["政治面貌"].ToString().Trim() != string.Empty)
{
if (!htPoliticalStatus.ContainsKey(dr["政治面貌"].ToString().Trim()))
{
AddError(objErrorList, dr, "政治面貌在系统中不存在");
continue;
}
else
{
objEmployee.PoliticalStatusID = Convert.ToInt32(htPoliticalStatus[dr["政治面貌"].ToString().Trim()]);
}
}
else
{
objEmployee.PoliticalStatusID = 1;
}
//出生日期
if (dr["出生日期"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "出生日期不能为空");
continue;
}
else
{
try
{
string strBirth = dr["出生日期"].ToString().Trim().Replace(".", "");
if (strBirth.IndexOf("-") >= 0)
{
objEmployee.Birthday = Convert.ToDateTime(strBirth);
}
else
{
if (strBirth.Length != 8)
{
AddError(objErrorList, dr, "出生日期填写错误");
continue;
}
else
{
strBirth = strBirth.Insert(4, "-");
strBirth = strBirth.Insert(7, "-");
objEmployee.Birthday = Convert.ToDateTime(strBirth);
}
}
if (Convert.ToDateTime(strBirth) < Convert.ToDateTime("1900-1-1") ||
Convert.ToDateTime(strBirth) > Convert.ToDateTime("2000-12-31"))
{
AddError(objErrorList, dr, "出生日期填写错误");
continue;
}
}
catch
{
AddError(objErrorList, dr, "出生日期填写错误");
continue;
}
}
//进入本公司时间
if (dr["进入本公司时间"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "进入本公司时间不能为空");
continue;
}
else
{
try
{
string strJoin = dr["进入本公司时间"].ToString().Trim().Replace(".", "");
if (strJoin.IndexOf("-") >= 0)
{
objEmployee.WorkDate = Convert.ToDateTime(strJoin);
}
else
{
if (strJoin.Length != 8)
{
AddError(objErrorList, dr, "进入本公司时间填写错误");
continue;
}
else
{
strJoin = strJoin.Insert(4, "-");
strJoin = strJoin.Insert(7, "-");
objEmployee.WorkDate = Convert.ToDateTime(strJoin);
}
}
if (Convert.ToDateTime(strJoin) < Convert.ToDateTime("1900-1-1"))
{
AddError(objErrorList, dr, "进入本公司时间填写错误");
continue;
}
}
catch
{
AddError(objErrorList, dr, "进入本公司时间填写错误");
continue;
}
}
//参加工作日期
if (dr["参加工作时间"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "参加工作时间不能为空");
continue;
}
else
{
try
{
string strJoin = dr["参加工作时间"].ToString().Trim().Replace(".", "");
if (strJoin.IndexOf("-") >= 0)
{
objEmployee.BeginDate = Convert.ToDateTime(strJoin);
}
else
{
if (strJoin.Length != 8)
{
AddError(objErrorList, dr, "参加工作时间填写错误");
continue;
}
else
{
strJoin = strJoin.Insert(4, "-");
strJoin = strJoin.Insert(7, "-");
objEmployee.BeginDate = Convert.ToDateTime(strJoin);
}
}
if (Convert.ToDateTime(strJoin) < Convert.ToDateTime("1900-1-1"))
{
AddError(objErrorList, dr, "参加工作时间填写错误");
continue;
}
}
catch
{
AddError(objErrorList, dr, "参加工作时间填写错误");
continue;
}
}
//职名
if (dr["岗位名称"].ToString().Trim() == string.Empty)
{
AddError(objErrorList, dr, "岗位名称不能为空！");
continue;
}
else
{
IList <RailExam.Model.Post> objPost =
objPostBll.GetPostsByWhereClause("Post_Level=3 and Post_Name='" + dr["岗位名称"].ToString().Trim() + "'");
if (objPost.Count == 0)
{
if (htPostNeedAdd.ContainsKey(dr["岗位名称"].ToString().Trim()))
{
objPostNewList = (ArrayList)htPostNeedAdd[dr["岗位名称"].ToString().Trim()];
int x;
if (isUpdate)
{
x = objEmployeeUpdate.Count;
}
else
{
x = objEmployeeInsert.Count;
}
objPostNewList.Add(x + "|" + isUpdate);
htPostNeedAdd[dr["岗位名称"].ToString().Trim()] = objPostNewList;
}
else
{
objPostNewList = new ArrayList();
int x;
if (isUpdate)
{
x = objEmployeeUpdate.Count;
}
else
{
x = objEmployeeInsert.Count;
}
objPostNewList.Add(x + "|" + isUpdate);
htPostNeedAdd.Add(dr["岗位名称"].ToString().Trim(), objPostNewList);
}
}
objEmployee.PostID = Convert.ToInt32(htPost[dr["岗位名称"].ToString().Trim()]);
}
// 因dateAWARD_DATE未加入对象中， 所以此处缺失验证进入神华系统时间
if (dr["在岗"] == DBNull.Value || dr["在岗"].ToString() == "" || dr["在岗"].ToString() == "否" || dr["在岗"].ToString() == "0")
{
objEmployee.IsOnPost = false;
}
else if (dr["在岗"] != DBNull.Value && (dr["在岗"].ToString() == "是" || dr["在岗"].ToString() == "1"))
{
objEmployee.IsOnPost = true;
}
if (dr["在册"] == DBNull.Value || dr["在册"].ToString() == "" || dr["在册"].ToString() == "否" || dr["在册"].ToString() == "0")
{
objEmployee.Dimission = false;
}
else if (dr["在册"] != DBNull.Value && (dr["在册"].ToString() == "是" || dr["在册"].ToString() == "1"))
{
objEmployee.Dimission = true;
}
// 赋值默认值
if (!isUpdate)
{
//职工类型
objEmployee.EmployeeTypeID = 0;
// 在册
objEmployee.Dimission = true;
// 在岗
objEmployee.IsOnPost = true;
// 运输业职工类型
objEmployee.EmployeeTransportTypeID = 0;
objEmployeeInsert.Add(objEmployee);
}
else
{
objEmployeeUpdate.Add(objEmployee);
}
}
// 处理完成
jsBlock = "<script>SetCompleted('Excel数据检测完毕'); </script>";
Response.Write(jsBlock);
Response.Flush();
if (objErrorList.Count > 0)
{
// 处理完成
jsBlock = "<script>SetCompleted('正在统计不符合要求的数据，请等待......'); </script>";
Response.Write(jsBlock);
Response.Flush();
objErrorBll.AddEmployeeError(objErrorList);
if (File.Exists(strPath))
{
File.Delete(strPath);
}
Response.Write("<script>window.returnValue='refresh|请检查Excel数据',window.close();</script>");
return;
}
if (!string.IsNullOrEmpty(Request.QueryString.Get("mode")))
{
Response.Write("<script>window.returnValue='refresh|数据检查成功',window.close();</script>");
return;
}
#region 导入数据
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入部门名称、班组','0.00'); </script>";
Response.Write(jsBlock);
Response.Flush();
Database db = DatabaseFactory.CreateDatabase();
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
Hashtable htWorkshop = GetWorkShop(db, transaction);
int count = 1;
foreach (System.Collections.DictionaryEntry obj in htShopNeedAdd)
{
int nWorkShopID;
if (!htWorkshop.ContainsKey(obj.Key.ToString()))
{
RailExam.Model.Organization objshop = new RailExam.Model.Organization();
objshop.FullName = obj.Key.ToString();
objshop.ShortName = obj.Key.ToString();
objshop.ParentId = Convert.ToInt32(orgID);
objshop.Memo = "";
nWorkShopID = orgBll.AddOrganization(db, transaction, objshop);
}
else
{
nWorkShopID = Convert.ToInt32(htWorkshop[obj.Key.ToString()]);
}
Hashtable htGroup = (Hashtable)obj.Value;
if (htGroup.Count != 0)
{
foreach (System.Collections.DictionaryEntry objGroupNeedAdd in htGroup)
{
RailExam.Model.Organization objGroup = new RailExam.Model.Organization();
objGroup.FullName = objGroupNeedAdd.Key.ToString();
objGroup.ShortName = objGroupNeedAdd.Key.ToString();
objGroup.ParentId = nWorkShopID;
objGroup.Memo = "";
orgBll.AddOrganization(db, transaction, objGroup);
}
}
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入部门名称、班组','" + ((double)(count * 100) / (double)(htShopNeedAdd.Count + objEmployeeInsert.Count)).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = count + 1;
}
htWorkshop = GetWorkShop(db, transaction);
Hashtable htNowOrg = GetOrgInfo(db, transaction);
foreach (RailExam.Model.EmployeeDetail objEmployee in objEmployeeInsert)
{
if (objEmployee.Memo.ToString() != string.Empty)
{
if (objEmployee.Memo.Split('-').Length == 2)
{
objEmployee.OrgID = Convert.ToInt32(htWorkshop[objEmployee.Memo.Split('-')[1]]);
}
else
{
objEmployee.OrgID = Convert.ToInt32(htNowOrg[objEmployee.Memo.ToString()].ToString().Split('-')[0]);
}
}
if (objEmployee.OrgID == 0)
{
throw new Exception("aaaa");
}
objEmployee.Memo = "";
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入部门名称、班组','" + ((double)(count * 100) / (double)(htShopNeedAdd.Count + objEmployeeInsert.Count + objEmployeeUpdate.Count)).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = count + 1;
}
foreach (RailExam.Model.EmployeeDetail objEmployee in objEmployeeUpdate)
{
if (objEmployee.Memo.ToString() != string.Empty)
{
if (objEmployee.Memo.Split('-').Length == 2)
{
objEmployee.OrgID = Convert.ToInt32(htWorkshop[objEmployee.Memo.Split('-')[1]]);
}
else
{
objEmployee.OrgID = Convert.ToInt32(htNowOrg[objEmployee.Memo.ToString()].ToString().Split('-')[0]);
}
}
if (objEmployee.OrgID == 0)
{
throw new Exception("aaaa");
}
objEmployee.Memo = "";
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入部门名称、班组','" + ((double)(count * 100) / (double)(htShopNeedAdd.Count + objEmployeeInsert.Count + objEmployeeUpdate.Count)).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = count + 1;
}
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入干部职名','0.00'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = 1;
foreach (System.Collections.DictionaryEntry objPostNeed in htPostNeedAdd)
{
RailExam.Model.Post objPost = new RailExam.Model.Post();
objPost.ParentId = 1550; // 649通用-其他, 1550 其他-其他
objPost.PostName = objPostNeed.Key.ToString();
objPost.Technician = 0;
objPost.Promotion = 0;
objPost.Description = string.Empty;
objPost.Memo = string.Empty;
int postID = objPostBll.AddPost(db, transaction, objPost);
ArrayList objPostList = (ArrayList)objPostNeed.Value;
for (int i = 0; i < objPostList.Count; i++)
{
string[] strPost = objPostList[i].ToString().Split('|');
if (strPost[1] == "false" || strPost[1] == "False")
{
objEmployeeInsert[Convert.ToInt32(strPost[0])].PostID = postID;
}
else
{
objEmployeeUpdate[Convert.ToInt32(strPost[0])].PostID = postID;
}
}
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入职名','" + ((double)(count * 100) / (double)(htPostNeedAdd.Count)).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = count + 1;
}
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入员工信息','0.00'); </script>";
Response.Write(jsBlock);
Response.Flush();
OracleAccess access = new OracleAccess();
string strSql;
count = 1;
for (int i = 0; i < objEmployeeInsert.Count; i++)
{
int employeeid = objEmployeeDetailBll.AddEmployee(db, transaction, objEmployeeInsert[i]);
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入员工信息','" + ((double)(count * 100) / (double)(objEmployeeInsert.Count + objEmployeeUpdate.Count)).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = count + 1;
}
for (int i = 0; i < objEmployeeUpdate.Count; i++)
{
objEmployeeDetailBll.UpdateEmployee(db, transaction, objEmployeeUpdate[i]);
System.Threading.Thread.Sleep(10);
jsBlock = "<script>SetPorgressBar('正在导入员工信息','" + ((double)(count * 100) / (double)(objEmployeeInsert.Count + objEmployeeUpdate.Count)).ToString("0.00") + "'); </script>";
Response.Write(jsBlock);
Response.Flush();
count = count + 1;
}
strMessage = "导入成功!";
transaction.Commit();
}
catch (Exception ex)
{
strMessage = "导入失败!";
transaction.Rollback();
//Response.Write(EnhancedStackTrace(ex));
}
finally
{
connection.Close();
}
if (File.Exists(strPath))
{
File.Delete(strPath);
}
Response.Write("<script>window.returnValue='refresh|" + strMessage + "';window.close();</script>");
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (PrjPub.CurrentLoginUser == null)
{
Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统！");
return;
}
string strCoursewareID = Request.QueryString.Get("id");
hfMode.Value = Request.QueryString.Get("mode");
if (!string.IsNullOrEmpty(strCoursewareID)) //Update
{
FillPage(int.Parse(strCoursewareID));
}
else //Add
{
datePublishDate.DateValue = DateTime.Now.ToString("yyyy-MM-dd");
if (Request.QueryString.Get("coursewareTypeID") != null)
{
if (!string.IsNullOrEmpty(Request.QueryString.Get("coursewareTypeID")))
{
hfCoursewareTypeID.Value = Request.QueryString.Get("coursewareTypeID");
KnowledgeBLL objBll = new KnowledgeBLL();
RailExam.Model.Knowledge obj = objBll.GetKnowledge(Convert.ToInt32(hfCoursewareTypeID.Value));
txtCoursewareTypeName.Text = txtCoursewareTypeName.Text + GetKnowledgeName("/" + obj.KnowledgeName, obj.ParentId);
ImgSelectCoursewareType.Visible = false;
}
}
//string strId1 = Request.QueryString.Get("CoursewareTypeId");
//if (! string.IsNullOrEmpty(strId1))
//{
// CoursewareTypeBLL coursewareTypeBLL = new CoursewareTypeBLL();
// CoursewareType coursewareType = coursewareTypeBLL.GetCoursewareType(int.Parse(strId1));
// if (coursewareType != null)
// {
// txtCoursewareTypeName.Text = coursewareType.CoursewareTypeName;
// }
// hfCoursewareTypeID.Value = strId1;
//}
//string strTypeId1 = Request.QueryString.Get("TrainTypeId");
//if (! string.IsNullOrEmpty(strTypeId1))
//{
// TrainTypeBLL trainTypeBLL = new TrainTypeBLL();
// TrainType trainType = trainTypeBLL.GetTrainTypeInfo(int.Parse(strTypeId1));
// if (trainType != null)
// {
// txtTrainTypeName.Text = trainType.TypeName;
// }
// hfTrainTypeID.Value = strTypeId1;
//}
//txtProvideOrgName.Text = SessionSet.OrganizationName;
ViewState["AddFlag"] = 1;
ArrayList orgIDAL = new ArrayList();
ArrayList postIDAL = new ArrayList();
if (PrjPub.CurrentLoginUser.SuitRange == 0)
{
OrganizationBLL orgBll = new OrganizationBLL();
txtProvideOrgName.Text = orgBll.GetOrganization(PrjPub.CurrentLoginUser.StationOrgID).ShortName;
hfProvideOrgID.Value = PrjPub.CurrentLoginUser.StationOrgID.ToString();
IList <Organization> objOrganizationList =
orgBll.GetOrganizationsByWhereClause("ID_Path || '/' like '/1/" + PrjPub.CurrentLoginUser.StationOrgID + "/%' ");
foreach (Organization organization in objOrganizationList)
{
orgIDAL.Add(organization.OrganizationId);
}
}
BindOrganizationTree(orgIDAL);
BindPostTree(postIDAL);
}
}
}
private void BindOrgTree()
{
OrganizationBLL organizationBLL = new OrganizationBLL();
int railSystemID = PrjPub.GetRailSystemId();
if ((PrjPub.CurrentLoginUser.SuitRange == 1 || railSystemID != 0) && PrjPub.IsServerCenter)
{
IList <RailExam.Model.Organization> organizationList = organizationBLL.GetOrganizationsByLevel(2);
string strOwnIDs = string.Empty;
if (railSystemID != 0)
{
IList <RailExam.Model.Organization> organizationList1 = organizationBLL.GetOrganizations(PrjPub.CurrentLoginUser.StationOrgID);
foreach (RailExam.Model.Organization organization in organizationList1)
{
strOwnIDs += strOwnIDs == string.Empty
? organization.OrganizationId.ToString()
: "," + organization.OrganizationId;
}
}
if (organizationList.Count > 0)
{
TreeViewNode tvn = null;
foreach (Organization organization in organizationList)
{
if ((organization.IdPath + "/").IndexOf("/1/") >= 0 && organization.LevelNum != 1 && railSystemID != 0 && railSystemID != organization.RailSystemID)
{
continue;
}
if (organization.LevelNum != 1 && strOwnIDs != string.Empty && (organization.IdPath + "/").IndexOf("/1/") < 0 && ("," + strOwnIDs + ",").IndexOf("," + organization.OrganizationId + ",") < 0)
{
continue;
}
tvn = new TreeViewNode();
tvn.ID = organization.OrganizationId.ToString();
tvn.Value = organization.OrganizationId.ToString();
tvn.Text = organization.ShortName;
tvn.ToolTip = organization.FullName;
if (organization.ParentId == 0)
{
tvView.Nodes.Add(tvn);
}
else
{
try
{
tvView.FindNodeById(organization.ParentId.ToString()).Nodes.Add(tvn);
}
catch
{
tvView.Nodes.Clear();
SessionSet.PageMessage = "Êý¾Ý´íÎó£¡";
return;
}
}
}
}
if (tvView.Nodes.Count > 0)
{
tvView.Nodes[0].Expanded = true;
}
}
else
{
string strOrgID;
if (PrjPub.IsServerCenter)
{
strOrgID = PrjPub.CurrentLoginUser.StationOrgID.ToString();
}
else
{
strOrgID = ConfigurationManager.AppSettings["StationID"].ToString();
}
int stationID = organizationBLL.GetStationOrgID(Convert.ToInt32(strOrgID));
RailExam.Model.Organization organization = organizationBLL.GetOrganization(stationID);
TreeViewNode tvn = null;
tvn = new TreeViewNode();
tvn.ID = organization.OrganizationId.ToString();
tvn.Value = organization.IdPath.ToString();
tvn.Text = organization.ShortName;
tvn.ToolTip = organization.FullName;
tvView.Nodes.Add(tvn);
}
tvView.DataBind();
}
