private void TreeBind(string strWhere) { BLL.Haulway haulwayBll = new BLL.Haulway(); DataTable haulwayDT = haulwayBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlHaulway.Items.Clear(); ddlHaulway.Items.Add(new ListItem("请选择运输路线", "")); foreach (DataRow dr in haulwayDT.Rows) { this.ddlHaulway.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } BLL.Customer customerBll = new BLL.Customer(); DataTable customerDT = customerBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlShipper.Items.Clear(); ddlShipper.Items.Add(new ListItem("请选择托运方", "")); ddlReceiver.Items.Clear(); ddlReceiver.Items.Add(new ListItem("请选择收货方", "")); foreach (DataRow dr in customerDT.Rows) { if (!dr["Category"].ToString().Equals("托运方")) { this.ddlReceiver.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } if (!dr["Category"].ToString().Equals("收货方")) { this.ddlShipper.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } } BLL.Address addressBll = new BLL.Address(); DataTable addressDT = addressBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlLoadingAddress.Items.Clear(); ddlLoadingAddress.Items.Add(new ListItem("请选择装货地址", "")); ddlUnloadingAddress.Items.Clear(); ddlUnloadingAddress.Items.Add(new ListItem("请选择卸货地址", "")); foreach (DataRow dr in addressDT.Rows) { if (!dr["CategoryName"].ToString().Equals("卸货地址")) { this.ddlLoadingAddress.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } if (!dr["CategoryName"].ToString().Equals("装货地址")) { this.ddlUnloadingAddress.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]; ddlGoods.Items.Clear(); ddlGoods.Items.Add(new ListItem("请选择承运货物", "")); foreach (DataRow dr in goodsDT.Rows) { this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("address_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; BLL.Address bll = new BLL.Address(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { if (bll.Delete(id)) { sucCount += 1; } else { errorCount += 1; } } } AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除装卸货地址" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("address_list.aspx", "keywords={0}", this.keywords), "Success"); }
private void ShowInfo(int _id) { BLL.Address bll = new BLL.Address(); Model.Address model = bll.GetModel(_id); txtName.Text = model.Name; txtCode.Text = model.Code; ddlCategory.SelectedValue = model.CategoryName; }
private void TreeBind(string strWhere) { BLL.Goods goodsBll = new BLL.Goods(); DataTable goodsDT = goodsBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlGoods.Items.Clear(); ddlGoods.Items.Add(new ListItem("承运货物", "")); foreach (DataRow dr in goodsDT.Rows) { this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].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["Id"].ToString())); } if (!dr["Category"].ToString().Equals("收货方")) { this.ddlCustomer1.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } } BLL.Address addressBll = new BLL.Address(); DataTable addressDT = addressBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlLoadingAddress.Items.Clear(); ddlLoadingAddress.Items.Add(new ListItem("请选择装货地址", "")); ddlUnloadingAddress.Items.Clear(); ddlUnloadingAddress.Items.Add(new ListItem("请选择卸货地址", "")); foreach (DataRow dr in addressDT.Rows) { if (!dr["CategoryName"].ToString().Equals("卸货地址")) { this.ddlLoadingAddress.Items.Add(new ListItem(dr["Name"].ToString(), dr["Name"].ToString())); } if (!dr["CategoryName"].ToString().Equals("装货地址")) { this.ddlUnloadingAddress.Items.Add(new ListItem(dr["Name"].ToString(), dr["Name"].ToString())); } } ddlIsAllot.Items.Clear(); ddlIsAllot.Items.Add(new ListItem("是否调拨单", "0")); ddlIsAllot.Items.Add(new ListItem("是", "1")); ddlIsAllot.Items.Add(new ListItem("否", "2")); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); this.txtKeywords.Text = this.keywords; BLL.Address bll = new BLL.Address(); 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("address_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private bool DoAdd() { bool result = false; Model.Address model = new Model.Address(); BLL.Address bll = new BLL.Address(); model.Name = txtName.Text.Trim(); model.Code = string.IsNullOrEmpty(txtCode.Text.Trim()) ? model.Name : txtCode.Text.Trim(); model.CategoryName = ddlCategory.SelectedValue; if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加装卸货地址:" + model.Name); //记录日志 result = true; } return result; }
private bool DoEdit(int _id) { bool result = false; BLL.Address bll = new BLL.Address(); Model.Address model = bll.GetModel(_id); model.Name = txtName.Text.Trim(); model.Code = string.IsNullOrEmpty(txtCode.Text.Trim()) ? model.Name : txtCode.Text.Trim(); model.CategoryName = ddlCategory.SelectedValue; if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改装卸货地址信息:" + model.Name); //记录日志 result = true; } return(result); }
private bool DoAdd() { bool result = false; Model.Address model = new Model.Address(); BLL.Address bll = new BLL.Address(); model.Name = txtName.Text.Trim(); model.Code = string.IsNullOrEmpty(txtCode.Text.Trim()) ? model.Name : txtCode.Text.Trim(); model.CategoryName = ddlCategory.SelectedValue; if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加装卸货地址:" + model.Name); //记录日志 result = true; } return(result); }
private void TreeBind(string strWhere) { BLL.Haulway haulwayBll = new BLL.Haulway(); DataTable haulwayDT = haulwayBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlHaulway.Items.Clear(); ddlHaulway.Items.Add(new ListItem("请选择运输路线", "")); foreach (DataRow dr in haulwayDT.Rows) { this.ddlHaulway.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } BLL.Customer customerBll = new BLL.Customer(); DataTable customerDT = customerBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlShipper.Items.Clear(); ddlShipper.Items.Add(new ListItem("请选择托运方", "")); ddlReceiver.Items.Clear(); ddlReceiver.Items.Add(new ListItem("请选择收货方", "")); foreach (DataRow dr in customerDT.Rows) { if (!dr["Category"].ToString().Equals("托运方")) { this.ddlReceiver.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } if (!dr["Category"].ToString().Equals("收货方")) { this.ddlShipper.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } } BLL.Address addressBll = new BLL.Address(); DataTable addressDT = addressBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlLoadingAddress.Items.Clear(); ddlLoadingAddress.Items.Add(new ListItem("请选择装货地址", "")); ddlUnloadingAddress.Items.Clear(); ddlUnloadingAddress.Items.Add(new ListItem("请选择卸货地址", "")); foreach (DataRow dr in addressDT.Rows) { if (!dr["CategoryName"].ToString().Equals("卸货地址")) { this.ddlLoadingAddress.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } if (!dr["CategoryName"].ToString().Equals("装货地址")) { this.ddlUnloadingAddress.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]; ddlGoods.Items.Clear(); ddlGoods.Items.Add(new ListItem("请选择承运货物", "")); foreach (DataRow dr in goodsDT.Rows) { this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } BLL.TransportOrder transportOrderBLL = new BLL.TransportOrder(); DataTable transportOrderDT = transportOrderBLL.GetSelectList(0, " A.Status = 0", "Id DESC").Tables[0]; ddlTransportOrder.Items.Clear(); ddlTransportOrder.Items.Add(new ListItem("请选择运输单", "")); foreach (DataRow dr in transportOrderDT.Rows) { this.ddlTransportOrder.Items.Add(new ListItem(string.Format("{0}({1})", dr["CarNumber"].ToString(), dr["Code"].ToString()), dr["Id"].ToString())); } }
private void TreeBind(string strWhere) { BLL.Haulway haulwayBll = new BLL.Haulway(); DataTable haulwayDT = haulwayBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlHaulway.Items.Clear(); ddlHaulway.Items.Add(new ListItem("请选择运输路线", "")); foreach (DataRow dr in haulwayDT.Rows) { this.ddlHaulway.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } ddlFormula.Items.Clear(); ddlFormula.Items.Add(new ListItem("计量*运费单价", "1")); ddlFormula.Items.Add(new ListItem("计量*公里*运费单价", "2")); ddlFormula.Items.Add(new ListItem("固定运费", "3")); BLL.Customer customerBll = new BLL.Customer(); DataTable customerDT = customerBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlShipper.Items.Clear(); ddlShipper.Items.Add(new ListItem("请选择托运方", "")); ddlReceiver.Items.Clear(); ddlReceiver.Items.Add(new ListItem("请选择收货方", "")); foreach (DataRow dr in customerDT.Rows) { if (!dr["Category"].ToString().Equals("托运方")) { this.ddlReceiver.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } if (!dr["Category"].ToString().Equals("收货方")) { this.ddlShipper.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["Id"].ToString())); } } BLL.Address addressBll = new BLL.Address(); DataTable addressDT = addressBll.GetList(0, strWhere, "Id desc").Tables[0]; ddlLoadingAddress.Items.Clear(); ddlLoadingAddress.Items.Add(new ListItem("请选择装货地址", "")); ddlUnloadingAddress.Items.Clear(); ddlUnloadingAddress.Items.Add(new ListItem("请选择卸货地址", "")); foreach (DataRow dr in addressDT.Rows) { if (!dr["CategoryName"].ToString().Equals("卸货地址")) { this.ddlLoadingAddress.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } if (!dr["CategoryName"].ToString().Equals("装货地址")) { this.ddlUnloadingAddress.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]; ddlGoods.Items.Clear(); ddlGoods.Items.Add(new ListItem("请选择承运货物", "")); foreach (DataRow dr in goodsDT.Rows) { this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString())); } ddlSettleAccountsWay.Items.Clear(); ddlSettleAccountsWay.Items.Add(new ListItem("现结", "现结")); ddlSettleAccountsWay.Items.Add(new ListItem("月结", "月结")); ddlSettleAccountsWay.Items.Add(new ListItem("预付", "预付")); }
private bool DoEdit(int _id) { bool result = false; BLL.Address bll = new BLL.Address(); Model.Address model = bll.GetModel(_id); model.Name = txtName.Text.Trim(); model.Code = string.IsNullOrEmpty(txtCode.Text.Trim()) ? model.Name : txtCode.Text.Trim(); model.CategoryName = ddlCategory.SelectedValue; if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改装卸货地址信息:" + model.Name); //记录日志 result = true; } return result; }