App_Code/Job.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 ;
using System.Collections;


/// <summary>
/// Job 的摘要说明
/// </summary>
public class Job
{
    private SqlConnection fmyConn;
    public SqlConnection myConn
    {
        get
        {
            return fmyConn;
        }
        
    }
	public Job()
	{
        fmyConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strconnection"]);
        myConn.Open();
	}
    public DataSet GetResult(string sql) 
    {
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter(sql, fmyConn);
        sda.Fill(ds);
        return ds;
    }
    public SqlDataReader GetReaderResult(string sql)
    {
        SqlCommand scomm = new SqlCommand(sql, fmyConn);
        return scomm.ExecuteReader();
    }
    public DataSet GetResult(string sql,Parameters parameter)
    {
        DataSet ds = new DataSet();
        SqlCommand sc = new SqlCommand(sql, fmyConn);
        foreach (ParameterString pstring in parameter .List  )
        {
            sc.Parameters.Add(pstring .Parameter ,pstring.Value );

        }
        SqlDataAdapter sda = new SqlDataAdapter(sc);
        sda.Fill(ds);
        return (ds);
    }
    public SqlDataReader GetReaderResult(string sql, Parameters parameter)
    {
        SqlCommand sc = new SqlCommand(sql, fmyConn);