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);
}
