コード例 #1
0
        protected void btn_Save_Click(object sender, EventArgs e)
        {
            int companyid = Convert.ToInt32(drp_company.SelectedValue);
            OrderEntity od = new OrderEntity();
            od.Amount = Math.Round(Convert.ToDecimal(hd_TotalAmount.Value),2, MidpointRounding.AwayFromZero);    //支付总价
            od.CompanyId = companyid;                               //采购商ID
            od.StandardAmount = od.Amount;                          //汇总总价
            od.CustomerId = logic.sysAdmin.AdminID;                 //用户ID,电话订单就代表录入者ID
            od.FireightFee = Convert.ToDecimal(txt_fireightFee.Value);  //运费
            od.Note = txt_Note.Text;                                     //备注
            od.OrderNo = ""; //传空值,存储过程自动得到订单编号
            od.Source = "3";    //订单来源:1、网站订单;2、电话订单;3.补单
            od.Taxfee = Convert.ToDecimal(txt_taxfee.Value); //税费
            od.Status = "4";  //订单状态:“1”:已提交;“2”备货中;“3”已发货;“4”交易成功;“5”交易关闭;
            od.ReceiveDt = Convert.ToDateTime(DateTime.Now.AddDays(1).ToShortDateString()).AddHours(Convert.ToInt32(ddl_receiveTime.SelectedValue));    //收货时间
            string[] splitstr = { "," };
            string[] str_vpros = hd_proScope.Value.Split(splitstr, StringSplitOptions.RemoveEmptyEntries);
            od.TypeCount = str_vpros.Length / 6;
            int orderid = logic.order.insert(od);

            // businessNature
            string businessNature = logic.company.getById(companyid).BusinessNature;

            logic.order.updateStatusDate(orderid,od.ReceiveDt); //修改订单状态时间为订单配送时间

            for (int i = 0; i < str_vpros.Length; i += 6)
            {
                int proid = Convert.ToInt32(str_vpros[i]);  //商品ID
                OrderItemEntity _oritem = new OrderItemEntity();
                _oritem.CustomerId = logic.sysAdmin.AdminID;
                _oritem.ProductId = proid;
                _oritem.BusinessNature = businessNature;

                decimal sellerPrice = Convert.ToDecimal(str_vpros[i + 2]);
                //decimal price = logic.product.getBuyerPrice(Convert.ToInt32(drp_company.SelectedValue), sellerPrice, proid);
                decimal price = Convert.ToDecimal(str_vpros[i + 5]);
                _oritem.Price = price;  //商品价格
                _oritem.Quantity = Convert.ToDecimal(str_vpros[i + 3]); //数量
                _oritem.InitQuantity = Convert.ToDecimal(str_vpros[i + 3]); //实际数量
                _oritem.Note = str_vpros[i + 4] == "0" ? "" : str_vpros[i + 4];     //备注
                _oritem.OrderId = orderid;
                ProductEntity pro = logic.product.getById(proid);
                _oritem.SellerId = 43;                //供应商ID

                _oritem.SellerPrice = sellerPrice;           //供应价格
                _oritem.Unit = pro.Unit;                         //单位
                logic.orderItem.insert(_oritem);
            }
            Library.Script.ClientMsgUrl("订单保存成功!", "orderList.aspx");
        }
