Пример #1
0
        public ActionResult GetGoodsCollect(string uid, int goodsid, int isactive)
        {
            try
            {
                var   usmodel    = db.tb_userinfos.FirstOrDefault(s => s.UserID == uid);
                goods goodsmodel = new goods();
                //如果不是活动商品
                if (isactive == 0)
                {
                    goodsmodel = db.goods.FirstOrDefault(s => s.ID == goodsid);
                }
                else
                {
                    var activegood = db.zyactivitygoods.FirstOrDefault(s => s.ID == goodsid);
                    goodsmodel = db.goods.FirstOrDefault(s => s.ID == activegood.goodsid);
                }

                if (usmodel != null)
                {
                    var collectmodel = db.MyZyGoodsCollect.FirstOrDefault(s => s.userid == usmodel.ID && s.goodid == goodsmodel.ID);
                    if (collectmodel != null)
                    {
                        return(Json(Comm.ToJsonResult("Success", "成功", "1"), JsonRequestBehavior.AllowGet));
                    }
                    else
                    {
                        return(Json(Comm.ToJsonResult("Success", "成功", "0"), JsonRequestBehavior.AllowGet));
                    }
                }
                else
                {
                    return(Json(Comm.ToJsonResult("NotFind", "用户不存在"), JsonRequestBehavior.AllowGet));
                }
            }
            catch (Exception ex)
            {
                return(Json(Comm.ToJsonResult("Error", "获取失败"), JsonRequestBehavior.AllowGet));
            }
        }
        protected void btnAddGoods_Click(object sender, EventArgs e)
        {
            using (EnshineUnionDataContext db = new EnshineUnionDataContext())
            {
                goods addNot = new goods();
                addNot.goodstitle   = txtTitle.Value.Trim();
                addNot.goodscontent = SearchDataClass.CheckStr(txtFckContent.Value);

                addNot.goodsvalidate = Convert.ToChar(drpValidate.SelectedValue);
                addNot.setindex      = Convert.ToChar(drpSetIndex.SelectedValue);
                addNot.goodscode     = txtGoodsCode.Value;
                addNot.goodsprice    = Convert.ToDecimal(txtGoodsPrice.Value);
                addNot.goodssort     = int.Parse(drpGoodsSort.SelectedValue);
                addNot.goodsimg      = HFurl.Value.Trim();
                addNot.addtime       = DateTime.Now;

                addNot.goodstock    = int.Parse(txtStockNum.Value);
                addNot.goodsSales   = Convert.ToChar(drpSales.SelectedValue);
                addNot.getgoodpoint = txtGetGoodPoint.Value == "" ? 0 : int.Parse(txtGetGoodPoint.Value);

                addNot.goodscost     = txtGoodsCost.Value == "" ? 0.00m : Convert.ToDecimal(txtGoodsCost.Value);
                addNot.ifexchange    = Convert.ToChar(drpExchangeGood.SelectedValue);
                addNot.exchangepoint = txtExchangePoint.Value == "" ? 0 : int.Parse(txtExchangePoint.Value);
                addNot.tichengpoint  = ticheng.Value == "" ? "0/20/20/10" : ticheng.Value;
                //addNot.goodgoldprice = txtGoldPrice.Value == "" ? 0.00m : Convert.ToDecimal(txtGoldPrice.Value);
                //addNot.goodsilverprice = txtSilverprice.Value == "" ? 0.00m : Convert.ToDecimal(txtSilverprice.Value);
                addNot.ifxiangou     = Convert.ToChar(drpXianGou.SelectedValue);
                addNot.xiangounumber = txtXianGouNumber.Value == "" ? "0/0/0" : txtXianGouNumber.Value;
                addNot.goodsspec     = txtGoodsSpec.Value;
                addNot.goodscompany  = txtGoodsCompany.Value;
                //addNot.iftuangou = Convert.ToChar(drpGroupBy.SelectedValue);
                addNot.expiredate   = Convert.ToDateTime(txtExpireDate.Value);
                addNot.selectytsort = Convert.ToChar(drpSaleGoodsSort.SelectedValue);
                db.goods.InsertOnSubmit(addNot);
                db.SubmitChanges();
            }
            Response.Redirect("GoodsManager.aspx?mid=" + Request["mid"] + "&type=" + Request["type"]);
        }
Пример #3
0
 public String Creategoodsinfo(String goodsname, String goodstype, String goodslow, String goodshigh, String goodsdes)
 {
     try
     {
         String cid = (String)Session["uid"];
         if (cid == null)
         {
             return("-1");
         }
         user cuser = EFOperationdll.PersonOp.getAllInfo(db, cid);
         if (cuser == null)
         {
             return("-1");
         }
         goods newgoods = new goods()
         {
             gid        = "",
             sid        = cid,
             gname      = goodsname,
             gtype      = goodstype,
             glow       = int.Parse(goodslow),
             ghigh      = int.Parse(goodshigh),
             gdes       = goodsdes,
             gstate     = "1",
             gstarttime = DateTime.Now
         };
         //return EFOperationdll.GoodsOp.addGoods(db, newgoods);
         db.goods.Add(newgoods);
         db.SaveChanges();
         return("1");
     }
     catch (DbUpdateConcurrencyException e)
     {
         Console.WriteLine(e.StackTrace);
         return(e.StackTrace);
     }
 }
Пример #4
0
        public List <goods> getAllGoods(string request = "")
        {
            List <goods>  li  = new List <goods>();
            SQLiteCommand cmd = new SQLiteCommand(m_con);

            cmd.CommandText = "select * from global " + request;
            SQLiteDataReader dr = cmd.ExecuteReader();
            StringBuilder    sb = new StringBuilder();

            while (dr.Read())
            {
                goods one = new goods();
                one.number      = dr.GetString(0);
                one.source      = dr.GetString(1);
                one.dest        = dr.GetString(2);
                one.arriveTime  = dr.GetString(3);
                one.deadline    = dr.GetString(4);
                one.status      = dr.GetString(5);
                one.objVechicle = dr.GetString(6);
                one.finishTime  = dr.GetString(7);
                li.Add(one);
            }
            return(li);
        }
Пример #5
0
 public ActionResult GetBuyTerm(string uid, int goodsid, int isactive)
 {
     try
     {
         var   usmodel    = db.tb_userinfos.FirstOrDefault(s => s.UserID == uid);
         goods goodsmodel = new goods();
         if (usmodel != null)
         {
             int fitusergrade = 0;
             //如果不是活动商品
             if (isactive == 1)
             {
                 var activegood  = db.zyactivitygoods.FirstOrDefault(s => s.ID == goodsid);
                 var activemodel = db.zyactivity.FirstOrDefault(s => s.ID == activegood.activityid);
                 if (activemodel.GradeAsk == usmodel.UserGrade)
                 {
                     fitusergrade = 1;
                 }
             }
             var returndata = new
             {
                 userok    = 1,
                 usgradeok = fitusergrade
             };
             return(Json(Comm.ToJsonResult("Success", "成功", returndata), JsonRequestBehavior.AllowGet));
         }
         else
         {
             return(Json(Comm.ToJsonResult("NotFind", "用户不存在"), JsonRequestBehavior.AllowGet));
         }
     }
     catch (Exception ex)
     {
         return(Json(Comm.ToJsonResult("Error", "获取失败"), JsonRequestBehavior.AllowGet));
     }
 }
Пример #6
0
        public void updateGoods(goods one)
        {
            string str = "update global set  deadline ='" + one.deadline + "', status ='" + one.status + "', objVechicle = '" + one.objVechicle + "', finishTime = '" + one.finishTime + "' where number =" + "'" + one.number + "'";

            excuteCommand(str);
        }
 /// <summary>
 /// 架构中不存在 goods 的注释。
 /// </summary>
 public void AddTogoods(goods goods)
 {
     base.AddObject("goods", goods);
 }
