/// <summary> /// 绑定读取数据 /// </summary> private void BindData() { //定义变量 string strSql, strTypeID, strKeyWords, strIsRecommend; //变量赋值 strTypeID = Request.QueryString["TypeID"]; strKeyWords = Request.QueryString["keyword"]; strIsRecommend = Request.QueryString["IsRecommend"]; //判断变量 if (!FunctionClass.CheckStr(strTypeID, 1)) { strTypeID = "1"; } if (!FunctionClass.CheckStr(strIsRecommend, 1)) { strIsRecommend = ""; } //打开数据库 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //sql语句 strSql = " where IsShow=1"; if (strTypeID != "") { strSql += " and (" + myData.GetProTypeIDSql(strTypeID, myConn) + "TypeID=" + strTypeID + ")"; } if (FunctionClass.CheckStr(strKeyWords, 0)) { strSql += " and (ProName like '%" + strKeyWords.Replace("'", "''") + "%' or Content like '%" + strKeyWords.Replace("'", "''") + "%')"; } if (strIsRecommend != "") { strSql += " and IsRecommend=" + strIsRecommend; } //初始化分页变量 int intPageIndex = FunctionClass.CurrentPage(); int intPageSize = 100; int intPageCount = 0; int intPageRecordcount = 0; //创建Dataset对象读取数据记录集 DataSet myDs = myData.GetDataSet("T_Products", strSql, "SID asc,NoteTime desc", intPageIndex, intPageSize, ref intPageCount, ref intPageRecordcount, myConn); DataView myDv = new DataView(myDs.Tables[0], " ", "", DataViewRowState.CurrentRows); for (int i = 0; i < myDv.Count; i++) { lbList.Text += "<li><a href=" + FunctionClass.GetImgUrl(myDv[i]["Content"].ToString()) + " rel=\"lightbox-tour\" title=\"" + myDv[i]["ProName"].ToString() + "\"><img src=\"" + FunctionClass.GetUploadFileRelativeURL(myDv[i]["ProPic"].ToString()) + "\" width=\"200\" height=\"133\" alt=\"" + myDv[i]["ProName"].ToString() + "\" /><br/>" + myDv[i]["ProName"].ToString() + "</a></li>"; } myDv.Dispose(); //分页 lbPageBar.Text = FunctionClass.GetPageBar(intPageIndex, intPageRecordcount, intPageCount, 4, FunctionClass.GetNewURL("page", "{page}", FunctionClass.PageURL), "<img src=\"images/news_19.jpg\" width=\"21\" height=\"13\" alt=\"第一页\" />", "<img src=\"images/news_116.jpg\" width=\"21\" height=\"13\" alt=\"上一页\" />", "<img src=\"images/news_22.jpg\" width=\"21\" height=\"13\" alt=\"下一页\" />", "<img src=\"images/news_23.jpg\" width=\"21\" height=\"13\" alt=\"最后页\" />", false, false); myDs.Dispose(); //分类名称赋值 lbCalled.Text = "美食推荐"; lbCalled1.Text = "Food recommended"; if (strTypeID == "") { hyCalled.Text = "美食推荐"; hyCalled.NavigateUrl = "products.aspx"; } else { strSql = "select * from T_ProType where ID=" + strTypeID; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { hyCalled.Text = myDr["TypeCalled"].ToString(); hyCalled.NavigateUrl = "products.aspx?TypeID=" + strTypeID; lbTypeCalled.Text = myDr["TypeCalled"].ToString(); lbMemo.Text = myDr["Memo"].ToString();; } } //关闭数据库 myData.ConnClose(myConn); }
/// <summary> /// 绑定读取数据 /// </summary> private void BindData() { //定义变量 string strSql, strNewType, strKeyWords, strIsRecommend; //变量赋值 strNewType = Request.QueryString["NewType"]; strKeyWords = Request.QueryString["keyword"]; strIsRecommend = Request.QueryString["IsRecommend"]; //判断变量 if (!FunctionClass.CheckStr(strNewType, 1)) { strNewType = "1"; } if (!FunctionClass.CheckStr(strIsRecommend, 1)) { strIsRecommend = ""; } //打开数据库 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //sql语句 strSql = " where IsShow=1"; if (strNewType != "") { strSql += " and (" + myData.GetNewTypeIDSql(strNewType, myConn) + "NewType=" + strNewType + ")"; } if (FunctionClass.CheckStr(strKeyWords, 0)) { strSql += " and (Title like '%" + strKeyWords.Replace("'", "''") + "%' or Content like '%" + strKeyWords.Replace("'", "''") + "%')"; tbKeyword.Text = strKeyWords; } if (strIsRecommend != "") { strSql += " and IsRecommend=" + strIsRecommend; } //初始化分页变量 int intPageIndex = FunctionClass.CurrentPage(); int intPageSize = 10; int intPageCount = 0; int intPageRecordcount = 0; //创建Dataset对象读取数据记录集 DataSet myDs = myData.GetDataSet("T_News", strSql, "SID asc,NoteTime desc", intPageIndex, intPageSize, ref intPageCount, ref intPageRecordcount, myConn); DataView myDv = new DataView(myDs.Tables[0], " ", "", DataViewRowState.CurrentRows); for (int i = 0; i < myDv.Count; i++) { lbList.Text += "<tr"; if (i % 2 != 0) { lbList.Text += " class='curr'"; } lbList.Text += ">" + "<td width=\"75\">" + (intPageSize * (intPageIndex - 1) + i + 1) + "</td>" + "<th width=\"395\"><a href=\"newinfo.aspx?id=" + myDv[i]["ID"].ToString() + "\" target=\"_blank\">" + myDv[i]["Title"].ToString() + "</a></th>" + "<td width=\"130\">" + DateTime.Parse(myDv[i]["NoteTime"].ToString()).ToString("yyyy-MM-dd") + "</td>" + "<td>【<a href=\"newinfo.aspx?id=" + myDv[i]["ID"].ToString() + "\" target=\"_blank\">查看详情</a>】</td>" + "</tr>"; } myDv.Dispose(); //分页 lbPageBar.Text = FunctionClass.GetPageBar(intPageIndex, intPageRecordcount, intPageCount, 4, FunctionClass.GetNewURL("page", "{page}", FunctionClass.PageURL), "<img src=\"images/news_11.jpg\" width=\"12\" height=\"12\" />", "<img src=\"images/news_12.jpg\" width=\"12\" height=\"12\" />", "<img src=\"images/news_14.jpg\" width=\"12\" height=\"12\" />", "<img src=\"images/news_15.jpg\" width=\"12\" height=\"12\" />", false, false); myDs.Dispose(); lbCalled.Text = "新闻中心"; lbCalled1.Text = "News Center"; hyCalled.Text = "新闻中心"; hyCalled.NavigateUrl = "news.aspx"; //关闭数据库 myData.ConnClose(myConn); }
/// <summary> /// 绑定读取数据 /// </summary> private void BindData() { //定义变量 string strSql, strKeyWords, strIsRecommend; //变量赋值 strKeyWords = Request.QueryString["keyword"]; strIsRecommend = Request.QueryString["IsRecommend"]; //判断变量 if (!FunctionClass.CheckStr(strIsRecommend, 1)) { strIsRecommend = ""; } //打开数据库 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //sql语句 strSql = " where IsShow=1"; if (FunctionClass.CheckStr(strKeyWords, 0)) { strSql += " and (Title like '%" + strKeyWords.Replace("'", "''") + "%' or Memo like '%" + strKeyWords.Replace("'", "''") + "%')"; } if (strIsRecommend != "") { strSql += " and IsRecommend=" + strIsRecommend; } //初始化分页变量 int intPageIndex = FunctionClass.CurrentPage(); int intPageSize = 5; int intPageCount = 0; int intPageRecordcount = 0; //创建Dataset对象读取数据记录集 DataSet myDs = myData.GetDataSet("T_Book", strSql, "SID asc,NoteTime desc", intPageIndex, intPageSize, ref intPageCount, ref intPageRecordcount, myConn); DataView myDv = new DataView(myDs.Tables[0], " ", "", DataViewRowState.CurrentRows); for (int i = 0; i < myDv.Count; i++) { lbList.Text += "<dl><dt>" + myDv[i]["Title"].ToString() + "</dt>" + "<dd>" + FunctionClass.WriteHtml(myDv[i]["Memo"].ToString()) + "</dd></dl>"; } myDv.Dispose(); //分页 lbPageBar.Text = FunctionClass.GetPageBar(intPageIndex, intPageRecordcount, intPageCount, 4, FunctionClass.GetNewURL("page", "{page}", FunctionClass.PageURL), "<img src=\"images/news_11.jpg\" width=\"12\" height=\"12\" />", "<img src=\"images/news_12.jpg\" width=\"12\" height=\"12\" />", "<img src=\"images/news_14.jpg\" width=\"12\" height=\"12\" />", "<img src=\"images/news_15.jpg\" width=\"12\" height=\"12\" />", false, false); myDs.Dispose(); lbCalled.Text = "加盟问答"; lbCalled1.Text = "F A Q"; hyCalled.Text = "加盟问答"; hyCalled.NavigateUrl = "jm_book.aspx"; lbInfo11.Text = myData.GetInfo(11, myConn); //关闭数据库 myData.ConnClose(myConn); }