/// <summary> /// get query script /// </summary> /// <param name="config"></param> /// <param name="configType"></param> /// <param name="isLogGet"></param> /// <param name="topCount"></param> /// <param name="sortdirection"></param> /// <returns></returns> public static string TBLQueryGet(ConfigurationSettingDataTbl config , ConfigSettingType configType , bool isLogGet , int topCount = 0 , CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None) { string topStr = string.Empty; if (topCount > 0) { topStr = "top " + topCount; } string orderBy = string.Empty; if (sortdirection == CommonEnum.SortDirection.ASC) { orderBy = "order by 1 asc"; } else if (sortdirection == CommonEnum.SortDirection.DESC) { orderBy = "order by 1 desc"; } string tblName = (isLogGet) ? ConfigSettingHelper.ConfigLogTableNameGet(configType) : ConfigSettingHelper.ConfigTableNameGet(configType); string where = TBLQueryGetWhere(config, configType); return(string.Format("select {0} * from {1} {2} {3} ", topStr, tblName, where, orderBy)); }
/// <summary> /// error map script get /// </summary> /// <param name="searchTbl"></param> /// <param name="isLogGet"></param> /// <param name="topCount"></param> /// <param name="sortdirection"></param> /// <returns></returns> public static string TBLQueryGet(ErrorMapConfigTbl searchTbl, bool isLogGet = false , int topCount = 0 , CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None) { string topStr = string.Empty; if (topCount > 0) { topStr = "top " + topCount; } string orderBy = string.Empty; if (sortdirection == CommonEnum.SortDirection.ASC) { orderBy = "order by 1 asc"; } else if (sortdirection == CommonEnum.SortDirection.DESC) { orderBy = "order by 1 desc"; } return(string.Format("select {0} * from {1} where 1=1 {2} {3} {4} {5}" , topStr , (isLogGet ? "ErrorMapLog" : "ErrorMap") , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.messageType, "and MessageType") , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.errorCode, "and errorCode") , CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.textRegex, "and TextRegEx") , orderBy)); }
/// <summary> /// get configutaion entity list /// </summary> /// <param name="sConfig"></param> /// <param name="isLogGet"></param> /// <param name="topCount"></param> /// <param name="sortdirection"></param> /// <param name="defaultNullValue"></param> /// <returns></returns> public List <ConfigurationSettingDataTbl> CSDTblsGet(SupplierConfiguration sConfig , bool isLogGet = false , int topCount = 0 , CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None , string defaultNullValue = null) { ConfigurationSettingDataTbl config = ConvertToConfigurationSettingDataTbl(sConfig); return(CSDTblsGet(config, isLogGet, topCount, sortdirection, defaultNullValue)); }
/// <summary> /// get error map logs /// </summary> /// <param name="messageType"></param> /// <param name="errorCode"></param> /// <param name="textRegex"></param> /// <param name="topCount"></param> /// <param name="sortdirection"></param> /// <returns></returns> public List <ErrorMapConfigLogTbl> ErrorMapConfigLogGet(string messageType = null, string errorCode = null, string textRegex = null , int topCount = 0 , CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.DESC) { ErrorMapConfigTbl searchTbl = TBLEntityGet(messageType, errorCode, textRegex); string query = TBLQueryGet(searchTbl, true, topCount, sortdirection); List <ErrorMapConfigLogTbl> logTbl = ErrorMapLogTblGet(query, this.ConnectionString); return(logTbl); }
/// <summary> /// get configutaion entity list /// </summary> /// <param name="config"></param> /// <param name="isLogGet"></param> /// <param name="topCount"></param> /// <param name="sortdirection"></param> /// <param name="defaultNullValue"></param> /// <returns></returns> public List <ConfigurationSettingDataTbl> CSDTblsGet(ConfigurationSettingDataTbl config , bool isLogGet = false , int topCount = 0 , CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None , string defaultNullValue = null) { List <ConfigurationSettingDataTbl> tbls = CSDTblsGet( TBLQueryGet(config, this.ConfigurationType, isLogGet, topCount, sortdirection) , this.ConnectionString , ConfigurationIDNameGet(isLogGet) , defaultNullValue); return(tbls); }