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())); } }