/// <summary>
/// 讲座出现变更通知
/// </summary>
/// <param name="Num"></param>
/// <returns></returns>
public List <Model.T_Base_Order> GetOrderMsg(string Num)
{
List <Model.T_Base_Order> list = new List <Model.T_Base_Order>();
SqlConfig config = new DAL.SqlConfig();
SqlCommand cmd = config.getSqlCommand();
cmd.CommandText = "select * from V_Lecture_Order where Num='" + Num + "' and State = 1 and AlertFlag = 1 and MsgFlag = 0";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Order order = new Model.T_Base_Order();
order.Lecture = new Model.T_Base_Lecture();
order.LectureId = Convert.ToInt32(reader["LectureId"]);
order.Lecture.Subject = Convert.ToString(reader["Subject"]);
list.Add(order);
}
reader.Close();
cmd.CommandText = "select * from V_Lecture_Order where Num = '" + Num + "' and MsgFlag = 0 and result = 3";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Model.T_Base_Order order = new Model.T_Base_Order();
order.Lecture = new Model.T_Base_Lecture();
order.LectureId = Convert.ToInt32(reader["LectureId"]);
order.Lecture.Subject = Convert.ToString(reader["Subject"]);
order.Result = Convert.ToInt16(reader["Result"]);
list.Add(order);
}
reader.Close();
config.Close();
return(list);
}
/// <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);
}
