public void DownloadBaseCacheData()
{
IBridge_DataDict bridge = BridgeFactory.CreateDataDictBridge("");
//下载小字典表数据
_AllDataDicts = bridge.DownloadDicts();
//跟据存储过程返回数据表的顺序取
_BusinessTables = _AllDataDicts.Tables[1];
_User = _AllDataDicts.Tables[2];
_Person = _AllDataDicts.Tables[3];
_CustomerAttributes = _AllDataDicts.Tables[4];
_Bank = _AllDataDicts.Tables[5];
_CommonDataDictType = _AllDataDicts.Tables[6];
_PayType = _AllDataDicts.Tables[7];
_Currency = _AllDataDicts.Tables[8];
_Location = _AllDataDicts.Tables[9];
_DepartmentData = _AllDataDicts.Tables[10];
//调用数据表名
_AllDataDicts.Tables[1].TableName = sys_BusinessTables.__TableName;
_AllDataDicts.Tables[2].TableName = TUser.__TableName;
_AllDataDicts.Tables[3].TableName = tb_Person.__TableName;
_AllDataDicts.Tables[4].TableName = tb_CustomerAttribute.__TableName;
_AllDataDicts.Tables[5].TableName = "#Bank"; //tb_CommDataDictType表的银行类别的记录
_AllDataDicts.Tables[6].TableName = tb_CommDataDictType.__TableName;
_AllDataDicts.Tables[7].TableName = tb_PayType.__TableName;
_AllDataDicts.Tables[8].TableName = tb_Currency.__TableName;
_AllDataDicts.Tables[9].TableName = tb_Location.__TableName;
_AllDataDicts.Tables[10].TableName = "#Dept"; //tb_CommDataDictType表的部门类别的记录
}
/// <summary>
/// 构造器
/// </summary>
/// <param name="derivedClassName">派生类的类名.如xxx.xx.x.dalProduct.(未指定类名则创建基类实例)</param>
public ADODirect_DataDict(string derivedClassName)
{
//创建数据层的实例
if (String.IsNullOrEmpty(derivedClassName))
{
_DAL_Instance = new dalBaseDataDict(Loginer.CurrentUser);
}
else
{
_DAL_Instance = dalBaseDataDict.CreateDalByClassName(Loginer.CurrentUser, derivedClassName);
}
}
public bllMenuMgr()
{
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_sys_Function));
_BarDataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_sys_Fun_MenuBar));
_KeyFieldName = tb_sys_Function.__KeyName;
_SummaryTableName = tb_sys_Function.__TableName;
_MyBridge = BridgeFactory.CreateUserGroupBridge();
_AuthorityItem = _MyBridge.GetAuthorityItem(); //Actions Master Data
_AuthorityItem.TableName = tb_sys_Fun_MenuBar.__TableName;
_FormTagCustomName = _MyBridge.GetFormTagCustomName(); //自定义功能名称
}
public bllMenuMgr()
{
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_sys_Function));
_BarDataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_sys_Fun_MenuBar));
_KeyFieldName = tb_sys_Function.__KeyName;
_SummaryTableName = tb_sys_Function.__TableName;
_MyBridge = BridgeFactory.CreateUserGroupBridge();
_AuthorityItem = _MyBridge.GetAuthorityItem(); //Actions Master Data
_AuthorityItem.TableName = tb_sys_Fun_MenuBar.__TableName;
_FormTagCustomName = _MyBridge.GetFormTagCustomName(); //自定义功能名称
}
/// <summary>
/// 保存附件
/// </summary>
/// <param name="storage">附件数据</param>
public void SaveAttachedFile(DataTable storage)
{
DataTable temp = storage.GetChanges(); //获取修改的记录
if (temp != null) //有新增或修改附件，保存数据
{
IBridge_DataDict bridge = BridgeFactory.CreateDataDictBridge(typeof(tb_AttachFile));
DataSet ds = new DataSet();
ds.Tables.Add(temp);
bridge.Update(ds);
}
}
/// <summary>
/// 构造器
/// </summary>
/// <param name="derivedClassName">派生类的类名.如xxx.xx.x.dalProduct.(未指定类名则创建基类实例)</param>
public ADODirect_SGBaseDict(string derivedClassName)
{
//创建数据层的实例
if (String.IsNullOrEmpty(derivedClassName))
{
_DAL_Instance = new dalBaseDataDict(Loginer.CurrentUser);
}
else
{
_DAL_Instance = dalBaseDataDict.CreateDalByClassName(Loginer.CurrentUser, derivedClassName);
}
}
// 获取所有字典数据
public void DownloadBaseCacheData()
{
IBridge_DataDict bridge = BridgeFactory.CreateDataDictBridge("");
//下载小字典表数据
_AllDataDicts = bridge.DownloadDicts();
_DataDictType = _AllDataDicts.Tables[1];
string[] TableNames = new string[] { "CONFIG_DETAIL", "CONFIG_HEADER", "WAREHOUSE", "COMPANY"
, "PALLETSPEC", "PALLET", "WARECELLSPEC", "WARECELL"
, "ZONE", "ROADWAY" };
for (int i = 0; i < _AllDataDicts.Tables.Count; i++)
{
_AllDataDicts.Tables[i].TableName = TableNames[i];
}
}
/// <summary>
/// 刷新单个数据字典
/// </summary>
/// <param name="tableName">字典表名</param>
public static void RefreshCache(string tableName)
{
DataTable cache = DataDictCache.Cache.GetCacheTableData(tableName);
if (cache != null) //有客户窗体引用缓存数据时才更新
{
IBridge_DataDict bridge = BridgeFactory.CreateDataDictBridge(tableName, "");
DataTable data = bridge.GetDataDictByTableName(tableName);
cache.Rows.Clear();
foreach (DataRow row in data.Rows)
{
cache.ImportRow(row);
}
cache.AcceptChanges();
}
}
public void DownloadBaseCacheData()
{
IBridge_DataDict bridge = BridgeFactory.CreateDataDictBridge("");
//下载小字典表数据
_AllDataDicts = bridge.DownloadDicts();
if (_AllDataDicts == null)
{
return;
}
//调用数据表名
_AllDataDicts.Tables[0].TableName = tb_sys_User.__TableName;
_AllDataDicts.Tables[1].TableName = tb_sys_Department.__TableName;
_AllDataDicts.Tables[2].TableName = tb_sys_DbLink.__TableName;
_AllDataDicts.Tables[3].TableName = tb_t_CommDataDictType.__TableName;
_AllDataDicts.Tables[4].TableName = tb_t_CommonDataDict.__TableName;
_AllDataDicts.Tables[5].TableName = tb_t_ItemClass.__TableName;
_AllDataDicts.Tables[6].TableName = tb_t_ItemPropDesc.__TableName;
_AllDataDicts.Tables[7].TableName = tb_sys_Function.__TableName;;
_AllDataDicts.Tables[8].TableName = tb_sys_Fun_MenuBar.__TableName;
//_AllDataDicts.Tables[9].TableName = tb_Location.__TableName;
//_AllDataDicts.Tables[10].TableName = "#Dept"; //tb_CommDataDictType表的部门类别的记录
//跟据存储过程返回数据表的顺序取
_User = _AllDataDicts.Tables[0];
_DepartmentData = _AllDataDicts.Tables[1];
_DbLink = _AllDataDicts.Tables[2];
_CommonDataDictType = _AllDataDicts.Tables[3];
_CommonDataDict = _AllDataDicts.Tables[4];
_CommonDataDict.TableName = tb_t_CommonDataDict.__TableName;
_ItemClass = _AllDataDicts.Tables[5];
_ItemPropDesc = _AllDataDicts.Tables[6];
_Function = _AllDataDicts.Tables[7];
_FunBar = _AllDataDicts.Tables[8];
//_CustomerAttributes = _AllDataDicts.Tables[4];
//_Bank = _AllDataDicts.Tables[5];
//_CommonDataDictType = _AllDataDicts.Tables[6];
//_PayType = _AllDataDicts.Tables[7];
//_Currency = _AllDataDicts.Tables[8];
//_Location = _AllDataDicts.Tables[9];
//_DepartmentData = _AllDataDicts.Tables[10];
}
public bool SaveGroup(DataSet save)
{
IBridge_DataDict dataDict = BridgeFactory.CreateDataDictBridge(typeof(TUserGroup));
return(dataDict.Update(save));
}
public ADODirect_DataDict(Type ORM)
{
//创建数据层的实例
_DAL_Instance = dalBaseDataDict.CreateDalByORM(Loginer.CurrentUser, ORM.FullName);
}
/// <summary>
/// 获取表的所有字段
/// </summary>
/// <param name="tableName">表名</param>
//public static DataTable GetTableFieldsDef(string tableName, bool onlyDisplayField)
//{
// IBridge_CommonData bridge = BridgeFactory.CreateCommonDataBridge();
// return bridge.GetTableFieldsDef(tableName, onlyDisplayField);
//}
/// <summary>
/// 获取数据字典
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public static DataTable GetDataDict(string tableName)
{
IBridge_DataDict bridge = BridgeFactory.CreateDataDictBridge(tableName, "");
return(bridge.GetSummaryData());
}
public ADODirect_SGBaseDict(Type ORM)
{
//创建数据层的实例
_DAL_Instance = dalBaseDataDict.CreateDalByORM(Loginer.CurrentUser, ORM.FullName);
}
