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;
}
}
