pub.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
namespace 在线考试
{
    
    public class pub
    {
             SQLHelper db = new SQLHelper();
             //
             public string turn_depart(int c_id)
             {
                 string query = "select * from depart where depart_id=" + c_id;
                 DataTable d = db.ExecuteQuery(query, CommandType.Text);
                 return d.Rows[0]["depart"].ToString();
             }
        //
             public DataTable turn_kc(int kc_id)
             {
                 string query = "select * from kc where kc_id=" + kc_id;
                 DataTable d = db.ExecuteQuery(query, CommandType.Text);
                 return d;
             }
            //
             public DataTable turn_ti(int ti_id)
             {
                 string query = "select * from ti where ti_id=" + ti_id;
                 DataTable d = db.ExecuteQuery(query, CommandType.Text);
                 return d;
             }
             //
             public string tj_ti(int id)
             {
                 string query = "select count(*) as a from tp where ti_id=@id";
                 SqlParameter[] paras = new SqlParameter[] 
               { 
                  new SqlParameter("@id",id), 
               };
                 DataTable dt = db.ExecuteQuery(query, paras, CommandType.Text);
                 return dt.Rows[0]["a"].ToString();
             }
        //
             public string tj_xy(int id)
             {
                 string query ="select count(*) as b from tp where xy_id="+id;
                 DataTable d = db.ExecuteQuery(query, CommandType.Text);
                 return d.Rows[0]["b"].ToString();
             }
        //
             public int turn_price(int pro_id)
             {
                 string query = "select * from product where pro_id=" + pro_id;
                 DataTable d = db.ExecuteQuery(query, CommandType.Text);
                 return int.Parse(d.Rows[0]["price"].ToString());
             }
        //计算利润