public void InitSearchConditionView(bool isPostBack) { if (!isPostBack) { List <SearchField> SearchFieldList = _IEmployeeAdvanceSearchListView.SearchFieldSourceCookie; if (SearchFieldList.Count == 0) { SearchFieldList = EmployeeFieldPara.InitialConditionList(); } SearchFieldList.Add(SearchField.InitField_Null()); _IEmployeeAdvanceSearchListView.SearchFieldConditionSource = SearchFieldList; _IEmployeeAdvanceSearchListView.SearchFieldHiddenValue = EmployeeFieldPara.GetAllEmployeeSearchField(); List <SearchField> colshowlist = new List <SearchField>(); if (!string.IsNullOrEmpty(_IEmployeeAdvanceSearchListView.SearchFieldColShowCookie)) { string[] colshowcookies = _IEmployeeAdvanceSearchListView.SearchFieldColShowCookie.Split('|'); foreach (string colindex in colshowcookies) { int temp; if (!string.IsNullOrEmpty(colindex) && int.TryParse(colindex, out temp)) { colshowlist.Add(EmployeeFieldPara.GetAllEmployeeSearchField()[temp]); } } _IEmployeeAdvanceSearchListView.InitCheckedBoxCol = colshowlist; } if (colshowlist.Count == 0) { _IEmployeeAdvanceSearchListView.InitCheckedBoxCol = EmployeeFieldPara.InitialColList(); } _IEmployeeAdvanceSearchListView.SearchFieldCheckBoxCol = EmployeeFieldPara.GetAllEmployeeSearchField(); } }
private void Search() { List <SearchField> searchFieldList = new List <SearchField>(); if (Request.QueryString["condition"] != null) { searchFieldList = ModelAdvanceSearch.Utility.ConvertStringToSearchFieldList(Request.QueryString["condition"], EmployeeFieldPara.GetAllEmployeeSearchField()); ; } string si = "{}", se = "{}"; try { Account account = Session[SessionKeys.LOGININFO] as Account; List <Employee> resultList = InstanceFactory.CreateAdvanceSearchFacade().AdvanceSearchEmployeeFacade(searchFieldList, account); si = JsonConvert.SerializeObject(EmployeeStringValue.Turn(resultList)); si = si.Replace("null", "\"\""); Session["AdvanceSearchEmployeeColShow"] = Request.QueryString["colshow"]; Session["AdvanceSearchEmployeeCondition"] = Request.QueryString["condition"]; Session["AdvanceSearchEmployeeResult"] = resultList; } catch (Exception ex) { List <SEPPerformance.Error> error = new List <SEPPerformance.Error>(); error.Add(new SEPPerformance.Error("doorcardErrorMessage", ex.Message)); se = JsonConvert.SerializeObject(error); } Response.Write(string.Format("{{itemList:{0},error:{1}}}", si, se)); Response.End(); }
private void BindSearchFieldInfo(string q) { string result = String.Empty; List <SearchField> allSearchFields = EmployeeFieldPara.GetAllEmployeeSearchField(); foreach (SearchField item in allSearchFields) { bool isCompareSuccess = false; foreach (string abbreviation in item.FieldParaBase.Abbreviations) { if (abbreviation.StartsWith(q)) { isCompareSuccess = true; break; } } if (isCompareSuccess) { result += string.IsNullOrEmpty(result) ? item.FieldParaBase.FieldName : "\n" + item.FieldParaBase.FieldName; } } Response.Write(result); }
protected override void DoOrCompare() { for (int i = 0; i < _EmployeeList.Count; i++) { bool isNeedOne = false; bool isExistOr = false; foreach (SearchField item in _SearchFieldList) { if (item.ConditionField.EnumCollectedType != EnumCollectedType.Or) { continue; } isExistOr = true; isNeedOne = EmployeeFieldPara.IsNeedCondition(item, _EmployeeList[i]); if (isNeedOne) { break; } } if (isExistOr && !isNeedOne) { _EmployeeList.RemoveAt(i); i--; } } }
private static SearchField GetSearchFieldObjectEvent(string fieldName) { SearchField retSearchField = SearchField.GetFieldParaByFieldName(EmployeeFieldPara.GetAllEmployeeSearchField(), fieldName); if (retSearchField == null) { return(SearchField.InitField_Null()); } return(retSearchField); }
private void Init_PartSearchFieldList() { _EmployeeBasicInfoSearchFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.EmployeeBasicInfoPart); _EmployeeWelfareSearchFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.EmployeeWelfarePart); _CountryNationalitySearchFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.CountryNationalityPart); _DiyProcessSearchFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.DiyProcessPart); _VacationSearchFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.VacationPart); _AdjustSearchFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.AdjustPart); _SkillFieldList = EmployeeFieldPara.GetPartSearchFieldList(_SearchFieldList, EmployeeFieldPara.SkillPart); }
private void ExportToExcel(_Worksheet excelSheet) { List <Employee> resultList = new List <Employee>(); if (Session["AdvanceSearchEmployeeResult"] != null) { resultList = Session["AdvanceSearchEmployeeResult"] as List <Employee>; } //二维数组定义是多一个标题行。 int rowcount = resultList.Count; List <SearchField> employeeFieldParaList = EmployeeFieldPara.GetAllEmployeeSearchField(); int colcount = employeeFieldParaList.Count; object[,] dataArray = new object[rowcount + 1, colcount]; string[] colshows = Request.QueryString["colshow"] != null ? Request.QueryString["colshow"].Split('|') : null; int colIndex = 0; for (int j = 0; j < employeeFieldParaList.Count; j++) { if (colshows != null) { foreach (string s in colshows) { if (s == j.ToString()) { dataArray[0, colIndex] = employeeFieldParaList[j].FieldParaBase.FieldName; for (int i = 1; i < rowcount + 1; i++) { dataArray[i, colIndex] = "'" + EmployeeFieldPara.GetSearchFieldValue(resultList[i - 1], employeeFieldParaList[j]); } colIndex++; break; } } } } excelSheet.get_Range("A1", excelSheet.Cells[rowcount + 1, colcount]).Value2 = dataArray; }
protected override void DoAndCompare() { for (int i = 0; i < _EmployeeList.Count; i++) { foreach (SearchField item in _SearchFieldList) { if (item.ConditionField.EnumCollectedType != EnumCollectedType.And) { continue; } bool isNeed = EmployeeFieldPara.IsNeedCondition(item, _EmployeeList[i]); if (!isNeed) { _EmployeeList.RemoveAt(i); i--; break; } } } }
/// <summary> /// 比对标签中的字符串返回SearchField /// </summary> /// <param name="fieldNamecondition"></param> /// <returns></returns> private static SearchField ConvertStringToSearchField(string fieldNamecondition) { List <SearchField> searchFieldSource = EmployeeFieldPara.GetAllEmployeeSearchField(); searchFieldSource.Add(EmployeeFieldPara.InitEmployeeSearchField_Responsibility()); searchFieldSource.Add(EmployeeFieldPara.InitEmployeeSearchField_EmployeeWelfareDescription()); if (searchFieldSource == null) { searchFieldSource = new List <SearchField>(); } if (!string.IsNullOrEmpty(fieldNamecondition)) { foreach (SearchField item in searchFieldSource) { if (fieldNamecondition.Contains(item.FieldParaBase.FieldName)) { return(item); } } } return(null); }
/// <summary> /// 初始化标签 /// </summary> /// <param name="fieldNamecondition"></param> /// <param name="employee"></param> /// <returns></returns> public static string InitBookMarkValue(string fieldNamecondition, Employee employee) { return (EmployeeFieldPara.GetSearchFieldValue(employee, ConvertStringToSearchField(fieldNamecondition)) ?? string.Empty); }