sql_commands类

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>
/// fadataset 的摘要说明
/// </summary>
public class sql_commands
{
    [AjaxPro.AjaxMethod]

    public DataSet pagination(int pageid,string tbname,string jltj,string zsy)                                   //数据集框架
{
        string Con = ConfigurationManager.ConnectionStrings["spjkconn"].ConnectionString;

        SqlConnection conn = new SqlConnection(Con);

        SqlDataAdapter da = new SqlDataAdapter();

        da.SelectCommand = new SqlCommand();

        da.SelectCommand.Connection = conn;

        da.SelectCommand.CommandText = "hqyjl";

        da.SelectCommand.CommandType = CommandType.StoredProcedure;

        SqlParameter param = new SqlParameter("@pageid", SqlDbType.Int);

        param.Direction = ParameterDirection.Input;

        param.Value = pageid;

        SqlParameter param1 = new SqlParameter("@tabname", SqlDbType.VarChar);

        param1.Direction = ParameterDirection.Input;

        param1.Value = tbname;

        SqlParameter param2 = new SqlParameter("@cxtj", SqlDbType.VarChar);

        param2.Direction = ParameterDirection.Input;

        param2.Value = jltj;

        SqlParameter param3 = new SqlParameter("@zj", SqlDbType.VarChar);

        param3.Direction = ParameterDirection.Input;

        param3.Value = zsy;                                                //主索引字段

        da.SelectCommand.Parameters.Add(param);

        da.SelectCommand.Parameters.Add(param1);

        da.SelectCommand.Parameters.Add(param2);

        da.SelectCommand.Parameters.Add(param3);

        DataSet ds = new DataSet();

        da.Fill(ds);

        conn.Close();

        return ds;

}

 

[AjaxPro.AjaxMethod]

    public int get_record_count(string jltj,string tbname)
    {
        string connstr = ConfigurationManager.ConnectionStrings["spjkconn"].ConnectionString;

        SqlConnection conn = new SqlConnection(connstr);

        SqlCommand cmd = new SqlCommand();

        int bh;

        string cmdstr;

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.CommandText = "record_count";

        cmd.Parameters.Add("@spcount", SqlDbType.Int).Direction = ParameterDirection.Output;                           //获得存储过程返回的记录总数的参数
       
        SqlParameter param = new SqlParameter("@cxtj", SqlDbType.VarChar);

        param.Direction = ParameterDirection.Input;

        param.Value = jltj;

        SqlParameter param1 = new SqlParameter("@tabname", SqlDbType.VarChar);

        param1.Direction = ParameterDirection.Input;

        param1.Value = tbname;

        cmd.Parameters.Add(param);

        cmd.Parameters.Add(param1);
       
        cmd.Connection = conn;

        conn.Open();

        cmd.ExecuteNonQuery();

        bh = (int)cmd.Parameters["@spcount"].Value;    //获得记录总数

        return bh;
    }

 

[AjaxPro.AjaxMethod]

    public int do_sql(string cmdstr)
    {

        string connstr = ConfigurationManager.ConnectionStrings["spjkconn"].ConnectionString;

        SqlConnection conn = new SqlConnection(connstr);

        conn.Open();

        SqlCommand cmd = new SqlCommand();

        int count;

        cmd.Connection = conn;

        cmd = new SqlCommand(cmdstr, conn);

        count = cmd.ExecuteNonQuery();

        conn.Close();

        if (count > 0)

            return 1;

        return 0;
   
   
    }

    [AjaxPro.AjaxMethod]

    public DataSet datasetfa_faid(string cmdstr)
    {

        string Con = ConfigurationManager.ConnectionStrings["spjkconn"].ConnectionString;

        SqlConnection conn = new SqlConnection(Con);

        conn.Open();

        SqlDataAdapter adpt = new SqlDataAdapter(cmdstr, conn);

        DataSet ds = new DataSet();

        adpt.Fill(ds);

        conn.Close();

        return ds;
    }

}