App_Code/BaseClass.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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.SqlClient;
/// <summary>
/// BaseClass 的摘要说明
/// </summary>
public class BaseClass
{
    public BaseClass()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    
    private static SqlConnection connection;
    public static SqlConnection DBCon()
    {

        //return new SqlConnection("server=.;database=db_ExamOnline;uid=sa;pwd=111111");
        string connectionString = ConfigurationManager.ConnectionStrings["db_ExamOnlineConnectionString1"].ConnectionString;
        connection = new SqlConnection(connectionString);
        return connection;
    }

    public static void BindDG(GridView dg, string id, string strSql, string Tname)
    {
        SqlConnection conn = DBCon();
        SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, Tname);
        dg.DataSource = ds.Tables[Tname];
        dg.DataKeyNames = new string[] { id };
        dg.DataBind();
    }
    public static int OperateData(string strsql)
    {
        SqlConnection conn = DBCon();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql, conn);
        int count = cmd.ExecuteNonQuery();
        return count;
        conn.Close();
    }
    //================如果是学生登录======================
    public static bool CheckStudent(string studentNum, string studentPwd)
    {

        string sql = "select count(*) from tb_Student where StudentNum=@stunum and StudentPwd=@stupwd ";
        SqlParameter[] sp = new SqlParameter[2];
        sp[0] = new SqlParameter("@stunum", studentNum);
        sp[1] = new SqlParameter("@stupwd", studentPwd);
        int i = Convert.ToInt32(PetShop.DBUtility.SqlHelper.ExecuteScalar(BaseClass.DBCon(), CommandType.Text, sql, sp));