private void LoadSubData(string pid, TreeNode nodes, DataTable dt) { foreach (DataRow row in dt.Select("SupperID=" + pid)) { TreeNode nodess = new TreeNode(); nodess.Text = row["CodeName"].ToString(); nodess.Value = row["ID"].ToString(); //TypeFlag = row["TypeFlag"].ToString(); nodess.NavigateUrl = string.Format("javascript:SelectedNodeChanged1('{0}','{1}');", nodess.Text, nodess.Value); LoadSubData(row["ID"].ToString(), nodess, dt); nodes.ChildNodes.Add(nodess); nodes.Expanded = false; } string Code = "5"; string TypeFlag = "5"; DataTable dt_Mater = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code); if (dt_Mater.Rows.Count > 0) { this.sel_Material.DataTextField = "TypeName"; sel_Material.DataValueField = "ID"; sel_Material.DataSource = dt_Mater; sel_Material.DataBind(); } sel_Material.Items.Insert(0, new ListItem("--请选择--", "0")); }
private void BindFlag() { string feeflag = "5"; string feecode = "6"; DataTable dt = CodePublicTypeBus.GetCodePublicByCode(feeflag, feecode); if (dt.Rows.Count > 0) { seltype.DataTextField = "TypeName"; seltype.DataValueField = "ID"; seltype.DataSource = dt; seltype.DataBind(); sel_type.DataTextField = "TypeName"; sel_type.DataValueField = "ID"; sel_type.DataSource = dt; sel_type.DataBind(); sel_type.SelectedIndex = 0; } ListItem Item = new ListItem(); Item.Value = "0"; Item.Text = "--请选择--"; seltype.Items.Insert(0, Item); }
private void BindCom() { string TypeFlag = "5"; string Code = "2"; DataTable dt = null; Code = "3"; dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code);//绑定颜色 if (dt.Rows.Count > 0) { this.sel_ColorID.DataTextField = "TypeName"; sel_ColorID.DataValueField = "ID"; sel_ColorID.DataSource = dt; sel_ColorID.DataBind(); } sel_ColorID.Items.Insert(0, new ListItem("--请选择--", "0")); Code = "5"; dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code);//绑定材质 if (dt.Rows.Count > 0) { this.sel_Material.DataTextField = "TypeName"; sel_Material.DataValueField = "ID"; sel_Material.DataSource = dt; sel_Material.DataBind(); } sel_Material.Items.Insert(0, new ListItem("--请选择--", "0")); }
/// <summary> /// 所在区域 /// </summary> private void BindSel() { TypeFlag = "4"; //客户 TypeCode = "12"; //区域 DataTable dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, TypeCode); if (dt.Rows.Count > 0) { this.sel_AreaID.DataTextField = "TypeName"; sel_AreaID.DataValueField = "ID"; sel_AreaID.DataSource = dt; sel_AreaID.DataBind(); } }
/// <summary> /// 国家地区 /// </summary> private void BindArea() { TypeFlag = "2"; //人事 TypeCode = "3"; //国家地区 DataTable dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, TypeCode); if (dt.Rows.Count > 0) { this.sel_CountryID.DataTextField = "TypeName"; sel_CountryID.DataValueField = "ID"; sel_CountryID.DataSource = dt; sel_CountryID.DataBind(); } }
private void BindM() { string Code = "5"; string TypeFlag = "5"; DataTable dt_Mater = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code); if (dt_Mater.Rows.Count > 0) { this.sel_Material.DataTextField = "TypeName"; sel_Material.DataValueField = "ID"; sel_Material.DataSource = dt_Mater; sel_Material.DataBind(); } sel_Material.Items.Insert(0, new ListItem("--请选择--", "0")); }
/// <summary> /// 绑定颜色 /// </summary> private void BindColor() { string TypeFlag = "5"; string Code = "3"; DataTable dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code); if (dt.Rows.Count > 0) { this.selCorlor.DataTextField = "TypeName"; selCorlor.DataValueField = "ID"; selCorlor.DataSource = dt; selCorlor.DataBind(); } selCorlor.Items.Insert(0, new ListItem("--请选择--", "")); }
/// <summary> /// 支付方式 /// </summary> private void BindMoney() { TypeFlag = "4"; TypeCode = "14"; DataTable dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, TypeCode); if (dt.Rows.Count > 0) { this.sel_MoneyType.DataTextField = "TypeName"; sel_MoneyType.DataValueField = "ID"; sel_MoneyType.DataSource = dt; sel_MoneyType.DataBind(); } ListItem Item = new ListItem(ConstUtil.CODE_TYPE_INSERT_TEXT, ConstUtil.CODE_TYPE_INSERT_VALUE); sel_MoneyType.Items.Insert(0, Item); }
/// <summary> /// 所在区域 /// </summary> private void BindSel() { string TypeFlag = "4"; //客户 string TypeCode = "12"; //区域 DataTable dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, TypeCode); if (dt.Rows.Count > 0) { this.sel_BillType.DataTextField = "TypeName"; sel_BillType.DataValueField = "ID"; sel_BillType.DataSource = dt; sel_BillType.DataBind(); ListItem Item = new ListItem(); Item.Value = ""; Item.Text = "--请选择--"; sel_BillType.Items.Insert(0, Item); } }
/// <summary> /// 绑定所有下拉框 /// </summary> private void BindCom() { TypeFlag = "5"; Code = "2"; DataTable dt = null; dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code);//绑定等级 if (dt.Rows.Count > 0) { this.sel_GradeID.DataTextField = "TypeName"; sel_GradeID.DataValueField = "ID"; sel_GradeID.DataSource = dt; sel_GradeID.DataBind(); } sel_GradeID.Items.Insert(0, new ListItem("--请选择--", "0")); Code = "1"; dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code);//绑定品牌 if (dt.Rows.Count > 0) { this.sel_Brand.DataTextField = "TypeName"; sel_Brand.DataValueField = "ID"; sel_Brand.DataSource = dt; sel_Brand.DataBind(); } sel_Brand.Items.Insert(0, new ListItem("--请选择--", "0")); Code = "3"; dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code);//绑定颜色 if (dt.Rows.Count > 0) { this.sel_ColorID.DataTextField = "TypeName"; sel_ColorID.DataValueField = "ID"; sel_ColorID.DataSource = dt; sel_ColorID.DataBind(); } sel_ColorID.Items.Insert(0, new ListItem("--请选择--", "0")); dt = CodeReasonFeeBus.GetCodeUnitType();//绑定单位 if (dt.Rows.Count > 0) { this.sel_UnitID.DataTextField = "CodeName"; sel_UnitID.DataValueField = "ID"; sel_UnitID.DataSource = dt; sel_UnitID.DataBind(); } Code = "5"; dt = CodePublicTypeBus.GetCodePublicByCode(TypeFlag, Code);//绑定材质 if (dt.Rows.Count > 0) { this.sel_Material.DataTextField = "TypeName"; sel_Material.DataValueField = "ID"; sel_Material.DataSource = dt; sel_Material.DataBind(); } sel_Material.Items.Insert(0, new ListItem("--请选择--", "0")); StorageModel model = new StorageModel(); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; model.CompanyCD = userInfo.CompanyCD; DataTable dt_Stor = StorageBus.GetStorageListBycondition(model);//绑定仓库 if (dt_Stor.Rows.Count > 0) { sel_StorageID.DataSource = dt_Stor; sel_StorageID.DataTextField = "StorageName"; sel_StorageID.DataValueField = "ID"; sel_StorageID.DataBind(); } //DataTable dt_BindUnit =new DataTable(); //dt_BindUnit = ProductInfoBus.GetUnitGroupList(this.txtUnitGroup.Value); }