Пример #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BLL.procate myb = new BLL.procate();
            DataSet ds = myb.dataset();
            _cateid.DataSource = ds.Tables[0];
            _cateid.DataBind();
            L_id.Text = Request.QueryString["id"].ToString();
            int  u_id = Convert.ToInt32( L_id.Text);
            BLL.product prob = new BLL.product();
            MySqlDataReader dr = prob.selectupdate(u_id);

            if (dr.Read())
            {
                _title.Text = dr["_title"].ToString();
                FCKeditor1.Value = dr["_content"].ToString();
                _posttime.Text = dr["_posttime"].ToString();
                _weight.Text = dr["_weight"].ToString();
                _imageid.Text = dr["_imageid"].ToString();
                _marketprice.Text = dr["_marketprice"].ToString();
                _localprice.Text = dr["_localprice"].ToString();
                _procount.Text = dr["_procount"].ToString();
                _ischeap.SelectedIndex = Convert.ToInt32(dr["_ischeap"].ToString());
                _isrecomment.SelectedIndex = Convert.ToInt32(dr["_isrecommend"].ToString());
                _top.SelectedIndex = Convert.ToInt32(dr["_top"].ToString());
                _cateid.SelectedIndex = Convert.ToInt32(dr["_cateid"].ToString()) + 1;
            }
            dr.Close();

        }
    }
Пример #2
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Edit")
        {
            z_id.Text = e.CommandArgument.ToString();
        }

        if (e.CommandName == "Delete")
        {
            int z_id = Convert.ToInt32(e.CommandArgument);
            BLL.product myb = new BLL.product();
            int result = myb.num(z_id);
            if (result > 0)
            {
                msg("先把含有此子类的商品记录删除,才能删除子类");
            }
            else
            {
                BLL.procate d_bll = new BLL.procate();
                int rs = d_bll.dalete(z_id);
                if (rs > 0)
                {
                    msg("删除成功");
                    bing();
                }
                else
                {
                    msg("删除失败!");

                }
            }

        }
    }
Пример #3
0
    protected void tijiao_Click(object sender, EventArgs e)
    {
        Model.product mym = new Model.product();
        mym.title       = _title.Text;
        mym.content     = FCKeditor1.Value;
        mym.imageid     = _imageid.Text;
        mym.ischeap     = Convert.ToInt32(_ischeap.SelectedValue);
        mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue);
        mym.localprice  = Convert.ToDouble(_localprice.Text);
        mym.marketprice = Convert.ToDouble(_marketprice.Text);
        mym.posttime    = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
        mym.procount    = Convert.ToInt32(_procount.Text);
        mym.top         = Convert.ToInt32(_top.SelectedValue);
        mym.weight      = _weight.Text;
        mym.cateid      = Convert.ToInt32(_cateid.SelectedValue);
        BLL.product bpro   = new BLL.product();
        int         result = bpro.insert(mym);

        if (result > 0)
        {
            msg("成功添加产品!!");

            string mmmm = DateTime.Now.ToString("yyyyMMddhhmmssfff");
            _imageid.Text = mmmm;

            _title.Text       = "";
            FCKeditor1.Value  = "";
            _procount.Text    = "";
            _weight.Text      = "";
            _localprice.Text  = "";
            _marketprice.Text = "";
            imagela.Text      = "";
        }
    }
Пример #4
0
 public void bing()
 {
     BLL.product myb = new BLL.product();
     DataSet ds = myb.dataset();
     GridView1.DataSource  =ds.Tables[0];
     GridView1.DataBind();
 }
