/// <summary> /// 删除学生 /// </summary> /// <param name="stu"></param> /// <returns></returns> public int DeleteStudent(student stu) { SqlConnection con = new SqlConnection(@"Data Source=WIN-L8SRCUH9LF2\JACK;Initial Catalog=StudentroomDB;Persist Security Info=True;User ID=sa;pwd=720713"); int ret=-1; SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "pro_deletestudent"; cmd.Parameters.Add("@StudentId", SqlDbType.Int).Value = stu.StudentId; try { con.Open(); ret = cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return ret; }
/// <summary> /// 是否缺勤 /// </summary> /// <returns></returns> public int cheackfee(student stu) { int ret = -1; SqlConnection con = new SqlConnection(@"Data Source=WIN-L8SRCUH9LF2\JACK;Initial Catalog=StudentroomDB;Persist Security Info=True;User ID=sa;pwd=720713"); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "dbo.StoredProcedure2"; cmd.Parameters.Add("@StudentId", SqlDbType.Int).Value = stu.StudentId; SqlParameter parret = new SqlParameter("@retvalues", SqlDbType.Int); parret.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(parret); try { con.Open(); cmd.ExecuteNonQuery(); ret = (int)parret.Value; } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return ret; }
public bool DeleteStudent(student stu) { int ret= studens.DeleteStudent(stu); if (ret == 1) { return true; } else return false; }
/// <summary> /// 查询具体学生缴费 /// </summary> /// <param name="fee"></param> /// <returns></returns> public bool cheackfee(student stu) { int ret = studens.cheackfee(stu); if (ret == 1) { return true; } else return false; }
public int GetStudent(student stu) { return studens.GetStudent(stu); }
public DataSet getallinfo(student stu) { return studens.getallinfo(stu); }
////////////////////////////////////////////////////////////////////////// public DataSet getallinfo(student stu) { SqlConnection con = new SqlConnection(@"Data Source=WIN-L8SRCUH9LF2\JACK;Initial Catalog=StudentroomDB;Persist Security Info=True;User ID=sa;pwd=720713"); DataSet dt = new DataSet(); SqlCommand cmd = new SqlCommand("dbo.GetAllInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@studentid", SqlDbType.Int).Value = stu.StudentId; //返回值 SqlDataAdapter adp = new SqlDataAdapter(); try { adp.SelectCommand = cmd; adp.Fill(dt, "infostudent"); } catch (Exception ex) { Console.WriteLine(ex.Message); } // int rettu = (int)parret.Value; return dt; }