/// <summary>
/// #目前登入者是可否看見此群組部門{CU_IsVirtualVisible}：○{T}是 ○{F}不是※群組需為公開或是非公開，但是為其成員者。
/// </summary>
private void link_EOD_CU_IsVirtualVisible_XX(EO_DepartmentDataTable dt)
{
var empId = NsQueryContext.getCurrentUserId();
//NsQueryContext.getCurrentUserId()();
//SdmService.Instance.ServiceContext[AppDdParameterName.DDPN_EOE_EmployeeId];
//找出人員的所有部門
var dt1 = NsDmHelper.EO_DeptMember.where (t1 => t1.EODM_MemberId == empId.toConstReq1()).query();
dt1.Constraints.Add("pk", dt1.EODM_DeptIdColumn, true);
foreach (var row in dt)
{
if (row.EOD_DepartmentType == "B")
{
if (row.EOD_VirtualType == "A")
{
row.EOD_CU_IsVirtualVisible_XX = "T";
}
else
{
if (dt1.Rows.Find(row.EOD_DepartmentId) == null)
{
row.EOD_CU_IsVirtualVisible_XX = "F";
}
else
{
row.EOD_CU_IsVirtualVisible_XX = "T";
}
}
}
}
}
protected override void onSchemaLoaded()
{
addTypedSqlHandler()
.setColumns(AppDataName.EOE_EmployeeFullName_XX)
.setHandler(t1 => (t1.PrimaryKey == null).istrue("", t1.EOE_DepartmentName_XX + "-" + t1.EOE_EmployeeName + " " + t1.EOE_EmployeeTitleName_XX))
//.setHandler(t1 => (t1.PrimaryKey == null).istrue("", t1.EOE_OrganSName_XX + "-" + t1.EOE_EmployeeName + " " + t1.EOE_EmployeeTitleName_XX))
;
addTypedSqlHandler()
.setColumns(AppDataName.EOE_EmployeeStandardName_XX)
.setHandler(t1 => (t1.PrimaryKey == null).istrue("", t1.EOE_EmployeeName + " " + t1.EOE_EmployeeTitleName_XX))
;
addTypedSqlHandler()
.setColumns(AppDataName.EOE_SexName_XX)
.setHandler(t => t.EOE_Sex.decode("A", "男", "B", "女", t.EOE_Sex))
;
addTypedSqlHandler()
.setColumns(AppDataName.EOE_EmployeeSearchName_XX)
.setHandler(t1 => t1.EOE_EmployeeName + NSQL.iif(t1.EOE_EmployeeTitleName_XX.isnull("") != "", " " + t1.EOE_EmployeeTitleName_XX.isnull(""), "") + NSQL.iif(t1.EOE_EmployeeEmail != "", " (" + t1.EOE_EmployeeEmail + ")", ""))
;
addTypedSqlHandler()
.setColumns(AppDataName.EOE_IsLeave_XX)
.setHandler(t1 => NSQL.iif(t1.EOE_LeaveDate != null, "T", "F"))
;
addTypedSqlHandler()
.setColumns(AppDataName.EOE_CU_IsLoginUser_XX)
.setHandler(t => {
var userId = NsQueryContext.getCurrentUserId();
return((t.EOE_EmployeeId == userId).istrue("T", "F"));
});
base.onSchemaLoaded();
}
