public static List <string> GetClassStrList() { ClubcReader r = Utility.ExecSql("select Descript from tblClubcUserClass order by Class"); if (r != null) { List <string> ClassStrList = new List <string>(); do { ClassStrList.Add((string)r["Descript"]); } while (r.Next()); return(ClassStrList); } else { return(null); } }
public static ClubcUser CreateUser(string user, string pass, string ClassStr, string Nickname) { bool bSuccessed; ClubcReader r = Utility.ExecSql(string.Format("exec CreateClubcUser '{0}', '{1}', '{2}', '{3}'", user, pass, ClassStr, Nickname), out bSuccessed); if (bSuccessed) { ClubcUser cu = new ClubcUser(); cu.UserName = user; cu.Password = pass; cu.Nickname = Nickname; cu.m_UserClassStr = ClassStr; return(cu); } else { return(null); } }