public void ApplyDorm(List <string> mKeys, string sHandlerWorkdayNo, string sEnName, string sDormAreaID, string sHandle, string sMsg)
{
var assignArea = new AssignRoomBLL();
foreach (var k in mKeys)
{
var dtAppInfo = _mDAL.GetApplyDormByID(k);
var dr = dtAppInfo.Rows[0];
var sWorkdayNo = dr["EmployeeNo"] as string;
if ("1" == sHandle)
{
TB_AssignDormArea tB_AssignDormArea = new TB_AssignDormArea();
tB_AssignDormArea.DormAreaID = Convert.ToInt32(sDormAreaID);
tB_AssignDormArea.CardNo = dr["CardNo"] as string;
tB_AssignDormArea.EmployeeNo = sWorkdayNo;
tB_AssignDormArea.CreateUser = sHandlerWorkdayNo;
tB_AssignDormArea.CreateDate = System.DateTime.Now;
if (assignArea.AssignArea(tB_AssignDormArea))
{
_mDAL.HandleApplyDorm(k, sEnName, sHandle, sMsg);
}
}
else
{
_mDAL.HandleApplyDorm(k, sEnName, sHandle, sMsg);
}
MessageBLL.SendJpush(sWorkdayNo, "宿舍申请", "宿舍申请", sMsg, "msg");
}
}
private void CacheData()
{
Pager pager = null;
//已经锁定的房间数
DataTable dtAssignedRoom = new AssignRoomBLL().GetPagerData(ref pager, string.Empty, string.Empty);
ViewState["dtAssignedRoom"] = dtAssignedRoom;
}
protected void btnSearch_Click(object sender, EventArgs e)
{
lblCName.Text = string.Empty;
lblEmpTypeName.Text = string.Empty;
var sInputID = this.txtScanCardNO.Text.Trim();
var sWorkDayNO = this.txtWorkDayNo.Text.Trim();
string sIdCard = string.Empty;
GetIdCardNumber(sInputID, sWorkDayNO, out sIdCard);
//查询人员信息
DataTable dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard);
if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo))
{
ddlRoomSexType.SelectedValue = dtEmployeeInfo.Rows[0]["Sex"].ToString();
lblCName.Text = dtEmployeeInfo.Rows[0]["ChineseName"].ToString();
lblEmpTypeName.Text = dtEmployeeInfo.Rows[0]["EmployeeTypeName"].ToString();
//检查是否申请住房津贴
bool isHaveApplyAllowance = new AssignRoomBLL().CheckAllowanceApply(dtEmployeeInfo.Rows[0]["EmployeeID"].ToString());
if (isHaveApplyAllowance)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户申请了住房津贴！如需入住，请申请取消津贴')", true);
return;
}
//检查是否有分配记录
DataTable dtAssignArea = new AssignRoomBLL().GetAssignDormArea(dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString());
if (dtAssignArea.Rows.Count > 0)
{
int dormAreaID = Convert.ToInt32(dtAssignArea.Rows[0]["DormAreaID"].ToString());
ViewState["dormAreaID"] = dormAreaID;
DormManageAjaxServices ser = new DormManageAjaxServices();
DataTable dtBuild = ser.GetBuildingByDormAreaID(dormAreaID);
ddlBind(dtBuild);
Bind(1, dormAreaID);
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户还没分配宿舍！')", true);
return;
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('招聘系统找不到此用户！')", true);
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
try
{
var sInputID = this.txtScanCardNO.Text.Trim();
var sWorkDayNO = this.txtWorkDayNo.Text.Trim();
string sIdCard = string.Empty;
GetIdCardNumber(sInputID, sWorkDayNO, out sIdCard);
//查询人员信息
DataTable dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard);
if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo))
{
//检查是否有分配记录
var dr = dtEmployeeInfo.Rows[0];
DataTable dtAssignArea = new AssignRoomBLL().GetAssignDormArea(dr["IDCardNumber"].ToString());
if (dtAssignArea.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户没有分配记录！')", true);
return;
}
else
{
bool isDel = new AssignRoomBLL().DelAssignDormArea(dr["IDCardNumber"].ToString());
if (isDel)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('删除成功！')", true);
this.Bind(1);
return;
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('招聘系统找不到此用户！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + ex.Message + "')", true);
}
finally
{
ClearWorkIDInput();
}
}
private void Bind(int intCurrentIndex)
{
TB_AssignRoom mTB_AssignRoom = new TB_AssignRoom();
AssignRoomBLL mAssignRoomBLL = new AssignRoomBLL();
Pager pager = new Pager();
DataTable dtSource = null;
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
dtSource = mAssignRoomBLL.GetPagerData(ref pager, this.txtCardNo.Text.Trim(), this.ddlStatus.SelectedValue);
GridView1.DataSource = dtSource;
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
protected void btnAssign_Click(object sender, EventArgs e)
{
try
{
var sInputID = this.txtScanCardNO.Text.Trim();
var sWorkDayNO = this.txtWorkDayNo.Text.Trim();
string sIdCard = string.Empty;
GetIdCardNumber(sInputID, sWorkDayNO, out sIdCard);
TB_AllowanceApplyBLL bll = new TB_AllowanceApplyBLL();
//查询人员信息
DataTable dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard);
if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo))
{
//检查用工类型
var sEmpType = dtEmployeeInfo.Rows[0]["EmployeeTypeName"].ToString();
if (!CanApplay(sEmpType))
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户用工类型为：" + sEmpType + "，不能申请住房津贴')", true);
return;
}
//检查是否已经申请津贴
TB_AllowanceApply tb_AllowanceApply = new TB_AllowanceApply();
tb_AllowanceApply.EmployeeNo = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString();
tb_AllowanceApply.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
Pager pager = new Pager();
pager.CurrentPageIndex = 1;
pager.srcOrder = " ID desc";
DataTable dt = bll.GetTableByID(tb_AllowanceApply, ref pager);
if (dt.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已经申请过住房津贴，不能重复申请')", true);
return;
}
//检查是否有分配记录
DataTable dtAssignArea = new AssignRoomBLL().GetAssignDormArea(dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString());
if (dtAssignArea.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有分配住宿记录！暂时不能申请')", true);
return;
}
//检查是否已经有CheckIn的记录
DataTable DtCheck = new AssignRoomBLL().GetAssignedData(dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString(), "");
if (DtCheck != null && DtCheck.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有入住记录！请先退宿舍')", true);
}
else
{
TB_AllowanceApply tB_AllowanceApply = new TB_AllowanceApply();
tB_AllowanceApply.EmployeeNo = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString();
tB_AllowanceApply.Name = dtEmployeeInfo.Rows[0]["ChineseName"].ToString();
tB_AllowanceApply.CardNo = sIdCard;
tB_AllowanceApply.Sex = dtEmployeeInfo.Rows[0]["Sex"].ToString();
tB_AllowanceApply.Company = "";
tB_AllowanceApply.BU = dtEmployeeInfo.Rows[0]["SegmentName"].ToString();
tB_AllowanceApply.Grade = 0;
tB_AllowanceApply.CheckOutDate = GetCheckOutDate(tB_AllowanceApply.EmployeeNo);
tB_AllowanceApply.EmployeeTypeName = dtEmployeeInfo.Rows[0]["EmployeeTypeName"].ToString();
tB_AllowanceApply.CreateUser = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount);
tB_AllowanceApply.CreateDate = System.DateTime.Now;
tB_AllowanceApply.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
tB_AllowanceApply.Hire_Date = Convert.ToDateTime(dtEmployeeInfo.Rows[0]["Hire_Date"]);
tB_AllowanceApply.Effective_Date = DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddHours(-DateTime.Now.Hour + 1).AddMinutes(-DateTime.Now.Minute).AddSeconds(-DateTime.Now.Second);
bll.ADDAllowanceApply(tB_AllowanceApply);
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('申请成功！')", true);
this.Bind(1);
if (dtEmployeeInfo.Rows[0]["Phone"].ToString() != "")
{
//string sContent = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString() + "亲，以下是你被分配的宿舍信息：" + sDormAreaName + "宿舍 " + sBuildingName + "栋 " + sRoomName + "房间 " + sBedName + "床. 该宿舍的服务热线18926980019,请于3天内前往宿舍区办理入住手续，谢谢！ ";
try
{
//SendSMS(dtEmployeeInfo.Rows[0]["Phone"].ToString(), sContent);
}
catch
{
return;
}
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('招聘系统找不到此用户！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + ex.Message + "')", true);
}
finally
{
ClearWorkIDInput();
}
}
protected void btnAssign_Click(object sender, EventArgs e)
{
try
{
var sInputID = this.txtScanCardNO.Text.Trim();
var sWorkDayNO = this.txtWorkDayNo.Text.Trim();
string sIdCard = string.Empty;
GetIdCardNumber(sInputID, sWorkDayNO, out sIdCard);
DataTable dt = ViewState["dtSetupContent"] as DataTable;
DataRow[] drArr = null;
DataTable dtAssignRoom = ViewState["dtAssignedRoom"] as DataTable;
DataRow[] drAssignRoomArr = null;
//ServiceReference1.EmployeeInfoSoapClient employee = new ServiceReference1.EmployeeInfoSoapClient();
//DataTable dtEmployeeInfo = employee.GetEmployee(this.txtScanCardNO.Text.Trim());
//查询人员信息
DataTable dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard);
//DataTable dtEmployeeInfo = new DataTable();
//dtEmployeeInfo.Columns.Add("Segment");
//dtEmployeeInfo.Columns.Add("EmployeeID");
//dtEmployeeInfo.Columns.Add("IDCard");
//dtEmployeeInfo.Columns.Add("ChineseName");
//dtEmployeeInfo.Columns.Add("Sex");
//DataRow drNew = dtEmployeeInfo.NewRow();
//drNew["Segment"] = "BU1";
//drNew["EmployeeID"] = "2051773";
//drNew["IDCard"] = "1234567890";
//drNew["ChineseName"] = "Eric liu";
//drNew["Sex"] = "男";
//dtEmployeeInfo.Rows.Add(drNew);
if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo))
{
string condition = " BU='" + dtEmployeeInfo.Rows[0]["SegmentName"] + "' and Sex ='" + dt.Rows[0]["Sex"] + "' ";
drArr = dt.Select(condition);
drAssignRoomArr = dtAssignRoom.Select("DormAreaID=" + drArr[0]["DormAreaID"] + " and BuildingID=" + drArr[0]["BuildingID"] + " and RoomType=" + drArr[0]["RoomType"] + " and RoomSexType='" + drArr[0]["Sex"] + "'");
string sDormAreaName = drAssignRoomArr[0]["DormAreaName"].ToString();
string sBuildingName = drAssignRoomArr[0]["BuildingName"].ToString();
string sRoomName = drAssignRoomArr[0]["RoomName"].ToString();
string sBedName = drAssignRoomArr[0]["BedName"].ToString();
if (dtEmployeeInfo.Rows[0]["Sex"].ToString() == RemarkAttribute.GetEnumRemark(TypeManager.Sex.Male))
{
this.txtEmployeeNo.Text = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString();
this.txtCardNo.Text = dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString();
this.txtName.Text = dtEmployeeInfo.Rows[0]["ChineseName"].ToString();
this.txtBU.Text = dtEmployeeInfo.Rows[0]["SegmentName"].ToString();
this.txtDormArea.Text = drAssignRoomArr[0]["DormAreaName"].ToString();
this.txtBuilding.Text = drAssignRoomArr[0]["BuildingName"].ToString();
this.txtRoom.Text = drAssignRoomArr[0]["RoomName"].ToString();
this.txtBed.Text = drAssignRoomArr[0]["BedName"].ToString();
}
else
{
//this.rbSex.SelectedValue = Convert.ToString((int)TypeManager.Sex.Female);
this.txtFemaleEmployeeNo.Text = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString();
this.txtFemaleCardNo.Text = dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString();
this.txtFemaleName.Text = dtEmployeeInfo.Rows[0]["ChineseName"].ToString();
this.txtFemaleBU.Text = dtEmployeeInfo.Rows[0]["SegmentName"].ToString();
this.txtFemaleDormArea.Text = drAssignRoomArr[0]["DormAreaName"].ToString();
this.txtFemaleBuilding.Text = drAssignRoomArr[0]["BuildingName"].ToString();
this.txtFemaleRoom.Text = drAssignRoomArr[0]["RoomName"].ToString();
this.txtFemaleBed.Text = drAssignRoomArr[0]["BedName"].ToString();
}
//检查是否已经有CheckIn的记录
DataTable DtCheck = new AssignRoomBLL().GetAssignedData(dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString(), "");
if (DtCheck != null && DtCheck.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有分配记录！')", true);
}
else
{
TB_EmployeeCheckIn mTB_EmployeeCheckIn = new TB_EmployeeCheckIn();
mTB_EmployeeCheckIn.RoomID = Convert.ToInt32(drAssignRoomArr[0]["RoomID"]);
mTB_EmployeeCheckIn.BedID = int.Parse(drAssignRoomArr[0]["BedID"].ToString());
mTB_EmployeeCheckIn.BU = Util.NormalBU(dtEmployeeInfo.Rows[0]["SegmentName"].ToString());
mTB_EmployeeCheckIn.CardNo = sIdCard; //this.txtScanCardNO.Text;
mTB_EmployeeCheckIn.CheckInDate = DateTime.Now;
mTB_EmployeeCheckIn.Company = string.Empty;
mTB_EmployeeCheckIn.EmployeeNo = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString();
mTB_EmployeeCheckIn.Name = dtEmployeeInfo.Rows[0]["ChineseName"].ToString();
mTB_EmployeeCheckIn.Sex = drAssignRoomArr[0]["RoomSexType"].ToString() == "男" ? 1 : 2;
mTB_EmployeeCheckIn.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckIn.Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount);
mTB_EmployeeCheckIn.IsActive = (int)TypeManager.IsActive.Invalid;
mTB_EmployeeCheckIn.Telephone = dtEmployeeInfo.Rows[0]["Phone"].ToString();
var bAssign = new AssignRoomBLL().AssignRoom(mTB_EmployeeCheckIn);
if (!bAssign)
{
var msg = "分配房间失败，请重新分配";
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + msg + "')", true);
return;
}
dtAssignRoom.Rows.Remove(drAssignRoomArr[0]);
ViewState["dtAssignedRoom"] = dtAssignRoom;
//this.txtNation.Text = dt.Rows[0]["Nation"].ToString();
//this.txtAddress.Text = dt.Rows[0]["Address"].ToString();
//this.txtDept.Text = dt.Rows[0]["Segment"].ToString();
//this.txtBirthDay.Text = dt.Rows[0]["Birth"].ToString();
if (dtEmployeeInfo.Rows[0]["Phone"].ToString() != "")
{
string sContent = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString() + "亲，以下是你被分配的宿舍信息：" + sDormAreaName + "宿舍 " + sBuildingName + "栋 " + sRoomName + "房间 " + sBedName + "床. 该宿舍的服务热线18926980019,请于3天内前往宿舍区办理入住手续，谢谢！ ";
try
{
SendSMS(dtEmployeeInfo.Rows[0]["Phone"].ToString(), sContent);
}
catch
{
return;
}
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('招聘系统找不到此用户！')", true);
}
//this.txtScanCardNO.Text = string.Empty;
//this.ReadCardTimer.Enabled = true;
//this.txtScanCardNO.Focus();
}
catch
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('异常错误，请检查！')", true);
}
finally
{
ClearWorkIDInput();
}
}
//分配
protected void btnAssign_Click(object sender, EventArgs e)
{
try
{
//获取选中的ID
string bagID = selbagID.Value;
//查询room信息
DataTable dt = ViewState["dtFreeRoom"] as DataTable;
DataRow[] drAssignRoomArr = dt.Select("ID=" + bagID + "");
var drAssign = drAssignRoomArr[0];
var sIdCard = this.txtScanCardNO.Text.Trim();
var sName = this.txtScanName.Text.Trim();
if (!Util.IsValidIDCard(sIdCard))
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('不是有效的中国身份证！')", true);
return;
}
if (string.IsNullOrEmpty(sIdCard) || string.IsNullOrEmpty(sName))
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('姓名应当提供！')", true);
return;
}
//查询人员信息
var sSex = Util.IsIDCardMan(sIdCard) > 0 ? "男" : "女";
if (sSex != drAssign["RoomSexType"].ToString())
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('身份证的性别与房间的性别不匹配，不能分配！')", true);
return;
}
string sDormAreaName = drAssign["DormAreaName"].ToString();
string sBuildingName = drAssign["BuildingName"].ToString();
string sRoomName = drAssign["RoomName"].ToString();
string sBedName = drAssign["Name"].ToString();
//检查是否已经有CheckIn的记录
DataTable DtCheckIDCard = new AssignRoomBLL().GetAssignedData(sIdCard, "");
if (DtCheckIDCard != null && DtCheckIDCard.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有分配记录！')", true);
return;
}
else
{
TB_EmployeeCheckIn mTB_EmployeeCheckIn = new TB_EmployeeCheckIn();
mTB_EmployeeCheckIn.RoomID = Convert.ToInt32(drAssign["RoomID"]);
mTB_EmployeeCheckIn.BedID = int.Parse(drAssign["ID"].ToString());
mTB_EmployeeCheckIn.BU = string.Empty;
//TODO 2018-02-07
//由于 EHR.[Segment] 的ID 与 DormManage.[TB_BU]根本不对应
//因此，换房记录无法导出事业部
mTB_EmployeeCheckIn.BUID = 0;
mTB_EmployeeCheckIn.CardNo = sIdCard;
mTB_EmployeeCheckIn.CheckInDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
mTB_EmployeeCheckIn.Company = string.Empty;
mTB_EmployeeCheckIn.EmployeeNo = string.Empty;
mTB_EmployeeCheckIn.Name = sName;
mTB_EmployeeCheckIn.Sex = drAssign["RoomSexType"].ToString() == "男" ? 1 : 2;
mTB_EmployeeCheckIn.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckIn.Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount);
mTB_EmployeeCheckIn.IsActive = (int)TypeManager.IsActive.Valid;
mTB_EmployeeCheckIn.Telephone = string.Empty;
mTB_EmployeeCheckIn.EmployeeTypeName = string.Empty;
var bAssign = new AssignRoomBLL().AssignRoom(mTB_EmployeeCheckIn);
if (!bAssign)
{
var msg = "分配房间失败，请重新分配";
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + msg + "')", true);
return;
}
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('分配成功！')", true);
ClearControl();
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + ex.Message + "')", true);
}
}
protected void btnAssign_Click(object sender, EventArgs e)
{
try
{
var sInputID = this.txtScanCardNO.Text.Trim();
var sWorkDayNO = this.txtWorkDayNo.Text.Trim();
string sIdCard = string.Empty;
GetIdCardNumber(sInputID, sWorkDayNO, out sIdCard);
//获取选中的ID
string areaID = selAreaID.Value;
//查询room信息
//DataTable dt = ViewState["dtDormArea"] as DataTable;
//DataRow[] drAssignAreaArr = dt.Select("ID=" + areaID + "");
//查询人员信息
DataTable dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard);
if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo))
{
//检查是否有分配记录
DataTable dtAssignArea = new AssignRoomBLL().GetAssignDormArea(dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString());
if (dtAssignArea.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有分配记录！')", true);
return;
}
//检查是否已经有CheckIn的记录
DataTable DtCheck = new AssignRoomBLL().GetAssignedData(dtEmployeeInfo.Rows[0]["IDCardNumber"].ToString(), "");
if (DtCheck != null && DtCheck.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有入住记录！')", true);
}
else
{
var dr = dtEmployeeInfo.Rows[0];
TB_AssignDormArea tB_AssignDormArea = new TB_AssignDormArea();
tB_AssignDormArea.DormAreaID = Convert.ToInt32(areaID);
tB_AssignDormArea.CardNo = string.IsNullOrEmpty(sIdCard) ? dr["IDCardNumber"].ToString() : sIdCard;
tB_AssignDormArea.EmployeeNo = dr["EmployeeID"].ToString();
tB_AssignDormArea.CreateUser = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount);
tB_AssignDormArea.CreateDate = System.DateTime.Now;
new AssignRoomBLL().AssignArea(tB_AssignDormArea);
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('分配成功！')", true);
this.Bind(1);
if (dtEmployeeInfo.Rows[0]["Phone"].ToString() != "")
{
//string sContent = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString() + "亲，以下是你被分配的宿舍信息：" + sDormAreaName + "宿舍 " + sBuildingName + "栋 " + sRoomName + "房间 " + sBedName + "床. 该宿舍的服务热线18926980019,请于3天内前往宿舍区办理入住手续，谢谢！ ";
try
{
//SendSMS(dtEmployeeInfo.Rows[0]["Phone"].ToString(), sContent);
}
catch
{
return;
}
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('招聘系统找不到此用户！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + ex.Message + "')", true);
}
finally
{
ClearWorkIDInput();
}
}
protected void btnAssign_Click(object sender, EventArgs e)
{
try
{
//获取选中的ID
string bagID = selbagID.Value;
//查询room信息
DataTable dt = ViewState["dtFreeRoom"] as DataTable;
DataRow[] drAssignRoomArr = dt.Select("ID=" + bagID + "");
var drAssign = drAssignRoomArr[0];
var sInputID = this.txtScanCardNO.Text.Trim();
var sWorkDayNO = this.txtWorkDayNo.Text.Trim();
string sIdCard = string.Empty;
GetIdCardNumber(sInputID, sWorkDayNO, out sIdCard);
//查询人员信息
DataTable dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard);
if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo))
{
var drEmp = dtEmployeeInfo.Rows[0];
if (drEmp["Sex"].ToString() != drAssign["RoomSexType"].ToString())
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('性别不符合宿舍定义，不能分配！')", true);
return;
}
string sDormAreaName = drAssign["DormAreaName"].ToString();
string sBuildingName = drAssign["BuildingName"].ToString();
string sRoomName = drAssign["RoomName"].ToString();
string sBedName = drAssign["Name"].ToString();
//检查是否已经有CheckIn的记录
DataTable DtCheckIDCard = new AssignRoomBLL().GetAssignedData(drEmp["IDCardNumber"].ToString(), "");
DataTable DtCheckEmployeeID = new AssignRoomBLL().GetAssignedData(drEmp["EmployeeID"].ToString(), "");
if (DtCheckIDCard != null && DtCheckIDCard.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有分配记录！')", true);
}
else if (DtCheckEmployeeID != null && DtCheckEmployeeID.Rows.Count > 0)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已有分配记录！')", true);
}
else
{
TB_EmployeeCheckIn mTB_EmployeeCheckIn = new TB_EmployeeCheckIn();
mTB_EmployeeCheckIn.RoomID = Convert.ToInt32(drAssign["RoomID"]);
mTB_EmployeeCheckIn.BedID = int.Parse(drAssign["ID"].ToString());
mTB_EmployeeCheckIn.BU = Util.NormalBU(drEmp["SegmentName"].ToString());
//TODO 2018-02-07
//由于 EHR.[Segment] 的ID 与 DormManage.[TB_BU]根本不对应
//因此，换房记录无法导出事业部
mTB_EmployeeCheckIn.BUID = drEmp["SegmentID"] != DBNull.Value
? Convert.ToInt32(drEmp["SegmentID"])
: 0;
mTB_EmployeeCheckIn.CardNo = string.IsNullOrEmpty(sIdCard) ? drEmp["IDCardNumber"].ToString() : sIdCard;
mTB_EmployeeCheckIn.CheckInDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
mTB_EmployeeCheckIn.Company = string.Empty;
mTB_EmployeeCheckIn.EmployeeNo = drEmp["EmployeeID"].ToString();
mTB_EmployeeCheckIn.Name = drEmp["ChineseName"].ToString();
mTB_EmployeeCheckIn.Sex = drAssign["RoomSexType"].ToString() == "男" ? 1 : 2;
mTB_EmployeeCheckIn.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckIn.Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount);
mTB_EmployeeCheckIn.IsActive = (int)TypeManager.IsActive.Valid;
mTB_EmployeeCheckIn.Telephone = drEmp["Phone"].ToString();
mTB_EmployeeCheckIn.EmployeeTypeName = drEmp["EmployeeTypeName"].ToString();
var bAssign = new AssignRoomBLL().AssignRoom(mTB_EmployeeCheckIn);
if (!bAssign)
{
var msg = "分配房间失败，请重新分配";
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + msg + "')", true);
return;
}
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('分配成功！')", true);
ClearControl();
if (drEmp["Phone"].ToString() != "")
{
string sContent = drEmp["EmployeeID"].ToString() + "亲，以下是你被分配的宿舍信息：" + sDormAreaName + "宿舍 " + sBuildingName + "栋 " + sRoomName + "房间 " + sBedName + "床. 该宿舍的服务热线18926980019,请于3天内前往宿舍区办理入住手续，谢谢！ ";
try
{
//SendSMS(drEmp["Phone"].ToString(), sContent);
}
catch
{
return;
}
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('招聘系统找不到此用户！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('" + ex.Message + "')", true);
}
finally
{
ClearWorkIDInput();
}
}
