private void TreeBind(string strWhere)
{
BLL.Vehicle goodsBll = new BLL.Vehicle();
DataTable goodsDT = goodsBll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("车号不限", ""));
foreach (DataRow dr in goodsDT.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
BLL.Customer customerBll = new BLL.Customer();
DataTable customerDT = customerBll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCustomer1.Items.Clear();
ddlCustomer1.Items.Add(new ListItem("托运方不限", ""));
ddlCustomer2.Items.Clear();
ddlCustomer2.Items.Add(new ListItem("收货方不限", ""));
foreach (DataRow dr in customerDT.Rows)
{
if (!dr["Category"].ToString().Equals("托运方"))
{
this.ddlCustomer2.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["ShortName"].ToString()));
}
if (!dr["Category"].ToString().Equals("收货方"))
{
this.ddlCustomer1.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["ShortName"].ToString()));
}
}
}
private void TreeBind(string strWhere)
{
BLL.Customer customerBLL = new BLL.Customer();
DataTable customerDT = customerBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlCustomer.Items.Clear();
this.ddlCustomer.Items.Add(new ListItem("选择客户", ""));
foreach (DataRow dr in customerDT.Rows)
{
this.ddlCustomer.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
this.ddlGoods.Items.Clear();
this.ddlGoods.Items.Add(new ListItem("选择货物", ""));
BLL.Vehicle vehicleBLL = new BLL.Vehicle();
DataTable vehicleDT = vehicleBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlVehicle.Items.Clear();
this.ddlVehicle.Items.Add(new ListItem("选择车辆", ""));
foreach (DataRow dr in vehicleDT.Rows)
{
this.ddlVehicle.Items.Add(new ListItem(dr["PlateNumber"].ToString(), dr["Id"].ToString()));
}
BLL.HandlingMode handlingModeBLL = new BLL.HandlingMode();
DataTable handlingModeDT = handlingModeBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlHandlingMode.Items.Clear();
this.ddlHandlingMode.Items.Add(new ListItem("选择装卸方式", ""));
foreach (DataRow dr in handlingModeDT.Rows)
{
this.ddlHandlingMode.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
}
private void TreeBind(string strWhere)
{
BLL.Customer customerBLL = new BLL.Customer();
DataTable customerDT = customerBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlCustomer.Items.Clear();
this.ddlCustomer.Items.Add(new ListItem("客户", ""));
foreach (DataRow dr in customerDT.Rows)
{
this.ddlCustomer.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
BLL.Goods goodsBLL = new BLL.Goods();
DataTable goodsDT = goodsBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlGoods.Items.Clear();
this.ddlGoods.Items.Add(new ListItem("货物", ""));
foreach (DataRow dr in goodsDT.Rows)
{
this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
BLL.Vehicle vehicleBLL = new BLL.Vehicle();
DataTable vehicleDT = vehicleBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlVehicle.Items.Clear();
this.ddlVehicle.Items.Add(new ListItem("车辆", ""));
foreach (DataRow dr in vehicleDT.Rows)
{
this.ddlVehicle.Items.Add(new ListItem(dr["PlateNumber"].ToString(), dr["Id"].ToString()));
}
}
private void TreeBind(string strWhere)
{
BLL.Motorcade bll = new BLL.Motorcade();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlMotorcade.Items.Clear();
ddlMotorcade.Items.Add(new ListItem("请选择车队", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlMotorcade.Items.Add(new ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
}
ddlMotorcade.SelectedIndex = 0;
string motorcadeName = ddlMotorcade.SelectedValue;
BLL.Vehicle vehicleBll = new BLL.Vehicle();
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择车辆", ""));
if (!string.IsNullOrEmpty(motorcadeName))
{
DataTable vehicledt = vehicleBll.GetList(0, " MotorcadeName = '" + motorcadeName + "' ", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
else
{
DataTable vehicledt = vehicleBll.GetList(0, "", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
BLL.Order orderBll = new BLL.Order();
this.rptList.DataSource = orderBll.GetList(" Quantity > DispatchedCount or (IsCharteredCar = 1 and DispatchedCount = 0.00)");
this.rptList.DataBind();
}
private void TreeBind(string strWhere)
{
BLL.Vehicle bll = new BLL.Vehicle();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择所驾车辆...", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
if (!string.IsNullOrEmpty(_motorcadeName))
{
this.ddlMotorcadeName.SelectedValue = this._motorcadeName;
}
this.txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "motorcadeName={0}&keywords={1}&page={2}",
this._motorcadeName, this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
if (!string.IsNullOrEmpty(_motorcadeName))
{
this.ddlMotorcadeName.SelectedValue = this._motorcadeName;
}
this.txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "motorcadeName={0}&keywords={1}&page={2}",
this._motorcadeName, this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void TreeBind(string strWhere)
{
BLL.Vehicle bll = new BLL.Vehicle();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择所驾车辆...", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
private void TreeBind(string strWhere)
{
BLL.Customer customerBLL = new BLL.Customer();
DataTable customerDT = customerBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlCustomer.Items.Clear();
this.ddlCustomer.Items.Add(new ListItem("客户", ""));
foreach (DataRow dr in customerDT.Rows)
{
this.ddlCustomer.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
BLL.Goods goodsBLL = new BLL.Goods();
DataTable goodsDT = goodsBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlGoods.Items.Clear();
this.ddlGoods.Items.Add(new ListItem("货物", ""));
foreach (DataRow dr in goodsDT.Rows)
{
this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
BLL.Vehicle vehicleBLL = new BLL.Vehicle();
DataTable vehicleDT = vehicleBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlVehicle.Items.Clear();
this.ddlVehicle.Items.Add(new ListItem("车辆", ""));
foreach (DataRow dr in vehicleDT.Rows)
{
this.ddlVehicle.Items.Add(new ListItem(dr["PlateNumber"].ToString(), dr["Id"].ToString()));
}
}
private void TreeBind(string strWhere)
{
BLL.Vehicle goodsBll = new BLL.Vehicle();
DataTable goodsDT = goodsBll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("车号不限", ""));
foreach (DataRow dr in goodsDT.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
BLL.Customer customerBll = new BLL.Customer();
DataTable customerDT = customerBll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCustomer1.Items.Clear();
ddlCustomer1.Items.Add(new ListItem("托运方不限", ""));
ddlCustomer2.Items.Clear();
ddlCustomer2.Items.Add(new ListItem("收货方不限", ""));
foreach (DataRow dr in customerDT.Rows)
{
if (!dr["Category"].ToString().Equals("托运方"))
{
this.ddlCustomer2.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["ShortName"].ToString()));
}
if (!dr["Category"].ToString().Equals("收货方"))
{
this.ddlCustomer1.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["ShortName"].ToString()));
}
}
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void TreeBind(string strWhere)
{
BLL.Motorcade bll = new BLL.Motorcade();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlMotorcade.Items.Clear();
ddlMotorcade.Items.Add(new ListItem("请选择车队", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlMotorcade.Items.Add(new ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
}
ddlMotorcade.SelectedIndex = 0;
string motorcadeName = ddlMotorcade.SelectedValue;
BLL.Vehicle vehicleBll = new BLL.Vehicle();
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择车辆", ""));
if (!string.IsNullOrEmpty(motorcadeName))
{
DataTable vehicledt = vehicleBll.GetList(0, " MotorcadeName = '" + motorcadeName + "' ", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
else
{
DataTable vehicledt = vehicleBll.GetList(0, "", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
BLL.Order orderBll = new BLL.Order();
this.rptList.DataSource = orderBll.GetList(" Quantity > DispatchedCount or (IsCharteredCar = 1 and DispatchedCount = 0.00)");
this.rptList.DataBind();
}
private void TreeBind(string strWhere)
{
BLL.Customer customerBLL = new BLL.Customer();
DataTable customerDT = customerBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlCustomer.Items.Clear();
this.ddlCustomer.Items.Add(new ListItem("选择客户", ""));
foreach (DataRow dr in customerDT.Rows)
{
this.ddlCustomer.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
this.ddlGoods.Items.Clear();
this.ddlGoods.Items.Add(new ListItem("选择货物", ""));
BLL.Vehicle vehicleBLL = new BLL.Vehicle();
DataTable vehicleDT = vehicleBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlVehicle.Items.Clear();
this.ddlVehicle.Items.Add(new ListItem("选择车辆", ""));
foreach (DataRow dr in vehicleDT.Rows)
{
this.ddlVehicle.Items.Add(new ListItem(dr["PlateNumber"].ToString(), dr["Id"].ToString()));
}
BLL.HandlingMode handlingModeBLL = new BLL.HandlingMode();
DataTable handlingModeDT = handlingModeBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlHandlingMode.Items.Clear();
this.ddlHandlingMode.Items.Add(new ListItem("选择装卸方式", ""));
foreach (DataRow dr in handlingModeDT.Rows)
{
this.ddlHandlingMode.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
}