コード例 #2
0
        // 生成订单数据
        protected void btn_Save_Click(object sender, EventArgs e)
        {
            int companyid = Convert.ToInt32(drp_company.SelectedValue);
            OrderEntity od = new OrderEntity();
            od.Amount = Convert.ToDecimal(hd_TotalAmount.Value);    //支付总价
            od.CompanyId = companyid;                               //采购商ID
            od.StandardAmount = od.Amount;                          //汇总总价
            od.CustomerId = logic.sysAdmin.AdminID;                 //用户ID,电话订单就代表录入者ID
            od.FireightFee = Convert.ToDecimal(txt_fireightFee.Value);  //运费
            od.Note = txt_Note.Text;                                     //备注
            od.OrderNo = ""; //传空值,存储过程自动得到订单编号
            od.Source = "2";    //订单来源:1、网站订单;2、电话订单
            od.Taxfee = Convert.ToDecimal(txt_taxfee.Value); //税费
            od.Status = "1";  //订单状态:“1”:已提交;“2”备货中;“3”已发货;“4”交易成功;“5”交易关闭;
            //string time = ddl_receiveTime.SelectedValue.Substring(ddl_receiveTime.SelectedValue.IndexOf("-") + 1, ddl_receiveTime.SelectedValue.Length - (ddl_receiveTime.SelectedValue.IndexOf("-") + 1));
            //od.ReceiveDt = Convert.ToDateTime(ext_receiveDt.Value).AddHours(Convert.ToInt32(time.Substring(0,time.IndexOf(":"))));    //收货时间

            string timeRange = ddl_receiveTime.SelectedItem.Text;
            int hour = Convert.ToInt32(timeRange.Substring(timeRange.IndexOf("-") + 1, timeRange.Length - (timeRange.IndexOf("-") + 4)));
            od.ReceiveDt = Convert.ToDateTime(ext_receiveDt.Value).AddHours(hour);    //收货时间

            string[] splitstr = { "," };
            string[] str_vpros = hd_proScope.Value.Split(splitstr, StringSplitOptions.RemoveEmptyEntries);
            od.TypeCount = str_vpros.Length / 5;
            int orderid = logic.order.insert(od);
            for (int i = 0; i < str_vpros.Length; i += 5)
            {
                int proid = Convert.ToInt32(str_vpros[i]);  //商品ID
                OrderItemEntity _oritem = new OrderItemEntity();
                _oritem.CustomerId = logic.sysAdmin.AdminID;
                _oritem.ProductId = proid;
                _oritem.Price = Convert.ToDecimal(str_vpros[i + 2]);  //商品价格
                _oritem.Quantity = Convert.ToDecimal(str_vpros[i + 3]); //数量
                _oritem.InitQuantity = Convert.ToDecimal(str_vpros[i + 3]); //实际数量
                _oritem.Note = str_vpros[i + 4] == "0" ? "" : str_vpros[i + 4];     //备注
                _oritem.OrderId = orderid;
                PriceEntity pr = logic.price.getByProduct(proid,companyid);
                _oritem.SellerId = pr.CompanyId;                //供应商ID
                _oritem.SellerPrice = pr.SellerPrice;           //供应价格
                _oritem.Unit = pr.Unit;                         //单位
                logic.orderItem.insert(_oritem);
            }
            Library.Script.ClientMsgUrl("订单保存成功!", "orderList.aspx");
        }
コード例 #3
0
        protected void btn_Save_Click(object sender, EventArgs e)
        {
            OrderEntity Dynamicorder = logic.order.getDynamicById(id);
            StringBuilder where = new StringBuilder();
            where.Append("1=1");
            where.AppendFormat(" AND orderId={0}", id);
            DataSet ds = logic.order.selectDynamicOrderItem(where.ToString(), "productId desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
            DataTable dt = ds.Tables[1];
            int errorno = 0;
            decimal amount = 0;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["nowprice"].ToString() != "")
                {

                    amount = amount + Convert.ToDecimal(Convert.ToDouble(dt.Rows[i]["nowprice"].ToString()) * Convert.ToDouble(dt.Rows[i]["quantity"].ToString()));
                }
                else
                {
                    errorno++;
                    logic.orderItem.updateDynamicOrderItem(Convert.ToInt32(dt.Rows[i]["orderId"].ToString()), Convert.ToInt32(dt.Rows[i]["productId"].ToString()), dt.Rows[i]["businessnature"].ToString());
                }
            }
            OrderEntity order = Dynamicorder;
            order.Amount = Math.Round(amount,2, MidpointRounding.AwayFromZero);
            order.StandardAmount = order.Amount;
            order.OrderNo = "";
            order.Status = "1";
            int OrderId = logic.order.insertWithDynamicOrder(order);
            string OrderNo = logic.order.getById(OrderId).OrderNo;
            int adminId = logic.sysAdmin.AdminID;
            logic.order.updateDynamicOrder(id, OrderNo, adminId);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["nowprice"].ToString() != "")
                {
                    OrderItemEntity oi = new OrderItemEntity();
                    oi = new OrderItemEntity();
                    oi.CustomerId = Convert.ToInt32(dt.Rows[i]["customerId"].ToString());
                    oi.SellerId = Convert.ToInt32(dt.Rows[i]["sellerId"].ToString());
                    oi.ProductId = Convert.ToInt32(dt.Rows[i]["productId"].ToString());
                    oi.Price = Convert.ToDecimal(dt.Rows[i]["nowprice"].ToString());
                    oi.SellerPrice = Convert.ToDecimal(dt.Rows[i]["sellerPrice"].ToString());
                    oi.Unit = dt.Rows[i]["unit"].ToString();
                    oi.Quantity = Convert.ToDecimal(dt.Rows[i]["quantity"].ToString());
                    oi.Note = dt.Rows[i]["note"].ToString();
                    oi.OrderId = OrderId;
                    oi.InitQuantity = oi.Quantity;
                    oi.BusinessNature = dt.Rows[i]["businessNature"].ToString();
                    logic.orderItem.insert(oi);
                }
            }
            Response.Redirect("DynamicOrderList.aspx");
        }
