public static List <T> Select <T>(int ID, bool random)
{
List <T> List = new List <T>();
try
{
string query = "";
string TableName = typeof(T).Name;
if (ID == 0)
{
if (random)
{
query = "select * from " + TableName + " ORDER BY NEWID()";
}
else
{
query = "select * from " + TableName;
}
}
else
{
query = "declare @columnName nvarchar(MAX) declare @query nvarchar(MAX)set @columnName=(SELECT Top(1)[name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = 'U' AND [Name] = '" + TableName + "')) exec( 'select * from " + TableName + " where ' + @columnName + '= " + ID + "')";
}
DataTable dt = DatatableData(query);
List = DataClasses.DtFilltoList <T>(dt);
}
catch (Exception)
{
}
return(List);
}
public static List <T> SelectWhere <T>(T item)
{
string TableName = item.GetType().Name;
List <T> List = new List <T>();
OrderedDictionary objList = fillPorperties(item);
object[] myValues = new object[objList.Count];
String[] myKeys = new String[objList.Count];
objList.Values.CopyTo(myValues, 0);
objList.Keys.CopyTo(myKeys, 0);
string command = string.Empty;
for (int i = 0; i < objList.Count; i++)
{
string qq = "";
if (myValues[i].GetType() == typeof(string))
{
qq = "=@" + myKeys[i] + "";
}
else if (myValues[i].GetType() == typeof(int))
{
qq = "=@" + myKeys[i];
}
else if (myValues[i].GetType() == typeof(bool))
{
qq = "=@" + myKeys[i];
}
else if (myValues[i].GetType() == typeof(DateTime))
{
qq = "=@" + myKeys[i] + "";
}
command += "" + myKeys[i] + " " + qq + " and ";
}
command += "1=1";
string query = "select * from " + TableName + " where ";
query = query + " " + command;
tools t = new tools(MyConn);
t.Baglanti_Ac();
SqlCommand cmd = new SqlCommand(query, t.cnn);
for (int i = 0; i < objList.Count; i++)
{
cmd.Parameters.AddWithValue("@" + myKeys[i], myValues[i]);
}
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = cmd;
DataTable dt = new DataTable();
adp.Fill(dt);
t.Baglanti_Kapat(cmd);
List = DataClasses.DtFilltoList <T>(dt);
return(List);
}
/// <summary>
/// Tablonun ilk colunu ID olmazk zorundadır.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="rowlimit"></param>
/// <param name="SayfaLinkleri"></param>
/// <returns></returns>
public static List <T> SelectPaging <T>(double rowlimit, out string SayfaLinkleri, out string toplamitem)
{
string TableName = typeof(T).Name;
string clas = "";
List <T> List = new List <T>();
int pageSize = 0;
int.TryParse(HttpContext.Current.Request.QueryString["pager"], out pageSize);
pageSize = pageSize == 0 ? 1 : pageSize;
string query = "declare @columnName nvarchar(100)set @columnName='" + TableName + "'+'.'+(SELECT Top(1)[name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = 'U' AND [Name] = '" + TableName + "'));WITH paging AS (select ROW_NUMBER() over (order by @columnName desc) as Row, * from ( select top(10000)* from " + TableName + " order by ID desc ) as Table1 ) SELECT (select count(*) from paging) TotalCount, * FROM paging WHERE Row between ((" + pageSize + " * " + rowlimit + ") +1- " + rowlimit + ") and (" + pageSize + "* " + rowlimit + ") order by ID desc";
DataTable dt = DatatableData(query);
List <T> ListCount = DataClasses.Select <T>(0);
List = DtFilltoList <T>(dt);
SayfaLinkleri = "";
string sPagePath = System.Web.HttpContext.Current.Request.Url.AbsolutePath;
//System.IO.FileInfo oFileInfo = new System.IO.FileInfo(sPagePath);
string[] dizi = sPagePath.Split('/');
string sPageName = "";
if (dizi.Length > 0)
{
sPageName = dizi[dizi.Length - 1];
}
int page = GetNoPages(ListCount.Count, rowlimit);
toplamitem = ListCount.Count.ToString();
if (page >= 5)
{
int pager = 0;
int.TryParse(HttpContext.Current.Request.QueryString["pager"], out pager);
if (pager > 0)
{
if (pager >= 5)
{
if (pager >= (page - 5))
{
if (pager >= page)
{
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + 1 + "')\" class='" + clas + "'><<</a>";
for (int i = (pager - 5); i <= pager; i++)
{
clas = HttpContext.Current.Request.QueryString["pager"] != null && HttpContext.Current.Request.QueryString["pager"] == i.ToString() ? "aktif_page" : "pasif_page";
if (HttpContext.Current.Request.QueryString["pager"] == null)
{
if (i == 1)
{
clas = "aktif_page";
}
}
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + i + "')\" class='" + clas + "'>" + i + "</a>";
}
}
else
{
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + 1 + "')\" class='" + clas + "'><<</a>";
for (int i = (pager - 4); i <= pager; i++)
{
clas = HttpContext.Current.Request.QueryString["pager"] != null && HttpContext.Current.Request.QueryString["pager"] == i.ToString() ? "aktif_page" : "pasif_page";
if (HttpContext.Current.Request.QueryString["pager"] == null)
{
if (i == 1)
{
clas = "aktif_page";
}
}
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + i + "')\" class='" + clas + "'>" + i + "</a>";
}
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + page + "')\" class='pasif_page'>>></a>";
}
}
else
{
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + 1 + "')\" class='" + clas + "'><<</a>";
for (int i = (pager - 2); i <= (pager + 2); i++)
{
clas = HttpContext.Current.Request.QueryString["pager"] != null && HttpContext.Current.Request.QueryString["pager"] == i.ToString() ? "aktif_page" : "pasif_page";
if (HttpContext.Current.Request.QueryString["pager"] == null)
{
if (i == 1)
{
clas = "aktif_page";
}
}
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + i + "')\" class='" + clas + "'>" + i + "</a>";
}
SayfaLinkleri += "<a>...</a><a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + page + "')\" class='" + clas + "'>>></a>";
}
}
else
{
for (int i = 1; i <= 5; i++)
{
clas = HttpContext.Current.Request.QueryString["pager"] != null && HttpContext.Current.Request.QueryString["pager"] == i.ToString() ? "aktif_page" : "pasif_page";
if (HttpContext.Current.Request.QueryString["pager"] == null)
{
if (i == 1)
{
clas = "aktif_page";
}
}
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + i + "')\" class='" + clas + "'>" + i + "</a>";
}
SayfaLinkleri += "<a>...</a><a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + page + "')\" class='" + clas + "'>>></a>";
}
}
}
else
{
for (int i = 1; i <= page; i++)
{
clas = HttpContext.Current.Request.QueryString["pager"] != null && HttpContext.Current.Request.QueryString["pager"] == i.ToString() ? "aktif_page" : "pasif_page";
if (HttpContext.Current.Request.QueryString["pager"] == null)
{
if (i == 1)
{
clas = "aktif_page";
}
}
SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + i + "')\" class='" + clas + "'>" + i + "</a>";
}
}
//for (int i = 1; i < page; i++)
//{
// clas = HttpContext.Current.Request.QueryString["pager"] != null && HttpContext.Current.Request.QueryString["pager"] == i.ToString() ? "aktif_page" : "pasif_page";
// if (HttpContext.Current.Request.QueryString["pager"] == null)
// {
// if (i == 1)
// clas = "aktif_page";
// }
// SayfaLinkleri += "<a href='javascript:;' onclick=\"getList('" + sPageName + "?pager=" + i + "')\" class='" + clas + "'>" + i + "</a>";
//}
return(List);
}
