public static List<T_ad_type> admin_se_type() { string sql = "select * from t_type"; using (SqlDataReader dr = a.data.mssql.ExecuteReader(0, sql)) { List<T_ad_type> list = new List<T_ad_type>(); while (dr.Read()) { T_ad_type type = new T_ad_type(); type.Id = a.normal.toInt(dr["id"]); type.Atype_name = a.normal.toString(dr["type_name"]); list.Add(type); } dr.Close(); dr.Dispose(); return list; } }
public static List<T_ad_type> admin_type_all(string tblName, string fldName, int PageSize, int PageIndex, string OrderType, string strWhere, out int Count) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@strOrder", SqlDbType.VarChar,100), new SqlParameter("@strWhere", SqlDbType.VarChar,1500), new SqlParameter("@Count", SqlDbType.Int), }; parameters[0].Value = tblName; parameters[1].Value = "*"; parameters[2].Value = fldName; parameters[3].Value = PageSize; parameters[4].Value = PageIndex; parameters[5].Value = OrderType; parameters[6].Value = strWhere; parameters[7].Direction = ParameterDirection.Output; List<T_ad_type> list = new List<T_ad_type>(); using (SqlDataReader dr = a.data.mssql.ExecuteReader(1, "[UP_PaginationAnyOrderCount]", parameters)) { while (dr.Read()) { T_ad_type model = new T_ad_type(); model.Id = a.normal.toInt(dr["id"]); model.Atype_name = a.normal.toString(dr["atype_name"]); model.Btype_name = a.normal.toString(dr["atype_name"]); model.Type_father_id = a.normal.toInt(dr["Type_father_id"]); list.Add(model); } dr.Close(); dr.Dispose(); Count = a.normal.toInt(parameters[7].Value); return list; } }
public static List<T_ad_type> admin_select_type() { using (SqlDataReader dr = a.data.mssql.ExecuteReader(0, "select * from t_ad_type")) { List<T_ad_type> list = new List<T_ad_type>(); while (dr.Read()) { T_ad_type model = new T_ad_type(); model.Id = a.normal.toInt(dr["id"]); model.Atype_name = a.normal.toString(dr["type_name"]); model.Type_father_id = a.normal.toInt(dr["Type_father_id"]); list.Add(model); } dr.Close(); dr.Dispose(); return list; } }