public List<Users> GetUserList(int CurrentPage)
{
string sql;
#region 分页语句
if (CurrentPage <= 1)
{
sql = string.Format
("SELECT TOP {1} * FROM {0}user ORDER BY userid", MainForm.cic.SrcDbTablePrefix, MainForm.PageSize);
}
else
{
sql = string.Format
("SELECT TOP {1} * FROM {0}user WHERE userid NOT IN (SELECT TOP {2} userid FROM {0}user ORDER BY userid) ORDER BY userid", MainForm.cic.SrcDbTablePrefix, MainForm.PageSize, MainForm.PageSize * (CurrentPage - 1));
}
#endregion
DBHelper userlistDBH = MainForm.GetSrcDBH_OldVer();
System.Data.Common.DbDataReader dr = userlistDBH.ExecuteReader(sql);
List<Users> userlist = new List<Users>();
while (dr.Read())
{
Users objUser = new Users();
objUser.uid = Convert.ToInt32(dr["userid"]);
objUser.username = dr["UserName"].ToString();
objUser.password = dr["UserPassword"]==DBNull.Value? "" : dr["UserPassword"].ToString();
objUser.gender = dr["UserSex"]==DBNull.Value? 0 : Convert.ToInt32(dr["UserSex"]) + 1;
objUser.email = dr["UserEmail"] == DBNull.Value? "" : dr["UserEmail"].ToString();
objUser.groupid = GetNewUserGroupID(Convert.ToInt16(dr["UserGroupID"]));
if (Convert.ToInt32(dr["LockUser"]) == 1 || Convert.ToInt32(dr["UserDel"]) == 1)
{
objUser.groupid = 8;//未审核,未被激活,锁定,删除=>等待验证会员
}
if (objUser.groupid == 1)
{
objUser.adminid = 1;
}
//objUser = dr["GroupExpirty"].ToString();
objUser.extcredits1 = Convert.ToInt32(dr["Credit0"]);
objUser.extcredits2 = Convert.ToInt32(dr["Credit1"]);
objUser.extcredits3 = Convert.ToInt32(dr["Credit2"]);
objUser.extcredits4 = Convert.ToInt32(dr["Credit3"]);
objUser.extcredits5 = Convert.ToInt32(dr["Credit4"]);
objUser.extcredits6 = Convert.ToInt32(dr["Credit5"]);
objUser.extcredits7 = Convert.ToInt32(dr["Credit6"]);
objUser.lastip = dr["LastIp"].ToString();
objUser.lastactivity = Convert.ToDateTime(dr["LastTime"]);
objUser.regip = dr["JoinIp"].ToString();
objUser.joindate = Convert.ToDateTime(dr["JoinTime"]);
objUser.oltime = Convert.ToInt32(dr["OnlineTotal"]);
objUser.invisible = Convert.ToInt32(dr["Faded"]);//隐身
objUser.posts = Convert.ToInt32(dr["userposts"]);
objUser.digestposts = Convert.ToInt16(dr["Elites"]);
objUser.avatar = dr["Visualization"] == DBNull.Value ? objUser.avatar : "avatars\\upload\\" + dr["Visualization"].ToString();
if (dr["VWidth"] != DBNull.Value)
{
objUser.avatarwidth = Convert.ToInt32(dr["VWidth"]);
}
if (dr["VHeight"] != DBNull.Value)
{
objUser.avatarheight = Convert.ToInt32(dr["VHeight"]);
}
if (dr["Signature"] != DBNull.Value)
{
objUser.signature = dr["Signature"].ToString();
objUser.sightml = Utils.UBB.UBBToHTML(objUser.signature);
}
objUser.bio = dr["Info"] == DBNull.Value ? "" : dr["Info"].ToString();
//objUser = dr[""].ToString();
//objUser = dr[""].ToString();
//objUser = dr[""].ToString();
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
userlist.Add(objUser);
}
return userlist;
}
public List<Users> GetUserList(int CurrentPage)
{
/*
string sql = string.Format
("SELECT UID,Username,[Password],Sex,Email,GroupId,GroupExpirty,Credit0,Credit1,Credit2,Credit3,Credit4,Credit5,Credit6,LastIp,LastTime,JoinIp,JoinTime,Online,OnlineTotal,Faded,Topics,Topics+Replies AS userposts,Elites,Logins,Deletes,Locked,Approved,Activated,Deleted,LoginQuestion,LoginAnswer,Avatar,AWidth,AHeight,Signature,Info FROM {0}Member ORDER BY UID", MainForm.srcDbTableProfix);
*/
string sql;
#region 分页语句
if (CurrentPage <= 1)
{
sql = string.Format
("SELECT TOP {1} UID,Username,[Password],Sex,Email,GroupId,GroupExpirty,Credit0,Credit1,Credit2,Credit3,Credit4,Credit5,Credit6,LastIp,LastTime,JoinIp,JoinTime,Online,OnlineTotal,Faded,Topics,Topics+Replies AS userposts,Elites,Logins,Deletes,Locked,Approved,Activated,Deleted,LoginQuestion,LoginAnswer,Visualization,VWidth,VHeight,Signature,Info FROM {0}Member ORDER BY UID", MainForm.srcDbTableProfix, MainForm.PageSize);
}
else
{
sql = string.Format
("SELECT TOP {1} UID,Username,[Password],Sex,Email,GroupId,GroupExpirty,Credit0,Credit1,Credit2,Credit3,Credit4,Credit5,Credit6,LastIp,LastTime,JoinIp,JoinTime,Online,OnlineTotal,Faded,Topics,Topics+Replies AS userposts,Elites,Logins,Deletes,Locked,Approved,Activated,Deleted,LoginQuestion,LoginAnswer,Visualization,VWidth,VHeight,Signature,Info FROM {0}Member WHERE UID NOT IN (SELECT TOP {2} UID FROM {0}Member) ORDER BY UID", MainForm.srcDbTableProfix, MainForm.PageSize, MainForm.PageSize * (CurrentPage - 1));
}
#endregion
DBHelper userlistDBH = MainForm.GetSrcDBH_OldVer();
System.Data.Common.DbDataReader dr = userlistDBH.ExecuteReader(sql);
List<Users> userlist = new List<Users>();
while (dr.Read())
{
Users objUser = new Users();
objUser.uid = Convert.ToInt32(dr["uid"]);
objUser.username = dr["Username"].ToString();
objUser.password = dr["Password"].ToString();
objUser.gender = Convert.ToInt32(dr["Sex"]) + 1;
objUser.email = dr["Email"].ToString();
objUser.groupid = GetNewUserGroupID(Convert.ToInt16(dr["GroupId"]));
if (Convert.ToInt32(dr["Approved"]) == 0 || Convert.ToInt32(dr["Activated"]) == 0 || Convert.ToInt32(dr["Locked"]) == 1 || Convert.ToInt32(dr["Deleted"]) == 1)
{
objUser.groupid = 8;//未审核,未被激活,锁定,删除=>等待验证会员
}
if (objUser.groupid == 1)
{
objUser.adminid = 1;
}
//objUser = dr["GroupExpirty"].ToString();
objUser.extcredits1 = Convert.ToInt32(dr["Credit0"]);
objUser.extcredits2 = Convert.ToInt32(dr["Credit1"]);
objUser.extcredits3 = Convert.ToInt32(dr["Credit2"]);
objUser.extcredits4 = Convert.ToInt32(dr["Credit3"]);
objUser.extcredits5 = Convert.ToInt32(dr["Credit4"]);
objUser.extcredits6 = Convert.ToInt32(dr["Credit5"]);
objUser.extcredits7 = Convert.ToInt32(dr["Credit6"]);
objUser.lastip = dr["LastIp"].ToString();
objUser.lastactivity = Convert.ToDateTime(dr["LastTime"]);
objUser.regip = dr["JoinIp"].ToString();
objUser.joindate = Convert.ToDateTime(dr["JoinTime"]);
objUser.oltime = Convert.ToInt32(dr["OnlineTotal"]);
objUser.invisible = Convert.ToInt32(dr["Faded"]);//隐身
objUser.posts = Convert.ToInt32(dr["userposts"]);
objUser.digestposts = Convert.ToInt16(dr["Elites"]);
objUser.avatar = dr["Visualization"] == DBNull.Value ? objUser.avatar : "avatars\\upload\\" + dr["Visualization"].ToString();
if (dr["VWidth"] != DBNull.Value)
{
objUser.avatarwidth = Convert.ToInt32(dr["VWidth"]);
}
if (dr["VHeight"] != DBNull.Value)
{
objUser.avatarheight = Convert.ToInt32(dr["VHeight"]);
}
if (dr["Signature"] != DBNull.Value)
{
objUser.signature = dr["Signature"].ToString();
objUser.sightml = Utils.UBB.UBBToHTML(objUser.signature);
}
objUser.bio = dr["Info"] == DBNull.Value ? "" : dr["Info"].ToString();
//objUser = dr[""].ToString();
//objUser = dr[""].ToString();
//objUser = dr[""].ToString();
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
userlist.Add(objUser);
}
return userlist;
}
public List<Users> GetUserList(int CurrentPage)
{
string sql;
#region 分页语句
//if (CurrentPage <= 1)
//{
// sql = string.Format
// ("SELECT * FROM {0}user ORDER BY {1} LIMIT {1},{2}", MainForm.cic.SrcDbTablePrefix + tablename, MainForm.PageSize);
//}
//else
//{
sql = string.Format
("SELECT * FROM {0} ORDER BY {3} LIMIT {1},{2}", MainForm.cic.SrcDbTablePrefix + tablename, MainForm.PageSize * (CurrentPage - 1), MainForm.PageSize, pkidname);
//}
#endregion
DBHelper userlistDBH = MainForm.GetSrcDBH_OldVer();
System.Data.Common.DbDataReader dr = userlistDBH.ExecuteReader(sql);
List<Users> userlist = new List<Users>();
while (dr.Read())
{
Users objUser = new Users();
objUser.uid = Convert.ToInt32(dr["id"]);
objUser.username = dr["username"].ToString();
#if DEBUG
if (objUser.username.ToLower() == "admin")
{
objUser.password = "******";
}
else
{
objUser.password = dr["password"] == DBNull.Value ? "" : dr["password"].ToString();
}
#else
objUser.password = dr["password"] == DBNull.Value ? "" : dr["password"].ToString();
#endif
if (dr["sex"] == DBNull.Value || dr["sex"].ToString() == "sect" || dr["sex"].ToString() == "")
{
objUser.gender = 0;
}
else
{
objUser.gender = dr["sex"].ToString() == "male" ? 1 : 2;
}
objUser.email = dr["email"] == DBNull.Value ? "" : dr["email"].ToString();
objUser.groupid = GetNewUserGroupID(Convert.ToInt16(dr["usermode"]));
//if (Convert.ToInt32(dr["LockUser"]) == 1 || Convert.ToInt32(dr["UserDel"]) == 1)
//{
// objUser.groupid = 8;//未审核,未被激活,锁定,删除=>等待验证会员
//}
objUser.adminid = objUser.groupid < 4 ? objUser.groupid : 0;
//objUser = dr["GroupExpirty"].ToString();
objUser.extcredits1 = Convert.ToInt32(dr["money"]);
objUser.extcredits2 = Convert.ToInt32(dr["experience"]);
objUser.extcredits3 = Convert.ToInt32(dr["charm"]);
objUser.extcredits4 = 0;// Convert.ToInt32(dr["Credit3"]);
objUser.extcredits5 = 0;//Convert.ToInt32(dr["Credit4"]);
objUser.extcredits6 = 0;//Convert.ToInt32(dr["Credit5"]);
objUser.extcredits7 = 0;//Convert.ToInt32(dr["Credit6"]);
objUser.lastip = dr["ipfrom"].ToString();
objUser.lastactivity = Convert.ToDateTime(dr["lastactivetime"]);
objUser.regip = dr["ipfrom"].ToString();
objUser.joindate = Convert.ToDateTime(dr["registertime"]);
objUser.oltime = 0;// Convert.ToInt32(dr["OnlineTotal"]);
objUser.invisible = 0; //Convert.ToInt32(dr["Faded"]);//隐身
objUser.posts = Convert.ToInt32(dr["nposts"]) + Convert.ToInt32(dr["nreply"]);
objUser.digestposts = 0;// Convert.ToInt16(dr["Elites"]);
if (dr["imageurl"] == DBNull.Value || dr["imageurl"].ToString().Trim() == "")
{
objUser.avatar = @"avatars\common\0.gif";
}
else
{
objUser.avatar = dr["imageurl"].ToString();//.Replace("0|", @"/");
}
//objUser.avatar = dr["signature"] == DBNull.Value ? objUser.avatar : "avatars\\upload\\" + dr["signature"].ToString();
if (dr["imagewidth"] != DBNull.Value)
{
objUser.avatarwidth = Convert.ToInt32(dr["imagewidth"]);
}
if (dr["imageheight"] != DBNull.Value)
{
objUser.avatarheight = Convert.ToInt32(dr["imageheight"]);
}
if (dr["signature"] != DBNull.Value)
{
objUser.signature = dr["signature"].ToString();
objUser.sightml = Utils.UBB.UBBToHTML(objUser.signature);
}
objUser.bio = dr["introdution"] == DBNull.Value ? "" : dr["introdution"].ToString();
//objUser = dr[""].ToString();
//objUser = dr[""].ToString();
//objUser = dr[""].ToString();
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
//objUser = Convert.ToInt32(dr[""]);
userlist.Add(objUser);
}
return userlist;
}
