/***************************************************** * - Function name : searchData * - Description : 查询目标数据 * - Variables : void *****************************************************/ public void searchData() { DataManagerService DMS = new DataManagerService(); DM.setSummary(DMS.set(DM.getDeal_kind())); DM.setRecord(DMS.getRecords(DM.getDeal_kind())); }
public override async Task CreateAsync(AuthenticationTokenCreateContext context) { var clientid = context.Ticket.Properties.Dictionary["as:client_id"]; if (string.IsNullOrEmpty(clientid)) { return; } var refreshTokenId = Guid.NewGuid().ToString("n"); using (DataManagerService _repo = new DataManagerService()) { var client = _repo.FindClient(clientid); var refreshTokenLifeTime = context.OwinContext.Get <string>("as:clientRefreshTokenLifeTime"); var token = new Client_RefreshTokens() { RefreshToken = refreshTokenId, ClientId = client.Id, UserName = context.Ticket.Identity.Name, IssuedUtc = DateTime.UtcNow, ExpiresUtc = DateTime.UtcNow.AddMinutes(Convert.ToDouble(refreshTokenLifeTime)) }; context.Ticket.Properties.IssuedUtc = token.IssuedUtc; context.Ticket.Properties.ExpiresUtc = token.ExpiresUtc; token.ProtectedTicket = context.SerializeTicket(); var result = await _repo.AddRefreshToken(token); if (result) { context.SetToken(refreshTokenId); } } }
public override Task ValidateClientAuthentication(OAuthValidateClientAuthenticationContext context) { string clientId = string.Empty; string clientSecret = string.Empty; RestfullAPI_Clients client = null; if (!context.TryGetBasicCredentials(out clientId, out clientSecret)) { context.TryGetFormCredentials(out clientId, out clientSecret); } if (context.ClientId == null) { //Remove the comments from the below line context.SetError, and invalidate context //if you want to force sending clientId/secrects once obtain access tokens. context.SetError("Invalid_ClientId", "ClientId should be provided!"); return(Task.FromResult <object>(null)); } using (DataManagerService _repo = new DataManagerService()) { client = _repo.FindClient(context.ClientId); } if (client == null) { context.SetError("Invalid_ClientId", string.Format("Client '{0}' is not registered in the system.", context.ClientId)); return(Task.FromResult <object>(null)); } if (client.ApplicationType == (int)AppTypes.AngularApp) { if (string.IsNullOrWhiteSpace(clientSecret)) { context.SetError("invalid_clientId", "Client secret should be sent."); return(Task.FromResult <object>(null)); } else { if (client.Secret != clientSecret) { context.SetError("invalid_clientId", "Client secret is invalid."); return(Task.FromResult <object>(null)); } } } if (!client.Active) { context.SetError("Error", "Provided ClientId is currently inactive."); return(Task.FromResult <object>(null)); } context.OwinContext.Set <string>("as:clientAllowedOrigin", client.AllowedOrigin); context.OwinContext.Set <string>("as:clientRefreshTokenLifeTime", client.RefreshTokenLifeTime.ToString()); context.Validated(); return(Task.FromResult <object>(null)); }
private void Init() { DocumentTypesList = DocumentService.ReadDocumentTypes(); SelectedDocumentType = DocumentTypesList[0]; BrokersList = DataManagerService.TradingInstance().ReadBrokers(); SelectedBroker = BrokersList[0]; CompaniesStorageList = DataManagerService.TradingInstance().GetCompanies(); SelectedCompany = CompaniesStorageList[0]; AuthorsList = DataManagerService.TradingInstance().ReadTraders(); SelectedAuthor = AuthorsList[0]; DocumentDate = DateTime.Now; }
public WebRtcOutgoingDataStream(DataManagerService dataManagerService, File file) { _dataManagerService = dataManagerService; _file = file; _guid = Guid.NewGuid(); _dataParameters = new DataParameters { From = DataFromType.Outgoing, Time = DateTime.Now.ToString("HH:mm"), Object = file }; dataManagerService.DataParametersList.Add(_dataParameters); }
public void UploadDocumentParams(Document document) { this.document = document; DocumentName = document.name; DocumentNumber = document.number; SelectedDocumentType = DocumentTypesList.First(d => d.id == document.type); SelectedBroker = BrokersList.First(b => b.ShortName == document.broker); if (CompaniesStorageList.Count(c => c.name.ToLower().Contains(document.company.ToLower())) > 0) { SelectedCompany = CompaniesStorageList.First(c => c.name.ToLower().Contains(document.company.ToLower())); } SearchCompanyTxt = document.company; SelectedAuthor = AuthorsList.FirstOrDefault(a => a.name == document.author); if (SelectedAuthor == null) { SelectedAuthor = AuthorsList.First(a => a.name.ToLower().Contains("не наз")); } DocumentDate = document.createdDate; DocumentDescription = document.description; if (CurrentPresentation == PresentationEnum.Archive) { DocumentYear = document.year; DocumentCase = document.case_; DocumentVolume = document.volume; DocumentSerialNumber = document.serialNumber == null ? 0 : (int)document.serialNumber; } AttachedDocument = DataManagerService.Instanse().ReadDocumentLink(document.id); if (!string.IsNullOrEmpty(AttachedDocument)) { IsAttach = true; } }
public override async Task ReceiveAsync(AuthenticationTokenReceiveContext context) { var allowedOrigin = context.OwinContext.Get <string>("as:clientAllowedOrigin"); context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { allowedOrigin }); string hashedTokenId = context.Token; using (DataManagerService _repo = new DataManagerService()) { var refreshToken = _repo.FindRefreshToken(hashedTokenId); if (refreshToken != null) { //Get protectedTicket from refreshToken class context.DeserializeTicket(refreshToken.ProtectedTicket); var result = await _repo.RemoveRefreshToken(hashedTokenId); } else { context.Response.StatusCode = 401; context.Response.ReasonPhrase = "Invalid or expired refresh token has been provided."; } } }
/***************************************************** * - Function name : ButtonRefresh2_Click * - Description : 刷新第二个汇总表 * - Variables : object sender, EventArgs e *****************************************************/ protected void ButtonRefresh2_Click(object sender, EventArgs e) { // 查看是否已登录 if (Session["FinanceDepartmentUsername"] == null) { Response.Write("<script>alert('请先登录!');</script>"); return; } // 实例化一个DataManager服务类 DataManagerService DMS = new DataManagerService(); // 查询供应商个数 int N = DMS.getProviders(); // 建立数组缓存供应商编号 string[] pid = new string[N]; // 读取机型编号 int i = 0; string link = string.Format("server={0};User Id={1};password={2};Database={3}", MDB.getServer(), MDB.getUser(), MDB.getPassword(), MDB.getDatabase()); MySqlConnection mycon = new MySqlConnection(link); mycon.Open(); string sql = string.Format("select pr_number from provider_table"); MySqlCommand mycmd = new MySqlCommand(sql, mycon); MySqlDataReader reader = null; reader = mycmd.ExecuteReader(); while (reader.Read()) { pid[i++] = reader[0].ToString(); } reader.Close(); mycon.Close(); // 挨个供应商汇总 for (i = 0; i < N; i++) { int amount = 0; // 数量 double summary = 0; // 总价 int kinds = 0; // 商品种类 int finished = 0; // 已完成订单 int unfinished = 0; // 未完成订单 // 统计数量 amount = DMS.getAmountOf("count(*)", "purchase_detail_table", "where pr_number='" + pid[i] + "'"); // 统计总价 summary = DMS.getAmountOf("sum(p_summary)", "purchase_detail_table", "where pr_number='" + pid[i] + "'"); // 统计已收货数量 kinds = DMS.getAmountOf("count(*)", "purchase_detail_table", "where pur_received='是' and pr_number='" + pid[i] + "'"); // 统计未收货数量 finished = DMS.getAmountOf("count(*)", "purchase_detail_table", "where pur_received='否' and pr_number='" + pid[i] + "'"); // 统计总单数 unfinished = DMS.getAmountOf("count(*)", "purchase_detail_table", "where pr_number='" + pid[i] + "'"); // 查看汇总表是否有相关供应商记录 int hash = 0; hash = DMS.getAmountOf("count(*)", "purchase_summary_provider_table", "where pr_number='" + pid[i] + "'"); // 存回数据库 if (hash == 0) { // 当之前没有该机型信息汇总,插入操作 if (!DMS.saveProviderSummary(pid[i], amount, summary, kinds, unfinished, finished, "insert")) { Response.Write("<script>alert('汇总过程出错[机型:" + pid + "]');</script>"); } } else { // 存在汇总操作时进行更新 if (!DMS.saveProviderSummary(pid[i], amount, summary, kinds, unfinished, finished, "update")) { Response.Write("<script>alert('汇总过程出错[机型:" + pid + "]');</script>"); } } } // 提示完成 Response.Write("<script>alert('汇总完成');</script>"); // 刷新 Label2.Text = "上一次汇总:" + System.DateTime.Now.ToString(); bind(SELECT_PROVIDER_SUMMARY, 2); }
/***************************************************** * - Function name : ButtonRefresh1_Click * - Description : 刷新第一个汇总表 * - Variables : object sender, EventArgs e *****************************************************/ protected void ButtonRefresh1_Click(object sender, EventArgs e) { // 查看是否已登录 if (Session["FinanceDepartmentUsername"] == null) { Response.Write("<script>alert('请先登录!');</script>"); return; } // 实例化一个DataManager服务类 DataManagerService DMS = new DataManagerService(); // 查询机型个数 int N = DMS.getPhoneKinds(); // 建立数组缓存机型编号 string[] pid = new string[N]; // 读取机型编号 int i = 0; string link = string.Format("server={0};User Id={1};password={2};Database={3}", MDB.getServer(), MDB.getUser(), MDB.getPassword(), MDB.getDatabase()); MySqlConnection mycon = new MySqlConnection(link); mycon.Open(); string sql = string.Format("select p_id from phone_table"); MySqlCommand mycmd = new MySqlCommand(sql, mycon); MySqlDataReader reader = null; reader = mycmd.ExecuteReader(); while (reader.Read()) { pid[i++] = reader[0].ToString(); } reader.Close(); mycon.Close(); // 挨个机型汇总 for (i = 0; i < N; i++) { int amount = 0; // 数量 double summary = 0; // 总价 int received = 0; // 已收货 int unreceived = 0; // 未收货 int purAmount = 0; // 总单数 // 统计数量 amount = DMS.getAmountOf("sum(pur_amount)", "purchase_detail_table", ""); // 统计总价 summary = DMS.getAmountOf("sum(p_summary)", "purchase_detail_table", ""); // 统计已收货数量 received = DMS.getAmountOf("count(*)", "purchase_detail_table", "where pur_received='是'"); // 统计未收货数量 unreceived = DMS.getAmountOf("count(*)", "purchase_detail_table", "where pur_received='否'"); // 统计总单数 purAmount = DMS.getAmountOf("count(*)", "purchase_detail_table", "where p_id='" + pid[i] + "'"); // 查看汇总表是否有机型记录 int hash = 0; hash = DMS.getAmountOf("count(*)", "purchase_summary_good_table", "where p_id='" + pid[i] + "'"); // 存回数据库 if (hash == 0) { // 当之前没有该机型信息汇总,插入操作 if (!DMS.saveSummary(pid[i], amount, summary, received, unreceived, purAmount, "insert")) { Response.Write("<script>alert('汇总过程出错[机型:" + pid + "]');</script>"); } } else { // 存在汇总操作时进行更新 if (!DMS.saveSummary(pid[i], amount, summary, received, unreceived, purAmount, "update")) { Response.Write("<script>alert('汇总过程出错[机型:" + pid + "]');</script>"); } } } // 提示完成 Response.Write("<script>alert('汇总完成');</script>"); // 刷新 Label1.Text = "上一次汇总:" + System.DateTime.Now.ToString(); bind(SELECT_GOOD_SUMMARY, 1); }
/***************************************************** * - Function name : ButtonRefresh_Click * - Description : 刷新汇总数据 * - Variables : object sender, EventArgs e *****************************************************/ protected void ButtonRefresh_Click(object sender, EventArgs e) { // 查看是否已登录 if (Session["FinanceDepartmentUsername"] == null) { Response.Write("<script>alert('请先登录!');</script>"); return; } // 实例化一个DataManager服务类 DataManagerService DMS = new DataManagerService(); // 查询售出过的机型个数 int N = DMS.getSaledPhones(); // 建立缓存数组 string[] pid = new string[N]; // 挨个汇总 int i = 0; double sum = 0; for (i = 0; i < N; i++) { int store = 0; // 库存量 int saled = 0; // 售出量 double earned = 0; // 总收入 try { // 统计库存量 store = DMS.getAmountOf("count(*)", "phone_detail_table", "where p_id='" + pid[i] + "' and saled='否'"); // 统计售出量 saled = DMS.getAmountOf("count(*)", "sale_detail_table", "where p_id='" + pid[i] + "'"); // 总收入 earned = DMS.getSaledSummary(pid[i]); sum += earned; // 查看汇总表是否有机型记录 int hash = 0; hash = DMS.getAmountOf("count(*)", "sale_summary_table", "where p_id='" + pid[i] + "'"); // 存回数据库 if (hash == 0) { // 当之前没有该机型信息汇总,插入操作 if (!DMS.saveSaledSummary(pid[i], store, saled, earned, "insert")) { Response.Write("<script>alert('汇总过程出错[机型:" + pid[i] + "]');</script>"); } } else { // 存在汇总操作时进行更新 if (!DMS.saveSaledSummary(pid[i], store, saled, earned, "update")) { Response.Write("<script>alert('汇总过程出错[机型:" + pid[i] + "]');</script>"); } } } catch (Exception ex) { } } // 提示完成 Response.Write("<script>alert('汇总完成');</script>"); // 修改总收入显示 LabelSummary.Text = "总收入:" + sum + "元"; }