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