예제 #1
0
        protected internal DataTable GetImport(int cid)
        {
            DBComparison client = DBComparison.Equal(DBField.Field(TalentozTemplate.ClientID.Name), DBConst.Int32(cid));
            DBQuery      select = DBQuery.SelectAll().From(TalentozTemplate.Table).Where(client).OrderBy(TalentozTemplate.Name.Name, Order.Ascending);

            return(db.GetDatatable(select));
        }
        public DataTable GetView(string viewID)
        {
            DBComparison dbView = DBComparison.Compare(DBField.Field(TalentozViewSchema.ViewID.Name),
                                                       Compare.Equals, DBConst.String(viewID));
            DBQuery se = DBQuery.SelectAll().From(TalentozView.Table).Where(dbView);

            return(db.GetDatatable(se));
        }
예제 #3
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public DataTable GetTables(string clientid, string serverid)
        {
            DBQuery      select;
            DBComparison client = DBComparison.Equal(DBField.Field(TzAccount.ClientServer.ClientID.Name), DBConst.String(clientid));
            DBComparison server = DBComparison.Equal(DBField.Field(TzAccount.ClientServer.ServerID.Name), DBConst.String(serverid));

            DBConst dbclientid = DBConst.String(clientid);

            select = DBQuery.SelectAll(TzAccount.Tables.Table).From(TzAccount.Tables.Table)
                     .WhereAll(client, server);
            return(db.GetDatatable(select));
        }
예제 #4
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="tableid"></param>
        /// <returns></returns>
        public DataTable GetFields(string tableid)
        {
            DBQuery select;

            select = DBQuery.SelectAll(TzAccount.Field.Table).From(TzAccount.Field.Table)
                     .LeftJoin(TzAccount.Field.Table).On(TzAccount.Field.TableID, Compare.Equals, TzAccount.Field.TableID);

            return(db.GetDatatable(select));
        }
예제 #5
0
        /// <summary>
        ///
        /// </summary>

        /// <returns></returns>
        public DataTable GetServer( )
        {
            DBDatabase db;

            db = base.Database;
            DBQuery select;

            select = DBQuery.SelectAll(TzAccount.Server.Table).From(TzAccount.Server.Table);
            return(db.GetDatatable(select));
        }
예제 #6
0
        public DataTable GetSecurityGroup(string clientid, string groupID)
        {
            DBQuery select;
            //   DBComparison baseType= DBComparison.Equal(DBField.Field(TzAccount.SecurityGroup.BaseType .Name), DBConst.Int32(pBaseType));
            DBComparison client = DBComparison.Equal(DBField.Field(TzAccount.SecurityGroup.ClientID.Name), DBConst.String(clientid));
            DBComparison group  = DBComparison.Equal(DBField.Field(TzAccount.SecurityGroup.SecurityGroupID.Name), DBConst.String(groupID));

            select = DBQuery.SelectAll(TzAccount.SecurityGroup.Table).From(TzAccount.SecurityGroup.Table)
                     .WhereAll(client, group);
            return(db.GetDatatable(select));
        }
예제 #7
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="serverid"></param>
        /// <returns></returns>
        public DataTable GetServer(string serverid)
        {
            DBDatabase db;

            db = base.Database;
            DBQuery select;

            select = DBQuery.SelectAll(TzAccount.Server.Table).From(TzAccount.Server.Table)
                     .WhereField(TzAccount.Server.Table, TzAccount.Server.ServerID.Name, Compare.Equals, DBConst.String(serverid));
            return(db.GetDatatable(select));
        }
예제 #8
0
        public System.Data.DataTable GetData(int currentPage, int PageSize, string tb)
        {
            System.Data.DataTable dt = new DataTable();
            DBDatabase            db = base.Database;
            string  dbname           = base.Schema;
            DBQuery totalRecord      = DBQuery.SelectCount().From(dbname, tb);
            int     trecord          = Convert.ToInt32(db.ExecuteScalar(totalRecord));
            DBQuery record           = DBQuery.SelectAll().From(dbname, tb).TopRange(currentPage * PageSize, PageSize);
            var     dtRecord         = db.GetDatatable(record);

            return(dtRecord);
        }
예제 #9
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="clientid"></param>
        /// <param name="groupid"></param>
        /// <param name="privilegeid"></param>
        /// <returns></returns>
        public DataTable GetPrivilege(string clientid, string groupid, string privilegeid)
        {
            DBQuery      select;
            DBComparison privilege = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.PrivilegeID.Name), DBConst.String(privilegeid));
            //    DBComparison user = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.UserID.Name), DBConst.String(userid));
            DBComparison SecurityGroupID = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.SecurityGroupID.Name), DBConst.String(groupid));
            DBComparison Client          = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.ClientID.Name), DBConst.String(clientid));

            select = DBQuery.SelectAll(TzAccount.SecurityGroup.Table).From(TzAccount.SecurityGroup.Table)
                     .WhereAll(privilege, SecurityGroupID, Client);
            return(db.GetDatatable(select));
        }
예제 #10
0
        protected internal DataTable GetComponents()
        {
            DBQuery select = DBQuery.SelectAll().From(TalentozSchema.Table).OrderBy(TalentozSchema.ComponentName.Name, Order.Ascending);

            return(db.GetDatatable(select));
        }