//private void ManageExternalResources(string fileName, string culture) //{ // string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; // conStr += Server.MapPath("~/common/db/demo.mdb"); // System.Data.OleDb.OleDbConnection srcDB = new System.Data.OleDb.OleDbConnection(conStr); // srcDB.Open(); // string sql = "Select * From ConceptsReserveFields"; // System.Data.OleDb.OleDbDataAdapter daSrc = new System.Data.OleDb.OleDbDataAdapter(sql, srcDB); // DataTable oTable = new DataTable(); // daSrc.Fill(oTable); // srcDB.Close(); // string filePath = "App_LocalResources\\" + fileName; // ResXResourceReader resxReader = new ResXResourceReader(Server.MapPath(filePath)); // ResXResourceWriter resxWriter = new ResXResourceWriter(Server.MapPath(filePath)); // foreach (DictionaryEntry de in resxReader) // { // string key = de.Key.ToString().Replace(".HeadingText", string.Empty); // DataRow[] RowCol = (oTable.Select("OriginalName='" + key + "'")); // if (RowCol.Length == 0) // resxWriter.AddResource(de.Key.ToString(), de.Value.ToString()); // } // foreach (DataRow dr in oTable.Rows) // { // string NewValue = string.Empty; // switch (culture) // { // case "fa-IR": // NewValue = dr["Fa_Name"].ToString(); // break; // case "en-US": // NewValue = dr["En_Name"].ToString(); // break; // } // resxWriter.AddResource(dr["OriginalName"].ToString() + ".HeadingText", NewValue); // } // resxReader.Close(); // resxWriter.Generate(); // resxWriter.Close(); //} private void Fill_GridSummaryMonthlyOperation_ManagerMasterMonthlyOperation(LoadState Ls, decimal departmentID, int pageSize, int pageIndex, GridOrderFields Gof, GridOrderFieldType Goft, GridSearchFields Gsf, string SearchTerm, int Month) { IList <UnderManagementPerson> UnderManagementPersonnelList = null; this.InitializeCulture(); switch (Ls) { case LoadState.Normal: if (departmentID == 0) { return; } UnderManagementPersonnelList = this.MonthlyOperationBusiness.GetUnderManagmentByDepartment(Month, departmentID, pageIndex, pageSize, Gof, Goft); break; case LoadState.Search: UnderManagementPersonnelList = this.MonthlyOperationBusiness.GetUnderManagmentBySearch(Month, SearchTerm, Gsf, pageIndex, pageSize, Gof, Goft); break; } this.GridMonthlyOperationSummary_ManagerMasterMonthlyOperation.DataSource = UnderManagementPersonnelList; this.GridMonthlyOperationSummary_ManagerMasterMonthlyOperation.DataBind(); }
/// <summary> /// افراد تحت مدیریت را براساس کلمه جستجوشده برمیگرداند /// </summary> /// <param name="searchKey"></param> /// <param name="searchType"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="orderField"></param> /// <param name="orderType"></param> /// <returns></returns> public IList <UnderManagementPerson> GetUnderManagmentBySearch(int month, string searchKey, GridSearchFields searchType, int pageIndex, int pageSize, GridOrderFields orderField, GridOrderFieldType orderType) { try { if (InitManager()) { if (orderField == GridOrderFields.NONE) { orderField = GridOrderFields.gridFields_BarCode; } IList <UnderManagementPerson> Result = new List <UnderManagementPerson>(); if (searchType == GridSearchFields.PersonName) { Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonName, BUser.CurrentUser.Person.ID, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); } else if (searchType == GridSearchFields.PersonCode) { Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonCode, BUser.CurrentUser.Person.ID, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); } else { Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonName, BUser.CurrentUser.Person.ID, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); if (Result == null || Result.Count == 0) { Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.PersonCode, BUser.CurrentUser.Person.ID, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); } } foreach (UnderManagementPerson under in Result) { #region LoadBasicTraffic GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic(); IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now)); int counter = 1; foreach (BasicTrafficProxy trafic in trafficList) { switch (counter) { case 1: under.FirstEntrance = trafic.TheTime; break; case 2: under.FirstExit = trafic.TheTime; break; case 3: under.SecondEntrance = trafic.TheTime; break; case 4: under.SecondExit = trafic.TheTime; break; case 5: under.ThirdEntrance = trafic.TheTime; break; case 6: under.ThirdExit = trafic.TheTime; break; case 7: under.FourthEntrance = trafic.TheTime; break; case 8: under.FourthExit = trafic.TheTime; break; case 9: under.FifthEntrance = trafic.TheTime; break; case 10: under.FifthExit = trafic.TheTime; break; } counter++; } under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : ""; #endregion } return(Result); } else if (InitOperator()) { decimal oprPrsId = BUser.CurrentUser.Person.ID; if (orderField == GridOrderFields.NONE) { orderField = GridOrderFields.gridFields_BarCode; } IList <UnderManagementPerson> Result = new List <UnderManagementPerson>(); if (searchType == GridSearchFields.PersonName) { Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonName, oprPrsId, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); } else if (searchType == GridSearchFields.PersonCode) { Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonCode, oprPrsId, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); } else { Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonName, oprPrsId, 0, searchKey, "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); if (Result == null || Result.Count == 0) { Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.PersonCode, oprPrsId, 0, "", searchKey, month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); } } foreach (UnderManagementPerson under in Result) { #region LoadBasicTraffic GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic(); IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now)); int counter = 1; foreach (BasicTrafficProxy trafic in trafficList) { switch (counter) { case 1: under.FirstEntrance = trafic.TheTime; break; case 2: under.FirstExit = trafic.TheTime; break; case 3: under.SecondEntrance = trafic.TheTime; break; case 4: under.SecondExit = trafic.TheTime; break; case 5: under.ThirdEntrance = trafic.TheTime; break; case 6: under.ThirdExit = trafic.TheTime; break; case 7: under.FourthEntrance = trafic.TheTime; break; case 8: under.FourthExit = trafic.TheTime; break; case 9: under.FifthEntrance = trafic.TheTime; break; case 10: under.FifthExit = trafic.TheTime; break; } counter++; } under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : ""; #endregion } return(Result); } else { throw new IllegalServiceAccess(String.Format("این سرویس تنها توسط مدیران قابل استفاده میباشد. شناسه کاربری {0} میباشد", this.Username), ExceptionSrc); } } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BWorkedTime", "GetUnderManagmentByDepartment"); throw ex; } }
public IList <UnderManagementPerson> GetUnderManagmentOperatorByDepartment(GridSearchFields SearchField, decimal oprPersonId, decimal departmentID, string personName, string personbarCode, int dateRangeOrder, int dateRangeOrderIndex, string CurrentDateTime, GridOrderFields order, GridOrderFieldType orderType, int pageIndex, int pageSize) { string orderingType = orderType.ToString(); string orderingField = order.ToString(); return(NHibernateSession.GetNamedQuery("GetUnderManagementOperatorPersonList") .SetParameter("oprPersonId", oprPersonId) .SetParameter("departmentId", departmentID) .SetParameter("searchField", (int)SearchField) .SetParameter("barcodeParam", personbarCode) .SetParameter("personNameParam", personName) .SetParameter("orderByField", orderingField) .SetParameter("orderType", orderingType) .SetParameter("dateRangeOrder", dateRangeOrder) .SetParameter("dateRangeOrderIndex", dateRangeOrderIndex) .SetParameter("curentDate", CurrentDateTime) .SetParameter("pageSize", pageSize) .SetParameter("pageIndex", pageIndex) .List <UnderManagementPerson>()); }
/// <summary> /// با دریافت یک گره از درخت تحت مدیریت مدیر اشخاص تحت مدیریت را برمیگرداند /// این افراد مرتب شده بر اساس فیلد مشخص شده هستند /// </summary> /// <param name="departmentID"></param> /// <returns></returns> public IList <UnderManagementPerson> GetUnderManagmentByDepartment(int month, decimal departmentID, int pageIndex, int pageSize, GridOrderFields orderField, GridOrderFieldType orderType) { try { int year = 0; if (BLanguage.CurrentSystemLanguage == LanguagesName.Parsi) { year = Utility.ToPersianDateTime(DateTime.Now).Year; if (month <= 0) { month = Utility.ToPersianDateTime(DateTime.Now).Month; } } else { year = DateTime.Now.Year; if (month <= 0) { month = DateTime.Now.Month; } } if (orderField == GridOrderFields.NONE) { orderField = GridOrderFields.gridFields_BarCode; } if (InitManager()) { IList <UnderManagementPerson> Result = managerRepository.GetUnderManagmentByDepartment(GridSearchFields.NONE, BUser.CurrentUser.Person.ID, departmentID, "", "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); foreach (UnderManagementPerson under in Result) { #region LoadBasicTraffic GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic(); IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now)); int counter = 1; foreach (BasicTrafficProxy trafic in trafficList) { switch (counter) { case 1: under.FirstEntrance = trafic.TheTime; break; case 2: under.FirstExit = trafic.TheTime; break; case 3: under.SecondEntrance = trafic.TheTime; break; case 4: under.SecondExit = trafic.TheTime; break; case 5: under.ThirdEntrance = trafic.TheTime; break; case 6: under.ThirdExit = trafic.TheTime; break; case 7: under.FourthEntrance = trafic.TheTime; break; case 8: under.FourthExit = trafic.TheTime; break; case 9: under.FifthEntrance = trafic.TheTime; break; case 10: under.FifthExit = trafic.TheTime; break; } counter++; } under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : ""; #endregion under.RemainLeaveToYearEnd = this.GetReainLeaveToEndOfYear(under.PersonId, year, month); under.RemainLeaveToMonthEnd = this.GetReaiLeaveToEndMonth(under.PersonId, year, month); } return(Result); } else if (InitOperator()) { IList <UnderManagementPerson> Result = managerRepository.GetUnderManagmentOperatorByDepartment(GridSearchFields.NONE, BUser.CurrentUser.Person.ID, departmentID, "", "", month, month > 0 ? 0 : Utility.ToDateRangeIndex(DateTime.Now, sysLanguageResource), DateTime.Now.ToString("yyyy/MM/dd"), orderField, orderType, pageIndex, pageSize); foreach (UnderManagementPerson under in Result) { #region LoadBasicTraffic GTS.Clock.Business.BaseInformation.BTraffic trafficBus = new BaseInformation.BTraffic(); IList <BasicTrafficProxy> trafficList = trafficBus.GetDayTraffics(under.PersonId, Utility.ToString(DateTime.Now)); int counter = 1; foreach (BasicTrafficProxy trafic in trafficList) { switch (counter) { case 1: under.FirstEntrance = trafic.TheTime; break; case 2: under.FirstExit = trafic.TheTime; break; case 3: under.SecondEntrance = trafic.TheTime; break; case 4: under.SecondExit = trafic.TheTime; break; case 5: under.ThirdEntrance = trafic.TheTime; break; case 6: under.ThirdExit = trafic.TheTime; break; case 7: under.FourthEntrance = trafic.TheTime; break; case 8: under.FourthExit = trafic.TheTime; break; case 9: under.FifthEntrance = trafic.TheTime; break; case 10: under.FifthExit = trafic.TheTime; break; } counter++; } under.LastExit = trafficList.LastOrDefault() != null?trafficList.LastOrDefault().TheTime : ""; #endregion under.RemainLeaveToYearEnd = this.GetReainLeaveToEndOfYear(under.PersonId, year, month); under.RemainLeaveToMonthEnd = this.GetReaiLeaveToEndMonth(under.PersonId, year, month); } return(Result); } else { throw new IllegalServiceAccess(String.Format("این سرویس تنها توسط مدیران قابل استفاده میباشد. شناسه کاربری {0} میباشد", this.Username), ExceptionSrc); } } catch (Exception ex) { BaseBusiness <Entity> .LogException(ex, "BWorkedTime", "GetUnderManagmentByDepartment"); throw ex; } }