コード例 #1
0
        public ActionResult ReportHeadersGridViewPartialUpdate(ReportHeader item)
        {
            var model = db.ReportHeaders;

            if (ModelState.IsValid)
            {
                try
                {
                    var modelItem = model.FirstOrDefault(it => it.ObjId == item.ObjId);
                    if (modelItem != null)
                    {
                        this.UpdateModel(modelItem);
                        db.SaveChanges();
                    }
                }
                catch (Exception e)
                {
                    ViewData["EditError"] = e.Message;
                }
            }
            else
            {
                ViewData["EditError"] = "Please, correct all errors.";
            }
            return(PartialView("_ReportHeaderGridViewPartial", model.ToList()));
        }
コード例 #2
0
        //构建报表列
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();

            //销售部门
            var department = header.AddChild("DEPTNAME", new Kingdee.BOS.LocaleValue("销售部门"));

            department.ColIndex = 0;

            //销售员
            var salesman = header.AddChild("SALERNAME", new Kingdee.BOS.LocaleValue("销售员"));

            salesman.ColIndex = 1;

            //指标
            var quota = header.AddChild("TOTALQUOTA", new Kingdee.BOS.LocaleValue("指标"));

            quota.ColIndex = 2;

            //完成金额
            var amount = header.AddChild("TOTALAMOUNT", new Kingdee.BOS.LocaleValue("完成金额"));

            amount.ColIndex = 3;

            //完成占比
            var rate = header.AddChild("COMPLETERATE", new Kingdee.BOS.LocaleValue("完成占比"));

            rate.ColIndex = 4;

            return(header);
        }
コード例 #3
0
        public void SingleProperty_AssertPass()
        {
            var reportHeader = new ReportHeader();

            reportHeader.ShouldNotifyFor(x => x.Report)
            .When(() => reportHeader.Report = "Setup Sheet");
        }
コード例 #4
0
        //构建报表列
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();

            //部门
            var department = header.AddChild("DEPTNAME", new Kingdee.BOS.LocaleValue("部门"));

            department.ColIndex = 0;
            department.Width    = 200;

            //业务员
            var salesman = header.AddChild("SALERNAME", new Kingdee.BOS.LocaleValue("业务员"));

            salesman.ColIndex = 1;

            //线索数量
            var clueNumber = header.AddChild("CLUENUMBER", new Kingdee.BOS.LocaleValue("线索数量"));

            clueNumber.ColIndex = 2;

            //转化商机数量
            var oppNumber = header.AddChild("OPPNUMBER", new Kingdee.BOS.LocaleValue("转化商机数量"));

            oppNumber.ColIndex = 3;

            //转化率
            var conversionRate = header.AddChild("RATE1", new Kingdee.BOS.LocaleValue("转化率"));

            conversionRate.ColIndex = 4;

            return(header);
        }
コード例 #5
0
        /// <summary>
        /// 构建出报表列
        /// </summary>
        /// <param name="filter"></param>
        /// <returns></returns>
        /// <remarks>
        /// // 如下代码,演示如何设置同一分组的分组头字段合并
        /// // 需配合Initialize事件,设置分组依据字段(PrimaryKeyFieldName)
        /// ReportHeader header = new ReportHeader();
        /// header.Mergeable = true;
        /// int width = 80;
        /// ListHeader headChild1 = header.AddChild("FBILLNO", new LocaleValue("应付单号"));
        /// headChild1.Width = width;
        /// headChild1.Mergeable = true;
        ///
        /// ListHeader headChild2 = header.AddChild("FPURMAN", new LocaleValue("采购员"));
        /// headChild2.Width = width;
        /// headChild2.Mergeable = true;
        /// </remarks>

        //事件 6:设置账表列头字段信息
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            //FID,FEntryId,编号,状态,物料,数量,单位,单位精度,单价,价税合计

            ReportHeader header = new ReportHeader();
            var          status = header.AddChild("FDocumentStatus", new LocaleValue("状态"));

            status.ColIndex = 0;

            var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));

            billNo.ColIndex    = 1;
            billNo.IsHyperlink = true;//支持超链接

            var material = header.AddChild("FMaterialName", new LocaleValue("物料"));

            material.ColIndex = 2;

            var qty = header.AddChild("FQty", new LocaleValue("数量"), SqlStorageType.SqlDecimal); //SqlStorageType.SqlDecimal 是精度控制 在初始化中已经进行了定义

            qty.ColIndex = 3;

            var unit = header.AddChild("FUnitName", new LocaleValue("单位"));

            unit.ColIndex = 4;

            var price = header.AddChild("FTAXPRICE", new LocaleValue("含税价"), SqlStorageType.SqlDecimal);

            price.ColIndex = 5;

            var amount = header.AddChild("FALLAMOUNT", new LocaleValue("价税合计"), SqlStorageType.SqlDecimal);

            amount.ColIndex = 6;
            return(header);
        }
