nothing

王 垚

2021-09-13 527469d17b75d42349bf17234ef3e34cc36e8920

 src/BLL/Demo.Report/PRD/prd_CompleteSetRateReport.cs

@@ -29,13 +29,6 @@

        public override void Initialize()
        {
            //base.Initialize();
            //this.ReportProperty.ReportType = ReportType.REPORTTYPE_NORMAL;
            //this.ReportProperty.ReportName = new LocaleValue("供应商送料计划列表订单", base.Context.UserLocale.LCID);
            //this.ReportProperty.IsUIDesignerColumns = true;
            //this.ReportProperty.IsGroupSummary = true;
            //this.ReportProperty.SimpleAllCols = false;

            base.Initialize();
            // 简单账表类型：普通、树形、分页
            this.ReportProperty.ReportType = ReportType.REPORTTYPE_NORMAL;
@@ -44,15 +37,11 @@
            this.ReportProperty.IsUIDesignerColumns = false;
            //是否分组汇总
            this.ReportProperty.IsGroupSummary = true;



        }

        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();

            header.AddChild("FIDENTITYID", new LocaleValue("序号"), SqlStorageType.SqlInt).ColIndex = 1;
            header.AddChild("FHDATE", new LocaleValue("提料计划日期", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 1;
            header.AddChild("FHSOURCEBILLNO", new LocaleValue("生产订单编号", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 2;
@@ -73,7 +62,6 @@
            header.AddChild("FISQT", new LocaleValue("是否齐套", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 12;
            header.AddChild("FTYPE", new LocaleValue("类型", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 12;
            header.AddChild("FJSRATE", new LocaleValue("齐套率", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal).ColIndex = 12;

            return header;
        }

@@ -86,11 +74,9 @@
            string FProductLine = ""; //生产线
            string FMoBillNo = ""; //生产订单号
            string FSupplyID = ""; //供应商

            FBeginDATE = customFil["FBeginDATE"]?.ToString();
            FEndDATE = customFil["FEndDATE"]?.ToString();
            FMoBillNo = customFil["FMoBillNo"]?.ToString();
            
            if (((DynamicObject)customFil["FProductLine"]) != null)
            {
                FProductLine = ((DynamicObject)customFil["FProductLine"])["Id"].ToString();
@@ -103,8 +89,30 @@
            LogHelper.Info(sql);
            DBUtils.Execute(this.Context, sql);
        }
        public override void CloseReport()
        public override ReportTitles GetReportTitles(IRptParams filter)
        {
            var result = base.GetReportTitles(filter);
            DynamicObject dyFilter = filter.FilterParameter.CustomFilter;
            if (dyFilter != null)
            {
                if (result == null)
                {
                    result = new ReportTitles();
                }
            }
            var begindate = dyFilter["FBeginDATE"]?.ToString() ?? "1990-01-01 00:00:00";
            var enddate = dyFilter["FEndDATE"]?.ToString() ?? "9999 - 01 - 01 00:00:00";
            var FMoBillNo = dyFilter["FMoBillNo"]?.ToString() ?? "";
            var FProductLine = (dyFilter["FProductLine"] as DynamicObject)?["Name"].ToString() ?? "";
            var FSupplyID = (dyFilter["FSupplyID"] as DynamicObject)?["Name"].ToString() ?? "";
            //var FMaterialID = (dyFilter["FMaterialID"] as DynamicObject)?["Id"].ToString() ?? "";
            result.AddTitle("FBeginDATE", begindate);
            result.AddTitle("FEndDATE", enddate);
            result.AddTitle("FMoBillNo", FMoBillNo);
            result.AddTitle("FProductLine", FProductLine);
            result.AddTitle("FSupplyID", FSupplyID);
            //result.AddTitle("FMaterialID", FMaterialID);
            return result;

        }
    }