生成网站的时候 总是提示 QuestionList_bll 错误 14 当前上下文中不存在名称“PubConstant” 请各位老师帮忙看看代码有什么地方不对
ASPX.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using BLL;
using Models;public partial class allerror : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
} private readonly QuestionList_bll bll = new QuestionList_bll(); int currPage = 1;
int PageSize = 5; public void Bind()
{ int pageCount;
int RecordCount; Repeater1.DataSource = bll.GetPage(currPage, PageSize, out pageCount, out RecordCount); Repeater1.DataBind(); this.AspNetPager1.RecordCount = RecordCount; this.AspNetPager1.CurrentPageIndex = currPage; this.AspNetPager1.PageSize = PageSize; }
protected void PageChanged(object sender, EventArgs e)
{ int pageCount;
int RecordCount; Repeater1.DataSource = bll.GetPage(this.AspNetPager1.CurrentPageIndex, PageSize, out pageCount, out RecordCount); Repeater1.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e)
{
string keywords = this.txtSearch.Text;
Response.Redirect("SearchQuestionList.html?keywords=" + keywords);
}
protected void btnAsk_Click(object sender, EventArgs e)
{
Response.Redirect("cuowu.html");
}
}
QuestionList_bll文件
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using DLL;
using Models;namespace BLL
{
public class QuestionList_bll
{
#region 调用全部的问题的列表的存储过程
/// <summary>
/// 调用procAllQuestionListSelect存储过程,得到全部的问题列表
/// </summary>
/// <returns></returns>
public static DataSet GetAllQuestionList()
{
SqlConnection con = DBHelper.Connection;
SqlCommand cmd = new SqlCommand("procAllQuestionListSelect",con);
cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
return ds;
}
#endregion
#region 调用未回答问题列表的存储过程
/// <summary>
/// 调用问题表中所有还未回答的问题的信息列表:包括字段:qid,ssname,qtitle,qip,qtime
/// </summary>
/// <returns></returns>
public static DataSet GetNoReplyQuestionList()
{
SqlConnection con = DBHelper.Connection;
SqlCommand cmd = new SqlCommand("procAllNoReplyQuestionListSelect", con);
cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
return ds; }
#endregion #region 调用已回答的问题的部分信息列表的存储过程
/// <summary>
/// 调用已回答得的问题列表的存储过程
/// </summary>
/// <returns></returns>
public static DataSet GetYesReplyQuestionList()
{
SqlConnection con = DBHelper.Connection;
SqlCommand cmd = new SqlCommand("procAllYesReplyQuestionListSelect", con);
cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
return ds;
}
#endregion #region 根据问题的编号得到ssid,返回该类的已回答的15条记录,供“您可能感兴趣的有”用
/// <summary>
/// 根据问题的编号得到ssid,返回该类的已回答的15条记录
/// </summary>
///<param name="qid"></param>
/// <returns></returns>
public static DataSet GetTop15YesReplyQuestionListBySSid(int id)
{
SqlConnection con = DBHelper.Connection;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("procTop15YesReplyQuestionListBySSidSelect", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter para0 = new SqlParameter("@qid", id);
da.SelectCommand.Parameters.Add(para0);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
try
{
da.Fill(ds);
con.Close();
return ds;
}
catch (Exception ex)
{
con.Close();
return null;
}
finally
{
con.Close(); }
}
#endregion
#region 根据编号得到所有内容
public IList<Question_model> GetPage(int pageindex, int _pageSize, out int pageCount, out int RecordCount)
{ pageCount = 0; RecordCount = 0; IList<Question_model> list = new List<Question_model>();
using (SqlConnection conn = new SqlConnection(PubConstant.ConnectionString))
{ SqlCommand objcmd = new SqlCommand(".ThePagerIndex", conn); objcmd.CommandType = CommandType.StoredProcedure; SqlParameter[] para ={ new SqlParameter("@strTable",SqlDbType.VarChar,-1), new SqlParameter("@strField",SqlDbType.VarChar,-1), new SqlParameter("@pageSize",SqlDbType.Int), new SqlParameter("@pageIndex",SqlDbType.Int), new SqlParameter("@strSortKey",SqlDbType.VarChar,-1), new SqlParameter("@strSortField",SqlDbType.VarChar,-1), new SqlParameter("@strOrderBy",SqlDbType.Bit), new SqlParameter("@pageCount",SqlDbType.Int), new SqlParameter("@RecordCount",SqlDbType.Int), new SqlParameter("@inttop",SqlDbType.Int,-1) }; para[0].Value = "question"; para[1].Value = "*"; para[2].Value = _pageSize; para[3].Value = pageindex; para[4].Value = "qid"; para[5].Value = "qtime desc"; para[6].Value = 1; para[7].Value = pageCount; para[7].Direction = ParameterDirection.Output; para[8].Value = RecordCount; para[8].Direction = ParameterDirection.Output; para[9].Value = -1; objcmd.Parameters.AddRange(para); conn.Open(); using (SqlDataReader reader = objcmd.ExecuteReader(CommandBehavior.CloseConnection))
{ while (reader.Read())
{ Question_model model = new Question_model(); model.Qid = Convert.ToInt32(reader["qid"]); model.Qtitle = Convert.ToString(reader["qtitle"]); list.Add(model); } } RecordCount = Convert.ToInt32(objcmd.Parameters["@RecordCount"].Value); pageCount = Convert.ToInt32(objcmd.Parameters["@pageCount"].Value); conn.Close(); conn.Dispose(); } return list; } #endregion
}
}
ASPX.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using BLL;
using Models;public partial class allerror : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
} private readonly QuestionList_bll bll = new QuestionList_bll(); int currPage = 1;
int PageSize = 5; public void Bind()
{ int pageCount;
int RecordCount; Repeater1.DataSource = bll.GetPage(currPage, PageSize, out pageCount, out RecordCount); Repeater1.DataBind(); this.AspNetPager1.RecordCount = RecordCount; this.AspNetPager1.CurrentPageIndex = currPage; this.AspNetPager1.PageSize = PageSize; }
protected void PageChanged(object sender, EventArgs e)
{ int pageCount;
int RecordCount; Repeater1.DataSource = bll.GetPage(this.AspNetPager1.CurrentPageIndex, PageSize, out pageCount, out RecordCount); Repeater1.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e)
{
string keywords = this.txtSearch.Text;
Response.Redirect("SearchQuestionList.html?keywords=" + keywords);
}
protected void btnAsk_Click(object sender, EventArgs e)
{
Response.Redirect("cuowu.html");
}
}
QuestionList_bll文件
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using DLL;
using Models;namespace BLL
{
public class QuestionList_bll
{
#region 调用全部的问题的列表的存储过程
/// <summary>
/// 调用procAllQuestionListSelect存储过程,得到全部的问题列表
/// </summary>
/// <returns></returns>
public static DataSet GetAllQuestionList()
{
SqlConnection con = DBHelper.Connection;
SqlCommand cmd = new SqlCommand("procAllQuestionListSelect",con);
cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
return ds;
}
#endregion
#region 调用未回答问题列表的存储过程
/// <summary>
/// 调用问题表中所有还未回答的问题的信息列表:包括字段:qid,ssname,qtitle,qip,qtime
/// </summary>
/// <returns></returns>
public static DataSet GetNoReplyQuestionList()
{
SqlConnection con = DBHelper.Connection;
SqlCommand cmd = new SqlCommand("procAllNoReplyQuestionListSelect", con);
cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
return ds; }
#endregion #region 调用已回答的问题的部分信息列表的存储过程
/// <summary>
/// 调用已回答得的问题列表的存储过程
/// </summary>
/// <returns></returns>
public static DataSet GetYesReplyQuestionList()
{
SqlConnection con = DBHelper.Connection;
SqlCommand cmd = new SqlCommand("procAllYesReplyQuestionListSelect", con);
cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
con.Close();
return ds;
}
#endregion #region 根据问题的编号得到ssid,返回该类的已回答的15条记录,供“您可能感兴趣的有”用
/// <summary>
/// 根据问题的编号得到ssid,返回该类的已回答的15条记录
/// </summary>
///<param name="qid"></param>
/// <returns></returns>
public static DataSet GetTop15YesReplyQuestionListBySSid(int id)
{
SqlConnection con = DBHelper.Connection;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("procTop15YesReplyQuestionListBySSidSelect", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter para0 = new SqlParameter("@qid", id);
da.SelectCommand.Parameters.Add(para0);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
try
{
da.Fill(ds);
con.Close();
return ds;
}
catch (Exception ex)
{
con.Close();
return null;
}
finally
{
con.Close(); }
}
#endregion
#region 根据编号得到所有内容
public IList<Question_model> GetPage(int pageindex, int _pageSize, out int pageCount, out int RecordCount)
{ pageCount = 0; RecordCount = 0; IList<Question_model> list = new List<Question_model>();
using (SqlConnection conn = new SqlConnection(PubConstant.ConnectionString))
{ SqlCommand objcmd = new SqlCommand(".ThePagerIndex", conn); objcmd.CommandType = CommandType.StoredProcedure; SqlParameter[] para ={ new SqlParameter("@strTable",SqlDbType.VarChar,-1), new SqlParameter("@strField",SqlDbType.VarChar,-1), new SqlParameter("@pageSize",SqlDbType.Int), new SqlParameter("@pageIndex",SqlDbType.Int), new SqlParameter("@strSortKey",SqlDbType.VarChar,-1), new SqlParameter("@strSortField",SqlDbType.VarChar,-1), new SqlParameter("@strOrderBy",SqlDbType.Bit), new SqlParameter("@pageCount",SqlDbType.Int), new SqlParameter("@RecordCount",SqlDbType.Int), new SqlParameter("@inttop",SqlDbType.Int,-1) }; para[0].Value = "question"; para[1].Value = "*"; para[2].Value = _pageSize; para[3].Value = pageindex; para[4].Value = "qid"; para[5].Value = "qtime desc"; para[6].Value = 1; para[7].Value = pageCount; para[7].Direction = ParameterDirection.Output; para[8].Value = RecordCount; para[8].Direction = ParameterDirection.Output; para[9].Value = -1; objcmd.Parameters.AddRange(para); conn.Open(); using (SqlDataReader reader = objcmd.ExecuteReader(CommandBehavior.CloseConnection))
{ while (reader.Read())
{ Question_model model = new Question_model(); model.Qid = Convert.ToInt32(reader["qid"]); model.Qtitle = Convert.ToString(reader["qtitle"]); list.Add(model); } } RecordCount = Convert.ToInt32(objcmd.Parameters["@RecordCount"].Value); pageCount = Convert.ToInt32(objcmd.Parameters["@pageCount"].Value); conn.Close(); conn.Dispose(); } return list; } #endregion
}
}
红色部分
using 命名空间;
初学 听不太懂
鼠标移到这个名字,看t右下角有出现个红色下划线不!有就移到那个下化线。引用命名空间!