public static List <T> ExecuteDataset <T>(string cmdText, params SqlParameter[] sqlParams) { if (string.IsNullOrEmpty(cmdText)) { throw new ArgumentNullException("cmdText"); } using (DataSet set = DataBase.ExecuteDataset(CommandType.Text, cmdText, sqlParams)) { if ((set.Tables.Count < 1) || (set.Tables[0].Rows.Count < 1)) { return(new List <T>(0)); } return(DataBinding.LoadForList <T>(set.Tables[0].Rows)); } }
public static List <T> Select <T>(string tableName, string fields, int topCount, string condition, string orderField, bool asc, params SqlParameter[] sqlParams) { if (string.IsNullOrEmpty(tableName)) { throw new ArgumentNullException("tableName"); } if (condition == null) { condition = string.Empty; } condition = condition.Trim(); if (!string.IsNullOrEmpty(condition) && !condition.StartsWith("WHERE", true, null)) { condition = "WHERE " + condition; } if (string.IsNullOrEmpty(fields)) { fields = "*"; } string commandText = "SELECT"; if (topCount > 0) { commandText = commandText + " TOP " + topCount.ToString(); } string str2 = commandText; commandText = str2 + " " + fields + " FROM [" + tableName + "] " + condition; orderField = orderField.Trim(); if (!string.IsNullOrEmpty(orderField)) { orderField = " ORDER BY [" + orderField + "] " + (asc ? "ASC" : "DESC"); commandText = commandText + orderField; } using (DataSet set = DataBase.ExecuteDataset(CommandType.Text, commandText, sqlParams)) { if ((set.Tables.Count < 1) || (set.Tables[0].Rows.Count < 1)) { return(new List <T>(0)); } return(DataBinding.LoadForList <T>(set.Tables[0].Rows)); } }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <param name="tableName"></param> /// <param name="fields"></param> /// <param name="condition"></param> /// <param name="fldName"></param> /// <param name="asc"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public static List <T> Select <T>(string tableName, string fields, string condition, string fldName, int asc, int pageIndex, int pageSize) { List <SqlParameter> list = new List <SqlParameter>(7); list.Add(new SqlParameter("@tblName", tableName)); list.Add(new SqlParameter("@fldName", fldName)); list.Add(new SqlParameter("@PageSize", pageSize)); list.Add(new SqlParameter("@PageIndex", pageIndex)); list.Add(new SqlParameter("@IsCount", SqlDbType.BigInt)); list.Add(new SqlParameter("@OrderType", asc)); list.Add(new SqlParameter("@strWhere", condition)); using (DataSet set = DataBase.ExecuteDataset(CommandType.StoredProcedure, "GetRecordFromPage", list.ToArray())) { if ((set.Tables.Count < 1) || (set.Tables[0].Rows.Count < 1)) { return(new List <T>(0)); } return(DataBinding.LoadForList <T>(set.Tables[0].Rows)); } }
public static List <T> Select <T>(string tbname, string FieldKey, int PageCurrent, int PageSize, string FieldShow, string FieldOrder, string Where, int pageSize) { List <SqlParameter> list = new List <SqlParameter>(8); list.Add(new SqlParameter("@tbname", tbname)); list.Add(new SqlParameter("@FieldKey", FieldKey)); list.Add(new SqlParameter("@PageCurrent", PageCurrent)); list.Add(new SqlParameter("@PageSize", PageSize)); list.Add(new SqlParameter("@FieldShow", FieldShow)); list.Add(new SqlParameter("@FieldOrder", FieldOrder)); list.Add(new SqlParameter("@Where", Where)); list.Add(new SqlParameter("@PageCount", 10)); using (DataSet set = DataBase.ExecuteDataset(CommandType.StoredProcedure, "sp_pageView", list.ToArray())) { if ((set.Tables.Count < 1) || (set.Tables[0].Rows.Count < 1)) { return(new List <T>(0)); } return(DataBinding.LoadForList <T>(set.Tables[0].Rows)); } }