/// <summary> /// 导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, EventArgs e) { TB_AllowanceApply mTB_AllowanceApply = new TB_AllowanceApply(); TB_AllowanceApplyBLL mTB_AllowanceApplyBLL = new TB_AllowanceApplyBLL(); mTB_AllowanceApply.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_AllowanceApply.Name = ""; mTB_AllowanceApply.CardNo = this.txtScanCardNO.Text.Trim(); mTB_AllowanceApply.EmployeeNo = this.txtWorkDayNo.Text.Trim(); mTB_AllowanceApply.BU = this.txtBu.Text.Trim(); DateTime dtCheckOut = DateTime.Now; if (DateTime.TryParse(this.txtHireDate.Text.Trim(), out dtCheckOut)) { mTB_AllowanceApply.Hire_Date = dtCheckOut; } dtCheckOut = DateTime.Now; if (DateTime.TryParse(this.txtEffectiveDate.Text.Trim(), out dtCheckOut)) { mTB_AllowanceApply.Effective_Date = dtCheckOut; } if (ddlEmpType.SelectedIndex > 0) { mTB_AllowanceApply.EmployeeTypeName = ddlEmpType.SelectedItem.Text; } string strFileName = mTB_AllowanceApplyBLL.Export(mTB_AllowanceApply); this.DownLoadFile(this.Request, this.Response, "住房津申请记录.xls", File.ReadAllBytes(strFileName), 10240000); //File.Delete(strFileName); }
/// <summary> /// 下拉框绑定 /// </summary> private void ddlBind() { TB_AllowanceApply mTB_AllowanceApply = new TB_AllowanceApply(); TB_AllowanceApplyBLL mTB_AllowanceApplyBLL = new TB_AllowanceApplyBLL(); #region 宿舍区 this.ddlEmpType.DataValueField = "EmployeeTypeName"; this.ddlEmpType.DataTextField = "EmployeeTypeName"; this.ddlEmpType.DataSource = mTB_AllowanceApplyBLL.GetAllEmployeeTypes(); this.ddlEmpType.DataBind(); this.ddlEmpType.Items.Insert(0, new ListItem() { Value = "0", Text = "--请选择--" }); #endregion }
private int GetAllowanceApply(string EmployeeID) { TB_AllowanceApply mTB_AllowanceApply = new TB_AllowanceApply(); TB_AllowanceApplyBLL mTB_AllowanceApplyBLL = new TB_AllowanceApplyBLL(); Pager pager = new Pager(); DataTable dtSource = null; pager.CurrentPageIndex = 1; pager.srcOrder = " ID desc"; mTB_AllowanceApply.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_AllowanceApply.EmployeeNo = EmployeeID; mTB_AllowanceApply.Name = ""; mTB_AllowanceApply.CardNo = ""; dtSource = mTB_AllowanceApplyBLL.GetTable(mTB_AllowanceApply, ref pager); return(Convert.ToInt32(dtSource.Rows[0]["ID"])); }
public bool CheckAllowanceApply(string EmployeeNo) { DataTable dt1 = new TB_AllowanceApplyBLL().GetTableByEmployeeNo(EmployeeNo); DataTable dt2 = new TB_AllowanceApplyCancelBLL().GetTableByEmployeeNo(EmployeeNo); if (dt1.Rows.Count == 0) { return(false); } else if (dt1.Rows.Count > 0 && dt2.Rows.Count == 0) { return(true); } else if (dt1.Rows.Count > 0 && dt2.Rows.Count > 0) { return(false); } return(false); }
/// <summary> /// 导入 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnImport_Click(object sender, EventArgs e) { string strFilePath = ViewState["FilePath"] as String; if (string.IsNullOrEmpty(strFilePath)) { ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "Error", "alert('请先上传需要导入的文件!')", true); return; } try { //导入 TB_AllowanceApplyBLL mTB_AllowanceApplyBLL = new TB_AllowanceApplyBLL(); DataTable dtError = mTB_AllowanceApplyBLL.Import(strFilePath); this.Bind(1); if (dtError.Rows.Count <= 0) { ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "Success", "alert('导入成功!')", true); } else { //string strFileName = Path.Combine(Server.MapPath("..\\..\\"), "report", DateTime.Now.ToString("yyMMddHHmmssms_") + "导入失败记录.xls"); //new ExcelHelper().RenderToExcel(dtError, strFileName); //this.DownLoadFile(this.Request, this.Response, "导入失败记录.xls", File.ReadAllBytes(strFileName), 10240000); //File.Delete(strFileName); //Cache mCache = new Cache(this.UserInfo == null ? this.SystemAdminInfo.Account : this.UserInfo.ADAccount, (this.UserInfo == null ? this.SystemAdminInfo.SiteID : this.UserInfo.SiteID) + "dtError"); //mCache.SetCache(dtError); SessionHelper.Set(HttpContext.Current, TypeManager.SESSIONKEY_ImpErrAllowanceApply, dtError); ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "myScript", "importComplete();", true); ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "Success", "alert('部分导入成功,导入失败记录见文件')", true); } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "Error", "alert('导入失败!" + ex.Message + "')", true); } finally { ViewState["FilePath"] = null; } }
private void Bind(int intCurrentIndex) { TB_AllowanceApply mTB_AllowanceApply = new TB_AllowanceApply(); TB_AllowanceApplyBLL mTB_AllowanceApplyBLL = new TB_AllowanceApplyBLL(); Pager pager = new Pager(); pager.CurrentPageIndex = intCurrentIndex; pager.srcOrder = " ID desc"; mTB_AllowanceApply.Name = ""; mTB_AllowanceApply.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); mTB_AllowanceApply.CardNo = this.txtScanCardNO.Text.Trim(); mTB_AllowanceApply.EmployeeNo = this.txtWorkDayNo.Text.Trim(); mTB_AllowanceApply.BU = this.txtBu.Text.Trim(); DateTime dtCheckOut = DateTime.Now; if (DateTime.TryParse(this.txtHireDate.Text.Trim(), out dtCheckOut)) { mTB_AllowanceApply.Hire_Date = dtCheckOut; } dtCheckOut = DateTime.Now; if (DateTime.TryParse(this.txtEffectiveDate.Text.Trim(), out dtCheckOut)) { mTB_AllowanceApply.Effective_Date = dtCheckOut; } if (ddlEmpType.SelectedIndex > 0) { mTB_AllowanceApply.EmployeeTypeName = ddlEmpType.SelectedItem.Text; } DataTable dt = mTB_AllowanceApplyBLL.GetTable(mTB_AllowanceApply, ref pager); GridView1.DataSource = dt; 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 dtEmployeeInfo = new StaffingBLL().GetTableWithIDL(sWorkDayNO, sIdCard); TB_AllowanceApplyCancelBLL bll = new TB_AllowanceApplyCancelBLL(); if (!DataTableHelper.IsEmptyDataTable(dtEmployeeInfo)) { //检查是否已经申请津贴 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 = new TB_AllowanceApplyBLL().GetTableByID(tb_AllowanceApply, ref pager); if (dt.Rows.Count == 0) { ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户未申请过住房津贴,不能申请取消津贴')", true); return; } //检查是否已经申请津贴 TB_AllowanceApplyCancel tb_AllowanceApplyCancel = new TB_AllowanceApplyCancel(); tb_AllowanceApplyCancel.EmployeeNo = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString(); tb_AllowanceApplyCancel.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); DataTable dt1 = bll.GetTableByID(tb_AllowanceApplyCancel, ref pager); if (dt1.Rows.Count > 0) { ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "msg", "alert('此用户已经申请过取消住房津贴,不能重复申请')", true); return; } //检查是否已经有CheckIn的记录 TB_AllowanceApplyCancel tB_AllowanceApplyCancel = new TB_AllowanceApplyCancel(); tB_AllowanceApplyCancel.EmployeeNo = dtEmployeeInfo.Rows[0]["EmployeeID"].ToString(); tB_AllowanceApplyCancel.Name = dtEmployeeInfo.Rows[0]["ChineseName"].ToString(); tB_AllowanceApplyCancel.CardNo = sIdCard; tB_AllowanceApplyCancel.Sex = dtEmployeeInfo.Rows[0]["Sex"].ToString(); tB_AllowanceApplyCancel.Company = ""; tB_AllowanceApplyCancel.BU = dtEmployeeInfo.Rows[0]["SegmentName"].ToString(); tB_AllowanceApplyCancel.Grade = 0; tB_AllowanceApplyCancel.AlloWanceApplyID = GetAllowanceApply(tB_AllowanceApplyCancel.EmployeeNo); tB_AllowanceApplyCancel.EmployeeTypeName = dtEmployeeInfo.Rows[0]["EmployeeTypeName"].ToString(); tB_AllowanceApplyCancel.CreateUser = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount); tB_AllowanceApplyCancel.CreateDate = System.DateTime.Now; tB_AllowanceApplyCancel.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID); tB_AllowanceApplyCancel.Hire_Date = Convert.ToDateTime(dtEmployeeInfo.Rows[0]["Hire_Date"]); tB_AllowanceApplyCancel.Effective_Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); bll.ADDAllowanceCancelApply(tB_AllowanceApplyCancel); 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(); } }