コード例 #6
0
        public ReportHeaderViewModel Create(ReportHeaderViewModel pt, string UserName)
        {
            ReportHeader obj = Mapper.Map <ReportHeader>(pt);

            obj.CreatedDate  = DateTime.Now;
            obj.ModifiedDate = DateTime.Now;
            obj.CreatedBy    = UserName;
            obj.ModifiedBy   = UserName;
            obj.ObjectState  = Model.ObjectState.Added;
            Create(obj);

            _unitOfWork.Save();

            pt.ReportHeaderId = obj.ReportHeaderId;


            _logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
            {
                DocTypeId    = _DocumentTypeService.FindByName(TransactionDoctypeConstants.Report).DocumentTypeId,
                DocId        = pt.ReportHeaderId,
                ActivityType = (int)ActivityTypeContants.Added,
            }));

            return(pt);
        }
コード例 #7
0
        public ActionResult ReportLayout(string name)
        {
            ReportHeader header = _ReportHeaderservice.GetReportHeaderByName(name);
            List <ReportLineViewModel> lines = _ReportLineService.GetReportLineList(header.ReportHeaderId).ToList();

            Dictionary <int, string> DefaultValues = TempData["ReportLayoutDefaultValues"] as Dictionary <int, string>;

            TempData["ReportLayoutDefaultValues"] = DefaultValues;
            foreach (var item in lines)
            {
                if (DefaultValues != null && DefaultValues.ContainsKey(item.ReportLineId))
                {
                    item.DefaultValue = DefaultValues[item.ReportLineId];
                }
            }

            ReportMasterViewModel vm = new ReportMasterViewModel();

            if (TempData["closeOnSelectOption"] != null)
            {
                vm.closeOnSelect = (bool)TempData["closeOnSelectOption"];
            }

            vm.ReportHeader   = header;
            vm.ReportLine     = lines;
            vm.ReportHeaderId = header.ReportHeaderId;

            return(View(vm));
        }
