public static bool DeleteSysMsg(SysMsg msg) { MySqlConnection mConnect = null; MySqlCommand mCommand = null; List <SysMsg> list = new List <SysMsg>(); try { mConnect = new MySqlConnection("server=localhost;user id=root;Password=;database=classroomad"); mCommand = new MySqlCommand(); mCommand.Connection = mConnect; mConnect.Open(); } catch { Console.WriteLine("FAILED to link MySQL in DeleteSysMsg(" + msg.Info + ")"); return(false); } mCommand.CommandText = "DELETE FROM SysMsg WHERE "; mCommand.CommandText += "sendId=" + msg.SendId + " and recvId=" + msg.RecvId + " and time = '" + msg.Time.ToString("yyyy-MM-dd") + "'" + " and info = '" + msg.Info + "';"; mCommand.Prepare(); int i = mCommand.ExecuteNonQuery(); mConnect.Close(); return(i > 0); }
public static bool SendSysMsg(SysMsg msg) { MySqlConnection mConnect = null; MySqlCommand mCommand = null; List <SysMsg> list = new List <SysMsg>(); try { mConnect = new MySqlConnection("server=localhost;user id=root;Password=;database=classroomad"); mCommand = new MySqlCommand(); mCommand.Connection = mConnect; mConnect.Open(); } catch { Console.WriteLine("FAILED to link MySQL in SendSysMsg(" + msg.Info + ")"); return(false); } mCommand.CommandText = "INSERT INTO SysMsg VALUES"; mCommand.CommandText += " (" + msg.SendId + ", " + msg.RecvId + ", '" + msg.Time.ToString("yyyy-MM-dd") + "', " + "'" + msg.Info + "');"; mCommand.Prepare(); int i = mCommand.ExecuteNonQuery(); mConnect.Close(); return(i > 0); }
private void TBDecline_MouseDown(object sender, MouseButtonEventArgs e) { if (DatabaseLinker.DeleteRent(rent)) { rent.GetApproved(); SysMsg msg = new SysMsg(0, rent.pId, DateTime.Now, "对不起, 您申请的课程 " + rent.rId + ", " + rent.Info + " 没有通过审核, 已被管理员删除."); DatabaseLinker.SendSysMsg(msg); MessageBox.Show("已删除课程."); this.Close(); } }
private void TBOK_MouseDown(object sender, MouseButtonEventArgs e) { if (DatabaseLinker.ApproveRent(rent)) { rent.GetApproved(); SysMsg msg = new SysMsg(0, rent.pId, DateTime.Now, "您申请的课程 " + rent.rId + ", " + rent.Info + " 已经通过审核."); DatabaseLinker.SendSysMsg(msg); MessageBox.Show("审核已通过."); this.Close(); } }
// 系统消息初始化 private void TextBlockMessageInitialize(TextBlock tb, SysMsg msg) { string sendName = DatabaseLinker.GetName(msg.SendId); tb.FontSize = 24; tb.Padding = new Thickness(16); tb.Inlines.Add(new Bold(new Run(sendName + ": (" + msg.Time.ToString("yyyy/MM/dd") + ")\r\n"))); tb.Inlines.Add(new Run(" " + msg.Info)); tb.TextWrapping = TextWrapping.Wrap; // tb.MouseEnter += tbRent_MouseEnter; // tb.MouseLeave += tbRent_MouseLeave; tb.Tag = msg; }
private void GridMessage_Loaded(object sender, RoutedEventArgs e) { listSysMsg = DatabaseLinker.GetPersonSysMsgList(person.pId); for (int i = listSysMsg.Count - 1; i >= 0; --i) { SysMsg msg = listSysMsg[i]; TextBlock tb = new TextBlock(); TextBlockMessageInitialize(tb, msg); stackPanelMessage.Children.Add(tb); } if (person.pId == 0) { List <Rent> listRent = DatabaseLinker.GetUnapprovedRentTable(); foreach (Rent r in listRent) { TextBlock tb = new TextBlock(); TextBlockUnapprovedRentInitialize(tb, r); stackPanelMessage.Children.Add(tb); } } }
private void TBOK_MouseDown(object sender, MouseButtonEventArgs e) { if (DatabaseLinker.ApproveRent(rent)) { rent.GetApproved(); SysMsg msg = new SysMsg(0, rent.pId, DateTime.Now, "您申请的课程 " + rent.rId + ", " + rent.Info + " 已经通过审核."); DatabaseLinker.SendSysMsg(msg); MessageBox.Show("审核已通过."); this.Close(); } }
private void TBDecline_MouseDown(object sender, MouseButtonEventArgs e) { if (DatabaseLinker.DeleteRent(rent)) { rent.GetApproved(); SysMsg msg = new SysMsg(0, rent.pId, DateTime.Now, "对不起, 您申请的课程 " + rent.rId + ", " + rent.Info + " 没有通过审核, 已被管理员删除."); DatabaseLinker.SendSysMsg(msg); MessageBox.Show("已删除课程."); this.Close(); } }
// 系统消息初始化 private void TextBlockMessageInitialize(TextBlock tb, SysMsg msg) { string sendName = DatabaseLinker.GetName(msg.SendId); tb.FontSize = 24; tb.Padding = new Thickness(16); tb.Inlines.Add(new Bold(new Run(sendName + ": ("+msg.Time.ToString("yyyy/MM/dd")+")\r\n"))); tb.Inlines.Add(new Run(" " + msg.Info)); tb.TextWrapping = TextWrapping.Wrap; // tb.MouseEnter += tbRent_MouseEnter; // tb.MouseLeave += tbRent_MouseLeave; tb.Tag = msg; }
public static bool SendSysMsg(SysMsg msg) { MySqlConnection mConnect = null; MySqlCommand mCommand = null; List<SysMsg> list = new List<SysMsg>(); try { mConnect = new MySqlConnection("server=localhost;user id=root;Password=;database=classroomad"); mCommand = new MySqlCommand(); mCommand.Connection = mConnect; mConnect.Open(); } catch { Console.WriteLine("FAILED to link MySQL in SendSysMsg(" + msg.Info + ")"); return false; } mCommand.CommandText = "INSERT INTO SysMsg VALUES"; mCommand.CommandText += " (" + msg.SendId + ", " + msg.RecvId + ", '" + msg.Time.ToString("yyyy-MM-dd") + "', " + "'" + msg.Info + "');"; mCommand.Prepare(); int i = mCommand.ExecuteNonQuery(); mConnect.Close(); return i > 0; }
public static bool DeleteSysMsg(SysMsg msg) { MySqlConnection mConnect = null; MySqlCommand mCommand = null; List<SysMsg> list = new List<SysMsg>(); try { mConnect = new MySqlConnection("server=localhost;user id=root;Password=;database=classroomad"); mCommand = new MySqlCommand(); mCommand.Connection = mConnect; mConnect.Open(); } catch { Console.WriteLine("FAILED to link MySQL in DeleteSysMsg(" + msg.Info + ")"); return false; } mCommand.CommandText = "DELETE FROM SysMsg WHERE "; mCommand.CommandText += "sendId=" + msg.SendId + " and recvId=" + msg.RecvId + " and time = '" + msg.Time.ToString("yyyy-MM-dd") + "'" + " and info = '" + msg.Info + "';"; mCommand.Prepare(); int i = mCommand.ExecuteNonQuery(); mConnect.Close(); return i > 0; }