public Student(string email, Course course, string firstName, string middleName, string lastName,
University university, Major major, string phone)
: this(email, course, firstName, middleName, lastName, university, major)
{
this.Phone = phone;
count++;
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";//
string Name = context.Request.QueryString["Name"].ToString();
int CollegeId = Convert.ToInt32(context.Request.QueryString["College"]);
string Des = context.Request.QueryString["Des"].ToString();
if (Name.Length >= 1 && CollegeId != 0)
{
try
{
Major major = new Major();
major.Name = Name;
major.CollegeID = CollegeId;
major.Des = Des;
major.Save();
context.Response.Write("{success:true,msg:'新增成功。',majorId:'" + major.Id + "'}");
}
catch (Exception ex)
{
context.Response.Write("{success:false,msg:'" + ex.Message + "'}");
}
}
else
{
context.Response.Write("{success:false,msg:'新增失败，名称和专业为必填项。'}");
}
}
public EnrollingMajor(Major major)
{
this.major = major;
tempAdmittedCandidates = new List<EnrollingCandidate>();
quota = this.major.Limit;
}
public Student(string email, Course course, string firstName, string middleName, string lastName,
University university, Major major)
: this(email, course, firstName, middleName, lastName)
{
this.University = university;
this.Major = major;
count++;
}
public static List<Account> GetAccounts(
string name,
int gender,
string bloodType,
int birthYear,
int birthMonth,
int birthDate,
City hometownCity,
Province homwtownProvince,
City resideCity,
Province resideProvince,
ClassInfo classInfo,
Grade grade,
Major major,
College college,
University university,
string code,
bool? hasAvatar,
string nickName,
bool? isProtected,
int minViewCount,
int maxViewCount,
bool? isPublic,
int minYear,
int maxYear,
string interest,
PagingInfo pagingInfo)
{
return provider.GetAccounts(
name,
gender,
bloodType,
birthYear,
birthMonth,
birthDate,
hometownCity,
homwtownProvince,
resideCity,
resideProvince,
classInfo,
grade,
major,
college,
university,
code,
hasAvatar,
nickName,
isProtected,
minViewCount,
maxViewCount,
isPublic,
minYear,
maxYear,
interest,
pagingInfo);
}
public void Update(Major major)
{
var originalMajor = this.majors.GetById(major.Id);
if (originalMajor != null)
{
originalMajor.Name = major.Name;
this.majors.Save();
}
}
public RTFException(RTF rtf, string error_message) {
this.pos = rtf.LinePos;
this.line = rtf.LineNumber;
this.token_class = rtf.TokenClass;
this.major = rtf.Major;
this.minor = rtf.Minor;
this.param = rtf.Param;
this.text = rtf.Text;
this.error_message = error_message;
}
public ActionResult Create(Major major)
{
if (ModelState.IsValid)
{
db.Majors.Add(major);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(major);
}
internal async Task<bool> Update(HomeState homeState, ClassStanding classStanding, CollegeName collegeName, Major major)
{
if (_currentUser != null)
{
_currentUser.HomeState = homeState;
_currentUser.ClassStanding = classStanding;
_currentUser.College = collegeName;
_currentUser.Major = major;
await _usersTable.UpdateAsync(_currentUser);
return true;
}
return false;
}
public Major Create(string name)
{
var major = new Major()
{
Name = name,
CreatedOn = DateTime.UtcNow
};
this.majors.Add(major);
this.majors.Save();
return major;
}
public StyleElement(Style s, TokenClass token_class, Major major, Minor minor, int param, string text) {
this.token_class = token_class;
this.major = major;
this.minor = minor;
this.param = param;
this.text = text;
lock (s) {
if (s.Elements == null) {
s.Elements = this;
} else {
StyleElement se = s.Elements;
while (se.next != null)
se = se.next;
se.next = this;
}
}
}
public bool CheckMM(Major major, Minor minor) {
if ((this.major == major) && (this.minor == minor)) {
return true;
}
return false;
}
public bool CheckCMM(TokenClass rtf_class, Major major, Minor minor) {
if ((this.rtf_class == rtf_class) && (this.major == major) && (this.minor == minor)) {
return true;
}
return false;
}
public void Lookup(string token) {
Object obj;
KeyStruct key;
obj = key_table[token.Substring(1)];
if (obj == null) {
rtf_class = TokenClass.Unknown;
major = (Major) -1;
minor = (Minor) -1;
return;
}
key = (KeyStruct)obj;
this.rtf_class = TokenClass.Control;
this.major = key.Major;
this.minor = key.Minor;
}
public void UngetToken() {
if (this.pushed_class != TokenClass.None) {
throw new RTFException(this, "Cannot unget more than one token");
}
if (this.rtf_class == TokenClass.None) {
throw new RTFException(this, "No token to unget");
}
this.pushed_class = this.rtf_class;
this.pushed_major = this.major;
this.pushed_minor = this.minor;
this.pushed_param = this.param;
//this.pushed_text_buffer = new StringBuilder(this.text_buffer.ToString());
}
public void SetToken(TokenClass cl, Major maj, Minor min, int par, string text) {
this.rtf_class = cl;
this.major = maj;
this.minor = min;
this.param = par;
if (par == NoParam) {
this.text_buffer = new StringBuilder(text);
} else {
this.text_buffer = new StringBuilder(text + par.ToString());
}
}
private void GetToken2() {
char c;
int sign;
this.rtf_class = TokenClass.Unknown;
this.param = NoParam;
this.text_buffer.Length = 0;
if (this.pushed_char != EOF) {
c = this.pushed_char;
this.text_buffer.Append(c);
this.pushed_char = EOF;
} else if ((c = GetChar()) == EOF) {
this.rtf_class = TokenClass.EOF;
return;
}
if (c == '{') {
this.rtf_class = TokenClass.Group;
this.major = Major.BeginGroup;
return;
}
if (c == '}') {
this.rtf_class = TokenClass.Group;
this.major = Major.EndGroup;
return;
}
if (c != '\\') {
if (c != '\t') {
this.rtf_class = TokenClass.Text;
this.major = (Major)c; // FIXME - typing?
return;
} else {
this.rtf_class = TokenClass.Control;
this.major = Major.SpecialChar;
this.minor = Minor.Tab;
return;
}
}
if ((c = GetChar()) == EOF) {
// Not so good
return;
}
if (!Char.IsLetter(c)) {
if (c == '\'') {
char c2;
if ((c = GetChar()) == EOF) {
return;
}
if ((c2 = GetChar()) == EOF) {
return;
}
this.rtf_class = TokenClass.Text;
this.major = (Major)((Char)((Convert.ToByte(c.ToString(), 16) * 16 + Convert.ToByte(c2.ToString(), 16))));
return;
}
// Escaped char
if (c == ':' || c == '{' || c == '}' || c == '\\') {
this.rtf_class = TokenClass.Text;
this.major = (Major)c;
return;
}
Lookup(this.text_buffer.ToString());
return;
}
while (Char.IsLetter(c)) {
if ((c = GetChar()) == EOF) {
break;
}
}
if (c != EOF) {
this.text_buffer.Length--;
}
Lookup(this.text_buffer.ToString());
if (c != EOF) {
this.text_buffer.Append(c);
}
sign = 1;
if (c == '-') {
sign = -1;
c = GetChar();
}
if (c != EOF && Char.IsDigit(c)) {
this.param = 0;
while (Char.IsDigit(c)) {
this.param = this.param * 10 + Convert.ToByte(c) - 48;
if ((c = GetChar()) == EOF) {
break;
}
}
this.param *= sign;
}
if (c != EOF) {
if (c != ' ') {
this.pushed_char = c;
}
this.text_buffer.Length--;
}
}
/// <summary>Return the next token in the stream</summary>
public TokenClass GetToken() {
if (pushed_class != TokenClass.None) {
this.rtf_class = this.pushed_class;
this.major = this.pushed_major;
this.minor = this.pushed_minor;
this.param = this.pushed_param;
this.pushed_class = TokenClass.None;
return this.rtf_class;
}
GetToken2();
if (this.rtf_class == TokenClass.Text) {
this.minor = (Minor)this.cur_charset[(int)this.major];
if (encoding == null) {
encoding = Encoding.GetEncoding (encoding_code_page);
}
encoded_text = new String (encoding.GetChars (new byte [] { (byte) this.major }));
}
if (this.cur_charset.Flags == CharsetFlags.None) {
return this.rtf_class;
}
if (CheckCMM (TokenClass.Control, Major.Unicode, Minor.UnicodeAnsiCodepage)) {
encoding_code_page = param;
// fallback to the default one in case we have an invalid value
if (encoding_code_page < 0 || encoding_code_page > 65535)
encoding_code_page = DefaultEncodingCodePage;
}
if (((this.cur_charset.Flags & CharsetFlags.Read) != 0) && CheckCM(TokenClass.Control, Major.CharSet)) {
this.cur_charset.ReadMap();
} else if (((this.cur_charset.Flags & CharsetFlags.Switch) != 0) && CheckCMM(TokenClass.Control, Major.CharAttr, Minor.FontNum)) {
Font fp;
fp = Font.GetFont(this.font_list, this.param);
if (fp != null) {
if (fp.Name.StartsWith("Symbol")) {
this.cur_charset.ID = CharsetType.Symbol;
} else {
this.cur_charset.ID = CharsetType.General;
}
} else if (((this.cur_charset.Flags & CharsetFlags.Switch) != 0) && (this.rtf_class == TokenClass.Group)) {
switch(this.major) {
case Major.BeginGroup: {
this.charset_stack.Push(this.cur_charset);
break;
}
case Major.EndGroup: {
this.cur_charset = (Charset)this.charset_stack.Pop();
break;
}
}
}
}
return this.rtf_class;
}
public ActionResult Edit(Major major)
{
if (ModelState.IsValid)
{
db.Entry(major).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(major);
}
internal List<User> Search(HomeState homeState, ClassStanding classStanding, CollegeName collegeName, Major major)
{
List<User> mentorList = _usersList.Where(User => User.IsMentor).ToList();
if(homeState != HomeState.NA)
{
mentorList = mentorList.Where(User => User.HomeState == homeState).ToList();
}
if(classStanding != ClassStanding.NA)
{
mentorList = mentorList.Where(User => User.ClassStanding == classStanding).ToList();
}
if (collegeName != CollegeName.NA)
{
mentorList = mentorList.Where(User => User.College == collegeName).ToList();
}
if (major != Major.NA)
{
mentorList = mentorList.Where(User => User.Major == major).ToList();
}
mentorList.OrderBy(User => User.College).ThenBy(User => User.Major).ThenBy(User => User.HomeState).ThenBy(User => User.ClassStanding);
return mentorList;
}
public string GetId()
{
return(String.Format("{0}.{1}.{2}", Uuid, Major.PadLeft(5, '0'), Minor.PadLeft(5, '0')));
}
/// <summary>
/// Implement hashing as for value-equality.
/// </summary>
public override int GetHashCode()
{
return(31 * Major.GetHashCode() + Minor.GetHashCode());
}
VFileInfo wrap(Major.Proto.File file)
{
return new VFileInfo {
Name = file.Name,
Attributes = (file.Type == Major.Proto.File.Types.FileType.DIRECTORY ? FileAttributes.Directory : FileAttributes.Normal),
Length = (file.Type == Major.Proto.File.Types.FileType.DIRECTORY ? 0 : file.Size),
LastAccessTime = DateTime.Now,
LastWriteTime = file.HasLastModified ? file.LastModified.ToDateTime () : DateTime.Now,
CreationTime = DateTime.Now
};
}
// ��̨����
public List<Account> GetAccounts(
string name,
int gender,
string bloodType,
int birthYear,
int birthMonth,
int birthDate,
City hometownCity,
Province homwtownProvince,
City resideCity,
Province resideProvince,
ClassInfo classInfo,
Grade grade,
Major major,
College college,
University university,
string code,
bool? hasAvatar,
string nickName,
bool? isProtected,
int minViewCount,
int maxViewCount,
bool? isPublic,
string Sort,
PagingInfo pagingInfo)
{
List<Account> accountlist = new List<Account>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
System.Text.StringBuilder sbFilter = new StringBuilder();
#region Build filter
sbFilter.Append("1=1 ");
if (!string.IsNullOrEmpty(name))
{
sbFilter.Append(" And [Name] like '%");
sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
sbFilter.Append("%'");
}
if (gender == 1 || gender == 0)
{
sbFilter.Append(" And [Gender] = ");
sbFilter.Append(gender);
}
if (!string.IsNullOrEmpty(bloodType))
{
sbFilter.Append(" And BloodType = '");
sbFilter.Append(bloodType.Replace("'", "").Replace("\"", ""));
sbFilter.Append(" '");
}
if (birthYear > 0)
{
sbFilter.Append(" And BirthYear = ");
sbFilter.Append(birthYear);
}
if (birthMonth > 0 && birthMonth < 13)
{
sbFilter.Append(" And BirthMonth = ");
sbFilter.Append(birthMonth);
}
if (birthDate > 0 && birthDate < 32)
{
sbFilter.Append(" And BirthDate = ");
sbFilter.Append(birthDate);
}
if (hometownCity != null)
{
if (hometownCity.Id > 0)
{
sbFilter.Append(" And HometownCityId = ");
sbFilter.Append(hometownCity.Id);
}
}
else
{
if (homwtownProvince != null && homwtownProvince.Id > 0)
{
sbFilter.Append(" And HometownProvinceId = ");
sbFilter.Append(homwtownProvince.Id);
}
}
if (resideCity != null)
{
if (resideCity.Id > 0)
{
sbFilter.Append(" And ResideCityId = ");
sbFilter.Append(resideCity.Id);
}
}
else
{
if (resideProvince != null && resideProvince.Id > 0)
{
sbFilter.Append(" And ResideProvinceId = ");
sbFilter.Append(resideProvince.Id);
}
}
if (classInfo != null)
{
if (classInfo.Id > 0)
{
sbFilter.Append(" And ClassInfoId = ");
sbFilter.Append(classInfo.Id);
}
}
else
{
if (grade != null && grade.Id > 0)
{
sbFilter.Append(" And GradeId = ");
sbFilter.Append(grade.Id);
}
if (major != null)
{
if (major.Id > 0)
{
sbFilter.Append(" And MajorId = ");
sbFilter.Append(major.Id);
}
}
else
{
if (college != null)
{
if (college.Id > 0)
{
sbFilter.Append(" And CollegeId = ");
sbFilter.Append(college.Id);
}
}
else
{
if (university != null && university.Id > 0)
{
sbFilter.Append(" And UniversityID = ");
sbFilter.Append(university.Id);
}
}
}
}
if (!string.IsNullOrEmpty(code))
{
sbFilter.Append(" And Code = '");
sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
sbFilter.Append("'");
}
if (hasAvatar.HasValue)
{
sbFilter.Append(string.Format(" And HasAvatar = '{0}'", hasAvatar.Value ? "1" : "0"));
}
if (!string.IsNullOrEmpty(nickName))
{
sbFilter.Append(" And NickName = '");
sbFilter.Append(nickName.Replace("'", "").Replace("\"", ""));
sbFilter.Append("'");
}
if (isProtected.HasValue)
{
sbFilter.Append(string.Format(" And IsProtected = '{0}'", isProtected.Value ? "1" : "0"));
}
if ((minViewCount > 0) &&
(maxViewCount > 0) &&
(minViewCount < maxViewCount))
{
sbFilter.Append(string.Format(" And ViewNumber Between {0} and {1} ", minViewCount, maxViewCount));
}
if (isPublic.HasValue)
{
sbFilter.Append(" And IsPublic = '");
sbFilter.Append(isPublic.Value ? "1" : "0");
sbFilter.Append("'");
}
//ͨ��������֤�����û�
sbFilter.Append(" And IsEmailChecked='1'");
#endregion
#region BackCode
/*
int pageSize = int.MaxValue;
int pageNumber = 1;
if (pagingInfo != null)
{
pageSize = pagingInfo.PageSize;
pageNumber = pagingInfo.CurrentPage;
}
String Fields1 = "Id,ViewNumber,DateCreated,IsProtected,HasAvatar,IsTeacher,Name,NickName,Code,Credit,IsPublic,BirthYear,BirthMonth," +
"BirthDate,Gender,LoveState,HometownProvinceId,HometownCityId,ResideProvinceId,ResideCityId,Birthday,IsEmailChecked," +
"Telephone,Email,QQ,MSN,BloodType,Theme,LibUserId,Password,Interest,MajorId,MajorName,CollegeId,CollegeName,UniversityID,UniversityName,GradeId,GradeYear," +
"HometownProvinceName,HometownCityName,ResideProvinceName,ResideCityName,IsShow,FriendCount";
String Fields2 = "Id,Credit,DateCreated,IsProtected,HasAvatar,IsTeacher,IsPublic,ViewNumber,Name,NickName,Code,FriendCount";
sql.AddParameter("@Tables", SqlDbType.VarChar, "view_account_all");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
sql.AddParameter("@Fields", SqlDbType.VarChar, Fields2);//"Id"
sql.AddParameter("@sort", SqlDbType.NVarChar, Sort + " DESC");
sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString());
sql.AddParameter("@PageNumber", SqlDbType.Int, pageNumber);
sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
*/
#endregion
int pageSize = int.MaxValue;
int pageNumber = 1;
if (pagingInfo != null)
{
pageSize = pagingInfo.PageSize;
pageNumber = pagingInfo.CurrentPage;
}
sql.AddParameter("@PageNum", SqlDbType.Int, pageSize);
sql.AddParameter("@Num", SqlDbType.Int, pageSize * (pageNumber - 1));
String Column = "Id,Credit,DateCreated,IsProtected,HasAvatar,IsTeacher,IsPublic,ViewNumber,Name,NickName,Code,(SELECT COUNT(Friendship.Id) FROM Friendship WHERE (Friendship.AccountId = view_account_all.Id) AND (Friendship.IsChecked = 1)) AS FriendCount";
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append("SELECT TOP (@PageNum) " + Column + " FROM view_account_all WHERE " + sbFilter.ToString() + " AND [Id] NOT IN ");
sbSQL.Append("(SELECT TOP (@Num) [Id] FROM view_account_all WHERE " + sbFilter.ToString() + " ORDER BY " + Sort + " DESC) ORDER BY " + Sort + " DESC");
SqlDataReader reader = sql.ExecuteSqlReader(sbSQL.ToString());
if (reader != null)
{
while (reader.Read())
{
Core.Business.Account account = new Core.Business.Account();
if (!reader.IsDBNull(0)) account.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) account.Credit = reader.GetInt32(1);
if (!reader.IsDBNull(2)) account.DateCreated = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) account.IsProtected = reader.GetBoolean(3);
if (!reader.IsDBNull(4)) account.HasAvatar = reader.GetBoolean(4);
if (!reader.IsDBNull(5)) account.IsTeacher = reader.GetBoolean(5);
if (!reader.IsDBNull(6)) account.IsPublic = reader.GetBoolean(6);
if (!reader.IsDBNull(7)) account.ViewNumber = reader.GetInt64(7);
if (!reader.IsDBNull(8)) account.Name = reader.GetString(8);
if (!reader.IsDBNull(9)) account.NickName = reader.GetString(9);
if (!reader.IsDBNull(10)) account.Code = reader.GetString(10);
if (!reader.IsDBNull(11)) account.FriendCount = reader.GetInt32(11);
account.MarkOld();
accountlist.Add(account);
}
reader.Close();
}
return accountlist;
}
public List<Account> GetAccounts(
string name,
int gender,
string bloodType,
int birthYear,
int birthMonth,
int birthDate,
City hometownCity,
Province homwtownProvince,
City resideCity,
Province resideProvince,
ClassInfo classInfo,
Grade grade,
Major major,
College college,
University university,
string code,
bool? hasAvatar,
string nickName,
bool? isProtected,
int minViewCount,
int maxViewCount,
bool? isPublic,
int minYear,
int maxYear,
string interest,
PagingInfo pagingInfo)
{
List<Account> accounts = new List<Account>();
System.Text.StringBuilder sbFilter = new StringBuilder();
#region Build filter
sbFilter.Append("1=1 ");
if (!string.IsNullOrEmpty(name))
{
sbFilter.Append(" And [Name] like '%");
sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
sbFilter.Append("%'");
}
if (gender == 1 || gender == 0)
{
sbFilter.Append(" And [Gender] = ");
sbFilter.Append(gender);
}
if (!string.IsNullOrEmpty(bloodType))
{
sbFilter.Append(" And BloodType = '");
sbFilter.Append(bloodType.Replace("'", "").Replace("\"", ""));
sbFilter.Append(" '");
}
if (birthYear > 0)
{
sbFilter.Append(" And BirthYear = ");
sbFilter.Append(birthYear);
}
if (birthMonth > 0 && birthMonth < 13)
{
sbFilter.Append(" And BirthMonth = ");
sbFilter.Append(birthMonth);
}
if (birthDate > 0 && birthDate < 32)
{
sbFilter.Append(" And BirthDate = ");
sbFilter.Append(birthDate);
}
if (hometownCity != null)
{
if (hometownCity.Id > 0)
{
sbFilter.Append(" And HometownCityId = ");
sbFilter.Append(hometownCity.Id);
}
}
else
{
if (homwtownProvince != null && homwtownProvince.Id > 0)
{
sbFilter.Append(" And HometownProvinceId = ");
sbFilter.Append(homwtownProvince.Id);
}
}
if (resideCity != null)
{
if (resideCity.Id > 0)
{
sbFilter.Append(" And ResideCityId = ");
sbFilter.Append(resideCity.Id);
}
}
else
{
if (resideProvince != null && resideProvince.Id > 0)
{
sbFilter.Append(" And ResideProvinceId = ");
sbFilter.Append(resideProvince.Id);
}
}
if (classInfo != null)
{
if (classInfo.Id > 0)
{
sbFilter.Append(" And ClassInfoId = ");
sbFilter.Append(classInfo.Id);
}
}
else
{
if (grade != null && grade.Id > 0)
{
sbFilter.Append(" And GradeId = ");
sbFilter.Append(grade.Id);
}
if (major != null)
{
if (major.Id > 0)
{
sbFilter.Append(" And MajorId = ");
sbFilter.Append(major.Id);
}
}
else
{
if (college != null)
{
if (college.Id > 0)
{
sbFilter.Append(" And CollegeId = ");
sbFilter.Append(college.Id);
}
}
else
{
if (university != null && university.Id > 0)
{
sbFilter.Append(" And UniversityID = ");
sbFilter.Append(university.Id);
}
}
}
}
if (!string.IsNullOrEmpty(code))
{
sbFilter.Append(" And Code = '");
sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
sbFilter.Append("'");
}
if (hasAvatar.HasValue)
{
sbFilter.Append(string.Format(" And HasAvatar = '{0}'", hasAvatar.Value ? "1" : "0"));
}
if (!string.IsNullOrEmpty(nickName))
{
sbFilter.Append(" And NickName = '");
sbFilter.Append(nickName.Replace("'", "").Replace("\"", ""));
sbFilter.Append("'");
}
if (isProtected.HasValue)
{
sbFilter.Append(string.Format(" And IsProtected = '{0}'", isProtected.Value ? "1" : "0"));
}
if ((minViewCount > 0) &&
(maxViewCount > 0) &&
(minViewCount < maxViewCount))
{
sbFilter.Append(string.Format(" And ViewNumber Between {0} and {1} ", minViewCount, maxViewCount));
}
if (isPublic.HasValue)
{
sbFilter.Append(" And IsPublic = '");
sbFilter.Append(isPublic.Value ? "1" : "0");
sbFilter.Append("'");
}
if (minYear != 0 && maxYear != 0)
{
sbFilter.Append(string.Format(" And BirthYear Between {0} and {1} ", minYear, maxYear));
}
if (interest != string.Empty)
{
sbFilter.Append(string.Format(" And Interest like '%{0}%' ", interest));
}
//ͨ��������֤�����û�
sbFilter.Append(" And IsEmailChecked='1'");//������ AND [IsShow] = 0
#endregion
int pageSize = int.MaxValue;
int pageNumber = 1;
if (pagingInfo != null)
{
pageSize = pagingInfo.PageSize;
pageNumber = pagingInfo.CurrentPage;
}
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Tables", SqlDbType.VarChar, "view_account_all");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
sql.AddParameter("@Fields", SqlDbType.VarChar, "Id");
sql.AddParameter("@sort", SqlDbType.NVarChar, "Id DESC");
sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString());
sql.AddParameter("@PageNumber", SqlDbType.Int, pageNumber);
sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
long id = reader.GetInt64(0);
Account account = Account.Load(id);
accounts.Add(account);
}
reader.Close();
}
return accounts;
}
public int GetAccountsCount(
string name,
int gender,
string bloodType,
int birthYear,
int birthMonth,
int birthDate,
City hometownCity,
Province homwtownProvince,
City resideCity,
Province resideProvince,
ClassInfo classInfo,
Grade grade,
Major major,
College college,
University university,
string code,
bool? hasAvatar,
string nickName,
bool? isProtected,
int minViewCount,
int maxViewCount,
bool? isPublic,
int minYear,
int maxYear,
string interest
)
{
System.Text.StringBuilder sbFilter = new StringBuilder();
#region Build filter
sbFilter.Append("Where 1=1 ");
if (!string.IsNullOrEmpty(name))
{
sbFilter.Append(" And [Name] like '%");
sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
sbFilter.Append("%'");
}
if (gender == 1 || gender == 0)
{
sbFilter.Append(" And [Gender] = ");
sbFilter.Append(gender);
}
if (!string.IsNullOrEmpty(bloodType))
{
sbFilter.Append(" And BloodType = '");
sbFilter.Append(bloodType.Replace("'", "").Replace("\"", ""));
sbFilter.Append(" '");
}
if (birthYear > 0)
{
sbFilter.Append(" And BirthYear = ");
sbFilter.Append(birthYear);
}
if (birthMonth > 0 && birthMonth < 13)
{
sbFilter.Append(" And BirthMonth = ");
sbFilter.Append(birthMonth);
}
if (birthDate > 0 && birthDate < 32)
{
sbFilter.Append(" And BirthDate = ");
sbFilter.Append(birthDate);
}
if (hometownCity != null)
{
if (hometownCity.Id > 0)
{
sbFilter.Append(" And HometownCityId = ");
sbFilter.Append(hometownCity.Id);
}
}
else
{
if (homwtownProvince != null && homwtownProvince.Id > 0)
{
sbFilter.Append(" And HometownProvinceId = ");
sbFilter.Append(homwtownProvince.Id);
}
}
if (resideCity != null)
{
if (resideCity.Id > 0)
{
sbFilter.Append(" And ResideCityId = ");
sbFilter.Append(resideCity.Id);
}
}
else
{
if (resideProvince != null && resideProvince.Id > 0)
{
sbFilter.Append(" And ResideProvinceId = ");
sbFilter.Append(resideProvince.Id);
}
}
if (classInfo != null)
{
if (classInfo.Id > 0)
{
sbFilter.Append(" And ClassInfoId = ");
sbFilter.Append(classInfo.Id);
}
}
else
{
if (grade != null && grade.Id > 0)
{
sbFilter.Append(" And GradeId = ");
sbFilter.Append(grade.Id);
}
if (major != null)
{
if (major.Id > 0)
{
sbFilter.Append(" And MajorId = ");
sbFilter.Append(major.Id);
}
}
else
{
if (college != null)
{
if (college.Id > 0)
{
sbFilter.Append(" And CollegeId = ");
sbFilter.Append(college.Id);
}
}
else
{
if (university != null && university.Id > 0)
{
sbFilter.Append(" And UniversityID = ");
sbFilter.Append(university.Id);
}
}
}
}
if (!string.IsNullOrEmpty(code))
{
sbFilter.Append(" And Code = '");
sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
sbFilter.Append("'");
}
if (hasAvatar.HasValue)
{
sbFilter.Append(string.Format(" And HasAvatar = '{0}'", hasAvatar.Value ? "1" : "0"));
}
if (!string.IsNullOrEmpty(nickName))
{
sbFilter.Append(" And NickName = '");
sbFilter.Append(nickName.Replace("'", "").Replace("\"", ""));
sbFilter.Append("'");
}
if (isProtected.HasValue)
{
sbFilter.Append(string.Format(" And IsProtected = '{0}'", isProtected.Value ? "1" : "0"));
}
if ((minViewCount > 0) &&
(maxViewCount > 0) &&
(minViewCount < maxViewCount))
{
sbFilter.Append(string.Format(" And ViewNumber Between {0} and {1} ", minViewCount, maxViewCount));
}
if (isPublic.HasValue)
{
sbFilter.Append(" And IsPublic = '");
sbFilter.Append(isPublic.Value ? "1" : "0");
sbFilter.Append("'");
}
if (minYear != 0 && maxYear != 0)
{
sbFilter.Append(string.Format(" And BirthYear Between {0} and {1} ", minYear, maxYear));
}
if (interest != string.Empty)
{
sbFilter.Append(string.Format(" And Interest like '{0}' ", interest));
}
//ͨ��������֤�����û�
sbFilter.Append(" And IsEmailChecked='1'");// ������ AND [IsShow] = 0
#endregion
SqlServerUtility sql = new SqlServerUtility(connectionString);
String strSql = "Select count(Id) From [view_account_all] " + sbFilter.ToString();
SqlDataReader reader = sql.ExecuteSqlReader(strSql);
if (reader != null && !reader.IsClosed && reader.Read())
{
int count = 0;
if (!reader.IsDBNull(0)) count = reader.GetInt32(0);
reader.Close();
return count;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return 0;
}
}
private void GetToken2()
{
char c;
int sign;
this.rtf_class = TokenClass.Unknown;
this.param = NoParam;
this.text_buffer.Length = 0;
if (this.pushed_char != EOF)
{
c = this.pushed_char;
this.text_buffer.Append(c);
this.pushed_char = EOF;
}
else if ((c = GetChar()) == EOF)
{
this.rtf_class = TokenClass.EOF;
return;
}
if (c == '{')
{
this.rtf_class = TokenClass.Group;
this.major = Major.BeginGroup;
return;
}
if (c == '}')
{
this.rtf_class = TokenClass.Group;
this.major = Major.EndGroup;
return;
}
if (c != '\\')
{
if (c != '\t')
{
this.rtf_class = TokenClass.Text;
this.major = (Major)c; // FIXME - typing?
return;
}
else
{
this.rtf_class = TokenClass.Control;
this.major = Major.SpecialChar;
this.minor = Minor.Tab;
return;
}
}
if ((c = GetChar()) == EOF)
{
// Not so good
return;
}
if (!Char.IsLetter(c))
{
if (c == '\'')
{
char c2;
if ((c = GetChar()) == EOF)
{
return;
}
if ((c2 = GetChar()) == EOF)
{
return;
}
this.rtf_class = TokenClass.Text;
this.major = (Major)((Char)((Convert.ToByte(c.ToString(), 16) * 16 + Convert.ToByte(c2.ToString(), 16))));
return;
}
// Escaped char
if (c == ':' || c == '{' || c == '}' || c == '\\')
{
this.rtf_class = TokenClass.Text;
this.major = (Major)c;
return;
}
Lookup(this.text_buffer.ToString());
return;
}
while (Char.IsLetter(c))
{
if ((c = GetChar(false)) == EOF)
{
break;
}
}
if (c != EOF)
{
this.text_buffer.Length--;
}
Lookup(this.text_buffer.ToString());
if (c != EOF)
{
this.text_buffer.Append(c);
}
sign = 1;
if (c == '-')
{
sign = -1;
c = GetChar();
}
if (c != EOF && Char.IsDigit(c) && minor != Minor.PngBlip)
{
this.param = 0;
while (Char.IsDigit(c))
{
this.param = this.param * 10 + Convert.ToByte(c) - 48;
if ((c = GetChar()) == EOF)
{
break;
}
}
this.param *= sign;
}
if (c != EOF)
{
if (c != ' ' && c != '\r' && c != '\n')
{
this.pushed_char = c;
}
this.text_buffer.Length--;
}
}
/// <summary>Return the next token in the stream</summary>
public TokenClass GetToken()
{
if (pushed_class != TokenClass.None)
{
this.rtf_class = this.pushed_class;
this.major = this.pushed_major;
this.minor = this.pushed_minor;
this.param = this.pushed_param;
this.pushed_class = TokenClass.None;
return(this.rtf_class);
}
GetToken2();
if (this.rtf_class == TokenClass.Text)
{
if (encoding == null)
{
encoding = Encoding.GetEncoding(encoding_code_page);
}
encoded_text = new String(encoding.GetChars(new byte [] { (byte)this.major }));
}
else if (CheckCMM(TokenClass.Control, Major.Unicode, Minor.UnicodeAnsiCodepage))
{
encoding_code_page = param;
// fallback to the default one in case we have an invalid value
if (encoding_code_page < 0 || encoding_code_page > 65535)
{
encoding_code_page = DefaultEncodingCodePage;
}
encoding = null;
}
else if (CheckCMM(TokenClass.Control, Major.CharAttr, Minor.FontNum))
{
Font fp;
fp = Font.GetFont(this.fonts, this.param);
if (fp != null)
{
if (fp.Codepage != 0)
{
if (fp.Codepage != encoding_code_page)
{
encoding_code_page = fp.Codepage;
encoding = null;
}
}
else
{
var cp = CharsetToCodepage.Translate(fp.Charset);
if (cp != 0 && cp != encoding_code_page)
{
encoding_code_page = cp;
encoding = null;
}
}
}
}
else if (this.rtf_class == TokenClass.Group)
{
switch (this.major)
{
case Major.BeginGroup: {
charset_stack.Push(encoding_code_page);
break;
}
case Major.EndGroup: {
if (charset_stack.Count > 0)
{
encoding_code_page = (int)this.charset_stack.Pop();
}
else
{
encoding_code_page = DefaultEncodingCodePage;
}
if (encoding != null && encoding.CodePage != encoding_code_page)
{
encoding = null;
}
break;
}
}
}
return(this.rtf_class);
}
/// <summary>Return the next token in the stream</summary>
public TokenClass GetToken() {
if (pushed_class != TokenClass.None) {
this.rtf_class = this.pushed_class;
this.major = this.pushed_major;
this.minor = this.pushed_minor;
this.param = this.pushed_param;
this.pushed_class = TokenClass.None;
return this.rtf_class;
}
GetToken2();
if (this.rtf_class == TokenClass.Text) {
this.minor = (Minor)this.cur_charset[(int)this.major];
}
if (this.cur_charset.Flags == CharsetFlags.None) {
return this.rtf_class;
}
if (((this.cur_charset.Flags & CharsetFlags.Read) != 0) && CheckCM(TokenClass.Control, Major.CharSet)) {
this.cur_charset.ReadMap();
} else if (((this.cur_charset.Flags & CharsetFlags.Switch) != 0) && CheckCMM(TokenClass.Control, Major.CharAttr, Minor.FontNum)) {
Font fp;
fp = Font.GetFont(this.font_list, this.param);
if (fp != null) {
if (fp.Name.StartsWith("Symbol")) {
this.cur_charset.ID = CharsetType.Symbol;
} else {
this.cur_charset.ID = CharsetType.General;
}
} else if (((this.cur_charset.Flags & CharsetFlags.Switch) != 0) && (this.rtf_class == TokenClass.Group)) {
switch(this.major) {
case Major.BeginGroup: {
this.charset_stack.Push(this.cur_charset);
break;
}
case Major.EndGroup: {
this.cur_charset = (Charset)this.charset_stack.Pop();
break;
}
}
}
}
return this.rtf_class;
}
public bool Equals(VersionInfo vi)
{
return(object.ReferenceEquals(vi, null) ? false : Major.Equals(vi.Major) && Minor.Equals(vi.Minor) && Maintenance.Equals(vi.Maintenance) && Build.Equals(vi.Build) && RevisionGuid.Equals(vi.RevisionGuid, StringComparison.Ordinal));
}
public KeyStruct(Major major, Minor minor, string symbol) {
Major = major;
Minor = minor;
Symbol = symbol;
}
void CheckHeader()
{
if (header.Length != 96)
{
throw new InvalidDataException("Hit unexpected end of file.");
}
if (bytesToString(Magic) != magic)
{
throw new InvalidDataException("Expected magic tag '" + magic + "'. Found '" + bytesToString(Magic) + "'.");
}
if (!majors.Contains(Major))
{
throw new InvalidDataException("Expected major version(s) '" + string.Join(", ", majors) + "'. Found '" + Major.ToString() + "'.");
}
if (Minor != minor)
{
throw new InvalidDataException("Expected minor version '" + minor + "'. Found '" + Minor.ToString() + "'.");
}
}