コード例 #4
0
 //添加商品
 protected void lbn_AddOrderItem_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < rpt_Products.Items.Count; i++)      //循环Repeater
     {
         RepeaterItem row = rpt_Products.Items[i];
         HiddenField hidproId = row.FindControl("hid_productId") as HiddenField;
         Label lblproName = row.FindControl("lbl_proName") as Label;
         TextBox lblsellerPrice = row.FindControl("txt_Price") as TextBox;  //供应价
         TextBox txtBuyPrice = row.FindControl("txt_BuyPrice") as TextBox;  //购买价格
         TextBox txtQuantity = row.FindControl("txtQuantity") as TextBox;
         TextBox txtnote = row.FindControl("txtNote") as TextBox;
         TextBox txtUnit = row.FindControl("lbl_unit") as TextBox;
         CheckBox cbxSelect = row.FindControl("cbx_isSelect") as CheckBox;
         if (cbxSelect.Checked)            //找到选择的商品加入数据库
         {
             OrderItemEntity oi = new OrderItemEntity();
             oi.CustomerId = Convert.ToInt32(hd_customerid.Value);
             oi.Note = txtnote.Text; ;
             oi.OrderId = Convert.ToInt32(hd_orderid.Value);
             oi.Price = Convert.ToDecimal(txtBuyPrice.Text);
             oi.ProductId = Convert.ToInt32(hidproId.Value);
             oi.Quantity = Convert.ToDecimal(txtQuantity.Text);
             oi.InitQuantity = oi.Quantity;
             oi.SellerId = 146;
             oi.SellerPrice = Convert.ToDecimal(lblsellerPrice.Text.Trim());
             oi.Unit = logic.product.getById(oi.ProductId).Unit;
             logic.orderItem.update(oi);
         }
     }
     int orderid = Convert.ToInt32(hd_orderid.Value);
     rptBind();
     getDetails(orderid);
 }
コード例 #5
0
ファイル: orderItem.cs プロジェクト: atian15/peisong-expert
 public static void insertDynamicOrderItem(OrderItemEntity _orderItem)
 {
     OrderItem.insertDynamicOrderItem(_orderItem);
 }
