/// <summary> /// 根据条件,获取T_FB_SYSTEMSETTINGS信息 /// </summary> /// <param name="strVacName"></param> /// <param name="strVacYear"></param> /// <param name="strCountyType"></param> /// <param name="strSortKey"></param> /// <returns></returns> public static IQueryable <T_FB_SYSTEMSETTINGS> GetAllSystemSettingsRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey) { SystemSettingsDAL dalSystemSettings = new SystemSettingsDAL(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " SYSTEMSETTINGSID "; } var q = dalSystemSettings.GetSystemSettingsRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray()); return(q); }
/// <summary> /// 检查当前月,是否已进行月结 /// </summary> /// <param name="bIsChecked"></param> private void IsCheckedAccount(ref bool bIsChecked) { SystemSettingsDAL dalSystemSetting = new SystemSettingsDAL(); T_FB_SYSTEMSETTINGS entRd = dalSystemSetting.GetObjects().FirstOrDefault(); if (entRd == null) { return; } if (entRd.LASTCHECKDATE != null) { var checkDate = entRd.LASTCHECKDATE.Value; var nowDate = System.DateTime.Now.Date; if (checkDate.Year == nowDate.Year && checkDate.Month == nowDate.Month) { bIsChecked = true; } } }
/// <summary> /// 获取T_FB_SYSTEMSETTINGS信息 /// </summary> /// <param name="strSystemSettingsId">主键索引</param> /// <returns></returns> public T_FB_SYSTEMSETTINGS GetSystemSettingsByID(string strSystemSettingsId) { if (string.IsNullOrEmpty(strSystemSettingsId)) { return(null); } SystemSettingsDAL dalSystemSettings = new SystemSettingsDAL(); StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); if (!string.IsNullOrEmpty(strSystemSettingsId)) { strFilter.Append(" SYSTEMSETTINGSID == @0"); objArgs.Add(strSystemSettingsId); } T_FB_SYSTEMSETTINGS entRd = dalSystemSettings.GetSystemSettingsRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); return(entRd); }