private void ShowInfo(int Id) { TB_Good model = goodSer.GetModel(Id); txtGoodName.Text = model.GoodName; txtGoodNo.Text = model.GoodNo; txtModel.Text = model.GoodModel; txtSpec.Text = model.GoodSpec; txtUnit.Text = model.GoodUnit; txtZhuJi.Text = model.ZhuJi; cbSpec.Checked = model.IfSpec; txtGoodBrand.Text = model.GoodBrand; lblProNo.Text = model.ProNo; txtProduct.Text = model.Product; ddlArea.Text = model.GoodArea; ddlCol.Text = model.GoodCol; ddlRow.Text = model.GoodRow; ddlNumber.Text = model.GoodNumber; if (model.GoodTypeName != null) { ddlGoodType.SelectedValue = model.GoodTypeName.ToString(); TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArray(" 1=1 and GoodTypeName='" + model.GoodTypeName + "'"); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodSmType.DataTextField = "GoodTypeSmName"; ddlGoodSmType.DataValueField = "GoodTypeSmName"; } if (model.GoodTypeSmName != null) { ddlGoodSmType.Text = model.GoodTypeSmName.ToString(); } }
protected void ddlGoodType_SelectedIndexChanged(object sender, EventArgs e) { if (ddlGoodType.SelectedItem.Text == "") { ddlGoodSmType.Text = ""; } else { TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArrayToddl(" 1=1 and GoodTypeName='" + ddlGoodType.SelectedItem.Value + "'"); goodsSmTypeList.Insert(0, new TB_GoodsSmType()); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodType.DataTextField = "GoodTypeSmName"; ddlGoodType.DataValueField = "GoodTypeSmName"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["DioSellWFHouseGoods"] = new List <Sell_OrderOutHouses>(); TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArray(""); goodsSmTypeList.Insert(0, new TB_GoodsSmType()); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodSmType.DataTextField = "GoodTypeSmName"; ddlGoodSmType.DataValueField = "GoodTypeSmName"; TB_GoodsTypeService typeSer = new TB_GoodsTypeService(); List <TB_GoodsType> allType = typeSer.GetListArray(""); allType.Insert(0, new TB_GoodsType()); ddlGoodType.DataSource = allType; ddlGoodType.DataBind(); ddlGoodType.DataTextField = "GoodTypeName"; ddlGoodType.DataValueField = "GoodTypeName"; Dal.BaseInfo.TB_HouseInfoService houseSer = new VAN_OA.Dal.BaseInfo.TB_HouseInfoService(); List <Model.BaseInfo.TB_HouseInfo> houseList = houseSer.GetListArray(""); houseList.Add(new TB_HouseInfo()); ddlHouse.DataSource = houseList; ddlHouse.DataBind(); ddlHouse.DataTextField = "houseName"; ddlHouse.DataValueField = "id"; List <TB_HouseGoods> allGoods = new List <TB_HouseGoods>(); gvList.DataSource = allGoods; gvList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //加载基本信息 ddlNumber.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlRow.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlCol.Items.Add(new ListItem { Text = "全部", Value = "" }); //货架号:1.全部 缺省 2….51 1,..50 for (int i = 1; i < 51; i++) { ddlNumber.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); //层数:1.全部 缺省 2….21 1,2,3…20 //部位:1.全部 缺省 2….21 1,2,3…20 if (i <= 21) { ddlRow.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); ddlCol.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); } } TB_GoodsTypeService typeSer = new TB_GoodsTypeService(); List <TB_GoodsType> allType = typeSer.GetListArray(""); allType.Insert(0, new TB_GoodsType()); ddlGoodType.DataSource = allType; ddlGoodType.DataBind(); ddlGoodType.DataTextField = "GoodTypeName"; ddlGoodType.DataValueField = "GoodTypeName"; TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArrayToddl(""); goodsSmTypeList.Insert(0, new TB_GoodsSmType()); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodSmType.DataTextField = "GoodTypeSmName"; ddlGoodSmType.DataValueField = "GoodTypeSmName"; Dal.BaseInfo.TB_HouseInfoService houseSer = new VAN_OA.Dal.BaseInfo.TB_HouseInfoService(); List <Model.BaseInfo.TB_HouseInfo> houseList = houseSer.GetListArray(""); houseList.Insert(0, new TB_HouseInfo()); ddlHouse.DataSource = houseList; ddlHouse.DataBind(); ddlHouse.DataTextField = "houseName"; ddlHouse.DataValueField = "id"; List <TB_HouseGoods> allGoods = new List <TB_HouseGoods>(); gvList.DataSource = allGoods; gvList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "全部", Id = -1 }); ddlPOTyle.DataSource = basePoTypeList; ddlPOTyle.DataBind(); ddlPOTyle.DataTextField = "BasePoType"; ddlPOTyle.DataValueField = "Id"; TB_GoodsTypeService typeSer = new TB_GoodsTypeService(); List <TB_GoodsType> allType = typeSer.GetListArray(""); allType.Insert(0, new TB_GoodsType()); ddlGoodType.DataSource = allType; ddlGoodType.DataBind(); ddlGoodType.DataTextField = "GoodTypeName"; ddlGoodType.DataValueField = "GoodTypeName"; TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArrayToddl(""); goodsSmTypeList.Insert(0, new TB_GoodsSmType()); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodSmType.DataTextField = "GoodTypeSmName"; ddlGoodSmType.DataValueField = "GoodTypeSmName"; //主单 List <JXC_REPORT> pOOrderList = new List <JXC_REPORT>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); bool showAll = true; if (QuanXian_ShowAll(SysObj.JXC_REPORTList) == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTList, Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User> (); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["IsSpecial"] != null) { ddlIsSpecial.Text = Request["IsSpecial"].ToString(); } if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { //加载基本信息 ddlNumber.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlRow.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlCol.Items.Add(new ListItem { Text = "全部", Value = "" }); //货架号:1.全部 缺省 2….51 1,..50 for (int i = 1; i < 51; i++) { ddlNumber.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); //层数:1.全部 缺省 2….21 1,2,3…20 //部位:1.全部 缺省 2….21 1,2,3…20 if (i <= 21) { ddlRow.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); ddlCol.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); } } if (Request["IsMine"] != null) { gvList.Columns[0].Visible = false; } TB_GoodsTypeService typeSer = new TB_GoodsTypeService(); List <TB_GoodsType> allType = typeSer.GetListArray(""); allType.Insert(0, new TB_GoodsType()); ddlGoodType.DataSource = allType; ddlGoodType.DataBind(); ddlGoodType.DataTextField = "GoodTypeName"; ddlGoodType.DataValueField = "GoodTypeName"; TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArray(""); goodsSmTypeList.Insert(0, new TB_GoodsSmType()); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodSmType.DataTextField = "GoodTypeSmName"; ddlGoodSmType.DataValueField = "GoodTypeSmName"; //加载SESSION中的数据 if (Session[Query] != null) { //QueryEForms QuerySession.QueryGood QEForm = Session[Query] as QuerySession.QueryGood; if (QEForm == null) { return; } if (QEForm.GoodSmTypeId != 0) { try { // ddlGoodSmType.Text = QEForm.GoodSmTypeId.ToString(); } catch (Exception) { } } if (QEForm.GoodName != "") { txtName.Text = QEForm.GoodName; } if (QEForm.GoodNo != "") { txtGoodNo.Text = QEForm.GoodNo; } if (QEForm.ZhuJi != "") { txtZhuJi.Text = QEForm.ZhuJi; } Show(); } else { List <TB_Good> goodList = new List <TB_Good>(); this.gvList.DataSource = goodList; this.gvList.DataBind(); } } }