Пример #5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BLL.procate myb = new BLL.procate();
            DataSet     ds  = myb.dataset();
            _cateid.DataSource = ds.Tables[0];
            _cateid.DataBind();
            L_id.Text = Request.QueryString["id"].ToString();
            int           u_id = Convert.ToInt32(L_id.Text);
            BLL.product   prob = new BLL.product();
            SqlDataReader dr   = prob.selectupdate(u_id);

            if (dr.Read())
            {
                _title.Text                = dr["_title"].ToString();
                FCKeditor1.Value           = dr["_content"].ToString();
                _posttime.Text             = dr["_posttime"].ToString();
                _weight.Text               = dr["_weight"].ToString();
                _imageid.Text              = dr["_imageid"].ToString();
                _marketprice.Text          = dr["_marketprice"].ToString();
                _localprice.Text           = dr["_localprice"].ToString();
                _procount.Text             = dr["_procount"].ToString();
                _ischeap.SelectedIndex     = Convert.ToInt32(dr["_ischeap"].ToString());
                _isrecomment.SelectedIndex = Convert.ToInt32(dr["_isrecommend"].ToString());
                _top.SelectedIndex         = Convert.ToInt32(dr["_top"].ToString());
                _cateid.SelectedIndex      = Convert.ToInt32(dr["_cateid"].ToString()) + 1;
            }
            dr.Close();
        }
    }
Пример #6
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Edit")
        {
            z_id.Text = e.CommandArgument.ToString();
        }

        if (e.CommandName == "Delete")
        {
            int         z_id   = Convert.ToInt32(e.CommandArgument);
            BLL.product myb    = new BLL.product();
            int         result = myb.num(z_id);
            if (result > 0)
            {
                msg("先把含有此子类的商品记录删除,才能删除子类");
            }
            else
            {
                BLL.procate d_bll = new BLL.procate();
                int         rs    = d_bll.dalete(z_id);
                if (rs > 0)
                {
                    msg("删除成功");
                    bing();
                }
                else
                {
                    msg("删除失败!");
                }
            }
        }
    }
Пример #7
0
 public void sbing()
 {
     int cateid = Convert.ToInt32(l_cateid.Text);
     BLL.product b_date = new BLL.product();
     DataSet ds = b_date.p_dataset(cateid, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "helpcate");
     DataList1.DataSource = ds.Tables[0];
     DataList1.DataBind();
 }
Пример #8
0
    public void bing()
    {
        BLL.product myb = new BLL.product();
        DataSet     ds  = myb.dataset();

        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
Пример #9
0
 public void s_cateid()
 {
     string cate_id = Request.QueryString["cateid"].ToString();
     l_cateid.Text = cate_id;
     BLL.product b_p = new BLL.product();
     int result = b_p.num_cateid(Convert.ToInt32(cate_id));
     AspNetPager1.RecordCount = result;
     AspNetPager1.PageSize = 9;
 }
Пример #10
0
    public void sbing()
    {
        int cateid = Convert.ToInt32(l_cateid.Text);

        BLL.product b_date = new BLL.product();
        DataSet     ds     = b_date.p_dataset(cateid, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "helpcate");

        DataList1.DataSource = ds.Tables[0];
        DataList1.DataBind();
    }
Пример #11
0
    protected void sous_Click(object sender, EventArgs e)
    {
        Model.product mym = new Model.product();
        mym.title = Text_title.Text;
        BLL.product myb = new BLL.product();
        DataSet     ds  = myb.select_title(mym);

        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
Пример #12
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Delete")
        {
            Model.product mym = new Model.product();
            mym.id = Convert.ToInt32(e.CommandArgument);
            BLL.product myb = new BLL.product();



            string s_imageid = myb.select_imageid(mym);


            BLL.proimage b_image = new BLL.proimage();

            DataSet ds = b_image.select_sizeid(s_imageid);



            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string size_id = Convert.ToString(ds.Tables[0].Rows[i]["_sizeid"]);

                BLL.size s_bll = new BLL.size();

                int result_s = s_bll.delete(size_id);


                string path1 = Convert.ToString(ds.Tables[0].Rows[i]["_imageurl"]);

                string path = "~/" + path1;

                if (File.Exists(Server.MapPath(path)))
                {
                    File.Delete(Server.MapPath(path));
                }
            }

            int r_image = b_image.delete(s_imageid);

            int result = myb.delete_id(mym);

            if (result > 0)
            {
                msg("删除成功!!");
                bing();
            }
        }

        if (e.CommandName == "Edit")
        {
            Response.Redirect("proupdate.aspx?id=" + e.CommandArgument + "");
        }
    }
