App_Code/Class1.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
///Class1 的摘要说明
/// </summary>
public class Class1
{
    private const string USP_NEWS_GETNEWS = "USP_News_GetNews";
	public Class1()
	{
		//
		//TODO: 在此处添加构造函数逻辑
		//
        
	}
    public DataTable Getnewskey(string fl)
    {
         SqlConnection connection = new SqlConnection();
         connection.ConnectionString = ConfigurationManager.AppSettings["strConn"];
            string cmdtext="select distinct NewsKey from NewsKey ";
            if (fl != "ALL")
            {
                cmdtext += " where FL='" + fl + "'";
            }            
            connection.Open();
            SqlDataAdapter sd = new SqlDataAdapter(cmdtext,connection);
            DataTable dt = new DataTable();
                sd.Fill(dt) ;
            connection.Close();
            connection.Dispose();
            return dt;
    }
    public DataTable Getnews(string NewsForm, int start, int end, string key,string bt)
    {
        SqlParameter[] param = { new SqlParameter("@NewsForm", SqlDbType.NVarChar, 50) ,
                                   new SqlParameter("@startindex", SqlDbType.Int) ,
                                   new SqlParameter("@endindex", SqlDbType.Int) ,                               
                                   new SqlParameter("@key", SqlDbType.NVarChar, 550) , 
                                    new SqlParameter("@bt", SqlDbType.NVarChar, 550) , 
                               };

        param[0].Value = NewsForm;
        param[1].Value = start;
        param[2].Value = end;
        param[3].Value = key;
        param[4].Value = bt;
        SqlConnection connection = new SqlConnection();
        connection.ConnectionString = ConfigurationManager.AppSettings["strConn"];
        SqlCommand command = new SqlCommand(USP_NEWS_GETNEWS, connection);
        try
        {
            connection.Open();