コード例 #6
0
 protected void lbn_AddOrderItem_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < rpt_Products.Items.Count; i++)      //循环Repeater
     {
         RepeaterItem row = rpt_Products.Items[i];
         HiddenField hidproId = row.FindControl("hid_productId") as HiddenField;
         HiddenField hidsellerId = row.FindControl("hid_sellerId") as HiddenField;
         HiddenField hidsellerPrice = row.FindControl("hid_sellerPrice") as HiddenField;
         Label lblprice = row.FindControl("lbl_price") as Label;
         HiddenField lblnature = row.FindControl("hidNature") as HiddenField;
         TextBox txtQuantity = row.FindControl("txtQuantity") as TextBox;
         TextBox txtnote = row.FindControl("txtNote") as TextBox;
         CheckBox cbxUser = row.FindControl("cbx_isUser") as CheckBox;
         if (cbxUser.Checked)            //找到选择的商品加入数据库
         {
             OrderItemEntity oi = new OrderItemEntity();
             oi.CustomerId = logic.order.getDynamicById(id).CustomerId;
             oi.Note = txtnote.Text; ;
             oi.OrderId = id;
             oi.Price = Convert.ToDecimal(lblprice.Text);
             oi.ProductId = Convert.ToInt32(hidproId.Value);
             oi.Quantity = Convert.ToDecimal(txtQuantity.Text);
             oi.InitQuantity = oi.Quantity;
             oi.BusinessNature = lblnature.Value;
             PriceEntity pr = logic.price.getByProduct(oi.ProductId, lblnature.Value);
             oi.SellerId = pr.CompanyId;
             oi.SellerPrice = pr.SellerPrice;
             oi.Unit = pr.Unit;
             logic.orderItem.insertDynamicOrderItem(oi);
         }
     }
     logic.order.updateDynamiceOrderByOrderId(id, logic.sysAdmin.AdminID);
     rptBind();
     getDetails(id);
     rtpDobind(id);
     dynamicorder_details.Show();
 }
コード例 #7
0
ファイル: orderItem.cs プロジェクト: atian15/peisong-expert
 public static void insert(OrderItemEntity _orderItem)
 {
     OrderItem.insert(_orderItem);
 }
コード例 #8
0
ファイル: orderItem.cs プロジェクト: atian15/peisong-expert
 public static void update(OrderItemEntity _orderItem)
 {
     OrderItem.update(_orderItem);
 }
コード例 #9
0
        // 固定报价商品添加
        protected void lbn_AddWeeklyOrderItem_Click(object sender,EventArgs e)
        {
            TextBox txtNote = null;
            TextBox txtQuantity = null;
            HiddenField hid_bpid = null;
            Label lbl_price = null;
            Label lbl_unit = null;

            foreach (RepeaterItem item in rpt_WeeklyProducts.Items)
            {
                if (item.ItemType== ListItemType.AlternatingItem || item.ItemType== ListItemType.Item)
                {
                    CheckBox chk = item.FindControl("cbx_isSelect") as CheckBox;
                    if (chk!=null && chk.Checked)
                    {
                        txtNote = item.FindControl("txtNote") as TextBox;
                        txtQuantity = item.FindControl("txtQuantity") as TextBox;
                        hid_bpid = item.FindControl("hid_bpid") as HiddenField;
                        lbl_price = item.FindControl("lbl_price") as Label;
                        lbl_unit = item.FindControl("lbl_unit") as Label;

                        OrderItemEntity oi = new OrderItemEntity();
                        oi.CustomerId = Convert.ToInt32(hd_customerid.Value);
                        oi.Note = txtNote.Text;
                        oi.OrderId = Convert.ToInt32(hd_orderid.Value);
                        oi.Price = Convert.ToDecimal(lbl_price.Text);
                        oi.Quantity = Convert.ToDecimal(txtQuantity.Text);
                        oi.InitQuantity = oi.Quantity;
                        oi.BusinessNature = chk.Attributes["businessNature"];

                        BuyerFixedPricePeriodItemEntity bfpEnt = logic.buyerFixedPricePeriodItem.getBybpId(Convert.ToInt32(hid_bpid.Value));
                        oi.ProductId = bfpEnt.ProductId;
                        oi.SellerId = bfpEnt.SellerId;
                        oi.SellerPrice = bfpEnt.SellerPrice;
                        oi.Unit = lbl_unit.Text.Trim();
                        logic.orderItem.update(oi);
                    }
                }
            }

            int orderid = Convert.ToInt32(hd_orderid.Value);
            rptBind();
            getDetails(orderid);
        }
