public int AddSave(Book.Model.T_Base_User book) { Book.DAL.T_Base_User bookAddSave = new DAL.T_Base_User(); int result = bookAddSave.AddSave(book); return(result); }
public int GetCount() { Book.DAL.T_Base_User dal = new DAL.T_Base_User(); int result = dal.GetCount(); return(result); }
public List <Book.Model.T_Base_User> GetList(int PageNumber, int PageSize) { Book.DAL.T_Base_User dal = new DAL.T_Base_User(); List <Book.Model.T_Base_User> list = dal.GetList(PageNumber, PageSize); return(list); }
public int Delete(string[] Ids) { //防止注入式漏洞 string ids = string.Join(",", Ids); Book.DAL.T_Base_User dal = new DAL.T_Base_User(); return(dal.Delete(ids)); }
/// <summary> /// 审核处理 /// </summary> /// <param name="ApplyId"></param> /// <param name="LectureId"></param> /// <param name="State"></param> /// <param name="Num"></param> /// <param name="Reason"></param> /// <returns></returns> public int Review_Updata(int ApplyId, int LectureId, int State, string Num, string ReviewNum, string Reason = "") { SqlConfig config = new SqlConfig(); SqlCommand cmd = config.getSqlCommand(); SqlDataReader reader; cmd.CommandText = "select State from T_Base_Lecture Where Id = " + LectureId; int oldState = (int)cmd.ExecuteScalar(); cmd.CommandText = "update T_Base_Lecture set State = " + State + " where T_Base_Lecture.Id = " + "(select LectureId from T_Base_Apply where T_Base_Apply.Id = " + ApplyId + ")"; int result = cmd.ExecuteNonQuery(); if (State == 2) { cmd.CommandText = "insert into T_Base_Audit values('" + Num + "'," + LectureId + ",'" + Reason + "','" + DateTime.Now + "','" + ReviewNum + "')"; result = cmd.ExecuteNonQuery(); } if (State == 1) { //更新二维码 QRCodeSave("" + LectureId); cmd.CommandText = "update T_Base_Lecture set QRCode = " + LectureId + " where Id = " + LectureId; cmd.ExecuteNonQuery(); //更新处理人账号 cmd.CommandText = "update T_Base_Apply set ReviewNum = '" + ReviewNum + "' where Id=" + ApplyId; cmd.ExecuteNonQuery(); } if (oldState == 3 && State == 1) { //通知报名人员 cmd.CommandText = "select Subject,ExpectPeople,RealPeople from T_Base_Lecture where Id = " + LectureId; reader = cmd.ExecuteReader(); reader.Read(); string subject = Convert.ToString(reader["Subject"]); int expectPeople = Convert.ToInt16(reader["ExpectPeople"]); int realPeople = Convert.ToInt16(reader["RealPeople"]); reader.Close(); //获取报名参加人员 cmd.CommandText = "select Num from T_Base_Order where LectureId = " + LectureId; reader = cmd.ExecuteReader(); List <Model.T_Base_Order> listOrder = new List <Model.T_Base_Order>(); while (reader.Read()) { Model.T_Base_Order order = new Model.T_Base_Order(); Model.T_Base_User user = new DAL.T_Base_User().GetUser(Convert.ToString(reader["Num"])); order.User = user; listOrder.Add(order); } reader.Close(); //发送消息 for (int i = 0; i < listOrder.Count; i++) { MailMessage mailMessage = new MailMessage(); mailMessage.From = new MailAddress("*****@*****.**"); mailMessage.To.Add(new MailAddress("*****@*****.**")); //mailMessage.To.Add(listOrder[i].Num+"@stu.wzu.edu.cn"); mailMessage.Subject = subject + "地点变更通知"; mailMessage.Body = "您所报名参加的讲座" + subject + "信息发生变更,请注意查看"; SmtpClient client = new SmtpClient(); client.Host = "smtp.wzu.edu.cn"; client.EnableSsl = false; client.UseDefaultCredentials = false; client.Credentials = new NetworkCredential("*****@*****.**", "b5ZF36PPMMmCF883"); client.Send(mailMessage); } } return(result); }
public List <Book.Model.T_Base_User> GetList(int CurrentPage, int PageSize) { Book.DAL.T_Base_User dal = new DAL.T_Base_User(); return(dal.GetList(CurrentPage, PageSize)); }
public int GetCount() { Book.DAL.T_Base_User dal = new DAL.T_Base_User(); return(dal.GetCount()); }
public List <Model.T_Base_User> GetSearch(string query, int mathCount) { DAL.T_Base_User dal = new DAL.T_Base_User(); return(dal.GetSearch(query, mathCount)); }
public void AlterSave(Model.T_Base_User alterBook) { Book.DAL.T_Base_User dll = new DAL.T_Base_User(); dll.AlterSave(alterBook); }
public Book.Model.T_Base_User Alter(int Id) { Book.DAL.T_Base_User dal = new DAL.T_Base_User(); return(dal.Alter(Id)); }