public void storeUser_Refresh(object sender, StoreReadDataEventArgs e) { DataTable dtU = new DataTable(); DataTable dtS = new DataTable(); AppUserQuery uQ = new AppUserQuery("a"); uQ.es2.Connection.Name = "KENCANA"; ServiceUnitQuery sQ = new ServiceUnitQuery("b"); sQ.es2.Connection.Name = "KENCANA"; dtU = uQ.LoadDataTable(); dtS = sQ.LoadDataTable(); storeUser.DataSource = dtU; storeUser.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["ServiceUnitID"] == null) { return; } } AppUserCollection userColl = new AppUserCollection(); userColl.es.Connection.Name = "KENCANA"; AppUserQuery userQ = new AppUserQuery("a"); userQ.es2.Connection.Name = "KENCANA"; userQ.SelectAll(); userColl.Load(userQ); if (userColl.Count >= 1) { foreach (AppUser au in userColl) { ADefHelpDeskUsersQuery hlpUserQ = new ADefHelpDeskUsersQuery("uQ"); hlpUserQ.es2.Connection.Name = "HELPDESK"; hlpUserQ.SelectAll().Where(hlpUserQ.Username == au.UserID); DataTable dtU = hlpUserQ.LoadDataTable(); if (dtU.Rows.Count == 0) { ADefHelpDeskUsers hlpUser = new ADefHelpDeskUsers(); hlpUser.es.Connection.Name = "HELPDESK"; hlpUser.Username = au.UserID; hlpUser.FirstName = au.UserName; hlpUser.LastName = "."; hlpUser.IsSuperUser = false; hlpUser.Email = au.UserID + "@rscmkencana.com"; hlpUser.Password = au.Password; hlpUser.Save(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!X.IsAjaxRequest) { DataTable dtU = new DataTable(); DataTable dtS = new DataTable(); AppUserQuery uQ = new AppUserQuery("a"); uQ.SelectAll(); uQ.es2.Connection.Name = "KENCANA"; ServiceUnitQuery sQ = new ServiceUnitQuery("b"); sQ.SelectAll(); sQ.es2.Connection.Name = "KENCANA"; dtU = uQ.LoadDataTable(); dtS = sQ.LoadDataTable(); storeServiceUnit.DataSource = dtS; storeServiceUnit.DataBind(); storeUser.DataSource = dtU; storeUser.DataBind(); smGrdServiceUnit.Select(0); smGrdServiceUnit.UpdateSelection(); } }
public async Task <QueryResult <AppUserQueryRow> > QueryAppUser( AppUserQueryFilter filter = null, AppUserQuerySort sort = null, AppUserQueryProjection projection = null, AppUserQueryPaging paging = null, AppUserQueryOptions options = null) { var conn = context.Database.GetDbConnection(); var openConn = conn.OpenAsync(); var query = AppUserQuery.CreateDynamicSql(); #region General if (filter != null) { query = query.SqlFilter(filter); } if (projection != null) { query = query.SqlJoin(projection); } DynamicSql countQuery = null; int?totalCount = null; Task <int> countTask = null; if (options != null && options.count_total) { countQuery = query.SqlCount("*"); } if (projection != null) { query = query.SqlProjectFields(projection); } #endregion await openConn; if (options != null && !options.single_only) { #region List query if (sort != null) { query = query.SqlSort(sort); } if (paging != null && (!options.load_all || !AppUserQueryOptions.IsLoadAllAllowed)) { query = query.SqlSelectPage(paging.page, paging.limit); } #endregion #region Count query if (options.count_total) { countTask = conn.ExecuteScalarAsync <int>( sql: countQuery.PreparedForm, param: countQuery.DynamicParameters); } #endregion } if (projection != null) { query = query.SqlExtras(projection); } var multipleResult = await conn.QueryMultipleAsync( sql : query.PreparedForm, param : query.DynamicParameters); using (multipleResult) { var queryResult = multipleResult.Read( types: query.GetTypesArr(), map: (objs) => ProcessMultiResults(query, objs), splitOn: string.Join(',', query.GetSplitOns())); if (projection != null) { var extraKeys = projection.GetFieldsArr() .Where(f => AppUserQueryProjection.Extras.ContainsKey(f)); IEnumerable <AppUserRoleQueryRow> userRoles = null; foreach (var key in extraKeys) { switch (key) { case AppUserQueryProjection.ROLES: userRoles = GetAppUserRoleQueryResult(multipleResult); break; } } ProcessExtras(queryResult, userRoles); } if (options != null && options.single_only) { var single = queryResult.FirstOrDefault(); if (single == null) { return(null); } return(new QueryResult <AppUserQueryRow> { SingleResult = single }); } if (options != null && options.count_total) { totalCount = await countTask; } return(new QueryResult <AppUserQueryRow> { Results = queryResult, TotalCount = totalCount }); } }