コード例 #10
0
        //添加商品
        protected void lbn_AddOrderItem_Click(object sender, EventArgs e)
        {
            foreach (RepeaterItem row in rpt_Products.Items)
            {
                if (row.ItemType == ListItemType.AlternatingItem || row.ItemType == ListItemType.Item)
                {
                    CheckBox cbxUser = row.FindControl("cbx_isUser") as CheckBox;
                    TextBox txtQuantity = row.FindControl("txtQuantity") as TextBox;
                    TextBox txtnote = row.FindControl("txtNote") as TextBox;

                    if (cbxUser.Checked)
                    {
                        OrderItemEntity oi = new OrderItemEntity();
                        oi.CustomerId = Convert.ToInt32(hd_customerid.Value);
                        oi.Note = txtnote.Text;
                        oi.OrderId = Convert.ToInt32(hd_orderid.Value);
                        oi.Price = Convert.ToDecimal(cbxUser.Attributes["price"]);
                        oi.ProductId = Convert.ToInt32(cbxUser.Attributes["productId"]);
                        oi.Quantity = Convert.ToDecimal(txtQuantity.Text);
                        oi.InitQuantity = oi.Quantity;
                        oi.BusinessNature = cbxUser.Attributes["businessNature"];
                        PriceEntity pr = logic.price.getByProduct(oi.ProductId, oi.BusinessNature);
                        oi.SellerId = pr.CompanyId;
                        oi.SellerPrice = pr.SellerPrice;
                        oi.Unit = pr.Unit;
                        logic.orderItem.update(oi);
                    }
                }
            }

            int orderid = Convert.ToInt32(hd_orderid.Value);
            rptBind();
            getDetails(orderid);
        }
コード例 #11
0
        //添加商品
        protected void lbn_AddOrderItem_Click(object sender, EventArgs e)
        {
            int companyId = 0;
            int.TryParse(hd_companyid.Value, out companyId);

            // businessNature
            string businessNature = "1";
            DAL.CompanyEntity companyEntity = logic.company.getById(companyId);

            if (companyEntity!=null)
            {
                businessNature = companyEntity.BusinessNature;
            }

            for (int i = 0; i < rpt_Products.Items.Count; i++)      //循环Repeater
            {
                RepeaterItem row = rpt_Products.Items[i];
                HiddenField hidproId = row.FindControl("hid_productId") as HiddenField;
                Label lblproName = row.FindControl("lbl_proName") as Label;
                TextBox lblsellerPrice = row.FindControl("txt_Price") as TextBox;  //供应价
                TextBox txtBuyPrice = row.FindControl("txt_BuyPrice") as TextBox;  //购买价格
                TextBox txtQuantity = row.FindControl("txtQuantity") as TextBox;
                TextBox txtnote = row.FindControl("txtNote") as TextBox;
                TextBox txtUnit = row.FindControl("lbl_unit") as TextBox;
                CheckBox cbxSelect = row.FindControl("cbx_isSelect") as CheckBox;
                DropDownList ddl = row.FindControl("ddl") as DropDownList;
                if (cbxSelect.Checked)            //找到选择的商品加入数据库
                {
                    OrderItemEntity oi = new OrderItemEntity();
                    oi.CustomerId = Convert.ToInt32(hd_customerid.Value);
                    oi.Note = txtnote.Text; ;
                    oi.OrderId = Convert.ToInt32(hd_orderid.Value);
                    oi.Price = Convert.ToDecimal(txtBuyPrice.Text);
                    oi.ProductId = Convert.ToInt32(hidproId.Value);
                    oi.Quantity = Convert.ToDecimal(txtQuantity.Text);
                    oi.InitQuantity = oi.Quantity;
                    int sellerid = Convert.ToInt32(ddl.SelectedValue);
                    oi.SellerId = sellerid;
                    oi.SellerPrice = Convert.ToDecimal(lblsellerPrice.Text.Trim());
                    oi.Unit = logic.product.getById(oi.ProductId).Unit;
                    oi.BusinessNature = businessNature;
                    logic.orderItem.update(oi);
                }
            }
            int orderid = Convert.ToInt32(hd_orderid.Value);
            rptBind();
            getDetails(orderid);
        }