/// <summary> /// 获取合同信息集合 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="CompanyId">公司编号</param> /// <param name="SearchInfo">合同管理查询实体</param> /// <returns></returns> public IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, EyouSoft.Model.AdminCenterStructure.ContractSearchInfo SearchInfo) { return(idal.GetList(PageSize, PageIndex, ref RecordCount, CompanyId, SearchInfo)); }
protected void Page_Load(object sender, EventArgs e) { PageIndex = Utils.GetInt(Request.QueryString["Page"], 1); string method = Utils.GetQueryStringValue("Method"); int WorkerID = Utils.GetInt(Request.QueryString["WorkerID"], -1); if (!IsPostBack && method == "") //查询 { if (CheckGrant(global::Common.Enum.TravelPermission.行政中心_劳动合同管理_修改合同)) { EditFlag = true; } if (CheckGrant(global::Common.Enum.TravelPermission.行政中心_劳动合同管理_删除合同)) { DeleteFlag = true; } string WorkerNo = Utils.GetQueryStringValue("WorkerNo"); string WorkerName = Utils.GetQueryStringValue("WorkerName"); DateTime?TimeOfSigningStart = Utils.GetDateTimeNullable(Request.QueryString["TimeOfSigningStart"]); DateTime?TimeOfSigningEnd = Utils.GetDateTimeNullable(Request.QueryString["TimeOfSigningEnd"]); DateTime?ComeDueStart = Utils.GetDateTimeNullable(Request.QueryString["ComeDueStart"]); DateTime?ComeDueEnd = Utils.GetDateTimeNullable(Request.QueryString["ComeDueEnd"]); EyouSoft.BLL.AdminCenterStructure.ContractInfo bllContractInfo = new EyouSoft.BLL.AdminCenterStructure.ContractInfo(); EyouSoft.Model.AdminCenterStructure.ContractSearchInfo searchInfo = new EyouSoft.Model.AdminCenterStructure.ContractSearchInfo(); searchInfo.StaffNo = WorkerNo; searchInfo.StaffName = WorkerName; searchInfo.BeginFrom = TimeOfSigningStart; searchInfo.BeginTo = TimeOfSigningEnd; searchInfo.EndFrom = ComeDueStart; searchInfo.EndTo = ComeDueEnd; IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> listContractInfo = bllContractInfo.GetList(PageSize, PageIndex, ref RecordCount, CurrentUserCompanyID, searchInfo); if (listContractInfo != null && listContractInfo.Count > 0) { this.crptContractList.DataSource = listContractInfo; this.crptContractList.DataBind(); BindPage(); } else { this.crptContractList.EmptyText = "<tr><td colspan=\"8\"><div style=\"text-align:center; margin-top:75px; margin-bottom:75px;\">没有相关的数据!</span></div></td></tr>"; this.ExporPageInfoSelect1.Visible = false; } } if (method == "DeleteContract" && WorkerID != -1) //删除 { if (!CheckGrant(global::Common.Enum.TravelPermission.行政中心_劳动合同管理_删除合同)) //删除权限判断 { Response.Clear(); Response.Write("NoPermission"); Response.End(); } else { EyouSoft.BLL.AdminCenterStructure.ContractInfo bllContractInfo = new EyouSoft.BLL.AdminCenterStructure.ContractInfo(); if (bllContractInfo.Delete(CurrentUserCompanyID, WorkerID)) { Response.Clear(); Response.Write("True"); Response.End(); } else { Response.Clear(); Response.Write("False"); Response.End(); } } } }
/// <summary> /// 获取合同信息集合 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="CompanyId">公司编号</param> /// <param name="SearchInfo">合同管理查询实体</param> /// <returns></returns> public IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, EyouSoft.Model.AdminCenterStructure.ContractSearchInfo SearchInfo) { IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> ResultList = null; string tableName = "tbl_ContractInfo"; string identityColumnName = "Id"; string fields = " [Id],[StaffNo],[StaffName],[BeginDate],[EndDate],[ContractStatus],[Remark] "; string query = string.Format("[CompanyId]={0}", CompanyId); if (!string.IsNullOrEmpty(SearchInfo.StaffNo)) { query = query + string.Format("AND StaffNo LIKE '%{0}%' ", SearchInfo.StaffNo); } if (!string.IsNullOrEmpty(SearchInfo.StaffName)) { query = query + string.Format("AND StaffName LIKE '%{0}%' ", EyouSoft.Toolkit.Utils.ReplaceXmlSpecialCharacter(SearchInfo.StaffName)); } if (SearchInfo.BeginFrom.HasValue) { query = query + string.Format(" AND DATEDIFF(DAY,'{0}',BeginDate)>=0", SearchInfo.BeginFrom); } if (SearchInfo.BeginTo.HasValue) { query = query + string.Format(" AND DATEDIFF(DAY,BeginDate,'{0}')>=0", SearchInfo.BeginTo); } if (SearchInfo.EndFrom.HasValue) { query = query + string.Format(" AND DATEDIFF(DAY,'{0}',EndDate)>=0", SearchInfo.EndFrom); } if (SearchInfo.EndTo.HasValue) { query = query + string.Format(" AND DATEDIFF(DAY,EndDate,'{0}')>=0", SearchInfo.EndTo); } string orderByString = " IssueTime DESC"; using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <EyouSoft.Model.AdminCenterStructure.ContractInfo>(); while (dr.Read()) { EyouSoft.Model.AdminCenterStructure.ContractInfo model = new EyouSoft.Model.AdminCenterStructure.ContractInfo() { Id = dr.GetInt32(dr.GetOrdinal("Id")), BeginDate = dr.GetDateTime(dr.GetOrdinal("BeginDate")), EndDate = dr.GetDateTime(dr.GetOrdinal("EndDate")), ContractStatus = (EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus)Enum.Parse(typeof(EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus), dr.GetInt32(dr.GetOrdinal("ContractStatus")).ToString()), Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")), StaffName = dr.IsDBNull(dr.GetOrdinal("StaffName")) ? "" : dr.GetString(dr.GetOrdinal("StaffName")), StaffNo = dr.GetString(dr.GetOrdinal("StaffNo")) }; ResultList.Add(model); model = null; } }; return(ResultList); }