コード例 #8
0
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();

            header.AddChild("dname", new LocaleValue("工厂", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
            header.AddChild("fcaption", new LocaleValue("品类", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
            header.AddChild("mname", new LocaleValue("品名", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
            header.AddChild("fspecification", new LocaleValue("规格", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

            header.AddChild("SC", new LocaleValue("生产数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("ZT", new LocaleValue("正品数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("CK", new LocaleValue("发货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("TH", new LocaleValue("退货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("XS", new LocaleValue("销售数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("fprice", new LocaleValue("单价", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

            header.AddChild("SCCZ", new LocaleValue("生产产值", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("SCE", new LocaleValue("生产金额", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("ZPE", new LocaleValue("正品金额", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("CKE", new LocaleValue("发货金额", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("THJE", new LocaleValue("退货金额", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
            header.AddChild("XSE", new LocaleValue("销售金额", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

            header.AddChild("FHL1", new LocaleValue("退货率", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
            header.AddChild("FXSZB1", new LocaleValue("销售占比", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

            return(header);
        }
コード例 #9
0
 /// <summary>
 /// 设置列名
 /// </summary>
 /// <param name="filter"></param>
 /// <returns></returns>
 public override ReportHeader GetReportHeaders(IRptParams filter)
 {
     header = base.GetReportHeaders(filter);
     header = new ReportHeader();
     setField();
     return(header);
 }
コード例 #10
0
        // apply the style to an existing report
        public void Apply(C1Report rpt)
        {
            if (rpt == null)
            {
                return;
            }

            // default report font
            rpt.Font = Detail.Font;

            // report header
            ReportHeader.Apply(rpt.Sections.Header);

            // page header
            PageHeader.Apply(rpt.Sections.PageHeader);

            // group headers
            foreach (Group group in rpt.Groups)
            {
                GroupHeader.Apply(group.SectionHeader);
            }

            // detail
            Detail.Apply(rpt.Sections.Detail);

            // report footer
            PageFooter.Apply(rpt.Sections.PageFooter);
        }
コード例 #11
0
        //设置报表列名
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header    = new ReportHeader();
            int          width     = 100;
            ListHeader   headChild = header.AddChild("费用项目", new LocaleValue("费用项目"));

            headChild.Width     = width;
            headChild.Mergeable = false;
            headChild.Visible   = true;
            //循环添加部门
            ListHeader[] listHeader = new ListHeader[depCol.Count];
            for (int i = 0; i < depCol.Count; i++)
            {
                //部门
                string depName = Convert.ToString(depCol[i]["FDepName"]);
                listHeader[i]           = header.AddChild(depName, new LocaleValue(depName), SqlStorageType.SqlDecimal);
                listHeader[i].Width     = width;
                listHeader[i].Mergeable = false;
                listHeader[i].Visible   = true;
            }
            ListHeader headChildEnd = header.AddChild("合计", new LocaleValue("合计"), SqlStorageType.SqlDecimal);

            headChildEnd.Width     = width;
            headChildEnd.Mergeable = false;
            headChildEnd.Visible   = true;
            return(header);
        }
コード例 #12
0
        //构建报表列
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();

            //部门
            var department = header.AddChild("department", new Kingdee.BOS.LocaleValue("部门"));

            department.ColIndex = 0;

            //业务员
            var salesman = header.AddChild("saler", new Kingdee.BOS.LocaleValue("业务员"));

            salesman.ColIndex = 1;

            //线索数量
            var clueNumber = header.AddChild("cluenumber", new Kingdee.BOS.LocaleValue("线索数量"));

            clueNumber.ColIndex = 2;

            //转化商机数量
            var oppNumber = header.AddChild("oppnumber", new Kingdee.BOS.LocaleValue("转化商机数量"));

            oppNumber.ColIndex = 3;

            //转化率
            var conversionRate = header.AddChild("rate", new Kingdee.BOS.LocaleValue("转化率"));

            conversionRate.ColIndex = 4;

            return(header);
        }
コード例 #13
0
ファイル: ReportService.cs プロジェクト: kav128/WebKoorsach
        public async Task <ReportData> GetReportByStudent(StudentDto student, CourseDto course)
        {
            var reportHeader = new ReportHeader {
                Course = course.Name, Student = student.FullName, Lecture = null
            };

            IList <JournalRecordDto> journalRecords = await _journalService.GetRecords(0, student.Id, course.Id);

            IList <LectureDto> lectures = await _lectureService.GetAllByCourse(course.Id);

            ReportRecord[] reportRecords = journalRecords.Select(dto => new ReportRecord
            {
                Lecture    = lectures.First(lectureDto => lectureDto.Id == dto.LectureId).Name,
                Attendance = dto.Attendance,
                Score      = dto.Score,
                Student    = null
            }).ToArray();

            double?attendancePercentage = reportRecords.IsEmpty()
                ? null
                : reportRecords.Average(record => Convert.ToInt32(record.Attendance)) * 100;

            double?averageScore = reportRecords.IsEmpty()
                ? null
                : reportRecords.Average(record => record.Score);
            var report = new ReportData
            {
                Header  = reportHeader,
                Records = reportRecords,
                AttendancePercentage = attendancePercentage,
                AverageScore         = averageScore
            };

            return(report);
        }
        //构建报表列
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();

            //设置列的key值,字段名,标题,数据类型
            var FMATERIALNUMBER = header.AddChild();

            FMATERIALNUMBER.Key       = "FMATERIALNUMBER";
            FMATERIALNUMBER.FieldName = "FMATERIALNUMBER";
            FMATERIALNUMBER.Caption   = new LocaleValue("物料号", this.Context.UserLocale.LCID);
            FMATERIALNUMBER.ColType   = SqlStorageType.Sqlnvarchar;

            var FLOTNUMBER = header.AddChild();

            FLOTNUMBER.Key       = "FLOTNUMBER";
            FLOTNUMBER.FieldName = "FLOTNUMBER";
            FLOTNUMBER.Caption   = new LocaleValue("批号", this.Context.UserLocale.LCID);
            FLOTNUMBER.ColType   = SqlStorageType.Sqlnvarchar;

            var FBASEQTY = header.AddChild();

            FBASEQTY.Key       = "FBASEQTY";
            FBASEQTY.FieldName = "FBASEQTY";
            FBASEQTY.Caption   = new LocaleValue("库存量", this.Context.UserLocale.LCID);
            FBASEQTY.ColType   = SqlStorageType.SqlDecimal;

            var FDAYS = header.AddChild();

            FDAYS.Key       = "FDAYS";
            FDAYS.FieldName = "FDAYS";
            FDAYS.Caption   = new LocaleValue("天数", this.Context.UserLocale.LCID);
            FDAYS.ColType   = SqlStorageType.SqlInt;

            return(header);
        }
コード例 #15
0
        /// <summary>
        /// 设置报表列
        /// </summary>
        /// <param name="filter"></param>
        /// <returns></returns>
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header   = new ReportHeader();
            var          material = header.AddChild("FMATERIALID", new LocaleValue("物料"));

            material.ColIndex = 0;
            var qty = header.AddChild("FQTY", new LocaleValue("数量"), SqlStorageType.SqlDecimal);

            qty.ColIndex = 1;
            var unit = header.AddChild("FUNITNAME", new LocaleValue("单位"));

            unit.ColIndex = 2;
            var taxprice = header.AddChild("FTAXPRICE", new LocaleValue("含税价"), SqlStorageType.SqlDecimal);

            taxprice.ColIndex = 3;
            var amount = header.AddChild("FALLAMOUNT", new LocaleValue("价税合计"), SqlStorageType.SqlDecimal);

            amount.ColIndex = 4;
            var taxRate = header.AddChild("FTAXRATE", new LocaleValue("税率"), SqlStorageType.SqlDecimal);

            taxRate.ColIndex = 5;
            var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));

            billNo.ColIndex = 6;
            var date = header.AddChild("FDATE", new LocaleValue("日期"));

            date.ColIndex = 7;
            var price = header.AddChild("FPRICE", new LocaleValue("未税单价"));

            price.ColIndex = 8;

            return(header);
        }
コード例 #16
0
        private void On_SubscribeReceived(NetMQMessage message)
        {
            int count = message.FrameCount;

            if (count < 3)
            {
                return;
            }

            string accountNo = message.Pop().ConvertToString();
            var    msgHeader = message.Pop().ToByteArray();
            var    payload   = message.Pop();

            ReportHeader header = ReportHeader.Parser.ParseFrom(msgHeader);

            if (header.ApiId == ID_STOCK_PLACE_REPORT)
            {
                PlacedReport report = PlacedReport.Parser.ParseFrom(payload.ToByteArray());
                PlaceReportReceived?.Invoke(accountNo, header, report);
            }
            else if (header.ApiId == ID_STOCK_FILL_REPORT)
            {
                FillReport report = FillReport.Parser.ParseFrom(payload.ToByteArray());
                FillReportReceived?.Invoke(accountNo, header, report);
            }
            else if (header.ApiId == ID_STOCK_CANCEL_REPORT)
            {
                CancellationReport report = CancellationReport.Parser.ParseFrom(payload.ToByteArray());
                CancelReportReceived?.Invoke(accountNo, header, report);
            }
        }
コード例 #17
0
        public override Kingdee.BOS.Core.Report.ReportHeader GetReportHeaders(Kingdee.BOS.Core.Report.IRptParams filter)
        {
            ReportHeader header = base.GetReportHeaders(filter);

            header.AddChild("FAuditDate", new LocaleValue("审核日期"), SqlStorageType.SqlSmalldatetime, true);
            return(header);
        }
コード例 #18
0
        public ActionResult ReportHeadersGridViewPartialAddNew(ReportHeader item)
        {
            var model = db.ReportHeaders;

            if (ModelState.IsValid)
            {
                try
                {
                    var currentRolesToAddExists = db.ReportHeaders.Where(c => c.ObjId == item.ObjId).Any();
                    if (currentRolesToAddExists == false)
                    {
                        item.ObjId = Guid.NewGuid();
                        model.Add(item);
                        db.SaveChanges();
                    }
                    else
                    {
                        ViewData["EditError"] = "Report Headers Already Exist";
                    }
                }

                catch (Exception e)
                {
                    ViewData["EditError"] = e.Message;
                }
            }
            else
            {
                ViewData["EditError"] = "Please, correct all errors.";
            }
            return(PartialView("_ReportHeaderGridViewPartial", model.ToList()));
        }
コード例 #19
0
ファイル: Header.aspx.cs プロジェクト: AYCHErp/AYCH-mixerp
 protected void Page_Load(object sender, EventArgs e)
 {
     using (ReportHeader header = new ReportHeader())
     {
         this.Placeholder1.Controls.Add(header);
     }
 }
コード例 #20
0
        /// <summary>
        /// 设置表头
        /// </summary>
        /// <param name="filter"></param>
        /// <returns></returns>
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader reportHeader = base.GetReportHeaders(filter);

            reportHeader.AddChild("F_JN_YDL_AllocUseDeptID_EXT", new LocaleValue("使用部门", base.Context.UserLocale.LCID));
            reportHeader.AddChild("F_JN_YDL_AllocUseDeptNumber_EXT", new LocaleValue("使用部门编码", base.Context.UserLocale.LCID));
            return(reportHeader);
        }
コード例 #21
0
        private static ReportHeader GetHeaderByRegion()
        {
            ReportHeader header = new ReportHeader();

            header.AddChild("regionName", new LocaleValue("区域"));
            header.AddChild("oppCount", new LocaleValue("数量"), SqlStorageType.SqlInt);
            return(header);
        }
コード例 #22
0
        private static ReportHeader GetHeaderByProvince()
        {
            ReportHeader header = new ReportHeader();

            header.AddChild("provinceName", new LocaleValue("省份"));
            header.AddChild("oppCount", new LocaleValue("数量"), SqlStorageType.SqlInt);
            return(header);
        }
コード例 #23
0
        private static ReportHeader GetHeaderByIndustry()
        {
            ReportHeader header = new ReportHeader();

            header.AddChild("industryName", new LocaleValue("产业"));
            header.AddChild("oppCount", new LocaleValue("数量"), SqlStorageType.SqlInt);
            return(header);
        }
コード例 #24
0
ファイル: Header.aspx.cs プロジェクト: ududsha/mixerp
 protected void Page_Load(object sender, EventArgs e)
 {
     using (ReportHeader header = new ReportHeader())
     {
         header.ResourceAssembly = Assembly.GetAssembly(typeof(Header));
         this.Placeholder1.Controls.Add(header);
     }
 }
コード例 #25
0
        //public override void Initialize()
        //{
        //    base.Initialize();
        //    DecimalControlField field = new DecimalControlField
        //    {
        //        ByDecimalControlFieldName = "FJNUnitEnzyme",
        //        DecimalControlFieldName = "FSECPRECISION"
        //    };
        //    base.ReportProperty.DecimalControlFieldList.Add(field);
        //    DecimalControlField field2 = new DecimalControlField
        //    {
        //        ByDecimalControlFieldName = "FJNTonProperty",
        //        DecimalControlFieldName = "FSECPRECISION"
        //    };
        //    base.ReportProperty.DecimalControlFieldList.Add(field2);
        //}

        public override Kingdee.BOS.Core.Report.ReportHeader GetReportHeaders(Kingdee.BOS.Core.Report.IRptParams filter)
        {
            ReportHeader reportHeader = base.GetReportHeaders(filter);

            reportHeader.AddChild("FJNUnitEnzyme", new LocaleValue("单位酶活量", base.Context.UserLocale.LCID));
            reportHeader.AddChild("FJNTonProperty", new LocaleValue("标吨", base.Context.UserLocale.LCID));
            return(reportHeader);
        }
コード例 #26
0
        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header  = new ReportHeader();
            ListHeader   header1 = header.AddChild();
            ListHeader   header2 = header.AddChild();
            ListHeader   header3 = header.AddChild();

            header1.Caption = new LocaleValue("客户名称", this.Context.UserLocale.LCID);
            header2.Caption = new LocaleValue("单据编码", this.Context.UserLocale.LCID);
            header3.Caption = new LocaleValue("提货日期", this.Context.UserLocale.LCID);
            // 编号
            var seq = header1.AddChild("FSEQ", new LocaleValue("序号"));

            seq.ColIndex = 0;
            var materialId = header1.AddChild("FMATERIALID", new LocaleValue("物料编码"));

            materialId.ColIndex = 1;

            var name = header1.AddChild("FNAME", new LocaleValue("品名"));

            name.ColIndex = 2;

            var specifiCation = header2.AddChild("FSPECIFICATION", new LocaleValue("规格"), SqlStorageType.SqlDecimal);

            specifiCation.ColIndex = 3;
            //待定  装箱数
            var packingQty = header2.AddChild("FPACKQTY ", new LocaleValue("装箱数"), SqlStorageType.SqlInt);

            packingQty.ColIndex = 4;

            var price = header2.AddChild("FTAXPRICE", new LocaleValue("含税单价"), SqlStorageType.SqlMoney);

            price.ColIndex = 5;

            var relQty = header2.AddChild("FREALQTY", new LocaleValue("实发数量"), SqlStorageType.SqlInt);

            relQty.ColIndex = 6;
            //待定  箱数
            var packQty = header2.AddChild("FPACKERQTY", new LocaleValue("箱数"), SqlStorageType.SqlInt);

            packQty.ColIndex = 7;

            var produceDate = header3.AddChild("FPRODUCEDATE", new LocaleValue("生产日期"), SqlStorageType.SqlDatetime);

            produceDate.ColIndex = 8;
            //保质期
            var expiryPeriod = header3.AddChild("FEXPPERIOD ", new LocaleValue("保质期"), SqlStorageType.SqlnText);

            expiryPeriod.ColIndex = 9;


            //结算金额(含税金额* 实发数量)
            var amount = header3.AddChild("FALLAMOUNT", new LocaleValue("结算金额"), SqlStorageType.SqlMoney);

            amount.ColIndex = 10;

            return(header);
        }
コード例 #27
0
        public ActionResult Save_Mapping(BigViewModel bigModel)
        {
            ReportHeader header = new ReportHeader();

            header.ElementSeparator    = (string)Session["ElementSeparator"];
            header.NewlineSeparator    = (string)Session["NewlineSeparator"];
            header.SubElementSeparator = (string)Session["SubElementSeparator"];

            header.Country     = bigModel.ReportHeader.Country;
            header.PartnerName = bigModel.ReportHeader.PartnerName;
            header.ReportType  = bigModel.ReportHeader.ReportType;

            //Insert through EDIFACTMapping
            header.EDI_FileType = "EDIFACT";


            //Load from Session
            if (Session["SegmentInitiator"] != null && Session["SegmentLocation"] != null && Session["FieldName"] != null)
            {
                SegmentInitiator    = (List <string>)Session["SegmentInitiator"];
                SegmentLocation     = (List <int>)Session["SegmentLocation"];
                FieldName           = (List <string>)Session["FieldName"];
                SegmentIdentifier_2 = (List <string>)Session["SegmentIdentifier_2"];
            }

            int id;

            using (EDI_ReportConverterEntities entity = new EDI_ReportConverterEntities())
            {
                entity.ReportHeaders.Add(header);
                entity.SaveChanges();
                id = header.Id;

                for (int i = 0; i < SegmentInitiator.Count; i++)
                {
                    ReportMapping mapping = new ReportMapping();
                    mapping.ReportHeader_Id     = id;
                    mapping.SegmentInitiator    = SegmentInitiator[i];
                    mapping.SegmentLocation     = SegmentLocation[i];
                    mapping.FieldName           = FieldName[i];
                    mapping.SegmentIdentifier_2 = SegmentIdentifier_2[i];

                    entity.ReportMappings.Add(mapping);
                    entity.SaveChanges();
                }
            }


            //validate if ReportHeader fields present (Make all ReportHeader fields mandatory)

            TempData["Message_Save_Mapping_Confirmation"] = "Mapping saved successfully!";

            Session["ReportheaderID"] = id; // Saving id in session. To be used in CriteriaController. Passing data as parameter to RedirecttoAction doesn't work

            //return View("Index");
            //return RedirectToAction("Index", "EDIFACT");  //redirects to upload and convert page
            return(RedirectToAction("Index", "Criteria")); // creating a new criteria that uses the given map header id
        }
コード例 #28
0
        private void On_CancelReportReceived(string accountNo, ReportHeader header, CancellationReport report)
        {
            string log = string.Format("{0} 账号:{1} {2} 券:{3} 数量:{4,6} 撤消:{6,6}. 单号:{7,10}, 原号:{8,10}. 成交:{5, 6}. {9} ",
                                       report.Status, report.AccountNo, report.OrderSide, report.Code, report.Quantity,
                                       report.TotalFillQuantity, report.CancelledQuantity,
                                       report.OrderExchangeId, report.OrderOriginalId, header.Message);

            BeginInvoke(new MethodInvoker(() => { WriteReport(log); }));
        }
コード例 #29
0
        // GET: /ProductMaster/Edit/5

        public ActionResult Edit(int id)
        {
            ReportHeader pt = _ReportHeaderService.GetReportHeader(id);

            if (pt == null)
            {
                return(HttpNotFound());
            }
            return(View("Create", pt));
        }
コード例 #30
0
        private void On_FillReportReceived(string accountNo, ReportHeader header, FillReport report)
        {
            string log = string.Format("{0} 账号:{1} {2} 券:{3} 数量:{4,6} 价格:{5,8}. 单号:{6,10}, 原号:{7,10}. 成交:{8, 6} 价格:{9, 8}. {10} ",
                                       report.FillStatus, report.AccountNo, report.OrderSide, report.Code, report.Quantity, report.Price,
                                       report.OrderExchangeId, report.OrderOriginalId,
                                       report.FillQuantity, report.FillPrice, header.Message
                                       );

            BeginInvoke(new MethodInvoker(() => { WriteReport(log); }));
        }
コード例 #31
0
ファイル: Report.cs プロジェクト: Opentany/Tech
 public void setHeader(ReportHeader header)
 {
     this.header = header;
 }