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