/// <summary>
/// 获取并设置人员信息
/// </summary>
/// <param name="ID">ID</param>
private void InitEmployeInfo(string ID)
{
//获取申请单数据
DataTable dtEmpl = EmployeeInfoBus.GetEmplDeptInfoWithID(ID);
//数据存在时，设置值
if (dtEmpl != null && dtEmpl.Rows.Count > 0)
{
//离职人
txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "ID");
//员工编号
txtEmployeeNo.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeNo");
//员工名
txtEmployeeName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeName");
//部门名称
txtDeptName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptName");
//岗位名
txtQuarterName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterName");
//岗位职等
txtAdminLevelName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelName");
//入职时间
txtEnterDate.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EnterDate");
//设置不可编辑
txtEmployeeNo.Enabled = false;
}
}
/// <summary>
/// 根据人员编号，获取人员信息，并设置到页面显示
/// </summary>
/// <param name="employeeNo">人员编号</param>
private void InitEmployeeInfo(string employeeID)
{
//查询数据
EmployeeInfoModel employModel = EmployeeInfoBus.GetEmployeeInfoWithID(int.Parse(employeeID));
//设置人员基本信息
InitEmployeeBaseInfo(employModel);
//设置人员工作履历以及学习履历
InitHistoryInfo(employModel);
//设置技能信息
InitSkillInfo(employModel);
//设置合同信息
if (employModel.ContractInfo != null)
{
//设定合同信息数据源
rpEmployeeContract.DataSource = employModel.ContractInfo;
//绑定数据源
rpEmployeeContract.DataBind();
//合同信息可见
divContract.Visible = true;
}
}
/// <summary>
/// 获取并设置人员信息
/// </summary>
/// <param name="ID">ID</param>
private void InitEmployeInfo(string ID)
{
//获取申请单数据
DataTable dtEmpl = EmployeeInfoBus.GetEmplDeptInfoWithID(ID);
//数据存在时，设置值
if (dtEmpl != null && dtEmpl.Rows.Count > 0)
{
//调职人
txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "ID");
divCodeNo.Attributes.Add("style", "width:60%;");
//员工编号
txtEmployeeNo.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeNo");
//员工名
txtEmployeeName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeName");
//原部门名称
txtNowDeptName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptName");
//原部门ID
txtNowDeptID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptID");
//原岗位名
txtNowQuarterName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterName");
//原岗位ID
txtNowQuarterID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterID");
//原岗位职等名称
txtNowQuarterAdminName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelName");
//原岗位职等ID
txtNowQuarterAdminID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelID");
//设置不可编辑
txtEmployeeNo.Enabled = false;
}
}
protected void btn_excel_Click(object sender, EventArgs e)
{
if (this.upExcelFile.PostedFile.FileName.Length > 0)
{
this.initState();
}
else
{
this.lbl_upresult.Text = "请选择要上传的Excel文件!";
return;
}
string filename = upExcelFile.PostedFile.FileName;
string subfile = filename.Substring(filename.LastIndexOf(".") + 1);
if (subfile.ToUpper() != "XLS" && subfile.ToUpper() != "XLSX")
{
this.lbl_upresult.Text = "导入文件格式错误,必须为XLS,XLSX格式!";
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), 0, 0, this.lbl_upresult.Text);
}
else
{
try
{
//获取企业上传文件路径
string upfilepath = ProductInfoBus.GetCompanyUpFilePath(userinfo.CompanyCD);//得到格式如:"D:\zhou"
//获取企业并构造企业上传文件名称
Session["newfile"] = DateTime.Now.ToString("yyyyMMddhhmmss") + filename.Substring(filename.LastIndexOf("\\") + 1);
//Session["newfile"] = "HR_ZHOU.xls";
upExcelFile.PostedFile.SaveAs(upfilepath + @"\" + Session["newfile"].ToString());
this.lbl_upresult.Text = "Excel文件上传成功!";
this.setup1.Enabled = true;
//将excel中的数据读取到ds中
try
{
ds = EmployeeInfoBus.ReadEexcel(upfilepath + @"\" + Session["newfile"].ToString(), userinfo.CompanyCD);
if (ds.Tables[0].Rows.Count < 1)
{
initState();
this.lbl_upresult.Text = "您导入的Excel表没有数据!";
return;
}
}
catch (Exception ex)
{
initState();
this.lbl_upresult.Text = "数据读取失败,原因：" + ex.Message;
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), 0, 0, this.lbl_upresult.Text);
}
}
catch (Exception ex)
{
this.setup1.Enabled = false;
this.lbl_upresult.Text = "数据读取失败,原因：" + ex.Message;
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), 0, 0, this.lbl_upresult.Text);
}
}
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
EmployeeSearchModel model = new EmployeeSearchModel(); //获取数据
model.EmployeeNo = txtEmployeeNo.Value.Trim(); //编号
model.EmployeeNum = txtEmployeeNum.Value.Trim(); //工号
model.PYShort = txtPYShort.Value.Trim(); //拼音缩写
model.EmployeeName = txtEmployeeName.Value.Trim(); //姓名
model.ContractKind = ""; //request.QueryString["ContractKind"].Trim();//工种
model.AdminLevelID = ""; // request.QueryString["AdminLevel"].Trim(); //行政等级
model.QuarterID = ddlQuarter_ddlCodeType.SelectedItem.Value; //岗位
model.PositionID = ddlPosition.SelectedValue; //职称
string BeginDate = txtStartDate.Value.Trim(); //入职开始时间
string EndDate = txtEnterEndDate.Value.Trim();
DataTable dt = EmployeeInfoBus.ExportEmployeeWorkInfo(model, BeginDate, EndDate, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "编号", "工号", "姓名", "拼音缩写", "曾用名", "部门", "英文名", "人员分类",
"证件类型", "证件号码", "社保卡号", "应聘职务", "岗位", "职称", "岗位职等",
"所在部门", "入职时间", "性别", "出生日期", "联系电话", "手机号码", "电子邮件", "其他联系方式",
"籍贯", "婚姻状况", "学历", "毕业院校", "专业", "政治面貌", "宗教信仰",
"民族", "户口", "户口性质", "国家地区", "身高(厘米)", "体重", "视力",
"最高学位", "健康状况", "特长", "计算机水平", "参加工作时间", "家庭住址", "外语语种1",
"外语语种2", "外语语种3", "外语水平1", "外语水平2", "外语水平3",
"专业描述" },
new string[] { "EmployeeNo", "EmployeeNum", "EmployeeName", "PYShort", "UsedName", "DeptName", "NameEn", "Flag",
"DocuType", "CardID", "SafeguardCard", "PositionTitle", "QuarterName", "PositionName", "AdminLevelName",
"DeptName", "EnterDate", "Sex", "Birth", "Telephone", "Mobile", "EMail", "OtherContact",
"Origin", "MarriageStatus", "CultureLevel", "GraduateSchool", "Professional", "Landscape", "Religion",
"NationalName", "Account", "AccountNature", "CountryName", "Height", "Weight", "Sight",
"Degree", "HealthStatus", "Features", "ComputerLevel", "WorkTime", "HomeAddress", "ForeignLanguage11",
"ForeignLanguage12", "ForeignLanguage13", "ForeignLanguageLevel1", "ForeignLanguageLevel2", "ForeignLanguageLevel3",
"ProfessionalDes" },
"在职人员列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btn_input_Click(object sender, EventArgs e)
{
try
{
userinfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
EmployeeInfoBus.GetExcelToEmployeeInfo(userinfo.CompanyCD);
this.lbl_jg.Text = "Excel数据导入成功";
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), ds.Tables[0].Rows.Count, 1, "成功导入" + ds.Tables[0].Rows.Count.ToString() + "条数据");
/*
* 更新有特殊符号的员工编号"##@@$$@@##"
*/
DataSet nullds = EmployeeInfoBus.GetNullEmployeeList(userinfo.CompanyCD);
for (int i = 0; i < nullds.Tables[0].Rows.Count; i++)
{
//获取规则码
string employeeNo = XBase.Business.Common.ItemCodingRuleBus.GetCodeValue(ruleCode.ToString(), "EmployeeInfo", "EmployeeNo");
EmployeeInfoBus.UpdateEmployeeInfo(userinfo.CompanyCD, employeeNo, nullds.Tables[0].Rows[i]["ID"].ToString());
}
/*
* 更新结束
*/
if (Session["newfile"] != null)
{
ProductInfoBus.DeleteFile(userinfo.CompanyCD, Session["newfile"].ToString());
}
this.tab_end.Visible = true;
btn_input.Enabled = false;
}
catch (Exception ex)
{
btn_input.Enabled = true;
this.tab_end.Visible = true;
this.lbl_jg.Text = ex.Message;
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), 0, 0, this.lbl_jg.Text);
}
}
protected void setup4_Click(object sender, EventArgs e)
{
errorstr = string.Empty;
ruleCode = EmployeeInfoBus.GetCodeRuleID(userinfo.CompanyCD);
if (ruleCode < 1)
{
errorstr = "<strong>员工编号编码规则没有设置,设置步骤如下</strong><br><br>办公模式->系统管理->公用设置->基础数据编号设置，点击[新建]按钮，选择“基础数据名称”为“人员”";
if (Session["newfile"] != null)
{
ProductInfoBus.DeleteFile(userinfo.CompanyCD, Session["newfile"].ToString());
}
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), 0, 0, errorstr);
this.tr_result.Visible = true;
}
else
{
this.tr_result.Visible = false;
tr_repeat.Visible = false;
this.setup4.Enabled = false;
this.btn_input.Enabled = true;
lbl_validateend.Visible = true;
}
}
protected void setup3_Click(object sender, EventArgs e)
{
string suberrorstr = string.Empty;
errorstr = string.Empty;
int j = 0; //定义错误列表序号
int total = 0; //总错误记录
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim().Length > 0)
{
bool flag = EmployeeInfoBus.ChargeDeptInfo(ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim(), ds.Tables[0].Rows[i]["部门编号"].ToString().Trim(), userinfo.CompanyCD);
if (!flag)
{
if (ds.Tables[0].Rows[i]["部门编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() + "行中部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() + "</span>的 部门 不存在,导入操作失败!<br>";
}
else
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() + "行中的 目前所在部门 不存在,导入操作失败!<br>";
}
tr_repeat.Visible = false;
}
//部门多于一个选择
int num = EmployeeInfoBus.ChargeDeptInfoNum(ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim(), ds.Tables[0].Rows[i]["部门编号"].ToString().Trim(), userinfo.CompanyCD);
if (num > 1)
{
DataTable DeptInfoDt = EmployeeInfoBus.GetDeptInfo(ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim(), userinfo.CompanyCD);
Repeat_data.DataSource = DeptInfoDt;
Repeat_data.DataBind();
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() + "行中的 目前所在部门 重复,导入操作失败!<br><br><span style='color:red'>解决办法</span>:<span style='color:blue'>在数据重复列表中找到正确的部门编号,填写到Excel文件中,然后重新导入</span>";
this.tr_result.Visible = true;
tr_repeat.Visible = true;
tr_quqrter.Visible = false;
tr_dept.Visible = true;
errorstr = suberrorstr;
return;
}
}
}
if (j > 0)
{
total += j;
errorstr += "<strong>是否存在校验错误列表(部门)</strong><br>";
errorstr += suberrorstr;
suberrorstr = string.Empty;
this.tr_result.Visible = true;
tr_quqrter.Visible = false;
tr_dept.Visible = false;
return;
}
j = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//判断岗位是否存在
if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0)
{
bool flag = EmployeeInfoBus.ChargeQuarterInfo(ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim(), ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim(), ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim(), ds.Tables[0].Rows[i]["部门编号"].ToString().Trim(), userinfo.CompanyCD);
if (!flag) //岗位不存在
{
if (ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim().Length > 0 && ds.Tables[0].Rows[i]["部门编号"].ToString().Trim().Length > 0)
{
if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0 && ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>,岗位名称为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在岗位"].ToString() +
"</span>,岗位编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["岗位编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>,岗位名称为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在岗位"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else if (ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>,岗位编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["岗位编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
}
else if (ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim().Length > 0)
{
if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0 && ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,岗位名称为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在岗位"].ToString() +
"</span>,岗位编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["岗位编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,岗位名称为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在岗位"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else if (ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,岗位编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["岗位编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中部门为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在部门"].ToString() +
"</span>,部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
}
else if (ds.Tables[0].Rows[i]["部门编号"].ToString().Trim().Length > 0)
{
if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0 && ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中的部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>,岗位名称为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在岗位"].ToString() +
"</span>,岗位编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["岗位编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else if (ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中的部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>,岗位名称为<span style='color:blue'>" + ds.Tables[0].Rows[i]["目前所在岗位"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else if (ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim().Length > 0)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中的部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>,岗位编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["岗位编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
else
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() +
"行中的部门编号为<span style='color:blue'>" + ds.Tables[0].Rows[i]["部门编号"].ToString() +
"</span>的 岗位 不存在,导入操作失败!<br>";
}
}
tr_repeat.Visible = false;
}
//岗位多于一个选择
DataTable QuarterDT = EmployeeInfoBus.ChargeQuarterInfoNum(ds.Tables[0].Rows[i]["目前所在岗位"].ToString().Trim(), ds.Tables[0].Rows[i]["岗位编号"].ToString().Trim(), ds.Tables[0].Rows[i]["目前所在部门"].ToString().Trim(), ds.Tables[0].Rows[i]["部门编号"].ToString().Trim(), userinfo.CompanyCD);
if (QuarterDT.Rows.Count > 1)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() + "行中的 目前所在岗位 重复,导入操作失败!<br><br><span style='color:red'>解决办法</span>:<span style='color:blue'>在数据重复列表中找到正确的岗位编号,填写到Excel文件中,然后重新导入</span>";
this.tr_result.Visible = true;
tr_quqrter.Visible = true;
tr_repeat.Visible = true;
tr_dept.Visible = false;
rpt_quarter.DataSource = QuarterDT;
rpt_quarter.DataBind();
errorstr = suberrorstr;
return;
}
}
}
if (j > 0)
{
total += j;
errorstr = "<strong>是否存在校验错误列表(岗位)</strong><br>";
errorstr += suberrorstr;
suberrorstr = string.Empty;
}
j = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["婚姻状况"].ToString().Trim().Length > 0)
{
bool flag = EmployeeInfoBus.ChargeHyInfo(ds.Tables[0].Rows[i]["婚姻状况"].ToString().Trim(), userinfo.CompanyCD);
if (!flag)
{
suberrorstr += (++j).ToString() + "： " + "第" + (i + 2).ToString() + "行中的 婚姻状况 不存在,导入操作失败!<br>";
}
}
}
if (j > 0)
{
total += j;
total += j;
errorstr += "<strong>是否存在校验错误列表(婚姻状况)</strong><br>";
errorstr += suberrorstr;
suberrorstr = string.Empty;
}
if (total > 0)
{
if (Session["newfile"] != null)
{
ProductInfoBus.DeleteFile(userinfo.CompanyCD, Session["newfile"].ToString());
}
ProductInfoBus.LogInsert(userinfo.CompanyCD, userinfo.DeptID, userinfo.UserID, Request.QueryString["ModuleID"].ToString(), 0, 0, errorstr);
this.tr_result.Visible = true;
}
else
{
this.tr_result.Visible = false;
this.setup3.Enabled = false;
this.setup4.Enabled = true;
}
}
void LoadDataBind()
{
string No = Request.QueryString["No"].ToString(); //编号
string ID = Request.QueryString["ID"].ToString(); //ID
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
DataTable dt = EmployeeInfoBus.PrintEmployee(CompanyCD, No);
DataTable dtHis = EmployeeInfoBus.PrintHistory(CompanyCD, No);
DataTable dtHisWork = new DataTable();
dtHisWork = dtHis.Clone();
DataTable dtHisStudy = new DataTable();
dtHisStudy = dtHis.Clone();
DataRow[] rows = dtHis.Select("Flag = 1");
foreach (DataRow row in rows)
{
dtHisWork.Rows.Add(row.ItemArray);
}
DataRow[] rows2 = dtHis.Select("Flag = 2");
foreach (DataRow row in rows2)
{
dtHisStudy.Rows.Add(row.ItemArray);
}
DataTable dtSkill = EmployeeInfoBus.PrintSkill(CompanyCD, No);
DataTable dtContract = EmployeeContractBus.PrintContract(CompanyCD, ID);
if (dt != null)
{
//主报表
rd.Load(Server.MapPath(@"~/PrinttingModel/HumanManager/EmployeeInfoPrint.rpt"));
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.EmployeeInfo"));
//子报表
if (dtHisWork != null)
{
ReportDocument rdHisWork = rd.Subreports["EmployeeHistoryWork.rpt"];
rdHisWork.SetDataSource(dtHisWork);
}
if (dtHisStudy != null)
{
ReportDocument rdHisStudy = rd.Subreports["EmployeeHistoryStudy.rpt"];
rdHisStudy.SetDataSource(dtHisStudy);
}
if (dtSkill != null)
{
ReportDocument rdSkill = rd.Subreports["EmployeeSkill.rpt"];
rdSkill.SetDataSource(dtSkill);
}
if (dtContract != null)
{
ReportDocument rdContract = rd.Subreports["EmoloyeeContract.rpt"];
rdContract.SetDataSource(dtContract);
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//绑定数据
rd.SetDataSource(dt);
rd.SetParameterValue("Today", "制表人：" + userInfo.EmployeeName);
this.CrystalReportViewer1.ReportSource = rd;
}
}
