score.cs

简单的系统评分源代码

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Text;
//５1ａsｐｘ
/// <summary>
/// score 的摘要说明
/// </summary>
public class score
{
	public score()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 输入值
    /// </summary>
    /// <param name="id">学号</param>
    /// <param name="name">姓名</param>
    /// <param name="score">评分</param>
    public void InsertData(int id,string name,double grading)
    {
        string StrCommand = "insert into db_Grade(db_ID,db_Name,db_Grading)values('"+id+"','"+name+"','"+grading+"')";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;


        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 填充数据集
    /// </summary>
    /// <param name="_Table">信息表</param>
    /// <returns>返回数据集</returns>
    public DataSet SelectData(string _Table)
    {
        string StrCommand = "select * from db_Grade order by db_Grading DESC";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;


        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
            OleDbDataAdapter da = new OleDbDataAdapter(oleCommand);
            DataSet ds = new DataSet();
            da.Fill(ds, _Table);
            return ds;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 删除数据
    /// </summary>
    /// <param name="id">学号</param>
    /// <param name="_Table">信息表</param>
    /// <returns>返回数据集</returns>
    public DataSet DeleteData(int id,string _Table)
    {
        string StrCommand = "delete from db_Grade where db_ID = "+id+"";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;


        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
            OleDbDataAdapter da = new OleDbDataAdapter(oleCommand);
            DataSet ds = new DataSet();
            da.Fill(ds,"_Table");
            return ds;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// SUM
    /// </summary>
    /// <param name="DataTotal"></param>
    public String TotalData(String StrSum)
    {
        string StrCommand = "select sum(db_Grading) As TotalGrading from db_Grade ";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        OleDbDataReader dr = oleCommand.ExecuteReader();
        try
        {
            while (dr.Read())
            {
                StrSum = dr["TotalGrading"].ToString();
            }
            return StrSum;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            dr.Close();
            oleCommand.Dispose();
            oleConnection.Close();
        }

    }
    /// <summary>
    /// 数据行
    /// </summary>
    /// <param name="StrSum"></param>
    /// <returns></returns>
    public String CountData(String StrCount)
    {
        string StrCommand = "select Count(*) As CountRow from db_Grade ";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        OleDbDataReader dr = oleCommand.ExecuteReader();
        try
        {
            while (dr.Read())
            {
                StrCount = dr["CountRow"].ToString();
            }
            return StrCount;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            dr.Close();
            oleCommand.Dispose();
            oleConnection.Close();
        }

    }
    /// <summary>
    /// 验证用户ID是否存在
    /// </summary>
    /// <param name="id">学号</param>
    /// <returns>返回布尔型</returns>
    public bool iExistID(String ID)
    {
        string AJX_id = ID;
        string StrCommand = "select * from db_Grade where db_ID = " + AJX_id + "";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        OleDbDataReader dr = oleCommand.ExecuteReader();

        try
        {
            if (dr.Read())
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            dr.Close();
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 验证用户姓名是否存在
    /// </summary>
    /// <param name="Name">姓名</param>
    /// <returns>返回布尔型</returns>
    public bool iExistName(String Name)
    {
        string AJX_Name = Name;
        string StrCommand = "select * from db_Grade where db_Name = '" + AJX_Name + "'";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        OleDbDataReader dr = oleCommand.ExecuteReader();

        try
        {
            if (dr.Read())
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            dr.Close();
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 导入数据
    /// </summary>
    /// <param name="data">数据</param>
    public void InsertScore(int id,int data,String groupLeader)
    {
        int _data = data;
        string StrCommand = "insert into db_Grade(db_GroupID,db_Score,db_LeaderName)values('"+id+"','"+_data+"','"+groupLeader+"')";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 清除表中的数据
    /// </summary>
    /// <param name="abc"></param>
    public void DeleteScore()
    {
        string StrCommand = "delete * from db_Grade";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 登记组号
    /// </summary>
    /// <param name="_groupNumber">组号</param>
    /// <param name="_groupLeader">组长</param>
    public void InsertNumber(int _groupNumber, string _groupLeader)
    {
        string StrCommand = "insert into db_Group(db_GroupID,db_LeaderName)Values('" + _groupNumber + "','" + _groupLeader + "')";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
    /// <summary>
    /// 获得组号
    /// </summary>
    /// <param name="id">组号</param>
    /// <param name="groupLeader">组长</param>
    /// <param name="_Table">信息表</param>
    /// <returns>返回数据集</returns>
    public DataSet getNumber(int id,String _Table)
    {
        string StrCommand = "select db_GroupID,db_LeaderName from db_Group Where db_GroupID = "+id+"";
        OleDbConnection oleConnection = new OleDbConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dpPath"]).ToString() + ";");
        OleDbCommand oleCommand = oleConnection.CreateCommand();
        oleCommand.CommandText = StrCommand;
        oleConnection.Open();
        try
        {
            oleCommand.ExecuteNonQuery();
            OleDbDataAdapter da = new OleDbDataAdapter(oleCommand);
            DataSet ds = new DataSet();
            da.Fill(ds,_Table);
            return ds;
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            oleCommand.Dispose();
            oleConnection.Close();
        }
    }
}