public ResponseStatus Login(HttpRequestBase req, Container_List_Status conTa_status, ref UserStatus us) { if (req.Form.Count == 0) { return ResponseStatus.REQFORM_COUNT_ISZERO; } else { string message = ""; VerifyUtil2 verify2 = new VerifyUtil2(); conTa_status.list_ErrMsg = new List<string>(); conTa_status.user = new UserStatus(); string userID = req.Form["userID"].ToString(); Rule[] rules = new Rule[] { Rule.REQUEST, Rule.DIGIT, Rule.LENGTH }; if (!verify2.Verify("学号", userID, rules, 10,10 , out message)) { conTa_status.list_ErrMsg.Add(message); } else { conTa_status.user.UserID = userID; } string pwd = req.Form["pwd"].ToString(); rules = new Rule[] { Rule.REQUEST, Rule.DIGITABC, Rule.LENGTH }; if (!verify2.Verify("密码", pwd, rules, 8, 16, out message)) { conTa_status.list_ErrMsg.Add(message); } else { pwd = MD5Factory.Instance().GetMd5Hash(pwd); conTa_status.user.Password = pwd; } if (conTa_status.list_ErrMsg.Count == 0) { conTa_status.list_ErrMsg = null; UserDAL userDAL = new UserDAL(); ResponseStatus resp = userDAL.Login(userID, pwd, ref us); userDAL.ReturnUnitToPool(); return resp; } else { return ResponseStatus.LOGIN_FAILED; } } }
//private static UserDAL userDal; //public static UserDAL Instance() //{ // if (userDal == null) // { // userDal = new UserDAL(); // } // return userDal; //} public bool CheckValid(UserStatus us) { dalBase.sql = "SELECT id FROM db_users WHERE id=@id AND stuNum=@stuNum AND depid=@depid"; dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@id",us.ID), new MySqlParameter("@stuNum",us.UserID), new MySqlParameter("@depid",us.Dep.ID) }; dalBase.Run(Behavious.SELECT_WITH_MUTIPARAM, false); bool flag = dalBase.DataRead.HasRows; dalBase.CloseConnect(); return flag; }
public void Add(UserStatus user) { dalBase.sql = string.Format("INSERT INTO db_users (stuNum,stuName,depid,grdid,collageid,phone,passwords,sex)" + "VALUES(@stuNum,@stuName,@depid,@grdid,@collageid,@phone,@passwords,@sex)"); dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@stuNum",user.UserID), new MySqlParameter("@stuName",user.UserName), new MySqlParameter("@depid",user.Dep.ID), new MySqlParameter("@grdid",user.Grd.ID), new MySqlParameter("@collageid",user.Clg.ID), new MySqlParameter("@phone",user.Phone), new MySqlParameter("@passwords",user.Password), new MySqlParameter("@sex",user.Sex) }; dalBase.Run(Behavious.INSERT_OR_UPDATE_OR_DELETE,true); }
public ResponseStatus Login(string userID, string psw, ref UserStatus us) { dalBase.sql = string.Format("SELECT id,stuNum,stuName,db_users.depid,isWaitForPass FROM db_users,db_department " + "WHERE db_users.depid=db_department.depid " + "AND stuNum=@stuNum AND passwords=@passwords");//可能有变化,先这么写着 dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@stuNum",userID), new MySqlParameter("@passwords",psw) }; dalBase.Run(Behavious.SELECT_WITH_MUTIPARAM,false); if (!dalBase.DataRead.HasRows) { us = null; dalBase.CloseConnect(); return ResponseStatus.NOT_REGISTER; } while (dalBase.DataRead.Read()) { if (Convert.ToBoolean(dalBase.DataRead["isWaitForPass"]) == false) { us = null; dalBase.CloseConnect(); return ResponseStatus.NOT_PASS; } us = new UserStatus() { ID = Convert.ToInt32(dalBase.DataRead["id"]), UserID = dalBase.DataRead["stuNum"].ToString(), UserName = dalBase.DataRead["stuName"].ToString(), Dep = new Department() { ID = Convert.ToInt32(dalBase.DataRead["depid"]) } }; } dalBase.CloseConnect(); return ResponseStatus.SUCCESS; }
public void Select(HttpRequestBase req, Container_List_FreeTime container_list_free) { TmTab_ResearchCon tmTab_RC = new TmTab_ResearchCon(); //1,2,3,4,5,6,7 tmTab_RC.WeekStart = !string.IsNullOrEmpty(req.Form["weekStart"]) ? Convert.ToInt32(req.Form["weekStart"]) : 1; tmTab_RC.WeekEnd = !string.IsNullOrEmpty(req.Form["weekEnd"]) ? Convert.ToInt32(req.Form["weekEnd"]) : 7; //1,3,5,7,9,10,12 tmTab_RC.SectionStart = !string.IsNullOrEmpty(req.Form["sectionStart"]) ? Convert.ToInt32(req.Form["sectionStart"]) : 1; tmTab_RC.SectionEnd = !string.IsNullOrEmpty(req.Form["sectionEnd"]) ? Convert.ToInt32(req.Form["sectionEnd"]) : 12; object value = null; value = req.Form["grdID"]; UserStatus us = new UserStatus(); us.Grd = new Grade() { ID = !string.IsNullOrEmpty(value.ToString()) ? Convert.ToInt32(value) : 0 }; value = req.Form["collageID"]; us.Clg = new Collage() { ID = !string.IsNullOrEmpty(value.ToString()) ? Convert.ToInt32(value) : 0 }; value = req.Form["depID"]; us.Dep = new Department() { ID = !string.IsNullOrEmpty(value.ToString()) ? Convert.ToInt32(value) : 0 }; tmTabDal = new TimeTableDAL(); tmTabDal.Select(us, tmTab_RC); tmTabDal.ReturnUnitToPool(); container_list_free.list_free = tmTabDal.list_free; }
private string GetCondition(UserStatus user) { string con = null; if (user.Clg.ID != 0) { con += "AND db_collage.collageid =" + user.Clg.ID; } if (user.Dep.ID != 0) { con += "AND db_department.depid =" + user.Dep.ID; } if (user.Grd.ID != 0) { con += "AND db_grade.grdid =" + user.Grd.ID; } return con; }
public void Select(UserStatus user, TmTab_ResearchCon tmTab_RC) { Dictionary<int,string> dayDictionary = null; this.GetDays(tmTab_RC.WeekStart, tmTab_RC.WeekEnd,out dayDictionary); string strDay = null; foreach (var d in dayDictionary) { strDay += d.Value + ","; } string con = this.GetCondition(user); dalBase.sql = "SELECT db_users.id,db_users.stuNum,db_users.stuName,db_users.phone," + "db_users.sex,db_users.short_phone," + //"db_collage.collagename,db_grade.grdname,db_department.depname" + strDay + "db_user_timetable.class " + "FROM db_users,db_collage,db_department,db_grade,db_user_timetable " + "WHERE db_users.collageid = db_collage.collageid " + "AND db_users.depid = db_department.depid " + "AND db_users.grdid = db_grade.grdid " + "AND db_users.id = db_user_timetable.id " + "AND db_user_timetable.class BETWEEN @classStart AND @classEnd " + con; //+ "ORDER BY db_user_timetable.class"//+ " GROUP BY db_user_timetable.class " dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@classStart",tmTab_RC.SectionStart), new MySqlParameter("@classEnd",tmTab_RC.SectionEnd) }; dalBase.Run(Behavious.SELECT_WITH_MUTIPARAM, false); list_free.Clear(); while (dalBase.DataRead.Read()) { int id = Convert.ToInt32(dalBase.DataRead["id"]); string section = Convert.ToString(dalBase.DataRead["class"]); string day; string free = section; int freeCount = 0; foreach(var d in dayDictionary) { day = Convert.ToString(d.Value); if (Convert.ToChar(dalBase.DataRead[day]) == '0') { free += "*" + d.Key; freeCount++; } } free += "#"; if (freeCount == 0) continue; UserFreeTime u_ft = list_free.Find(model => model.ID == id);; if (u_ft == null) { string a = dalBase.DataRead["sex"].ToString(); u_ft = new UserFreeTime() { ID = id, UserID = dalBase.DataRead["stuNum"].ToString(), UserName = dalBase.DataRead["stuName"].ToString(), Phone = dalBase.DataRead["phone"].ToString(), Phone_short = dalBase.DataRead["short_phone"].ToString(), Sex = Convert.ToByte(dalBase.DataRead["sex"]), FreeTime = free }; list_free.Add(u_ft); } else { u_ft.FreeTime += free; } } dalBase.CloseConnect(); }