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(); } }