Пример #8
0
 /// <summary>
 /// 插入方法
 /// </summary>
 /// <param name="goods">goods表实例</param>
 /// <returns>int</returns>
 public static int Insert(goods goodsExample)
 {
     return(Service.Insert(goodsExample));
 }
        public void BindShowUpInfo(string strUpid)
        {
            if (!string.IsNullOrEmpty(strUpid))
            {
                if (EnshineUnionManager.model.SearchDataClass.IsNumber(strUpid) == true)
                {
                    using (EnshineUnionDataContext db = new EnshineUnionDataContext())
                    {
                        goods getNot = db.goods.Single(x => x.goodsId == int.Parse(strUpid));
                        txtTitle.Value                  = getNot.goodstitle;
                        txtFckContent.Value             = SearchDataClass.CheckStr(getNot.goodscontent);
                        drpValidate.SelectedValue       = getNot.goodsvalidate.ToString();
                        drpSetIndex.SelectedValue       = getNot.setindex.ToString();
                        this.drpGoodsSort.SelectedValue = getNot.goodssort.ToString();
                        txtGoodsCode.Value              = getNot.goodscode;
                        txtGoodsPrice.Value             = getNot.goodsprice.ToString();;
                        this.hfDel.Value                = getNot.goodsimg;
                        this.HFurl.Value                = getNot.goodsimg;
                        if (!string.IsNullOrEmpty(getNot.goodsimg))
                        {
                            this.iShowPhoto.Src = getNot.goodsimg;
                        }
                        else
                        {
                            this.iShowPhoto.Src = "assets/images/nophoto.gif";
                        }
                        txtStockNum.Value             = getNot.goodstock.ToString();
                        drpSales.SelectedValue        = getNot.goodsSales.ToString();
                        txtGoodsCost.Value            = getNot.goodscost.ToString();;
                        txtExchangePoint.Value        = getNot.exchangepoint.ToString();;
                        drpExchangeGood.SelectedValue = getNot.ifexchange.ToString();
                        txtGetGoodPoint.Value         = getNot.getgoodpoint.ToString();
                        //txtGoldPrice.Value = getNot.goodgoldprice.ToString();
                        //txtSilverprice.Value = getNot.goodsilverprice.ToString();
                        //判断分成比例 0/20/20/10
                        var     tichengsplit = getNot.tichengpoint.Split('/');
                        decimal fencheng1    = (Convert.ToDecimal(getNot.goodsprice) - Convert.ToDecimal(getNot.goodscost)) * Convert.ToDecimal(75 / 100) * Convert.ToDecimal(tichengsplit[1]) / Convert.ToDecimal(100);
                        decimal fencheng2    = (Convert.ToDecimal(getNot.goodsprice) - Convert.ToDecimal(getNot.goodscost)) * Convert.ToDecimal(75 / 100) * Convert.ToDecimal(tichengsplit[2]) / Convert.ToDecimal(100);
                        decimal fencheng3    = (Convert.ToDecimal(getNot.goodsprice) - Convert.ToDecimal(getNot.goodscost)) * Convert.ToDecimal(75 / 100) * Convert.ToDecimal(tichengsplit[3]) / Convert.ToDecimal(100);

                        if (tichengsplit.Length > 0)
                        {
                            if (int.Parse(tichengsplit[0]) == 0)
                            {
                                //sp1.InnerText = "分成比例20%=" + Convert.ToDecimal((getNot.goodsprice * (int.Parse(tichengsplit[1]) / 100))).ToString("N2") + "元";
                                //sp2.InnerText = "分成比例20%=" + Convert.ToDecimal((getNot.goodsprice * (int.Parse(tichengsplit[2]) / 100))).ToString("N2") + "元";
                                //sp3.InnerText = "分成比例10%=" + Convert.ToDecimal((getNot.goodsprice * (int.Parse(tichengsplit[3]) / 100))).ToString("N2") + "元";
                                sp1.InnerText = "分成比例20%=" + Convert.ToDecimal(fencheng1).ToString("N2") + "元";
                                sp2.InnerText = "分成比例20%=" + Convert.ToDecimal(fencheng2).ToString("N2") + "元";
                                sp3.InnerText = "分成比例10%=" + Convert.ToDecimal(fencheng3).ToString("N2") + "元";
                            }
                            else
                            {
                                Text1.Value = tichengsplit[1];
                                Text2.Value = tichengsplit[2]; Text3.Value = tichengsplit[3];
                                //spz1.InnerText = "%=" + Convert.ToDecimal((getNot.goodsprice * (Convert.ToDecimal(tichengsplit[1]) / 100))).ToString("N2") + "元";
                                //spz2.InnerText = "%=" + Convert.ToDecimal((getNot.goodsprice * (Convert.ToDecimal(tichengsplit[2]) / 100))).ToString("N2") + "元";
                                //spz3.InnerText = "%=" + Convert.ToDecimal((getNot.goodsprice * (Convert.ToDecimal(tichengsplit[3]) / 100))).ToString("N2") + "元";
                                spz1.InnerText = "%=" + Convert.ToDecimal(fencheng1).ToString("N2") + "元";
                                spz2.InnerText = "%=" + Convert.ToDecimal(fencheng2).ToString("N2") + "元";
                                spz3.InnerText = "%=" + Convert.ToDecimal(fencheng3).ToString("N2") + "元";
                            }
                        }
                        drpXianGou.SelectedValue = getNot.ifxiangou.ToString();
                        txtXianGouNumber.Value   = getNot.xiangounumber.ToString();
                        txtGoodsSpec.Value       = getNot.goodsspec;
                        txtGoodsCompany.Value    = getNot.goodscompany;
                        //drpGroupBy.SelectedValue = getNot.iftuangou.ToString();
                        txtExpireDate.Value            = Convert.ToDateTime(getNot.expiredate).ToString("yyyy/MM/dd");
                        drpSaleGoodsSort.SelectedValue = getNot.selectytsort.ToString();
                    }
                }
            }
        }
Пример #10
0
 /// <summary>
 /// 插入方法
 /// </summary>
 /// <param name="goods">goods表实例</param>
 /// <returns>int</returns>
 public int Insert(goods goodsExample)
 {
     DBHelper.sqlstr = "insert into  goods (g_price_yuan,g_standby1,g_standby2,g_standby3,gdate,gdate1,gdate2,gdate3,gimg,gimg2,gname,gprice1,gprice2,gremark1,gremark2,gstate,gstate1,gstate2,gstate3,gtid,gtitle,gurl,gurl_yuan,gurl2)values(@g_price_yuan,@g_standby1,@g_standby2,@g_standby3,'" + goodsExample.gdate.ToString("yyyy-MM-dd") + "','" + goodsExample.gdate1.ToString("yyyy-MM-dd") + "','" + goodsExample.gdate2.ToString("yyyy-MM-dd") + "','" + goodsExample.gdate3.ToString("yyyy-MM-dd") + "',@gimg,@gimg2,@gname,@gprice1,@gprice2,@gremark1,@gremark2,@gstate,@gstate1,@gstate2,@gstate3,@gtid,@gtitle,@gurl,@gurl_yuan,@gurl2)";
     return(DBHelper.ExecuteNonQuery(GetSqlParameter(goodsExample)));
 }
Пример #11
0
 public IActionResult AddGoods(goods goods)
 {
     _goodsService.addNewGoods(goods);
     return(RedirectToAction("Index", "ShoppingCart"));
 }
Пример #12
0
 public IActionResult editPrice(goods goods)
 {
     _goodsService.updatePrice(goods);
     return(RedirectToAction("Index", "ShoppingCart"));
 }