Пример #13
0
    public void s_cateid()
    {
        string cate_id = Request.QueryString["cateid"].ToString();

        l_cateid.Text = cate_id;
        BLL.product b_p    = new BLL.product();
        int         result = b_p.num_cateid(Convert.ToInt32(cate_id));

        AspNetPager1.RecordCount = result;
        AspNetPager1.PageSize    = 9;
    }
Пример #14
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Delete")
        {
            Model.product mym = new Model.product();
            mym.id = Convert.ToInt32(e.CommandArgument);
            BLL.product myb = new BLL.product();

            string s_imageid = myb.select_imageid(mym);

            BLL.proimage b_image = new BLL.proimage();

            DataSet ds = b_image.select_sizeid(s_imageid);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string size_id = Convert.ToString(ds.Tables[0].Rows[i]["_sizeid"]);

                BLL.size s_bll = new BLL.size();

                int result_s = s_bll.delete(size_id);

                string path1 = Convert.ToString(ds.Tables[0].Rows[i]["_imageurl"]);

                string path = "~/" + path1;

                if (File.Exists(Server.MapPath(path)))
                {

                    File.Delete(Server.MapPath(path));
                }

            }

                int r_image = b_image.delete(s_imageid);

                int result = myb.delete_id(mym);

                if (result > 0)
                {
                    msg("删除成功!!");
                    bing();
                }

            }

            if (e.CommandName == "Edit")
            {
                Response.Redirect("proupdate.aspx?id="+e.CommandArgument+"");
            }
    }
Пример #15
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)

        {
            BLL.fathercate my_f = new BLL.fathercate();
            DataSet        ds_f = my_f.dataset();
            Repeater1.DataSource = ds_f.Tables[0];
            Repeater1.DataBind();


            uid.Text = Request.QueryString["uid"].ToString();
            int u_id = Convert.ToInt32(uid.Text);



            BLL.product   prob   = new BLL.product();
            SqlDataReader dr_pro = prob.selectupdate(u_id);
            dr_pro.Read();
            market.Text    = Math.Round(Convert.ToDecimal(dr_pro["_market_price"].ToString()), 2).ToString();
            local.Text     = Math.Round(Convert.ToDecimal(dr_pro["_local_price"].ToString()), 2).ToString();
            image_id.Text  = dr_pro["_imageid"].ToString();
            title_l.Text   = dr_pro["_product_name"].ToString();
            content_s.Text = dr_pro["_describe"].ToString();
            int cate_id = Convert.ToInt32(dr_pro["_cateid"].ToString());

            catename(cate_id);
            dr_pro.Close();

            BLL.proimage b_image  = new BLL.proimage();
            DataSet      ds_image = b_image.select_sizeid(image_id.Text);
            DataList1.DataSource = ds_image.Tables[0];
            DataList1.DataBind();


            Image_1.ImageUrl = Convert.ToString(ds_image.Tables[0].Rows[0]["_imageurl"]);
            im_url           = Image_1.ImageUrl;
            img_url.Text     = im_url;
            d_color.Text     = Convert.ToString(ds_image.Tables[0].Rows[0]["_color"]);
            if (ds_image.Tables[0].Rows[0]["_sizeid"] != null)
            {
                string size_id = Convert.ToString(ds_image.Tables[0].Rows[0]["_sizeid"]);
                sizeid.Text = size_id;
                siz(sizeid.Text);
            }
        }
    }
Пример #16
0
    protected void tijiao_Click(object sender, EventArgs e)
    {
        Model.product mym = new Model.product();
        mym.title = _title.Text;
        mym.content = FCKeditor1.Value;
        mym.imageid = _imageid.Text;
        mym.ischeap = Convert.ToInt32(_ischeap.SelectedValue);
        mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue);
        mym.localprice = Convert.ToDouble(_localprice.Text);
        mym.marketprice = Convert.ToDouble(_marketprice.Text);
        mym.posttime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
        mym.procount = Convert.ToInt32(_procount.Text);
        mym.top = Convert.ToInt32(_top.SelectedValue);
        mym.weight = _weight.Text;
        mym.cateid = Convert.ToInt32(_cateid.SelectedValue);
        BLL.product bpro = new BLL.product();
        int result = bpro.insert(mym);
        if (result > 0)
        {
            msg("成功添加产品!!");

            string mmmm = DateTime.Now.ToString("yyyyMMddhhmmssfff");
            _imageid.Text = mmmm;

            _title.Text = "";
            FCKeditor1.Value = "";

            _procount.Text = "";
            _weight.Text = "";
            sizela.Text = "";
            _localprice.Text = "";
            _marketprice.Text = "";

            imagela.Text = "";

        }
    }
