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)); }
/// <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)); }
/// <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)); }
/// <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)); }
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)); }
/// <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)); }
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); }
/// <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)); }
protected internal DataTable GetComponents() { DBQuery select = DBQuery.SelectAll().From(TalentozSchema.Table).OrderBy(TalentozSchema.ComponentName.Name, Order.Ascending); return(db.GetDatatable(select)); }