Пример #13
0
 private void myListGood_ItemClick(object sender, ItemClickEventArgs e)
 {
     var tmp = ((popularListGoods)e.ClickedItem).name;
     goods tmpGood = new goods(tmp, 1.0);
     listGoods.Add(tmpGood);
     nowList.ItemsSource = listGoods;
 }
Пример #14
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string state = e.CommandName;

        if (state == "state_up")
        {
            int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["gid"].ToString());
            if (id != 0)
            {
                goods g = BLL.goodsManager.SearchBygid(id);
                g.gstate2 = g.gstate2 == "1" ? "2" : "1";
                if (g.gstate2 == "2")
                {
                    g.gdate2 = DateTime.Now;
                }
                if (BLL.goodsManager.Update(g) != 1)
                {
                    AJAXManager.Alert(this.UpdatePanel1, "修改失败");
                }
                else
                {
                    bind();
                }
            }
        }
        if (state == "state_img")
        {
            int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["gid"].ToString());
            if (id != 0)
            {
                goods g = BLL.goodsManager.SearchBygid(id);
                g.gstate1 = g.gstate1 == "1" ? "2" : "1";
                if (g.gstate1 == "2")
                {
                    g.gdate1 = DateTime.Now;
                }
                if (BLL.goodsManager.Update(g) != 1)
                {
                    AJAXManager.Alert(this.UpdatePanel1, "修改失败");
                }
                else
                {
                    bind();
                }
            }
        }
        if (state == "state_yh")
        {
            int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["gid"].ToString());
            if (id != 0)
            {
                goods g = BLL.goodsManager.SearchBygid(id);
                g.gstate3 = g.gstate3 == "1" ? "2" : "1";
                if (g.gstate3 == "2")
                {
                    g.gdate3 = DateTime.Now;
                }
                if (BLL.goodsManager.Update(g) != 1)
                {
                    AJAXManager.Alert(this.UpdatePanel1, "修改失败");
                }
                else
                {
                    bind();
                }
            }
        }
        if (state == "state_important")
        {
            int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["gid"].ToString());
            if (id != 0)
            {
                goods g = BLL.goodsManager.SearchBygid(id);
                g.g_standby1 = g.g_standby1 == "1" ? "2" : "1";
                if (BLL.goodsManager.Update(g) != 1)
                {
                    AJAXManager.Alert(this.UpdatePanel1, "修改失败");
                }
                else
                {
                    bind();
                }
            }
        }
    }
Пример #15
0
 /// <summary>
 /// 更新
 /// </summary>
 /// <param name="goods">goods表实例</param>
 /// <returns>int</returns>
 public static int Update(goods goodsExample)
 {
     return(Service.Update(goodsExample));
 }
