/// <summary> /// 获取员工列表数据 /// </summary> /// <returns></returns> public string GetEmpList() { string limit = System.Web.HttpContext.Current.Request.Params["limit"]; string page = System.Web.HttpContext.Current.Request.Params["page"]; string sqlFilter = System.Web.HttpContext.Current.Request.Params["sqlfilter"]; //组件定义时传入的默认查询串 string searchTxt = System.Web.HttpContext.Current.Request.Params["searchtxt"]; //输入的查询串 string empstatus = System.Web.HttpContext.Current.Request.Params["empstatus"]; //员工状态 string emptype = System.Web.HttpContext.Current.Request.Params["emptype"]; //员工类型 string partMark = System.Web.HttpContext.Current.Request.Params["partmark"]; //显示兼职 string proyMark = System.Web.HttpContext.Current.Request.Params["proymark"]; //显示代理 string oCode = System.Web.HttpContext.Current.Request.Params["ocode"]; //当前节点 string leaf = System.Web.HttpContext.Current.Request.Params["leaf"]; //是否叶子节点 string relatIndex = System.Web.HttpContext.Current.Request.Params["relatindex"]; //节点关系索引 string and = " and ", assigntypeFilter = "assigntype is null or assigntype='0'"; if (string.IsNullOrEmpty(sqlFilter)) { and = ""; sqlFilter = ""; } if (!string.IsNullOrEmpty(searchTxt)) //查询串 { sqlFilter += and + searchTxt; and = " and "; } if (!string.IsNullOrEmpty(empstatus)) { sqlFilter += and + string.Format("hr_epm_main.empstatus='{0}'", empstatus); //员工状态 and = " and "; } if (!string.IsNullOrEmpty(emptype)) { sqlFilter += and + string.Format("hr_epm_main.emptype='{0}'", emptype); //员工类型 and = " and "; } if (!string.IsNullOrEmpty(partMark)) //显示兼职 { assigntypeFilter += " or assigntype='1'"; } if (!string.IsNullOrEmpty(proyMark)) //显示代理 { assigntypeFilter += " or assigntype='2'"; } sqlFilter += and + "(" + assigntypeFilter + ")"; int totalRecord = 0, pageSize = 20, pageIndex = 0; int.TryParse(limit, out pageSize); int.TryParse(page, out pageIndex); DataTable tmpDT = proxy.GetEmpList(sqlFilter, pageSize, pageIndex, ref totalRecord, oCode, leaf == "true", relatIndex); string str = DataConverterHelper.ToJson(tmpDT, totalRecord); return(str); }