/// <summary>
/// 绑定菜单下拉列表——只显示所有可以显示的菜单（IsMenu)
/// </summary>
public void BandDropDownListShowMenu(Page page, FineUI.DropDownList ddl)
{
//在内存中筛选记录 string.Format("{0}={1}", BranchTable.IsMenu, 0)
var dt = DataTableHelper.GetFilterData(GetDataTable(), string.Format("{0} is not null", BranchTable.Id), BranchTable.Depth + ", " + BranchTable.Sort);
try
{
//整理出有层次感的数据
dt = DataTableHelper.DataTableTidyUp(dt, BranchTable.Id, BranchTable.ParentId, 0);
ddl.EnableSimulateTree = true;
//显示值
ddl.DataTextField = BranchTable.Name;
//显示key
ddl.DataValueField = BranchTable.Code;
//数据层次
ddl.DataSimulateTreeLevelField = BranchTable.Depth;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 根据门店编码，获取该区域下所有的门店，包括自己,并绑定到DropList
/// </summary>
/// <returns></returns>
public void GetShopList(Page page, string shop_id, FineUI.DropDownList ddl)
{
try
{
List <ConditionFun.SqlqueryCondition> shopCondit1 = new List <ConditionFun.SqlqueryCondition>();
shopCondit1.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, SHOP00Table.SHOP_ID, Comparison.Equals, shop_id, false, false));
var area_ID = SHOP00Bll.GetInstence().GetFieldValue("SHOP_Area_ID", shopCondit1);
var dt = DataTableHelper.GetFilterData(GetDataTable(), string.Format("{0} = '{1}'", SHOP00Table.SHOP_Area_ID, area_ID), SHOP00Table.Id);
//显示值
ddl.DataTextField = SHOP00Table.SHOP_NAME1;
//显示key
ddl.DataValueField = SHOP00Table.SHOP_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择分店", "0"));
//ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public DataTable BandDropDownListShowProductName_1(Page page, FineUI.DropDownList ddl, string shop_id)
{
//在内存中筛选记录
var dt = GET_PRODUCT00_PRODUCT01_LIST_("0", shop_id);// DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PRODUCT00Table.Id, "");
try
{
ddl.DataTextField = PRODUCT00Table.PROD_NAME1;
ddl.DataValueField = PRODUCT00Table.PROD_NAME1;
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("请选择", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
return(dt);
}
/// <summary>
/// 根据当前登录角色，禁用角色下拉列表。管理员专用。
/// </summary>
/// <param name="_ddl_role">FineUI下拉控件</param>
/// <param name="_adminRoleID">当前登录角色</param>
public void AdminDropDownListDisabled(FineUI.DropDownList _ddl_role, int _adminRoleID)
{
if (IsSuperAdminRole())
{
//超级管理员.不操作.
return;
}
//根据登录的角色禁用本级与上级选项
var list_child = (
from r in DBSession.Db.GetParentID_AdminRole(_adminRoleID)
select new { r.Kid, r.F_Title }
).ToList();
//禁用ID列表
string str_id = "";
if (IsSuperAdminRole())
{
//超级管理员.过滤本身角色.
list_child = list_child.Where(p => p.Kid.Value != _adminRoleID).ToList();
}
else
{
//不是超级管理员.顶级角色不可用．
str_id = "-1,0,";
}
foreach (var item in list_child)
{
str_id += item.Kid + ",";
}
//禁用
EKFineUIDataControl.DropDownListDisabledSelect(_ddl_role, str_id);
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowProductName1(Page page, FineUI.DropDownList ddl)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PRODUCT00Table.Id, "");
try
{
//显示值
// ddl.DataTextField = PRODUCT00Table.PROD_NAME1;
//显示key
// ddl.DataValueField = PRODUCT00Table.PROD_ID;
//数据层次
//绑定数据源
//绑定数据源
ddl.DataTextField = PRODUCT00Table.PROD_NAME1;
ddl.DataValueField = PRODUCT00Table.PROD_ID;
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("请选择", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowCOM(Page page, FineUI.DropDownList ddl, string PROD_ID)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), PRODUCT00Table.PROD_ID, PROD_ID, COMPONENT00Table.Id, " asc");
try
{
//显示值
ddl.DataTextField = COMPONENT00Table.COM_ID;
//显示key
ddl.DataValueField = COMPONENT00Table.COM_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowShop(Page page, FineUI.DropDownList ddl, string shop_id)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), string.Format("{0} = '{1}'", SHOP00Table.SHOP_ID, shop_id), SHOP00Table.Id);
try
{
//显示值
ddl.DataTextField = SHOP00Table.SHOP_NAME1;
//显示key
ddl.DataValueField = SHOP00Table.SHOP_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
// ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择分店", "0"));
//ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandOnlineUserStock(Page page, string shop_id, FineUI.DropDownList ddl)
{
//在内存中筛选记录
//在内存中筛选记录
List <ConditionFun.SqlqueryCondition> shopCondit = new List <ConditionFun.SqlqueryCondition>();
shopCondit.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, STOCKTable.SHOP_ID, Comparison.Equals, shop_id, false, false));
var dt = DataTableHelper.GetFilterData(GetDataTable(false, 0, null, 0, 0, shopCondit, null), "1", "1", STOCKTable.Id, " desc");
try
{
//显示值
ddl.DataTextField = STOCKTable.STOCK_NAME;
//显示key
ddl.DataValueField = STOCKTable.STOCK_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择分店", "0"));
//ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——显示所有的数据
/// </summary>
public void BandDropDownListShowUnit(Page page, FineUI.DropDownList ddl)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PROD_UNITTable.Id, " asc");
try
{
//显示值
ddl.DataTextField = PROD_UNITTable.UNIT_NAME;
//显示key
ddl.DataValueField = PROD_UNITTable.UNIT_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择单位", "0"));
//ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/***********************************************************************
* 自定义函数 *
***********************************************************************/
#region 自定义函数
#region 绑定下拉列表
/// <summary>
/// 绑定下拉列表
/// </summary>
public void BandDropDownList(Page page, FineUI.DropDownList ddl)
{
//显示值
ddl.DataTextField = UploadTypeTable.Name;
//显示key
ddl.DataValueField = UploadTypeTable.Id;
//绑定数据源
ddl.DataSource = GetDataTable();
ddl.DataBind();
ddl.Items.Insert(0, new FineUI.ListItem("请选择上传类型", "0"));
ddl.SelectedValue = "0";
}
/***********************************************************************
* 自定义函数 *
***********************************************************************/
#region 自定义函数
#region 绑定信息分类下拉列表
/// <summary>
/// 绑定信息分类下拉列表——只显示一级信息分类
/// </summary>
public void BandDropDownList(Page page, FineUI.DropDownList ddl)
{
var dt = DataTableHelper.GetFilterData(GetDataTable(), InformationClassTable.ParentId, "0", InformationClassTable.Sort, "desc");
//显示值
ddl.DataTextField = InformationClassTable.Name;
//绑定Id
ddl.DataValueField = InformationClassTable.Id;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.Items.Insert(0, new FineUI.ListItem("请选择信息分类", "0"));
ddl.SelectedValue = "0";
}
/// <summary>
/// 绑定菜单下拉列表——只显示一级菜单
/// </summary>
public void BandDropDownList(Page page, FineUI.DropDownList ddl)
{
var dt = GetDataTable();// DataTableHelper.GetFilterData(GetDataTable(), PositionTable.ParentId, "1", PositionTable.Id, "desc");
//显示值
ddl.DataTextField = PositionTable.Name;
//显示key
ddl.DataValueField = PositionTable.Id;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.Items.Insert(0, new FineUI.ListItem("请选择菜单", "0"));
ddl.SelectedValue = "0";
}
/// <summary>
/// 绑定部门下拉列表——显示所有
/// </summary>
public void BandDropDownListShowAll(Page page, FineUI.DropDownList ddl, bool isBandBranchCode = false)
{
//设置排序
var sortList = new List <string>();
sortList.Add(BranchTable.Depth);
sortList.Add(BranchTable.Sort);
//筛选记录
var dt = GetDataTable(false, 0, null, 0, 0, null, sortList);
try
{
//整理出有层次感的数据
dt = DataTableHelper.DataTableTidyUp(dt, BranchTable.Id, BranchTable.ParentId, 0);
ddl.EnableSimulateTree = true;
//显示值
ddl.DataTextField = BranchTable.Name;
//判断是否绑定部门编码
if (isBandBranchCode)
{
//绑定部门编码
ddl.DataValueField = BranchTable.Code;
}
else
{
//绑定Id
ddl.DataValueField = BranchTable.Id;
}
//数据层次
ddl.DataSimulateTreeLevelField = BranchTable.Depth;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("请选择部门", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定菜单下拉列表——只显示一级菜单
/// </summary>
public void BandDropDownList(Page page, FineUI.DropDownList ddl)
{
var dt = DataTableHelper.GetFilterData(GetDataTable(), string.Format("{0} like '%{1}%'", BranchTable.Name, "部门"), string.Format("{0} {1}", BranchTable.Sort, "desc"));
//显示值
ddl.DataTextField = BranchTable.Name;
//显示key
ddl.DataValueField = BranchTable.Id;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
//ddl.Items.Insert(0, new FineUI.ListItem("请选择部门", "0"));
//ddl.SelectedValue = "0";
}
public static void Binding <T>(FineUI.DropDownList control, IEnumerable <T> tList, string dataTextField, string dataValueField,
string defaultSelectedValue)
{
if (!dataTextField.IsNullOrEmpty())
{
control.DataTextField = dataTextField;
}
if (!dataValueField.IsNullOrEmpty())
{
control.DataValueField = dataValueField;
}
control.DataSource = tList;
control.DataBind();
if (!defaultSelectedValue.IsNullOrEmpty())
{
control.SelectedValue = defaultSelectedValue;
}
}
/// <summary>
/// 禁用FineUI.DropDownList控件指定ID值选项．其他选项启用．
/// </summary>
/// <param name="ddl">控件</param>
/// <param name="strvDisabledID">ID格式字符串 例:1,2,3,4,5</param>
public static void DropDownListDisabledSelect(FineUI.DropDownList ddl, string strDisabledID)
{
strDisabledID = "," + strDisabledID + ",";
bool isEx = false;
for (int i = 0; i < ddl.Items.Count; i++)
{
isEx = strDisabledID.Contains("," + ddl.Items[i].Value + ",");
if (isEx)
{
//禁用
ddl.Items[i].EnableSelect = false;
}
else
{
//启用
ddl.Items[i].EnableSelect = true;
}
}
}
public void BandDropDownList(Page page, FineUI.DropDownList ddl, string shop_id)
{
//在内存中筛选记录
var dt = (DataTable)SPs.GET_ORDER_DEP00_ORDER_DEP01_LIST(shop_id).ExecuteDataTable();
try
{
//显示值
ddl.DataTextField = ORDER_DEP00Table.ORDDEP_NAME; //SHOP00Table.SHOP_NAME1;
//显示key
ddl.DataValueField = ORDER_DEP00Table.ORDDEP_ID;
//数据层次
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
public static void Binding <T>(FineUI.DropDownList control, IEnumerable <T> tList, string dataTextField,
string dataValueField)
{
Binding(control, tList, dataTextField, dataValueField, string.Empty);
}
public static void Binding <T>(FineUI.DropDownList control, IEnumerable <T> tList)
{
Binding(control, tList, string.Empty, string.Empty, string.Empty);
}
