supply/default.aspx.cs

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

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

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 Meiqi.BusinessLogicLayer;

public partial class supply_default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                string strSql = "";

                //绑定列表数据
                bindData();

                strSql = "select top 8 SupplyBuyID,SBType,MemberID,SBTitle,AddTime from cai_SupplyBuy where SBType=1 and IsRecommended=1 order by SupplyBuyID desc";
                DataView dvlist = cai_SupplyBuy.QuerySupplyBuy(strSql);
                rp_NewsList.DataSource = dvlist;
                rp_NewsList.DataBind();

                strSql = "select top 8 MemberID,CompanyName,AddTime from cai_Members where CheckState=1 order by MemberID desc";
                DataView dvlist1 = cai_Members.QueryMembers(strSql);
                rp_MemberList.DataSource = dvlist1;
                rp_MemberList.DataBind();
            }
            catch
            {
                Response.Write("发生错误.");
                Response.End();
            }
        }
    }

    void bindData()
    {
        string strSql = "";

        string action = Convert.ToString(Request.QueryString["action"]);
        if (action == "SearchSupply")
        {
            string keywords = Convert.ToString(Request.QueryString["keywords"]);
            strSql = "select SupplyBuyID,SBType,MemberID,CompanyName,SBTitle,PicPathSmall,SBContent,AddTime from V_SupplyBuy where SBType=1 and SBTitle like \'%" + keywords + "%\' order by SupplyBuyID desc";
        }
        else
        {
            strSql = "select SupplyBuyID,SBType,MemberID,CompanyName,SBTitle,PicPathSmall,SBContent,AddTime from V_SupplyBuy where SBType=1 order by SupplyBuyID desc";
        }