private int InserirPedidoVenda(SAPbobsCOM.Company oCompany, OrderPluggto pedidoPluggto) { try { if (oCompany.Connected) { OrdersDAL orderDAL = new OrdersDAL(oCompany); string messageError = ""; int oOrderNum = 0; Boolean inserir = true; foreach (Item item in pedidoPluggto.Order.items) { if (string.IsNullOrEmpty(item.sku) && inserir) { this.log.WriteLogTable(oCompany, EnumTipoIntegracao.PedidoVenda, pedidoPluggto.Order.id, "", EnumStatusIntegracao.Erro, "Um ou mais item(s) do pedido está com o código de referência inválido."); this.log.WriteLogPedido("Um ou mais item(s) do pedido está com o código de referência inválido."); inserir = false; } } if (inserir) { oOrderNum = orderDAL.InsertOrder(pedidoPluggto.Order, out messageError); } } return(0); } catch (Exception e) { this.log.WriteLogPedido("Exception InserirPedidoVenda " + e.Message); throw; } }
public IHttpActionResult UpdateBakeryItem(int id) { OrdersDAL dal = new OrdersDAL(); dal.ChangeActivityBakery(id); return(Ok()); }
private int InserirPedidoVenda(SAPbobsCOM.Company oCompany, Order pedidoMl) { try { if (oCompany.Connected) { OrdersDAL orderDAL = new OrdersDAL(oCompany); string messageError = ""; int oOrderNum = 0; Boolean inserir = true; foreach (Order_Items item in pedidoMl.order_items) { if (item.item.seller_custom_field == null && inserir) { this.log.WriteLogTable(oCompany, EnumTipoIntegracao.PedidoVenda, pedidoMl.id.ToString(), "", EnumStatusIntegracao.Erro, "Um ou mais item(s) do pedido está com o código de referência inválido."); //throw new ArgumentException("Não foi possível criar o Pedido de Venda para o pedido "+pedidoVtex.orderId+" pois um ou mais item(s) do pedido está com o código de referência inválido."); inserir = false; } } if (inserir) { oOrderNum = orderDAL.InsertOrder(pedidoMl, out messageError); } } return(0); } catch (Exception e) { this.log.WriteLogPedido("Exception InserirPedidoVenda " + e.Message); throw; } }
public ActionResult Orders(int permissionLevel = 0) { AllOrdersModel orders = new AllOrdersModel(); OrdersDAL dal = new OrdersDAL(); orders.User = Session["User"] as UserInfoModel; //admin if (permissionLevel == 1 || orders.User.IsAdmin) { orders.DeliOrders = dal.GetAllDeliOrders(); orders.BakeryOrders = dal.GetAllBakeryOrders(); } //bakery else if (permissionLevel == 2 || orders.User.IsBakery) { orders.BakeryOrders = dal.GetAllBakeryOrders(); } //deli else if (permissionLevel == 3 || orders.User.IsDeli) { orders.DeliOrders = dal.GetAllDeliOrders(); } return(View("Orders", orders)); }
private void BindData() { OrdersDAL orders = new OrdersDAL(); DataSet ds = orders.GetAllOrders(); gvOrders.DataSource = ds; gvOrders.DataBind(); }
protected void ddlOrderDate_SelectedIndexChanged(object sender, EventArgs e) { OrdersDAL orders = new OrdersDAL(); DataSet ds = orders.GetOrdersByDateType(ddlOrderDate.SelectedValue); gvOrders.DataSource = ds; gvOrders.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.Label1.Text = OrdersDAL.selectOrderState(1).ToString(); this.Label2.Text = OrdersDAL.selectOrderState(2).ToString(); this.Label3.Text = OrdersDAL.selectOrderState(3).ToString(); this.Label4.Text = OrdersDAL.selectOrderState(4).ToString(); } }
protected void gvOrders_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = gvOrders.Rows[e.RowIndex]; int customerId = Convert.ToInt32(((Label)row.FindControl("lblCustID")).Text); string address = ((TextBox)row.FindControl("Address_Txt_Box")).Text; OrdersDAL orders = new OrdersDAL(); orders.UpdateCustomerAddress(address, customerId); gvOrders.EditIndex = -1; BindData(); }
public ActionResult DeliOrder(DeliOrderModel order) { OrdersDAL dal = new OrdersDAL(); if (dal.SaveDeliOrder(order)) { return(RedirectToAction("Orders")); } else { return(View("DeliOrder", order)); } }
/// <summary> /// 获取购物车列表 /// </summary> /// <param name="ordertype"></param> /// <param name="userid"></param> /// <returns></returns> public static List <ProductDetail> GetShoppingCart(EnumDocType ordertype, string userid) { DataTable dt = OrdersDAL.GetShoppingCart((int)ordertype, userid); List <ProductDetail> list = new List <ProductDetail>(); foreach (DataRow dr in dt.Rows) { ProductDetail model = new ProductDetail(); model.FillData(dr); list.Add(model); } return(list); }
protected void BtnQuery_Click(object sender, EventArgs e) { string orderDateFilterValue = ddlOrderDate.SelectedValue == "" ? "Last 6 Months" : ddlOrderDate.SelectedValue; string customerId = txtBoxCustomerID.Text == "" ? null : txtBoxCustomerID.Text; string custName = txtBoxUserName.Text == "" ? null : txtBoxUserName.Text; string salesMgr = ddlSalesManager.SelectedValue == "" ? null : ddlSalesManager.SelectedValue; OrdersDAL orders = new OrdersDAL(); DataSet ds = orders.GetOrdersWithFilterOptions(orderDateFilterValue, customerId, custName, salesMgr); gvOrders.DataSource = ds; gvOrders.DataBind(); }
private void button2_Click(object sender, EventArgs e) { OrdersDAL sqlbase; sqlbase = new OrdersDAL(); sqlbase.OpenConnection(ConfigurationManager.ConnectionStrings[ "Vmax44Parser.Properties.Settings.vmax44parserConnectionString"].ToString()); int orderid = sqlbase.LookUpOrderId(comboBox1.SelectedItem.ToString()); sqlbase.InsertParsedDataCollection(orderid, dataBase); sqlbase.CloseConnection(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["AID"] == null) { Response.Redirect("Default.aspx"); } if (!IsPostBack) { string OID = Request.QueryString["OID"]; this.Repeater1.DataSource = OrdersDAL.getOrdersByOID(OID); this.Repeater1.DataBind(); this.Repeater2.DataSource = OrderDetailsDAL.getOrderDetailByOID(OID); this.Repeater2.DataBind(); } }
/// <summary> /// 获取单据列表 /// </summary> /// <param name="userid">创建人(拥有者)</param> /// <param name="type">类型</param> /// <param name="status">状态</param> /// <param name="keywords">关键词</param> /// <param name="pageSize">页Size</param> /// <param name="pageIndex">页码</param> /// <param name="totalCount">总数</param> /// <param name="pageCount"><总页/param> /// <param name="clientID">客户端ID</param> /// <returns></returns> public static List <StorageDoc> GetStorageDocList(string userid, EnumDocType type, EnumDocStatus status, string keywords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID) { DataSet ds = OrdersDAL.GetStorageDocList(userid, (int)type, (int)status, keywords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID); List <StorageDoc> list = new List <StorageDoc>(); foreach (DataRow dr in ds.Tables[0].Rows) { StorageDoc model = new StorageDoc(); model.FillData(dr); model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientID); model.StatusStr = GetDocStatusStr(model.DocType, model.Status); list.Add(model); } return(list); }
public void CreateOrder() { var order = new Order(); order.CustomerID = "VINET"; order.EmployeeID = 5; order.OrderDate = DateTime.Now; order.ShipVia = 1; order.Freight = 10.05m; order.ShipName = "Toms Spezialitäten"; order.ShipAddress = "Luisenstr. 48"; order.ShipCity = "Münster"; order.ShipPostalCode = "44087"; order.ShipCountry = "Germany"; var dal = new OrdersDAL(); dal.CreateNewOrder(order); }
protected void Button1_Click(object o, EventArgs e) { //1>.构建订单表对象: Order orders = new Order(); orders.OID = OrdersDAL.GetNewOrderID(); //订单编号 orders.MID = Convert.ToInt32(Session["login"]); orders.ODate = Convert.ToDateTime(DateTime.Now.ToString()); orders.OConsignee = this.txtName.Text; orders.OAddress = this.txtAddress.Text; orders.OTelephone = this.txtTel.Text; orders.OState = 1; //新订单 //2>.构建订单详细表集合 List <OrderDetails> listDetails = new List <OrderDetails>(); //得到购物车集合 if (Request.QueryString["ids"] == null) { return; } string ids = Request.QueryString["ids"]; ids = ids.Substring(0, ids.Length - 1); List <Trade> listTrade = TradeDAL.getTradeByMIDAndBIDS(Convert.ToInt32(Session["login"]), ids); foreach (Trade trade in listTrade) { OrderDetails details = new OrderDetails(); details.OID = orders.OID; //订单编号 details.BID = trade.BID; //书籍编号 details.BPrice = trade.BPrice; //书籍价格 details.BCount = trade.BCount; //购买数量 listDetails.Add(details); } orders.OSumPrice = Convert.ToInt32(this.Label1.Text); //总计; //保存订单: int count = OrdersDAL.SavaOrder(orders, listDetails); //if (txtName.Text!=null && txtTel.Text!=null && txtAddress!=null) //{ if (count > 0) { Response.Redirect("done.aspx?OID=" + orders.OID); } }
public ActionResult BakeryOrder(BakeryOrderModel order) { if (order.Kitname == null) { order.Kitname = "n/a"; } OrdersDAL dal = new OrdersDAL(); if (dal.SaveBakeryOrder(order)) { return(RedirectToAction("Orders")); } else { return(View("BakeryOrder", order)); } }
public IEnumerable <DeliOrderModel> GetDeliOrderModels(int id) { var output = new DeliOrderModel(); OrdersDAL dal = new OrdersDAL(); List <DeliOrderModel> orders = dal.GetAllDeliOrders(); for (int i = 0; i < orders.Count; i++) { if (orders[i].Id == id) { output = orders[i]; } } List <DeliOrderModel> outputt = new List <DeliOrderModel>(); outputt.Add(output); return(outputt); }
public Form1() { InitializeComponent(); dataBase = new ParsedDataCollection(); dataCollectionBindingSource.DataSource = dataBase; dataGridView1.DataSource = dataCollectionBindingSource; OrdersDAL sqlbase = new OrdersDAL(); sqlbase.OpenConnection(ConfigurationManager.ConnectionStrings[ "Vmax44Parser.Properties.Settings.vmax44parserConnectionString"].ToString()); DataTable orders = sqlbase.GetAllOrdersAsDataTable(); foreach (DataRow row in orders.Rows) { comboBox1.Items.Add(row.Field <string>("OrderNumber")); } sqlbase.CloseConnection(); }
/// <summary> /// 创建单据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string CreateStorageDoc(StorageDoc model, string userid, string operateip, string clientid) { string docid = Guid.NewGuid().ToString(); SqlConnection conn = new SqlConnection(OrdersDAL.ConnectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { bool bl = OrdersDAL.AddStorageDoc(docid, model.DocType, model.TotalMoney, model.CityCode, model.Address, model.Remark, userid, operateip, clientid, tran); if (bl) { //单据明细 foreach (var detail in model.Details) { if (!OrdersDAL.AddStorageDocDetail(docid, detail.AutoID, detail.ProductDetailID, detail.Quantity, detail.Price, detail.TotalMoney, detail.BatchCode, clientid, tran)) { tran.Rollback(); conn.Dispose(); return(""); } } tran.Commit(); conn.Dispose(); return(docid); } else { tran.Rollback(); conn.Dispose(); return(""); } } catch (Exception ex) { tran.Rollback(); conn.Dispose(); return(""); } }
/// <summary> /// 获取单据详情 /// </summary> /// <param name="docid">单据ID</param> /// <param name="clientid">客户端ID</param> /// <returns></returns> public static StorageDoc GetStorageDetail(string docid, string clientid) { DataSet ds = OrdersDAL.GetStorageDetail(docid, clientid); StorageDoc model = new StorageDoc(); if (ds.Tables.Contains("Doc") && ds.Tables["Doc"].Rows.Count > 0) { model.FillData(ds.Tables["Doc"].Rows[0]); model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, clientid); model.StatusStr = GetDocStatusStr(model.DocType, model.Status); model.Details = new List <StorageDetail>(); foreach (DataRow item in ds.Tables["Details"].Rows) { StorageDetail details = new StorageDetail(); details.FillData(item); model.Details.Add(details); } } return(model); }
/// <summary> /// Configuring order by asking customer. /// </summary> private void ProcessingOrder() { if (_botMoodState != BotEmotionalStatus.Friendly) { CalmBot(); } WriteLineWithSpecColor("Now i'll show you our menu."); string answer = string.Empty; bool IsExitAnswer = true; Food food = new Food(); FoodDAL fDAL = new FoodDAL(); while (IsExitAnswer) { ShowMenu(); WriteLineWithSpecColor("Enter food number:"); answer = GetNumericAnswer().ToString(); while (!fDAL.IsIdFound(int.Parse(answer))) { WriteLineWithSpecColor("No such food number."); answer = GetNumericAnswer().ToString(); } food = fDAL.GetFoodByFoodID(int.Parse(answer)); WriteLineWithSpecColor("How much?"); answer = GetNumericAnswer().ToString(); food.Count = int.Parse(answer); _order.AddFoodInOrder(food); food = new Food(); WriteLineWithSpecColor("Wanna continue?"); IsExitAnswer = GetSimpleUserAnswer(); } WriteLineWithSpecColor($"Total order price:{_order.TotalPrice}"); OrdersDAL ordersDAL = new OrdersDAL(); ordersDAL.SendOrderToDB(_order); }
/// <summary> /// 添加 ///</summary> public static int AddOrders(Orders OrdersModel) { return(OrdersDAL.AddOrders(OrdersModel)); }
/// <summary> /// 保存订单 /// </summary> /// <returns></returns> public static int SavaOrder(Order order, List <OrderDetails> listDeta) { return(OrdersDAL.SavaOrder(order, listDeta)); }
/// <summary> /// 生成新订单编号 /// </summary> /// <returns></returns> public static string GetNewOrderID() { return(OrdersDAL.GetNewOrderID()); }
/// <summary> /// 查询条数 ///</summary> public static int CountNumber(string NewWHere) { return(OrdersDAL.CountNumber(NewWHere)); }
/// <summary> /// 修改 ///</summary> public static int UpdateOrders(Orders OrdersModel) { return(OrdersDAL.UpdateOrders(OrdersModel)); }
public void GetOrderDetail() { var dal = new OrdersDAL(); var order = dal.GetOrderDetails(11082); }
public OrdersBL() { orderDAL = new OrdersDAL(); }
/// <summary> /// 根据主键删除 ///</summary> public static int DeleteOrders(int Id) { return(OrdersDAL.DeleteOrders(Id)); }
/// <summary> /// 分页 ///</summary> public static List <Orders> PageSelectOrders(int pageSize, int pageIndex, string WhereSrc, string PXzd, string PXType) { pageIndex = pageIndex - 1; return(OrdersDAL.PageSelectOrders(pageSize, pageIndex, WhereSrc, PXzd, PXType)); }
public void MakeComplete() { var dal = new OrdersDAL(); dal.MakeComplete(11082, DateTime.Now); }
/// <summary> /// 查询全部 ///</summary> public static List <Orders> AllData(string NewWHere) { return(OrdersDAL.AllData(NewWHere)); }
public void TakeOrder() { var dal = new OrdersDAL(); dal.TakeOrder(11082, DateTime.Now); }
/// <summary> /// 根据主键查询实体 ///</summary> public static Orders GetIdByOrders(int Id) { return(OrdersDAL.GetIdByOrders(Id)); }
public void GetOrders() { var order1 = new OrdersDAL(); Assert.IsTrue(order1.GetAllOrders().Count > 0); }