Пример #17
0
    protected void tijiao_Click(object sender, EventArgs e)
    {
        Model.product mym = new Model.product();
        mym.title       = _title.Text;
        mym.content     = FCKeditor1.Value;
        mym.id          = Convert.ToInt32(L_id.Text);
        mym.ischeap     = Convert.ToInt32(_ischeap.SelectedValue);
        mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue);
        mym.localprice  = Convert.ToDouble(_localprice.Text);
        mym.marketprice = Convert.ToDouble(_marketprice.Text);

        mym.procount = Convert.ToInt32(_procount.Text);
        mym.top      = Convert.ToInt32(_top.SelectedValue);
        mym.weight   = _weight.Text;
        mym.cateid   = Convert.ToInt32(_cateid.SelectedValue);
        BLL.product bpro   = new BLL.product();
        int         result = bpro.update(mym);

        if (result > 0)
        {
            msg("成功更新商品!!");
            Response.Redirect("proselect.aspx");
        }
    }
Пример #18
0
    protected void info()
    {
        try
        {
            int c = 1;
            string str = "select * from product where _ischeap=" + c + " limit 10";
            DataSet ds = new BLL.product().getProductDS(str);
            DataList1.DataSource = ds.Tables[0];
            DataList1.DataBind();
            /*----------------- hot--------------*/

            string str2 = @"select * from product where _id
                      in (select _proid from orderdetail group by _proid order by sum(_count) ) limit 10";
            DataSet ds2 = new BLL.product().getProductDS(str2);
            DataList2.DataSource = ds2.Tables[0];
            DataList2.DataBind();
            /*----------------- time--------------*/
            string str3 = "select * from product order by _id desc limit 10";
            DataSet ds3 = new BLL.product().getProductDS(str3);
            DataList3.DataSource = ds3.Tables[0];
            DataList3.DataBind();

        }
        catch
        {

        }
    }
Пример #19
0
 protected void sous_Click(object sender, EventArgs e)
 {
     Model.product mym = new Model.product();
     mym.title = Text_title.Text;
     BLL.product myb = new BLL.product();
     DataSet ds = myb.select_title(mym);
     GridView1.DataSource = ds.Tables[0];
     GridView1.DataBind();
 }
Пример #20
0
        public static product Getproduct(product p0)
        {
            string sql = "select * from product where id = @id";

            return(DAL.SqlHelper <Model.product> .Query(sql, p0)[0]);
        }
Пример #21
0
    protected void tijiao_Click(object sender, EventArgs e)
    {
        Model.product mym = new Model.product();
        mym.title = _title.Text;
        mym.content = FCKeditor1.Value;
        mym.id = Convert.ToInt32(L_id.Text);
        mym.ischeap = Convert.ToInt32(_ischeap.SelectedValue);
        mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue);
        mym.localprice = Convert.ToDouble(_localprice.Text);
        mym.marketprice = Convert.ToDouble(_marketprice.Text);

        mym.procount = Convert.ToInt32(_procount.Text);
        mym.top = Convert.ToInt32(_top.SelectedValue);
        mym.weight = _weight.Text;
        mym.cateid = Convert.ToInt32(_cateid.SelectedValue);
        BLL.product bpro = new BLL.product();
        int result = bpro.update(mym);
        if (result > 0)
        {
            msg("成功更新商品!!");
            Response.Redirect("proselect.aspx");

        }
    }
Пример #22
0
    protected string bd(string str)
    {
        string sql = " select  _imageurl from  proimage where _imageid= '" + str + "' ";

        DataTable sdr = new BLL.product().getProductDS(sql).Tables[0];

        if (sdr.Rows.Count > 0)
        {
            return sdr.Rows[0]["_imageurl"].ToString();
        }
        else {
            return "images\\11_03.jpg";
        }
    }