/// <summary>
/// 绑定基础数据
/// </summary>
/// <param name="lue"></param>
/// <param name="E"></param>
/// <param name="displayCombination"></param>
/// <param name="AddNull"></param>
public static void BoundCommonDictDataName(RepositoryItemLookUpEdit lue, EnumCommonDicData E, bool displayCombination, bool AddNull)
{
lue.Columns.Clear();
InitializeControl(lue, new string[] { "名称" }, new string[] { dt_CommonDicData.DataName });
BoundDatabase(lue, DataCache.Cache.GetCommonDictData(E), displayCombination, AddNull, dt_CommonDicData.DataName, dt_CommonDicData.DataName);
}
public DataTable getCommonDicData(EnumCommonDicData E, string TableName)
{
var sql = "SELECT DataCode,DataName FROM dt_CommonDicData WHERE DataType=@DataType ORDER BY SortIndex";
//var dbH = DataBaseFactoryEx.CreateDataBase(Loginer.CurrentLoginer.LoginDBCode);
SqlParameterProvider p = new SqlParameterProvider();
p.AddParameter("@DataType", SqlDbType.VarChar, 50, E.ToString());
return(DBServices.LoginDB.GetTable(sql, TableName, p));
}
/// <summary>
/// 基础字典数据
/// </summary>
/// <param name="E"></param>
/// <returns></returns>
public DataTable GetCommonDictData(EnumCommonDicData E)
{
string TableName = dt_CommonDicData._TableName + (int)E;
DataTable dt = CommonData.FindFromCache(TableName);
if (dt == null)
{
dt = bllDataCommon.Instance.getCommonDicData(E, TableName);
AddToCache(dt.Copy());
}
return(dt);
}
/// <summary>
/// 绑定基础数据
/// </summary>
/// <param name="lue"></param>
/// <param name="E"></param>
/// <param name="displayCombination"></param>
/// <param name="AddNull"></param>
public static void BoundCommonDictDataName(RepositoryItemComboBox lue, EnumCommonDicData E, bool AddNull)
{
lue.Items.Clear();
DataTable dt = DataCache.Cache.GetCommonDictData(E).Copy();
if (AddNull)
{
dt.Rows.InsertAt(dt.NewRow(), 0);
}
dt.AcceptChanges();
foreach (DataRow dr in dt.Rows)
{
lue.Items.Add(dr[dt_CommonDicData.DataName]);
}
}
/// <summary>
/// 绑定基础数据
/// </summary>
/// <param name="lue"></param>
/// <param name="E"></param>
/// <param name="displayCombination"></param>
public static void BoundCommonDictDataName(CheckedComboBoxEdit lue, EnumCommonDicData E, bool displayCombination)
{
BoundCommonDictDataName(lue.Properties, E, displayCombination);
}
/// <summary>
/// 绑定基础数据
/// </summary>
/// <param name="lue"></param>
/// <param name="E"></param>
/// <param name="displayCombination"></param>
/// <param name="AddNull"></param>
public static void BoundCommonDictDataName(RepositoryItemCheckedComboBoxEdit lue, EnumCommonDicData E, bool displayCombination)
{
lue.Items.Clear();
BoundDatabase(lue, DataCache.Cache.GetCommonDictData(E), displayCombination, dt_CommonDicData.DataName, dt_CommonDicData.DataName);
}
/// <summary>
/// 绑定基础数据
/// </summary>
/// <param name="lue"></param>
/// <param name="E"></param>
/// <param name="displayCombination"></param>
/// <param name="AddNull"></param>
public static void BoundCommonDictDataName(LookUpEdit lue, EnumCommonDicData E, bool displayCombination, bool AddNull)
{
BoundCommonDictDataName(lue.Properties, E, displayCombination, AddNull);
}
/// <summary>
/// 绑定基础数据
/// </summary>
/// <param name="lue"></param>
/// <param name="E"></param>
/// <param name="AddNull"></param>
public static void BoundCommonDictDataName(ComboBoxEdit lue, EnumCommonDicData E, bool AddNull)
{
BoundCommonDictDataName(lue.Properties, E, AddNull);
}
