public CMSMStruct.EmployeeStruct GetEmpInfoByName(string strEmpName)
{
DataTable dtout = Ea.GetEmpInfoByName(strEmpName);
CMSMStruct.EmployeeStruct es1 = new CommCenter.CMSMStruct.EmployeeStruct();
if (dtout != null)
{
es1.strCardID = dtout.Rows[0]["vcCardID"].ToString();
es1.strEmpName = dtout.Rows[0]["vcEmpName"].ToString();
es1.strOfficer = dtout.Rows[0]["vcCommName"].ToString();
}
return(es1);
}
public CMSMStruct.EmployeeStruct GetEmpInfo(string strCardid)
{
DataTable dtout = Ea.GetEmpInfo(strCardid);
CMSMStruct.EmployeeStruct es1 = new CommCenter.CMSMStruct.EmployeeStruct();
if (dtout != null)
{
es1.strCardID = dtout.Rows[0]["vcCardID"].ToString();
es1.strEmpName = dtout.Rows[0]["vcEmpName"].ToString();
es1.strSex = dtout.Rows[0]["vcSex"].ToString();
es1.strEmpNbr = dtout.Rows[0]["vcEmpNbr"].ToString();
es1.strInDate = dtout.Rows[0]["dtInDate"].ToString();
es1.strDegree = dtout.Rows[0]["vcDegree"].ToString();
es1.strLinkPhone = dtout.Rows[0]["vcLinkPhone"].ToString();
es1.strAddress = dtout.Rows[0]["vcAddress"].ToString();
es1.strOfficer = dtout.Rows[0]["vcOfficer"].ToString();
es1.strDeptID = dtout.Rows[0]["vcDeptID"].ToString();
es1.strFlag = dtout.Rows[0]["vcFlag"].ToString();
es1.strComments = dtout.Rows[0]["vcComments"].ToString();
}
return(es1);
}
private void btMod_Click(object sender, System.EventArgs e)
{
CMSMStruct.EmployeeStruct esnew = new CommCenter.CMSMStruct.EmployeeStruct();
esnew.strCardID = txtCardID.Text.Trim();
CMSMStruct.EmployeeStruct esold = (CMSMStruct.EmployeeStruct)Session["esold"];
if (esold == null)
{
this.SetErrorMsgPageBydir("调整员工信息出错，请退出本页面重试！");
return;
}
else if (esold.strCardID != esnew.strCardID)
{
this.SetErrorMsgPageBydir("调整员工信息出错，请退出本页面重试！");
return;
}
if (txtEmpName.Text.Trim() == "")
{
this.SetErrorMsgPageBydir("员工姓名不能为空！");
return;
}
else
{
esnew.strEmpName = txtEmpName.Text.Trim();
if (esold.strEmpName == esnew.strEmpName)
{
esnew.strEmpName = txtEmpName.Text.Trim();
}
else
{
if (esins.ChkEmpNameDup(txtEmpName.Text.Trim()))
{
esnew.strEmpName = txtEmpName.Text.Trim();
}
else
{
this.SetErrorMsgPageBydir("该员工姓名已经存在，请重新输入！");
return;
}
}
}
if (txtEmpNbr.Text.Trim() != "" && txtEmpNbr.Text.Trim().Length != 15 && txtEmpNbr.Text.Trim().Length != 18)
{
this.SetErrorMsgPageBydir("身份证号不正确！");
return;
}
else
{
esnew.strEmpNbr = txtEmpNbr.Text.Trim();
}
if (strInDate == "" || strInDate == null)
{
this.SetErrorMsgPageBydir("入职时间不能为空！");
return;
}
else
{
esnew.strInDate = strInDate;
}
esnew.strFlag = ddlFlag.SelectedValue;
esnew.strOfficer = ddlOfficer.SelectedValue;
esnew.strDeptID = ddlDept.SelectedValue;
esnew.strSex = ddlSex.SelectedValue;
esnew.strDegree = ddlDegree.SelectedValue;
esnew.strLinkPhone = txtLinkPhone.Text.Trim();
esnew.strAddress = txtAddress.Text.Trim();
esnew.strComments = txtComments.Text.Trim();
if (!esins.ModEmployee(esold, esnew))
{
this.SetErrorMsgPageBydir("调整员工信息失败或者没有做任何调整！");
return;
}
else
{
this.SetSuccMsgPageBydir("调整员工信息成功！", "EmpLoy/wfmEmpInfo.aspx");
return;
}
}
private DataSet CheckEmpSch(DataSet ds)
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
emb = new EmpBusi(strcons);
DataTable dtEmp = emb.GetEmployInfo();
Hashtable htEmpCardID = new Hashtable();
foreach (DataRow dr in dtEmp.Rows)
{
CMSMStruct.EmployeeStruct emp1 = new CommCenter.CMSMStruct.EmployeeStruct();
emp1.strCardID = dr["vcCardID"].ToString();
emp1.strEmpName = dr["vcEmpName"].ToString();
emp1.strOfficer = dr["vcOfficer"].ToString();
emp1.strDeptID = dr["vcDeptName"].ToString();
htEmpCardID.Add(emp1.strCardID, emp1);
}
DataTable dtDeptManager = emb.GetDeptManagerList();
Hashtable htManager = new Hashtable();
string strManaDeptID = "";
string strManager = "";
if (dtDeptManager != null && dtDeptManager.Rows.Count > 0)
{
strManaDeptID = dtDeptManager.Rows[0]["vcDeptID"].ToString();
}
for (int i = 0; i < dtDeptManager.Rows.Count; i++)
{
if (strManaDeptID == dtDeptManager.Rows[i]["vcDeptID"].ToString())
{
strManager += dtDeptManager.Rows[i]["vcEmpName"].ToString() + ",";
}
else
{
if (strManager != "")
{
strManager = strManager.Substring(0, strManager.Length - 1);
}
htManager.Add(strManaDeptID, strManager);
strManaDeptID = dtDeptManager.Rows[i]["vcDeptID"].ToString();
strManager = dtDeptManager.Rows[i]["vcEmpName"].ToString() + ",";
}
if (i == dtDeptManager.Rows.Count - 1)
{
if (strManager != "")
{
strManager = strManager.Substring(0, strManager.Length - 1);
}
htManager.Add(strManaDeptID, strManager);
}
}
int iError = 0;
DataTable dt = ds.Tables[0];
dt.Columns.Add("校验错误");
dt.Columns.Add("vcSchID");
dt.Columns.Add("vcDeptName");
dt.Columns.Add("vcManager");
dt.Columns.Add("vcCardID");
dt.Columns.Add("vcEmpName");
dt.Columns.Add("vcEmpOF");
dt.Columns.Add("vcClass");
dt.Columns.Add("dtCheckIn");
dt.Columns.Add("dtCheckOut");
foreach (DataRow dr in dt.Rows)
{
string strSchID = dr["排班日期"].ToString().Trim();
if (strSchID.Length != 8)
{
dr["校验错误"] += strSchID + "：排班日期应为8位日期；";
iError += 1;
}
else
{
DateTime dtsch = new DateTime(int.Parse(strSchID.Substring(0, 4)), int.Parse(strSchID.Substring(4, 2)), int.Parse(strSchID.Substring(6, 2)));
if (dtsch.CompareTo(DateTime.Today) < 0)
{
dr["校验错误"] += strSchID + "：不能排今天以前的班；";
iError += 1;
}
else
{
dr["vcSchID"] = strSchID;
}
}
string strDeptName = dr["门店"].ToString().Trim();
string strDeptOldID = "";
bool isdeptexist = false;
DataTable dtDept = (DataTable)Application["AllMD"];
foreach (DataRow dr1 in dtDept.Rows)
{
if (dr1["vcCommName"].ToString() == strDeptName)
{
isdeptexist = true;
strDeptOldID = dr1["vcCommCode"].ToString();
break;
}
}
if (!isdeptexist)
{
dr["校验错误"] += strDeptName + "：门店不存在；";
iError += 1;
}
else
{
dr["vcDeptName"] = strDeptName;
}
if (dr["vcDeptName"].ToString() != "" && strDeptOldID != "")
{
if (htManager.ContainsKey(strDeptOldID))
{
dr["vcManager"] = htManager[strDeptOldID].ToString();
}
}
string strCardID = dr["员工卡号"].ToString();
string strEmpName = dr["员工姓名"].ToString();
string strOfficer = dr["职务"].ToString();
if (!htEmpCardID.ContainsKey(strCardID))
{
dr["校验错误"] += strCardID + "：卡号不正确，员工不存在；";
iError += 1;
}
else
{
dr["vcCardID"] = strCardID;
CMSMStruct.EmployeeStruct emptmp2 = (CMSMStruct.EmployeeStruct)htEmpCardID[strCardID];
if (emptmp2.strEmpName != strEmpName)
{
dr["校验错误"] += strEmpName + "：员工姓名不正确；";
iError += 1;
}
else
{
dr["vcEmpName"] = strEmpName;
}
if (emptmp2.strOfficer != strOfficer)
{
dr["校验错误"] += strOfficer + "：职务不正确；";
iError += 1;
}
else
{
dr["vcEmpOF"] = strOfficer;
}
if (emptmp2.strDeptID != strDeptName)
{
dr["校验错误"] += strDeptName + "：员工所属部门不正确；";
iError += 1;
}
}
string strClass = dr["班次"].ToString();
if (emb.IsEmpSchExist(strSchID, strDeptName, strCardID, strClass))
{
dr["校验错误"] += "系统中已有该员工的本条排班信息；";
iError += 1;
}
else
{
dr["vcClass"] = strClass;
}
string InHour = dr["上班-小时"].ToString().Trim();
string InMin = dr["上班-分钟"].ToString().Trim();
string OutHour = dr["下班-小时"].ToString().Trim();
string OutMin = dr["下班-分钟"].ToString().Trim();
string nextoutflag = dr["次日下班"].ToString().Trim();
if (!(this.JudgeIsNum(InHour) && this.JudgeIsNum(InMin) && this.JudgeIsNum(OutHour) && this.JudgeIsNum(OutMin)))
{
dr["校验错误"] += "上下班的小时数或分钟数中有非数字字符；";
iError += 1;
}
else
{
if (!(this.JudgeIs24Hour(InHour) && this.JudgeIs60Minute(InMin) && this.JudgeIs24Hour(OutHour) && this.JudgeIs60Minute(OutMin)))
{
dr["校验错误"] += "上下班的小时数或分钟数有误；";
iError += 1;
}
else
{
if (dr["vcSchID"].ToString() != "")
{
DateTime dtIn = new DateTime(int.Parse(dr["vcSchID"].ToString().Substring(0, 4)), int.Parse(dr["vcSchID"].ToString().Substring(4, 2)), int.Parse(dr["vcSchID"].ToString().Substring(6, 2)), int.Parse(InHour), int.Parse(InMin), 0);
DateTime dtOut = DateTime.Now;
if (nextoutflag == "是")
{
dtOut = new DateTime(dtIn.AddDays(1).Year, dtIn.AddDays(1).Month, dtIn.AddDays(1).Day, int.Parse(OutHour), int.Parse(OutMin), 0);
}
else
{
dtOut = new DateTime(int.Parse(dr["vcSchID"].ToString().Substring(0, 4)), int.Parse(dr["vcSchID"].ToString().Substring(4, 2)), int.Parse(dr["vcSchID"].ToString().Substring(6, 2)), int.Parse(OutHour), int.Parse(OutMin), 0);
}
if (dtIn.CompareTo(dtOut) > 0)
{
dr["校验错误"] += "上班时间不能大于下班时间；";
iError += 1;
}
TimeSpan tsIn = new TimeSpan(dtIn.Ticks);
TimeSpan tsOut = new TimeSpan(dtOut.Ticks);
TimeSpan ts = tsIn.Subtract(tsOut).Duration();
double diffdate = Math.Round(double.Parse(ts.Hours.ToString()) + double.Parse(ts.Minutes.ToString()) / 60, 2);
if (diffdate < 8.5)
{
dr["校验错误"] += "每班次的上班时间应大于8小时30分钟；";
iError += 1;
}
dr["dtCheckIn"] = dtIn;
dr["dtCheckOut"] = dtOut;
}
}
}
}
this.txtError.Text = iError.ToString();
return(ds);
}