Пример #16
0
        //结束
        #endregion

        /// <summary>
        /// 代码生成数据库中的订单数据
        /// </summary>
        void sckjmen()
        {
            for (int i = 0; i < 10; i++)//重新载入订单表需要清空生的控件们
            {
                foreach (Control item in pan_goods.Controls)
                {
                    if (item == lab_tip)
                    {
                        continue;                 //除了悬浮提示外其它的都清除,然后重新再生成,达到刷新的效果
                    }
                    pan_goods.Controls.Remove(item);
                }
            }
            //查询有关于这个买家的数据
            string    sql = string.Format("select * from goods where buydename = '{0}'", love.denglu_username == string.Empty ? "b" : love.denglu_username);
            DataTable d   = sqlHelper.ExecutedataTable(sql, CommandType.Text, null);

            //查询总金额
            string    fdas      = string.Format("select sum(fkje) from goods where goods.buydename = '{0}'", love.denglu_username == string.Empty ? "b" : love.denglu_username);
            DataTable jlk       = sqlHelper.ExecutedataTable(fdas, CommandType.Text, null);
            string    zongjinge = string.Empty;//总金额

            try
            {
                zongjinge    = jlk.Rows[0][0].ToString();//如果没有金额就会出错
                lab_tip.Text = string.Format("tip:亲爱的 {0} ,你总共购买了 {1} 件商品,总共交易金额 {2} 元", love.denglu_username == string.Empty ? "b" : love.denglu_username, d.Rows.Count.ToString(), zongjinge.ToString());
            }
            catch (Exception)
            {
                lab_tip.Text = string.Format("tip:亲爱的 {0} ,你总共购买了 {1} 件商品,总共交易金额 {2} 元", love.denglu_username == string.Empty ? "b" : love.denglu_username, d.Rows.Count.ToString(), 0);
                throw;
            }

            Point panzuixin = new Point();         //用来记录下pannel的最新的位置,一个pannel一个商品订单
            bool  bol       = true;                //如果pannel是第一次诞生那么他是true,否则会false

            for (int i = 0; i < d.Rows.Count; i++) //有多少个订单就循环多少次
            {
                Panel pan_gs = new Panel();        //用来记录下最新的位置
                pan_goods.Controls.Add(pan_gs);
                pan_gs.BorderStyle = BorderStyle.FixedSingle;
                pan_gs.Size        = new Size(pan_goods.Width - 80, 140);
                #region pan_gs的位置算法
                if (bol)                                                                                   //说明它是第一次诞生
                {
                    bol             = false;                                                               //说明有过了第一个pannel
                    pan_gs.Location = new Point((pan_goods.Width - pan_gs.Width) / 2, pan_goods.Top + 20); //x等于平均,y等于最外的pannel,最外的自带内边距,y轴不加
                    Point poc = new Point(pan_gs.Location.X, pan_gs.Location.Y + pan_gs.Height + 20);      //第一个pannel的x,y加20像素
                    panzuixin = poc;                                                                       //把第一次的我位置传出去
                }
                else//如果不是第一次诞生就使用上次的位置y轴加20像素
                {
                    pan_gs.Location = panzuixin;
                    Point poc = new Point(pan_gs.Location.X, pan_gs.Location.Y + pan_gs.Height + 20); //第一个pannel的x,y加20像素
                    panzuixin = poc;                                                                  //把最后一个pannel的位置传出去
                }
                #endregion

                PictureBox compic = new PictureBox();//商品图片
                compic.Name     = "compic";
                compic.SizeMode = PictureBoxSizeMode.Zoom;
                compic.Size     = new Size(120, 120);
                sqlHelper.imagechu(d.Rows[i]["compic"], compic);
                //compic.BorderStyle = BorderStyle.FixedSingle;
                compic.Location = new Point(25, (pan_gs.Height - compic.Height) / 2);


                Label comname = new Label();//商品名
                comname.AutoSize = true;
                comname.Text     = "商品名称: " + d.Rows[i]["comname"].ToString();
                comname.Location = new Point(compic.Right + 30, compic.Top + 7);

                Label fkje = new Label();//付款金额
                fkje.AutoSize = true;
                fkje.Text     = "付款金额: " + d.Rows[i]["fkje"].ToString();
                fkje.Location = new Point(comname.Left, comname.Bottom);

                Label fktime = new Label();//付款时间
                fktime.AutoSize = true;
                fktime.Text     = "付款时间:" + d.Rows[i]["fktime"].ToString();
                fktime.Location = new Point(fkje.Left + 120, fkje.Top);

                Label cmid = new Label();//商品编号
                cmid.AutoSize = true;
                cmid.Text     = "商品编号: " + d.Rows[i]["cmid"].ToString();
                cmid.Location = new Point(fkje.Left, fkje.Bottom);

                Label pjdh = new Label();//评价单号
                pjdh.AutoSize = true;
                pjdh.Text     = "订单编号:" + d.Rows[i]["pjdh"].ToString();
                pjdh.Location = new Point(fktime.Left, cmid.Top);



                //获取昵称
                Label sellednicheng = new Label();//卖家昵称
                sellednicheng.AutoSize = true;
                string nnc = string.Format("select nicheng from sellde where username = '******'", d.Rows[i]["selledname"].ToString());
                sellednicheng.Text     = "卖家昵称:" + sqlHelper.ExecutedataTable(nnc, CommandType.Text, null).Rows[0][0].ToString();
                sellednicheng.Location = new Point(fktime.Right + 100, fktime.Location.Y);


                goods ggg = new goods();
                ggg.Pjdh = long.Parse(d.Rows[i]["pjdh"].ToString());
                if (ggg.isorneirong())//ture说明没有评价内容,也没有评价星级,那么就开始评价
                {
                    Label xj1 = new Label();
                    xj1.Text     = "我想给";     //这里加1-5的小数框
                    xj1.Tag      = "xj1";
                    xj1.AutoSize = true;
                    pan_gs.Controls.Add(xj1);
                    //                    xj1.Location = new Point(pjdh.Right + 30, pjdh.Top);
                    xj1.Location = new Point(sellednicheng.Left, pjdh.Top);
                    NumericUpDown num = new NumericUpDown();
                    num.AutoSize = true;
                    pan_gs.Controls.Add(num);
                    num.Maximum  = 5;
                    num.Width    = 13;
                    num.Location = new Point(xj1.Right, xj1.Top - 4);

                    Label xj2 = new Label();
                    xj2.AutoSize = true;
                    xj2.Text     = "颗星星的评价";
                    xj2.Tag      = "xj2";
                    xj2.Location = new Point(num.Right, xj1.Top);
                    pan_gs.Controls.Add(xj2);

                    Label nrts = new Label();
                    pan_gs.Controls.Add(nrts);
                    nrts.Text     = "评价内容:";
                    nrts.AutoSize = true;
                    //nrts.Font = new Font(nrts.Font.FontFamily, 25);
                    nrts.Location = new Point(cmid.Left, cmid.Bottom);

                    TextBox pj = new TextBox();
                    pan_gs.Controls.Add(pj);
                    pj.Multiline  = true;
                    pj.Size       = new Size(350, 40);
                    pj.ScrollBars = ScrollBars.Vertical;
                    pj.Location   = new Point(nrts.Right, nrts.Top);


                    Button submit = new Button();
                    submit.Name = d.Rows[i]["pjdh"].ToString();//用按钮记录下单号
                    submit.Text = "立即评价";
                    pan_gs.Controls.Add(submit);
                    submit.Location = new Point(pj.Right + 20, pj.Top + (pj.Height - submit.Height) / 2);
                    //submit.Size = new Size(submit.Size.Width, submit.Size.Height + 1);
                    submit.Click += new EventHandler(submit_Click);
                }
                else//说明评价完星级和内容了,可以开始直接显示了
                {
                    Label pjxj = new Label();
                    pan_gs.Controls.Add(pjxj);
                    pjxj.AutoSize = true;
                    pjxj.Location = new Point(cmid.Left, cmid.Bottom);
                    pjxj.Text     = "评价星级:";          //后面记得加上数据库的星级
                    //查询数据库的星级然后循环出对应的星星数量
                    bool      diyicixx = true;        //判断是否第一次产生星星
                    Point     pinxx    = new Point(); //存储星星的最新位置
                    DataTable tabxj    = sqlHelper.ExecutedataTable(string.Format("select xingji,neirong from goods where pjdh = {0}", d.Rows[i]["pjdh"].ToString()), CommandType.Text, null);
                    int       jkx      = int.Parse(tabxj.Rows[0]["xingji"].ToString());
                    for (int forxx = 0; forxx < jkx; forxx++)
                    {
                        PictureBox xx = new PictureBox();                                         //星级放到评价单号的右边
                        pan_gs.Controls.Add(xx);
                        xx.Size  = new Size(19, 19);                                              //图片为19,正好盛放
                        xx.Image = Image.FromFile(Application.StartupPath + "\\image\\haop.png"); //好评图片
                        if (diyicixx)
                        {
                            xx.Location = new Point(pjxj.Right, pjxj.Top - 4);
                            pinxx       = new Point(xx.Right + xx.Width + 10, xx.Top);
                            diyicixx    = false;//执行后说明它不是第一次运行
                        }
                        else
                        {
                            xx.Location = pinxx;
                            Point temp = new Point(xx.Right + xx.Width + 10, xx.Top);
                            pinxx = temp;
                        }
                    }


                    Label pjtime = new Label();
                    pjtime.AutoSize = true;
                    pjtime.Text     = "评价时间:" + d.Rows[0]["pjtime"].ToString();
                    pjtime.Location = new Point(sellednicheng.Left, pjxj.Top);
                    pan_gs.Controls.Add(pjtime);


                    Label neirong = new Label();//评价内容
                    neirong.AutoSize = true;
                    neirong.Text     = "评价内容:" + tabxj.Rows[0]["neirong"].ToString();
                    neirong.Location = new Point(pjxj.Left, pjxj.Bottom + pjxj.Height);
                    pan_gs.Controls.Add(neirong);
                }
                Control[] ctl = { pjdh, cmid, sellednicheng, comname, compic, fkje, fktime };
                pan_gs.Controls.AddRange(ctl);

                Button bbb = new Button();
                pan_goods.Controls.Add(bbb);
                bbb.Location = new Point(100, 100);//让它来承载焦点,否则将会自动把焦点赋予给星级框
                bbb.Focus();

                foreach (Control item in pan_gs.Controls)
                {
                    if (item is Button)
                    {
                        Button bb = (Button)item;
                        SetBtnStyle(bb);
                    }
                }
            }//订单循环结束
        }
