public int StudentDel(Model.StudentModel st)
{
Student est = new Student()
{
Id = st.Id
};
return(Delete(est));
}
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();
}
//Search:
public DataTable SearchStuInfo(StudentModel objStudentModel)
{
//string SqlString = "Select * From Student Where StuNum='" + objStudentModel.StuNum + "'";
// string SqlString = "Select * From V_Student_All_Info where 班级='11应用嵌入式班'";
string SqlString = "Select * From V_Student_All_Info where 学号='"+objStudentModel.StuNum+"'or 学生姓名='"+objStudentModel.StuName+"'or 班级='"+objStudentModel.ClaName+"'";
return (objDataBaseOperateClass2.ShowTable(SqlString));
}
private void btnClear_Click(object sender, EventArgs e)
{
#region 把编辑框的内容内容转成一个消息框弹出：
StudentModel objStudentModel = new StudentModel();
objStudentModel.StuNum = txtStuNum.Text;
objStudentModel.StuName = txtStuName.Text;
objStudentModel.StuSex = cbxStuSex.Text;
objStudentModel.Birthday = dtBirthday.Value.ToString("yyy-mm-dd");
objStudentModel.Address = txtAddress.Text;
string OutString = "姓名:" + objStudentModel.StuName + "\n";
OutString += "学号：" + objStudentModel.StuNum + "\n";
OutString += "性别:" + objStudentModel.StuSex + "\n";
OutString += "出生日期：" + objStudentModel.Birthday + "\n";
OutString += "地址:" + objStudentModel.Address + "\n";
MessageBox.Show(OutString, "学生信息");
#endregion
}
//Add:
public bool InsertStudent(StudentModel objStudentModel)
{
//string SqlString ="Insert into Student(StuNum,StuName,StuSex,Policity,Birthday,Favor,StuScore,Meno,ClaNum,Phone,Address) Values('"+objStudentModel.StuNum+"','"+objStudentModel.StuName+"','"+objStudentModel.StuSex+"','"+objStudentModel.Policity+"','"+objStudentModel.Birthday+"','"+objStudentModel.Favor+"','"+objStudentModel.StuScore+"','"+objStudentModel.Meno+"','"+objStudentModel.ClaNum+"','"+objStudentModel.Phone+"','"+objStudentModel.Address+"')";
string SqlString = "Insert into V_Student_All_Info(学号,学生姓名,性别,出生日期,政治面目,班级编号,爱好,综合分,评价,联系电话,联系地址) Values('" + objStudentModel.StuNum + "','" + objStudentModel.StuName + "','" + objStudentModel.StuSex + "','" + objStudentModel.Birthday + "','" + objStudentModel.Policity + "','" + objStudentModel.ClaNum + "','" + objStudentModel.Favor + "','" + objStudentModel.StuScore + "','" + objStudentModel.Meno + "','" + objStudentModel.Phone + "','" + objStudentModel.Address + "')";
try
{
if (objDataBaseOperateClass2.GetExecute(SqlString))
return (true);
else
return (false);
}
catch(Exception e1)
{
MessageBox.Show("学号不能重复。\n请检查后再添加。"+e1);
return (false);
}
}
//Update:
public bool Updatestudent(StudentModel objStudentModel)
{
//StuNum='"+objStudentModel.StuNum+"',
string SqlString;
//SqlString = "update dbo.Student set StuName='"+objStudentModel.StuName+"',StuSex='"+objStudentModel.StuSex+"',Policity='"+objStudentModel.Policity+"',Birthday='"+objStudentModel.Birthday+"',Favor='"+objStudentModel.Favor+"',StuScore='"+objStudentModel.StuScore+"',Meno='"+objStudentModel.Meno+"',ClaNum='"+objStudentModel.ClaNum+"',Phone='"+objStudentModel.Phone+"',Address='"+objStudentModel.Address+"' where StuNum='"+objStudentModel.StuNum+"'";
SqlString = "update V_Student_All_Info set 学号='" + objStudentModel.StuNum + "',学生姓名='" + objStudentModel.StuName + "',性别='" + objStudentModel.StuSex + "',出生日期='" + objStudentModel.Birthday + "',政治面目='" + objStudentModel.Policity + "',班级编号='" + objStudentModel.ClaNum + "',爱好='" + objStudentModel.Favor + "',综合分='" + objStudentModel.StuScore + "',评价='" + objStudentModel.Meno + "',联系电话='" + objStudentModel.Phone + "',联系地址='" + objStudentModel.Address + "'where 学号='"+objStudentModel.StuNum+"'";
try
{
if (objDataBaseOperateClass2.GetExecute(SqlString))
return (true);
else
return (false);
}
catch (Exception e1)
{
MessageBox.Show("错误信息"+e1);
return (false);
}
}
public int updatestudent(StudentModel stuModel)
{
return new StudentService().update(stuModel);
}
public bool UpdateStudent(StudentModel objStudentModel)
{
return (objStudentDAL.Updatestudent(objStudentModel));
}
public DataTable SearchStuInfo(StudentModel objStudentModel)
{
return (objStudentDAL.SearchStuInfo(objStudentModel));
}
public bool InsertStudent(StudentModel objstudentClass1)
{
return (objStudentDAL.InsertStudent(objstudentClass1));
}
//学生列表编辑后保存
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("更新失败");
}
}
