Asp.Net 通用數據操作類 (附通用數據基類)
更新時間：2008年07月13日 21:52:53 作者：
以前經常用php的數據操作類，這次的asp.net數據操作類，是個方法
/// <summary>
/// 執(zhí)行存儲過程(返回記錄集)
/// </summary>
/// <param name="procName">過程名</param>
/// <param name="hashtable">傳入的參數表</param>
/// <returns>返回記錄集</returns>
public DataSet ExecProcedure(string procName, System.Collections.Hashtable hashtable)
{
System.Data.DataSet ds = new DataSet();
com.CommandText = procName;
com.CommandType = CommandType.StoredProcedure;
System.Collections.IDictionaryEnumerator ide = hashtable.GetEnumerator();
while (ide.MoveNext())
{
System.Data.SqlClient.SqlParameter p = new System.Data.SqlClient.SqlParameter(ide.Key.ToString(), ide.Value);
com.Parameters.Add(p);
}
try
{
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
da.Fill(ds);
da.Dispose();
}
catch (Exception ee)
{
throw new Exception(ee.Message.ToString());
}
finally
{
com.Cancel();
}
return ds;
}
#endregion
#region 數據操作
/// <summary>
/// 統(tǒng)計某表記錄總數
/// </summary>
/// <param name="KeyField">主鍵/索引鍵</param>
/// <param name="TableName">數據庫.用戶名.表名</param>
/// <param name="Condition">查詢條件</param>
/// <returns>返回記錄總數</returns>
public int GetRecordCount(string keyField, string tableName, string condition)
{
int RecordCount = 0;
string sql = "select count(" + keyField + ") as count from " + tableName + " " + condition;
System.Data.DataSet ds = GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
RecordCount =Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
ds.Clear();
ds.Dispose();
return RecordCount;
}
/// <summary>
/// 統(tǒng)計某表記錄總數
/// </summary>
/// <param name="Field">可重復的字段</param>
/// <param name="tableName">數據庫.用戶名.表名</param>
/// <param name="condition">查詢條件</param>
/// <param name="flag">字段是否主鍵</param>
/// <returns>返回記錄總數</returns>
public int GetRecordCount(string Field, string tableName, string condition, bool flag)
{
int RecordCount = 0;
if (flag)
{
RecordCount = GetRecordCount(Field, tableName, condition);
}
else
{
string sql = "select count(distinct(" + Field + ")) as count from " + tableName + " " + condition;
System.Data.DataSet ds = GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
ds.Clear();
ds.Dispose();
}
return RecordCount;
}
/// <summary>
/// 統(tǒng)計某表分頁總數
/// </summary>
/// <param name="keyField">主鍵/索引鍵</param>
/// <param name="tableName">表名</param>
/// <param name="condition">查詢條件</param>
/// <param name="pageSize">頁寬</param>
/// <param name="RecordCount">記錄總數</param>
/// <returns>返回分頁總數</returns>
public int GetPageCount(string keyField, string tableName, string condition, int pageSize, int RecordCount)
{
int PageCount = 0;
PageCount = (RecordCount % pageSize) > 0 ? (RecordCount / pageSize) + 1 : RecordCount / pageSize;
if (PageCount < 1) PageCount = 1;
return PageCount;
}
/// <summary>
/// 統(tǒng)計某表分頁總數
/// </summary>
/// <param name="keyField">主鍵/索引鍵</param>
/// <param name="tableName">表名</param>
/// <param name="condition">查詢條件</param>
/// <param name="pageSize">頁寬</param>
/// <returns>返回頁面總數</returns>
public int GetPageCount(string keyField, string tableName, string condition, int pageSize, ref int RecordCount)
{
RecordCount = GetRecordCount(keyField, tableName, condition);
return GetPageCount(keyField, tableName, condition, pageSize, RecordCount);
}
/// <summary>
/// 統(tǒng)計某表分頁總數
/// </summary>
/// <param name="Field">可重復的字段</param>
/// <param name="tableName">表名</param>
/// <param name="condition">查詢條件</param>
/// <param name="pageSize">頁寬</param>
/// <param name="flag">是否主鍵</param>
/// <returns>返回頁頁總數</returns>
public int GetPageCount(string Field, string tableName, string condition, ref int RecordCount, int pageSize, bool flag)
{
RecordCount = GetRecordCount(Field, tableName, condition, flag);
return GetPageCount(Field, tableName, condition, pageSize, ref RecordCount);
}
#endregion
#region 分頁函數
/// <summary>
/// 構造分頁查詢SQL語句
/// </summary>
/// <param name="KeyField">主鍵</param>
/// <param name="FieldStr">所有需要查詢的字段(field1,field2...)</param>
/// <param name="TableName">庫名.擁有者.表名</param>
/// <param name="Condition">查詢條件1(where ...)</param>
/// <param name="Condition2">查詢條件2(order by ...)</param>
/// <param name="CurrentPage">當前頁號</param>
/// <param name="PageSize">頁寬</param>
/// <returns>SQL語句</returns>
public static string JoinPageSQL(string KeyField, string FieldStr, string TableName, string Condition, string Condition2, int CurrentPage, int PageSize)
{
string sql = null;
if (CurrentPage == 1)
{
sql = "select top " + CurrentPage * PageSize + " " + FieldStr + " from " + TableName + " " + Condition + " " + Condition2 + " ";
}
else
{
sql = "select * from (";
sql += "select top " + CurrentPage * PageSize + " " + FieldStr + " from " + TableName + " " + Condition + " " + Condition2 + ") a ";
sql += "where " + KeyField + " not in (";
sql += "select top " + (CurrentPage - 1) * PageSize + " " + KeyField + " from " + TableName + " " + Condition + " " + Condition2 + ")";
}
return sql;
}
/// <summary>
/// 構造分頁查詢SQL語句
/// </summary>
/// <param name="Field">字段名(非主鍵)</param>
/// <param name="TableName">庫名.擁有者.表名</param>
/// <param name="Condition">查詢條件1(where ...)</param>
/// <param name="Condition2">查詢條件2(order by ...)</param>
/// <param name="CurrentPage">當前頁號</param>
/// <param name="PageSize">頁寬</param>
/// <returns>SQL語句</returns>
public static string JoinPageSQL(string Field, string TableName, string Condition, string Condition2, int CurrentPage, int PageSize)
{
string sql = null;
if (CurrentPage == 1)
{
sql = "select top " + CurrentPage * PageSize + " " + Field + " from " + TableName + " " + Condition + " " + Condition2 + " group by " + Field;
}
else
{
sql = "select * from (";
sql += "select top " + CurrentPage * PageSize + " " + Field + " from " + TableName + " " + Condition + " " + Condition2 + " group by " + Field + " ) a ";
sql += "where " + Field + " not in (";
sql += "select top " + (CurrentPage - 1) * PageSize + " " + Field + " from " + TableName + " " + Condition + " " + Condition2 + " group by " + Field + ")";
}
return sql;
}
/// <summary>
/// 頁面分頁顯示功能
/// </summary>
/// <param name="Parameters">參數串(a=1&b=2...)</param>
/// <param name="RecordCount">記錄總數</param>
/// <param name="PageSize">頁寬</param>
/// <param name="CurrentPage">當前頁號</param>
/// <param name="ShowJump">是否顯示跳轉輸入框及按鈕</param>
/// <param name="Style">樣式(1:上頁下頁...,2:1234...)</param>
/// <returns></returns>
public static string Paging(string Parameters, int RecordCount, int PageCount, int PageSize, int CurrentPage, bool ShowJump, int Style)
{
string str;
if (RecordCount <= PageSize) return "";
if (Parameters != "") Parameters += "&";
if (CurrentPage < 1) CurrentPage = 1;
if (CurrentPage > PageCount) CurrentPage = PageCount;
str = "<table align='center' width=\"100%\"><tr><td align=\"center\">";
str += "共 " + RecordCount + " 條記錄 頁次：" + CurrentPage + "/" + PageCount + "頁 ";
str += PageSize + "條/頁 ";
if (Style == 1)
{
if (CurrentPage == 1)
str += "<font color=\"#999999\">首頁 上頁</font> ";
else
{
str += "<a href='?" + Parameters + "page=1' class=\"link\">首頁</a> ";
str += "<a href='?" + Parameters + "page=" + (CurrentPage - 1) + "' class=\"link\">上頁</a> "; ;
}
if (CurrentPage == PageCount )
{
str += "<font color=\"#999999\">下頁 尾頁</font> ";
}
else
{
str += "<a href='?" + Parameters + "page=" + (CurrentPage + 1) + "' class=\"link\">下頁</a> ";
str += "<a href='?" + Parameters + "page=" + PageCount + "' class=\"link\">尾頁</a> ";
}
}
else if (Style == 2)
{
int NumberSize = 10;
int PageNumber = (CurrentPage - 1) / NumberSize;
if (PageNumber * NumberSize > 0)
str += "<a href='?" + Parameters + "page=" + PageNumber * NumberSize + "' title=上十頁 >[<<]</a> ";
int i;
for (i = PageNumber * NumberSize + 1; i <= (PageNumber + 1) * NumberSize; i++)
{
if (i == CurrentPage)
str += "<strong><font color=#ff0000>[" + i + "]</font></strong> ";
else
str += "<a href='?" + Parameters + "page=" + i + "'>[" + i + "]</a> ";
if (i == PageCount) break;
}
if (i < RecordCount) str += "<a href='?" + Parameters + "page=" + i + "' title=下十頁>[>>]</a> ";
}
if (ShowJump)
{
str += "";
}
str += "</td></tr></table>";
return str;
}
#endregion
}
}
您可能感興趣的文章:
相關文章
.NET使用CsvHelper快速讀取和寫入CSV文件的操作方法
在日常開發(fā)中使用CSV文件進行數據導入和導出、數據交換是非常常見的需求,今天我們來講講在.NET中如何使用CsvHelper這個開源庫快速實現CSV文件讀取和寫入,需要的朋友可以參考下2024-06-06
這篇文章主要介紹了ASP.NET中為GridView添加刪除提示框的方法,可實現非常人性化的刪除提示功能,需要的朋友可以參考下2015-06-06
在開發(fā)需要用戶注冊后才能使用提供的各項功能的應用程序時，在新用戶提交注冊信息后，較常見的做法是由程序生成隨機密碼，然后發(fā)送密碼到用戶注冊時填寫的電子信箱，用戶再用收到的密碼來激活其帳戶。2009-11-11
.NET?設計模式之模板方法模式(Template?Method?Pattern)詳解
模板方法模式（Template?Method?Pattern）,又叫模板模式（Template?Pattern）,是一種行為設計模式,它定義了一個操作中的算法框架,將某些步驟的具體實現留給子類,這篇文章主要介紹了.NET?設計模式—模板方法模式（Template?Method?Pattern）,需要的朋友可以參考下2024-04-04
UTF-7轉換GB2312編碼的方法2010-07-07
ASP.NET技巧：做個DataList可分頁的數據源...2006-09-09
工作中需要在linux上監(jiān)控系統(tǒng)空閑時間,但是沒有找到C#代碼,只找到C的代碼,所以準備將C文件編譯為so然后用P/invoke調用,這篇文章主要介紹了如何通過.net core調用so文件,需要的朋友可以參考下2023-08-08
這篇文章介紹了Visual?Studio的常用快捷鍵，對大家的學習或者工作具有一定的參考學習價值，需要的朋友們下面隨著小編來一起學習學習吧2022-04-04
ASP.NET技巧：教你制做Web實時進度條...2006-09-09
asp.net mvc 動態(tài)編譯生成Controller的方法
本篇文章主要介紹了asp.net mvc 動態(tài)編譯生成Controller的方法，具有一定的參考價值，有興趣的可以了解一下2017-08-08