private void Window_Loaded(object sender, RoutedEventArgs e) { DataTable dt = new CutprepMasterDataSet().Tables["CutprepMasterTable"]; foreach (CutprepMasterExportViewModel cutprepMasterExportView in cutprepMasterExportViewList) { DataRow dr = dt.NewRow(); dr["Sequence"] = cutprepMasterExportView.Sequence; dr["ProductNo"] = cutprepMasterExportView.ProductNo; dr["Country"] = cutprepMasterExportView.Country; dr["ShoeName"] = cutprepMasterExportView.ShoeName; dr["ArticleNo"] = cutprepMasterExportView.ArticleNo; dr["PatternNo"] = cutprepMasterExportView.PatternNo; dr["Quantity"] = cutprepMasterExportView.Quantity; dr["ETD"] = cutprepMasterExportView.ETD; dr["SewingLine"] = cutprepMasterExportView.SewingLine; dr["UpperMatsArrival"] = cutprepMasterExportView.UpperMatsArrival; dr["SewingStartDate"] = cutprepMasterExportView.SewingStartDate; dr["SewingQuota"] = cutprepMasterExportView.SewingQuota; dr["SewingBalance"] = cutprepMasterExportView.SewingBalance; dr["CutAStartDate"] = cutprepMasterExportView.CutAStartDate; dr["CutAFinishDate"] = cutprepMasterExportView.CutAFinishDate; dr["CutAQuota"] = cutprepMasterExportView.CutAQuota; dr["AutoCut"] = cutprepMasterExportView.AutoCut; dr["LaserCut"] = cutprepMasterExportView.LaserCut; dr["HuasenCut"] = cutprepMasterExportView.HuasenCut; dr["CutABalance"] = cutprepMasterExportView.CutABalance; dr["PrintingBalance"] = cutprepMasterExportView.PrintingBalance; dr["H_FBalance"] = cutprepMasterExportView.H_FBalance; dr["EmbroideryBalance"] = cutprepMasterExportView.EmbroideryBalance; dr["CutBBalance"] = cutprepMasterExportView.CutBBalance; dr["IsUpperMatsArrivalOk"] = cutprepMasterExportView.IsUpperMatsArrivalOk; dr["IsHaveMemo"] = !string.IsNullOrEmpty(cutprepMasterExportView.MemoId); dt.Rows.Add(dr); } ReportParameter rp = new ReportParameter("Line", line); ReportDataSource rds = new ReportDataSource(); rds.Name = "CutprepMaster"; rds.Value = dt; //reportViewer.LocalReport.ReportPath = @"C:\Users\IT02\Documents\Visual Studio 2010\Projects\Saoviet Master Schedule Solution\MasterSchedule\Reports\CutprepMasterReport.rdlc"; reportViewer.LocalReport.ReportPath = @"Reports\CutprepMasterReport.rdlc"; reportViewer.LocalReport.SetParameters(new ReportParameter[] { rp }); reportViewer.LocalReport.DataSources.Add(rds); reportViewer.RefreshReport(); this.Cursor = null; }
private void Window_Loaded(object sender, RoutedEventArgs e) { DataTable dt = new CutprepMasterDataSet().Tables["CutprepMasterTable"]; foreach (CutprepMasterExportViewModel cutprepMasterExportView in cutprepMasterExportViewList) { DataRow dr = dt.NewRow(); dr["Sequence"] = cutprepMasterExportView.Sequence; dr["ProductNo"] = cutprepMasterExportView.ProductNo; dr["Country"] = cutprepMasterExportView.Country; dr["ShoeName"] = cutprepMasterExportView.ShoeName; dr["ArticleNo"] = cutprepMasterExportView.ArticleNo; dr["PatternNo"] = cutprepMasterExportView.PatternNo; dr["Quantity"] = cutprepMasterExportView.Quantity; dr["ETD"] = cutprepMasterExportView.ETD; dr["SewingLine"] = cutprepMasterExportView.SewingLine; dr["UpperMatsArrival"] = cutprepMasterExportView.UpperMatsArrival; dr["SewingStartDate"] = cutprepMasterExportView.SewingStartDate; dr["SewingQuota"] = cutprepMasterExportView.SewingQuota; dr["SewingBalance"] = cutprepMasterExportView.SewingBalance; dr["CutAStartDate"] = cutprepMasterExportView.CutAStartDate; dr["CutAFinishDate"] = cutprepMasterExportView.CutAFinishDate; dr["CutAQuota"] = cutprepMasterExportView.CutAQuota; dr["AutoCut"] = cutprepMasterExportView.AutoCut; dr["LaserCut"] = cutprepMasterExportView.LaserCut; dr["HuasenCut"] = cutprepMasterExportView.HuasenCut; dr["CutABalance"] = cutprepMasterExportView.CutABalance; dr["PrintingBalance"] = cutprepMasterExportView.PrintingBalance; dr["H_FBalance"] = cutprepMasterExportView.H_FBalance; dr["EmbroideryBalance"] = cutprepMasterExportView.EmbroideryBalance; dr["CutBBalance"] = cutprepMasterExportView.CutBBalance; dr["IsUpperMatsArrivalOk"] = cutprepMasterExportView.IsUpperMatsArrivalOk; dr["IsHaveMemo"] = !string.IsNullOrEmpty(cutprepMasterExportView.MemoId); dr["CutBStartDate"] = cutprepMasterExportView.CutBStartDate; dr["AtomCutA"] = cutprepMasterExportView.AtomCutA; dr["AtomCutB"] = cutprepMasterExportView.AtomCutB; dr["LaserCutA"] = cutprepMasterExportView.LaserCutA; dr["LaserCutB"] = cutprepMasterExportView.LaserCutB; dr["HuasenCutA"] = cutprepMasterExportView.HuasenCutA; dr["HuasenCutB"] = cutprepMasterExportView.HuasenCutB; dr["ComelzCutA"] = cutprepMasterExportView.ComelzCutA; dr["ComelzCutB"] = cutprepMasterExportView.ComelzCutB; dt.Rows.Add(dr); } //ReportParameter rp = new ReportParameter("Line", line); // Hidden = IIF(Parameters!ShowProductNo.Value="1", false, true) var parameterList = new List <ReportParameter>(); parameterList.Add(new ReportParameter("Line", line)); var propertyList = typeof(CutprepMasterExportViewModel).GetProperties().ToList(); foreach (var property in propertyList) { string value = "0"; if (columnNeedPrintList.Contains(property.Name)) { value = "1"; } parameterList.Add(new ReportParameter(String.Format("Show{0}", property.Name), value)); } ReportDataSource rds = new ReportDataSource(); rds.Name = "CutprepMaster"; rds.Value = dt; //reportViewer.LocalReport.ReportPath = @"C:\Users\IT02\Documents\Visual Studio 2010\Projects\Saoviet Master Schedule Solution\MasterSchedule\Reports\CutprepMasterReport.rdlc"; reportViewer.LocalReport.ReportPath = @"Reports\CutprepMasterReport.rdlc"; reportViewer.LocalReport.SetParameters(parameterList); reportViewer.LocalReport.DataSources.Add(rds); reportViewer.RefreshReport(); this.Cursor = null; }