stumclass.cs

一个班管理系统.用的存储过存和直接SQL语言.数据库:SQLServer 2

using System;
using System.Data.SqlClient;
using System.Data.Common;
using System.Windows.Forms;
using System.Data;
using System.Windows;

namespace WindowsApplication1
{

	/// <summary>
	/// stumclass 的摘要说明。
	/// </summary>
	public class stumclass
	{	
     	public System.Int32 f =0;
		public System.Data.DataSet ds = new System.Data.DataSet();
		public stumclass()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public void STMS_JCDELE(System.Int32 nuber)
		{
			try
			{

				System.Data.SqlClient.SqlConnection cn;
				string str ="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Student;Data Source=(local);";
				cn = new System.Data.SqlClient.SqlConnection(str);
				cn.Open();
				System.Data.SqlClient.SqlCommand cmd;
				cmd = new System.Data.SqlClient.SqlCommand("delete RePunishment where Student_NO = '"+ nuber +"'",cn);
				cmd.ExecuteNonQuery();
				MessageBox.Show("删除成功!");
				cn.Close();
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
		}
		public void STMS_JC(string stname,System.Int32 stno,string award,string pun,DateTime stdate,string term,Double awascore,Double punscore)
	  {
                    
			try
			{
				System.Data.SqlClient.SqlConnection cn;
				string str ="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=student;Data Source=(local);";
				cn = new System.Data.SqlClient.SqlConnection(str);
				cn.Open();
				System.Data.SqlClient.SqlCommand cmd;
				cmd = new System.Data.SqlClient.SqlCommand("insert into RePunishment(Student_name,Student_No,Awards,PunItem,StDate,Term,AwardsSore,PunItemScore) VALUES ('"+stname +"','"+ stno+"','" + award +"','"+ pun +"','"+ stdate+"','"+  term  +"','"+awascore +"','"+ punscore +"')",cn);
				cmd.ExecuteNonQuery();
				MessageBox.Show("添加成功!");
				cn.Close();
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}			   
		}
		public void STMS_Dbkation(string use ,string pad,System.Int32 strno)
		{
		    SqlConnection cn;
		    System.Data.SqlClient.SqlDataAdapter da = new SqlDataAdapter();
			System.Data.SqlClient.SqlCommand cmd = new SqlCommand();
			cn = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Student;Data Source=(local);");
			try
			{
				if (f==0)
				{
                cmd = new SqlCommand("dbo.STMS_Dbkation",cn);
				cmd.CommandType =CommandType.StoredProcedure;
                cmd.Parameters.Add("@useval",SqlDbType.VarChar ,20);
                cmd.Parameters["@useval"].Value =use;
				cmd.Parameters.Add("@usepawd",SqlDbType.VarChar ,20);
				cmd.Parameters["@usepawd"].Value =pad;
                da.SelectCommand =cmd;
				}
				else if(f==1)
				{
					cmd = new SqlCommand("dbo.stunoque",cn);
					cmd.CommandType =CommandType.StoredProcedure;
					cmd.Parameters.Add("@stno",SqlDbType.Int ,4);
					cmd.Parameters["@stno"].Value = strno;
					da.SelectCommand =cmd;
				}
		    da.Fill(ds); 
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
	}	
}
	
		
	}
}