private void button1_Click(object sender, EventArgs e)
{
if (this.tb_stunum.Text != "" && this.tb_sname.Text != "" && (this.radioButton1.Checked || this.radioButton2.Checked) && this.comboBox1.Text != "请选择年份" && this.comboBox2.Text != "请选择学院")
{
stunum = this.tb_stunum.Text;
sname = this.tb_sname.Text;
if (this.radioButton1.Checked)
gender = 1;
else
gender = 0;
startyear = this.comboBox1.Text;
collegeid = int.Parse(this.comboBox2.SelectedValue.ToString());
int sid = 0 ;
StudentBusiness addStudentBusiness = new StudentBusiness();
sid = addStudentBusiness.addstudent(stunum, sname, gender, startyear, collegeid);
if (sid != 0)
{
MessageBox.Show("成功!");
}
else
{
MessageBox.Show("失败，请重试!");
}
this.Dispose();
}
else
{
MessageBox.Show("请填写所有信息！");
}
}
public JsonResult Delete(string id)
{
string Message = string.Empty;
bool Error = false;
try
{
Business.StudentBusiness student = new Business.StudentBusiness();
if (!String.IsNullOrEmpty(id))
{
int identifier = int.Parse(id);
student.Delete(identifier);
}
else
{
Error = true;
Message = "El Identificador del studiante no puede ser nulo";
}
}
catch (Exception ex)
{
Message = ex.Message;
Error = true;
}
return(Json(new { Message = Message, Error = Error }, JsonRequestBehavior.AllowGet));
}
public FmStudentMain(FmLogin fmLogin, UserModel userModel)
{
InitializeComponent();
this.fmLogin = fmLogin;
this.userModel = userModel;
StudentBusiness sBusiness = new StudentBusiness();
this.studentModel = sBusiness.getStuBySid(sBusiness.getSidByUid(userModel.Uid));
fmLogin.Hide();
}
public JsonResult List(jQueryDataTableParamModel param)
{
Business.StudentBusiness student = new Business.StudentBusiness();
List <string[]> data = new List <string[]>();
var studentList = student.GetAll();
foreach (Domain.Students item in studentList)
{
data.Add(new string[] { item.Id + string.Empty, item.firstName, item.lastName, item.age + string.Empty, item.gender, item.phoneNumber, "" });
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = 10,
iTotalDisplayRecords = 3,
aaData = data
},
JsonRequestBehavior.AllowGet));
}
public JsonResult Update(string id, string name, string lastName, string gender, string age, string phone)
{
string Message = string.Empty;
name = name.Replace('%', ' ');
lastName = lastName.Replace('%', ' ');
bool Error = false;
try
{
Business.StudentBusiness student = new Business.StudentBusiness();
if (!String.IsNullOrEmpty(id))
{
int identifier = int.Parse(id);
Students entity = new Students
{
Id = identifier,
firstName = name,
lastName = lastName,
gender = gender,
age = int.Parse(age),
phoneNumber = phone
};
student.Update(entity);
}
else
{
Error = true;
Message = "El Identificador del studiante no puede ser nulo";
}
}
catch (Exception ex)
{
Message = ex.Message;
Error = true;
}
return(Json(new { Message = Message, Error = Error }, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(StudentViewModel model)
{
try
{
if (ModelState.IsValid)
{
Business.StudentBusiness student = new Business.StudentBusiness();
Domain.Students newStudent = new Domain.Students
{
firstName = model.firstName,
lastName = model.lastName,
age = model.age,
gender = model.gender,
phoneNumber = model.phoneNumber
};
student.Save(newStudent);
}
else
{
foreach (var item in ModelState.AsQueryable().ToList())
{
if (item.Value.Errors.Count > 0)
{
ModelState.AddModelError("Error", item.Value.Errors.First().ErrorMessage + string.Empty);
}
}
}
return(RedirectToAction("Index", model));
}
catch (Exception ex)
{
ModelState.AddModelError("Error", ex.Message);
return(View(model));
}
}
//显示最新的课表
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
//MessageBox.Show(this.tabControl1.SelectedIndex.ToString());
switch (this.tabControl1.SelectedIndex)
{
case 0: break;
//刷新选课列表
case 1: this.btn_refreshCL_Click(null, null); break;
//刷新已选课
case 2: this.button3_Click(null, null); break;
//刷新我的课表
case 3:
int sid = new StudentBusiness().getSidByUid(userModel.Uid);
List<CourseInfo> courseInfoList = new GetTimetableBusiness().getTimetable(this.studentModel.Sid);
int section = 0;
if (courseInfoList != null)
{
foreach (CourseInfo courseInfo in courseInfoList)
{
section = courseInfo.sectionNom;
((System.Windows.Forms.Label)(this.Controls.Find("lb_" + section.ToString(), true)[0])).Text = courseInfo.getCourseInfo();
}
}
this.tabPage3.Refresh();
break;
case 4: break;
}
}
//学生列表编辑后保存
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
StudentModel stuModelToBeUpdated = new StudentModel();
StudentBusiness stuBusiness = new StudentBusiness();
//int sid = int.Parse(this.dataGridView1.CurrentRow.Cells["sid"].Value.ToString());
stuModelToBeUpdated.Sid = int.Parse(this.dataGridView1.CurrentRow.Cells["sid"].Value.ToString());
stuModelToBeUpdated.Stunum = this.dataGridView1.CurrentRow.Cells["stunum"].Value.ToString();
stuModelToBeUpdated.Sname = this.dataGridView1.CurrentRow.Cells["sname"].Value.ToString();
stuModelToBeUpdated.Startyear = this.dataGridView1.CurrentRow.Cells["startyear"].Value.ToString();
stuModelToBeUpdated.Gender = this.dataGridView1.CurrentRow.Cells["gender"].Value.ToString() == "男" ? 1 : 0;
if (this.dataGridView1.CurrentCell.ColumnIndex == this.dataGridView1.Columns["collegeid"].Index)
{
stuModelToBeUpdated.Collegeid = int.Parse(this.dataGridView1.CurrentRow.Cells["collegeid"].Value.ToString());
}
else
{
stuModelToBeUpdated.Collegeid = int.Parse(this.dataGridView1.CurrentRow.Cells["college_id"].Value.ToString());
}
//stuModelToBeUpdated = stuBusiness.getStuBySid(sid);
int result = stuBusiness.updatestudent(stuModelToBeUpdated);
if (result != 0)
{
MessageBox.Show("更新成功");
}
else
{
MessageBox.Show("更新失败");
}
}
//删除学生按钮
private void button7_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要删除吗？", "询问", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
bool isDeleteOk = true;
StudentBusiness stuBusiness = new StudentBusiness();
DataGridViewSelectedRowCollection toBeDeletedRowsCollection = this.dataGridView1.SelectedRows;
DataGridViewRow[] tobedeletedrows = new DataGridViewRow[toBeDeletedRowsCollection.Count];
toBeDeletedRowsCollection.CopyTo(tobedeletedrows, 0);
foreach (DataGridViewRow temp in tobedeletedrows)
{
if (stuBusiness.deleteStudent(int.Parse(temp.Cells["sid"].Value.ToString())) == 0)
isDeleteOk = false;
}
if (isDeleteOk)
{
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除出现错误，请刷新列表后重试！");
}
}
}
//刷新学生列表
private void button6_Click(object sender, EventArgs e)
{
StudentBusiness stuBusiness = new StudentBusiness();
DataTable dt = stuBusiness.getAllStudent();
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = dt;
DataGridViewComboBoxColumn cob = new DataGridViewComboBoxColumn();
cob = (DataGridViewComboBoxColumn)this.dataGridView1.Columns["collegeid"];
cob.DataSource = new CollegeBusiness().getAllCollege();
cob.DisplayMember = "cname";
cob.ValueMember = "cid";
}
