private void TBChoose_MouseDown(object sender, MouseButtonEventArgs e) { if (TBinfo.Text.Trim() == "") { MessageBox.Show("活动名称不能为空。"); return; } if (TBinfo.Text.Length > 140) { MessageBox.Show("活动名称过长。"); return; } RentTime rt = new RentTime(date, date, 0, classStart, classEnd); Rent r = new Rent(0, TBinfo.Text, classroom.cId, person.pId, false, rt); if (DatabaseLinker.SetRent(r)) { MessageBox.Show("活动申请已发送。"); father.RefreshSchedule(); this.Close(); } else { MessageBox.Show("活动申请发送失败。"); } }
protected RentTime time; //占用的时间 #endregion Fields #region Constructors // public List<int> Students; public Rent(int id, string info, int classroomId, int host ,bool approved, RentTime time) { this.rid = id; this.info = info; this.cid = classroomId; this.approved = approved; this.pid = host; this.time = time; }
} // 活动概述 // public List<int> Students; public Rent(int id, string info, int classroomId, int host, bool approved, RentTime time) { this.rid = id; this.info = info; this.cid = classroomId; this.approved = approved; this.pid = host; this.time = time; }
//Get rent and RentTable public static Rent GetRent(int rId) { MySqlConnection mConnect = null; MySqlCommand mCommand = null; int cId = 0, pId = 0; bool approved = true; string info = ""; RentTime rentTime; 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 GetRent(" + rId + ")"); return(null); } mCommand.CommandText = "SELECT * FROM rent WHERE "; mCommand.CommandText += " rId = " + rId + ";"; MySqlDataReader mReader = mCommand.ExecuteReader(); while (mReader.Read()) { cId = int.Parse(mReader["cId"].ToString()); if (!int.TryParse(mReader["pId"].ToString(), out pId)) { pId = 0; } approved = "True" == mReader["approved"].ToString(); info = mReader["info"].ToString(); rentTime = new RentTime( mReader["startDate"].ToString(), mReader["endDate"].ToString(), int.Parse(mReader["cycDays"].ToString()), int.Parse(mReader["startClass"].ToString()), int.Parse(mReader["endClass"].ToString()) ); mConnect.Close(); return(new Rent(rId, info, cId, pId, approved, rentTime)); } mConnect.Close(); return(null); }
//Get rent and RentTable public static Rent GetRent(int rId) { MySqlConnection mConnect = null; MySqlCommand mCommand = null; int cId = 0, pId = 0; bool approved = true; string info = ""; RentTime rentTime; 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 GetRent(" + rId + ")"); return null; } mCommand.CommandText = "SELECT * FROM rent WHERE "; mCommand.CommandText += " rId = " + rId + ";"; MySqlDataReader mReader = mCommand.ExecuteReader(); while (mReader.Read()) { cId = int.Parse(mReader["cId"].ToString()); pId = int.Parse(mReader["pId"].ToString()); approved = "True" == mReader["approved"].ToString(); info = mReader["info"].ToString(); rentTime = new RentTime( mReader["startDate"].ToString(), mReader["endDate"].ToString(), int.Parse(mReader["cycDays"].ToString()), int.Parse(mReader["startClass"].ToString()), int.Parse(mReader["endClass"].ToString()) ); mConnect.Close(); return new Rent(rId, info, cId, pId, approved, rentTime); } mConnect.Close(); return null; }
private void TBChoose_MouseDown(object sender, MouseButtonEventArgs e) { if (TBinfo.Text.Trim()=="") { MessageBox.Show("活动名称不能为空。"); return; } if (TBinfo.Text.Length>140) { MessageBox.Show("活动名称过长。"); return; } RentTime rt = new RentTime(date, date, 0, classStart, classEnd); Rent r = new Rent(0, TBinfo.Text, classroom.cId, person.pId, false, rt); if (DatabaseLinker.SetRent(r)) { MessageBox.Show("活动申请已发送。"); father.RefreshSchedule(); this.Close(); } else MessageBox.Show("活动申请发送失败。"); }