protected override void onSchemaLoaded()
{
addTypedCalcHandler()
.setColumns(AppDataName.EOET_InUse_XX, AppDataName.EOET_InUseName_XX)
.setReferences(AppDataName.EOET_EmployeeTitleId)
.setHandler(dt => {
link_EOET_InUse_XX(dt);
});
addTypedCalcHandler()
.setColumns(AppDataName.EOET_UserCount_XX)
.setHandler(dt => {
var keys = dt.getPrimaryKeys();
var qry = new NsDbQuery();
qry.setSelect(s => {
var t1 = s.from <EO_Employee>();
s.Where = t1.EOE_EmployeeTitleId.batchin(keys.toConstReq1());
s.groupBy(t1.EOE_EmployeeTitleId);
s.select(t1.EOE_EmployeeTitleId, NSQL.count().As("TCount"));
});
var dt1 = qry.queryData();
dt1.Constraints.Add("pk", dt1.Columns[0], true);
foreach (var row in dt)
{
row.EOET_UserCount_XX = 0;
var row1 = dt1.Rows.Find(row.EOET_EmployeeTitleId);
if (row1 != null)
{
row.EOET_UserCount_XX = row1.getInt("TCount");
}
}
});
base.onSchemaLoaded();
}
private void link_EOD_EmployeeCount_XX(EO_DepartmentDataTable dt)
{
var pks = dt.getPrimaryKeys();
var qrydb = new NsDbQuery();
qrydb.setSelect(s => {
var t1 = s.from <EO_DeptMember>();
s.select(t1.EODM_DeptId, NSQL.count().As("EmpCount"));
s.Where = t1.EODM_DeptId.batchin(pks.toConstReq1());
s.groupBy(s.Selects[0]);
});
var dt2 = qrydb.queryData();
dt2.Constraints.Add("PK", dt2.Columns[0], true);
FtdDataHelper.linkTable(dt, dt2, new FtdDataHelper.LinkInfo(AppDataName.EOD_DepartmentId, AppDataName.EOD_EmployeeCount_XX, "EmpCount", 0));
}
private void link_CRCL_RegisterQty_XX(CR_ClassDataTable dt)
{
var pks = dt.getPrimaryKeys();
var qrydb = new NsDbQuery();
qrydb.setSelect(s =>
{
var t1 = s.from <CR_Registration>();
s.select(t1.CRR_ClassId, NSQL.count().As("UserCount"));
s.Where = t1.CRR_ClassId.batchin(pks.toConstReq1());
s.groupBy(s.Selects[0]);
});
var dt2 = qrydb.queryData();
dt2.Constraints.Add("PK", dt2.Columns[0], true);
FtdDataHelper.linkTable(dt, dt2, new FtdDataHelper.LinkInfo(AppDataName.CRCL_ClassId, AppDataName.CRCL_RegisterQty_XX, "UserCount", 0));
}
protected override void onSchemaLoaded()
{
addTypedCalcHandler()
.setColumns(AppDataName.EOD_ChildCount_XX, AppDataName.EOD_BrotherCount_XX)
.setReferences(AppDataName.EOD_DepartmentId, AppDataName.EOD_ParentId)
.setHandler(dt =>
{
var pks = dt.Select(x => x.EOD_DepartmentId).Union(dt.Select(x => x.EOD_ParentId)).Distinct().ToArray();
var qry = new NsDbQuery();
qry.setSelect(s =>
{
var t1 = s.from <EO_Department>();
s.Where = t1.EOD_ParentId.batchin(pks.toConstReq1());
s.select(t1.EOD_ParentId.isnull("@").As("ID"), NSQL.count().As("TheCount"));
s.groupBy(t1.EOD_ParentId);
});
var dt1 = qry.queryData();
var keys = dt1.Rows.Cast <DataRow>().Select(x => new { ID = x.getString("ID"), TheCount = x.getInt("TheCount").Value }).ToDictionary(x => x.ID);
foreach (var row in dt)
{
//ChildCount
{
var row1 = keys.findKey(row.EOD_DepartmentId);
if (row1 != null)
{
row.EOD_ChildCount_XX = row1.TheCount;
}
else
{
row.EOD_ChildCount_XX = 0;
}
}
//BrotherCount
{
var row1 = keys.findKey(row.EOD_ParentId.nullOrEmptyAs("@"));
if (row1 != null)
{
row.EOD_BrotherCount_XX = row1.TheCount;
}
else
{
row.EOD_BrotherCount_XX = 0;
}
}
}
});
addTypedSqlHandler()
.setColumns(AppDataName.EOD_DepartmentTypeName_XX)
.setHandler(
t1 => t1.EOD_DepartmentType.decode("A", "部門", "B", "群組", t1.EOD_DepartmentType)
);
addTypedCalcHandler()
.setColumns(AppDataName.EOD_EmployeeCount_XX)
.setHandler(dt => {
link_EOD_EmployeeCount_XX(dt);
});
addTypedSqlHandler()
.setColumns(AppDataName.EOD_DepartmentObjectName_XX)
.setHandler(
t1 => (t1.PrimaryKey == null).istrue("", "[" + t1.EOD_DepartmentTypeName_XX + "]" + t1.EOD_DepartmentName)
);
addTypedCalcHandler()
.setColumns(AppDataName.EOD_CU_IsVirtualVisible_XX)
.setReferences(AppDataName.EOD_DepartmentType, AppDataName.EOD_VirtualType)
.setHandler(dt => {
link_EOD_CU_IsVirtualVisible_XX(dt);
});
addTypedCalcHandler()
.setColumns(AppDataName.EOD_DepartmentFullName_XX)
.setReferences(AppDataName.EOD_ParentId, AppDataName.EOD_DepartmentName)
.setHandler(dt => {
link_EOD_DepartmentFullName_XX(dt);
});
addTypedCalcHandler()
.setColumns(AppDataName.EOD_DepartmentFullNameII_XX)
.setReferences(AppDataName.EOD_DepartmentName, AppDataName.EOD_DepartmentFullName_XX)
.setHandler(dt => {
foreach (var row in dt)
{
row.EOD_DepartmentFullNameII_XX = row.EOD_DepartmentCode.isNullOrEmpty() ? row.EOD_DepartmentFullName_XX : row.EOD_DepartmentCode + "-" + row.EOD_DepartmentFullName_XX;
}
});
addTypedCalcHandler()
.setColumns(AppDataName.EOD_IsDeleteable_XX)
.setReferences(AppDataName.EOD_DepartmentType, AppDataName.EOD_ChildCount_XX, AppDataName.EOD_EmployeeCount_XX)
.setHandler(dt => {
foreach (var row in dt)
{
if (row.EOD_DepartmentType == "A")
{
row.EOD_IsDeleteable_XX = (row.EOD_ChildCount_XX == 0 && row.EOD_EmployeeCount_XX == 0) ? "T" : "F";
}
if (row.EOD_DepartmentType == "B")
{
row.EOD_IsDeleteable_XX = (row.EOD_ChildCount_XX == 0) ? "T" : "F";
}
}
});
addTypedCalcHandler()
.setColumns(AppDataName.EOD_ScopeLevelNo_XX, AppDataName.EOD_ScopeTreeLeftNo_XX, AppDataName.EOD_ScopeTreeRightNo_XX)
.setReferences(AppDataName.EOD_ParentId)
.setHandler(dt => {
//向上展開樹
var dta = FtdDataHelper.TableTree.getTreeUpExpand(
dt,
dt1 =>
{
//Find All Parent
var pks = dt1.Select(x => x.EOD_ParentId).Distinct().ToArray();
var dt2 = NsDmHelper.EO_Department.wherepks(pks).query();
return(dt2);
}
, (dt1, dt2) =>
{
var rows = dt1.Where(x => dt2.findByPrimaryKey(x.EOD_DepartmentId) != null).ToArray();
rows.forEach(x => dt1.Rows.Remove(x));
}
);
//樹系代號計算
FtdDataHelper.TableTree.calcTreeNo(dta, "X_TreeNo1", "X_TreeNo2", "X_Level"
, dt1 => dt1.Where(x => x.EOD_ParentId.isNullOrEmpty()).OrderBy(x => x.EOD_SortNo)
, (dt1, row1) =>
{
var pk = ((EO_DepartmentRow)row1).EOD_DepartmentId;
return(dt1.Where(x => x.EOD_ParentId == pk).OrderBy(x => x.EOD_SortNo));
}
);
foreach (var row in dt)
{
var rowa = dta.findByPrimaryKey(row.EOD_DepartmentId);
if (rowa == null)
{
row.EOD_ScopeLevelNo_XX = null;
row.EOD_ScopeTreeLeftNo_XX = null;
row.EOD_ScopeTreeRightNo_XX = null;
}
else
{
row.EOD_ScopeLevelNo_XX = rowa.getInt("X_Level").Value;
row.EOD_ScopeTreeLeftNo_XX = rowa.getInt("X_TreeNo1").Value;
row.EOD_ScopeTreeRightNo_XX = rowa.getInt("X_TreeNo2").Value;
}
}
});
base.onSchemaLoaded();
}