public void Fill(ReportHelper.TableReport report) { var o = (AssayReportViewModel)_r; var cacheKey = string.Format("{0}-{1}", o.ProjectID, o.ReportName); var ds = CacheHelper.AddToCache<DataSet>(() => { return AssayService.ReportAssaysResult(o); }, cacheKey, CacheHelper.DefaultTimeout); report.DataSource = ds; report.Parameters["ParameterProjectID"].Value = o.ProjectID; report.Parameters["ParameterUserName"].Value = o.ReportExecutedByUserName; var tr1 = new XRTableRow { Name = "tr1" }; tr1.Cells.AddRange((from k in ds.Tables[0].Columns.Cast<DataColumn>() select new XRTableCell { Name = k.ColumnName, Text = k.ColumnName }).ToArray()); var h = new XRTable { Name = "h", LocationF = new DevExpress.Utils.PointFloat(0F, 0F), SizeF = new System.Drawing.SizeF(600.0000F, 25F), KeepTogether = true }; h.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { tr1 }); report.Bands["Detail"].Controls.Add(h); var tr2 = new XRTableRow { Name = "tr2" }; tr2.Cells.AddRange((from k in ds.Tables[0].Columns.Cast<DataColumn>() select new XRTableCell { Name = string.Format("{0}_data", k.ColumnName), Text = string.Format("[{0}]",k.ColumnName) }).ToArray()); var t = new XRTable { Name = "t", LocationF = new DevExpress.Utils.PointFloat(0F, 0F), SizeF = new System.Drawing.SizeF(600.0000F, 25F), KeepTogether= true }; t.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { tr2 }); ((DetailReportBand)report.Bands["DetailReport"]).Bands["DetailBand"].Controls.Add(t); }
protected override void OnPreRenderComplete(EventArgs e) { base.OnPreRenderComplete(e); report = new ReportHelper(Fn.ToString(Request["url"])); report.Format = ReportHelper.HTMLFORMAT; report.AddReportParameter("IsHTMLFormat", report.IsHTMLFormat()); for (int i = 0; i < Request.QueryString.Count; i++) { if (Fn.ToString(Request.QueryString.Keys[i]) != "url") { if (Server.UrlDecode(Fn.ToString(Request.QueryString[i])) != "") { if (Fn.ToString(Request.QueryString.Keys[i]).Substring(0, 3) == "INT") { report.AddReportParameter(Fn.ToString(Request.QueryString.Keys[i]).Substring(4), Fn.ToInt(Request.QueryString[i])); } else if (Fn.ToString(Request.QueryString.Keys[i]).Substring(0, 3) == "CHA") { report.AddReportParameter(Fn.ToString(Request.QueryString.Keys[i]).Substring(4), Fn.ToString(Request.QueryString[i])); } else if (Fn.ToString(Request.QueryString.Keys[i]).Substring(0, 3) == "BOL") { report.AddReportParameter(Fn.ToString(Request.QueryString.Keys[i]).Substring(4), Fn.ToBoolean(Request.QueryString[i])); } } } } report.RenderHTML(); }
public AssaysReport(ReportHelper.ITableReportDataFiller filler) : base(filler) { InitializeComponent(); //Name = ReportNames.TableReport; //DisplayName = ReportNames.TableReport; }
protected override void PreGetReport(ReportHelper report) { // report.AddReportParameter("pCurUserId", CurrentUser.UserID.ToString()); base.PreGetReport(report); }
public void Fill(ReportHelper.TableReport report) { var o = (BlockModelCompareViewModel)_r; var cacheKey = o.ToJson().ComputeHash(); report.DataSource = CacheHelper.AddToCache<DataSet>(() => { return BlockModelService.CompareModelsResult(o); }, cacheKey); report.Parameters["ParameterModel1Name"].Value = o.Model1Name; report.Parameters["ParameterModel2Name"].Value = o.Model2Name; report.Parameters["ParameterGradeTonnageFieldName"].Value = o.GradeTonnageFieldName; report.Parameters["ParameterUserName"].Value = o.ReportExecutedByUserName; }
string SendViaAPIUploadOneReport(WebClient client, string filename, string xml) { byte[] answer = null; Version version = Assembly.GetExecutingAssembly().GetName().Version; client.Headers.Add(HttpRequestHeader.ContentType, "application/json"); client.Headers.Add(HttpRequestHeader.UserAgent, "PingCastle " + version.ToString(4)); try { Trace.WriteLine("using filename:" + filename); var request = "{\"xmlReport\": \"" + ReportHelper.EscapeJsonString(xml) + "\",\"filename\":\"" + ReportHelper.EscapeJsonString(filename) + "\"}"; byte[] data = Encoding.ASCII.GetBytes(request); answer = client.UploadData(apiEndpoint + "api/Agent/SendReport", "POST", data); var o = Encoding.Default.GetString(answer); Trace.WriteLine("answer:" + o); return(o); } catch (WebException ex) { Trace.WriteLine("Status: " + ex.Status); Trace.WriteLine("Message: " + ex.Message); if (ex.Response != null) { var responseStream = ex.Response.GetResponseStream(); if (responseStream != null) { using (var reader = new StreamReader(responseStream)) { string responseText = reader.ReadToEnd(); if (string.IsNullOrEmpty(responseText)) { responseText = ex.Message; } throw new PingCastleException(responseText); } } } else { Trace.WriteLine("WebException response null"); } throw; } }
/// <summary> /// Report loaded method that is triggered when report and sub report begins to be loaded. /// </summary> /// <param name="reportOptions">The ReportViewer options.</param> public void OnReportLoaded(ReportViewerOptions reportOptions) { // User Parameters if (HttpContext.Current.Items.Contains("userParameters")) { reportOptions.ReportModel.Parameters = new JavaScriptSerializer().Deserialize <List <global::Syncfusion.Reports.EJ.ReportParameter> >(HttpContext.Current.Items["userParameters"].ToString()); HttpContext.Current.Items.Remove("userParameters"); } // DataSet(s) reportOptions.ReportModel.DataSources.Clear(); ReportDefinition reportDefinition = DeSerializeReport(reportOptions.ReportModel.ReportPath); ReportParameters reportParameters = reportDefinition.ReportParameters; IList <string> dataSetNames = ReportHelper.GetDataSetNames(); foreach (var dataSetName in dataSetNames) { var dataSet = reportDefinition.DataSets.Where(x => x.Name == dataSetName); var connectionName = MultiTenantHelper.GetConnectionName(dataSet.First().Query.DataSourceName); var sql = dataSet.First().Query.CommandText; DbConnection connection = null; try { DbProviderFactory provider; provider = AdoNetHelper.GetProvider(connectionName); connection = provider.CreateConnection(); connection.ConnectionString = AdoNetHelper.GetConnectionString(connectionName); connection.Open(); DbCommand command; DbDataReader reader; command = provider.CreateCommand(); command.Connection = connection; command.CommandTimeout = 600; command.CommandType = System.Data.CommandType.Text; command.CommandText = sql; command.Parameters.Clear(); if (reportOptions.ReportModel.Parameters != null && reportOptions.ReportModel.Parameters.Count() > 0) { int index = 0; foreach (var userParameter in reportOptions.ReportModel.Parameters) { DbParameter parameter = command.CreateParameter(); parameter.DbType = GetDbType(reportParameters[index].DataType); parameter.ParameterName = "@" + userParameter.Name; parameter.Value = userParameter.Values.First(); command.Parameters.Add(parameter); //command.AddParameterWithValue("@" + userParameter.Name, userParameter.Values.First()); // DbType.String index++; } } else { foreach (var reportParameter in reportParameters) { var defaultValue = reportParameter.DefaultValue == null ? null : reportParameter.DefaultValue.Values.First(); DbParameter parameter = command.CreateParameter(); parameter.DbType = GetDbType(reportParameter.DataType); parameter.ParameterName = "@" + reportParameter.Name; if (defaultValue == null) { parameter.Value = DBNull.Value; } else { parameter.Value = defaultValue; } command.Parameters.Add(parameter); //command.AddParameterWithValue("@" + reportParameter.Name, defaultValue); } } reader = command.ExecuteReader(IsolationLevel.ReadUncommitted); DataTable table = new DataTable(); table.Load(reader); // System.Data.EnumerableRowCollection<System.Data.DataRow> // https://msdn.microsoft.com/en-us/library/system.data.enumerablerowcollection%28v=vs.110%29.aspx // System.Data.DataRow // https://msdn.microsoft.com/en-us/library/system.data.datarow%28v=vs.110%29.aspx reportOptions.ReportModel.DataSources.Add(new ReportDataSource { Name = dataSetName, Value = table.AsEnumerable() }); } catch // (Exception exception) { } finally { if (connection != null) { connection.Close(); } } } }
private void BurndownConfig(ReportHelper.ReportConfig config, ScrumFactory.Project project) { var leftHoursByDay = backlogService.GetBurndownHoursByDay(project.ProjectUId, project.CurrentPlanningNumber.ToString()); if (leftHoursByDay == null) return; var burndownVM = new BurnDownViewModel(); burndownVM.ActualHours = leftHoursByDay.Where(h => h.LeftHoursMetric == LeftHoursMetrics.LEFT_HOURS).ToArray(); burndownVM.ActualHoursAhead = leftHoursByDay.Where(h => h.LeftHoursMetric == LeftHoursMetrics.LEFT_HOURS_AHEAD).ToArray(); burndownVM.PlannedHours = leftHoursByDay.Where(h => h.LeftHoursMetric == LeftHoursMetrics.PLANNING).ToArray(); config.ReportViewModels.Add("burndown", burndownVM); }
public object PostReportAction([FromBody] Dictionary <string, object> jsonResult) { HttpContext.Request.Headers.TryGetValue("Authorization", out authenticationHeader); //Perform your custom validation here if (authenticationHeader == "") { return(new Exception("Authentication failed!!!")); } if (jsonResult.ContainsKey("parameters")) { dynamic retorno = JsonConvert.DeserializeObject(jsonResult["parameters"].ToString()); foreach (var item in retorno) { //if (item.ibge != null) // report.ibge = item.ibge; if (item.unidade != null) { report.unidade = item.unidade; } if (item.nom_unidade != null) { report.nom_unidade = item.nom_unidade; } if (item.count_unidades != null) { report.count_unidades = item.count_unidades; } if (item.profissional != null) { report.profissional = item.profissional; } if (item.count_profissional != null) { report.count_profissional = item.count_profissional; } if (item.nom_profissional != null) { report.nom_profissional = item.nom_profissional; } if (item.produto != null) { report.produto = item.produto; } if (item.count_produto != null) { report.count_produto = item.count_produto; } if (item.nom_produto != null) { report.nom_produto = item.nom_produto; } if (item.datainicio != null) { report.datainicio = item.datainicio; } if (item.datafim != null) { report.datafim = item.datafim; } if (item.id_paciente != null) { report.id_paciente = item.id_paciente; } if (item.nome_paciente != null) { report.nome_paciente = item.nome_paciente; } if (item.gp_atendimento != null) { report.gp_atendimento = item.gp_atendimento; } if (item.agrupamento != null) { report.agrupamento = item.agrupamento; } if (item.unidadelogadaParam != null) { report.unidadelogadaParam = item.unidadelogadaParam; } if (item.usuarioParam != null) { report.usuarioParam = item.usuarioParam; } } } return(ReportHelper.ProcessReport(jsonResult, this, this._cache)); }
protected override ResultStatus Print(ReportHelper reportHelper) { base.Print(reportHelper); return(ResultStatus.Success); }
public object PostReportAction(Dictionary <string, object> jsonResult) { return(ReportHelper.ProcessReport(jsonResult, this as IReportController)); }
protected void Page_Load(object sender, EventArgs e) { string foldername = Server.MapPath("~/CS_REPORT/rpt/Disc-Per-Channel.rpt"); _User Ousr = new _User(Session["username"].ToString()); ReportDocument ReportDoc = new ReportDocument(); ReportDoc.Load(foldername); ReportDoc.SetDatabaseLogon("sa", "p@ssw0rd"); ParameterFields PFIELDS = ReportDoc.ParameterFields; ParameterDiscreteValue[] param_values = new ParameterDiscreteValue[] { }; ParameterDiscreteValue region_default_val = new ParameterDiscreteValue(); region_default_val.Value = "C"; ParameterDiscreteValue channel_default_val = new ParameterDiscreteValue(); channel_default_val.Value = "All"; ParameterDiscreteValue brand_default_val = new ParameterDiscreteValue(); brand_default_val.Value = "All"; PFIELDS["Region"].CurrentValues.Clear(); PFIELDS["Channel"].CurrentValues.Clear(); PFIELDS["Brand"].CurrentValues.Clear(); ReportHelper.GetRegions(Session["username"].ToString(), "Region", ref PFIELDS, ref param_values); foreach (ParameterDiscreteValue pd in PFIELDS["Region"].CurrentValues) { if (pd.Value.ToString() == "LUZON") { pd.Value = "CL"; } if (pd.Value.ToString() == "VISMIN") { pd.Value = "CV"; } } ReportHelper.GetChannels(Session["username"].ToString(), "Channel", ref PFIELDS, ref param_values); ReportHelper.GetAreas(Session["username"].ToString(), "Area", ref PFIELDS, ref param_values); ReportHelper.GetBrands(Session["username"].ToString(), "Brand", ref PFIELDS, ref param_values); bool has_region = false, has_channel = false, has_brand = false; foreach (ParameterField pd in PFIELDS) { bool has_val = pd.CurrentValues.Count > 0 ? true : false; if (has_val) { switch (pd.Name.ToUpper()) { case "REGION": has_region = true; break; case "CHANNEL": has_channel = true; break; case "BRAND": has_brand = true; break; } } } if (!has_region) { ReportDoc.ParameterFields["Region"].CurrentValues.Add(region_default_val); } if (!has_channel) { ReportDoc.ParameterFields["Channel"].CurrentValues.Add(channel_default_val); } if (!has_brand) { ReportDoc.ParameterFields["Brand"].CurrentValues.Add(brand_default_val); } CrystalReportViewer1.ReportSource = ReportDoc; }
public async Task <HttpResponseMessage> Export(HttpRequestMessage request, int month, int year, int districtId, int functionId, int poId, string userId) { #region Config Export file string fileName = string.Concat("TKBD_" + DateTime.Now.ToString("yyyyMMddhhmmsss") + ".xlsx"); var folderReport = ConfigHelper.GetByKey("ReportFolder"); string filePath = HttpContext.Current.Server.MapPath(folderReport); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } string fullPath = Path.Combine(filePath, fileName); #endregion Config Export file Export_Info_Template vm = new Export_Info_Template(); try { #region customFill Test District district = new District(); PO po = new PO(); ApplicationUser user = new ApplicationUser(); vm.Month = month; vm.Year = year; vm.CreatedBy = User.Identity.Name; //check param đầu vào #region data input if (districtId != 0) { district = _districtService.GetById(districtId); vm.District = district.Name; } if (poId != 0) { po = _poService.GetByID(poId); vm.Unit = po.Name; } if (!string.IsNullOrEmpty(userId)) { user = _userService.getByUserId(userId); vm.user = user.FullName; } vm.Service = "Tiết kiệm bưu điện"; #endregion data input string currentUser = User.Identity.Name; switch (functionId) { #region case 1 Thống kê tổng hợp giao dịch phát sinh case 1: vm.FunctionName = "Thống kê tổng hợp giao dịch phát sinh"; var responseTKBD = _tkbdService.Export_TKBD_By_Condition(month, year, districtId, poId, currentUser, userId); var dataSource = Mapper.Map <IEnumerable <TKBD_Export_Template>, IEnumerable <TKBD_Export_Template_ViewModel> >(responseTKBD); foreach (var item in dataSource) { var fullName = _userService.getByUserName(item.CreatedBy).FullName; if (fullName != null) { item.FullName = fullName; } } await ReportHelper.TKBD_Export_General(dataSource.ToList(), fullPath, vm); break; #endregion case 1 Thống kê tổng hợp giao dịch phát sinh #region case 2 Thống kê chi tiết giao dịch phát sinh case 2: vm.FunctionName = "Thống kê chi tiết giao dịch phát sinh"; var responseTKBD_Detail = _tkbdService.Export_TKBD_Detail_By_Condition(month, year, districtId, poId, currentUser, userId); //var c = responseTKBD_Detail.Count(); //var result = responseTKBD_Detail.ToList(); var dataSource_Detail = Mapper.Map <IEnumerable <TKBD_Export_Detail_Template>, IEnumerable <TKBD_Export_Detail_Template_ViewModel> >(responseTKBD_Detail); foreach (var item in dataSource_Detail) { var fullName = _userService.getByUserName(item.CreatedBy).FullName; item.FullName = fullName; } await ReportHelper.TKBD_Export_Detail(dataSource_Detail.ToList(), fullPath, vm); break; #endregion case 2 Thống kê chi tiết giao dịch phát sinh default: vm.FunctionName = "Chức năng khác"; break; } #endregion customFill Test return(request.CreateErrorResponse(HttpStatusCode.OK, Path.Combine(folderReport, fileName))); } catch (Exception ex) { return(request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
// return JWT token void SendViaAPIGetJwtToken(WebClient client) { ServicePointManager.Expect100Continue = false; client.UseDefaultCredentials = true; client.Proxy = WebRequest.DefaultWebProxy; if (client.Proxy == null) { Trace.WriteLine("No proxy"); } else { Trace.WriteLine("with proxy"); } Version version = Assembly.GetExecutingAssembly().GetName().Version; client.Headers.Add(HttpRequestHeader.ContentType, "application/json"); client.Headers.Add(HttpRequestHeader.UserAgent, "PingCastle " + version.ToString(4)); //client.Headers.Add("Authorization", token); string token; byte[] answer = null; try { string location = Dns.GetHostEntry(Environment.MachineName).HostName; Trace.WriteLine("location: " + location); Trace.WriteLine("apikey: " + apiKey); byte[] data = Encoding.Default.GetBytes("{\"apikey\": \"" + ReportHelper.EscapeJsonString(apiKey) + "\",\"location\": \"" + ReportHelper.EscapeJsonString(location) + "\"}"); answer = client.UploadData(apiEndpoint + "api/Agent/Login", "POST", data); token = Encoding.Default.GetString(answer); Trace.WriteLine("token: " + token); client.Headers.Add(HttpRequestHeader.Authorization, token); } catch (WebException ex) { if (ex.Response != null) { var responseStream = ex.Response.GetResponseStream(); if (responseStream != null) { using (var reader = new StreamReader(responseStream)) { string responseText = reader.ReadToEnd(); throw new UnauthorizedAccessException(responseText); } } } throw new UnauthorizedAccessException(ex.Message); } }
//Post action for processing the rdl/rdlc report public object PostReportAction(Dictionary <string, object> jsonResult) { jsonArray = jsonResult; return(ReportHelper.ProcessReport(jsonResult, this)); }
public async Task <ActionResult> BasicSurveyReport(BasicSurveyReportViewModel paramModel, string curPage) { ViewBag.LeftMenu = Global.Report; //사업년도 DownDown List Data //ViewBag.SelectBizWorkYearList = ReportHelper.MakeYear(2015); var bizWorkYearDropDown = ReportHelper.MakeYear(2015); SelectList bizWorkYear = new SelectList(bizWorkYearDropDown, "Value", "Text"); ViewBag.SelectBizWorkYearList = bizWorkYear; var mentorId = Session[Global.LoginID].ToString(); if (string.IsNullOrEmpty(paramModel.Status)) { paramModel.Status = ""; } //사업 DropDown List Data var listScMentorMapping = await scMentorMappingService.GetMentorMappingListByMentorId(mentorId, paramModel.BizWorkYear); var listScBizWork = listScMentorMapping.Select(mmp => mmp.ScBizWork).ToList(); ViewBag.SelectBizWorkList = ReportHelper.MakeBizWorkList(listScBizWork); var listScCompMapping = await scCompMappingService.GetCompMappingListByMentorId(mentorId, "A", paramModel.BizWorkSn, paramModel.BizWorkYear); var listScCompInfo = listScCompMapping.Select(cmp => cmp.ScCompInfo).ToList(); ViewBag.SelectCompInfoList = ReportHelper.MakeCompanyList(listScCompInfo); ViewBag.SelectStatusList = ReportHelper.MakeReportStatusList(); var scCompMapping = await scCompMappingService.GetCompMappingAsync(paramModel.BizWorkSn, paramModel.CompSn); //scCompMapping.ScCompInfo. //var statusForCom = await sc //기초역량 보고서 조회 int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); //// 문진표 작성 완료 후 count //var countTest = await _quesMasterService.GetQuesMasterAsync(paramModel.QuestionSn); var rptMsters = await rptMasterService.GetRptMasterList(int.Parse(curPage ?? "1"), pagingSize, mentorId, paramModel.BizWorkYear, paramModel.BizWorkSn, paramModel.CompSn, paramModel.Status); //var rptMaters2 = scCompMapping.ScCompInfo.RptMasters.Where(rm => rm.BasicYear == paramModel.BizWorkYear && rm.BizWorkSn == paramModel.BizWorkSn && rm.CompSn == paramModel.CompSn).SingleOrDefault(); // QuesMaster -> stauts ="C"인 애들만 mapping var quesMaster = await _quesMasterService.GetQuesMasterAsync(paramModel.RegistrationNo, paramModel.BizWorkYear); var quesMasterP = await _quesMasterService.GetQuesMasterAsyncPro(paramModel.RegistrationNo, paramModel.BizWorkYear); //paramModel.CompleteCount = 0; //paramModel.NotYetCountForMentor = 0; //paramModel.TotalCountForMentor = 0; // 추가적으로 for 문 돌리거나 그냥 viewModel에 direct로 박아주는 방법 //if(quesMaster.Status == "C") //{ // paramModel.CompleteCount++; //} //else //{ // paramModel.NotYetCountForMentor++; //} // 전체 기업 수 count //var a = quesMaster.Status; //var b = quesMaster.QuesCompInfo; //paramModel.Status = quesMaster.Status; paramModel.TotalCountForMentor = listScCompMapping.Count; // var a = rptMsters.Subset; //뷰모델 맵핑 var rptMasterListView = Mapper.Map <List <BasicSurveyReportViewModel> >(rptMsters); return(View(new StaticPagedList <BasicSurveyReportViewModel>(rptMasterListView, int.Parse(curPage ?? "1"), pagingSize, rptMsters.TotalItemCount))); }
public CreditTransactionPrintedDocumentTemplate(CreditTransaction transaction, byte[] templateFile) { TemplateFile = templateFile; _labelValues = new Dictionary <string, string>(); _labelValues.Add("банк_кредитор", transaction.Creditor.Name); _labelValues.Add("пропись_итого_комиссия", MoneyToText.Convert(((transaction.CreditSumm - (transaction.RealPrice - transaction.DownPaymentCashbox)) - transaction.ReportInsurance - transaction.Rollback + transaction.CommissionCashbox))); _labelValues.Add("итого_комиссия", ((transaction.CreditSumm - (transaction.RealPrice - transaction.DownPaymentCashbox)) - transaction.ReportInsurance - transaction.Rollback + transaction.CommissionCashbox).ToString()); _labelValues.Add("остаток_в_сумме", (transaction.CreditSumm - (transaction.RealPrice - transaction.DownPaymentCashbox)).ToString()); _labelValues.Add("пропись_остаток_в_сумме", MoneyToText.Convert(transaction.CreditSumm - (transaction.RealPrice - transaction.DownPaymentCashbox))); _labelValues.Add("к_выдаче_продавцу", (transaction.RealPrice - transaction.DownPaymentCashbox).ToString()); _labelValues.Add("пропись_к_выдаче_продавцу", MoneyToText.Convert(transaction.RealPrice - transaction.DownPaymentCashbox)); _labelValues.Add("пропись_комиссия_касса", MoneyToText.Convert(transaction.CommissionCashbox)); _labelValues.Add("пропись_сумма_кредит", MoneyToText.Convert(transaction.CreditSumm)); _labelValues.Add("пропись_первый_взнос", MoneyToText.Convert(transaction.DownPayment)); _labelValues.Add("пропись_стоимость_банк", MoneyToText.Convert(transaction.PriceBank)); _labelValues.Add("реквизит", transaction.Requisit.Name); _labelValues.Add("бик_реквизит", transaction.Requisit.Bik); _labelValues.Add("рс_реквизит", transaction.Requisit.Ros_schet); _labelValues.Add("кс_реквизит", transaction.Requisit.Kor_schet); _labelValues.Add("в_банке_реквизит", transaction.Requisit.InBank); _labelValues.Add("месяц_доверенность", transaction.DateProxy?.Month.ToString()); _labelValues.Add("месяц_ад", transaction.DateProxy?.Month.ToString()); _labelValues.Add("месяц", transaction.Date.Month.ToString()); _labelValues.Add("имя_мен", transaction.User.FirstName); _labelValues.Add("фамилия_мен", transaction.User.LastName); _labelValues.Add("отчество_мен", transaction.User.MiddleName); _labelValues.Add("имя_р__мен", transaction.User.FirstNameGenitive); _labelValues.Add("фамилия_р_мен", transaction.User.LastNameGenitive); _labelValues.Add("отчество_р__мен", transaction.User.MiddleNameGenitive); _labelValues.Add("номер_мен", transaction.User.Number); _labelValues.Add("дата_мен", transaction.User.Date.ToString("dd.MM.yyyy")); _labelValues.Add("номер", transaction.Number.ToString()); _labelValues.Add("дата_да", transaction.DateAgent?.ToString("dd.MM.yyyy")); _labelValues.Add("дата", transaction.Date.ToString("dd.MM.yyyy")); _labelValues.Add("дата_доверенность", transaction.DateProxy?.ToString("dd.MM.yyyy")); _labelValues.Add("номер_доверенность", transaction.NumberProxy); _labelValues.Add("номер_реестр", transaction.NumberRegistry); _labelValues.Add("стоимость", transaction.Price.ToString()); _labelValues.Add("пропись", MoneyToText.Convert(transaction.Price)); _labelValues.Add("стоимость_банк", transaction.PriceBank.ToString()); _labelValues.Add("первый_взнос", transaction.DownPayment.ToString()); _labelValues.Add("сумма_кредит", transaction.CreditSumm.ToString()); _labelValues.Add("стоимость_реальная", transaction.RealPrice.ToString()); _labelValues.Add("первый_взнос_касса", transaction.DownPaymentCashbox.ToString()); _labelValues.Add("отчёт_по_страховым", transaction.ReportInsurance.ToString()); _labelValues.Add("откат", transaction.Rollback.ToString()); _labelValues.Add("источник", transaction.Source); _labelValues.Add("комиссия_Касса", transaction.CommissionCashbox.ToString()); if (transaction.Seller != null) { _labelValues.Add("п_фио", ReportHelper.GetFullName(transaction.Seller)); _labelValues.Add("п_фио_сокр", ReportHelper.GetShortName(transaction.Seller)); _labelValues.Add("п_контрагент_и", ReportHelper.GetContractorName(transaction.Seller)); _labelValues.Add("п_контрагент_р", ReportHelper.GetContractorNameGenitive(transaction.Seller)); _labelValues.Add("п_подпись", ReportHelper.GetContractorSignature(transaction.Seller)); } else { _labelValues.Add("п_фио", null); _labelValues.Add("п_фио_сокр", null); _labelValues.Add("п_контрагент_и", null); _labelValues.Add("п_контрагент_р", null); _labelValues.Add("п_подпись", null); } if (transaction.Buyer != null) { _labelValues.Add("по_фио", ReportHelper.GetFullName(transaction.Buyer)); _labelValues.Add("по_фио_сокр", ReportHelper.GetShortName(transaction.Buyer)); _labelValues.Add("по_контрагент_и", ReportHelper.GetContractorName(transaction.Buyer)); _labelValues.Add("по_контрагент_р", ReportHelper.GetContractorNameGenitive(transaction.Buyer)); _labelValues.Add("по_подпись", ReportHelper.GetContractorSignature(transaction.Buyer)); } else { _labelValues.Add("по_фио", null); _labelValues.Add("по_фио_сокр", null); _labelValues.Add("по_контрагент_и", null); _labelValues.Add("по_контрагент_р", null); _labelValues.Add("по_подпись", null); } if (transaction.Owner != null) { _labelValues.Add("соб_фио", ReportHelper.GetFullName(transaction.Owner)); _labelValues.Add("соб_фио_сокр", ReportHelper.GetShortName(transaction.Owner)); _labelValues.Add("соб_контрагент_и", ReportHelper.GetContractorName(transaction.Owner)); _labelValues.Add("соб_контрагент_р", ReportHelper.GetContractorNameGenitive(transaction.Owner)); _labelValues.Add("соб_подпись", ReportHelper.GetContractorSignature(transaction.Owner)); } else { _labelValues.Add("соб_фио", null); _labelValues.Add("соб_фио_сокр", null); _labelValues.Add("соб_контрагент_и", null); _labelValues.Add("соб_контрагент_р", null); _labelValues.Add("соб_подпись", null); } _labelValues.Add("вид_тс", transaction.Trancport.Type.Name); _labelValues.Add("год_тс", transaction.Trancport.Year.ToString()); _labelValues.Add("вин", transaction.Trancport.Vin); _labelValues.Add("гос_номер_тс", transaction.Trancport.Number); _labelValues.Add("дата_птс", transaction.Trancport.DatePts?.ToString("dd.MM.yyyy")); _labelValues.Add("дата_cтс", transaction.Trancport.DateSts?.ToString("dd.MM.yyyy")); _labelValues.Add("изготовитель_тс", transaction.Trancport.Maker); _labelValues.Add("категория_тc", transaction.Trancport.Category.Name); _labelValues.Add("кем_птс", transaction.Trancport.ByPts); _labelValues.Add("кем_стс", transaction.Trancport.BySts); _labelValues.Add("кузов", transaction.Trancport.BodyNumber); _labelValues.Add("макс_масса", transaction.Trancport.MaxMass); _labelValues.Add("марка_двиг", transaction.Trancport.EngineMake); _labelValues.Add("марка_тс", transaction.Trancport.Make.Name); _labelValues.Add("модель_тс", transaction.Trancport.Model.Name); _labelValues.Add("масса", transaction.Trancport.Mass); _labelValues.Add("мощность", transaction.Trancport.Strong); _labelValues.Add("номер_птс", transaction.Trancport.NumberPts); _labelValues.Add("номер_стс", transaction.Trancport.NumberSts); _labelValues.Add("объем", transaction.Trancport.Volume); _labelValues.Add("па", transaction.Trancport.Pa); _labelValues.Add("серия_птс", transaction.Trancport.SerialPts); _labelValues.Add("серия_стс", transaction.Trancport.SerialSts); _labelValues.Add("типы_двигателей_тс", transaction.Trancport.EngineType.Name); _labelValues.Add("цвет", transaction.Trancport.Color); _labelValues.Add("шасси", transaction.Trancport.ChassisNumber); }
/// <summary> Gets the given request. </summary> /// <param name="request"> The request. </param> /// <returns> A Task<object> </returns> public object Get(GetReportDownload request) { if (string.IsNullOrEmpty(request.IncludeItemTypes)) { return(null); } request.DisplayType = "Export"; ReportViewType reportViewType = ReportHelper.GetReportViewType(request.ReportView); var headers = new Dictionary <string, string>(); string fileExtension = "csv"; string contentType = "text/plain;charset='utf-8'"; switch (request.ExportType) { case ReportExportType.CSV: break; case ReportExportType.Excel: contentType = "application/vnd.ms-excel"; fileExtension = "xls"; break; } var filename = "ReportExport." + fileExtension; headers["Content-Disposition"] = string.Format("attachment; filename=\"{0}\"", filename); headers["Content-Encoding"] = "UTF-8"; var user = !string.IsNullOrWhiteSpace(request.UserId) ? _userManager.GetUserById(request.UserId) : null; ReportResult result = null; switch (reportViewType) { case ReportViewType.ReportData: ReportIncludeItemTypes reportRowType = ReportHelper.GetRowType(request.IncludeItemTypes); ReportBuilder dataBuilder = new ReportBuilder(_libraryManager); QueryResult <BaseItem> queryResult = GetQueryResult(request, user); result = dataBuilder.GetResult(queryResult.Items, request); result.TotalRecordCount = queryResult.TotalRecordCount; break; case ReportViewType.ReportActivities: result = GetReportActivities(request); break; } string returnResult = string.Empty; switch (request.ExportType) { case ReportExportType.CSV: returnResult = new ReportExport().ExportToCsv(result); break; case ReportExportType.Excel: returnResult = new ReportExport().ExportToExcel(result); break; } return(_resultFactory.GetResult(returnResult, contentType, headers)); }
private void MenuFlyoutItem_Click(object sender, RoutedEventArgs e) { ReportHelper.ReportAttentionAsync(GetUIString("StillInDeveloping")); }
private void ReportWhenGoesWrong(string UIString) { ReportHelper.ReportAttentionAsync(GetUIString(UIString)); }
public MainWindow() { ServiceData.Init(@"Data/Service.xlsx"); Release.Init(Assembly.GetExecutingAssembly().GetName().Version); _windowSplash = new WindowSplash(); _windowSplash.Show(); Opc.UaFx.Client.Licenser.LicenseKey = "AALOERR5OO7EKFNQCABINGCH6TYOVHPLFC2QCUYAV3IYL7FGRNBJ4TYJX2GM6HKSCKZLBJWGHUWWXQ5HKWI7OFVYYMERDPQDC7ZW7ZTLPTM" + "LWLMY3RMLD2UQ6OXKUKC2YBBPBRGK6SBRI4DBXF4NGVKZUATMW3VI7EALG5FQNCETII7JG7OTOCL2EPO55TO5D4GPJROX5FHSUSALQX56E6" + "NCBRCDX35VJBWLQDD4QANXIWUKO7D3Q7SWDDL55ZZCSN7NLHKB3W5O524VIXFPLVJIYKM5U4OPRXPQ2IM5HNR5GRY4ZODEIIKTRJS2N2MBD" + "LYUUDDNUH5Y7X2MERUMPKZZHP3WWLGR2XUCXTZTA6MWSB6KXNJ3DMIA6ZU54UQVFC3FGTOU5YP2CHBVZOFZDZTDD2OX3XD5ZMPQTS4DU7C5" + "44BBNUXMNCNQ52DQSVBF3YYGVTPHHD7LMGCLZQA2EYXQBMNUIHQT3RZPFXRNUA3VKSXBN4WRK2QCN2MPWQL4RBNK7KEJVM2GK7QEOMX7FAN" + "SQGOIYLIQQCXGJB27SZEL6ZF4C4T6EUFOPKW7NSMEQWBAMCO2BSCP2YD4P4O3KHTUB7HXIFKUJNI5AVEM2YTDTLACIIOKI3BM7HXYJZBTHF" + "ME2O7ONQLRMFIQQF72YOWHVCRLLWGZOJUTWDWDPN532SOOV2AW2X4SFCVZHJGCG7OR5RYFI46NAA7Y3W52CHSMJKNGQEE7IDJPS76QFCOWE" + "TDJ6M2LXC4YMOO3CZYEZ6NVHWZQX2GJKU4CIYII5DTMAPACKWASLFUIHBMA47DBZYV5VBRUL6K7IGDTTZANTSFR4I2FGTFLVAXJOUR2WVEM" + "6L6AS6V5M3MU2KCRLLJGJ2QYOGYYCO4KYRVMRVK2324DAFHVMQJBC6YKDDSLPFHJLI6IHVNLHKMWWYFQC2O3KZTANJYC37J7DEV7XBBZIHY" + "7VBGTEKBW73KBCKZ3CQJDUW267N4QRJKSE4Z5YEYJDVESXC2JBHWPYXZV2VOU64D55EFWPQBN4KSZM3PLPELUQDLAE6LMCUC2QFODQI3E4D" + "Q7FI2GKTHYAO2KKWNI2STU7ABZ3VROFRTYOOEOLVI7FH2ZL35SDTWD2FPFWCR4SDXIRRFVXOGZJLF6KEUHOYGBRQR3CYA62YF4K2HYX46TX" + "ZQ3KUPWZTOBY3M7ZUJQFQ2KTXXIB75LVC7EHAZ2AF3OELXR2YP2AVTIGKBEPXAJIFQLB6CKHQQEHHSSPWO3HQHTYVZYGMVM4KUTDRHHSGUA"; Stimulsoft.Base.StiLicense.Key = "6vJhGtLLLz2GNviWmUTrhSqnOItdDwjBylQzQcAOiHlo0BLi03H5eu1wfyYtghdwJHRIUDASSNqz5wYiN/0REuF5rx" + "l0PuYej+g+9PW3zj9rf4q2Hr3Rp+4siFan2+bLDIWecyw4cso2kClUxmGiOPMf8e9yf/4LU06O2KwITH9htGzZ5H8f" + "WkYXqiSRovW8fvjzPHMKsHri+ywu+vv1sGfAwA0zzPsF2OEmeNC34NoNvq0aHta9JYfhfq9bkKZym8x02csbJJuI2R" + "c3V1rG5B/jATAQfCMOVMRttnnmQ6VnSEiSRStLhvBtVE0bC1kq4Z4RNpUVrGVcBn6w41aSyD8uOc78dBIu7a3ykZ45" + "1A/Q3ww3T1GtnmfAkGLK2b/srd675k7fpZrVlyiLH7BfEyo+hrBj51dYG0IaJqzseeuSh7GFjJZCihujJNgugyR4Id" + "N4KjrZg2sAuO4JeNlvzZvyQ7wNzu92lFHGoZGLnnKIAUQUk8FECgamOxYIYzP4UzLturdpFL6MBW6c9E0SdRy+Ydnb" + "SH40eSD+WGmkWgDhi8JDzJK2aIjAcTpjguEE"; InitializeComponent(); #region Init _logger = Service.GetInstance().GetLogger(); LibService.Init(_logger); LibService.GetInstance().SetDbConnectionString(Service.GetInstance().GetOpcDict()["DbConnectionString"]); AsLibraryCore.LibService.GetInstance().SetEventsDbConnectionString(Service.GetInstance().GetOpcDict()["EventsDbConnectionString"]); NewOpcServer.Init(_logger); NewOpcServer.GetInstance().InitOpc(NewOpcServer.OpcList.Rbu); NewOpcServer.GetInstance().ConnectOpc(NewOpcServer.OpcList.Rbu); var reportHelper = new ReportHelper(_logger); reportHelper.SubscribeReportSaving(); OpcServer.Init(@"Data/Service.xlsx"); OpcServer.GetInstance(); OpcServer.GetInstance().InitOpc(OpcServer.OpcList.Rbu, Service.GetInstance().GetOpcDict()["OpcServerAddress"]); OpcServer.GetInstance().ConnectOpc(OpcServer.OpcList.Rbu); EventsBase.GetInstance().CreateControlEvents(OpcServer.OpcList.Rbu); #endregion Title = ServiceData.GetInstance().GetTitle() + " " + Release.GetInstance().GetReleaseTitle(); Login(); EventsBase.GetInstance().GetControlEvents(OpcServer.OpcList.Rbu).AddEvent("Программа управления открыта", SystemEventType.Message); #region Масштаб экрана (comment) //var rect = SystemParameters.WorkArea; //if (rect.Width != 1920) // MainGrid.LayoutTransform = // new ScaleTransform(Math.Min(rect.Width, 1920) / 1920, Math.Min(rect.Height, 1080) / 1080); #endregion }
public StiReport GetReport(SystemReportType SRT, SystemReportTypeFilterConditions SrtFilterConditions) { try { ReportHelper reportHelper = ReportHelper.Instance("شرکت طرح و پردازش غدیر", BUser.CurrentUser.ID, BUser.CurrentUser.Person.Name, new List <decimal>(), Guid.NewGuid().ToString(), string.Empty, false, string.Empty, string.Empty, new List <decimal>()); StiReport stiReport = new StiReport(); double columnWidth = 0; double dataBandRowHeight = 1.0; double dataBandHeight = 4; double dataHeaderRowHeight = 1; double dataHeaderHeight = 3; Font dataBandFont = new Font("Tahoma", 8, FontStyle.Bold); Font headerBandFont = new Font("arial", 11, FontStyle.Bold); Font titleBandFont = new Font("Tahoma", 16, FontStyle.Bold); Font groupBandFont = new Font("Tahoma", 10, FontStyle.Bold); Font pageHeaderFont = new Font("Tahoma", 18, FontStyle.Bold); stiReport.Unit = Stimulsoft.Report.Units.StiUnit.Centimeters; StiPage page = stiReport.Pages[0]; page.Orientation = StiPageOrientation.Landscape; page.Width = 29.7; page.Height = 21; page.Margins.Bottom = 0.5; page.Margins.Left = 0.5; page.Margins.Right = 0.5; page.Margins.Top = 0.5; StiPageHeaderBand pageHeader = new StiPageHeaderBand(); pageHeader.Height = 2; pageHeader.Width = page.Width; pageHeader.Name = "PageHeader"; pageHeader.Border.Side = StiBorderSides.All; pageHeader.Border.Color = Color.Cornsilk; page.Components.Add(pageHeader); StiText officeNameText_pageHeader = new StiText(new RectangleD(0, 0, 10.6, 0.6)); officeNameText_pageHeader.Left = (page.Width / 2) - 5.3; officeNameText_pageHeader.Top = 0; IList <Presentaion_Helper.Proxy.DataAccessProxy> dataAccessList = new BDataAccess().GetAllByUserId(DataAccessParts.Corporation, BUser.CurrentUser.ID); string headerText = string.Empty; if (dataAccessList != null && dataAccessList.Count > 0) { headerText = dataAccessList.FirstOrDefault().Name; } officeNameText_pageHeader.Text = headerText; officeNameText_pageHeader.HorAlignment = StiTextHorAlignment.Center; officeNameText_pageHeader.VertAlignment = StiVertAlignment.Center; officeNameText_pageHeader.Name = "OfficeNameHeader"; officeNameText_pageHeader.Font = pageHeaderFont; officeNameText_pageHeader.Height = 1; pageHeader.Components.Add(officeNameText_pageHeader); StiText reportNameText_pageHeader = new StiText(new RectangleD(0, 0, 10.6, 0.6)); reportNameText_pageHeader.Left = (page.Width / 2) - 5.3; reportNameText_pageHeader.Top = 1; reportNameText_pageHeader.HorAlignment = StiTextHorAlignment.Center; reportNameText_pageHeader.VertAlignment = StiVertAlignment.Center; reportNameText_pageHeader.Name = "reportNameText"; reportNameText_pageHeader.Font = pageHeaderFont; reportNameText_pageHeader.Height = 1; pageHeader.Components.Add(reportNameText_pageHeader); StiText reportCreateDateLabelText_pageHeader = new StiText(new RectangleD(0, 0, 2.6, 0.6)); reportCreateDateLabelText_pageHeader.Left = 2.4; reportCreateDateLabelText_pageHeader.Top = 0; switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Unknown: reportCreateDateLabelText_pageHeader.Text = ": تاریخ تهیه گزارش"; break; case LanguagesName.Parsi: reportCreateDateLabelText_pageHeader.Text = ": تاریخ تهیه گزارش"; break; case LanguagesName.English: reportCreateDateLabelText_pageHeader.Text = "Report Date :"; break; default: break; } reportCreateDateLabelText_pageHeader.HorAlignment = StiTextHorAlignment.Center; reportCreateDateLabelText_pageHeader.VertAlignment = StiVertAlignment.Center; reportCreateDateLabelText_pageHeader.Name = "reportCreateDateLabelText"; reportCreateDateLabelText_pageHeader.Font = dataBandFont; reportCreateDateLabelText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(89, 89, 89)); pageHeader.Components.Add(reportCreateDateLabelText_pageHeader); StiText reportCreateDateText_pageHeader = new StiText(new RectangleD(0, 0, 2.4, 0.6)); reportCreateDateText_pageHeader.Left = 0; reportCreateDateText_pageHeader.Top = 0; reportCreateDateText_pageHeader.Text = ReportHelper.Instance().ShamsiGetNow(); reportCreateDateText_pageHeader.HorAlignment = StiTextHorAlignment.Center; reportCreateDateText_pageHeader.VertAlignment = StiVertAlignment.Center; reportCreateDateText_pageHeader.Name = "reportCreateDateText"; reportCreateDateText_pageHeader.Font = dataBandFont; reportCreateDateText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(183, 117, 64)); pageHeader.Components.Add(reportCreateDateText_pageHeader); StiText reportCreatorLabelText_pageHeader = new StiText(new RectangleD(0, 0, 2, 0.6)); reportCreatorLabelText_pageHeader.Left = 3; reportCreatorLabelText_pageHeader.Top = 0.6; switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Unknown: reportCreatorLabelText_pageHeader.Text = ": تهیه کننده"; break; case LanguagesName.Parsi: reportCreatorLabelText_pageHeader.Text = ": تهیه کننده"; break; case LanguagesName.English: reportCreatorLabelText_pageHeader.Text = "Creator :"; break; default: break; } reportCreatorLabelText_pageHeader.HorAlignment = StiTextHorAlignment.Center; reportCreatorLabelText_pageHeader.VertAlignment = StiVertAlignment.Center; reportCreatorLabelText_pageHeader.Name = "reportCreatorLabelText"; reportCreatorLabelText_pageHeader.Font = dataBandFont; reportCreatorLabelText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(89, 89, 89)); pageHeader.Components.Add(reportCreatorLabelText_pageHeader); StiText reportCreatorText_pageHeader = new StiText(new RectangleD(0, 0, 3, 0.6)); reportCreatorText_pageHeader.Left = 0; reportCreatorText_pageHeader.Top = 0.6; reportCreatorText_pageHeader.Text = ReportHelper.Instance().UserName; reportCreatorText_pageHeader.HorAlignment = StiTextHorAlignment.Center; reportCreatorText_pageHeader.VertAlignment = StiVertAlignment.Center; reportCreatorText_pageHeader.Name = "reportCreatorText"; reportCreatorText_pageHeader.Font = dataBandFont; reportCreatorText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(183, 117, 64)); pageHeader.Components.Add(reportCreatorText_pageHeader); StiHeaderBand headerBand = new StiHeaderBand(); headerBand.Name = "HeaderBand"; headerBand.Width = page.Width; headerBand.Border.Side = StiBorderSides.All; headerBand.Border.Color = Color.DimGray; page.Components.Add(headerBand); StiDataBand dataBand = new StiDataBand(); dataBand.Name = "DataBand"; dataBand.Width = page.Width; dataBand.Border.Side = StiBorderSides.All; dataBand.Border.Color = Color.Gainsboro; StiCondition conditionDataBand = new StiCondition("{Line%2==0}", Color.Black, Color.PeachPuff, dataBandFont, true); dataBand.Conditions.Add(conditionDataBand); page.Components.Add(dataBand); DataTable dtReport = new DataTable(); string modelReportName = string.Empty; switch (SRT) { case SystemReportType.SystemBusinessReport: IList <GTS.Clock.Model.Report.SystemBusinessReport> SystemBusinessReportList = this.GetSystemBusinessReportList(SRT, SrtFilterConditions); dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemBusinessReport>(SystemBusinessReportList); reportNameText_pageHeader.Text = "System Business Report"; modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemBusinessReport).Name; dataBand.Height = dataBandHeight; headerBand.Height = dataHeaderHeight; break; case SystemReportType.SystemEngineReport: IList <GTS.Clock.Model.Report.SystemEngineReport> SystemEngineReportList = this.GetSystemEngineReportList(SRT, SrtFilterConditions); dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemEngineReport>(SystemEngineReportList); reportNameText_pageHeader.Text = "System Engine Report"; modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemEngineReport).Name; dataBand.Height = dataBandHeight; headerBand.Height = dataHeaderHeight; break; case SystemReportType.SystemWindowsServiceReport: IList <GTS.Clock.Model.Report.SystemWindowsServiceReport> SystemWindowsServiceReportList = this.GetSystemWindowsServiceReportList(SRT, SrtFilterConditions); dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemWindowsServiceReport>(SystemWindowsServiceReportList); reportNameText_pageHeader.Text = "System Windows Service Report"; modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemWindowsServiceReport).Name; dataBand.Height = dataBandHeight; headerBand.Height = dataHeaderHeight; break; case SystemReportType.SystemUserActionReport: IList <GTS.Clock.Model.Report.SystemUserActionReport> SystemUserActionReportList = this.GetSystemUserActionReportList(SRT, SrtFilterConditions); dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemUserActionReport>(SystemUserActionReportList); reportNameText_pageHeader.Text = "System User Action Report"; modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemUserActionReport).Name; dataBand.Height = dataBandHeight; headerBand.Height = dataHeaderHeight; break; case SystemReportType.SystemEngineDebugReport: IList <GTS.Clock.Model.Report.SystemEngineDebugReport> SystemEngineDebugReportList = this.GetSystemEngineDebugReportList(SRT, SrtFilterConditions); dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemEngineDebugReport>(SystemEngineDebugReportList); reportNameText_pageHeader.Text = "System Engine Debug Report"; modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemEngineDebugReport).Name; dataBand.Height = dataBandHeight; headerBand.Height = dataHeaderHeight; break; case SystemReportType.SystemDataCollectorReport: IList <GTS.Clock.Model.Report.SystemDataCollectorReport> SystemDataCollectorReportList = this.GetSystemDataCollectorReportList(SRT, SrtFilterConditions); dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemDataCollectorReport>(SystemDataCollectorReportList); reportNameText_pageHeader.Text = "System Data Collector Report"; modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemDataCollectorReport).Name; dataBand.Height = dataBandHeight; headerBand.Height = dataHeaderHeight; break; } columnWidth = (page.Width) / (dtReport.Columns.Count - 2); stiReport.RegData(dtReport); stiReport.Dictionary.Synchronize(); double pos = 0; int nameIndex = 1; for (int i = 0; i < dtReport.Columns.Count; i++) { StiText headerColumnText; switch (dtReport.Columns[i].ColumnName.ToLower()) { case "exception": { headerColumnText = new StiText(new RectangleD(columnWidth, 1, (page.Width - columnWidth), 1)); break; } case "message": { headerColumnText = new StiText(new RectangleD(columnWidth, 2, (page.Width - columnWidth), 1)); break; } case "id": { if (SRT == SystemReportType.SystemUserActionReport) { headerColumnText = new StiText(new RectangleD(pos, 0, columnWidth, 1)); } else { headerColumnText = new StiText(new RectangleD(pos, 0, columnWidth, dataHeaderHeight)); } break; } case "cnpname": { headerColumnText = new StiText(new RectangleD(columnWidth, 1, (page.Width - columnWidth), 1)); break; } default: headerColumnText = new StiText(new RectangleD(pos, 0, columnWidth, 1)); headerColumnText.Width = columnWidth; break; } headerColumnText.HorAlignment = StiTextHorAlignment.Center; headerColumnText.VertAlignment = StiVertAlignment.Center; headerColumnText.Name = "HeaderText" + nameIndex.ToString(); headerColumnText.Brush = new StiSolidBrush(Color.FromArgb(191, 191, 191)); headerColumnText.Border.Side = StiBorderSides.All; headerColumnText.Font = headerBandFont; headerColumnText.Text.Value = dtReport.Columns[i].Caption; headerBand.Components.Add(headerColumnText); StiText dataText; switch (dtReport.Columns[i].ColumnName.ToLower()) { case "exception": { dataText = new StiText(new RectangleD(columnWidth, dataBandRowHeight, (page.Width - columnWidth), 1.5)); pos = pos - columnWidth; break; } case "message": { dataText = new StiText(new RectangleD(columnWidth, dataBandRowHeight + 1.5, (page.Width - columnWidth), 1.5)); pos = pos - columnWidth; break; } case "id": { if (SRT == SystemReportType.SystemUserActionReport) { dataText = new StiText(new RectangleD(pos, 0, columnWidth, 1)); } else { dataText = new StiText(new RectangleD(pos, 0, columnWidth, dataBandHeight)); } break; } case "cnpname": { dataText = new StiText(new RectangleD(columnWidth, dataBandRowHeight, (page.Width - columnWidth), 1.5)); pos = pos - columnWidth; break; } default: dataText = new StiText(new RectangleD(pos, 0, columnWidth, dataBandRowHeight)); break; } dataText.Type = StiSystemTextType.DataColumn; dataText.Text = "{Trim(" + modelReportName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(dtReport.Columns[i].ColumnName) + ")}"; dataText.HorAlignment = StiTextHorAlignment.Center; dataText.VertAlignment = StiVertAlignment.Center; dataText.Name = "DataText" + nameIndex.ToString(); dataText.Border.Side = StiBorderSides.All; dataText.Font = dataBandFont; dataText.WordWrap = true; dataBand.Components.Add(dataText); pos = pos + columnWidth; nameIndex++; } stiReport.Compile(); return(stiReport); } catch (Exception) { throw; } }
private void btnScan_Click(object sender, EventArgs e) { if (services != null && services.Count > 0) { lvResult.Items.Clear(); scanDirectory = DirectoryHelper.GetScanDirectoryName(); DirectoryHelper.CreateScanDirectory(scanDirectory); ReportObject reportObject = new ReportObject(); reportObject.ScanStartDate = DateTime.Now; reportObject.WsDescs = new List <WSDescriberForReport>(); reportObject.TotalRequestCount = 0; Log("Scan Started: " + reportObject.ScanStartDate.ToString("dd.MM.yyyy HH:mm:ss"), FontStyle.Bold, true); foreach (WSDescriber wsDesc in services) { WSDescriberForReport WSItemVulnerabilities = new WSDescriberForReport(); WSItemVulnerabilities.WsDesc = wsDesc; WSItemVulnerabilities.Vulns = new List <VulnerabilityForReport>(); WSItemVulnerabilities.StaticVulns = new List <StaticVulnerabilityForReport>(); WSItemVulnerabilities.InfoVulns = new List <DisclosureVulnerabilityForReport>(); Log("WSDL Address: " + wsDesc.WSDLAddress, FontStyle.Bold, true); Log("Parsing WSDL...", FontStyle.Regular, true); List <Param> respHeader = new List <Param>(); bool untrustedSSLSecureChannel = false; Parser parser = new Parser(wsDesc, ref untrustedSSLSecureChannel, ref respHeader); if (chkStaticScan.Checked) { Log("Static Analysis Started", FontStyle.Regular, true); StaticVulnerabilityScanner svs = new StaticVulnerabilityScanner(); foreach (StaticVulnerabilitiesStaticVulnerability staticVuln in staticVulnerabilities.StaticVulnerability) { Log(" Testing: " + staticVuln.title, FontStyle.Regular, chkDebug.Checked); string staticScanRes = svs.ScanIt(staticVuln, parser.rawWSDL); if (!string.IsNullOrEmpty(staticScanRes)) { Log(" " + staticVuln.title + " Vulnerability Found: " + staticScanRes, FontStyle.Bold, true); StaticVulnerabilityForReport vulnRep = new StaticVulnerabilityForReport(); vulnRep.Vuln = staticVuln; vulnRep.XMLLine = staticScanRes; WSItemVulnerabilities.StaticVulns.Add(vulnRep); } } Log("Static Analysis Finished", FontStyle.Regular, true); } if (chkDynamicScan.Checked) { Log("Getting Methods...", FontStyle.Regular, true); List <WSOperation> operations = parser.GetOperations(); WebServiceToInvoke wsInvoker = new WebServiceToInvoke(wsDesc.WSDLAddress.Replace("?WSDL", "")); if (!wsDesc.WSUri.Scheme.Equals("https")) { Log(" Vulnerability Found - SSL Not Used, Uri Schema is " + wsDesc.WSUri.Scheme, FontStyle.Bold, true); AddSSLRelatedVulnerability(WSItemVulnerabilities, 0); } else { if (untrustedSSLSecureChannel) { Log(" Vulnerability Found - Could not establish trust relationship for the SSL/TLS secure channel.", FontStyle.Bold, true); AddSSLRelatedVulnerability(WSItemVulnerabilities, -1); } } DynamicVulnerabilityScanner dynScn = new DynamicVulnerabilityScanner(this); foreach (WSOperation operation in operations) { Log("Method: " + operation.MethodName, FontStyle.Regular, chkDebug.Checked); foreach (VulnerabilitiesVulnerability vuln in vulnerabilities.Vulnerability) { if (vuln.id != 0 && vuln.id != 7) // 0 for insecure transport - ssl not used , 7 for verbose soap fault message { wsInvoker.PreInvoke(); Log(" Testing: " + vuln.title, FontStyle.Regular, chkDebug.Checked); Log(" Parameter Count: " + operation.Parameters.Count, FontStyle.Regular, chkDebug.Checked); try { dynScn.ScanVulnerabilities(wsInvoker, operation, vuln, parser.TargetNameSpace, wsDesc, WSItemVulnerabilities, reportObject, chkDebug.Checked, ref respHeader); } catch (System.Web.Services.Protocols.SoapException soapEx) { dynScn.SetSoapFaultException(operation, soapEx, WSItemVulnerabilities, chkDebug.Checked); } catch (Exception ex) { Log(" Exception: " + ex.ToString(), FontStyle.Regular, chkDebug.Checked); } } } } } if (chkInfoDisclosure.Checked) { Log("Information Disclosure Analysis Started", FontStyle.Regular, true); InformationDisclosureVulnerabilityScanner idvs = new InformationDisclosureVulnerabilityScanner(this); foreach (InformationDisclosureVulnerability infoVuln in disclosureVulnerabilities.Vulnerability) { Log(" Searching Response Header: " + infoVuln.title, FontStyle.Regular, chkDebug.Checked); string infoScanRes = idvs.ScanIt(infoVuln, respHeader); if (!string.IsNullOrEmpty(infoScanRes)) { Log(" " + infoVuln.title + " Information Disclosure Found: " + infoScanRes, FontStyle.Bold, true); DisclosureVulnerabilityForReport vulnRep = new DisclosureVulnerabilityForReport(); vulnRep.Vuln = infoVuln; vulnRep.Value = infoScanRes; WSItemVulnerabilities.InfoVulns.Add(vulnRep); } } Log("Information Disclosure Analysis Finished", FontStyle.Regular, true); } reportObject.WsDescs.Add(WSItemVulnerabilities); } reportObject.ScanEndDate = DateTime.Now; Log("Scan Finished: " + reportObject.ScanEndDate.ToString("dd.MM.yyyy HH:mm:ss"), FontStyle.Bold, true); string reportFilePath = scanDirectory + @"\Report\Report.html"; ReportHelper.CreateHTMLReport(reportObject, System.AppDomain.CurrentDomain.BaseDirectory + @"\ReportTemplates\HTMLReportTemplate.html", reportFilePath); Process.Start(reportFilePath); } else { MessageBox.Show("Please Select WSDL List File!!!"); } }
public object PostReportAction([FromBody] Dictionary <string, object> jsonArray) { return(ReportHelper.ProcessReport(jsonArray, this, this._cache)); }
public object PostReportAction([FromBody] Dictionary <string, object> jsonArray) { //Contains helper methods that help to process a Post or Get request from the Report Viewer control and return the response to the Report Viewer control return(ReportHelper.ProcessReport(jsonArray, this, this._cache)); }
public object GetResource(string key, string resourcetype, bool isPrint) { return(ReportHelper.GetResource(key, resourcetype, isPrint)); }
private void btnIn_Click(object sender, EventArgs e) { VnsLoaiChungTu objct = (VnsLoaiChungTu)ComboHelper.GetSelectData(cboLoaiCt); IList <RpChiTietNganSach> lst = new List <RpChiTietNganSach>(); string mact = objct == null ? "" : objct.MaLoaiChungTu; lst = ReportCapPhatService.GetBangKeChiTiet(ucDate.StartDate, ucDate.EndDate, mact, new Guid()); IList <Info> TempLstThamSo = General.lstThamSo; Info objThamSo = new Info(); objThamSo.Ma = "p_DateInput"; objThamSo.GiaTri = ucDate.Value_info.Ten; TempLstThamSo.Add(objThamSo); objThamSo = new Info(); objThamSo.Ma = "p_DonVi"; objThamSo.GiaTri = cboLoaiCt.Text; TempLstThamSo.Add(objThamSo); objThamSo = new Info(); objThamSo.Ma = "p_NgayBaoCao"; objThamSo.GiaTri = "Hà Nội, ngày " + DateTime.Now.Day.ToString() + " tháng " + DateTime.Now.Month.ToString() + " năm " + DateTime.Now.Year.ToString(); TempLstThamSo.Add(objThamSo); objThamSo = new Info(); objThamSo.Ma = "p_TieuDe"; string TieuDe = cboLoaiCt.Text; objThamSo.GiaTri = TieuDe.ToUpper(); TempLstThamSo.Add(objThamSo); ReportHelper.getParamValue(General.lstThamSo); List <RpChiTietNganSach> tmplst = new List <RpChiTietNganSach>(lst); XtraReport rp; switch (this.AccessibleDescription) { case "BangKe_01": rp = new Report.BangKe_01(); ReportHelper.SetParamValue(TempLstThamSo, rp.Parameters); tmplst = new List <RpChiTietNganSach>(lst); tmplst.Sort(RpChiTietNganSach.ComparePhieuByNgay_SoCt); tmplst = SortList(tmplst); rp.DataSource = tmplst; rp.ShowPreviewDialog(); break; case "BangKe_02": tmplst = new List <RpChiTietNganSach>(lst); tmplst.Sort(RpChiTietNganSach.ComparePhieuByNgay_SoCt); rp = new Report.BangKe_02(tmplst); ReportHelper.SetParamValue(TempLstThamSo, rp.Parameters); rp.DataSource = tmplst; rp.ShowPreviewDialog(); break; } }
public object PostFormReportAction() { return(ReportHelper.ProcessReport(null, this, _cache)); }
protected override ResultStatus Save(PokeBall pokeBall) { try { if (gvDetail.RowCount == 0) { MessageDisplay.Info("沒有變更資料,不需要存檔!"); return(ResultStatus.Fail); } #region ue_save_before gvMain.CloseEditor(); gvMain.UpdateCurrentRow(); gvDetail.CloseEditor(); gvDetail.UpdateCurrentRow(); string stockID, ymd, kindID, adjTypeName, opType, dbname, flag; string issueBeginYmd, issueEndYmd, implBeginYmd, implEndYmd, pubYmd, tradeYmd, mocfYmd, nextYmd; int found, count, row, col, currRow; decimal ldblRate; DateTime ldtWTIME = DateTime.Now; DataTable dtGrid = (DataTable)gcDetail.DataSource; found = dtGrid.Rows.IndexOf(dtGrid.Select("OP_TYPE <> ' '").FirstOrDefault()); if (found == -1) { MessageDisplay.Warning("沒有變更資料,不需要存檔!"); return(ResultStatus.Fail); } if (dtGrid.Rows.Count == 0) { MessageDisplay.Warning("無明細資料,請重新產生明細"); return(ResultStatus.FailButNext); } DataTable dtMGD2; //ids_mgd2 DataTable dtMGD2Log = dao40071.d_40071_log(); //ids_old dtMGD2Log.Clear(); //只取schema for (int f = 0; f < dtGrid.Rows.Count; f++) { if (dtGrid.Rows[f].RowState == DataRowState.Deleted) { continue; } DataRow dr = dtGrid.Rows[f]; opType = dr["OP_TYPE"].ToString(); flag = dr["DATA_FLAG"].AsString(); stockID = dr["STOCK_ID"].AsString(); //檢查同一標的的級距是否一致 if ((f + 1) < dtGrid.Rows.Count) { if (stockID == dtGrid.Rows[f + 1]["STOCK_ID"].AsString() && dr["M_CUR_LEVEL"].AsString() != dtGrid.Rows[f + 1]["M_CUR_LEVEL"].AsString()) { MessageDisplay.Error(stockID + "的級距不一致"); return(ResultStatus.FailButNext); } } //檢查有異動的資料 if (opType != " ") { kindID = dr["KIND_ID"].AsString(); ymd = dr["YMD"].ToString(); issueBeginYmd = dr["ISSUE_BEGIN_YMD"].ToString(); issueEndYmd = dr["ISSUE_END_YMD"].ToString(); implBeginYmd = dr["IMPL_BEGIN_YMD"].ToString(); implEndYmd = dr["IMPL_END_YMD"].ToString(); pubYmd = dr["PUB_YMD"].ToString(); if (ymd != implBeginYmd) { DialogResult result = MessageDisplay.Choose(stockID + "," + kindID + "交易日不等於處置起日,請問是否更新"); if (result == DialogResult.No) { return(ResultStatus.FailButNext); } } if (issueEndYmd != implEndYmd) { DialogResult result = MessageDisplay.Choose(stockID + "," + kindID + "生效迄日不等於處置迄日,請問是否更新"); if (result == DialogResult.No) { return(ResultStatus.FailButNext); } } //處置期間首日+1個月 mocfYmd = PbFunc.relativedate(implBeginYmd.AsDateTime("yyyyMMdd"), 30).ToString("yyyyMMdd"); /*次一營業日*/ nextYmd = daoMOCF.GetNextTradeDay(implBeginYmd, mocfYmd); if (issueBeginYmd != nextYmd) { DialogResult result = MessageDisplay.Choose(stockID + "," + kindID + "生效起日不等於處置起日之次一營業日,請問是否更新"); if (result == DialogResult.No) { return(ResultStatus.FailButNext); } } dtMGD2 = dao40072.d_40072(ymd, isAdjType, stockID); //資料修改,將修改前舊資料寫入log if (opType == "U") { dtMGD2.Filter("mgd2_kind_id = '" + kindID + "'"); foreach (DataRow drU in dtMGD2.Rows) { currRow = dtMGD2Log.Rows.Count; dtMGD2Log.Rows.Add(); for (col = 0; col < dtMGD2.Columns.Count; col++) { //先取欄位名稱,因為兩張table欄位順序不一致 dbname = dtMGD2.Columns[col].ColumnName; if (dbname == "CPSORT") { continue; //這個欄位是拿來排序用的,故無需複製 } dtMGD2Log.Rows[currRow][dbname] = drU[col]; } if (flag == "Y") { dtMGD2Log.Rows[currRow]["MGD2_L_TYPE"] = "U"; } if (flag == "N") { dtMGD2Log.Rows[currRow]["MGD2_L_TYPE"] = "D"; } dtMGD2Log.Rows[currRow]["MGD2_L_USER_ID"] = GlobalInfo.USER_ID; dtMGD2Log.Rows[currRow]["MGD2_L_TIME"] = ldtWTIME; } } /****************************************** * 確認商品是否在同一交易日不同情境下設定過 ******************************************/ DataTable dtSet = dao40071.IsSetOnSameDay(kindID, ymd, isAdjType); if (dtSet.Rows.Count == 0) { MessageDisplay.Info("MGD2 " + kindID + " 無任何資料!"); return(ResultStatus.FailButNext); } count = dtSet.Rows[0]["LI_COUNT"].AsInt(); adjTypeName = dtSet.Rows[0]["LS_ADJ_TYPE_NAME"].AsString(); if (count > 0) { MessageDisplay.Error(kindID + ",交易日(" + ymd + ")在" + adjTypeName + "已有資料"); return(ResultStatus.FailButNext); } /********************************* * 確認商品是否在同一生效日區間設定過 * 生效起日若與生效迄日相同,不重疊 * ex: 10/11的至10/31一般交易時段結束止,10/30的從10/31一般交易時段結束後始>>應不重疊 *************************************/ dtSet = dao40071.IsSetInSameSession(kindID, ymd, issueBeginYmd, issueEndYmd); count = dtSet.Rows[0]["LI_COUNT"].AsInt(); adjTypeName = dtSet.Rows[0]["LS_ADJ_TYPE_NAME"].AsString(); tradeYmd = dtSet.Rows[0]["LS_TRADE_YMD"].AsString(); if (count > 0) { MessageDisplay.Error(kindID + "," + adjTypeName + ",交易日(" + tradeYmd + ")在同一生效日區間內已有資料"); return(ResultStatus.FailButNext); } //判斷調整幅度是否為0 ldblRate = dr["ADJ_RATE"].AsDecimal(); if (ldblRate == 0) { MessageDisplay.Error("商品調整幅度不可為0"); return(ResultStatus.FailButNext); } } //if (ls_op_type != " ") } //for (int f = 0; f < dtGrid.Rows.Count; f++) #endregion string prodType; DataTable dtTemp = dao40072.d_40072(); //ids_tmp foreach (DataRow dr in dtGrid.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } opType = dr["OP_TYPE"].ToString(); //只更新有異動的資料 if (opType != " ") { kindID = dr["KIND_ID"].AsString(); stockID = dr["STOCK_ID"].AsString(); issueBeginYmd = dr["ISSUE_BEGIN_YMD"].ToString(); issueEndYmd = dr["ISSUE_END_YMD"].ToString(); implBeginYmd = dr["IMPL_BEGIN_YMD"].ToString(); implEndYmd = dr["IMPL_END_YMD"].ToString(); pubYmd = dr["PUB_YMD"].ToString(); ymd = dr["YMD"].ToString(); ldblRate = dr["ADJ_RATE"].AsDecimal(); //刪除已存在資料 if (daoMGD2.DeleteMGD2(ymd, isAdjType, stockID, kindID) < 0) { MessageDisplay.Error("MGD2資料刪除失敗"); return(ResultStatus.FailButNext); } if (dr["DATA_FLAG"].AsString() == "Y") { currRow = dtTemp.Rows.Count; prodType = dr["PROD_TYPE"].AsString(); dtTemp.Rows.Add(); dtTemp.Rows[currRow]["MGD2_YMD"] = ymd; dtTemp.Rows[currRow]["MGD2_PROD_TYPE"] = prodType; dtTemp.Rows[currRow]["MGD2_KIND_ID"] = kindID; dtTemp.Rows[currRow]["MGD2_STOCK_ID"] = stockID; dtTemp.Rows[currRow]["MGD2_ADJ_TYPE"] = isAdjType; dtTemp.Rows[currRow]["MGD2_ADJ_RATE"] = ldblRate; dtTemp.Rows[currRow]["MGD2_ADJ_CODE"] = "Y"; dtTemp.Rows[currRow]["MGD2_ISSUE_BEGIN_YMD"] = issueBeginYmd; dtTemp.Rows[currRow]["MGD2_ISSUE_END_YMD"] = issueEndYmd; dtTemp.Rows[currRow]["MGD2_IMPL_BEGIN_YMD"] = implBeginYmd; dtTemp.Rows[currRow]["MGD2_IMPL_END_YMD"] = implEndYmd; dtTemp.Rows[currRow]["MGD2_PUB_YMD"] = pubYmd; dtTemp.Rows[currRow]["MGD2_PROD_SUBTYPE"] = dr["PROD_SUBTYPE"]; dtTemp.Rows[currRow]["MGD2_PARAM_KEY"] = dr["PARAM_KEY"]; dtTemp.Rows[currRow]["MGD2_CUR_CM"] = dr["CM_CUR_A"]; dtTemp.Rows[currRow]["MGD2_CUR_MM"] = dr["MM_CUR_A"]; dtTemp.Rows[currRow]["MGD2_CUR_IM"] = dr["IM_CUR_A"]; dtTemp.Rows[currRow]["MGD2_CUR_LEVEL"] = dr["M_CUR_LEVEL"]; dtTemp.Rows[currRow]["MGD2_CM"] = dr["CM_A"]; dtTemp.Rows[currRow]["MGD2_MM"] = dr["MM_A"]; dtTemp.Rows[currRow]["MGD2_IM"] = dr["IM_A"]; dtTemp.Rows[currRow]["MGD2_CURRENCY_TYPE"] = dr["CURRENCY_TYPE"]; dtTemp.Rows[currRow]["MGD2_SEQ_NO"] = dr["SEQ_NO"]; dtTemp.Rows[currRow]["MGD2_OSW_GRP"] = dr["OSW_GRP"]; dtTemp.Rows[currRow]["MGD2_AMT_TYPE"] = dr["AMT_TYPE"]; dtTemp.Rows[currRow]["MGD2_W_TIME"] = ldtWTIME; dtTemp.Rows[currRow]["MGD2_W_USER_ID"] = GlobalInfo.USER_ID; /****************************** * AB TYTPE: -期貨 * A選擇權A值 * B選擇權B值 *******************************/ if (prodType == "F") { dtTemp.Rows[currRow]["MGD2_AB_TYPE"] = "-"; } else { dtTemp.Rows[currRow]["MGD2_AB_TYPE"] = "A"; //複製一筆一樣的,AB Type分開存 dtTemp.ImportRow(dtTemp.Rows[currRow]); //dtTemp.Rows.Add(dtTemp.Rows[ii_curr_row]);//會跳錯 currRow = dtTemp.Rows.Count - 1; dtTemp.Rows[currRow]["MGD2_AB_TYPE"] = "B"; dtTemp.Rows[currRow]["MGD2_CUR_CM"] = dr["CM_CUR_B"]; dtTemp.Rows[currRow]["MGD2_CUR_MM"] = dr["MM_CUR_B"]; dtTemp.Rows[currRow]["MGD2_CUR_IM"] = dr["IM_CUR_B"]; dtTemp.Rows[currRow]["MGD2_CM"] = dr["CM_B"]; dtTemp.Rows[currRow]["MGD2_MM"] = dr["MM_B"]; dtTemp.Rows[currRow]["MGD2_IM"] = dr["IM_B"]; } } //if (dr["DATA_FLAG"].AsString()=="Y") } //if (ls_op_type != " ") } //foreach (DataRow dr in dtGrid.Rows) //Update DB //ids_tmp.update() if (dtTemp.Rows.Count > 0) { ResultData myResultData = daoMGD2.UpdateMGD2(dtTemp); if (myResultData.Status == ResultStatus.Fail) { MessageDisplay.Error("更新資料庫MGD2錯誤! "); return(ResultStatus.FailButNext); } } //ids_old.update() if (dtMGD2Log.Rows.Count > 0) { ResultData myResultData = daoMGD2L.UpdateMGD2L(dtMGD2Log); if (myResultData.Status == ResultStatus.Fail) { MessageDisplay.Error("更新資料庫MGD2L錯誤! "); return(ResultStatus.FailButNext); } } //Write LOGF WriteLog("變更資料 ", "Info", "I"); //報表儲存pdf ReportHelper _ReportHelper = new ReportHelper(gcDetail, _ProgramID, this.Text); CommonReportLandscapeA3 reportLandscape = new CommonReportLandscapeA3();//設定為橫向列印 reportLandscape.printableComponentContainerMain.PrintableComponent = gcDetail; reportLandscape.IsHandlePersonVisible = false; reportLandscape.IsManagerVisible = false; _ReportHelper.Create(reportLandscape); _ReportHelper.Export(FileType.PDF, _ReportHelper.FilePath); MessageDisplay.Info("報表儲存完成!"); } catch (Exception ex) { MessageDisplay.Error("儲存錯誤"); throw ex; } return(ResultStatus.Success); }
public object GetResource(ReportResource resource) { return(ReportHelper.GetResource(resource, this, this._cache)); }
public ActionResult Averages() { return(View(ReportHelper.GetStudentAverages())); }
private void ProposalConfig(ReportHelper.ReportConfig config, string projectUId, string proposalUId) { var proposal = proposalService.GetProjectProposal(projectUId, proposalUId); if (proposal.ProposalStatus != (short)ProposalStatus.PROPOSAL_WAITING) { ProposalDocument document = proposalService.GetProposalDocument(projectUId, proposalUId); config.StaticXAMLReport = document.ProposalXAML; return; } // proposta config.ReportObjects.Add(proposal); // calcs the work days int dayCount = calendar.CalcWorkDayCount(proposal.EstimatedStartDate, proposal.EstimatedEndDate); config.ReportVars.Add("workDaysCount", dayCount.ToString()); // currency rate if (proposal.CurrencyRate == null) proposal.CurrencyRate = 1; // hourscosts var hourCosts = proposalService.GetHourCosts(projectUId); config.ReportObjects.Add(hourCosts); // creates proposal items with price List<ProposalItemWithPrice> itemsWithValue = new List<ProposalItemWithPrice>(); ICollection<BacklogItem> items = backlogService.GetCurrentBacklog(projectUId, (short)ScrumFactory.Services.BacklogFiltersMode.ALL); foreach (var item in proposal.Items) { var itemB = items.SingleOrDefault(i => i.BacklogItemUId == item.BacklogItemUId); if (itemB != null) { var price = proposal.CalcItemPrice(itemB, hourCosts); itemsWithValue.Add(new ProposalItemWithPrice(proposal.ProposalUId, itemB, price)); } } config.ReportObjects.Add(itemsWithValue); }
/// <summary> /// 將新增、刪除、變更的紀錄分別都列印或匯出出來(橫式A4) /// </summary> /// <param name="gridControl"></param> /// <param name="ChangedForAdded"></param> /// <param name="ChangedForDeleted"></param> /// <param name="ChangedForModified"></param> protected void AfterSaveForPrint(GridControl gridControl, DataTable ChangedForAdded, DataTable ChangedForDeleted, DataTable ChangedForModified, bool IsHandlePersonVisible = true, bool IsManagerVisible = true) { GridControl gridControlPrint = GridHelper.CloneGrid(gridControl); string _ReportTitle = _ProgramID + "─" + _ProgramName + GlobalInfo.REPORT_TITLE_MEMO; ReportHelper reportHelper = new ReportHelper(gridControl, _ProgramID, _ReportTitle); CommonReportLandscapeA4 reportLandscape = new CommonReportLandscapeA4(); //橫向A4 reportLandscape.printableComponentContainerMain.PrintableComponent = gcMain; reportLandscape.IsHandlePersonVisible = IsHandlePersonVisible; reportLandscape.IsManagerVisible = IsManagerVisible; reportHelper.Create(reportLandscape); if (ChangedForAdded != null) { if (ChangedForAdded.Rows.Count != 0) { gridControlPrint.DataSource = ChangedForAdded; reportHelper.PrintableComponent = gridControlPrint; reportHelper.ReportTitle = _ReportTitle + "─" + "新增"; reportHelper.Print(); reportHelper.Export(FileType.PDF, reportHelper.FilePath); } } if (ChangedForDeleted != null) { if (ChangedForDeleted.Rows.Count != 0) { DataTable dtTemp = ChangedForDeleted.Clone(); int rowIndex = 0; foreach (DataRow dr in ChangedForDeleted.Rows) { DataRow drNewDelete = dtTemp.NewRow(); for (int colIndex = 0; colIndex < ChangedForDeleted.Columns.Count; colIndex++) { drNewDelete[colIndex] = dr[colIndex, DataRowVersion.Original]; } dtTemp.Rows.Add(drNewDelete); rowIndex++; } gridControlPrint.DataSource = dtTemp.AsDataView(); reportHelper.PrintableComponent = gridControlPrint; reportHelper.ReportTitle = _ReportTitle + "─" + "刪除"; reportHelper.Print(); reportHelper.Export(FileType.PDF, reportHelper.FilePath); } } if (ChangedForModified != null) { if (ChangedForModified.Rows.Count != 0) { gridControlPrint.DataSource = ChangedForModified; reportHelper.PrintableComponent = gridControlPrint; reportHelper.ReportTitle = _ReportTitle + "─" + "變更"; reportHelper.Print(); reportHelper.Export(FileType.PDF, reportHelper.FilePath); } } }
private void btnView_Click(object sender, EventArgs e) { try { if (tvReportType.SelectedNode == null || tvReportType.SelectedNode.Tag == null) { return; } DataRow dr = tvReportType.SelectedNode.Tag as DataRow; long lReportTemplateID = dr["ReportTemplateID"] == DBNull.Value ? 0 : Convert.ToInt64(dr["ReportTemplateID"]); long lReportViewID = dr["ReportViewID"] == DBNull.Value ? 0 : Convert.ToInt64(dr["ReportViewID"]); if (lReportTemplateID == 0 || lReportViewID == 0) { return; } DataTable dtField = ExecuteSQL.CallView(133, "", "ReportViewID=" + lReportViewID, ""); DataView dvField = new DataView(dtField); DataTable dtFieldValue = new DataTable("Field"); dtFieldValue.Columns.Add("FieldName", typeof(string)); dtFieldValue.Columns.Add("FieldValue", typeof(string)); DataRow drRecord = null; DataTable dtRecord = new DataTable("Field"); foreach (Control ctl in this.pnlField.Controls) { string strName = ""; string strValue = ""; if (ctl is CoolTextBox) { CoolTextBox txt = ctl as CoolTextBox; strName = txt.Name; strValue = txt.Text; } else if (ctl is LBDateTime) { LBDateTime txt = ctl as LBDateTime; txt.Focus(); strName = txt.Name; strValue = txt.TextBox.Text.ToString(); } dvField.RowFilter = "FieldName='" + strName + "'"; if (dvField.Count > 0) { DataRow drField = dtFieldValue.NewRow(); drField["FieldName"] = strName; drField["FieldValue"] = strValue; dtFieldValue.Rows.Add(drField); } if (!dtRecord.Columns.Contains(strName)) { dtRecord.Columns.Add(strName, typeof(string)); } } drRecord = dtRecord.NewRow(); foreach (DataRow drField in dtFieldValue.Rows) { if (dtRecord.Columns.Contains(drField["FieldName"].ToString())) { drRecord[drField["FieldName"].ToString()] = drField["FieldValue"]; } } dtRecord.Rows.Add(drRecord); ReportRequestArgs args; args = new ReportRequestArgs(lReportTemplateID, 8, null, null); DataTable dtSPIN = new DataTable(); dtSPIN.Columns.Add("ReportViewID", typeof(long)); dtSPIN.Columns.Add("DTFieldValue", typeof(DataTable)); DataRow drNew = dtSPIN.NewRow(); drNew["ReportViewID"] = lReportViewID; drNew["DTFieldValue"] = dtFieldValue; dtSPIN.Rows.Add(drNew); dtSPIN.AcceptChanges(); DataSet dsReturn; DataTable dtOut; ExecuteSQL.CallSP(14407, dtSPIN, out dsReturn, out dtOut); DataTable dtSource = null; if (dsReturn != null && dsReturn.Tables.Count > 0) { dtSource = dsReturn.Tables[0].Copy(); dtSource.TableName = "T008"; DataSet dsSource = new DataSet("Report"); dsSource.Tables.Add(dtSource); args.DSDataSource = dsSource; args.ReportTemplateID = lReportTemplateID; args.RecordDR = drRecord; FastReport.Report report = ReportHelper.GetReport(args); report.Preview = this.previewControl1; report.Show(); } } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
public Report report() { return(ReportHelper.CreateReport(works(), stops())); }
public void SetReportDocument(string xaml, string title, ReportHelper.Report reports, ReportHelper.ReportConfig config) { this.reportXaml = xaml; this.reports = reports; this.config = config; this.title = title; if (reportXaml == null) { documentReader.Document = null; return; } xaml = CleanInvalidXmlChars(xaml); var document = System.Windows.Markup.XamlReader.Parse(xaml) as System.Windows.Documents.FlowDocument; documentReader.Document = document; foreach (string name in config.ReportViewModels.Keys) SetElementViewModel(name, config.ReportViewModels[name]); ScrumFactory.ReportHelper.Paginator.LoadLogo(serverUrl.Url + "/images/companyLogo.png"); }
/// <summary> /// Processes the fixture level blocks /// Adds all tests to the output /// </summary> private void ProcessFixtureBlocks() { Console.WriteLine("[INFO] Building fixture blocks..."); string errorMsg = null; string descMsg = null; XmlNodeList collectionNodes = _doc.SelectNodes(".//collection"); int testCount = 0; // run for each test collection foreach (XmlNode suite in collectionNodes) { var testSuite = new TestSuite(); testSuite.Name = suite.Attributes["name"].InnerText.Replace("Test collection for", "").Replace(_fileNameWithoutExtension + ".", "").Trim(); if (suite.Attributes["time"] != null) { double duration; if (double.TryParse(suite.Attributes["time"].InnerText, out duration)) { testSuite.Duration = duration; testSuite.StartTime = duration.ToString(); } } // check if the testSuite has any errors (ie error in the TestFixtureSetUp) /*var testSuiteFailureNode = suite.SelectSingleNode("failure"); * if (testSuiteFailureNode != null && testSuiteFailureNode.HasChildNodes) * { * errorMsg = descMsg = ""; * var message = testSuiteFailureNode.SelectSingleNode(".//message"); * * if (message != null) * { * errorMsg = message.InnerText.Trim(); * errorMsg += testSuiteFailureNode.SelectSingleNode(".//stack-trace") != null ? " -> " + testSuiteFailureNode.SelectSingleNode(".//stack-trace").InnerText.Replace("\r", "").Replace("\n", "") : ""; * } * testSuite.StatusMessage = errorMsg; * }*/ // add each test of the test-fixture foreach (XmlNode testcase in suite.SelectNodes(".//test")) { errorMsg = descMsg = ""; var tc = new Test(); tc.Name = testcase.Attributes["name"].InnerText.Replace(_fileNameWithoutExtension + ".", "").Replace(testSuite.Name + ".", ""); tc.Status = testcase.Attributes["result"].InnerText.AsStatus(); if (testcase.Attributes["time"] != null) { try { Double d; var durationTimeSpan = testcase.Attributes["time"].InnerText; if (Double.TryParse(durationTimeSpan, out d)) { tc.Duration = d; } } catch (Exception) { } } /*var categories = testcase.SelectNodes(".//property[@name='Category']"); * foreach (XmlNode category in categories) * { * tc.Categories.Add(category.Attributes["value"].InnerText); * }*/ var message = testcase.SelectSingleNode(".//message"); if (message != null) { errorMsg = "<pre>"; // + message.InnerText.Trim(); errorMsg += testcase.SelectSingleNode(".//stack-trace") != null ? " -> " + testcase.SelectSingleNode(".//stack-trace").InnerText.Replace("\r", "") : ""; errorMsg += "</pre>"; errorMsg = errorMsg == "<pre></pre>" ? "" : errorMsg; } /*XmlNode desc = testcase.SelectSingleNode(".//property[@name='Description']"); * * if (desc != null) * { * descMsg += "<p class='description'>Description: " + desc.Attributes["value"].InnerText.Trim(); * descMsg += "</p>"; * descMsg = descMsg == "<p class='description'>Description: </p>" ? "" : descMsg; * }*/ tc.StatusMessage = descMsg + errorMsg; testSuite.Tests.Add(tc); Console.Write("\r{0} tests processed...", ++testCount); } testSuite.Status = ReportHelper.GetFixtureStatus(testSuite.Tests); _report.TestFixtures.Add(testSuite); } }
public AppManager() { DataAccess = new AccessDB(dbINFO._SRV, dbINFO._CAT, dbINFO._UID, dbINFO._PWD); AppLogin = new AppLoginHelper(); Utility = new UtilityHelper(); SendMail = new MailHelper(); Report = new ReportHelper(Utility, dbINFO._SRV, dbINFO._CAT, dbINFO._UID, dbINFO._PWD); }
protected void DistributionCenterLossesView_DataBound(object sender, EventArgs e) { int lastColumn = DistributionCenterLossesView.Columns.Count - 1; ReportHelper.MarkCriticalRow(DistributionCenterLossesView.Rows, lastColumn); }
/// <summary> /// Shows this instance. /// </summary> public void Show(ReportHelper.ReportConfig config) { Config = config; PanelName = Config.ReportName; Refresh(); Show(projectContainer.Value); }
private void PrepareReport(ReportHelper.ReportConfig config) { // add project config.ReportObjects.Add(Project); // add risks ICollection<Risk> risks = projectsService.GetProjectRisks(Project.ProjectUId); config.ReportObjects.Add(risks); // add itens ICollection<BacklogItem> items = backlogService.GetBacklog(Project.ProjectUId, null, (short)ScrumFactory.Services.BacklogFiltersMode.ALL); foreach (BacklogItem item in items) { item.ValidPlannedHours = item.GetValidPlannedHours(); } config.ReportObjects.Add(items); // add constraints ICollection<ProjectConstraint> constraints = constraintsService.GetProjectConstraints(Project.ProjectUId); config.ReportObjects.Add(constraints); // add end date config.AddReportVar("ProjectEndDate", Project.LastSprint.EndDate); }