/// <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>
/// get all configutaion entity list
/// </summary>
/// <param name="isLogGet"></param>
/// <param name="defaultNullValue"></param>
/// <returns></returns>
public List <ConfigurationSettingDataTbl> CSDTblsGetAll(bool isLogGet = false, string defaultNullValue = null)
{
string tblName = (isLogGet) ? ConfigSettingHelper.ConfigLogTableNameGet(this.ConfigurationType) : ConfigSettingHelper.ConfigTableNameGet(this.ConfigurationType);
string query = string.Format("select * from {0}", tblName);
return(CSDTblsGet(query, this.ConnectionString, ConfigurationIDNameGet(isLogGet), defaultNullValue));
}