internal List<OrgGroup> GetOrgGroup(IDbConnection conn, IWhere where = null) { string tableName = "OrgGroup"; string fields = "PK_Group,InnerCode,Name,NC_PK_Group,NC_Modifiedtime"; if (where != null) { List<OrgGroup> t = conn.MultiQuery<List<OrgGroup>>(tableName) .Fields(fields) .Where(where) .Execute(); return t; } else { List<OrgGroup> t = conn.MultiQuery<List<OrgGroup>>(tableName) .Fields(fields) .Execute(); return t; } }
internal List<Department> GetDepartment(IDbConnection conn, IWhere where = null) { string tableName = "Department"; string fields = "PK_Dept,InnerCode,Name,PK_FDept,PK_Org,PK_Group,NC_PK_Dept,NC_Modifiedtime"; if (where != null) { List<Department> t = conn.MultiQuery<List<Department>>(tableName) .Fields(fields) .Where(where) .Execute(); return t; } else { List<Department> t = conn.MultiQuery<List<Department>>(tableName) .Fields(fields) .Execute(); return t; } }
internal List<PersonCore> GetPersonCore(IDbConnection conn, IWhere where = null) { string tableName = "PersonCore"; string fields = "PK_User,Code,Name,ShortName,IDCardNumber,Sex,Age,Email,Mobile,Birthdate,JoinWorkDate,Censusaddr,NC_PK_User,NC_Modifiedtime"; if (where != null) { List<PersonCore> t = conn.MultiQuery<List<PersonCore>>(tableName) .Fields(fields) .Where(where) .Execute(); return t; } else { List<PersonCore> t = conn.MultiQuery<List<PersonCore>>(tableName) .Fields(fields) .Execute(); return t; } }