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表的部门类别的记录
}
public bllUser()
{
_KeyFieldName = TUser.__KeyName; //主键字段
_SummaryTableName = TUser.__TableName; //表名
_WriteDataLog = false; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(TUser));
_MyBridge = this.CreateBridge();
}
private IBridge_Customer _MyBridge; //桥接/策略接口
public bllCustomer()
{
_KeyFieldName = tb_Customer.__KeyName; //主键字段
_SummaryTableName = tb_Customer.__TableName; //表名
_WriteDataLog = true; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_Customer));
_MyBridge = this.CreateBridge();
}
public bllCommonDataDict()
{
_KeyFieldName = tb_CONFIG_DETAIL.__KeyName; //主键字段
_SummaryTableName = tb_CONFIG_DETAIL.__TableName; //表名
_WriteDataLog = true; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_CONFIG_DETAIL));
_SelfBridge = BridgeFactory.CreateCommonDataDictBridge();
}
public bllAccountIDs()
{
_KeyFieldName = tb_AccountIDs.__KeyName; //主键字段
_SummaryTableName = tb_AccountIDs.__TableName; //表名
_WriteDataLog = false; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_AccountIDs));
_MyBridge = this.CreateBridge();
}
private IBridge_SUPPLIERCUSTOMER _MyBridge; //桥接/策略接口
public bllSUPPLIERCUSTOMER()
{
_KeyFieldName = tb_SUPPLIERCUSTOMER.__KeyName; //主键字段
_SummaryTableName = tb_SUPPLIERCUSTOMER.__TableName; //表名
_WriteDataLog = true; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_SUPPLIERCUSTOMER));
_MyBridge = this.CreateBridge();
}
public bllSystemProfile()
{
_KeyFieldName = tb_sys_SystemProfile.__KeyName; //主键字段
_SummaryTableName = tb_sys_SystemProfile.__TableName; //表名
_WriteDataLog = false; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_sys_SystemProfile));
_MyBridge = this.CreateBridge();
}
private IBridge_Customer _MyBridge; //桥接/策略接口
public blltest03()
{
_KeyFieldName = tb_test01.__KeyName; //主键字段
_SummaryTableName = tb_test01.__TableName; //表名
_WriteDataLog = true; //是否保存日志
//_DAL = new daltest03(Loginer.CurrentUser);//数据层的实例
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_test01));
_MyBridge = this.CreateBridge();
}
public bllPerson()
{
_KeyFieldName = tb_Person.__KeyName; //主键字段
_SummaryTableName = tb_Person.__TableName; //表名
_WriteDataLog = true; //是否保存日志
//方式一：由ORM自动查询DAL类
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_Person));
}
public bllCommonDataDict()
{
_KeyFieldName = tb_t_CommonDataDict.__KeyName; //主键字段
_SummaryTableName = tb_t_CommonDataDict.__TableName; //表名
_WriteDataLog = false; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_t_CommonDataDict));
_SelfBridge = BridgeFactory.CreateCommonDataDictBridge();
_SummaryTable = DataDictCache.Cache.CommonDataDict;
}
public bllMenuMgr()
{
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(TMenu));
_KeyFieldName = TMenu.__KeyName;
_SummaryTableName = TMenu.__TableName;
_MyBridge = BridgeFactory.CreateUserGroupBridge();
_AuthorityItem = _MyBridge.GetAuthorityItem(); //Actions Master Data
_FormTagCustomName = _MyBridge.GetFormTagCustomName(); //自定义功能名称
}
public bllDatabaseSet()
{
_KeyFieldName = tb_t_ItemPropDesc.__KeyName; //主键字段
_SummaryTableName = tb_t_ItemPropDesc.__TableName; //表名
_ClassKeyFieldName = tb_t_ItemClass.__KeyName; //分类字段主键
_ClassSummaryTableName = tb_t_ItemClass.__TableName; //表名
_WriteDataLog = true; //是否保存日志
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_t_ItemClass));
_ItemClassBridge = BridgeFactory.CreateItemClassBridge();
_ItemPropDescBridge = BridgeFactory.CreateItemPropDescBridge();
}
/// <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);
}
}
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 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 bllCompanyInfo()
{
_KeyFieldName = tb_CompanyInfo.CompanyCode;
_SummaryTableName = tb_CompanyInfo.__TableName;
_DataDictBridge = BridgeFactory.CreateDataDictBridge(typeof(tb_CompanyInfo));
}
public bool SaveGroup(DataSet save)
{
IBridge_DataDict dataDict = BridgeFactory.CreateDataDictBridge(typeof(TUserGroup));
return(dataDict.Update(save));
}
/// <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());
}
