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