private void RptBind(string _strWhere, string _goodsby) { this.page = DTRequest.GetQueryInt("page", 1); if (this.customer_id > 0) { this.ddlCustomer.SelectedValue = this.customer_id.ToString(); } if (this.storein_order_id > 0) { this.ddlStoreInOrder.SelectedValue = this.storein_order_id.ToString(); } txtKeyWord.Text = this.keyword; txtBeginTime.Text = this.beginTime; txtEndTime.Text = this.endTime; BLL.StoreInGoods bll = new BLL.StoreInGoods(); this.rptList.DataSource = bll.GetSearchList(this.pageSize, this.page, _strWhere, _goodsby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("storein_goods_list.aspx", "customer_id={0}&storein_order_id={1}&keyword={2}&beginTime={3}&endTime={4}&page={5}", this.customer_id.ToString(), this.storein_order_id.ToString(), this.keyword.ToString(), this.beginTime.ToString(), this.endTime, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void ShowInfo(int _id) { BLL.StoreInOrder bll = new BLL.StoreInOrder(); Model.StoreInOrder model = bll.GetModel(_id); ddlCustomer.SelectedValue = model.CustomerId.ToString(); txtAccountNumber.Text = model.AccountNumber; txtInspectionNumber.Text = model.InspectionNumber; txtBeginChargingTime.Text = model.BeginChargingTime.ToString("yyyy-MM-dd"); txtChargingCount.Text = model.ChargingCount.ToString(); txtSuttleWeight.Text = model.SuttleWeight.ToString("0.00"); txtAdmin.Text = model.Admin; txtRemark.Text = model.Remark; BLL.StoreInUnitPrice unitpriceBLL = new BLL.StoreInUnitPrice(); DataTable unitpriceDT = unitpriceBLL.GetList(" StoreInOrderId = " + _id + "").Tables[0]; this.rptUnitPriceList.DataSource = unitpriceDT; this.rptUnitPriceList.DataBind(); BLL.StoreInCost costBLL = new BLL.StoreInCost(); DataTable costDT = costBLL.GetList(" StoreInOrderId = " + _id + "").Tables[0]; this.rptCostList.DataSource = costDT; this.rptCostList.DataBind(); BLL.StoreInGoods goodsBLL = new BLL.StoreInGoods(); DataTable goodsDT = goodsBLL.GetList(" and A.StoreInOrderId = " + _id + " ").Tables[0]; this.rptGoodsList.DataSource = goodsDT; this.rptGoodsList.DataBind(); }
private void TreeBind(string strWhere) { BLL.StoreInOrder customerBLL = new BLL.StoreInOrder(); DataTable customerDT = customerBLL.GetList(0, " Status = 2 ", "Id desc").Tables[0]; this.ddlStoreInOrder.Items.Clear(); this.ddlStoreInOrder.Items.Add(new ListItem("入库单", "")); foreach (DataRow dr in customerDT.Rows) { this.ddlStoreInOrder.Items.Add(new ListItem(dr["AccountNumber"].ToString(), dr["Id"].ToString())); } BLL.StoreInGoods goodsBLL = new BLL.StoreInGoods(); DataTable goodsDT = goodsBLL.GetSelectList(0, strWhere, "Id desc").Tables[0]; this.ddlStoreInGoods.Items.Clear(); this.ddlStoreInGoods.Items.Add(new ListItem("入库货物", "")); foreach (DataRow dr in goodsDT.Rows) { this.ddlStoreInGoods.Items.Add(new ListItem(dr["GoodsName"].ToString(), dr["Id"].ToString())); } //BLL.Store storeBLL = new BLL.Store(); //DataTable storeDT = storeBLL.GetAllList().Tables[0]; //storeOptions += "<option value='0'>选择仓库</option>"; //foreach (DataRow dr in storeDT.Rows) //{ // storeOptions += "<option value='" + dr["Id"] + "'>" + dr["Name"] + "</option>"; //} }
private void StoreInGoodsBind(int storeInOrderId) { BLL.StoreInGoods storeInGoodsBLL = new BLL.StoreInGoods(); DataTable storeInGoodsDT = storeInGoodsBLL.GetSelectList(0, " and A.StoreInOrderId = " + storeInOrderId + " and A.Count > 0 ", "A.StoredInTime asc").Tables[0]; this.ddlStoreInGoods.Items.Clear(); this.ddlStoreInGoods.Items.Add(new ListItem("选择入库货物", "")); foreach (DataRow dr in storeInGoodsDT.Rows) { this.ddlStoreInGoods.Items.Add(new ListItem(string.Format("{0}(客户:{1},仓库:{2},库存:{3})", dr["GoodsName"].ToString(), dr["CustomerName"].ToString(), dr["StoreName"].ToString(), dr["StoredInCount"].ToString()), string.Format("{0}|{1}", dr["Id"].ToString(), dr["GoodsId"].ToString()))); } }
private void TreeBind(string strWhere) { BLL.StoreInOrder customerBLL = new BLL.StoreInOrder(); DataTable customerDT = customerBLL.GetList(0, " Status = 2 ", "Id desc").Tables[0]; this.ddlStoreInOrder.Items.Clear(); this.ddlStoreInOrder.Items.Add(new ListItem("入库单", "")); foreach (DataRow dr in customerDT.Rows) { this.ddlStoreInOrder.Items.Add(new ListItem(dr["AccountNumber"].ToString(), dr["Id"].ToString())); } BLL.StoreInGoods goodsBLL = new BLL.StoreInGoods(); DataTable goodsDT = goodsBLL.GetSelectList(0, strWhere, "Id desc").Tables[0]; this.ddlStoreInGoods.Items.Clear(); this.ddlStoreInGoods.Items.Add(new ListItem("入库货物", "")); foreach (DataRow dr in goodsDT.Rows) { this.ddlStoreInGoods.Items.Add(new ListItem(dr["GoodsName"].ToString(), dr["Id"].ToString())); } }