public SysManagementUnitCollection FetchAll() { SysManagementUnitCollection coll = new SysManagementUnitCollection(); Query qry = new Query(SysManagementUnit.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public SysManagementUnitCollection FetchByQuery(Query qry) { SysManagementUnitCollection coll = new SysManagementUnitCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public SysManagementUnitCollection FetchAll() { SysManagementUnitCollection coll = new SysManagementUnitCollection(); Query qry = new Query(SysManagementUnit.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static LIS.DAL.SysManagementUnitCollection GetSysManagementUnitCollection(long varIRole) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Sys_ManagementUnit] INNER JOIN [tbl_RolesForUsers] ON [Sys_ManagementUnit].[PK_sBranchID] = [tbl_RolesForUsers].[FP_sBranchID] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name); cmd.AddParameter("@FP_sBranchID", varIRole, DbType.String); IDataReader rdr = SubSonic.DataService.GetReader(cmd); SysManagementUnitCollection coll = new SysManagementUnitCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
public static void SaveSysManagementUnitMap(long varIRole, SysManagementUnitCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name); cmdDel.AddParameter("@FP_sBranchID", varIRole, DbType.String); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (SysManagementUnit item in items) { TblRolesForUser varTblRolesForUser = new TblRolesForUser(); varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole); varTblRolesForUser.SetColumnValue("FP_sBranchID", item.GetPrimaryKeyValue()); varTblRolesForUser.Save(); } }
public SysManagementUnitCollection FetchByQuery(Query qry) { SysManagementUnitCollection coll = new SysManagementUnitCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public SysManagementUnitCollection FetchByID(object PkSBranchID) { SysManagementUnitCollection coll = new SysManagementUnitCollection().Where("PK_sBranchID", PkSBranchID).Load(); return coll; }
public SysManagementUnitCollection FetchByID(object PkSBranchID) { SysManagementUnitCollection coll = new SysManagementUnitCollection().Where("PK_sBranchID", PkSBranchID).Load(); return(coll); }