public static List<string> CreatePdfPerAccount(XtraReportDefaultTemplate xreport, ReportDataSet dSet, string pReportsPath)
{
List<string> _PdfFiles = new List<string>();
foreach (DataRow row in dSet.account.Rows) {
if (row.RowState == DataRowState.Deleted)
continue;
var dSetClone = (ReportDataSet)dSet.Copy();
var dset = dSetClone.account.Select(String.Format("NOT(account_id={0})", row["account_id"]));
foreach (var rowD in dset)
rowD.Delete();
dSetClone.AcceptChanges();
string fileName = String.Format(@"{0}\{1}_{2}_{3}.pdf",
pReportsPath,
row["company_name"].ToString().Replace(" ", "_").Replace(":", "_").Replace("/", "").Replace(@"\", ""),
DateTime.Now.ToString("yyyy-MM-dd"),
Guid.NewGuid().ToString()
);
var report = xreport.CloneReport() as XtraReportDefaultTemplate;
report.ReportHeader.Controls.Clear();
PdfExportOptions pdfOptions = report.ExportOptions.Pdf;
pdfOptions.Compressed = true;
pdfOptions.ImageQuality = PdfJpegImageQuality.Low;
report.DataSource = dSetClone;
report.ExportToPdf(fileName);
_PdfFiles.Add(fileName);
}
return _PdfFiles;
}
public void Generate_rptTransactionOut(string transactionOutID)
{
try
{
//Original tested
ReportDataSource rptDataSource;
string reportPath = @"E:\Dinesh Demo Project\ColdStorage\ColdStorage\Reports\rptTransactionOut.rdlc";
reportViewer1.LocalReport.ReportPath = reportPath;
reportViewer1.LocalReport.DataSources.Clear();
ReportDataSet ds = new ReportDataSet();
TransactionOutDetails obj = new TransactionOutDetails();
DataTable datatable = obj.GetReportTransactionOut(transactionOutID);
// DataTable dt = ds.Tables["dtTransactionIn"];
ds.Tables["dtTransactionOut"].Merge(datatable);
rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtTransactionOut"]);
reportViewer1.LocalReport.DataSources.Add(rptDataSource);
reportViewer1.RefreshReport();
reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
if (cboReport.SelectedItem == "Report 1")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=1";
ReportDataSet.ReadXml(filePath);
}
else if (cboReport.SelectedItem == "Report 2")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=2";
ReportDataSet.ReadXml(filePath);
}
else if (cboReport.SelectedItem == "Report 3")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=3";
ReportDataSet.ReadXml(filePath);
}
else if (cboReport.SelectedItem == "Report 4")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=4";
ReportDataSet.ReadXml(filePath);
}
}
protected void chklDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
if (vcr != null)
{
vcr.Dispose();
}
vcr = new RequisitionCrystalReport();
conn = new SqlConnection("Data Source=DESKTOP-M8T503R\\SQLSERVER;Initial Catalog=ADTeam1;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework");
conn.Open();
string query = "SELECT [DepartmentName],[CategoryName],[Description],[OrderDate],[RequestedQty] FROM [ADTeam1].[dbo].[View_Requisition] where 1=2";
foreach (ListItem item in chklDepartment.Items)
{
if (item.Selected)
{
query = query + " or DepartmentName=" + "'" + item.Value + "'";
}
}
query = query + " and OrderDate >= DATEADD(MONTH,-3,GETDATE())";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
ReportDataSet rds = new ReportDataSet();
DataTable dataTable = rds.View_Requisition;
rds.EnforceConstraints = false;
da.Fill(dataTable);
conn.Close();
//RequisitionCrystalReport cr = new RequisitionCrystalReport();
vcr.SetDataSource(rds);
CrystalReportViewer1.ReportSource = vcr;
//ViewState["cr"] = cr;
}
private void LoadStockRep()
{
StockReport astockRep = new StockReport();
try
{
//Instantiate the dataset and table adapters
aDataSet = new ReportDataSet();
aStockAdapter = new ReportDataSetTableAdapters.StockReportTableAdapter();
//Fill the dataset
aStockAdapter.Fill(aDataSet.StockReport);
//Assign the filled dataset as the data source for the report
astockRep.SetDataSource(aDataSet);
//Set up the report viewer object on the form
//show the runtime report object
crvReports.ReportSource = astockRep;
}
catch (Exception ex)
{
//catch an exception thrown during data object intonation
//or report generation and display based on the dataset
MessageBox.Show("Data Error Encountered" + ex.ToString(), "ERROR");
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
string query = "SELECT a.Id,a.Account_Id,a.Name, d.Name as Account FROM AccountChart a inner join AccountDescription d on d.Account_Id = a.Account_Id";
con.Open();
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
//dgvData.DataSource = dt;
//dgvData.DataBind();
ReportDataSet reportDataSet = new ReportDataSet();
reportDataSet.Tables["Account"].Merge(dt);
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("AccountReport.rdlc");
ReportDataSource dataSource = new ReportDataSource("ReportDataSet", reportDataSet.Tables["Account"]);
ReportViewer1.LocalReport.EnableHyperlinks = true;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(dataSource);
ReportViewer1.LocalReport.Refresh();
}
}
}
public EventReportForm(MainDataContexts dataContexts,EventPlainInfo eventInfo)
{
InitializeComponent();
_dataSet=new ReportDataSet();
_dataContexts = dataContexts;
_eventInfo = eventInfo;
}
public static ReportDataSet GetReportData()
{
ReportDataSet dataset = new ReportDataSet();
ReportDataSet.Header_TransactionDataTable HeaderTable = dataset.Header_Transaction;
ReportDataSet.Detail_TransactionDataTable DetailTable = dataset.Detail_Transaction;
foreach (HeaderTransaction ht in db.HeaderTransactions)
{
DataRow HeaderRow = HeaderTable.NewRow();
HeaderRow["Transaction ID"] = ht.Id;
HeaderRow["User Name"] = ht.User.Name;
HeaderRow["Payment Type"] = ht.PaymentType.Type;
HeaderRow["Transaction Date"] = ht.Date;
HeaderTable.Rows.Add(HeaderRow);
foreach (DetailTransaction dt in ht.DetailTransactions)
{
DataRow DetailRow = DetailTable.NewRow();
DetailRow["Product Name"] = dt.Product.Name;
DetailRow["Product Price"] = dt.Product.Price;
DetailRow["Quantity"] = dt.Quantity;
DetailRow["Transaction ID"] = dt.TransactionID;
DetailTable.Rows.Add(DetailRow);
}
}
return(dataset);
}
private ReportDataSet GetReportHistory(List <HeaderTransaction> transactions)
{
ReportDataSet dataSet = new ReportDataSet();
var header = dataSet.HeaderTransactions;
var detail = dataSet.DetailTransactions;
foreach (var ht in transactions)
{
var headerTransaction = header.NewRow();
headerTransaction["TransactionID"] = ht.TransactionID;
headerTransaction["Username"] = ht.User.Name;
headerTransaction["Date"] = ht.Date;
header.Rows.Add(headerTransaction);
foreach (var dt in ht.DetailTransactions)
{
var detailTransaction = detail.NewRow();
detailTransaction["TransactionID"] = dt.TransactionID;
detailTransaction["ProductName"] = dt.Product.Name;
detailTransaction["Quantity"] = dt.Quantity;
detailTransaction["Price"] = dt.Product.Price;
detail.Rows.Add(detailTransaction);
}
}
return(dataSet);
}
private void LoadLowStockRep()
{
LowStockRep aLowStockRep = new LowStockRep();
try
{
//Instantiate the dataset and table adapters
aDataSet = new ReportDataSet();
aLowStockAdapter = new ReportDataSetTableAdapters.LowStockTableAdapter();
//Fill the dataset
// aStockAdapter.Adapter.SelectCommand = new System.Data.SqlClient.SqlCommand(AuntRosieApplication.Inventory.frmInventoryStock.reportSql);
aLowStockAdapter.Fill(aDataSet.LowStock);
//Assign the filled dataset as the data source for the report
aLowStockRep.SetDataSource(aDataSet);
//Set up the report viewer object on the form
//show the runtime report object
crvReports.ReportSource = aLowStockRep;
}
catch (Exception ex)
{
//catch an exception thrown during data object intonation
//or report generation and display based on the dataset
MessageBox.Show("Data Error Encountered" + ex.ToString(), "ERROR");
}
}
public AreaDetailReport(MainDataContexts dataContexts,Area reportedArea)
{
InitializeComponent();
_dataContexts = dataContexts;
_dataSet=new ReportDataSet();
_reportedArea = reportedArea;
}
public override global::System.Data.DataSet Clone()
{
ReportDataSet cln = ((ReportDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public CustomerSidesReport(MainDataContexts dataContexts,CustomerSidesSelection.CustomerInfo reportedCustomer, List<CustomerLink> reportedLinks)
{
InitializeComponent();
_dataContexts = dataContexts;
_reportedLinks = reportedLinks;
_dataSet=new ReportDataSet();
_reportedCustomer = reportedCustomer;
}
private void Form1_Load(object sender, EventArgs e)
{
btnSelect.TabStop = false;
btnSelect.FlatStyle = FlatStyle.Flat;
btnSelect.FlatAppearance.BorderSize = 0;
btnViewComment.TabStop = false;
btnViewComment.FlatStyle = FlatStyle.Flat;
btnViewComment.FlatAppearance.BorderSize = 0;
btnAddComment.TabStop = false;
btnAddComment.FlatStyle = FlatStyle.Flat;
btnAddComment.FlatAppearance.BorderSize = 0;
btnCancel.TabStop = false;
btnCancel.FlatStyle = FlatStyle.Flat;
btnCancel.FlatAppearance.BorderSize = 0;
btnSearch.TabStop = false;
btnSearch.FlatStyle = FlatStyle.Flat;
btnSearch.FlatAppearance.BorderSize = 0;
//using (StreamReader sr = new StreamReader("Settings.txt"))
//{
// while (sr.Peek() != -1)
// {
// this.BackColor = (sr.Read);
// }
//}
// combo box
cboReport.Items.Add("Report 1");
cboReport.Items.Add("Report 2");
cboReport.Items.Add("Report 3");
cboReport.Items.Add("Report 4");
//fill datagrid
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=1";
ReportDataSet.ReadXml(filePath);
dgvAll.DataSource = ReportDataSet;
ReportDataSet.Clear();
dgvAll.DataMember = "course";
dgvAll.Columns[0].HeaderText = "Course";
dgvAll.Columns[1].HeaderText = "Quater";
dgvAll.Columns[2].HeaderText = "Course Cost";
dgvAll.Columns[3].HeaderText = "Hours";
dgvAll.Columns[4].HeaderText = "Cost With Travel";
dgvAll.Columns[5].HeaderText = "Location";
dgvAll.Columns[6].HeaderText = "Number of Enrolements";
dgvAll.Columns[7].HeaderText = "Raw Total Cost";
dgvAll.Columns[8].HeaderText = "Total Cost With Travel";
dgvAll.Columns[9].HeaderText = "Total Hours";
}
/// <summary>
/// Adds the report properties.
/// </summary>
/// <param name="reportDataSet">
/// The report data set.
/// </param>
/// <param name="propertiesString">
/// The properties string.
/// </param>
private void AddReportProperties(ReportDataSet reportDataSet, string propertiesString)
{
string[] strings;
foreach (string propertery in propertiesString.Split(new[] { ';' }))
{
strings = propertery.Split(new[] { '=' });
reportDataSet.ReportServerProperties.Add(strings[0], strings[1]);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=search&query=" + txtSearch.Text;
ReportDataSet.ReadXml(filePath);
dgvAll.DataSource = ReportDataSet;
}
private static void GenerateBaseReport()
{
var dataSet = new ReportDataSet();
using (var report = new Report())
{
report.RegisterData(dataSet, true);
report.Save("report-base.frx");
}
}
/// <summary>
/// When overridden in a derived class, executes the task.
/// </summary>
/// <returns>
/// true if the task successfully executed; otherwise, false.
/// </returns>
public override bool Execute()
{
// Creates the new instances of the reporting services.
// Use the current users windows credentials to connect to the report server.
R2DeploymentManger r2DeploymentManger = new R2DeploymentManger(this.ReportServerURL);
ReportDataSet[] reportDataSets = new ReportDataSet[this.ShareDataSets.Length];
r2DeploymentManger.DeploymentMangerMessages += this.deploymentMangerMessages;
try
{
// loop through the array of reports.
for (int index = 0; index < this.ShareDataSets.Length; index++)
{
reportDataSets[index] = new ReportDataSet()
{
ShareDataSetName = this.ShareDataSets[index].GetMetadata("Filename"),
ShareDataSetFilePath = this.ShareDataSets[index].GetMetadata("FullPath"),
DataSource = this.ShareDataSets[index].GetMetadata("DataSource"),
DateSetFolder = this.ShareDataSets[index].GetMetadata("Folder"),
DocumentLibraryURL =
string.IsNullOrEmpty(this.ShareDataSets[index].GetMetadata("ReportDataSetNames"))
? null
: this.ShareDataSets[index].GetMetadata("DocumentLibraryURL")
};
string propertiesString = this.ShareDataSets[index].GetMetadata("ReportServerProperties");
if (!string.IsNullOrEmpty(propertiesString))
{
this.AddReportProperties(reportDataSets[index], propertiesString);
}
}
return(r2DeploymentManger.UploadShareDataSets(reportDataSets, this.DisableWarnings));
}
catch (Exception ex)
{
// catches the error and then reports out via msbuild.
this.BuildEngine.LogErrorEvent(
new BuildErrorEventArgs(
"Reporting",
"AddReports",
this.BuildEngine.ProjectFileOfTaskNode,
this.BuildEngine.LineNumberOfTaskNode,
this.BuildEngine.ColumnNumberOfTaskNode,
0,
0,
ex.Message,
string.Empty,
this.ToString()));
return(false);
}
}
private void Print()
{
LoadDeposits();
var myDataSet = new ReportDataSet();
var serNo = 1;
var selectedCompany = new CompanyService(true).GetCompany();
string datecaption = ReportUtility.GetEthCalendar(FilterStartDate, true) + "(" +
FilterStartDate.ToShortDateString() + ")";
if (FilterStartDate.Day != FilterEndDate.Day || FilterStartDate.Month != FilterEndDate.Month || FilterStartDate.Year != FilterEndDate.Year)
{
datecaption = "ከ " + datecaption + " እስከ " + ReportUtility.GetEthCalendar(FilterEndDate, true) + "(" +
FilterEndDate.ToShortDateString() + ")";
}
var returned = "";
if (SelectedCpoType.Value != 1)
{
returned = "የተመለሰበት ቀን";
}
foreach (var rentalPaymentDTO in RentDeposits)
{
var rentee = rentalPaymentDTO.Contrat.Rentee.DisplayName;
if (rentee.Length > 20)
{
rentee = rentee.Substring(0, 18) + "...";
}
myDataSet.RentalPayment.Rows.Add(
serNo,
SelectedCpoType.Display,
datecaption,
rentalPaymentDTO.DepositedDateStringAmharicFormatted,
rentalPaymentDTO.Contrat.Room.Number,
rentee,
"",
0.0, 0.0, 0.0,
0.0, 0.0,
rentalPaymentDTO.TotalDepositAmount,
rentalPaymentDTO.ReturnedDateStringAmharicFormatted,
0, 0.0, returned, "", "", "", selectedCompany.Header, null, "");
serNo++;
}
var myReport4 = new DepositList();
myReport4.SetDataSource(myDataSet);
var report = new ReportViewerCommon(myReport4);
report.Show();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
ReportDataSet ds = new ReportDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void generatebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (fundcb.SelectedValue == null)
{
MessageBox.Show("Please select fund");
}
else if (String.IsNullOrEmpty(startdatedp.Text) || String.IsNullOrEmpty(enddatedp.Text))
{
MessageBox.Show("Please select start date and end date");
}
else
{
int accountId = (int)fundcb.SelectedValue;
ImusCityHallEntities db = new ImusCityHallEntities();
if (db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Count() <= 0)
{
MessageBox.Show("There are no record in this selection");
return;
}
var result = db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Where(m => m.Status == "Created");
ReportDataSet ds = new ReportDataSet();
ds.Locale = CultureInfo.InvariantCulture;
DataTable checkRegisterList = ds.Tables["CheckRegisterDataTable"];
foreach (var checkregister in result)
{
DataRow dr = checkRegisterList.Rows.Add();
dr.SetField("FundName", checkregister.FundName);
dr.SetField("Branch", checkregister.Branch);
dr.SetField("AccountNumber", checkregister.AccountNumber);
dr.SetField("BankName", checkregister.BankName);
dr.SetField("DateCreated", checkregister.DateCreated);
dr.SetField("CheckNo", checkregister.CheckNo);
dr.SetField("CompanyName", checkregister.CompanyName);
dr.SetField("Amount", checkregister.Amount);
dr.SetField("AmountInWords", checkregister.AmountInWords);
dr.SetField("Status", checkregister.Status);
}
ReportDocument report;
report = new CheckDisbursement.Report.CheckRegisterReport();
report.SetDataSource(checkRegisterList);
report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID));
reportviewer.ViewerCore.ReportSource = report;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
/// <summary>
/// Gets supported reports data.
/// </summary>
/// <param name="request">The request with locale and settings.</param>
/// <returns><see cref="ReportDataSet"/> object.</returns>
private SingleEntityDataServiceResponse <ReportDataSet> GetSupportedReportData(GetSupportedReportsDataRequest request)
{
DataTable reportResults = this.GetReportsConfiguration(request.RequestContext, null, request.QueryResultSettings);
// Get localized strings for the report.
if (this.LocalizedStrings == null)
{
this.LocalizedStrings = this.GetLocalizedReportsStrings(request.RequestContext, request.QueryResultSettings);
}
// Localize results and convert them to report data set.
ReportDataSet dataSet = this.CreateReportsListDataSetFromTable(reportResults, request.RequestContext.LanguageId);
return(new SingleEntityDataServiceResponse <ReportDataSet>(dataSet));
}
public EquipmentListReport(EquipmentList reportedList)
{
InitializeComponent();
_dataSet=new ReportDataSet();
_reportedList = reportedList;
_reportParameters = new List<ReportParameter>()
{
new ReportParameter("ListType", _reportedList.ListType.ToString()),
new ReportParameter("ListState", _reportedList.ListState ? @"" : @"Архивный"),
new ReportParameter("ListName", _reportedList.Description),
new ReportParameter("UserName", _reportedList.Access_Users.Description),
new ReportParameter("CreationDate", _reportedList.CreationDate.ToShortDateString()),
new ReportParameter("SortBy", 0.ToString())
};
}
public static string SavePDF(XtraReportDefaultTemplate xreport, ReportDataSet dSet, string pReportsPath, bool pIsWebPortalCall = false)
{
// Set PDF-specific export options.
//string reportPath = Directory.GetCurrentDirectory();
//string reportPath = ConfigurationManager.AppSettings["PdfReportsPath"].ToString(); // for debugging purposes only
//if (pIsWebPortalCall)
//string reportPath = ConfigManager.AppSettings["PdfReportsPath"].ToString();
if (!pIsWebPortalCall) {
if (!Directory.Exists(@"C:\BrightVision"))
Directory.CreateDirectory(@"C:\BrightVision");
if (!Directory.Exists(@"C:\BrightVision\PdfReports"))
Directory.CreateDirectory(@"C:\BrightVision\PdfReports");
}
string fileName = "";
ReportDataSet dSetClone = new ReportDataSet();
foreach (DataRow row in dSet.account.Rows) {
if (row.RowState == DataRowState.Deleted)
continue;
dSetClone = (ReportDataSet)dSet.Copy();
var dset = dSetClone.account.Select(String.Format("NOT(account_id={0})", row["account_id"]));
foreach (var rowD in dset)
rowD.Delete();
dSetClone.AcceptChanges();
fileName = String.Format(@"{0}\{1}_{2}_{3}.pdf",
pReportsPath,
row["company_name"].ToString().Replace(" ", "_").Replace(":", "_").Replace("/", "").Replace(@"\", ""),
DateTime.Now.ToString("yyyy-MM-dd"),
Guid.NewGuid().ToString()
);
}
var report = xreport.CloneReport() as XtraReportDefaultTemplate;
report.ReportHeader.Controls.Clear();
PdfExportOptions pdfOptions = report.ExportOptions.Pdf;
pdfOptions.Compressed = true;
pdfOptions.ImageQuality = PdfJpegImageQuality.Low;
report.DataSource = dSetClone;
report.ExportToPdf(fileName);
return fileName;
}
/// <summary>
/// The execute method which is call msbuild to run the task
/// </summary>
/// <returns>
/// <c>true</c> if successful ; otherwise, <c>false</c>.
/// </returns>
public override bool Execute()
{
R2DeploymentManger r2DeploymentManger = new R2DeploymentManger(this.ReportServerURL);
r2DeploymentManger.DeploymentMangerMessages += this.deploymentMangerMessages;
ReportDataSet[] reportDataSets = new ReportDataSet[this.ShareDataSets.Length];
try
{
// loop through the array of reports.
for (int index = 0; index < this.ShareDataSets.Length; index++)
{
reportDataSets[index] = new ReportDataSet
{
DateSetFolder = this.ShareDataSets[index].GetMetadata("Folder"),
ShareDataSetName = this.ShareDataSets[index].GetMetadata("Filename"),
ReportDataSetNames =
string.IsNullOrEmpty(this.ShareDataSets[index].GetMetadata("ReportDataSetNames"))
? null
: this.ShareDataSets[index].GetMetadata("ReportDataSetNames").Split(new[] { ';' }),
DocumentLibraryURL =
string.IsNullOrEmpty(this.ShareDataSets[index].GetMetadata("DocumentLibraryURL"))
? string.Empty
: this.ShareDataSets[index].GetMetadata("DocumentLibraryURL")
};
}
return(r2DeploymentManger.SetReportDataSet(
this.ReportItem, this.DocumentLibraryURL, this.Recursive, reportDataSets, this.UseMatchCase));
}
catch (Exception ex)
{
this.BuildEngine.LogErrorEvent(
new BuildErrorEventArgs(
"Reporting",
"SetReportDataSet",
this.BuildEngine.ProjectFileOfTaskNode,
this.BuildEngine.LineNumberOfTaskNode,
this.BuildEngine.ColumnNumberOfTaskNode,
0,
0,
ex.Message,
string.Empty,
this.ToString()));
return(false);
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
//string query = "SELECT a.Id,a.Account_Id,a.Name, d.Name as Account FROM AccountChart a inner join AccountDescription d on d.Account_Id = a.Account_Id";
string query = @"SELECT TOP 500 [EmployeeNo]
,[EmployeeName]
,[FatherName]
,[Gender]
,[HouseNo]
,[Area]
,[City]
,[Designation]
,[NIC]
,[PhoneNo]
,[MobileNo]
,[Email]
,[Nationality]
,[MaritalStatus]
,[AppointmentDate]
,[ConfirmationDate]
,[BirthDate]
,[Department]
,[RosterType]
,[TransportMode]
FROM [TimeAX].[dbo].[HRTEmployee]";
con.Open();
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
//dgvData.DataSource = dt;
//dgvData.DataBind();
ReportDataSet reportDataSet = new ReportDataSet();
reportDataSet.Tables["Employee"].Merge(dt);
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/EmployeesReport.rdlc");
ReportDataSource dataSource = new ReportDataSource("ReportDataSet", reportDataSet.Tables["Employee"]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(dataSource);
}
}
}
/// <summary>
/// Creates report list from data table.
/// </summary>
/// <param name="reportListTable">Report list data table.</param>
/// <param name="locale">Current locale.</param>
/// <returns>Report list dataset.</returns>
private ReportDataSet CreateReportsListDataSetFromTable(DataTable reportListTable, string locale)
{
ThrowIf.Null(reportListTable, "Data table output is empty.");
string query, reportTitle, parameters, type, charts;
bool hasTotalRow = false;
bool hasDisclaimer = false;
bool isUserBasedReport = false;
using (DataTable listOfReports = new DataTable())
{
listOfReports.Columns.Add(ColumnReportId, typeof(string));
listOfReports.Columns.Add(ColumnReportTitle, typeof(string));
listOfReports.Columns.Add(ColumnParameters, typeof(string));
listOfReports.Columns.Add(ColumnCharts, typeof(string));
foreach (DataRow dr in reportListTable.Rows)
{
DataRow newRow = listOfReports.NewRow();
newRow[ColumnReportId] = dr[ColumnReportId].ToString();
this.GetReportDetailsFromXml(
dr[ColumnReportDefinitionXml].ToString(),
out query,
out reportTitle,
out parameters,
out type,
out charts,
out hasTotalRow,
out hasDisclaimer,
out isUserBasedReport);
newRow[ColumnReportTitle] = reportTitle;
newRow[ColumnParameters] = parameters;
newRow[ColumnCharts] = charts;
listOfReports.Rows.Add(newRow);
}
ReportDataSet reportListSet = new ReportDataSet()
{
Output = this.ConvertDataTableToCollection(listOfReports),
Locale = locale
};
return(reportListSet);
}
}
private static void GenerateReportFromData()
{
var dataset = new ReportDataSet();
{
DataTable personInformation = dataset.Tables["PersonInformation"];
DataRow row = personInformation.NewRow();
row["Name"] = "Arlindo Cruz";
row["SkillFinalResult"] = 3.4534445M;
row["QualitativeFinalResult"] = 2.123334M;
row["Box"] = "3A";
row["BoxDescription"] =
@"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Arcu felis bibendum ut tristique et egestas quis ipsum. Amet justo donec enim diam vulputate ut. A cras semper auctor neque vitae tempus. Elementum integer enim neque volutpat ac tincidunt vitae semper quis. Netus et malesuada fames ac turpis egestas. Scelerisque purus semper eget duis at tellus. Tortor vitae purus faucibus ornare suspendisse sed nisi. Eget felis eget nunc lobortis mattis aliquam. Mi in nulla posuere sollicitudin aliquam. Odio facilisis mauris sit amet massa vitae tortor condimentum lacinia. Accumsan lacus vel facilisis volutpat est velit egestas. Vel quam elementum pulvinar etiam non quam lacus suspendisse.";
personInformation.Rows.Add(row);
}
{
DataTable skillResult = dataset.Tables["SkillResult"];
(string skillName, decimal auto, decimal peer, decimal byLeader, decimal toLeader, decimal total)[] skill = new[]
public static void PrintCredit(CreditViewModel model, ServiceClient repository)
{
ReportDataSet dsRep = new ReportDataSet();
ReportDataSet.CreditDTRow dsCreditDtRowRow = dsRep.CreditDT.NewCreditDTRow();
dsCreditDtRowRow.Fio = model.UserName;
dsCreditDtRowRow.Data = model.DataStart;
dsCreditDtRowRow.SummaFull = model.SummaFull.ToString();
dsCreditDtRowRow.Stavka = model.Stavka.ToString();
dsCreditDtRowRow.TermMonth = model.TermMonth.ToString();
dsCreditDtRowRow.IdCredit = model.Id.ToString();
dsRep.CreditDT.Rows.Add(dsCreditDtRowRow);
List <Payment> payments = repository.GetPaymentsByIdCredit(model.Id).ToList();
foreach (var item in payments)
{
ReportDataSet.PaymentDTRow dsPaymentDtRow = dsRep.PaymentDT.NewPaymentDTRow();
dsPaymentDtRow.IdCredit = model.Id.ToString();
dsPaymentDtRow.NumberMonth = item.NumberMonth.ToString();
dsPaymentDtRow.Data = item.Data;
dsPaymentDtRow.LostSumma = item.LostSumma.ToString();
dsPaymentDtRow.MainPay = item.MainPay.ToString();
dsPaymentDtRow.Percent = item.Percent.ToString();
dsPaymentDtRow.SummaMonth = item.SummaMonth.ToString();
dsRep.PaymentDT.Rows.Add(dsPaymentDtRow);
}
using (FastReport.Report report = new FastReport.Report())
{
report.StoreInResources = true;
report.Load("Report\\CreditReport.frx");
report.RegisterData((DataTable)dsRep.CreditDT, "CreditInfoList");
report.GetDataSource("CreditInfoList").Enabled = true;
report.RegisterData((DataTable)dsRep.PaymentDT, "PaymentList");
report.GetDataSource("PaymentList").Enabled = true;
//report.Design();
report.Show();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Set the processing mode for the ReportViewer to Local
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/rdlc/Report1.rdlc");
//report.ReportPath = @"Report\rdlc\Report1.rdlc";
LocalReport report = ReportViewer1.LocalReport;
// 準備資料來源
ReportDataSet ds = new ReportDataSet();
ds.Account.AddAccountRow("id01", "id01", "id01", "2012/12/12", "12:34", "測試");
ds.Account.AddAccountRow("id02", "id02", "id02", "2012/12/12", "12:34", "測試");
// 更新UI
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource("Account", (DataTable)ds.Account));
}
}
protected override void Dispose(bool disposing)
{
try {
if (disposing)
{
if (components != null)
{
components.Dispose();
}
if (BooksTableAdapter != null)
{
BooksTableAdapter.Dispose();
}
if (ReportDataSet != null)
{
ReportDataSet.Dispose();
}
}
} finally {
base.Dispose(disposing);
}
}
private bool ContainsRowData(ReportDataSet.CustomDataRow x, ReportDataSet.CustomDataRow y)
{
string[] xa = new string[6]
{
x.IsColumn1Null() ? "" : x.Column1,
x.IsColumn2Null() ? "" : x.Column2,
x.IsColumn3Null() ? "" : x.Column3,
x.IsColumn4Null() ? "" : x.Column4,
x.IsColumn5Null() ? "" : x.Column5,
x.IsColumn6Null() ? "" : x.Column6
};
string[] ya = new string[6]
{
y.IsColumn1Null() ? "" : y.Column1,
y.IsColumn2Null() ? "" : y.Column2,
y.IsColumn3Null() ? "" : y.Column3,
y.IsColumn4Null() ? "" : y.Column4,
y.IsColumn5Null() ? "" : y.Column5,
y.IsColumn6Null() ? "" : y.Column6
};
return !xa.Except(ya).Any() & ya.Except(xa).Any();
}
private void showReport()
{
try
{
string query = "Select * from Product";// where Product_Name = '" + txtName.Text +"' ";
con.Open();
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
//GridView1.DataSource = dt;
//GridView1.DataBind();
//ReportParameterCollection reportParameters = new ReportParameterCollection();
//reportParameters.Add(new ReportParameter("Name", "test"));
ReportDataSet reportDataSet = new ReportDataSet();
reportDataSet.Tables["Product"].Merge(dt);
ReportViewer1.ProcessingMode = ProcessingMode.Local;
//ReportViewer1.LocalReport.ReportEmbeddedResource = "~/Reports/NewProductReport.rdlc";
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/NewProductReport.rdlc");
//ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/ProdReport.rdlc");
ReportDataSource dataSource = new ReportDataSource("ReportDataSet", reportDataSet.Tables["Product"]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(dataSource);
//ReportViewer1.LocalReport.SetParameters(reportParameters);
this.ReportViewer1.LocalReport.Refresh();
}
}
}
catch (Exception ex)
{
throw;
}
}
private void showReport()
{
try
{
string query = "Select * from Product";// where Product_Name = '" + txtName.Text +"' ";
con.Open();
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
dgvData.DataSource = dt;
dgvData.DataBind();
ReportDataSet reportDataSet = new ReportDataSet();
reportDataSet.Tables["Product"].Merge(dt);
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("ProductReport.rdlc");
ReportDataSource dataSource = new ReportDataSource("ReportDataSet", reportDataSet.Tables["Product"]);
//ReportParameterCollection reportParameters = new ReportParameterCollection();
//reportParameters.Add(new ReportParameter("@Account", Request.QueryString[1].ToString()));
//ReportViewer1.LocalReport.SetParameters(reportParameters);
//ReportParameter p1 = new ReportParameter("Account", "Test Account");
//ReportViewer1.ShowParameterPrompts = true;
//ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1 });
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(dataSource);
ReportViewer1.LocalReport.Refresh();
}
}
}
catch (Exception ex)
{
throw;
}
}
public ReportUserDesigner(ReportDataSet dataset)
{
InitializeComponent();
xreport = XtraReportDefault.CreateXtraReportDefaultTemplate(dataset);
additional_data_report_templates _item = m_efDbModel.additional_data_report_templates.FirstOrDefault(i => i.is_default == true);
if (_item != null) {
if (!string.IsNullOrEmpty(_item.layout_config)) {
MemoryStream _stream = new MemoryStream();
StreamWriter _writer = new StreamWriter(_stream, Encoding.Default);
_writer.Write(_item.layout_config);
_writer.Flush();
_stream.Position = 0;
xreport.LoadLayout(_stream);
}
}
this.LoadDefault();
}
public PerAbonentsSelect()
{
InitializeComponent();
_dataSet=new ReportDataSet();
}
public static XtraReportDefaultTemplate CreateXtraReportDefaultTemplate(ReportDataSet reportDataset)
{
XtraReportDefaultTemplate rdt = new XtraReportDefaultTemplate();
rdt.DataSource = reportDataset;
return rdt;
}
public EquipmentTypesReport(List<EquipmentTypesItem> reportedItems)
{
InitializeComponent();
_dataSet = new ReportDataSet();
_reportedItems = reportedItems;
}
public virtual int Fill(ReportDataSet.LineLaborHourReportSourceDataTable dataTable, System.DateTime 日期, System.DateTime 日期1) {
this.Adapter.SelectCommand = this.CommandCollection[0];
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(日期));
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(日期1));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public AllEventsReportForm(MainDataContexts dataContexts)
{
InitializeComponent();
_dataContexts = dataContexts;
_dataSet = new ReportDataSet();
}
private ReportViewer LoadReport(ReportSearchParams reportSearchModel)
{
#region Server Report
//ReportViewer reportViewer = new ReportViewer();
//reportViewer.ProcessingMode = ProcessingMode.Remote;
//reportViewer.SizeToReportContent = true;
//reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
//reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
//reportViewer.ServerReport.ReportPath = string.Format(ColorTrend.Common.GetAppKeyValue("ReportsPath"), reportName);
//reportViewer.ServerReport.ReportServerUrl = new Uri(ColorTrend.Common.GetAppKeyValue("ReportServerName"));
//reportViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials(ColorTrend.Common.GetAppKeyValue("ReportServerUser"), ColorTrend.Common.GetAppKeyValue("ReportServerPassword"), "");
#endregion
string reportName = "";
if (reportSearchModel == null || string.IsNullOrEmpty(reportSearchModel.ReportName))
{
reportName = "Empty";
}
else
{
reportName = reportSearchModel.ReportName;
}
#region Local Report
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
//TODO: To use our report path
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + string.Format(@"Reports\{0}.rdlc", reportName);
//TODO: To get datasource as per report;
reportViewer.LocalReport.DataSources.Clear();
// string value = SessionManagement.CurrentLang.ToString();
string value = SessionManagement.Language;
string lang = "EN";//default lang
if (value != "")
{
lang = value;
}
//TODO: Globalisation Of Reports
switch (reportName)
{
case "EmployeePresence":
ReportDataSet dsEP = new ReportDataSet();
usp_GetEmployeePresence1TableAdapter daEP = new usp_GetEmployeePresence1TableAdapter();
dsEP.EnforceConstraints = false;
daEP.Fill(dsEP.usp_GetEmployeePresence1, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
List<ReportParameter> parmE = new List<ReportParameter>();
DataTable dtEP = dsEP.Tables["usp_GetEmployeePresence1"];
ReportDataSource rptDataSourceEP = new ReportDataSource("GetEmployeePresence", dtEP);
reportViewer.LocalReport.DataSources.Add(rptDataSourceEP);
ReportParameter[] EmployeePresenceParm = new ReportParameter[]{
new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("EmployeePresence", new CultureInfo(lang))),
new ReportParameter("Date",Resources.Resource.ResourceManager.GetString("Date", new CultureInfo(lang))),
new ReportParameter("Start",Resources.Resource.ResourceManager.GetString("Start", new CultureInfo(lang))),
new ReportParameter("Stop",Resources.Resource.ResourceManager.GetString("Stop", new CultureInfo(lang)))
};
reportViewer.LocalReport.SetParameters(EmployeePresenceParm);
break;
case "EmployeeSms":
ReportDataSet dsES = new ReportDataSet();
usp_GetEmployeeSMSTableAdapter daES = new usp_GetEmployeeSMSTableAdapter();
dsES.EnforceConstraints = false;
daES.Fill(dsES.usp_GetEmployeeSMS, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
List<ReportParameter> parmES = new List<ReportParameter>();
DataTable dtES = dsES.Tables["usp_GetEmployeeSMS"];
ReportDataSource rptDataSourceES = new ReportDataSource("Getsms", dtES);
reportViewer.LocalReport.DataSources.Add(rptDataSourceES);
break;
case "ListCustomers":
ReportDataSet ds = new ReportDataSet();
usp_GetCustomersTableAdapter da = new usp_GetCustomersTableAdapter();
da.Fill(ds.usp_GetCustomers, SessionManagement.FactoryID, reportSearchModel.FilterSearch);
DataTable dt = ds.Tables["usp_GetCustomers"];
ReportDataSource rptDataSource = new ReportDataSource("GetCustomers", dt);
reportViewer.LocalReport.DataSources.Add(rptDataSource);
ReportParameter[] parm = new ReportParameter[]{
new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("ListCustomers", new CultureInfo(lang))),
new ReportParameter("Number",Resources.Resource.ResourceManager.GetString("Number", new CultureInfo(lang))),
new ReportParameter("CustomerName",Resources.Resource.ResourceManager.GetString("CustomerName", new CultureInfo(lang))),
new ReportParameter("Phone",Resources.Resource.ResourceManager.GetString("Phone", new CultureInfo(lang))),
new ReportParameter("Address",Resources.Resource.ResourceManager.GetString("Address", new CultureInfo(lang)))
};
reportViewer.LocalReport.SetParameters(parm);
break;
}
reportViewer.LocalReport.Refresh();
#endregion
return reportViewer;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
ReportDataSet ds = new ReportDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "ReportTableDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public CustomerPortTypesReport(List<CustomerTypesItem> reportedItems)
{
InitializeComponent();
_dataSet = new ReportDataSet();
_reportedItems = reportedItems;
}
private void load_rpt_FILE(String reportName, String storeName, Dictionary<string, string> paramerter,
Dictionary<string, string> parameterReport = null
, String hasValue = "false", String title = "Tiêu đề", String isPrintTemp = "False",
String isExportExcel = "False")
{
//ReportDB.exportDataToExcel("ABC", null, "OIUYTR");
//return;
AssetMangement.GenerateData.ConnectData sqlData = new AssetMangement.GenerateData.ConnectData();
if (hasValue == "True")
{
foreach (KeyValuePair<string, string> pair in paramerter)
{
sqlData.Paramerters.Add("@" + pair.Key);
sqlData.ParametersType.Add(SqlDbType.VarChar);
sqlData.ParamertersValue.Add(pair.Value);
}
}
// add paramerters cho store proc
rpds_demo = new ReportDataSet();
bool isLoad = sqlData.Read_Store(storeName, true);
if (isExportExcel == "True" || isExportExcel == "true")
{
// HyperLink1.NavigateUrl = HttpContext.Current.Request.PhysicalApplicationPath + "ReportPages/";
// return;
string tieude = Request["TitleName"];
DataTable dt = new DataTable();
string reportNameWithoutExtension = reportName.Substring(0, reportName.IndexOf('.'));
dt = sqlData.DataSource;
Dictionary<string, string> listNewColumnName = ReportDB.ReadXML(reportNameWithoutExtension);
if (listNewColumnName == null)
{
Label1.Text = "Lỗi đọc XML";
return;
}
foreach (KeyValuePair<string, string> pair in listNewColumnName)
{
// values += "&" + pair.Key + "=" + pair.Value;
// check name load from xml
if (dt.Columns.Contains(pair.Key) && !dt.Columns.Contains(pair.Value))
dt.Columns[pair.Key].ColumnName = pair.Value;
}
// string path = ReportDB.SaveAs(reportNameWithoutExtension);
string path = HttpContext.Current.Request.PhysicalApplicationPath + "ReportPages/" + reportNameWithoutExtension + ".xls";
bool isComplete = ReportDB.exportDataToExcel(tieude, dt, path);
Label1.Text = "Xuất file excel cho report " + tieude;
if (isComplete)
{
Label1.Text += " thành công ! ";// + "<a id=\"linkdownload\" href=\"" + path + "\">Tải file</a>";
HyperLink1.NavigateUrl = "../" + reportNameWithoutExtension + ".xls";
HyperLink1.Text = "Tải file";
// System.Diagnostics.Process.Start(path);
}
else
Label1.Text += " thất bại !";
// Label1.Text = System.Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\" + "reportName" + ".xls";
return;
}
try
{
if (isLoad)
{
try
{
DataTable dt = sqlData.DataSource;
if (isPrintTemp.Equals("True"))
dt = getDataPrintTemp(dt, parameterReport.First().Value);
dt.TableName = "Newrpt";
rpds_demo.Tables.Add(dt);
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
else
{
Label1.Text = "Không kết nối được";
}
}
catch (Exception ex)
{
Label1.Text = "Lỗi data: " + ex.Message;
return;
}
finally
{
GC.Collect();
}
try
{
string reportPath = Server.MapPath("/Reports/Management/" + reportName);
cryRpt = new ReportDocument();
cryRpt.Load(reportPath);
cryRpt.SummaryInfo.ReportTitle = title;
cryRpt.SetDataSource(rpds_demo.Tables["Newrpt"]);
if (parameterReport.Count > 0)
{
foreach (KeyValuePair<string, string> pair in parameterReport)
{
ParameterDiscreteValue pa = new ParameterDiscreteValue();
pa.Value = pair.Value;
ParameterFieldDefinition crParameterFieldDefinition = cryRpt.DataDefinition.ParameterFields[pair.Key];
crParameterFieldDefinition.CurrentValues.Clear();
crParameterFieldDefinition.CurrentValues.Add(pa);
crParameterFieldDefinition.ApplyCurrentValues(crParameterFieldDefinition.CurrentValues);
}
}
//cryRpt.PrintOptions.PrinterName = "Fax";
//cryRpt.PrintToPrinter(1, false, 0, 0);
//CrystalReportViewer.ReportSource = cryRpt;
//System.Drawing.Printing.PrintDocument pDoc = new System.Drawing.Printing.PrintDocument();
// CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings();
//System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings();
// printerSettings.PrinterName = "Default printer";
// don't use this, use the new button
//PrintLayout.Scaling = PrintLayoutSettings.PrintScaling.DoNotScale;
//System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings);
//rpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = false;
//cryRpt.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex;
//System.Drawing.Printing.PageSettings pageSettings = new System.Drawing.Printing.PageSettings(printerSettings);
//if (cryRpt.DefaultPageSettings.PaperSize.Height > cryRpt.DefaultPageSettings.PaperSize.Width)
//{
// cryRpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
// rptClientDoc.PrintOutputController.ModifyPaperOrientation(CrPaperOrientationEnum.crPaperOrientationPortrait);
//}
//else
//{
// cryRpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
// //rptClientDoc.PrintOutputController.ModifyPaperOrientation(CrPaperOrientationEnum.crPaperOrientationLandscape);
//}
//cryRpt.PrintToPrinter(printerSettings, pageSettings, false, PrintLayout);
CrystalReportViewer.ReportSource = cryRpt;
}
catch (Exception exr)
{
Label1.Text = "Lỗi parameter Report: " + exr.Message;
return;
}
finally
{
GC.Collect();
}
// ReportDB.exportDataToExcel("demo", sqlData.DataSource);
}
public static void SavePDFPerAccount(XtraReportDefaultTemplate xreport, ReportDataSet dSet)
{
FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
string reportPath = string.Empty;
if (folderBrowserDialog.ShowDialog() == DialogResult.OK) {
foreach (DataRow row in dSet.account.Rows) {
if (row.RowState == DataRowState.Deleted)
continue;
var dSetClone = (ReportDataSet)dSet.Copy();
var dset = dSetClone.account.Select(String.Format("NOT(account_id={0})", row["account_id"]));
foreach (var rowD in dset)
rowD.Delete();
dSetClone.AcceptChanges();
reportPath = folderBrowserDialog.SelectedPath;
string fileName = String.Format(@"{0}\{1}_{2}_{3}.pdf",
reportPath,
row["company_name"].ToString().Replace(" ", "_").Replace(":", "_").Replace("/", "").Replace(@"\", ""),
DateTime.Now.ToString("yyyy-MM-dd"),
Guid.NewGuid().ToString()
);
//string fileName = String.Format("{0}\\{1}_{2}.pdf", reportPath, row["company_name"].ToString().Replace(" ", "_").Replace(":", "_"), DateTime.Now.ToString("yyyy-MM-dd_HH_mm_ss"));
var report = xreport.CloneReport() as XtraReportDefaultTemplate;
report.ReportHeader.Controls.Clear();
PdfExportOptions pdfOptions = report.ExportOptions.Pdf;
pdfOptions.Compressed = true;
pdfOptions.ImageQuality = PdfJpegImageQuality.Low;
report.DataSource = dSetClone;
report.ExportToPdf(fileName);
}
DialogResult _dlg = MessageBox.Show(
string.Format("Successfully generated reports.{0}Would you like to open the folder where the reports are saved?", Environment.NewLine),
"Brightvision Reports",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question
);
if (_dlg == DialogResult.Yes)
System.Diagnostics.Process.Start(folderBrowserDialog.SelectedPath);
}
}
private void load_rpt_FILE(String reportName, String storeName, Dictionary <string, string> paramerter,
Dictionary <string, string> parameterReport = null
, String hasValue = "false", String title = "Tiêu đề", String isPrintTemp = "False",
String isExportExcel = "False")
{
//ReportDB.exportDataToExcel("ABC", null, "OIUYTR");
//return;
AssetMangement.GenerateData.ConnectData sqlData = new AssetMangement.GenerateData.ConnectData();
if (hasValue == "True")
{
foreach (KeyValuePair <string, string> pair in paramerter)
{
sqlData.Paramerters.Add("@" + pair.Key);
sqlData.ParametersType.Add(SqlDbType.VarChar);
sqlData.ParamertersValue.Add(pair.Value);
}
}
// add paramerters cho store proc
rpds_demo = new ReportDataSet();
bool isLoad = sqlData.Read_Store(storeName, true);
if (isExportExcel == "True" || isExportExcel == "true")
{
// HyperLink1.NavigateUrl = HttpContext.Current.Request.PhysicalApplicationPath + "ReportPages/";
// return;
string tieude = Request["TitleName"];
DataTable dt = new DataTable();
string reportNameWithoutExtension = reportName.Substring(0, reportName.IndexOf('.'));
dt = sqlData.DataSource;
Dictionary <string, string> listNewColumnName = ReportDB.ReadXML(reportNameWithoutExtension);
if (listNewColumnName == null)
{
Label1.Text = "Lỗi đọc XML";
return;
}
foreach (KeyValuePair <string, string> pair in listNewColumnName)
{
// values += "&" + pair.Key + "=" + pair.Value;
// check name load from xml
if (dt.Columns.Contains(pair.Key) && !dt.Columns.Contains(pair.Value))
{
dt.Columns[pair.Key].ColumnName = pair.Value;
}
}
// string path = ReportDB.SaveAs(reportNameWithoutExtension);
string path = HttpContext.Current.Request.PhysicalApplicationPath + "ReportPages/" + reportNameWithoutExtension + ".xls";
bool isComplete = ReportDB.exportDataToExcel(tieude, dt, path);
Label1.Text = "Xuất file excel cho report " + tieude;
if (isComplete)
{
Label1.Text += " thành công ! ";// + "<a id=\"linkdownload\" href=\"" + path + "\">Tải file</a>";
HyperLink1.NavigateUrl = "../" + reportNameWithoutExtension + ".xls";
HyperLink1.Text = "Tải file";
// System.Diagnostics.Process.Start(path);
}
else
{
Label1.Text += " thất bại !";
}
// Label1.Text = System.Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\" + "reportName" + ".xls";
return;
}
try
{
if (isLoad)
{
try
{
DataTable dt = sqlData.DataSource;
if (isPrintTemp.Equals("True"))
{
dt = getDataPrintTemp(dt, parameterReport.First().Value);
}
dt.TableName = "Newrpt";
rpds_demo.Tables.Add(dt);
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
else
{
Label1.Text = "Không kết nối được";
}
}
catch (Exception ex)
{
Label1.Text = "Lỗi data: " + ex.Message;
return;
}
finally
{
GC.Collect();
}
try
{
string reportPath = Server.MapPath("/Reports/Management/" + reportName);
cryRpt = new ReportDocument();
cryRpt.Load(reportPath);
cryRpt.SummaryInfo.ReportTitle = title;
cryRpt.SetDataSource(rpds_demo.Tables["Newrpt"]);
if (parameterReport.Count > 0)
{
foreach (KeyValuePair <string, string> pair in parameterReport)
{
ParameterDiscreteValue pa = new ParameterDiscreteValue();
pa.Value = pair.Value;
ParameterFieldDefinition crParameterFieldDefinition = cryRpt.DataDefinition.ParameterFields[pair.Key];
crParameterFieldDefinition.CurrentValues.Clear();
crParameterFieldDefinition.CurrentValues.Add(pa);
crParameterFieldDefinition.ApplyCurrentValues(crParameterFieldDefinition.CurrentValues);
}
}
//cryRpt.PrintOptions.PrinterName = "Fax";
//cryRpt.PrintToPrinter(1, false, 0, 0);
//CrystalReportViewer.ReportSource = cryRpt;
//System.Drawing.Printing.PrintDocument pDoc = new System.Drawing.Printing.PrintDocument();
// CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings();
//System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings();
// printerSettings.PrinterName = "Default printer";
// don't use this, use the new button
//PrintLayout.Scaling = PrintLayoutSettings.PrintScaling.DoNotScale;
//System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings);
//rpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = false;
//cryRpt.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex;
//System.Drawing.Printing.PageSettings pageSettings = new System.Drawing.Printing.PageSettings(printerSettings);
//if (cryRpt.DefaultPageSettings.PaperSize.Height > cryRpt.DefaultPageSettings.PaperSize.Width)
//{
// cryRpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
// rptClientDoc.PrintOutputController.ModifyPaperOrientation(CrPaperOrientationEnum.crPaperOrientationPortrait);
//}
//else
//{
// cryRpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
// //rptClientDoc.PrintOutputController.ModifyPaperOrientation(CrPaperOrientationEnum.crPaperOrientationLandscape);
//}
//cryRpt.PrintToPrinter(printerSettings, pageSettings, false, PrintLayout);
CrystalReportViewer.ReportSource = cryRpt;
}
catch (Exception exr)
{
Label1.Text = "Lỗi parameter Report: " + exr.Message;
return;
}
finally
{
GC.Collect();
}
// ReportDB.exportDataToExcel("demo", sqlData.DataSource);
}
public CableSelect()
{
InitializeComponent();
_dataSet=new ReportDataSet();
}
private void PopulateAreasData(IEnumerable<Area> areas, int level, ReportDataSet.CustomDataRow currentRow)
{
foreach (Area area in areas)
{
ReportDataSet.CustomDataRow localRow = currentRow ?? _dataSet.CustomData.NewCustomDataRow();
if (area.ParentArea == null)
localRow = _dataSet.CustomData.NewCustomDataRow();
localRow["Column" + level] = area.Description;
if (area.ChildAreas.Any())
PopulateAreasData(area.ChildAreas, level + 1, localRow);
ReportDataSet.CustomDataRow addRow = _dataSet.CustomData.NewCustomDataRow();
addRow.ItemArray = localRow.ItemArray;
string fieldName = "Column" + (level + 1);
if (!DBNull.Value.Equals(addRow[fieldName]))
{
for (int i = level + 1; i < 6; i++)
{
addRow["Column" + i] = null;
}
}
_dataSet.CustomData.AddCustomDataRow(addRow);
}
}
public ReportUserDesigner(ReportDataSet dataset, string layoutConfig)
{
//xreport = XtraReportDefault.CreateXtraReport(dataset);
MemoryStream _stream = new MemoryStream();
StreamWriter _writer = new StreamWriter(_stream, Encoding.Default);
_writer.Write(layoutConfig);
_writer.Flush();
_stream.Position = 0;
//xreport.LoadLayoutFromXml(_stream);
xreport.LoadLayout(_stream);
xreport.DataSource = dataset;
InitializeComponent();
}
public virtual int Fill(ReportDataSet.FinishedWorksheetReportSourceDataTable dataTable, global::System.Nullable<global::System.DateTime> 開始日期, global::System.Nullable<global::System.DateTime> 結束日期) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((開始日期.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(開始日期.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((結束日期.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(結束日期.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int _userid = (int)Session["user_id"];
string name = "";
int i = 0;
ReportDataSet _rds = new ReportDataSet();
//DataTable _dt;
if (Request.QueryString["pid"] != null)
{
name = Request.QueryString["pid"];
switch (name)
{
case "daviskw":
rptView.Reset();
rptView.LocalReport.ReportPath = "reports/daviskw.rdlc";
rptView.LocalReport.DataSources.Clear();
DataTable dtkw = _rds.Tables["davistest-kw"];
var _kws = ServiceFactory.wms_kuweiservice.LoadEntities(p => p.IsDelete == false);
DataRow drkw;
foreach (wms_kuwei _pr in _kws)
{
drkw = dtkw.NewRow();
drkw["kuwei"] = _pr.Mingcheng;
drkw["huojia"] = _pr.Huojia;
drkw["lei"] = _pr.Lieshu;
drkw["ceng"] = _pr.Censhu;
dtkw.Rows.Add(drkw);
}
rptView.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", _rds.Tables["davistest-kw"]));
break;
case "personrights":
rptView.Reset();
rptView.LocalReport.ReportPath = "reports/rptQuanxian.rdlc";
rptView.LocalReport.DataSources.Clear();
DataTable dtqx = _rds.Tables["Quanxian"];
var personrights = ServiceFactory.auth_quanxianservice.GetPersonRightsFirst(_userid);
i = 0;
DataRow drqx;
foreach (auth_personrights _pr in personrights)
{
i++;
drqx = dtqx.NewRow();
drqx["id"] = i;
drqx["rolename"] = _pr.rolename;
drqx["username"] = _pr.fullname;
drqx["module"] = _pr.module;
drqx["name"] = _pr.name;
drqx["control"] = _pr.controller;
drqx["function"] = _pr.function;
dtqx.Rows.Add(drqx);
}
rptView.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", _rds.Tables["Quanxian"]));
break;
default:
break;
}
}
}
}
public virtual int Fill(ReportDataSet.UnfinishedWorksheetReportSourceDataTable dataTable, System.DateTime 開始日期, System.DateTime 結束日期, bool 輸出全部) {
this.Adapter.SelectCommand = this.CommandCollection[0];
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(開始日期));
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(結束日期));
this.Adapter.SelectCommand.Parameters[2].Value = ((bool)(輸出全部));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public WorkTotalReportSelect()
{
InitializeComponent();
_dataSet=new ReportDataSet();
}
public virtual int Fill(ReportDataSet.UnitPriceReportDataTable dataTable, global::System.Nullable<global::System.DateTime> 實際完成日, global::System.Nullable<global::System.DateTime> 實際完成日1) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((實際完成日.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(實際完成日.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((實際完成日1.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(實際完成日1.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
ReportDataSet ds = new ReportDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "InspectListReportDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public AreasReport(MainDataContexts dataContexts)
{
InitializeComponent();
_dataSet=new ReportDataSet();
_dataContexts = dataContexts;
}
private void ReportMultiesTable()
{
try
{
Dictionary<string, Dictionary<string, string>> LstValues = new Dictionary<string, Dictionary<string, string>>();
Dictionary<string, string> parameters = new Dictionary<string, string>();
Dictionary<string, string> ParametersReport = new Dictionary<string, string>();
string key_compare = "pfrp_";
string storeKey = "_stna_";
int _index = 0;
string storeName ="";
string _keyParam = "";
foreach (String key in Request.QueryString.AllKeys)
{
if (key != "ReportName" && key != "StoreName" && key != "IsMuiltiesStore"
&& key != "HasValue" && key != "TitleName" && key != "IsPrintTemp"
&& key != "IsExportExcel" && key != "PathExport" && key != "IsExportExcelOld" && key != "IsExportNew" && key != "TypeExport"
)
{
//Lenght Key > 5 char
if (key.Substring(0, key_compare.Length).Equals(key_compare))
ParametersReport.Add(key.Substring(
key_compare.Length
, key.Length - key_compare.Length), Request[key]);
else
{
_index = key.IndexOf(storeKey);
storeName = key.Substring(0,_index);
_keyParam = key.Substring(_index + 6, key.Length - _index - 6);
if (!LstValues.ContainsKey(storeName))
LstValues.Add(storeName, new Dictionary<string, string>());
LstValues[storeName].Add(_keyParam, Request[key]);
}
}
}
//Goi load report
AssetMangement.GenerateData.ConnectData sqlData = new AssetMangement.GenerateData.ConnectData();
rpds_demo = new ReportDataSet();
try
{
foreach (var store_name in LstValues.Keys)
{
sqlData.Paramerters = new List<string>();
sqlData.ParametersType = new List<SqlDbType>();
sqlData.ParamertersValue = new List<string>();
if (Request["HasValue"] == "True")
{
foreach (KeyValuePair<string, string> pair in LstValues[store_name])
{
sqlData.Paramerters.Add("@" + pair.Key);
sqlData.ParametersType.Add(SqlDbType.VarChar);
sqlData.ParamertersValue.Add(pair.Value);
}
}
//add paramerters cho store proc
//rpds_demo = new ReportDataSet();
bool isLoad = sqlData.Read_Store(store_name, true);
if (isLoad)
{
try
{
DataTable dt = sqlData.DataSource;
dt.TableName = storeKey + store_name;
rpds_demo.Tables.Add(dt);
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
else
{
Label1.Text = "Không kết nối được";
}
}
}
catch (Exception ex)
{
Label1.Text = "Lỗi data: " + ex.Message;
return;
}
finally
{
GC.Collect();
}
try
{
string reportPath = Server.MapPath("/Reports/Management/" + Request["ReportName"]);
cryRpt = new ReportDocument();
cryRpt.Load(reportPath);
cryRpt.SummaryInfo.ReportTitle = Request["TitleName"];
foreach (var keyStoreName in LstValues.Keys)
{
//reportDocument.OpenSubreport("rptSubReport1.rpt").SetDataSource(dt1);
// reportDocument.OpenSubreport("rptSubReport2JNR.rpt").SetDataSource(dt2);
cryRpt.Database.Tables[keyStoreName].SetDataSource(rpds_demo.Tables[storeKey + keyStoreName]);
}
if (ParametersReport.Count > 0)
{
foreach (KeyValuePair<string, string> pair in ParametersReport)
{
ParameterDiscreteValue pa = new ParameterDiscreteValue();
pa.Value = pair.Value;
ParameterFieldDefinition crParameterFieldDefinition = cryRpt.DataDefinition.ParameterFields[pair.Key];
crParameterFieldDefinition.CurrentValues.Clear();
crParameterFieldDefinition.CurrentValues.Add(pa);
crParameterFieldDefinition.ApplyCurrentValues(crParameterFieldDefinition.CurrentValues);
}
}
CrystalReportViewer.ReportSource = cryRpt;
}
catch (Exception exr)
{
Label1.Text = "Lỗi parameter Report: " + exr.Message;
return;
}
finally
{
GC.Collect();
}
}
catch (Exception ex)
{
Label1.Text = "Lỗi:" + ex.Message;
return;
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
ReportDataSet ds = new ReportDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
