EasyShop/siteAdmin/Goods/副本 ProductXnList.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using OpSql;
using Ftion;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using conn;
using System.Linq;
using System.Text;
using MyMODEL;
namespace EasyShop.siteAdmin.Goods
{
    public partial class ProductXnList : System.Web.UI.Page
    {
        DbConn conn = new DbConn();
        public string jsString = "";
        public string sltID = "";
        protected void Page_Load(object sender, EventArgs e)
        {
            //Ftion.Function.CheckState();
            if (!IsPostBack)
            {
                LoadData();
            }
        }
        private void LoadData()
        {
            //RpProduct.DataSource = CompanyInfo.GetRiZhiList();
            //RpProduct.DataBind();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT  a.ID, ProductName,ClassName, Price, Case when State=1 then '<font style=\"color:green\">已审核</font>' else '<font style=\"color:#ff0000\">未审核</font>' end as State, Brand, Img_Big, [Content], AddDate,UserName, ProStockNumber FROM TB_MC_Product a left join TB_MC_Class b on a.ClassId=b.ID where 1=1");
            strSql.Append(" and IsXuNi=1");
            BindData("", strSql.ToString());

        }
        public string getBrandInfo()
        {

            string dem = "";
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT Id, Name FROM TB_MC_Brand");
            conn.open();
            DataSet ds = conn.dataset(strSql.ToString());
            int num = ds.Tables[0].Rows.Count;
            for (int i = 0; i < num; i++)
            {
                string ID = ds.Tables[0].Rows[i][0].ToString();
                string ClassName = ds.Tables[0].Rows[i][1].ToString();
                //if (ID == sltID)
                //{
                //    dem += "<option value=" + ID + " selected=selected>" + ClassName + "</option>";
                //}
                //else
                //{
                dem += "<option value=" + ID + ">" + ClassName + "</option>";
                //}