/// <summary> /// 网站公告 /// </summary> /// <returns></returns> public ActionResult HelpList(string path1 = "Login_register", int p = 1, int pageSize = 10) { StringBuilder str = new StringBuilder(); string TableName = "V_type_news"; string strFields = "newid,web_Type_menu_id,News_title,News_Key,news_Des,context,createtime,menu_name,path1,topmenuname,listcomm "; string fldName = " newid desc"; string Sort = "desc"; string strWhere = " path1='" + path1 + "'"; DataTable dt = new DataTable(); B_PublicPageList o = new B_PublicPageList(); var RecordCount = 0; dt = o.GetListByPage(TableName, strFields, fldName, pageSize, p, strWhere, out RecordCount); string srtitle = "注册与登录"; if (dt.Rows.Count > 0) { srtitle = dt.Rows[0]["menu_name"].ToString(); } ResponsePage rp = new ResponsePage(); rp.dataBody = dt; rp.pageSize = pageSize; rp.recordCount = RecordCount; rp.pageCount = (RecordCount + pageSize - 1) / pageSize; rp.currentCount = p; ViewBag.srtitle = srtitle; ViewBag.path1 = path1; return(View(rp)); }
/// <summary> /// 网站公告 /// </summary> /// <returns></returns> public ActionResult NoticeList(int p = 1, int pageSize = 10) { StringBuilder str = new StringBuilder(); string TableName = "V_type_news"; string strFields = "newid,web_Type_menu_id,News_title,News_Key,news_Des,context,createtime,menu_name,path1,topmenuname,listcomm "; string fldName = " newid desc"; string Sort = "desc"; string strWhere = "web_Type_menu_id=17"; DataTable dt = new DataTable(); B_PublicPageList o = new B_PublicPageList(); var RecordCount = 0; dt = o.GetListByPage(TableName, strFields, fldName, pageSize, p, strWhere, out RecordCount); ResponsePage rp = new ResponsePage(); rp.dataBody = dt; rp.pageSize = pageSize; rp.recordCount = RecordCount; rp.pageCount = (RecordCount + pageSize - 1) / pageSize; rp.currentCount = p; return(View(rp)); }
public static ResponsePage <List <Client> > Get(int size, int page, string search) { var res = new ResponsePage <List <Client> >(); res.data = new List <Client>(); try { using MySqlConnection connection = new MySqlConnection("server=localhost; Database=expenses; uid=admin; Pwd=database123;"); connection.Open(); MySqlCommand command = connection.CreateCommand(); MySqlTransaction transaction = connection.BeginTransaction(); command.Connection = connection; command.Transaction = transaction; var sql = $"select * from clients where identification like '%{search}%' limit {size} OFFSET {page-1}"; command.CommandText = sql; var dr = command.ExecuteReader(); while (dr.Read()) { if (dr != null) { var client = new Client(); client.id_client = Convert.ToInt32(dr["id_client"]); client.name = Convert.ToString(dr["name"]); client.identification = Convert.ToInt32(dr["identification"]); client.phone = Convert.ToString(dr["phone"]); client.loan = Convert.ToSingle(dr["loan"]); client.time_limit = Convert.ToInt32(dr["time_limit"]); client.interest_rate = Convert.ToSingle(dr["interest_rate"]); client.payment_type = Convert.ToInt16(dr["payment_type"]); client.days_added = Convert.ToInt16(dr["days_added"]); client.created_on = Convert.ToDateTime(dr["created_on"]); res.data.Add(client); } } res.success = true; res.size = size; res.total = Count(search); res.pages = (int)Math.Ceiling((decimal)res.total / (decimal)size); dr.Close(); transaction.Commit(); } catch (Exception ex) { res.errors.Add(ex.Message); res.errors.Add(ex.StackTrace); } return(res); }
private async Task <ResponsePage <ApiKey> > ListGroupApiKeysFunc(QueryOptions options) { try { var resp = await DeveloperApi.GetApiKeysOfGroupAsync(groupID : options.Id, limit : options.Limit, after : options.After, order : options.Order, include : options.Include); var responsePage = new ResponsePage <ApiKey>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData <ApiKeyInfoResp>(resp.Data, ApiKey.Map); return(responsePage); } catch (device_directory.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async System.Threading.Tasks.Task <ResponsePage <QuotaHistory> > ListQuotaHistoryFunc(QueryOptions options) { try { var resp = await api.GetServicePackageQuotaHistoryAsync(limit : options.Limit, after : options.After); var responsePage = new ResponsePage <QuotaHistory>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData <ServicePackageQuotaHistoryItem>(resp.Data, mapper.Map <ServicePackageQuotaHistoryItem, QuotaHistory>); return(responsePage); } catch (billing.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <PreSharedKey> > ListPreSharedKeysFunc(QueryOptions options) { try { var resp = await api.ListPreSharedKeysAsync(limit : options.Limit, after : options.After); var responsePage = new ResponsePage <PreSharedKey>(after: resp.ContinuationMarker, hasMore: resp.HasMore, totalCount: null); responsePage.MapData <connector_bootstrap.Model.PreSharedKeyWithoutSecret>(resp.Data, PreSharedKey.Map); return(responsePage); } catch (connector_bootstrap.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
public static ResponsePage <List <Expense> > Get(int size, int page) { var res = new ResponsePage <List <Expense> >(); res.data = new List <Expense>(); try { using MySqlConnection connection = new MySqlConnection("server=localhost; Database=expenses; uid=admin; Pwd=database123;"); connection.Open(); MySqlCommand command = connection.CreateCommand(); MySqlTransaction transaction = connection.BeginTransaction(); command.Connection = connection; command.Transaction = transaction; var sql = $"select * from expenses.expenses limit {size} OFFSET {page - 1}"; command.CommandText = sql; var dr = command.ExecuteReader(); while (dr.Read()) { if (dr != null) { var expense = new Expense(); expense.id_expense = Convert.ToInt32(dr["id_expense"]); expense.description = Convert.ToString(dr["description"]); expense.value = Convert.ToInt32(dr["value"]); expense.date = Convert.ToDateTime(dr["date"]); res.data.Add(expense); } } res.success = true; res.size = size; res.total = Count(); res.pages = (int)Math.Ceiling((decimal)res.total / (decimal)size); dr.Close(); transaction.Commit(); } catch (Exception ex) { res.errors.Add(ex.Message); res.errors.Add(ex.StackTrace); } return(res); }
private async Task <ResponsePage <ConnectedDevice> > ListConnectedDevicesFunc(QueryOptions options) { try { var resp = await DeviceDirectoryApi.DeviceListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include); var respDevices = new ResponsePage <ConnectedDevice>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); foreach (var device in resp.Data) { respDevices.Add(ConnectedDevice.Map(device, this)); } return(respDevices); } catch (device_directory.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <ApiKey> > ListApiKeysFuncAsync(QueryOptions options = null) { if (options == null) { options = new QueryOptions(); } try { var resp = await DeveloperApi.GetAllApiKeysAsync(limit : options.Limit, after : options.After, order : options.Order, include : options.Include, ownerEq : options.Filter.GetFirstValueByKey("owner_id")); var responsePage = new ResponsePage <ApiKey>(after: resp.After, hasMore: resp.HasMore, resp.TotalCount); responsePage.MapData <ApiKeyInfoResp>(resp.Data, ApiKey.Map); return(responsePage); } catch (iam.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
/// <summary> /// Lists the device logs. /// </summary> /// <returns>The device logs.</returns> /// <exception cref="CloudApiException">CloudApiException</exception> /// <param name="options">Query options.</param> private async Task <ResponsePage <DeviceEvent> > ListDeviceEventsFunc(QueryOptions options = null) { if (options == null) { options = new QueryOptions(); } try { var resp = await Api.DeviceLogListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include); var responsePage = new ResponsePage <DeviceEvent>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData <DeviceEventData>(resp.Data, DeviceEvent.Map); return(responsePage); } catch (device_directory.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <Campaign> > ListCampaignsFunc(QueryOptions options = null) { if (options == null) { options = new QueryOptions(); } try { var resp = await Api.UpdateCampaignListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include); var responsePage = new ResponsePage <Campaign>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData <UpdateCampaign>(resp.Data, Campaign.Map); return(responsePage); } catch (update_service.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <Group> > ListGroupsFunc(QueryOptions options = null) { if (options == null) { options = new QueryOptions(); } try { var resp = await DeveloperApi.GetAllGroupsAsync(limit : options.Limit, after : options.After, order : options.Order, include : options.Include); var responsePage = new ResponsePage <Group>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData(resp.Data, Group.Map); return(responsePage); } catch (device_directory.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <FirmwareManifest> > ListFirmwareManifestsFunc(QueryOptions options = null) { if (options == null) { options = new QueryOptions(); } try { var resp = await Api.FirmwareManifestListAsync(limit : options.Limit, order : options.Order, after : options.After, filter : options.Filter?.FilterString, include : options.Include); var responsePage = new ResponsePage <FirmwareManifest>(resp.After, resp.HasMore, resp.TotalCount); responsePage.MapData <update_service.Model.FirmwareManifest>(resp.Data, FirmwareManifest.Map); return(responsePage); } catch (update_service.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <Metric> > ListMetricsFunc(MetricQueryOptions options) { try { var resp = await StatisticsApi.V3MetricsGetAsync( include : options.Include, interval : options.Interval, start : options.Start, end : options.End, period : options.Period, limit : options.Limit, after : options.After, order : options.Order); var responsePage = new ResponsePage <Metric>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData <statistics.Model.Metric>(resp.Data, Metric.Map); return(responsePage); } catch (statistics.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } }
private async Task <ResponsePage <User> > ListUsersFunc(QueryOptions options = null) { if (options == null) { options = new QueryOptions(); } try { var resp = await adminApi.GetAllUsersAsync(limit : options.Limit, order : options.Order, after : options.After, include : options.Include, statusEq : options.Filter.GetFirstValueByKey("status", FilterOperator.Equals), statusIn : options.Filter.GetFirstValueByKey("status", FilterOperator.In), statusNin : options.Filter.GetFirstValueByKey("status", FilterOperator.NotIn)); var responsePage = new ResponsePage <User>(after: resp.After, hasMore: resp.HasMore, totalCount: resp.TotalCount); responsePage.MapData <UserInfoResp>(resp.Data, User.Map); return(responsePage); } catch (device_directory.Client.ApiException e) { throw new CloudApiException(e.ErrorCode, e.Message, e.ErrorContent); } catch (Exception) { throw; } }
public Home(UserData Userinfo, string uri) { InitializeComponent(); try { User = Userinfo; this.uri = uri; Loaded += Home_Loaded; string NameChip = "Hi, " + User.Firstname + " " + User.Surname; stat = new StatusModel { UserId = User.UserId, Status = "Active" }; connection = new HubConnectionBuilder() .WithUrl(uri + "/updates") .Build(); connection.Closed += async(error) => { await Task.Delay(5000); await ServerConnect(); await signalService.SendStatus(stat); CloseHomeWindow?.Invoke(); }; this.StateChanged += Home_StateChanged; signalService = new ConnService(connection); signalService.StatusReceived += Cos_StatusReceived; signalService.AlertReceived += CasesPage_AlertEvent; Task.Run(async() => { await ServerConnect(); }); persons = new PersonnelInfoViewModel(); schedule = new SchedulePage(); paypage = new PaymentPage(); loadingWindow = new LoadingWindow(); signalService.NewUserSync += async(string id) => { await signalService.ConnectionSync(User.UserId); }; signalService.DisconnectUser += (string obj) => { Task.Run(async() => { await signalService.SendStatus(stat); await signalService.UpdateStatus(stat.Status, stat.UserId); }); }; LoadMap(); HistoryPage.historyItem += (HistoryModel obj) => { MainHolder.Visibility = Visibility.Visible; browser.Visibility = Visibility.Collapsed; Dispatcher.Invoke(() => MainHolder.NavigationService.Navigate(new CaseDetails(obj))); }; this.Closing += MainWindow_Closing; sService = signalService; Respond += (string[] details) => { Dispatcher.Invoke(() => { ResponseView.Visibility = Visibility.Visible; browser.Visibility = Visibility.Collapsed; var rpage = new ResponsePage(User, signalService, details); Response.NavigationService.Navigate(rpage); rpage.BtnClicked += (string obj) => { switch (obj) { case "Close": ResponseView.Visibility = Visibility.Collapsed; browser.Visibility = Visibility.Visible; RestoreButton.Visibility = Visibility.Visible; break; case "restart": CasesModel alert = new CasesModel() { DateTime = Convert.ToDateTime(details[5]), Location = details[2], VHTCode = details[4], Description = details[6], Village = details[3], Status = "ongoing", CaseId = details[0], Category = details[7] }; Dispatcher.Invoke(async() => { await signalService.RestartResponse(details[0]); }); break; case "completed": Dispatcher.Invoke(() => { RadWindow.Confirm("Are you sure you want to mark case as completed?", async delegate { await signalService.CompletedCase(details[0]); RadWindow.Alert("This case has been marked as completed.", MarkCaseCompleted); }); }); break; } }; }); }; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static List <Property> GetPropertys(QueryRequest Query, out ResponsePage Page) { throw new Exception("接口未实现"); }