Пример #17
0
        public event EventHandler zjbz;                       //申明事件

        private void btn_OK_Click(object sender, EventArgs e) //点击了付款的按钮
        {
            if (isorcg)                                       //判断是否交易成功了
            {
                DialogResult dr = MessageBox.Show("亲!你已经付款成功了哟!是否返回订单表查看你的订单信息?", "付款提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
                if (dr == DialogResult.Yes)
                {
                    //打开订单表
                    //Hide();
                    Frm_BuydeGoods f = new Frm_BuydeGoods();
                    f.ShowDialog();
                    //Show();
                }
                else
                {
                    Close();//订单表被关闭后关闭此页回到商品表
                }
                return;
            }
            //开始判断金额是否足够
            if (decimal.Parse(lab_buydeyue.Text) < decimal.Parse(lab_zfje.Text))
            {
                MessageBox.Show("余额不足,请充值(๑•﹏•)。", "余额不足提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
                return;//不让它执行数据库插入动作
            }

            //开始确认订单
            //订单信息
            string ddxx = string.Format(@"

商品名称:{0}

物流公司:{1}

收 货 人:{2}

收货电话:{3}

收货地址:{4}

你的余额:{5}

应付金额:{6}

交易后的余额:{7}",

                                        lab_comname.Text, lab_kuaidi.Text, txt_ZFbuydeName.Text, txt_telephone.Text, txt_ZFShouhuoDZ.Text,
                                        lab_buydeyue.Text, lab_shoujia.Text, decimal.Parse(lab_buydeyue.Text) - decimal.Parse(lab_shoujia.Text));
            DialogResult qrdd = MessageBox.Show(ddxx, "确认订单信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);

            if (qrdd == DialogResult.No)
            {
                return;
            }

            //下面开始为两家数据库的余额进行操作
            if (shoppin.State == ConnectionState.Closed)
            {
                shoppin.Open();
            }
            SqlTransaction st   = shoppin.BeginTransaction();
            SqlCommand     cmd1 = new SqlCommand(string.Format("update buyde set yue-={0} where username = '******'", lab_shoujia.Text), shoppin);
            SqlCommand     cmd2 = new SqlCommand(string.Format("update sellde set yue+={0}  where username = '******'", lab_shoujia.Text), shoppin);

            cmd1.Transaction = st;
            cmd2.Transaction = st;
            if (cmd1.ExecuteNonQuery() + cmd2.ExecuteNonQuery() == 2)
            {
                st.Commit();
                isorcg = true;
                MessageBox.Show("购买成功!╭(╯3╰)╮", "交易提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                //下面开始插入订单表数据库
                goods g = new goods();
                g.Cmid    = long.Parse(love.goumaiid == string.Empty ? "1" : love.goumaiid); //商品id
                g.Comname = lab_comname.Text;                                                //商品名
                //查到商品的持有者
                string    username = string.Format("select username from commodity where comid = {0}", g.Cmid);
                DataTable d        = sqlHelper.ExecutedataTable(username, CommandType.Text, null);
                g.Selledname = d.Rows[0][0].ToString();      //用户名
                g.Buydename  = lab_Buyde_id.Text;            //买家名
                g.Fkje       = decimal.Parse(lab_zfje.Text); //应该付款金额
                g.Compic     = sqlHelper.tiqupic(pic_com, Application.StartupPath + "\\image\\jfkljfklsdjkflsdjflksajdkfj.jpg");
                g.insertgoods();                             //插入到订单表,插入到数据库
                //开始刷新余额
                lab_buydeyue.Text = sqlHelper.ExecutedataTable(string.Format("select yue from buyde where username = '******'", lab_Buyde_id.Text), CommandType.Text, null).Rows[0][0].ToString();

                //直接进入订单表


                if (this.Parent != null)
                {
                    Frm_BuydeZhifu f = new Frm_BuydeZhifu();
                    f.TopLevel = false;
                    f.Parent   = this.Parent;
                    f.Show();
                    f.BringToFront();
                }
                else
                {
                    Hide();
                    Frm_BuydeZhifu f = new Frm_BuydeZhifu();
                    f.ShowDialog();
                    Show();
                }

                //Show();
            }
            else
            {
                MessageBox.Show("出错,请稍后重试", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                st.Rollback();//回滚事务
            }
        }
Пример #18
0
    protected void btn_save_Click(object sender, EventArgs e)
    {
        try
        {
            DateTime dt        = DateTime.Now;
            string   gname     = txt_name.Text.Trim();
            string   gtitle    = txt_title.Text.Trim();
            string   gurl      = txt_url.Text.Trim();
            string   gurl2     = txt_url2.Text.Trim();
            string   gimg      = "";
            string   gimg2     = "";
            string   gstate1   = ddl_state_img.SelectedValue;
            string   gstate2   = ddl_state_up.SelectedValue;
            string   gstate3   = ddl_state_yh.SelectedValue;
            string   gremark1  = txt_remark.Text.Trim();
            int      gtid      = int.Parse(ddl_goodstype.SelectedValue);
            string   gprice1   = txt_price1.Text.Trim();
            string   gprice2   = txt_price2.Text.Trim();
            string   gurl_yuan = txt_url_yuan.Text.Trim();
            string   gprice    = txt_price.Text.Trim();
            string   important = ddl_important.SelectedValue;

            goods g = new goods();

            if (!string.IsNullOrEmpty(id))
            {
                g     = BLL.goodsManager.SearchBygid(Convert.ToInt32(id));
                gimg  = g.gimg;
                gimg2 = g.gimg2;
            }
            else
            {
                g.gdate = dt;
            }

            if (string.IsNullOrEmpty(gname))
            {
                //Manager.Alert("请输入商品简称", Page);
                AJAXManager.Alert(UpdatePanel1, "请输入商品简称");
                Manager.TextBox_Select(txt_name);
                return;
            }
            if (gtid == 0)
            {
                //Manager.Alert("请选择店铺", Page);
                AJAXManager.Alert(UpdatePanel1, "请选择店铺");
                ddl_goodstype.Focus();
                return;
            }
            if (fu_img.HasFile && fu_img2.HasFile)
            {
                //Manager.Alert("暂时不能同时上传两个图片,请单独上传!", Page);
                AJAXManager.Alert(UpdatePanel1, "暂时不能同时上传两个图片,请单独上传!");
                return;
            }
            else
            {
                if (fu_img.HasFile)
                {
                    gimg = Manager.UpImage(fu_img, Request.PhysicalApplicationPath + "OA\\upload\\", Page);
                    if (string.IsNullOrEmpty(gimg))
                    {
                        //Manager.Alert("淘宝图片上传失败,请稍后再试", Page);
                        AJAXManager.Alert(UpdatePanel1, "淘宝图片上传失败,请稍后再试");
                        return;
                    }
                }
                if (fu_img2.HasFile)
                {
                    gimg2 = Manager.UpImage(fu_img2, Request.PhysicalApplicationPath + "OA\\upload\\", Page);
                    if (string.IsNullOrEmpty(gimg2))
                    {
                        //Manager.Alert("淘宝图片上传失败,请稍后再试", Page);
                        AJAXManager.Alert(UpdatePanel1, "淘宝图片上传失败,请稍后再试");
                        return;
                    }
                }
            }

            g.gdate1       = gstate1 == "2" ? dt : new DateTime();
            g.gdate2       = gstate2 == "2" ? dt : new DateTime();
            g.gdate3       = gstate3 == "2" ? dt : new DateTime();
            g.gimg         = gimg;
            g.gimg2        = gimg2;
            g.gname        = gname;
            g.gprice1      = gprice1;
            g.gprice2      = gprice2;
            g.gremark1     = gremark1;
            g.gstate1      = gstate1;
            g.gstate2      = gstate2;
            g.gstate3      = gstate3;
            g.gtid         = gtid;
            g.gtitle       = gtitle;
            g.gurl         = gurl;
            g.gurl2        = gurl2;
            g.gurl_yuan    = gurl_yuan;
            g.g_price_yuan = gprice;
            g.g_standby1   = important;


            int res;
            if (string.IsNullOrEmpty(id))
            {
                res = BLL.goodsManager.Insert(g);
            }
            else
            {
                res = BLL.goodsManager.Update(g);
            }
            if (res == 1)
            {
                //Manager.Alert("保存成功", Page);
                AJAXManager.Alert(UpdatePanel1, "保存成功");
                clear();
            }
            else
            {
                //Manager.Alert("保存失败", Page);
                AJAXManager.Alert(UpdatePanel1, "保存失败");
            }
        }
        catch (Exception ex)
        {
            //Manager.Alert(ex.ToString(), Page);
            AJAXManager.Alert(UpdatePanel1, ex.ToString());
        }
        //Manager.page_href_reload(Page);
    }
Пример #19
0
 public static int InsertGoods(goods goods)
 {
     return(igoods.InsertGoods(goods));
 }
Пример #20
0
        private void addgood_Click(object sender, RoutedEventArgs e)
        {
            ++k;
            var tmpNameGood = boxGood.Text;
            countAddGood.Text = k.ToString();
            goods tmpGood= new goods(tmpNameGood, sliderCount.Value);
            listGoods.Add(tmpGood);
            nowList.ItemsSource = listGoods;
            boxGood.Text = "";

            /*

            bool flag = false;
            for (int i = 0; i < popList.Count(); ++i)
            {
                if (tmpNameGood == popList[i].name)
                {
                    popList[i].amount++;
                    flag = true;
                    break;
                }
            }
            if(flag==false)
            {
               popularListGoods tmpPop = new popularListGoods(tmpNameGood,1);
               popList.Add(tmpPop);
            }

            var listXml = docs.Descendants("good");

            flag = false;

                for(int i=0;i<sortList.Count();++i){
                    foreach (var j in listXml){
                       if( j.Element("good").Value==popList[i].name)
                       {
                           j.Element("good").Attribute("count").Value = popList[i].amount.ToString();
                           flag = true;
                           break;
                       }
                }
                    if (flag == false)
                    {
                        var writer = docs.CreateWriter();
                        writer.WriteElementString()
                       // var element = docs.CreateElement("element");
                        //document.DocumentElement.AppendChild(element); // указываем родителя
                        //XmlAttribute attribute = document.CreateAttribute("number"); // создаём атрибут
                        attribute.Value = 1; // устанавливаем значение атрибута
                        element.Attributes.Append(attribute); // добавляем атрибут
                    }
            }
             */
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                gsCount = esbll.GetModelList("").Count;
                if (gsCount % 5 == 0)
                {
                    gsMaxPage = gsCount / 5;
                }
                else
                {
                    gsMaxPage = gsCount / 5 + 1;
                }
            }

            // 点击客房收入时获取客房收入信息
            if (!string.IsNullOrEmpty(Request["postTag"]))
            {
                if (Request["postTag"] == "grincome")
                {
                    string sqlStrByPage = "select RoomType, BedType, count(*) as ckorderCount, SUM(C.cTotalPrice) as Total_gr_Income from CheckIn C, GuestRoomInfo G" +
                                          " where(CheckinStatus = 0 or CheckinStatus = 1 or CheckinStatus = 2 or CheckinStatus = 3)" +
                                          " and C.Gid = G.Gid group by G.RoomType, G.BedType";
                    Response.Write(Get_Serialize_Data_FromSql(connectString, sqlStrByPage));
                    Response.End();
                }
            }

            // 点击额外服务收入时获取额外服务收入信息
            if (!string.IsNullOrEmpty(Request["postTag"]))
            {
                if (Request["postTag"] == "gsincome")
                {
                    List <ServiceOrder> sorderList = new List <ServiceOrder>();
                    sorderList = new ServiceOrderBLL().GetModelList("esOrderStatus = 0 or esOrderStatus = 1 or esOrderStatus = 2 or esOrderStatus = 3");
                    List <esorderInfo> orderinfoList = new List <esorderInfo>();
                    for (int b = 0; b < sorderList.Count; b++)
                    {
                        if (sorderList[b].esOrderContent != "")
                        {
                            esorderInfo info = new esorderInfo()
                            {
                                ordercontent = sorderList[b].esOrderContent
                            };
                            orderinfoList.Add(info);
                        }
                    }

                    List <goods> goodsList = new List <goods>();
                    string[]     goodsinfo;

                    for (int k = 0; k < orderinfoList.Count; k++)
                    {
                        goodsinfo = orderinfoList[k].ordercontent.Split(',');
                        for (int c = 0; c < goodsinfo.Length; c++)
                        {
                            goods singlegoods = new goods()
                            {
                                goodsname = goodsinfo[c].Split('*')[0],
                                count     = int.Parse(goodsinfo[c].Split('*')[1])
                            };
                            goodsList.Add(singlegoods);
                        }
                    }
                    List <goods> gsInfoList   = new List <goods>();
                    goods        singlegoods2 = new goods();


                    bool hasSame = false;

                    for (int m = 0; m < goodsList.Count; m++)
                    {
                        for (int n = 0; n < gsInfoList.Count; n++)
                        {
                            if (gsInfoList[n].goodsname == goodsList[m].goodsname)
                            {
                                gsInfoList[n].count += goodsList[m].count;
                                hasSame              = true;
                                break;
                            }
                        }
                        if (!hasSame)
                        {
                            singlegoods2 = new goods
                            {
                                goodsname = goodsList[m].goodsname,
                                count     = goodsList[m].count
                            };
                            gsInfoList.Add(singlegoods2);
                        }
                        else
                        {
                            hasSame = false;
                        }
                    }

                    ExServiceBLL esbll = new ExServiceBLL();
                    for (int r = 0; r < gsInfoList.Count; r++)
                    {
                        gsInfoList[r].TotalPrice = float.Parse(esbll.GetModelList("GoodsName = '" + gsInfoList[r].goodsname + "'")[0].GoodsPrice.ToString()) * gsInfoList[r].count;
                    }

                    JavaScriptSerializer subjson = new JavaScriptSerializer();
                    object serializer_obj        = subjson.Serialize(gsInfoList);
                    Response.Write(serializer_obj);
                    Response.End();
                }
            }
        }
Пример #22
0
 public IActionResult editPricePartialView(goods goods)
 {
     return(PartialView("editpricePartialView", goods));
 }
        public ActionResult addGoods()
        {
            service = new GoodService();

            swapperService     = new SwapperService();
            categoryService    = new CategoryService();
            subCategoryService = new SubCategoryService();


            int connectedSwapper = 1; // connected swapper -identity

            swapper user = swapperService.Get(u => u.id_swapper == connectedSwapper);

            ViewBag.user = user;


            string   brand       = Request.Form["brand"];
            string   description = Request.Form["desc"];
            DateTime date        = DateTime.Now;
            int      validity    = 0;
            int      quantity    = int.Parse(Request.Form["quantity"]);
            string   label       = Request.Form["label"];
            Accpted  accepted    = Accpted.no;

            int catId = int.Parse(Request.Form["cat"]);
            //category cat = categoryService.Get(c => c.id_category == catId);

            int subCatId = int.Parse(Request.Form["subCat"]);
            //subCategory subCat = subCategoryService.Get(sc => sc.id_subCategory == subCatId);

            goods newGood = new goods();

            newGood.label       = label;
            newGood.brand       = brand;
            newGood.description = description;
            newGood.date        = date;
            newGood.validity    = validity;
            newGood.quantity    = quantity;
            newGood.accepted    = accepted;

            //subCat.category = cat;

            newGood.subCategoryID = subCatId;
            newGood.swapperID     = user.id_swapper;
            service.Add(newGood);
            service.Commit();



            if (Request.Files[0].ContentLength > 0) // on a ajouté une image pour le produit
            {
                byte[] file = null;
                using (var binaryReader = new BinaryReader(Request.Files[0].InputStream))
                {
                    file = binaryReader.ReadBytes(Request.Files[0].ContentLength);
                }


                Image img = this.byteArrayToImage(file);
                img = new Bitmap(img, new Size(180, 180));

                string path = "~/swapperImgs/" + newGood.id_goods + ".jpg";
                img.Save(Server.MapPath(path), System.Drawing.Imaging.ImageFormat.Jpeg);


                newGood.image = path;
                service.Update(newGood);
                service.Commit();
            }



            return(RedirectToAction("SearchGood"));
        }
Пример #24
0
 /// <summary>
 /// 架构中不存在 goods 的注释。
 /// </summary>
 public void AddTogoods(goods goods)
 {
     base.AddObject("goods", goods);
 }
Пример #25
0
        private void metroTile6_Click(object sender, EventArgs e)
        {
            goods g = new goods();

            g.Show();
        }
Пример #26
0
        /// <summary>
        /// 根据表,获取一个SqlParameter数组
        /// </summary>
        /// <returns>SqlParameter[]</returns>
        public static SqlParameter[] GetSqlParameter(goods goodsExample)
        {
            List <SqlParameter> list_param = new List <SqlParameter>();

            if (!string.IsNullOrEmpty(goodsExample.g_price_yuan))
            {
                list_param.Add(new SqlParameter("@g_price_yuan", goodsExample.g_price_yuan));
            }
            else
            {
                list_param.Add(new SqlParameter("@g_price_yuan", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.g_standby1))
            {
                list_param.Add(new SqlParameter("@g_standby1", goodsExample.g_standby1));
            }
            else
            {
                list_param.Add(new SqlParameter("@g_standby1", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.g_standby2))
            {
                list_param.Add(new SqlParameter("@g_standby2", goodsExample.g_standby2));
            }
            else
            {
                list_param.Add(new SqlParameter("@g_standby2", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.g_standby3))
            {
                list_param.Add(new SqlParameter("@g_standby3", goodsExample.g_standby3));
            }
            else
            {
                list_param.Add(new SqlParameter("@g_standby3", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gimg))
            {
                list_param.Add(new SqlParameter("@gimg", goodsExample.gimg));
            }
            else
            {
                list_param.Add(new SqlParameter("@gimg", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gimg2))
            {
                list_param.Add(new SqlParameter("@gimg2", goodsExample.gimg2));
            }
            else
            {
                list_param.Add(new SqlParameter("@gimg2", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gname))
            {
                list_param.Add(new SqlParameter("@gname", goodsExample.gname));
            }
            else
            {
                list_param.Add(new SqlParameter("@gname", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gprice1))
            {
                list_param.Add(new SqlParameter("@gprice1", goodsExample.gprice1));
            }
            else
            {
                list_param.Add(new SqlParameter("@gprice1", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gprice2))
            {
                list_param.Add(new SqlParameter("@gprice2", goodsExample.gprice2));
            }
            else
            {
                list_param.Add(new SqlParameter("@gprice2", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gremark1))
            {
                list_param.Add(new SqlParameter("@gremark1", goodsExample.gremark1));
            }
            else
            {
                list_param.Add(new SqlParameter("@gremark1", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gremark2))
            {
                list_param.Add(new SqlParameter("@gremark2", goodsExample.gremark2));
            }
            else
            {
                list_param.Add(new SqlParameter("@gremark2", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gstate))
            {
                list_param.Add(new SqlParameter("@gstate", goodsExample.gstate));
            }
            else
            {
                list_param.Add(new SqlParameter("@gstate", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gstate1))
            {
                list_param.Add(new SqlParameter("@gstate1", goodsExample.gstate1));
            }
            else
            {
                list_param.Add(new SqlParameter("@gstate1", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gstate2))
            {
                list_param.Add(new SqlParameter("@gstate2", goodsExample.gstate2));
            }
            else
            {
                list_param.Add(new SqlParameter("@gstate2", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gstate3))
            {
                list_param.Add(new SqlParameter("@gstate3", goodsExample.gstate3));
            }
            else
            {
                list_param.Add(new SqlParameter("@gstate3", DBNull.Value));
            }
            if (goodsExample.gtid != 0)
            {
                list_param.Add(new SqlParameter("@gtid", goodsExample.gtid));
            }
            else
            {
                list_param.Add(new SqlParameter("@gtid", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gtitle))
            {
                list_param.Add(new SqlParameter("@gtitle", goodsExample.gtitle));
            }
            else
            {
                list_param.Add(new SqlParameter("@gtitle", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gurl))
            {
                list_param.Add(new SqlParameter("@gurl", goodsExample.gurl));
            }
            else
            {
                list_param.Add(new SqlParameter("@gurl", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gurl_yuan))
            {
                list_param.Add(new SqlParameter("@gurl_yuan", goodsExample.gurl_yuan));
            }
            else
            {
                list_param.Add(new SqlParameter("@gurl_yuan", DBNull.Value));
            }

            if (!string.IsNullOrEmpty(goodsExample.gurl2))
            {
                list_param.Add(new SqlParameter("@gurl2", goodsExample.gurl2));
            }
            else
            {
                list_param.Add(new SqlParameter("@gurl2", DBNull.Value));
            }
            SqlParameter[] param = new SqlParameter[list_param.Count];
            int            index = 0;

            foreach (SqlParameter p in list_param)
            {
                param[index] = p;
                index++;
            }
            return(param);
        }
Пример #27
0
 public void addNewGoods(goods goods)
 {
     _goodsRepo.addGoods(goods);
 }
Пример #28
0
 /// <summary>
 /// 更新
 /// </summary>
 /// <param name="goods">goods表实例</param>
 /// <returns>int</returns>
 public int Update(goods goodsExample)
 {
     DBHelper.sqlstr = "update goods set g_price_yuan=@g_price_yuan,g_standby1=@g_standby1,g_standby2=@g_standby2,g_standby3=@g_standby3,gdate='" + goodsExample.gdate.ToString("yyyy-MM-dd") + "',gdate1='" + goodsExample.gdate1.ToString("yyyy-MM-dd") + "',gdate2='" + goodsExample.gdate2.ToString("yyyy-MM-dd") + "',gdate3='" + goodsExample.gdate3.ToString("yyyy-MM-dd") + "',gimg=@gimg,gimg2=@gimg2,gname=@gname,gprice1=@gprice1,gprice2=@gprice2,gremark1=@gremark1,gremark2=@gremark2,gstate=@gstate,gstate1=@gstate1,gstate2=@gstate2,gstate3=@gstate3,gtid=@gtid,gtitle=@gtitle,gurl=@gurl,gurl_yuan=@gurl_yuan,gurl2=@gurl2 where gid=" + goodsExample.gid;
     return(DBHelper.ExecuteNonQuery(GetSqlParameter(goodsExample)));
 }
Пример #29
0
 public void updatePrice(goods goods)
 {
     _goodsRepo.updatePrice(goods);
 }
Пример #30
0
 /// <summary>
 /// 创建新的 goods 对象。
 /// </summary>
 /// <param name="goodsid">goodsid 的初始值。</param>
 /// <param name="name">name 的初始值。</param>
 public static goods Creategoods(string goodsid, string name)
 {
     goods goods = new goods();
     goods.goodsid = goodsid;
     goods.name = name;
     return goods;
 }
Пример #31
0
        //结束
        #endregion

        /// <summary>
        /// 代码生成数据库中的订单数据
        /// </summary>
        void sckjmen()
        {
            for (int i = 0; i < 10; i++)//重新载入订单表需要清空生的控件们
            {
                foreach (Control item in pan_goods.Controls)
                {
                    if (item == lab_tip)
                    {
                        continue;                 //除了悬浮提示外其它的都清除,然后重新再生成,达到刷新的效果
                    }
                    pan_goods.Controls.Remove(item);
                }
            }
            //查询有关于这个卖家的数据
            string    sql = string.Format("select * from goods where selledname = '{0}'", love.denglu_username == string.Empty ? "a" : love.denglu_username);
            DataTable d   = sqlHelper.ExecutedataTable(sql, CommandType.Text, null);

            //查询总金额
            string    fdas      = string.Format("select sum(fkje) from goods where goods.selledname = '{0}'", love.denglu_username == string.Empty ? "a" : love.denglu_username);
            DataTable jlk       = sqlHelper.ExecutedataTable(fdas, CommandType.Text, null);
            string    zongjinge = string.Empty;//总金额

            try
            {
                zongjinge    = jlk.Rows[0][0].ToString();//如果没有金额就会出错
                lab_tip.Text = string.Format("tip:亲爱的 {0} (づ ̄3 ̄)づ╭❤~,你总共售出了 {1} 件商品,总共获得盈利 {2} 元,再接再厉哦!", love.denglu_username == string.Empty ? "a" : love.denglu_username, d.Rows.Count.ToString(), zongjinge.ToString());
            }
            catch (Exception)
            {
                lab_tip.Text = string.Format("tip:亲爱的 {0} (づ ̄3 ̄)づ╭❤~,你总共售出了 {1} 件商品,总共获得盈利 {2} 元,再接再厉哦!", love.denglu_username == string.Empty ? "a" : love.denglu_username, d.Rows.Count.ToString(), 0);
                throw;
            }

            Point panzuixin = new Point();         //用来记录下pannel的最新的位置,一个pannel一个商品订单
            bool  bol       = true;                //如果pannel是第一次诞生那么他是true,否则会false

            for (int i = 0; i < d.Rows.Count; i++) //有多少个订单就循环多少次
            {
                Panel pan_gs = new Panel();        //用来记录下最新的位置
                pan_goods.Controls.Add(pan_gs);
                pan_gs.BorderStyle = BorderStyle.FixedSingle;
                pan_gs.Size        = new Size(pan_goods.Width - 80, 140);
                #region pan_gs的位置算法
                if (bol)                                                                                  //说明它是第一次诞生
                {
                    bol             = false;                                                              //说明有过了第一个pannel
                    pan_gs.Location = new Point((pan_goods.Width - pan_gs.Width) / 2, pan_goods.Top + 5); //x等于平均,y等于最外的pannel,最外的自带内边距,y轴不加
                    Point poc = new Point(pan_gs.Location.X, pan_gs.Location.Y + pan_gs.Height + 20);     //第一个pannel的x,y加20像素
                    panzuixin = poc;                                                                      //把第一次的我位置传出去
                }
                else//如果不是第一次诞生就使用上次的位置y轴加20像素
                {
                    pan_gs.Location = panzuixin;
                    Point poc = new Point(pan_gs.Location.X, pan_gs.Location.Y + pan_gs.Height + 20); //第一个pannel的x,y加20像素
                    panzuixin = poc;                                                                  //把最后一个pannel的位置传出去
                }
                #endregion
                //

                PictureBox compic = new PictureBox();//商品图片
                compic.Name     = "compic";
                compic.SizeMode = PictureBoxSizeMode.Zoom;
                compic.Size     = new Size(120, 120);
                sqlHelper.imagechu(d.Rows[i]["compic"], compic);
                //compic.BorderStyle = BorderStyle.FixedSingle;
                compic.Location = new Point(25, (pan_gs.Height - compic.Height) / 2);


                Label comname = new Label();//商品名
                comname.AutoSize = true;
                comname.Text     = "商品名称: " + d.Rows[i]["comname"].ToString();
                comname.Location = new Point(compic.Right + 30, compic.Top + 7);

                Label fkje = new Label();//付款金额
                fkje.AutoSize = true;
                fkje.Text     = "付款金额: " + d.Rows[i]["fkje"].ToString();
                fkje.Location = new Point(comname.Left, comname.Bottom);

                Label fktime = new Label();//付款时间
                fktime.AutoSize = true;
                fktime.Text     = "付款时间:" + d.Rows[i]["fktime"].ToString();
                fktime.Location = new Point(fkje.Left + 150, fkje.Top);

                Label cmid = new Label();//商品编号
                cmid.AutoSize = true;
                cmid.Text     = "商品编号: " + d.Rows[i]["cmid"].ToString();
                cmid.Location = new Point(fkje.Left, fkje.Bottom);

                Label pjdh = new Label();//评价单号
                pjdh.AutoSize = true;
                pjdh.Text     = "订单编号:" + d.Rows[i]["pjdh"].ToString();
                pjdh.Location = new Point(cmid.Left + 150, cmid.Top);

                goods ggg = new goods();
                ggg.Pjdh = long.Parse(d.Rows[i]["pjdh"].ToString());
                if (ggg.isorneirong())//ture说明没有评价内容,也没有评价星级,那么就开始评价
                {
                    //开始获取买家的昵称
                    string    strnc = string.Format("select nicheng from buyde where username= '******'", d.Rows[i]["buydename"].ToString());
                    DataTable dtnc  = sqlHelper.ExecutedataTable(strnc, CommandType.Text, null);

                    Label pjren = new Label();//评价人的昵称
                    pjren.Text     = "买家名称: " + dtnc.Rows[0]["nicheng"].ToString();
                    pjren.Tag      = "pjren";
                    pjren.AutoSize = true;
                    pan_gs.Controls.Add(pjren);
                    pjren.Location = new Point(cmid.Left, cmid.Bottom);


                    Label pjnr = new Label();//评价者的
                    pjnr.Text     = "买家 " + dtnc.Rows[0]["nicheng"].ToString() + " 对此次交易暂时未给出评价";
                    pjnr.Tag      = "pjnr";
                    pjnr.AutoSize = true;
                    pan_gs.Controls.Add(pjnr);
                    pjnr.Location = new Point(pjren.Left, pjren.Bottom + pjren.Height);
                }
                else//说明评价完星级和内容了,可以开始直接显示了
                {
                    Label pjxj = new Label();
                    pan_gs.Controls.Add(pjxj);
                    pjxj.AutoSize = true;
                    pjxj.Location = new Point(cmid.Left, cmid.Bottom);
                    pjxj.Text     = "评价星级:";          //后面记得加上数据库的星级
                    //查询数据库的星级然后循环出对应的星星数量
                    bool      diyicixx = true;        //判断是否第一次产生星星
                    Point     pinxx    = new Point(); //存储星星的最新位置
                    DataTable tabxj    = sqlHelper.ExecutedataTable(string.Format("select xingji,neirong from goods where pjdh = {0}", d.Rows[i]["pjdh"].ToString()), CommandType.Text, null);
                    int       jkx      = int.Parse(tabxj.Rows[0]["xingji"].ToString());
                    for (int forxx = 0; forxx < jkx; forxx++)
                    {
                        PictureBox xx = new PictureBox();                                         //星级放到评价单号的右边
                        pan_gs.Controls.Add(xx);
                        xx.Size  = new Size(19, 19);                                              //图片为19,正好盛放
                        xx.Image = Image.FromFile(Application.StartupPath + "\\image\\haop.png"); //好评图片
                        if (diyicixx)
                        {
                            xx.Location = new Point(pjxj.Right, pjxj.Top - 4);
                            pinxx       = new Point(xx.Right + xx.Width + 10, xx.Top);
                            diyicixx    = false;//执行后说明它不是第一次运行
                        }
                        else
                        {
                            xx.Location = pinxx;
                            Point temp = new Point(xx.Right + xx.Width + 10, xx.Top);
                            pinxx = temp;
                        }
                    }

                    Label pjtime = new Label();
                    pjtime.AutoSize = true;
                    pjtime.Text     = "评价时间:" + d.Rows[0]["pjtime"].ToString();
                    pjtime.Location = new Point(pjxj.Right + 240, pjxj.Top);//240五颗星位置
                    pan_gs.Controls.Add(pjtime);


                    Label neirong = new Label();//评价内容
                    neirong.AutoSize = true;
                    neirong.Text     = "评价内容:" + tabxj.Rows[0]["neirong"].ToString();
                    neirong.Location = new Point(pjxj.Left, pjxj.Bottom + pjxj.Height);
                    pan_gs.Controls.Add(neirong);

                    //开始获取买家的昵称
                    string    strnc = string.Format("select nicheng from buyde where username= '******'", d.Rows[i]["buydename"].ToString());
                    DataTable dtnc  = sqlHelper.ExecutedataTable(strnc, CommandType.Text, null);

                    Label pjren = new Label();//评价人的昵称
                    pjren.Text     = "买家名称: " + dtnc.Rows[0]["nicheng"].ToString();
                    pjren.Tag      = "pjren";
                    pjren.AutoSize = true;
                    pan_gs.Controls.Add(pjren);
                    pjren.Location = new Point(pjdh.Right + 50, pjdh.Top);
                }
                //pan_gs.ForeColor = Color.Transparent;
                Control[] ctl = { pjdh, cmid, comname, compic, fkje, fktime };
                pan_gs.Controls.AddRange(ctl);

                Button bbb = new Button();
                pan_goods.Controls.Add(bbb);
                bbb.Location = new Point(100, 100);//让它来承载焦点,否则将会自动把焦点赋予给星级框
                bbb.Focus();
            }//订单循环结束
        }
Пример #32
0
 public GoodModels()
 {
     listGoods = IGS.GetAll();
     goood     = new goods();
 }
Пример #33
0
        public void deleteGoods(goods one)
        {
            string str = "delete from global where number =" + "'" + one.number + "'";

            excuteCommand(str);
        }