public void loadOrder() { orderlist = new OrderList(); orderlist.selectOrders(); GridView_Order.DataSource = orderlist.Values; //GridView_Order.DataSource = order.selectOrder(); GridView_Order.DataBind(); }
protected void Button_SearchOrder_Click(object sender, EventArgs e) { string condition; string ComOrderNum = TextBox_ComOrderNum.Text.Trim() == "" ? " and 1=1 " : "and SMSO_ComOrderNum like '%" + TextBox_ComOrderNum.Text.Trim() + "%' "; string CustOrder = TextBox_CustOrder.Text.Trim() == "" ? " and 1=1 " : "and SMSO_CusOrderNum like '%" + TextBox_CustOrder.Text.Trim() + "%' "; condition = ComOrderNum + CustOrder; GridView_Order.DataSource = wol.S_WO_SMSalesOrder(condition); GridView_Order.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Permissions.ComRedirect(Page, Permissions.redirUrl); if (!IsPostBack) { string storeOrderID = Request.QueryString["storeOrderID"].ToString(); GridView1.DataSource = new OrdersBrowseBLL().StoreOrderDataTable_III(storeOrderID); GridView1.DataBind(); DataTable dt = OrdersBrowseBLL.StoreOrderDT(storeOrderID); GridView_Order.DataSource = dt; GridView_Order.DataBind(); this.TranControls(this.GridView_Order, new string[][] { new string [] { "000098", "订货店铺" }, new string [] { "000079", "订单号" }, new string [] { "000045", "期数" }, new string [] { "000100", "付款否" }, new string [] { "000102", "发货否" }, new string [] { "000104", "收货否" }, new string [] { "000106", "订单类型" }, new string [] { "000107", "姓名" }, new string [] { "000108", "收货人国家" }, new string [] { "000109", "省份" }, new string [] { "000110", "城市" }, new string [] { "000112", "收货地址" }, new string [] { "000073", "邮编" }, new string [] { "000041", "总金额" }, new string [] { "000113", "总积分" }, new string [] { "000115", "联系电话" }, new string [] { "000118", "重量" }, new string [] { "000120", "运费" }, new string [] { "000121", "物流公司" }, new string [] { "000067", "订货日期" }, new string [] { "000070", "发货日期" } }); this.TranControls(this.GridView1, new string[][] { new string [] { "000558", "产品编号" }, new string [] { "000501", "产品名称" }, new string [] { "000505", "数量" }, new string [] { "000518", "单位" }, new string [] { "000045", "期数" }, new string [] { "000503", "单价" }, new string [] { "000414", "积分" } }); } }
protected void Btn_SelectOrder_Click(object sender, EventArgs e)//新增随工单时,选择订单号 { Panel_Product_Search.Visible = false; Panel_SelectOrder.Visible = true; string condition; string ComOrderNum = TextBox_ComOrderNum.Text.Trim() == "" ? " and 1=1 " : "and SMSO_ComOrderNum like '%" + TextBox_ComOrderNum.Text.Trim() + "%' "; string CustOrder = TextBox_CustOrder.Text.Trim() == "" ? " and 1=1 " : "and SMSO_CusOrderNum like '%" + TextBox_CustOrder.Text.Trim() + "%' "; condition = ComOrderNum + CustOrder; GridView_Order.DataSource = wol.S_WO_SMSalesOrder(condition); GridView_Order.DataBind(); UpdatePanel_Product.Update(); UpdatePanel_SelectOrder.Update(); }
protected void GridView_Order_PageIndexChanging(object sender, GridViewPageEventArgs e) //订单号表翻页 { GridView theGrid = sender as GridView; // refer to the GridView int newPageIndex = 0; GridView_Order.SelectedIndex = -1; if (-2 == e.NewPageIndex) { TextBox txtNewPageIndex = null; GridViewRow pagerRow = GridView_Order.BottomPagerRow; if (null != pagerRow) { txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); } if (null != txtNewPageIndex && txtNewPageIndex.Text != "") { newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; } } else { newPageIndex = e.NewPageIndex; } newPageIndex = newPageIndex < 0 ? 0 : newPageIndex; newPageIndex = newPageIndex >= GridView_Order.PageCount ? GridView_Order.PageCount - 1 : newPageIndex; GridView_Order.PageIndex = newPageIndex; GridView_Order.PageIndex = newPageIndex; string condition; string ComOrderNum = TextBox_ComOrderNum.Text.Trim() == "" ? " and 1=1 " : "and SMSO_ComOrderNum like '%" + TextBox_ComOrderNum.Text.Trim() + "%' "; string CustOrder = TextBox_CustOrder.Text.Trim() == "" ? " and 1=1 " : "and SMSO_CusOrderNum like '%" + TextBox_CustOrder.Text.Trim() + "%' "; condition = ComOrderNum + CustOrder; GridView_Order.DataSource = wol.S_WO_SMSalesOrder(condition); GridView_Order.DataBind(); UpdatePanel_SelectOrder.Update(); }
protected void getbtCon(string storeOrderID) { GridView_Order.DataSource = BLL.Logistics.CheckOutOrdersBLL.GetOrderGoodsNoteTable(storeOrderID); GridView_Order.DataBind(); }