/// <summary>
/// 取得關連明細資料表使用欄位集合。
/// </summary>
/// <param name="useFields">取得使用的欄位集合。</param>
/// <param name="detailTableName">傳回明細資料表名稱。</param>
private GStringHashSet GetUseDetailTableFields(GStringHashSet useFields, out string detailTableName)
{
GStringHashSet oUseFields;
string sDetailTableName;
string sTableName;
string sFieldName;
sDetailTableName = string.Empty;
oUseFields = new GStringHashSet();
foreach (string fieldName in useFields)
{
if (StrFunc.StrContains(fieldName, "."))
{
// 折解資料表及欄位名稱
StrFunc.StrSplitFieldName(fieldName, out sTableName, out sFieldName);
// 主檔不能同時 Join 多個明細資料表
if (StrFunc.StrIsNotEmpty(sDetailTableName) && !StrFunc.SameText(sDetailTableName, sTableName))
{
throw new GException("Master Table can't Join multi Detail Table");
}
sDetailTableName = sTableName;
oUseFields.Add(sFieldName);
}
}
detailTableName = sDetailTableName;
return(oUseFields);
}
/// <summary>
/// 取得使用到的欄位集合。
/// </summary>
/// <param name="tableDefine">資料表定義。</param>
private GStringHashSet GetUseFields(GTableDefine tableDefine)
{
// 取得資料表定義
var useFieldSet = new GStringHashSet();
if (StrFunc.StrIsEmpty(this.SelectFields))
{
// 包含所有欄位
foreach (GFieldDefine fieldDefine in tableDefine.Fields)
{
useFieldSet.Add(fieldDefine.FieldName);
}
}
else
{
// 加入取回欄位
useFieldSet.Add(this.SelectFields, ",");
// 加入篩選欄位
foreach (GFilterItem filterItem in this.FilterItems)
{
useFieldSet.Add(filterItem.FieldName);
}
// 加入排序欄位
foreach (GSortField sortField in this.SortFields)
{
useFieldSet.Add(sortField.FieldName);
}
}
return(useFieldSet);
}
/// <summary>
/// 取得 Select 的欄位集合字串。
/// </summary>
/// <param name="tableDefine">資料表。</param>
/// <param name="selectFields"></param>
private string GetSelectFields(GTableDefine tableDefine, string selectFields)
{
if (StrFunc.StrIsEmpty(selectFields))
{
return(string.Empty);
}
var oSelectFields = StrFunc.StrSplit(selectFields, ",");
var oFields = new GStringHashSet(selectFields, ",");
return(oFields.ToString(","));
}
/// <summary>
/// 取得主要資料表使用欄位集合。
/// </summary>
/// <param name="useFields">使用欄位集合。</param>
private GStringHashSet GetUseTableFields(GStringHashSet useFields)
{
var useFieldSet = new GStringHashSet();
foreach (string fieldName in useFields)
{
if (!StrFunc.StrContains(fieldName, "."))
{
useFieldSet.Add(fieldName);
}
}
return(useFieldSet);
}
/// <summary>
/// 取得關連取回欄位集合。
/// </summary>
/// <param name="tableDefine">資料表定義。</param>
/// <param name="linkFieldName">關連來源欄位。</param>
/// <param name="useFields">使用到的欄位集合。</param>
private GStringHashSet GetReturnFields(GTableDefine tableDefine, string linkFieldName, GStringHashSet useFields)
{
GStringHashSet oReturnFields;
GFieldDefine oFieldDefine;
oReturnFields = new GStringHashSet();
foreach (string fieldName in useFields)
{
oFieldDefine = tableDefine.Fields[fieldName];
if (oFieldDefine.FieldType == EFieldType.LinkField && StrFunc.SameText(oFieldDefine.LinkFieldName, linkFieldName))
{
oReturnFields.Add(fieldName);
}
}
return(oReturnFields);
}
/// <summary>
/// 建立資料表關連。
/// </summary>
/// <param name="key">關連鍵值。</param>
/// <param name="provider">資料表關連資訊提供者。</param>
/// <param name="fieldDefine">關連欄位定義。</param>
/// <param name="returnFields">關連取回欄位集合。</param>
/// <param name="leftTableAlias">左側資料表別名。</param>
/// <param name="detailTableName">明細資料表名稱。</param>
/// <param name="destFieldName">目的欄位名稱。</param>
private void BuildTableJoin(string key, GTableJoinProvider provider, GFieldDefine fieldDefine, GStringHashSet returnFields, string leftTableAlias, string detailTableName, string destFieldName = "")
{
// 取得關連程式定義
var programDefine = CacheFunc.GetProgramDefine(fieldDefine.LinkProgID);
if (BaseFunc.IsNull(programDefine))
{
throw new GException("'{0}' ProgramDefine not found", fieldDefine.LinkProgID);
}
// 取得關連資料表定義
var tableDefine = programDefine.MasterTable;
foreach (string fieldName in returnFields)
{
var linkReturnField = fieldDefine.LinkReturnFields.FindByDestField(fieldName);
if (BaseFunc.IsNull(linkReturnField))
{
throw new GException("'{0}' FieldDefine's LinkReturnFields not find DestField '{1}'", fieldDefine.FieldName, fieldName);
}
var sourceFieldDefine = tableDefine.Fields[linkReturnField.SourceField];
if (BaseFunc.IsNull(sourceFieldDefine))
{
throw new GException("'{0}' TableDefine not find '{1}' FieldDefine", tableDefine.TableName, linkReturnField.SourceField);
}
if (sourceFieldDefine.FieldType == EFieldType.VirtualField)
{
throw new GException("'{0}' TableDefine's '{1}' FieldDefine not allow VirtualField", tableDefine.TableName, sourceFieldDefine.FieldName);
}
var tableJoin = provider.TableJoins[key];
if (BaseFunc.IsNull(tableJoin))
{
// 建立資料表關連
tableJoin = new GTableJoin
{
Key = key,
LeftTableAlias = leftTableAlias,
LeftFieldName = tableDefine.GetLinkReturnActiveField(fieldDefine).DbFieldName,
RightTableName = tableDefine.DbTableName,
RightTableAlias = GetActiveTableAlias()
};
var sKeyField = tableDefine.Fields.Contains(SysFields.ID) ? SysFields.ID : SysFields.RowID;
tableJoin.RightFieldName = tableDefine.Fields[sKeyField].DbFieldName;
if (tableDefine.Fields.Contains(SysFields.CompanyID))
{
tableJoin.RightCompanyID = tableDefine.Fields[SysFields.CompanyID].DbFieldName;
}
else if (tableDefine.Fields.Contains(SysFields.CommonCompanyID))
{
tableJoin.RightCompanyID = tableDefine.Fields[SysFields.CommonCompanyID].DbFieldName;
}
provider.TableJoins.Add(tableJoin);
}
// 若來源欄位的欄位類型是 LinkField，則需往上階找關連來源
if (sourceFieldDefine.FieldType == EFieldType.LinkField)
{
var linkFieldDefine = tableDefine.GetLinkReturnActiveField(sourceFieldDefine);
var sKey = key + "." + linkFieldDefine.LinkProgID;
var returnFieldSet = new GStringHashSet {
sourceFieldDefine.DbFieldName
};
BuildTableJoin(sKey, provider, linkFieldDefine, returnFieldSet, tableJoin.RightTableAlias, detailTableName, fieldName);
}
else
{
// 記錄關連欄位對應
var linkFieldMapping = new GLinkFieldMapping();
linkFieldMapping.FieldName = (StrFunc.StrIsNotEmpty(destFieldName)) ? destFieldName : fieldName;
if (StrFunc.StrIsNotEmpty(detailTableName))
{
linkFieldMapping.FieldName = StrFunc.StrFormat("{0}.{1}", detailTableName, linkFieldMapping.FieldName);
}
linkFieldMapping.TableAlias = tableJoin.RightTableAlias;
linkFieldMapping.SourceFieldName = sourceFieldDefine.DbFieldName;
provider.Mappings.Add(linkFieldMapping);
}
}
}
/// <summary>
/// 建立資料表關連。
/// </summary>
/// <param name="provider">資料表關連資訊提供者。</param>
/// <param name="tableDefine">資料表定義。</param>
/// <param name="useFields">使用到的欄位集合。</param>
/// <param name="detailTableName">明細資料表名稱。</param>
private void BuildTableJoins(GTableJoinProvider provider, GTableDefine tableDefine, GStringHashSet useFields, string detailTableName = "")
{
foreach (GFieldDefine fieldDefine in tableDefine.Fields)
{
if (fieldDefine.FieldType == EFieldType.DataField && StrFunc.StrIsNotEmpty(fieldDefine.LinkProgID))
{
var oReturnFields = GetReturnFields(tableDefine, fieldDefine.FieldName, useFields);
if (oReturnFields.Count > 0)
{
var key = StrFunc.StrFormat("{0}.{1}.{2}", tableDefine.TableName, fieldDefine.FieldName, fieldDefine.LinkProgID);
var leftTableAlias = StrFunc.StrIsEmpty(detailTableName) ? "A" : "DA";
BuildTableJoin(key, provider, fieldDefine, oReturnFields, leftTableAlias, detailTableName);
}
}
}
}
