62,046
社区成员
发帖
与我相关
我的任务
分享
public class t_b_SysUserData : DataSet
{
public const String T_B_SYSUSER_TABLE = "t_b_SysUser";
public const String ADMINID_FILED = "AdminID";
public const String USENAME_FILED = "UseName";
public const String PSW_FILED = "PSW";
public const String ROLEID_ID = "RoleID";
public t_b_SysUserData()
{
BuildDataTable();
}
private void BuildDataTable()
{
DataTable dt = new DataTable(T_B_SYSUSER_TABLE);
DataColumnCollection dcc = dt.Columns;
DataColumn dc = dcc.Add(ADMINID_FILED, typeof(System.Int32));
dcc.Add(USENAME_FILED, typeof(System.String));
dcc.Add(PSW_FILED, typeof(System.String));
dcc.Add(ROLEID_ID, typeof(System.String));
this.Tables.Add(dt);
}
}
public static DataSet GetPage(string sTableName, string sFields, string sOrderField, string sSqlWhere, int iPageSize, int iPageIndex, out int TotalPage)
{
DataSet ds = new DataSet();
。。。。。。。。。。
dar.Fill(ds);
return ds;
}
public t_b_SysUserData GetAllSysUserInfo(string sSqlWhere, int iPageSize, int iPageIndex,out int TotalPage)
{
return (t_b_SysUserData)BaseClass.ConnectionInfo.GetPage("t_b_SysUser", "*", "AdminID", sSqlWhere, iPageSize, iPageIndex, out TotalPage);
}