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