private void frmReport_Load(object sender, EventArgs e)
{
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
string[] Account = help.GetAccount().Split(' ');
crConnectionInfo.ServerName = Account[0];
crConnectionInfo.DatabaseName = Account[1];
crConnectionInfo.UserID = Account[2];
object pwd = Account[3];
crConnectionInfo.Password=(pwd.ToString());
//---------Xét account truy cập vào các table
CrTables = rpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
//----------set resource---------------
rpt.SetParameterValue("tu",tu);
rpt.SetParameterValue("den", den);
cryRViewer.ReportSource = rpt;
cryRViewer.Refresh();
}
private void bPreview_Click(object sender, EventArgs e)
{
//System.Data.SqlClient.SqlDataReader SqlReader = null;
DataTable DT = new DataTable();
DataRow dr = DT.NewRow();
string d1,d2 ;
DateTime dt1 = DateTime.Parse(dateTimePicker1.Text);
int Year1 = dt1.Year;
int Month1 = dt1.Month;
int day1 = dt1.Day;
DateTime dt2 = DateTime.Parse(dateTimePicker2.Text);
int Year2 = dt2.Year;
int Month2 = dt2.Month;
int day2 = dt2.Day;
if (Year1 > 2500)
{
d1 = (Year1 - 543).ToString() + "-" + Month1.ToString("00") + "-" + day1.ToString("00");
d2 = (Year2 - 543).ToString() + "-" + Month2.ToString("00") + "-" + day2.ToString("00");
}
else {
d1 = Year1.ToString() + "-" + Month1.ToString("00") + "-" + day1.ToString("00");
d2 = Year2.ToString() + "-" + Month2.ToString("00") + "-" + day2.ToString("00");
}
string sql = "select h.staff_code as id ,p.first_name +' '+p.last_name name, sum(h.pdf_page) page, ";
sql += " convert(varchar(10),h.create_on,103) date ";
sql += " from scan_history h inner join personal p ";
sql += " on h.staff_code =p.staff_code ";
sql += " where convert(varchar(10),h.create_on,120) between '" + d1 + "' and '" + d2 + "' ";
sql += " group by h.staff_code, p.first_name, p.last_name, convert(varchar(10),h.create_on,103)";
sql += " order by h.staff_code";
Func.Master.ScanHistoryFunc fnc = new Func.Master.ScanHistoryFunc();
DT = fnc.GetDataBySql(sql);
if (DT.Rows.Count > 0)
{
TableLogOnInfo logonInfo = new TableLogOnInfo();
logonInfo.ConnectionInfo.DatabaseName = Config.DbGetDbName;
logonInfo.ConnectionInfo.ServerName = Config.DbGetDataSource;
logonInfo.ConnectionInfo.UserID = Config.DbGetUserID;
logonInfo.ConnectionInfo.Password = Config.DbGetPwd;
SummaryReport rpt = new SummaryReport();
frmPrintPreview frm = new frmPrintPreview();
rpt.SetDataSource(DT);
rpt.Database.Tables[0].ApplyLogOnInfo(logonInfo);
frm.crystalReportViewer1.ReportSource = rpt;
frm.StartPosition = FormStartPosition.CenterScreen;
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
}
public static TableLogOnInfos ConectaCrystal()
{
TableLogOnInfos Infos = new TableLogOnInfos();
TableLogOnInfo Info = new TableLogOnInfo();
ConnectionInfo cn = new ConnectionInfo();
cn.ServerName = "CCLSQL";
cn.DatabaseName = "materia_prima";
cn.UserID = "matprima";
cn.Password = "******";
cn.Type = ConnectionInfoType.SQL;
cn.IntegratedSecurity = false;
Info.ConnectionInfo = cn;
Infos.Add(Info);
return Infos;
}
public Reporte(string paramServidor, string paramUsuario, string paramContraseña, string paramBaseDatos, string paramRuta, string paramNombreArchivo, string paramNombreReporte, HttpResponse paramPagina)
{
conexionBaseDatos = new TableLogOnInfo();
reporte = new ReportDocument();
conexionBaseDatos.ConnectionInfo.ServerName = paramServidor;
conexionBaseDatos.ConnectionInfo.UserID = paramUsuario;
conexionBaseDatos.ConnectionInfo.Password = paramContraseña;
conexionBaseDatos.ConnectionInfo.DatabaseName = paramBaseDatos;
reporte.Load(paramRuta + paramNombreArchivo);
nombreReporte = paramNombreReporte;
reporte.Database.Tables[0].ApplyLogOnInfo(conexionBaseDatos);
pagina = paramPagina;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Admin/Login.aspx");
}
else
{
//load crystal report
ReportDocument Report = new ReportDocument();
Report.Load(Server.MapPath("Sales_Return.rpt "));
//this.CrystalReportSource1.Report.FileName = Server.MapPath("Sales_order.rpt");
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo.ConnectionInfo.ServerName = "USER-3924AC2E56";
logOnInfo.ConnectionInfo.DatabaseName = "MyData";
logOnInfo.ConnectionInfo.UserID = "sa";
logOnInfo.ConnectionInfo.Password = "******";
//对报表中的每个表进行循环
for (int i = 0; i < Report.Database.Tables.Count; i++)
{
Report.Database.Tables[i].ApplyLogOnInfo(logOnInfo);
}
//load param
//CrystalDecisions.Web.Parameter param = new CrystalDecisions.Web.Parameter();
//param.Name = "OrderID";
//param.DefaultValue = Request.QueryString["TextBoxId"].ToString().Trim();
//add param
//this.CrystalReportSource1.Report.Parameters.Add(param);
ParameterValues ParamValues = new ParameterValues();
ParameterDiscreteValue ParamValue = new ParameterDiscreteValue();
ParamValue.Value = Request.QueryString["TextBoxId"].ToString().Trim();
ParamValues.Add(ParamValue);
Report.DataDefinition.ParameterFields[0].ApplyCurrentValues(ParamValues);
//bind
this.CrystalReportViewer1.ReportSource = Report;
//this.CrystalReportViewer1.ReportSourceID = this.CrystalReportSource1.ID;
//關閉左邊
this.CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
//強制安裝ActiveX
CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX;
this.CrystalReportViewer1.DataBind();
}
}
public static CrystalDecisions.Windows.Forms.CrystalReportViewer ViewReport(string reportName, List<KeyValuePair<string, object>> Param_Values)
{
ReportDocument _reportDocument = new ReportDocument();
CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables crTables;
// load report
_reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName);
// set report Connection info
string[] LoginData = ConfigurationManager.ConnectionStrings["Local"].ConnectionString.ToString().Split(';');
if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "")
crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString();
crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString();
crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1];
crConnectionInfo.ServerName = LoginData[0].Split('=')[1];
crTables = _reportDocument.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in crTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
_reportDocument.Refresh();
// set report Parameter
if (Param_Values != null)
{
foreach (KeyValuePair<string, object> Param_Value in Param_Values)
{
// _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value);
_reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value);
}
}
crystalReportViewer1.ReportSource = _reportDocument;
crystalReportViewer1.Refresh();
crystalReportViewer1.Name = "crystalReportViewer1";
return crystalReportViewer1;
}
private void load_db(CrystalReportPass crystal)
{
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = "127.0.0.1";
crConnectionInfo.DatabaseName = "";
crConnectionInfo.UserID = "basdat";
crConnectionInfo.Password = "******";
CrTables = crystal.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
}
public static bool Print(string reportName, int copies, List<KeyValuePair<string, object>> Param_Values)
{
ReportDocument _reportDocument = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
bool status = false;
_reportDocument.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Reports\\" + reportName);
string[] LoginData = ConfigurationManager.ConnectionStrings["Production"].ConnectionString.ToString().Split(';');
if (!string.IsNullOrEmpty(LoginData[3].ToString()) && LoginData[3].ToString() != "")
crConnectionInfo.Password = LoginData[3].Split('=')[1].ToString();
crConnectionInfo.UserID = LoginData[2].Split('=')[1].ToString();
crConnectionInfo.DatabaseName = LoginData[1].Split('=')[1];
crConnectionInfo.ServerName = LoginData[0].Split('=')[1];
CrTables = _reportDocument.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
_reportDocument.Refresh();
// set report Parameter
if (Param_Values != null)
{
foreach (KeyValuePair<string, object> Param_Value in Param_Values)
{
// _reportDocument.SetParameterValue("SalesHeaderID",Param_Value.Value);
_reportDocument.SetParameterValue((string)Param_Value.Key, (object)Param_Value.Value);
}
}
for (int i = 0; i < copies; i++)
{
_reportDocument.PrintToPrinter(1, true, 0, 0);
status = true;
}
return status;
}
private static void DataBaseLogIn(ReportDocument rpt)
{
ConnectionInfo con_info = new ConnectionInfo();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
Tables crTables;
con_info.ServerName = Connection().DataSource;
con_info.DatabaseName = Connection().InitialCatalog;
con_info.UserID = Connection().UserID;
con_info.Password = Connection().Password;
crTables = rpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
crtableLogoninfo = crTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = con_info;
crTable.ApplyLogOnInfo(crtableLogoninfo);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer_DownloadFiles.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
ReportDocument rptDoc = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
// Tables CrTables;
crConnectionInfo.ServerName = objDbAccess.strServer;
crConnectionInfo.DatabaseName = objDbAccess.strDbName;
crConnectionInfo.UserID = objDbAccess.strUser;
crConnectionInfo.Password = objDbAccess.strPassword;
UserList ds = new UserList(); // .xsd file name
DataTable dt = new DataTable();
// Just set the name of data table
dt.TableName = "DownloadHistory";
dt = objReports.GetDownloadReports(); //This function is located below this function
ds.Tables[0].Merge(dt);
// Your .rpt file path will be below
rptDoc.Load(Server.MapPath("~/Reports/ListDownload.rpt"));
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in rptDoc.Database.Tables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
// crtableLogoninfo.ConnectionInfo = crConnectionInfo;
//set dataset to the report viewer.
rptDoc.SetDataSource(ds);
CrystalReportViewer_DownloadFiles.ReportSource = rptDoc;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["repname"] != null && Request.QueryString["param"] != null)
{
reportDoc = new ReportDocument();
reportDoc.Load(Server.MapPath(Request.QueryString["repname"]));
string param = Request.QueryString["param"];
int index = -1;
index = param.IndexOf("|");
if (index == -1)
AssignParam(param);
else
{
string[] temp = param.Split('|');
foreach (string prtemp in temp)
{
AssignParam(prtemp);
}
}
//set connection
TableLogOnInfo logonInfo = new TableLogOnInfo();
logonInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["DB_SERVER"].ToString().Trim();
logonInfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["DB_USER"].ToString().Trim();
logonInfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["DB_PASSWORD"].ToString();
crViewer.LogOnInfo.Add(logonInfo);
crViewer.EnableDatabaseLogonPrompt = false;
crViewer.EnableDrillDown = false;
crViewer.DisplayGroupTree = false;
crViewer.HasToggleGroupTreeButton = false;
crViewer.ReportSource = reportDoc;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//====================================================================================
// GENERATE REPORT
//====================================================================================
//ATM REPORT
CrystalDecisions.Shared.TableLogOnInfo li;
//Print Purposes
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
//SET VALUES FIRST
string type, comp, stat;
if (cmbLoanType.SelectedValue.ToString() == "ALL")
{
type = "";
}
else
{
type = cmbLoanType.SelectedValue.ToString();
}
if (cmbCompany.SelectedValue.ToString() == "ALL COMPANY")
{
comp = "";
}
else
{
comp = cmbCompany.SelectedValue.ToString();
}
if (cmbStatus.SelectedValue.ToString() == "ALL STATUS")
{
status = "('FOR APPROVAL','APPROVED','DISAPPROVED','RELEASED','FBA','CANCELLED','FOR RELEASE','FOR POSTING')";
}
else
{
status = "('" + cmbStatus.SelectedValue.ToString() + "')";
}
//=====================================================================================
// STRING QUERY BUILDER
//=====================================================================================
str = "select * From vw_LoanReport WHERE Loan_No Like '%" + txtLoanNo.Text + "%' and Loan_Type Like '%" + type + "%' and Company Like '%" + comp + "%' and Status in " + status + " and Name like '%" + txtName.Text + "%' and [Encoded By] like '%" + txtEncodedBy.Text + "%' and [Date Encoded] Between '" + dtFrom.Text + "' and '" + dtTo.Text + "'";
SqlDataAdapter adapter = new SqlDataAdapter(str, con);
DataTable checkDT = new DataTable();
adapter.Fill(checkDT);
if (checkDT.Rows.Count == 0)
{
Alert.show("No record(s) found.", Alert.AlertType.error);
return;
}
DataTable dt = new DataTable();
DataSet ds = new DataSet();
ReportsForms.loanReport cr = new ReportsForms.loanReport();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
adapter.Fill(ds, "vw_LoanReport");
dt = ds.Tables["vw_LoanReport"];
cr.SetDataSource(ds.Tables["vw_LoanReport"]);
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
//Setup Parameters
cr.SetParameterValue("from", dtFrom.Text);
cr.SetParameterValue("to", dtTo.Text);
cr.SetParameterValue("PrintedBy", Classes.clsUser.Username);
cr.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
crystalReportViewer1.ReportSource = cr;
}
}
void LoadReport()
{
ProjectID = "All";
BlockNo = "All";
StatusCode = -1;
Type = "All";
Category = "All";
try
{
this.Cursor = Cursors.WaitCursor;
ReportDocument cryRpt = new ReportDocument();
ReportObjects crReportObjects;
SubreportObject crSubreportObject;
ReportDocument crSubreportDocument;
Database crDatabase;
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
string s = "";
if (this.reportType == ReportType.UnitStatus)
{
s = Application.StartupPath + @"\Reports\UnitStatus.rpt";
}
else if (this.reportType == ReportType.UnitStatusCount)
{
s = Application.StartupPath + @"\Reports\UnitStatusCount.rpt";
}
//else if (this.reportType == ReportType.GRN)
//{ s = Application.StartupPath + @"\Reports\GRNMainReport.rpt"; }
//else if (this.reportType == ReportType.GIN)
//{ s = Application.StartupPath + @"\Reports\GINMainReport.rpt"; }
cryRpt.Load(s);
ConnectionInfo connInfo = new ConnectionInfo();
SqlConnectionStringBuilder builder = new DataAccess().GetCredentials();
crConnectionInfo.ServerName = builder.DataSource;
crConnectionInfo.DatabaseName = builder.InitialCatalog;
crConnectionInfo.UserID = builder.UserID;
crConnectionInfo.Password = builder.Password;
Sections ReportSections = cryRpt.ReportDefinition.Sections;
foreach (Section section in ReportSections)
{
crReportObjects = section.ReportObjects;
foreach (ReportObject crReportObject in crReportObjects)
{
if (crReportObject.Kind != ReportObjectKind.SubreportObject)
{
continue;
}
crSubreportObject = (SubreportObject)crReportObject;
crSubreportDocument = crSubreportObject.OpenSubreport(crSubreportObject.SubreportName);
crDatabase = crSubreportDocument.Database;
CrTables = crDatabase.Tables;
foreach (Table CrTable in CrTables)
{
TableLogOnInfo crTableLogOnInfo = CrTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crTableLogOnInfo);
}
}
}
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
if (this.reportType == ReportType.UnitStatus)
{
cryRpt.SetParameterValue("@ProjectID", this.ProjectID);
cryRpt.SetParameterValue("@BlockNo", this.BlockNo);
cryRpt.SetParameterValue("@StatusCode", this.StatusCode);
cryRpt.SetParameterValue("@Category", this.Category);
cryRpt.SetParameterValue("@Type", this.Type);
}
else if (this.reportType == ReportType.UnitStatusCount)
{
cryRpt.SetParameterValue("@ProjectID", this.ProjectID);
}
//else if (this.reportType == ReportType.GIN)
//{
// cryRpt.SetParameterValue("@docnmbr", this.strDocumentNumber);
//}
rptViewer.ReportSource = cryRpt;
rptViewer.Refresh();
}
catch { }
this.Cursor = Cursors.Arrow;
}
//Строка входящих параметров
//0-DTBeg
//1-DTEnd
//2-NameObj
//3-RazmA
//4-RazmR
public InitReports(string NameReport, NodeProp nodeProp, string listPars, string notes, DBToolKit dbWork)
{
Notes = notes;
//IdNode = nodeProp.IdParent;
IdMeter= nodeProp.IdObject;
IdAccount=nodeProp.IdObject;
string[] ListPars = listPars.Split('#');
DTBeg = ListPars[0];
DateTimeBeg = Convert.ToDateTime(DTBeg);
DTEnd = ListPars[1];
DateTimeEnd = Convert.ToDateTime(DTEnd);
NameObj = ListPars[2];
typeTree = Convert.ToInt32( ListPars[3]);
DecimalPoint = Convert.ToInt32( ListPars[4]);
FontSize = Convert.ToInt32( ListPars[5]);
try
{
StartHour = Convert.ToInt32(ListPars[6]);
}
catch { }
// SetStartHour(0);
//if(ListPars.Length==7)
//listobject = ListPars[6];
// RazmR = ListPars[4];
crConnectionInfo = new ConnectionInfo();
crConnectionInfo.ServerName = dbWork.ReturnIDFromConnString("datasource");
crConnectionInfo.DatabaseName = dbWork.ReturnIDFromConnString("initialcatalog");
crConnectionInfo.UserID = dbWork.ReturnIDFromConnString("userid");
crConnectionInfo.Password = dbWork.ReturnIDFromConnString("password");
//DataSet ds = new DataSet();
//SqlDataAdapter da;
string query = "";
string Capt;
string Razm = "";
switch(NameReport)
{
case "График часовой":
if (NameObj.ToLower().IndexOf("небаланс") != -1)
{
query = String.Format("select * from fGetBalanceForGroupByProfileByDeltaByOutDelta({0}, {1}, \'{2}\', \'{3}\', \'{4}\')", nodeProp.IdObject,
60, "-", DTBeg, DTEnd);
Otchreport = new Simple.Reports.SumGroupFrofileDelta();
Razm = "";
}
else
{
query = "select * from fGetSumGroup(" + nodeProp.IdObject + ", 17, " + (int)nodeProp.IdType + ", 1" +
", \'" + DTBeg + "\', " + "\'" + DTEnd + "\'" + ")";
Otchreport = new Simple.Reports.SumGroupFrofile();
SetTotalVis("true");
Razm =", кВт*ч/кВар*ч";
}
if (DateTime.Parse(DTBeg).AddDays(1) == DateTime.Parse(DTEnd))
{
Capt = NameObj + "\r\n" + "Часовой график" + Razm + " за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy");
}
else
{
Capt = NameObj + "\r\n" + "Часовой график" + Razm + " с " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy");
}
SetDecimalPoint();
SetFontSize();
SetTitle(Capt);
break;
case "График получасовой":
if(DateTime.Parse(DTBeg).AddDays(1)==DateTime.Parse(DTEnd))
{
Capt = NameObj+"\r\n"+ "Получасовой график, кВт/кВар за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy");
}
else
{
Capt = NameObj + "\r\n" + "Получасовой график, кВт/кВар c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy");
}
query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 1730, "+(int)nodeProp.IdType+", 1"+
", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")";
Otchreport = new Simple.Reports.SumGroupFrofile();
SetTitle(Capt);
SetDecimalPoint();
SetFontSize();
SetTotalVis("false");
break;
case "График суточный -10 дней":
DTEnd = DateTime.Parse(DTBeg).AddDays(10).ToString();
Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy");
query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 1"+
", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")";
Otchreport = new Simple.Reports.SumGroupFrofile();
SetTotalVis("true");
SetDecimalPoint();
SetFontSize();
SetTitle(Capt);
break;
case "График суточный -20 дней":
DTEnd = DateTime.Parse(DTBeg).AddDays(20).ToString();
Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy");
query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 1"+
", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")";
Otchreport = new Simple.Reports.SumGroupFrofile();
SetTitle(Capt);
SetDecimalPoint();
SetFontSize();
SetTotalVis("true");
break;
case "График суточный -месяц":
DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString();
if(DateTime.Parse(DTBeg).Day>=28)
Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч за " + DateTime.Parse(DTEnd).ToString("MMMM yyyy");
else
Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч за " + DateTime.Parse(DTBeg).ToString("MMMM yyyy");
query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 1"+
", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")";
Otchreport = new Simple.Reports.SumGroupFrofile();
SetTotalVis("true");
SetDecimalPoint();
SetFontSize();
SetTitle(Capt);
break;
case "График суточный(SUM) -месяц":
DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString();
if(DateTime.Parse(DTBeg).Day>=28)
Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч накопительный за " + DateTime.Parse(DTEnd).ToString("MMMM yyyy");
else
Capt = NameObj + "\r\n" + "Суточный график, кВт*ч/кВар*ч накопительный за " + DateTime.Parse(DTBeg).ToString("MMMM yyyy");
query = "select * from fGetSumGroup(" +nodeProp.IdObject+", 12, "+(int)nodeProp.IdType+", 11"+
", \'"+DTBeg+"\', "+"\'"+DTEnd+"\'"+")";
Otchreport = new Simple.Reports.SumGroupFrofile();
SetTitle(Capt);
SetDecimalPoint();
SetFontSize();
SetTotalVis("false");
break;
case "Основной-дублирующий":
switch (nodeProp.IdType)
{
case TypeObject.account:
case TypeObject.accountOV:
case TypeObject.accountTech:
//SetRazmA("%");
//SetRazmR("%");
query = String.Format("select * from MRDMGetVerificationTotal({0} ,\'{1}\', \'{2}\', \'{3}\')",
nodeProp.IdObject, nodeProp.IdType.ToString(), DTBeg, DTEnd);
break;
}
Otchreport = new Simple.Reports.Verification();
SetTitle(String.Format("Верификация учета {0}\r\nОсновной-Дублирующий", NameObj));
//SetNotes(Notes);
SetFontSize();
SetDecimalPoint();
//SetDTBeg();
break;
case"Профиль нагрузки получасовой":
switch(nodeProp.IdType)
{
case TypeObject.account:
case TypeObject.virtualAccount:
case TypeObject.accountOV:
case TypeObject.accountTech:
case TypeObject.oik:
case TypeObject.itec:
case TypeObject.oppositeLine:
case TypeObject.manual:
SetRazmA("кВт");
SetRazmR("кВар");
query = String.Format("select * from MRDMGetAcProfileHalfHour({0} ,\'{1}\', \'{2}\', \'{3}\')",
nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour));
break;
case TypeObject.meter:
case TypeObject.meterReserve:
switch (typeTree)
{
case 0:
SetRazmA("Вт");
SetRazmR("Вар");
query = "select *, 192 as \'quality\' from MRDMGetProfileHalfHour(" + nodeProp.IdParent + ", " + nodeProp.IdObject +
", \'" + DateTimeBeg.AddHours(StartHour) + "\', \'" + DateTimeEnd.AddHours(StartHour) + "\')";
break;
case 1:
SetRazmA("кВт");
SetRazmR("кВар");
query = String.Format("select * from MRDMGetAcProfileHalfHour({0} , \'{1}\', \'{2}\', \'{3}\')",
nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour));
break;
}
break;
}
Otchreport = new Simple.Reports.Profnag_sut30M();
SetTitle(NameObj);
SetNotes(Notes);
SetStartHour(StartHour);
SetFontSize();
SetDTBeg();
break;
case"Профиль нагрузки часовой":
switch(nodeProp.IdType)
{
case TypeObject.account:
case TypeObject.virtualAccount:
case TypeObject.accountOV:
case TypeObject.accountTech:
case TypeObject.oik:
case TypeObject.itec:
case TypeObject.oppositeLine:
case TypeObject.manual:
SetRazmA("кВт");
SetRazmR("кВар");
query = String.Format("select * from MRDMGetAcProfileHour({0} , \'{1}\', \'{2}\', \'{3}\')",
nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour));
break;
case TypeObject.meter:
case TypeObject.meterReserve:
switch (typeTree)
{
case 0:
SetRazmA("Вт");
SetRazmR("Вар");
query = "select * , 192 as \'quality\' from MRDMGetProfileHour (" + nodeProp.IdParent + ", " + nodeProp.IdObject +
", \'" + DateTimeBeg.AddHours(StartHour) + "\', \'" + DateTimeEnd.AddHours(StartHour) + "\')";
break;
case 1:
SetRazmA("кВт");
SetRazmR("кВар");
query = String.Format("select * from MRDMGetAcProfileHour({0} , \'{1}\', \'{2}\', \'{3}\')",
nodeProp.IdObject, nodeProp.IdType.ToString(), DateTimeBeg.AddHours(StartHour), DateTimeEnd.AddHours(StartHour));
break;
}
break;
}
Otchreport = new Simple.Reports.Profnag_sut60M();
SetNotes(Notes);
SetTitle(NameObj);
SetFontSize();
SetStartHour(StartHour);
SetDTBeg();
break;
case"Электроэнергия за сутки":
case"Электроэнергия за 10 дней":
case"Электроэнергия за 20 дней":
case"Электроэнергия за месяц":
switch(NameReport)
{
case"Электроэнергия за сутки":
DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString();
break;
case"Электроэнергия за 10 дней":
DTEnd = DateTime.Parse(DTBeg).AddDays(10).ToString();
break;
case"Электроэнергия за 20 дней":
DTEnd = DateTime.Parse(DTBeg).AddDays(20).ToString();
break;
case"Электроэнергия за месяц":
DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString();
break;
}
SetDTBeg();
SetTitle(NameObj);
SetDTEnd(DTEnd);
SetDecimalPoint();
SetFontSize();
switch(nodeProp.IdType)
{
case TypeObject.itec:
throw new Exception("Данный отчет не поддерживается - Подсистема отчетности");
case TypeObject.group:
switch (typeTree)
{
case 0:
Otchreport = new Simple.Reports.PotrebEnergy();
query = String.Format ("select * from fGetEnergyByGrouping ({0},\'{1}\', \'{2}\', \'{3}\', \'{4}\')",
nodeProp.IdObject, DTBeg , DTEnd , "кВт*ч", "кВар*ч");
break;
case 1:
Otchreport = new Simple.Reports.Potreb_account();
query = String.Format("select * from MRDMGetEnergyAccountByGrouping ({0}, \'{1}\', \'{2}\', \'{3}\', \'{4}\') order by Capt",
nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч");
break;
}
break;
case TypeObject.account:
case TypeObject.virtualAccount:
case TypeObject.accountOV:
case TypeObject.accountTech:
case TypeObject.oppositeLine:
Otchreport = new Simple.Reports.Potreb_account();
query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt",
"null", nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч");
break;
case TypeObject.oik:
Otchreport = new Simple.Reports.Potreb_account();
query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt",
-1, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч");
break;
case TypeObject.manual:
Otchreport = new Simple.Reports.Potreb_account();
query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt",
-2, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч");
break;
case TypeObject.meter:
Otchreport = new Simple.Reports.PotrebEnergy();
//query = "select * from fGetEnergy (null , null, " + nodeProp.IdObject + ", \'Meter\' " +
// ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')";
switch (typeTree)
{
case 0:
// Otchreport = new Simple.Reports.PotrebEnergy();
query = "select * from fGetEnergy (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", null, \'Meter\' " +
", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')";
break;
case 1:
query = "select * from fGetEnergy (null , null, " + nodeProp.IdObject + ", \'Meter\' " +
", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')";
//Otchreport = new Simple.Reports.Potreb_account();
//query = "select * from fGetEnergy (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", null, \'Meter\' " +
// ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')";
//query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt",
// (int)nodeProp.IdType * -1, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч");
break;
}
break;
case TypeObject.meterReserve:
Otchreport = new Simple.Reports.PotrebEnergy();
query = "select * from fGetEnergy (null , null, " + nodeProp.IdObject + ", \'MeterReserve\' " +
", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')";
//switch (typeTree)
//{
// case 0:
// Otchreport = new Simple.Reports.PotrebEnergy();
// query = "select * from fGetEnergy (" + nodeProp.IdParent + ", " + nodeProp.IdObject + ", \'Meter\' " +
// ", \'" + DTBeg + "\', \'" + DTEnd + "\', \'кВт*ч\', \'кВар*ч\')";
// break;
// case 1:
// Otchreport = new Simple.Reports.Potreb_account();
// query = String.Format("select * from MRDMGetEnergyAccount ({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\') order by Capt",
// (int)nodeProp.IdType * -1, nodeProp.IdObject, DTBeg, DTEnd, "кВт*ч", "кВар*ч");
// break;
//}
break;
case TypeObject.subst:
switch(typeTree)
{
case 0:
Otchreport = new Simple.Reports.PotrebEnergy();
query = "select * from fGetEnergy ("+nodeProp.IdObject+", "+" null, null,\'Meter\' "+
", \'"+ DTBeg+"\', \'"+DTEnd+"\', \'кВт*ч\', \'кВар*ч\')";
break;
case 1:Otchreport = new Simple.Reports.Potreb_account();
query = "select * from MRDMGetEnergyAccount (" + nodeProp.IdObject +
", null, \'"+ DTBeg+"\', \'"+DTEnd+"\', \'кВт*ч\', \'кВар*ч\')";
break;
}
break;
}
break;
case"Показания":
switch(nodeProp.IdType)
{
case TypeObject.meter:
case TypeObject.meterReserve:
/* if(listobject!="")
{
query = "select * from fGetDataPokazannew (\'"+listobject +"\', \'"+ DTBeg +"\')";
}else */
query = "select * from fGetDataPokazan ("+nodeProp.IdParent+", "+nodeProp.IdObject+
", \'"+ DTBeg +"\')";
break;
case TypeObject.subst:
query = "select * from fGetDataPokazan ("+nodeProp.IdObject+", null, \'"+ DTBeg +"\')";
break;
case TypeObject.group:
query = "select * from fGetDataPokazanByGrouping ("+nodeProp.IdObject+", \'"+ DTBeg +"\')";
break;
}
Otchreport = new Simple.Reports.Pokazn();
SetDTBeg();
SetDecimalPoint();
SetFontSize();
SetTitle(NameObj);
SetRazmA("кВт*ч");
SetRazmR("кВар*ч");
break;
case"Показания 5 минутные":
switch(nodeProp.IdType)
{
case TypeObject.meter:
query = "select * from fGetCurrentProfile ("+nodeProp.IdParent+", "+nodeProp.IdObject+
", \'"+DTBeg+"\', 5)";
break;
case TypeObject.subst:
query = "select * from fGetCurrentProfile ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 5)";
break;
}
Otchreport = new Simple.Reports.Potochni_5();
SetTitle(NameObj);
SetDTBeg();
SetDecimalPoint();
SetFontSize();
SetRazmA("кВт*ч");
SetRazmR("кВар*ч");
break;
case"Показания 30 минутные":
switch(nodeProp.IdType)
{
case TypeObject.meter:
query = "select * from fGetCurrentProfile ("+nodeProp.IdParent+", "+nodeProp.IdObject+
", \'"+DTBeg+"\', 30)";
break;
case TypeObject.subst:
query = "select * from fGetCurrentProfile ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 30)";
break;
}
Otchreport = new Simple.Reports.Potochni_5();
SetTitle(NameObj);
SetDTBeg();
SetFontSize();
SetDecimalPoint();
SetRazmA("кВт*ч");
SetRazmR("кВар*ч");
break;
case"Показания 60 минутные":
switch(nodeProp.IdType)
{
case TypeObject.meter:
query = "select * from fGetCurrentProfile ("+nodeProp.IdParent+", "+nodeProp.IdObject+
", \'"+DTBeg+"\', 60)";
break;
case TypeObject.subst:
query = "select * from fGetCurrentProfile ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 60)";
break;
}
Otchreport = new Simple.Reports.Potochni_5();
SetTitle(NameObj);
SetDTBeg();
SetFontSize();
SetDecimalPoint();
SetRazmA("кВт*ч");
SetRazmR("кВар*ч");
break;
case"Протокол замеров- 30 мин":
switch(nodeProp.IdType)
{
case TypeObject.meter:
query = "select * from fGetProtocole ("+nodeProp.IdParent+", "+nodeProp.IdObject+
", \'"+DTBeg+"\', 30)";
break;
case TypeObject.subst:
query = "select * from fGetProtocole ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 30)";
break;
}
Otchreport = new Simple.Reports.Potochni_5();
SetTitle(NameObj);
SetDTBeg();
SetFontSize();
SetDecimalPoint();
SetRazmA("кВт*ч");
SetRazmR("кВар*ч");
break;
case"Протокол замеров- час":
switch(nodeProp.IdType)
{
case TypeObject.meter:
query = "select * from fGetProtocole ("+nodeProp.IdParent+", "+nodeProp.IdObject+
", \'"+DTBeg+"\', 60)";
break;
case TypeObject.subst:
query = "select * from fGetProtocole ("+nodeProp.IdObject+", null, \'"+DTBeg+"\', 60)";
break;
}
Otchreport = new Simple.Reports.Potochni_5();
SetTitle(NameObj);
SetDTBeg();
SetDecimalPoint();
SetFontSize();
SetRazmA("кВт*ч");
SetRazmR("кВар*ч");
break;
case"Детальный отчет за сутки":
case"Детальный отчет за 10 дней":
case"Детальный отчет за 20 дней":
case"Детальный отчет за месяц":
switch(NameReport)
{
case"Детальный отчет за сутки":
DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString();
break;
case"Детальный отчет за 10 дней":
DTEnd = DateTime.Parse(DTBeg).AddDays(10).ToString();
break;
case"Детальный отчет за 20 дней":
DTEnd = DateTime.Parse(DTBeg).AddDays(20).ToString();
break;
case"Детальный отчет за месяц":
DTEnd = DateTime.Parse(DTBeg).AddMonths(1).ToString();
break;
}
Otchreport = new Simple.Reports.BalansEn();
SetDTBeg();
SetDecimalPoint();
SetFontSize();
SetDTEnd(DTEnd);
SetRazmA("кВт/кВар*ч");
SetNameobj();
query = "select * from fGetBalanceGroupByEnergy("+nodeProp.IdObject+", \'"+ DTBeg+"\',"+"\'"+DTEnd+"\')";
break;
case"Разница по дифтарифам за сутки":
case"Разница по дифтарифам за месяц":
query = String.Format("Select nfactory from meters where idnode={0} and idmeter = {1}", nodeProp.IdParent , nodeProp.IdObject);
NameObj = String.Format("{0} ({1})", NameObj, dbWork.SelectScalar(query));
switch (NameReport)
{
case"Разница по дифтарифам за сутки":
DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString();
Capt = NameObj+"\r\n"+ "Разница по дифтарифам за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy");
break;
case"Разница по дифтарифам за месяц":
DateTime dtEnd = DateTime.Parse(DTBeg).AddMonths(1);
if(dtEnd>DateTime.Now.Date)
{
dtEnd = DateTime.Now.Date;
Capt = NameObj+"\r\n"+ "Разница по дифтарифам c " +DateTime.Parse(DTBeg).ToString("dd MMMM yyyy")+" по "+ dtEnd.ToString("dd MMMM yyyy");
}
else
{
if(DateTime.Parse(DTBeg).Day==1)
Capt = NameObj+"\r\n"+ "Разница по дифтарифам за " +DateTime.Parse(DTBeg).ToString("MMMM yyyy");
else
Capt = NameObj + "\r\n" + "Разница по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + dtEnd.ToString("dd MMMM yyyy");
}
DTEnd = dtEnd.ToString();
break;
default:Capt = NameObj+"\r\n"+ "Разница по дифтарифам c " +DateTime.Parse(DTBeg).ToString("dd MMMM yyyy")+" по "+ DateTime.Parse(DTEnd).ToString("dd MMMM yyyy");
break;
}
query = "select * from fGetPokaznByTarif ("+nodeProp.IdParent+","+ nodeProp.IdObject+", \'"+ DTBeg+"\',"+"\'"+DTEnd+"\')";
Otchreport = new Simple.Reports.PotrebTarif();
SetTitle(Capt);
SetDecimalPoint();
SetFontSize();
break;
case "Электроэнергия по дифтарифам за сутки":
case "Электроэнергия по дифтарифам за месяц":
case "Электроэнергия по дифтарифам":
//query = String.Format("Select nfactory from meters where idnode={0} and idmeter = {1}", nodeProp.IdParent, nodeProp.IdObject);
//NameObj = String.Format("{0} ({1})", NameObj, dbWork.SelectScalar(query));
switch (NameReport)
{
case "Электроэнергия по дифтарифам за сутки":
DTEnd = DateTime.Parse(DTBeg).AddDays(1).ToString();
Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам за " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy");
break;
case "Электроэнергия по дифтарифам за месяц":
DateTime dtEnd = DateTime.Parse(DTBeg).AddMonths(1);
if (dtEnd > DateTime.Now.Date)
{
dtEnd = DateTime.Now.Date;
Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + dtEnd.ToString("dd MMMM yyyy");
}
else
{
if (DateTime.Parse(DTBeg).Day == 1)
Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам за " + DateTime.Parse(DTBeg).ToString("MMMM yyyy");
else
Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy") + " по " + dtEnd.ToString("dd MMMM yyyy");
}
DTEnd = dtEnd.ToString();
break;
default: Capt = NameObj + "\r\n" + "Электроэнергия по дифтарифам c " + DateTime.Parse(DTBeg).ToString("dd MMMM yyyy HH:mm") + " по " + DateTime.Parse(DTEnd).ToString("dd MMMM yyyy HH:mm");
break;
}
//fGetPokaznAndEnergyByTarif (24432974, '25-07-2010', '26-07-2010')
query = "select * from fGetPokaznAndEnergyByTarif (" + nodeProp.IdObject + ", \'" + DTBeg + "\'," + "\'" + DTEnd + "\')";
Otchreport = new Simple.Reports.EnergyByTarif();
SetTitle(Capt);
SetDecimalPoint();
SetFontSize();
break;
default:
throw new Exception ("Нет такого отчета");
}
dbWork.ExecuteTimeOut = 900;
//da = dbWork.SelectSqlDA(query);
//da.Fill(ds);
DataTable dt = dbWork.SelectTable(query);
Otchreport.Database.Tables[0].SetDataSource(dt);
crDatabase = Otchreport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
}
public void ShowTicketAnomaliesReport(DateTime StartDate, DateTime EndDate)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowTicketAnomaliesReport method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
TicketAnomaliesReport TicketAnomaliesReport = new TicketAnomaliesReport();
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info);
TicketAnomaliesReport.SetParameterValue("@StartDate", StartDate);
TicketAnomaliesReport.SetParameterValue("@EndDate", EndDate);
TicketAnomaliesReport.SetParameterValue("@Version", sVersion);
TicketAnomaliesReport.SetParameterValue("@SiteCode", Settings.SiteCode);
TicketAnomaliesReport.SetParameterValue("@SiteName", Settings.SiteName);
TicketAnomaliesReport.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
TicketAnomaliesReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString);
List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_TicketingConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_TicketingConnectionString);
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = "Ticketing"; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = TicketAnomaliesReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = TicketAnomaliesReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
// AuditReports();
strReportName = "Ticket Anomalies Report";
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
internal void ShowAccountingWinLossReport(string p, DataSet dtDataset, int ZoneNo, int MachineCategoryNo, DateTime StartDate, DateTime EndDate, string ZoneName, string CategoryName, bool IncludeNonCashable)
{
try
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo();
DbConnectionDetails.DatabaseName = "EXCHANGE";
connectionInfo.ServerName = DbConnectionDetails.ServerName;
connectionInfo.UserID = DbConnectionDetails.UserName;
connectionInfo.Password = DbConnectionDetails.Password;
connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName;
string sVersion, sSiteName;
var vAccountingWinLossReport = new AccountingWinLossReport();
vAccountingWinLossReport.SetDataSource(dtDataset);
vAccountingWinLossReport.SetParameterValue("@Zone", ZoneNo);
vAccountingWinLossReport.SetParameterValue("@Category", MachineCategoryNo);
vAccountingWinLossReport.SetParameterValue("@StartDate", StartDate);
vAccountingWinLossReport.SetParameterValue("@EndDate", EndDate);
vAccountingWinLossReport.SetParameterValue("@IncludeNonCashable", IncludeNonCashable);
GetVersion_SiteName(out sVersion, out sSiteName);
vAccountingWinLossReport.SetParameterValue("SiteName", sSiteName);
vAccountingWinLossReport.SetParameterValue("ZoneName", ZoneName);
vAccountingWinLossReport.SetParameterValue("CategoryName", CategoryName);
vAccountingWinLossReport.SetParameterValue("Version", sVersion);
vAccountingWinLossReport.SetParameterValue("Region", Settings.Region);
vAccountingWinLossReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
vAccountingWinLossReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
vAccountingWinLossReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
vAccountingWinLossReport.SetParameterValue("SiteCode", Settings.SiteCode);
crDatabase = vAccountingWinLossReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = vAccountingWinLossReport;
AuditReports();
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public void ShowOutstandingVaultReport(bool ShowCassettes)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside Show Undeclared Vault Drop Report method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
UndeclaredVaultDrops UndecVaultDrp = new UndeclaredVaultDrops();
UndecVaultDrp.SetParameterValue("@GetCassette", ShowCassettes);
UndecVaultDrp.SetParameterValue("SiteName", sSiteName);
UndecVaultDrp.SetParameterValue("Version", sVersion);
UndecVaultDrp.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
UndecVaultDrp.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
UndecVaultDrp.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
UndecVaultDrp.SetParameterValue("SiteCode", Settings.SiteCode);
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
IReports objReports = ReportsBusinessObject.CreateInstance();
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = UndecVaultDrp.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = UndecVaultDrp;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Undeclared Vault Drop Report";
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(comboBox1.Text))
{
MessageBox.Show("Please Select Extract No");
}
else
{
//creating an object of ParameterField class
ParameterField paramField = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
//set the parameter field name
paramField.Name = "extractid";
//set the parameter value
paramDiscreteValue.Value = x;
//add the parameter value in the ParameterField object
paramField.CurrentValues.Add(paramDiscreteValue);
//add the parameter in the ParameterFields object
paramFields.Add(paramField);
//set the parameterfield information in the crystal report
ReportViewer f2 = new ReportViewer();
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "tcp:KyotoServer,49172";
with1.DatabaseName = "BoardSecretariatDBKD";
with1.UserID = "sa";
with1.Password = "******";
ResolutionExtractReportedit cr = new ResolutionExtractReportedit();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields;
//set the parameterfield information in the crystal report
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
}
public string GenerateReport(Entities.Report report, ExportFormatType exportFormat)
{
string filePath = null;
try
{
_tableLogOnInfo = new TableLogOnInfo();
_reportDocument = new ReportDocument();
connectionStringBuilder = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString);
_dbConnectionInfo = new ConnectionInfo();
_tableLogOnInfo = new TableLogOnInfo();
//Create a folder if not exists
if (Directory.Exists(report.DirectoryPath) == false)
{
Directory.CreateDirectory(report.DirectoryPath);
}
var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/");
//File.AppendAllText(serverPath + "/log.txt", report.ReportPath);
_reportDocument.Load(report.ReportPath);
//Reading the db connection file
string serverName = connectionStringBuilder.DataSource;
string databaseName = connectionStringBuilder.InitialCatalog;
string userId = connectionStringBuilder.UserID;
string password = connectionStringBuilder.Password;
_dbConnectionInfo.ServerName = serverName;
_dbConnectionInfo.DatabaseName = databaseName;
_dbConnectionInfo.UserID = userId;
_dbConnectionInfo.Password = password;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in _reportDocument.Database.Tables)
{
_tableLogOnInfo = table.LogOnInfo;
_tableLogOnInfo.ConnectionInfo = _dbConnectionInfo;
table.ApplyLogOnInfo(_tableLogOnInfo);
}
if (report.Parameters != null)
{
if (report.Parameters.Count > 0)
{
for (int items = 0; items < report.Parameters.Count; items++)
{
_reportDocument.SetParameterValue(items, report.Parameters[items].ToString());
}
}
else if (report.Parameters.Count == 0)
{
_reportDocument.RecordSelectionFormula = report.RecordSelectionFormula;
}
}
else
{
_reportDocument.RecordSelectionFormula = report.RecordSelectionFormula;
}
//serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/");
//File.AppendAllText(serverPath + "/log.txt", "Report Parameters");
_diskFileDestinationOptions = new DiskFileDestinationOptions();
//_exportOptions = new ExportOptions();
_reportFormatOptions = new PdfRtfWordFormatOptions();
_exportOptions = _reportDocument.ExportOptions;
_diskFileDestinationOptions.DiskFileName = report.FileStoragePath;
_exportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
_exportOptions.ExportFormatType = exportFormat;
_exportOptions.ExportDestinationOptions = _diskFileDestinationOptions;
_exportOptions.ExportFormatOptions = _reportFormatOptions;
_reportDocument.Export();
//var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/");
//File.AppendAllText(serverPath + "/log.txt", "File Storeage path " + report.FileStoragePath);
filePath = report.FileStoragePath;
}
catch (Exception ex)
{
//var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/");
//File.AppendAllText(serverPath + "/log.txt", ex.Message);
throw new Exception("Error as " + ex.Message);
//LogEntry.LogExceptions.WriteLog("ExportCrystalReportClassLibrary", ex.GetType().ToString(), ex.Message.ToString(), ex.Source.ToString(), "WEB");
}
finally
{
_reportDocument.Close();
}
return(filePath);
}
private void ImprimeProrrogas()
{
try
{
Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "Prorrogas.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSISTMED"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@PACIENTE_ID";
ParametroValue.Value = Clases.Paciente.PacienteIngresado;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//2° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@Tipo";
if (this.radioProrrogas.Checked)
{
ParametroValue.Value = "PR";
}
if (this.radioResumen.Checked)
{
ParametroValue.Value = "RE";
}
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//3° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@FechaDesde";
ParametroValue.Value = this.datefechaDesde.Value;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//4° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@FechaHasta";
ParametroValue.Value = this.datefechaHasta.Value;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string qry = "select * from invoice where consumer_No = '" + txtConsumerNo.Text + "'";
sda = new SqlDataAdapter(qry, conn);
sda.Fill(ds, "invoice");
// rpt.Load(Server.MapPath("~/CrystalReport.rpt"));
//rpt.FileName = Server.MapPath("~/CrystalReport.rpt");
//rpt.SetDatabaseLogon("sa", "123");
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
Tables CrTables;
rpt.Load(Server.MapPath("~/billing.rpt"));
ConnectionInfo crConnectionInfo = new ConnectionInfo();
rpt.FileName = Server.MapPath("~/billing.rpt");
crConnectionInfo.ServerName = "WIN-7V1OQFPKUAJ";
crConnectionInfo.DatabaseName = "kmc";
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
CrTables = rpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
//ConnectionInfo info = new ConnectionInfo();
//info.ServerName = "SPRINT-IT-PC";
//info.DatabaseName = "kmc";
//info.UserID = "sa";
//info.Password = "******";
//System.Web.UI.WebControls.Table inc = new System.Web.UI.WebControls.Table();
crv.DisplayToolbar = true;
crv.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
crv.Zoom(100);
crv.HasExportButton = false;
crv.HasPrintButton = true;
crv.HasToggleGroupTreeButton = false;
crv.HasToggleParameterPanelButton = false;
crv.HasZoomFactorList = false;
crv.HasCrystalLogo = false;
crv.Font.Size = 8;
crv.GroupTreeStyle.Font.Size = 8;
crv.GroupTreeStyle.ShowLines = false;
crv.ToolbarStyle.Width = Unit.Parse("2046px");
rpt.SetDataSource(ds);
crv.ReportSource = rpt;
// rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat,Response, true, "PersonDetails");
conn.Close();
//filepath = Server.MapPath("~/" + "test.pdf");
//rpt.ExportToDisk(ExportFormatType.PortableDocFormat, filepath);
//System.IO.FileInfo fileinfo = new System.IO.FileInfo(filepath);
//Response.AddHeader("Content-Disposition", "inline;filename=test.pdf");
//Response.ContentType = "application/pdf";
//Response.WriteFile(fileinfo.FullName);
}
private void ShowReport(String _nome, Report_Data _dados, DataSet Ds, int Valor1)
{
crViewer.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
string _usuario = gtiCore.LastUser;
switch (_nome)
{
case "CertidaoEndereco":
Text = "Certidão de Endereço";
CertidaoEndereco rpt_endereco = new CertidaoEndereco();
rpt_endereco.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_endereco.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_endereco.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_endereco.SetParameterValue("CONTROLE", _dados.Controle);
rpt_endereco.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_endereco.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_endereco.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_endereco.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_endereco.SetParameterValue("NOME", _dados.Nome);
rpt_endereco.SetParameterValue("PROCESSO", _dados.Processo);
rpt_endereco.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_endereco.SetParameterValue("QUADRA", _dados.Quadra_original);
rpt_endereco.SetParameterValue("LOTE", _dados.Lote_original);
rpt_endereco.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? "");
rpt_endereco.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_endereco;
break;
case "CertidaoImunidade":
Text = "Certidão de Isenção";
CertidaoImunidade rpt_imunidade = new CertidaoImunidade();
rpt_imunidade.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_imunidade.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_imunidade.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_imunidade.SetParameterValue("CONTROLE", _dados.Controle);
rpt_imunidade.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_imunidade.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_imunidade.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_imunidade.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_imunidade.SetParameterValue("NOME", _dados.Nome);
rpt_imunidade.SetParameterValue("PROCESSO", _dados.Processo);
rpt_imunidade.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_imunidade.SetParameterValue("ANO", _dados.AnoIsencao);
rpt_imunidade.SetParameterValue("AREA", _dados.Area);
rpt_imunidade.SetParameterValue("PERC", _dados.Perc_Isencao);
rpt_imunidade.SetParameterValue("DOC", _dados.Cpf_cnpj ?? "");
rpt_imunidade.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_imunidade;
break;
case "CertidaoIsencaoProcesso":
Text = "Certidão de Isenção";
CertidaoIsencaoProcesso rpt_isencao = new CertidaoIsencaoProcesso();
rpt_isencao.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_isencao.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_isencao.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_isencao.SetParameterValue("CONTROLE", _dados.Controle);
rpt_isencao.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_isencao.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_isencao.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_isencao.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_isencao.SetParameterValue("NOME", _dados.Nome);
rpt_isencao.SetParameterValue("NUMPROCESSO", _dados.Processo);
rpt_isencao.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_isencao.SetParameterValue("NUMPROCESSOISENCAO", _dados.Processo_Isencao);
rpt_isencao.SetParameterValue("DATAPROCESSOISENCAO", _dados.Data_Processo_Isencao);
rpt_isencao.SetParameterValue("ANO", _dados.AnoIsencao);
rpt_isencao.SetParameterValue("AREA", _dados.Area);
rpt_isencao.SetParameterValue("PERC", _dados.Perc_Isencao);
rpt_isencao.SetParameterValue("DOC", _dados.Cpf_cnpj ?? "");
rpt_isencao.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_isencao;
break;
case "CertidaoIsencao65":
Text = "Certidão de Isenção";
CertidaoIsencao65 rpt_isencao65 = new CertidaoIsencao65();
rpt_isencao65.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_isencao65.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_isencao65.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_isencao65.SetParameterValue("CONTROLE", _dados.Controle);
rpt_isencao65.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_isencao65.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_isencao65.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_isencao65.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_isencao65.SetParameterValue("NOME", _dados.Nome);
rpt_isencao65.SetParameterValue("NUMPROCESSO", _dados.Processo);
rpt_isencao65.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_isencao65.SetParameterValue("ANO", _dados.AnoIsencao);
rpt_isencao65.SetParameterValue("AREA", _dados.Area);
rpt_isencao65.SetParameterValue("PERC", _dados.Perc_Isencao);
rpt_isencao65.SetParameterValue("DOC", _dados.Cpf_cnpj ?? "");
rpt_isencao65.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_isencao65;
break;
case "CertidaoValorVenal":
Text = "Certidão de Valor Venal";
CertidaoValorVenal rpt_vvenal = new CertidaoValorVenal();
Tributario_bll tributario_Class = new Tributario_bll(_connection);
SpCalculo RegCalculo = tributario_Class.Calculo_IPTU(Convert.ToInt32(_dados.Codigo), DateTime.Now.Year);
rpt_vvenal.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_vvenal.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_vvenal.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_vvenal.SetParameterValue("CONTROLE", _dados.Controle);
rpt_vvenal.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_vvenal.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_vvenal.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_vvenal.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_vvenal.SetParameterValue("NOME", _dados.Nome);
rpt_vvenal.SetParameterValue("PROCESSO", _dados.Processo);
rpt_vvenal.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_vvenal.SetParameterValue("QUADRA", _dados.Quadra_original);
rpt_vvenal.SetParameterValue("LOTE", _dados.Lote_original);
rpt_vvenal.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? "");
rpt_vvenal.SetParameterValue("VVT", RegCalculo.Vvt);
rpt_vvenal.SetParameterValue("VVP", RegCalculo.Vvp);
rpt_vvenal.SetParameterValue("VVI", RegCalculo.Vvi);
rpt_vvenal.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_vvenal;
break;
case "CertidaoDebitoImovel":
Text = "Certidão de Débito";
CertidaoDebitoImovel rpt_cdebitoimovel = new CertidaoDebitoImovel();
rpt_cdebitoimovel.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_cdebitoimovel.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_cdebitoimovel.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_cdebitoimovel.SetParameterValue("CONTROLE", _dados.Controle);
rpt_cdebitoimovel.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_cdebitoimovel.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_cdebitoimovel.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_cdebitoimovel.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_cdebitoimovel.SetParameterValue("NOME", _dados.Nome);
rpt_cdebitoimovel.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao);
rpt_cdebitoimovel.SetParameterValue("TRIBUTO", _dados.Tributos);
rpt_cdebitoimovel.SetParameterValue("NAO", _dados.Nao);
rpt_cdebitoimovel.SetParameterValue("ATIVIDADE", _dados.Atividade);
rpt_cdebitoimovel.SetParameterValue("CIDADE", _dados.Nome_cidade);
rpt_cdebitoimovel.SetParameterValue("PROCESSO", _dados.Processo);
rpt_cdebitoimovel.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_cdebitoimovel.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? "");
rpt_cdebitoimovel.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_cdebitoimovel;
break;
case "CertidaoDebitoEmpresa":
Text = "Certidão de Débito";
CertidaoDebitoEmpresa rpt_cdebitoempresa = new CertidaoDebitoEmpresa();
rpt_cdebitoempresa.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_cdebitoempresa.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_cdebitoempresa.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_cdebitoempresa.SetParameterValue("CONTROLE", _dados.Controle);
rpt_cdebitoempresa.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_cdebitoempresa.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_cdebitoempresa.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_cdebitoempresa.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_cdebitoempresa.SetParameterValue("NOME", _dados.Nome);
rpt_cdebitoempresa.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao);
rpt_cdebitoempresa.SetParameterValue("TRIBUTO", _dados.Tributos);
rpt_cdebitoempresa.SetParameterValue("NAO", _dados.Nao);
rpt_cdebitoempresa.SetParameterValue("ATIVIDADE", _dados.Atividade);
rpt_cdebitoempresa.SetParameterValue("CIDADE", _dados.Nome_cidade);
rpt_cdebitoempresa.SetParameterValue("PROCESSO", _dados.Processo);
rpt_cdebitoempresa.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_cdebitoempresa.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? "");
rpt_cdebitoempresa.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_cdebitoempresa;
break;
case "CertidaoDebitoImovelPN":
Text = "Certidão de Débito";
CertidaoDebitoImovelPN rpt_cdebitoimovelpn = new CertidaoDebitoImovelPN();
rpt_cdebitoimovelpn.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_cdebitoimovelpn.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_cdebitoimovelpn.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_cdebitoimovelpn.SetParameterValue("CONTROLE", _dados.Controle);
rpt_cdebitoimovelpn.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_cdebitoimovelpn.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_cdebitoimovelpn.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_cdebitoimovelpn.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_cdebitoimovelpn.SetParameterValue("NOME", _dados.Nome);
rpt_cdebitoimovelpn.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao);
rpt_cdebitoimovelpn.SetParameterValue("TRIBUTO", _dados.Tributos);
rpt_cdebitoimovelpn.SetParameterValue("NAO", _dados.Nao);
rpt_cdebitoimovelpn.SetParameterValue("ATIVIDADE", _dados.Atividade);
rpt_cdebitoimovelpn.SetParameterValue("CIDADE", _dados.Nome_cidade);
rpt_cdebitoimovelpn.SetParameterValue("PROCESSO", _dados.Processo);
rpt_cdebitoimovelpn.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_cdebitoimovelpn.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? "");
rpt_cdebitoimovelpn.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_cdebitoimovelpn;
break;
case "CertidaoDebitoEmpresapn":
Text = "Certidão de Débito";
CertidaoDebitoEmpresaPN rpt_cdebitoempresapn = new CertidaoDebitoEmpresaPN();
rpt_cdebitoempresapn.SetDatabaseLogon(gtiCore.Ul, gtiCore.Up, gtiCore.ServerName, gtiCore.BaseDados);
rpt_cdebitoempresapn.SetParameterValue("NUMCERTIDAO", _dados.Numero_Certidao);
rpt_cdebitoempresapn.SetParameterValue("DATAEMISSAO", DateTime.Now);
rpt_cdebitoempresapn.SetParameterValue("CONTROLE", _dados.Controle);
rpt_cdebitoempresapn.SetParameterValue("BAIRRO", _dados.Nome_bairro);
rpt_cdebitoempresapn.SetParameterValue("ENDERECO", _dados.Endereco);
rpt_cdebitoempresapn.SetParameterValue("CADASTRO", _dados.Codigo);
rpt_cdebitoempresapn.SetParameterValue("INSCRICAO", _dados.Inscricao);
rpt_cdebitoempresapn.SetParameterValue("NOME", _dados.Nome);
rpt_cdebitoempresapn.SetParameterValue("TIPOCERTIDAO", _dados.TipoCertidao);
rpt_cdebitoempresapn.SetParameterValue("TRIBUTO", _dados.Tributos);
rpt_cdebitoempresapn.SetParameterValue("NAO", _dados.Nao);
rpt_cdebitoempresapn.SetParameterValue("ATIVIDADE", _dados.Atividade);
rpt_cdebitoempresapn.SetParameterValue("CIDADE", _dados.Nome_cidade);
rpt_cdebitoempresapn.SetParameterValue("PROCESSO", _dados.Processo);
rpt_cdebitoempresapn.SetParameterValue("DATAPROCESSO", _dados.Data_Processo);
rpt_cdebitoempresapn.SetParameterValue("DOCUMENTO", _dados.Cpf_cnpj ?? "");
rpt_cdebitoempresapn.RecordSelectionFormula = "{Assinatura.Usuario}='" + _usuario + "'";
crViewer.ReportSource = rpt_cdebitoempresapn;
break;
case "Carta_Cobranca_Envelope":
Carta_Cobranca_Envelope rpt_carta_cobranca_envelope = new Carta_Cobranca_Envelope();
CrTables = rpt_carta_cobranca_envelope.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
rpt_carta_cobranca_envelope.RecordSelectionFormula = "{Carta_Cobranca.Remessa}=" + Valor1;
crViewer.ReportSource = rpt_carta_cobranca_envelope;
break;
case "Comunicado_Isencao":
ComunicadoIsencao rpt_comunicado_Isencao = new GTI_Desktop.Report.ComunicadoIsencao();
CrTables = rpt_comunicado_Isencao.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
rpt_comunicado_Isencao.RecordSelectionFormula = "{Comunicado_isencao.Remessa}=" + Valor1;
crViewer.ReportSource = rpt_comunicado_Isencao;
break;
default:
break;
}
}//End showReport
private void frmRMostrarVentas_Load(object sender, EventArgs e)
{
try
{
string bandera = frmMostrarVentas.f1.lblBandera.Text;
string fechaInicio = "";
string fechaFin = "";
DateTime fecIn;
if (bandera == "1")
{
fechaInicio = frmMostrarVentas.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00");
fechaFin = frmMostrarVentas.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59");
}
else
{
fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text);
fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss");
fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
ReportDocument repdoc = new ReportDocument();
// repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentas.rpt");
repdoc.Load(@"D:\Reportes\RVentas.rpt");
ParameterFieldDefinitions pfds;
ParameterFieldDefinition pfd;
ParameterValues pvs = new ParameterValues();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pdv.Value = Convert.ToDateTime(fechaInicio);
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@fechaInicio"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
pdv.Value = Convert.ToDateTime(fechaFin);
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@fechaFin"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS";
crConnectionInfo.DatabaseName = "BD_RESTAURANTE";
crConnectionInfo.UserID = "admin";
crConnectionInfo.Password = "******";
/*
* crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS";
* crConnectionInfo.DatabaseName = "db_restauranteAlmacen";
* crConnectionInfo.UserID = "martin";
* crConnectionInfo.Password = "******";
*/
CrTables = repdoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
cvVentas.ReportSource = repdoc;
cvVentas.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("ERROR" + ex);
}
}
internal void PrintLiquidationReportForProfitShare()
{
try
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo();
DbConnectionDetails.DatabaseName = "Exchange";
connectionInfo.ServerName = DbConnectionDetails.ServerName;
connectionInfo.UserID = DbConnectionDetails.UserName;
connectionInfo.Password = DbConnectionDetails.Password;
connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName;
var rLiquidationReportForProfitShare = new LiquidationSummary_PS();
crDatabase = rLiquidationReportForProfitShare.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = rLiquidationReportForProfitShare;
crystalReportViewer.Show();
crystalReportViewer.PrintReport();
AuditReports();
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public void ShowWeeklyExceptionSummary(int WeekID)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowWeeklyExceptionSummary method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
weekly_exception_summary_report WeeklyExceptionSummaryReport = new weekly_exception_summary_report();
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info);
WeeklyExceptionSummaryReport.SetParameterValue("WeekNo", WeekID);
WeeklyExceptionSummaryReport.SetParameterValue("@WeekID", WeekID);
WeeklyExceptionSummaryReport.SetParameterValue("@Currency", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
WeeklyExceptionSummaryReport.SetParameterValue("Version", sVersion);
IReports objReports = ReportsBusinessObject.CreateInstance();
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = WeeklyExceptionSummaryReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = WeeklyExceptionSummaryReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Weekly Exception Summary Report";
}
catch (Exception ex)
{
throw ex;
}
}
public void PDFGeneration()
{
MySqlConnection con1 = new MySqlConnection();
//SqlConnection con1 = new SqlConnection();
//con1.ConnectionString = ConfigurationManager.ConnectionStrings["DBconnection"].ConnectionString;
//con1.ConnectionString = "Data Source = 123.176.34.15;port=4043;Integrated Security=False; Initial Catalog = survey; User ID = TestLogin; Password = ASD123!@#;";
con1.ConnectionString = _base.Decrypt(ConfigurationManager.ConnectionStrings["MysqlPath"].ConnectionString);
//SqlDataAdapter da = new SqlDataAdapter("select * from question where submitted =1 AND MailStatus=0", con1);
MySqlDataAdapter da = new MySqlDataAdapter("select * from question where submitted =1 AND MailStatus=0", con1);
DataTable dt = new DataTable();
da.Fill(dt);
Base @base = new Base();
foreach (DataRow dr in dt.Rows)
{
ReportDocument ss = new ReportDocument();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.AllowCustomConnection = true;
myConnectionInfo.ServerName = _base.Decrypt(ConfigurationManager.AppSettings["SERVERNAME"].ToString());
myConnectionInfo.DatabaseName = _base.Decrypt(ConfigurationManager.AppSettings["DATABASE"].ToString());
myConnectionInfo.IntegratedSecurity = Convert.ToBoolean(ConfigurationManager.AppSettings["INTEGRATEDSECURITY"].ToString());
myConnectionInfo.UserID = _base.Decrypt(ConfigurationManager.AppSettings["USERID"].ToString());
myConnectionInfo.Password = _base.Decrypt(ConfigurationManager.AppSettings["PASSWORD"].ToString());
myConnectionInfo.Type = ConnectionInfoType.SQL;
string Rpt_Path = System.Web.Hosting.HostingEnvironment.MapPath(ConfigurationManager.AppSettings["rptLocation"].ToString());
string outputPath = System.Web.Hosting.HostingEnvironment.MapPath(ConfigurationManager.AppSettings["OutputPath_pdf"].ToString());
try
{
JavaScriptSerializer scr = new JavaScriptSerializer();
Question2 Que2 = (Question2)scr.Deserialize(dr["la_q2"].ToString().Replace("\\", ""), typeof(Question2));
Question4 Que4 = (Question4)scr.Deserialize(dr["la_q4"].ToString().Replace("\\", ""), typeof(Question4));
Question7 Que7 = (Question7)scr.Deserialize(dr["la_q7"].ToString().Replace("\\", ""), typeof(Question7));
question8 Que8 = (question8)scr.Deserialize(dr["la_q8"].ToString().Replace("\\", ""), typeof(question8));
//List<string> Que9 = (List<string>)scr.Deserialize(dr["la_q9"].ToString().Replace("\\", ""), typeof(List<string>));
Question11 Que11 = (Question11)scr.Deserialize(dr["la_q11"].ToString().Replace("\\", ""), typeof(Question11));
//Question15 Que15 = (Question15)scr.Deserialize(dr["la_q15"].ToString().Replace("\\", ""), typeof(Question15));
FQ1 fq1 = (FQ1)scr.Deserialize(dr["fq1"].ToString().Replace("\\", ""), typeof(FQ1));
FQ2 fq2 = (FQ2)scr.Deserialize(dr["fq2"].ToString().Replace("\\", ""), typeof(FQ2));
FQ3 fq3 = (FQ3)scr.Deserialize(dr["fq3"].ToString().Replace("\\", ""), typeof(FQ3));
string que1 = dr["la_q1"].ToString();
string que3 = dr["la_q3"].ToString();
string que5 = dr["la_q5"].ToString();
string que6 = dr["la_q6"].ToString();
string que9 = dr["la_q9"].ToString();
string que10 = dr["la_q10"].ToString();
string que12 = dr["la_q12"].ToString();
string que13 = dr["la_q13"].ToString();
string que14 = dr["la_q14"].ToString();
string que15 = dr["la_q15"].ToString();
String User_ID = dr["User_ID"].ToString();
con1.Open();
string q = "Select * from users WHERE User_ID = " + User_ID + " ";
MySqlCommand cmd3 = new MySqlCommand(q, con1);
//var a = cmd3.ExecuteScalar();
MySqlDataReader reader = cmd3.ExecuteReader();
MySqlUser u = new MySqlUser();
while (reader.Read())
{
u.FirstName = reader.GetString("First_Name");
u.SecoundName = reader.GetString("Second_Name");
u.Email = reader.GetString("Email");
u.Compnay = reader.GetString("Company_Name");
u.UserName = reader.GetString("User_Name");
}
con1.Close();
CrystalReport crypt = new CrystalReport();
crypt.SetParameterValue("Company_Name", u.Compnay);
crypt.SetParameterValue("User", u.FirstName + " " + u.SecoundName);
crypt.SetParameterValue("Promantus_POC", "Promantus");
crypt.SetParameterValue("Q4.1", Que4.la_q4_1);
crypt.SetParameterValue("Q4.2", Que4.la_q4_2);
crypt.SetParameterValue("Q4.3", Que4.la_q4_3);
//crypt.SetParameterValue("Q4.5", Que4.la_q4_5.ToString());
crypt.SetParameterValue("Q6", que6);
crypt.SetParameterValue("Q11", Que11.la_q11_1.ToString() + " , " + Que11.la_q11_2.ToString());
crypt.SetParameterValue("Q12", que12);
crypt.SetParameterValue("Q13", que13);
crypt.SetParameterValue("Q14", que14);
//crypt.SetParameterValue("Q15", Que15.la_q15_1 + " , " + Que15.la_q15_2.ToString());
crypt.SetParameterValue("Q15", que15);
crypt.SetParameterValue("f1", fq1.f1);
crypt.SetParameterValue("f2", fq1.f2);
crypt.SetParameterValue("f3", fq1.f3);
crypt.SetParameterValue("f4", fq2.f4);
crypt.SetParameterValue("f5", fq2.f5);
crypt.SetParameterValue("f6", fq2.f6);
crypt.SetParameterValue("f7", fq3.f7);
crypt.SetParameterValue("f8", fq3.f8);
if (que3 == "no")
{
if (Que4.la_q4_1 != "SAP ECC6.0" && Que4.la_q4_1 != "EHP")
{
crypt.SetParameterValue("Img_Op1", true);
crypt.SetParameterValue("Img_Op2", false);
}
else
{
crypt.SetParameterValue("Img_Op2", true);
crypt.SetParameterValue("Img_Op1", false);
}
}
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in crypt.Database.Tables)
{
TableLogOnInfo myTableLogonInfo = myTable.LogOnInfo;
myTableLogonInfo.ConnectionInfo = myConnectionInfo;
myTable.ApplyLogOnInfo(myTableLogonInfo);
myTable.Location = myConnectionInfo.DatabaseName + ".dbo." + myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1);
myTable.LogOnInfo.ConnectionInfo.ServerName = myConnectionInfo.ServerName;
}
CrystalReportViewer crb = new CrystalReportViewer();
crb.ReportSource = crypt;
ss.Load(Rpt_Path);
#region Q2
String Q2 = "";
if (Que2 != null)
{
if (Que2.la_q2_1 != "" && Que2.la_q2_1 != "undefined")
{
Q2 = Que2.la_q2_1 + ",";
}
if (Que2.la_q2_2 == "yes")
{
Q2 = Q2 + " Development,";
}
if (Que2.la_q2_3 == "yes")
{
Q2 = Q2 + " Sandbox,";
}
if (Que2.la_q2_4 == "yes")
{
Q2 = Q2 + " Quality / Test,";
}
if (Que2.la_q2_5 == "yes")
{
Q2 = Q2 + " Production,";
}
if (Que2.la_q2_6 != "")
{
Q2 = Q2 + Que2.la_q2_6;// " Any other System / Client in the SAP Landscape";
}
#endregion Q2
ss.SetParameterValue("Q2", Q2);
}
ss.SetParameterValue("Q4.1", Que4.la_q4_1);
ss.SetParameterValue("Q4.2", Que4.la_q4_2);
ss.SetParameterValue("Q4.3", Que4.la_q4_3);
//ss.SetParameterValue("Q4.5", Que4.la_q4_5.ToString());
ss.SetParameterValue("Q6", que6);
if (que3 == "no")
{
if (Que4.la_q4_1 != "SAP ECC6.0" && Que4.la_q4_1 != "EHP")
{
ss.SetParameterValue("Img_Op1", true);
ss.SetParameterValue("Img_Op2", false);
}
else
{
ss.SetParameterValue("Img_Op2", true);
ss.SetParameterValue("Img_Op1", false);
}
}
#region Q7
String Q7 = "";
if (Que7 != null)
{
if (Que7.la_q7_FI == "yes")
{
Q7 = Q7 + "Financials,";
}
if (Que7.la_q7_CO == "yes")
{
Q7 = Q7 + " Controlling,";
}
if (Que7.la_q7_MM == "yes")
{
Q7 = Q7 + " Materials Management,";
}
if (Que7.la_q7_SD == "yes")
{
Q7 = Q7 + " Sales & Distribution,";
}
if (Que7.la_q7_PP == "yes")
{
Q7 = Q7 + " Production Planning,";
}
if (Que7.la_q7_QM == "yes")
{
Q7 = Q7 + " Quality Management,";
}
if (Que7.la_q7_PS == "yes")
{
Q7 = " Project Systems,";
}
if (Que7.la_q7_PM == "yes")
{
Q7 = Q7 + " Plant Maintenance,";
}
if (Que7.la_q7_CS == "yes")
{
Q7 = Q7 + " Customer Service,";
}
if (Que7.la_q7_HR == "yes")
{
Q7 = Q7 + " Human Resources,";
}
if (Que7.la_q7_WM == "yes")
{
Q7 = Q7 + " Warehouse Management,";
}
if (Que7.la_q7_LO_VC == "yes")
{
Q7 = Q7 + " Variant Configuration,";
}
if (Que7.la_q7_LO_WTY == "yes")
{
Q7 = Q7 + " Warranty Management,";
}
if (Que7.la_q7_LO_SPM == "yes")
{
Q7 = Q7 + " Spare Parts Management,";
}
if (Que7.la_q7_other != "")
{
Q7 = Q7 + Que7.la_q7_other;
}
ss.SetParameterValue("Q7", Q7);
}
#endregion Q7
ss.SetParameterValue("Q11", Que11.la_q11_1.ToString() + " , " + Que11.la_q11_2.ToString());
ss.SetParameterValue("Q12", que12);
ss.SetParameterValue("Q13", que13);
ss.SetParameterValue("Q14", que14);
ss.SetParameterValue("Q15", que15);
//ss.SetParameterValue("Q15", Que15.la_q15_1 + " , " + Que15.la_q15_2.ToString());
ss.SetParameterValue("f1", fq1.f1);
ss.SetParameterValue("f2", fq1.f2);
ss.SetParameterValue("f3", fq1.f3);
ss.SetParameterValue("f4", fq2.f4);
ss.SetParameterValue("f5", fq2.f5);
ss.SetParameterValue("f6", fq2.f6);
ss.SetParameterValue("f7", fq3.f7);
ss.SetParameterValue("f8", fq3.f8);
ss.SetParameterValue("Company_Name", u.Compnay);
ss.SetParameterValue("User", u.FirstName + " " + u.SecoundName);
ss.SetParameterValue("Promantus_POC", "Promantus");
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = outputPath + User_ID + ".pdf";
CrExportOptions = ss.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
ss.Export();
// con1.Open();
// string q = "Select Email from users WHERE User_ID = " + User_ID + " ";
// MySqlCommand cmd3 = new MySqlCommand(q, con1);
//var a= cmd3.ExecuteScalar();
Boolean S = @base.AddQuestionnaire_Mail(Convert.ToInt32(User_ID), u.Email);
con1.Open();
string myQuery = "UPDATE question SET MailStatus = " + S + " WHERE User_ID = " + User_ID + " ";
MySqlCommand cmd2 = new MySqlCommand(myQuery, con1);
cmd2.ExecuteNonQuery();
con1.Close();
}
catch (Exception ex)
{
_log.createLog(ex, "-->CrystalReportPDF-->Loop" + ex.Message.ToString());
}
finally
{
if (ss != null)
{
ss.Close();
ss.Dispose();
}
}
}
}
public void ShowVaultCurrentDropSlip(int Vault_Id, string VaultName, string Serial_No, string Manufacturer_Name, string Type_Prefix, string LoginUser,
DateTime CreatedDate, bool IsWebServiceEnabled, decimal FillAmount, decimal TotalAmountOnFill,
decimal CurrentBalance, bool _isfinaldrop)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside Show Vault Current Drop Slip method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
VaultDropTransactionSlip VaultBalance = new VaultDropTransactionSlip();
string DropType = string.Empty;
if (_isfinaldrop)
DropType = "Final Drop";
else
DropType = "Standard Drop";
VaultBalance.SetParameterValue("@Vault_id", Vault_Id);
VaultBalance.SetParameterValue("VaultName", VaultName);
VaultBalance.SetParameterValue("SiteName", sSiteName);
VaultBalance.SetParameterValue("SerialNo", Serial_No);
VaultBalance.SetParameterValue("Type_Prefix", Type_Prefix);
VaultBalance.SetParameterValue("Manufacturer_Name", Manufacturer_Name);
VaultBalance.SetParameterValue("LoginUser", LoginUser);
VaultBalance.SetParameterValue("CreatedDate", CreatedDate);
VaultBalance.SetParameterValue("IsWebServiceEnabled", IsWebServiceEnabled);
VaultBalance.SetParameterValue("FillAmount", FillAmount);
VaultBalance.SetParameterValue("TotalAmountOnFill", TotalAmountOnFill);
VaultBalance.SetParameterValue("CurrentBalance", CurrentBalance);
VaultBalance.SetParameterValue("Version", sVersion);
VaultBalance.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
VaultBalance.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
VaultBalance.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
VaultBalance.SetParameterValue("DropType", DropType);
VaultBalance.SetParameterValue("SiteCode", Settings.SiteCode);
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
IReports objReports = ReportsBusinessObject.CreateInstance();
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = VaultBalance.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = VaultBalance;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Vault Drop Transaction Slip Report";
}
catch (Exception ex)
{
throw ex;
}
}
private void frmRPagoTrabador_Load(object sender, EventArgs e)
{
try
{
ExcelFormatOptions objExcel = new ExcelFormatOptions();
string fechaInicio = "";
string fechaFin = "";
int idTrabajador = 0;
if (frmReportePagoPorTrabajador.f1.cbTrabajador.Checked == true)
{
idTrabajador = Convert.ToInt32(frmReportePagoPorTrabajador.f1.cbEmpleado.SelectedValue);
}
else if (frmReportePagoPorTrabajador.f1.cbTrabajador.Checked == false)
{
idTrabajador = 0;
}
fechaInicio = frmReportePagoPorTrabajador.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00");
fechaFin = frmReportePagoPorTrabajador.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59");
//int idProducto = Convert.ToInt32(frmReporteVentasProducto.f1.cbProducto.SelectedValue);
ReportDocument repdoc = new ReportDocument();
// repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentaProducto.rpt");
repdoc.Load(@"D:\Reportes\RPagoTrabajador.rpt");
ParameterFieldDefinitions pfds;
ParameterFieldDefinition pfd;
ParameterValues pvs = new ParameterValues();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pdv.Value = Convert.ToDateTime(fechaInicio);
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@fechaInicio"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
pdv.Value = Convert.ToDateTime(fechaFin);
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@fechaFin"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
pdv.Value = idTrabajador;
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@idTrabajador"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS";
crConnectionInfo.DatabaseName = "BD_RESTAURANTE";
crConnectionInfo.UserID = "admin";
crConnectionInfo.Password = "******";
CrTables = repdoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
cvVentas.ReportSource = repdoc;
cvVentas.Refresh();
objExcel.ExcelUseConstantColumnWidth = false;
}
catch (Exception ex)
{
MessageBox.Show("ERROR" + ex);
}
}
public void ShowVarianceReport(int BatchNo, string ExchangeConn, string TicketingConn)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowVarianceReport method when Common CDO Enlable ", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
VarianceReport varianceReport = new VarianceReport();
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info);
try
{
varianceReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
}
catch
{
varianceReport.SetParameterValue("CurrencySymbol", "£");
LogManager.WriteLog("Exception occurred at CurrencySymbol Set in ExceptionSummary...", LogManager.enumLogLevel.Info);
}
varianceReport.SetParameterValue("BatchNumber", BatchNo);
varianceReport.SetParameterValue("@Batch_No", BatchNo);
varianceReport.SetParameterValue("Version", sVersion);
IReports objReports = ReportsBusinessObject.CreateInstance(ExchangeConn, TicketingConn);
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(ExchangeConn);
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = varianceReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = varianceReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Variance Report";
}
catch (Exception ex)
{
throw ex;
}
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
//connect
//crConnectionInfo.ServerName = @"2300-WS0242\SQLEXPRESS";
//crConnectionInfo.DatabaseName = "CRM";
//crConnectionInfo.UserID = "sa";
//crConnectionInfo.Password = "******";
crConnectionInfo.ServerName = DAL.DataAccess.conn.DataSource;
crConnectionInfo.DatabaseName = DAL.DataAccess.conn.Database;
crConnectionInfo.UserID = DAL.DataAccess.builder.UserID;
crConnectionInfo.Password = DAL.DataAccess.builder.Password;
Tables CrTables;
//In thong ke khach hang hien huu theo tinh, huyen, xa
if (CRM.frmMain.manhinhin == 1)
{
rptTKKHHH rptTKKH = new rptTKKHHH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHHH.loaikh);
rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHHH.tinh);
rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHHH.huyen);
rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHHH.xa);
rptTKKH.SetParameterValue("@tungay", CRM.frmKH_TKKHHH.tungay);
rptTKKH.SetParameterValue("@tuthang", CRM.frmKH_TKKHHH.tuthang);
rptTKKH.SetParameterValue("@denngay", CRM.frmKH_TKKHHH.denngay);
rptTKKH.SetParameterValue("@denthang", CRM.frmKH_TKKHHH.denthang);
rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHHH.cn);
rptTKKH.SetParameterValue("@nhomDT", CRM.frmKH_TKKHHH.nhomDT);
rptTKKH.SetParameterValue("@doituongKH", CRM.frmKH_TKKHHH.doituongKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke tong hop xep loai khach hang
if (CRM.frmMain.manhinhin == 2)
{
rptTKXLKH_TH rptTKXLKH = new rptTKXLKH_TH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKXLKH;
CrTables = rptTKXLKH.Database.Tables;
rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH.tungay);
rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH.denngay);
rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke chi tiet xep loai khach hang
if (CRM.frmMain.manhinhin == 3)
{
rptTKXLKH rptTKXLKH = new rptTKXLKH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKXLKH;
CrTables = rptTKXLKH.Database.Tables;
rptTKXLKH.SetParameterValue("@tungay", CRM.frmHH_TKXLKH.tungay);
rptTKXLKH.SetParameterValue("@denngay", CRM.frmHH_TKXLKH.denngay);
rptTKXLKH.SetParameterValue("@loaikh", CRM.frmHH_TKXLKH.loaikh);
rptTKXLKH.SetParameterValue("@dinhtinh", CRM.frmHH_TKXLKH.dinhtinh);
rptTKXLKH.SetParameterValue("@pheduyet", CRM.frmHH_TKXLKH.pheduyet);
rptTKXLKH.SetParameterValue("@xeploai", CRM.frmHH_TKXLKH.xeploai);
rptTKXLKH.SetParameterValue("@cn", CRM.frmHH_TKXLKH.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang tiem nang theo tinh, huyen, xa
if (CRM.frmMain.manhinhin == 4)
{
rptTKKHTN rptTKKH = new rptTKKHTN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHTN.loaikh);
rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHTN.tinh);
rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHTN.huyen);
rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHTN.xa);
rptTKKH.SetParameterValue("@tungay", CRM.frmKH_TKKHTN.tungay);
rptTKKH.SetParameterValue("@tuthang", CRM.frmKH_TKKHTN.tuthang);
rptTKKH.SetParameterValue("@denngay", CRM.frmKH_TKKHTN.denngay);
rptTKKH.SetParameterValue("@denthang", CRM.frmKH_TKKHTN.denthang);
rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHTN.cn);
rptTKKH.SetParameterValue("@nhomDT", CRM.frmKH_TKKHTN.nhomDT);
rptTKKH.SetParameterValue("@doituongKH", CRM.frmKH_TKKHTN.doituongKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//Danh sach chi nhanh da thuc hien xep loai khach hang
if (CRM.frmMain.manhinhin == 5)
{
rptDSCN rptTKXLKH = new rptDSCN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKXLKH;
CrTables = rptTKXLKH.Database.Tables;
rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH.tungay);
rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH.denngay);
rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang tiem nang da chuyen thanh hien huu theo tinh, huyen, xa
if (CRM.frmMain.manhinhin == 6)
{
rptTKKHTN_HH rptTKKH = new rptTKKHTN_HH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHTN_HH.loaikh);
rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHTN_HH.tinh);
rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHTN_HH.huyen);
rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHTN_HH.xa);
rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHTN_HH.cn);
rptTKKH.SetParameterValue("@tungay", CRM.frmKH_TKKHTN_HH.tungay);
rptTKKH.SetParameterValue("@tuthang", CRM.frmKH_TKKHTN_HH.tuthang);
rptTKKH.SetParameterValue("@denngay", CRM.frmKH_TKKHTN_HH.denngay);
rptTKKH.SetParameterValue("@denthang", CRM.frmKH_TKKHTN_HH.denthang);
rptTKKH.SetParameterValue("@nhomDT", CRM.frmKH_TKKHTN_HH.nhomDT);
rptTKKH.SetParameterValue("@doituongKH", CRM.frmKH_TKKHTN_HH.doituongKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang tiem nang da duoc phan cong theo doi theo tinh, huyen, xa
if (CRM.frmMain.manhinhin == 7)
{
rptTKKHTN_NV rptTKKH = new rptTKKHTN_NV();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
//rptTKKH.SetParameterValue("@loaikh", CRM.frmKH_TKKHTN_NV.loaikh);
rptTKKH.SetParameterValue("@tinh", CRM.frmKH_TKKHTN_NV.tinh);
rptTKKH.SetParameterValue("@huyen", CRM.frmKH_TKKHTN_NV.huyen);
rptTKKH.SetParameterValue("@xa", CRM.frmKH_TKKHTN_NV.xa);
rptTKKH.SetParameterValue("@canbo", CRM.frmKH_TKKHTN_NV.canbo);
rptTKKH.SetParameterValue("@cn", CRM.frmKH_TKKHTN_NV.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang da phan hoi ve chat luong SPDV
if (CRM.frmMain.manhinhin == 8)
{
rptTKCLSPDV rptTKKH = new rptTKCLSPDV();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@tungay", CRM.frmTK_CLSPDV.tuthang);
rptTKKH.SetParameterValue("@denngay", CRM.frmTK_CLSPDV.denthang);
rptTKKH.SetParameterValue("@maHM", CRM.frmTK_CLSPDV.mahm);
rptTKKH.SetParameterValue("@chitietHM", CRM.frmTK_CLSPDV.chitietHM);
//rptTKKH.SetParameterValue("@cn", Thongtindangnhap.macn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang da phan hoi ve SPDV dang su dung
if (CRM.frmMain.manhinhin == 9)
{
rptTKSPDV rptTKKH = new rptTKSPDV();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@tungay", CRM.frmTK_SPDV.tuthang);
rptTKKH.SetParameterValue("@denngay", CRM.frmTK_SPDV.denthang);
rptTKKH.SetParameterValue("@luachon", CRM.frmTK_SPDV.luachon);
rptTKKH.SetParameterValue("@chitietHM", CRM.frmTK_SPDV.chitietHM);
//rptTKKH.SetParameterValue("@cn", Thongtindangnhap.macn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang da phan hoi ve YTQT
if (CRM.frmMain.manhinhin == 10)
{
rptTKYTQT rptTKKH = new rptTKYTQT();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@tungay", CRM.frmTK_YTQT.tuthang);
rptTKKH.SetParameterValue("@denngay", CRM.frmTK_YTQT.denthang);
rptTKKH.SetParameterValue("@maCT", CRM.frmTK_YTQT.maCT);
rptTKKH.SetParameterValue("@chitietHM", CRM.frmTK_YTQT.chitietHM);
//rptTKKH.SetParameterValue("@cn", Thongtindangnhap.macn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke chi tiet hoat dong khach hang hien huu
if (CRM.frmMain.manhinhin == 11)
{
rptTKGDKH rptTKKH = new rptTKGDKH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn);
rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo);
rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke chi tiet nhan vien giao dich voi khach hang hien huu
if (CRM.frmMain.manhinhin == 12)
{
rptTKGD rptTKKH = new rptTKGD();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn);
rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo);
rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke chi tiet hoat dong khach hang tiem nang
if (CRM.frmMain.manhinhin == 13)
{
rptTKGDKH_TN rptTKKH = new rptTKGDKH_TN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn);
rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo);
rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke chi tiet nhan vien giao dich voi khach hang tiem nang
if (CRM.frmMain.manhinhin == 14)
{
rptTKGD_TN rptTKKH = new rptTKGD_TN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmKH_TKGD.cn);
rptTKKH.SetParameterValue("@canbo", frmKH_TKGD.canbo);
rptTKKH.SetParameterValue("@maKH", frmKH_TKGD.maKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke thong hop khach hang hien huu
if (CRM.frmMain.manhinhin == 15)
{
rptTKKHHH_TH rptTKKH = new rptTKKHHH_TH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmTKKHHH_TH.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke thong hop khach hang hien huu
if (CRM.frmMain.manhinhin == 16)
{
rptTKKHTN_TH rptTKKH = new rptTKKHTN_TH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmTKKHTN_TH.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 17)
{
rptCSKH_DKH rptCSKHDKH = new rptCSKH_DKH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptCSKHDKH;
CrTables = rptCSKHDKH.Database.Tables;
rptCSKHDKH.SetParameterValue("@cn", frmCSKH_TKDKH.cn);
rptCSKHDKH.SetParameterValue("@tudiem", frmCSKH_TKDKH.FDiem);
rptCSKHDKH.SetParameterValue("@dendiem", frmCSKH_TKDKH.TDiem);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke SDBQ khach hang
if (CRM.frmMain.manhinhin == 18)
{
rptTKSDBQ rptTKKH = new rptTKSDBQ();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@cn", frmTKSDBQ.cn);
rptTKKH.SetParameterValue("@tuthang", frmTKSDBQ.tuthang);
rptTKKH.SetParameterValue("@denthang", frmTKSDBQ.denthang);
//rptTKKH.SetParameterValue("@thang", frmTKSDBQ.thang);
rptTKKH.SetParameterValue("@loaiKH", frmTKSDBQ.loaikh);
rptTKKH.SetParameterValue("@tusdbq", frmTKSDBQ.tusdbq);
rptTKKH.SetParameterValue("@densdbq", frmTKSDBQ.densdbq);
rptTKKH.SetParameterValue("@maKH", frmTKSDBQ.maKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang nhan tien WU
if (CRM.frmMain.manhinhin == 19)
{
rptTKKHWU rptTKKH = new rptTKKHWU();
Cursor.Current = Cursors.WaitCursor;
dsKHWU ds = new dsKHWU();
ds.Tables.Add(frmKHWU.dtKHWU.Copy());
rptTKKH.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = rptTKKH;
rptTKKH.SetParameterValue("cn", frmKHWU.cn);
rptTKKH.SetParameterValue("tuthang", frmKHWU.tuthang);
rptTKKH.SetParameterValue("denthang", frmKHWU.denthang);
crystalReportViewer1.Refresh();
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 20)
{
rptTKKHCS rptTKKH_CS = new rptTKKHCS();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH_CS;
CrTables = rptTKKH_CS.Database.Tables;
rptTKKH_CS.SetParameterValue("@cn", frmTK_KeHoach.cn);
rptTKKH_CS.SetParameterValue("@thang", frmTK_KeHoach.thang);
rptTKKH_CS.SetParameterValue("@xeploai", frmTK_KeHoach.xeploai);
rptTKKH_CS.SetParameterValue("@sukien", frmTK_KeHoach.sukien);
rptTKKH_CS.SetParameterValue("@loaikh", frmTK_KeHoach.loaikh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 21)
{
rptTKTHKH rptTKTHKH = new rptTKTHKH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKTHKH;
CrTables = rptTKTHKH.Database.Tables;
rptTKTHKH.SetParameterValue("@cn", frmTK_THKH.cn);
rptTKTHKH.SetParameterValue("@thang", frmTK_THKH.thang);
rptTKTHKH.SetParameterValue("@xeploai", frmTK_THKH.xeploai);
rptTKTHKH.SetParameterValue("@sukien", frmTK_THKH.sukien);
rptTKTHKH.SetParameterValue("@kehoach", frmTK_THKH.kehoach);
rptTKTHKH.SetParameterValue("@nhanqua", frmTK_THKH.nhanqua);
rptTKTHKH.SetParameterValue("@loaikh", frmTK_THKH.loaikh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khach hang hien huu theo tinh, huyen, xa
if (CRM.frmMain.manhinhin == 22)
{
rptTKKHHH_DB rptTKKH = new rptTKKHHH_DB();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKKH;
CrTables = rptTKKH.Database.Tables;
rptTKKH.SetParameterValue("@loaikh", frmTKKHHH_DB.loaikh);
rptTKKH.SetParameterValue("@tinh", frmTKKHHH_DB.tinh);
rptTKKH.SetParameterValue("@huyen", frmTKKHHH_DB.huyen);
rptTKKH.SetParameterValue("@xa", frmTKKHHH_DB.xa);
rptTKKH.SetParameterValue("@tungay", frmTKKHHH_DB.tungay);
rptTKKH.SetParameterValue("@tuthang", frmTKKHHH_DB.tuthang);
rptTKKH.SetParameterValue("@denngay", frmTKKHHH_DB.denngay);
rptTKKH.SetParameterValue("@denthang", frmTKKHHH_DB.denthang);
rptTKKH.SetParameterValue("@nhomDT", CRM.frmTKKHHH_DB.nhomDT);
rptTKKH.SetParameterValue("@doituongKH", CRM.frmTKKHHH_DB.doituongKH);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 23)
{
rptTK_VIPCT rptTKVIPCT = new rptTK_VIPCT();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKVIPCT;
CrTables = rptTKVIPCT.Database.Tables;
rptTKVIPCT.SetParameterValue("@cn", frmHH_TKVIPCT.cn);
rptTKVIPCT.SetParameterValue("@tuthang", frmHH_TKVIPCT.tungay);
rptTKVIPCT.SetParameterValue("@denthang", frmHH_TKVIPCT.denngay);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 24)
{
rptTKDKH_IN rptTKDKHI = new rptTKDKH_IN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKDKHI;
CrTables = rptTKDKHI.Database.Tables;
rptTKDKHI.SetParameterValue("@cn", frmCSKH_TKD.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 25)
{
rptKHTK rptKHTK_IN = new rptKHTK();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptKHTK_IN;
CrTables = rptKHTK_IN.Database.Tables;
rptKHTK_IN.SetParameterValue("@cn", frmKHThamkhao.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 26)
{
rpt2890 rptTK2890 = new rpt2890();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTK2890;
CrTables = rptTK2890.Database.Tables;
rptTK2890.SetParameterValue("@cn", frmTK2890.cn);
rptTK2890.SetParameterValue("@thang", frmTK2890.thang);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke tong hop xep loai khach hang (VIP)
if (CRM.frmMain.manhinhin == 27)
{
rptTKXLKH_TH_VIP rptTKXLKH = new rptTKXLKH_TH_VIP();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKXLKH;
CrTables = rptTKXLKH.Database.Tables;
rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH_VIP.tungay);
rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH_VIP.denngay);
rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH_VIP.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke chi tiet xep loai khach hang VIP
if (CRM.frmMain.manhinhin == 28)
{
rptTKXLKH_VIP rptTKXLKH = new rptTKXLKH_VIP();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKXLKH;
CrTables = rptTKXLKH.Database.Tables;
rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_VIP.tungay);
rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_VIP.denngay);
rptTKXLKH.SetParameterValue("@loaikh", CRM.frmTKXLKH_VIP.loaikh);
rptTKXLKH.SetParameterValue("@dinhtinh", CRM.frmTKXLKH_VIP.dinhtinh);
rptTKXLKH.SetParameterValue("@pheduyet", CRM.frmTKXLKH_VIP.pheduyet);
rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_VIP.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//Danh sach chi nhanh da thuc hien xep loai khach hang
if (CRM.frmMain.manhinhin == 29)
{
rptDSCN rptTKXLKH = new rptDSCN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKXLKH;
CrTables = rptTKXLKH.Database.Tables;
rptTKXLKH.SetParameterValue("@tungay", CRM.frmTKXLKH_TH_VIP.tungay);
rptTKXLKH.SetParameterValue("@denngay", CRM.frmTKXLKH_TH_VIP.denngay);
rptTKXLKH.SetParameterValue("@cn", CRM.frmTKXLKH_TH_VIP.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In phieu diem cua khach hang
if (CRM.frmMain.manhinhin == 30)
{
DataSet1 ds = new DataSet1();
ds.Tables.Add(CRM.frmCSKH_TraCuuDiem.st_table);
rptPhieudiem objRpt = new rptPhieudiem();
objRpt.DataDefinition.FormulaFields["tencn"].Text = Thongtindangnhap.tencn;
objRpt.SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = objRpt;
//objRpt.SetParameterValue("@tencn", Thongtindangnhap.tencn);
crystalReportViewer1.Refresh();
}
//In bao cao thong ke khach hang nhan qua
if (CRM.frmMain.manhinhin == 31)
{
Cursor.Current = Cursors.WaitCursor;
if (frmCSKH_TKQT.loaibc == "1")
{
rptTKQTTH rptQTTH = new rptTKQTTH();
crystalReportViewer1.ReportSource = rptQTTH;
CrTables = rptQTTH.Database.Tables;
rptQTTH.SetParameterValue("@tungay", CRM.frmCSKH_TKQT.tungay);
rptQTTH.SetParameterValue("@denngay", CRM.frmCSKH_TKQT.denngay);
rptQTTH.SetParameterValue("@macn", CRM.frmCSKH_TKQT.macn);
rptQTTH.SetParameterValue("@loaibc", CRM.frmCSKH_TKQT.loaibc);
rptQTTH.SetParameterValue("@quatang", CRM.frmCSKH_TKQT.quatang);
}
else
{
rptCSKH_TKQTCT rptTKQTCT = new rptCSKH_TKQTCT();
crystalReportViewer1.ReportSource = rptTKQTCT;
CrTables = rptTKQTCT.Database.Tables;
rptTKQTCT.SetParameterValue("@tungay", CRM.frmCSKH_TKQT.tungay);
rptTKQTCT.SetParameterValue("@denngay", CRM.frmCSKH_TKQT.denngay);
rptTKQTCT.SetParameterValue("@macn", CRM.frmCSKH_TKQT.macn);
rptTKQTCT.SetParameterValue("@loaibc", CRM.frmCSKH_TKQT.loaibc);
rptTKQTCT.SetParameterValue("@quatang", CRM.frmCSKH_TKQT.quatang);
}
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke khách hàng chưa sử dụng SMS
if (CRM.frmMain.manhinhin == 32)
{
rptTKSMS rptTKS = new rptTKSMS();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKS;
CrTables = rptTKS.Database.Tables;
rptTKS.SetParameterValue("@cn", CRM.frmTKSMS.cn);
rptTKS.SetParameterValue("@loaikh", CRM.frmTKSMS.loaikh);
rptTKS.SetParameterValue("@dthoai", CRM.frmTKSMS.dthoai);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 33)
{
rptTKThe rptTKT = new rptTKThe();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTKT;
CrTables = rptTKT.Database.Tables;
rptTKT.SetParameterValue("@cn", CRM.frmTKThe.cn);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 34)
{
//Thong ke spdv cua khach hang la doanh nghiep
if (frmTKKHSPDV.loaikh == 2)
{
rptTKKHSPDVDN rptSPDVDN = new rptTKKHSPDVDN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptSPDVDN;
CrTables = rptSPDVDN.Database.Tables;
rptSPDVDN.SetParameterValue("@cn", CRM.frmTKKHSPDV.cn);
rptSPDVDN.SetParameterValue("@thang", CRM.frmTKKHSPDV.thang);
rptSPDVDN.SetParameterValue("@loaikh", CRM.frmTKKHSPDV.loaikh);
rptSPDVDN.SetParameterValue("@makh", CRM.frmTKKHSPDV.makh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
}
//Khach hang tien vay
if (frmTKKHSPDV.loaikh == 5)
{
rptTKKHVAYSPDV rptSPDVVAY = new rptTKKHVAYSPDV();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptSPDVVAY;
CrTables = rptSPDVVAY.Database.Tables;
rptSPDVVAY.SetParameterValue("@cn", CRM.frmTKKHSPDV.cn);
rptSPDVVAY.SetParameterValue("@thang", CRM.frmTKKHSPDV.thang);
rptSPDVVAY.SetParameterValue("@loaikh", CRM.frmTKKHSPDV.loaikh);
rptSPDVVAY.SetParameterValue("@makh", CRM.frmTKKHSPDV.makh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
}
//Thong ke spdv cua khach hang la ca nhan hoac nhan vien
if ((frmTKKHSPDV.loaikh == 1) || (frmTKKHSPDV.loaikh == 3) || (frmTKKHSPDV.loaikh == 4))
{
rptTKKHSPDVCN rptSPDVCN = new rptTKKHSPDVCN();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptSPDVCN;
CrTables = rptSPDVCN.Database.Tables;
rptSPDVCN.SetParameterValue("@cn", CRM.frmTKKHSPDV.cn);
rptSPDVCN.SetParameterValue("@thang", CRM.frmTKKHSPDV.thang);
rptSPDVCN.SetParameterValue("@loaikh", CRM.frmTKKHSPDV.loaikh);
rptSPDVCN.SetParameterValue("@makh", CRM.frmTKKHSPDV.makh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 35)
{
rptTK_DSBATD rptDSBATD = new rptTK_DSBATD();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptDSBATD;
CrTables = rptDSBATD.Database.Tables;
rptDSBATD.SetParameterValue("@cn", CRM.frmTK_BATD.chinhanh);
rptDSBATD.SetParameterValue("@tungay", CRM.frmTK_BATD.tungay);
rptDSBATD.SetParameterValue("@denngay", CRM.frmTK_BATD.denngay);
rptDSBATD.SetParameterValue("@lhbh", CRM.frmTK_BATD.lhbh);
rptDSBATD.SetParameterValue("@cbtd", CRM.frmTK_BATD.cbtd);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 36)
{
rptPHI_BATD rptP_BATD = new rptPHI_BATD();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptP_BATD;
CrTables = rptP_BATD.Database.Tables;
rptP_BATD.SetParameterValue("@cn", CRM.frmPHI_BATD.chinhanh);
rptP_BATD.SetParameterValue("@tungay", CRM.frmPHI_BATD.tungay);
rptP_BATD.SetParameterValue("@denngay", CRM.frmPHI_BATD.denngay);
rptP_BATD.SetParameterValue("@lhbh", CRM.frmPHI_BATD.lhbh);
rptP_BATD.SetParameterValue("@makh", CRM.frmPHI_BATD.makh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
if (CRM.frmMain.manhinhin == 37)
{
rptHHBATD rptHH_BATD = new rptHHBATD();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptHH_BATD;
CrTables = rptHH_BATD.Database.Tables;
rptHH_BATD.SetParameterValue("@cn", CRM.frmHH_BATD.chinhanh);
rptHH_BATD.SetParameterValue("@tungay", CRM.frmHH_BATD.tungay);
rptHH_BATD.SetParameterValue("@denngay", CRM.frmHH_BATD.denngay);
rptHH_BATD.SetParameterValue("@lhbh", CRM.frmHH_BATD.lhbh);
rptHH_BATD.SetParameterValue("@cbtd", CRM.frmHH_BATD.cbtd);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In khach hang kieu hoi
if (CRM.frmMain.manhinhin == 38)
{
rptTKKHNH rptTK_KHNH = new rptTKKHNH();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptTK_KHNH;
CrTables = rptTK_KHNH.Database.Tables;
rptTK_KHNH.SetParameterValue("@cn", CRM.frmTKKHNH.cn);
rptTK_KHNH.SetParameterValue("@tuthang", CRM.frmTKKHNH.tungay);
rptTK_KHNH.SetParameterValue("@denthang", CRM.frmTKKHNH.denngay);
rptTK_KHNH.SetParameterValue("@loaibc", CRM.frmTKKHNH.loaibc);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In lich su diem cua khach hang
if (CRM.frmMain.manhinhin == 39)
{
rptLichSuDiem rptLSD = new rptLichSuDiem();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptLSD;
CrTables = rptLSD.Database.Tables;
rptLSD.SetParameterValue("@makh", CRM.frmCSKH_ChiTiet.strmakh);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
//In thong ke nhan qua cua khach hang
if (CRM.frmMain.manhinhin == 40)
{
rptLichSuQT rptLSQT = new rptLichSuQT();
Cursor.Current = Cursors.WaitCursor;
crystalReportViewer1.ReportSource = rptLSQT;
CrTables = rptLSQT.Database.Tables;
rptLSQT.SetParameterValue("@makh", CRM.frmCSKH_TKQuaTang.strmakh);
rptLSQT.SetParameterValue("@tungay", CRM.frmCSKH_TKQuaTang.tungay);
rptLSQT.SetParameterValue("@denngay", CRM.frmCSKH_TKQuaTang.denngay);
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
CrTable.Location = "CRM" + ".dbo." + CrTable.Name;
}
Cursor.Current = Cursors.Default;
}
}
public void ShowRptData()
{
try
{
string strReportName = System.Web.HttpContext.Current.Session["ReportName"].ToString();
string cardCode = System.Web.HttpContext.Current.Session["CardCode"].ToString();
string cardName = System.Web.HttpContext.Current.Session["CardName"].ToString();
string startDate = System.Web.HttpContext.Current.Session["StartDate"].ToString();
string endDate = System.Web.HttpContext.Current.Session["EndDate"].ToString();
ReportDocument rd = new ReportDocument();
string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Report//" + strReportName;
ExceptionLog.Write(string.Format("the report path is {0}", strRptPath));
rd.Load(strRptPath);
TableLogOnInfo logInfo = new TableLogOnInfo();
logInfo.ConnectionInfo.ServerName = ".";
logInfo.ConnectionInfo.DatabaseName = "SBO_GS_TEST";
logInfo.ConnectionInfo.UserID = "sa";
logInfo.ConnectionInfo.Password = "******";
rd.Database.Tables[0].ApplyLogOnInfo(logInfo);
if (!string.IsNullOrEmpty(cardName))
rd.SetParameterValue("cardname", cardName);
if (!string.IsNullOrEmpty(startDate))
rd.SetParameterValue("Sdate", Convert.ToDateTime(startDate));
if (!string.IsNullOrEmpty(startDate))
rd.SetParameterValue("Edate", Convert.ToDateTime(endDate));
rd.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "crReport");
Session["ReportName"] = null;
Session["CardCode"] = null;
Session["CardName"] = null;
Session["StartDate"] = null;
Session["EndDate"] = null;
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void CreateReport()
{
crDoc = new ReportDocument();
SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection();
if (sqlcnn == null)
{
MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
SqlCommand sqlcmd = new SqlCommand();
SqlDataReader sqldr;
Tables CrTables;
ConnectionInfo crConnectionInfo = new ConnectionInfo();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
crConnectionInfo.Type = ConnectionInfoType.SQL;
crConnectionInfo.ServerName = "172.16.4.12";
crConnectionInfo.DatabaseName = "PTS";
crConnectionInfo.IntegratedSecurity = false;
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
string rpt = "";
if (rptName == "DraftPrepayInv")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "Prepayment.rpt";
crDoc.Load(rpt);
CrTables = crDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
sqlcmd = new SqlCommand("spPrepayments", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@CmpyCode", CmpyCode);
sqlcmd.Parameters.AddWithValue("@QuoteNo", QuoteNo);
sqlcmd.Parameters.AddWithValue("@RevNo", RevNo);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.Refresh();
}
else if (rptName == "PrepayInvoice")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PrepayInvoice.rpt";
crDoc.Load(rpt);
CrTables = crDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
sqlcmd = new SqlCommand("spPrepayInvoice", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@CmpyCode", CmpyCode);
sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
crDoc.PrintToPrinter(1, true, 0, 0);
crReport.Visible = false;
this.Dispose();
}
else if (nQ == 3)
{
crReport.Refresh();
crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\Invoices\" + DateTime.Now.Year.ToString() + "\\" + nInvNo.ToString("0000000") + ".pdf";
crDoc.ExportOptions.DestinationOptions = objDiskOpt;
crDoc.Export();
this.Dispose();
}
}
else if (rptName == "Invoice" || rptName == "InvoiceIngredion" || rptName == "DraftInvoiceMfst" || rptName == "InvoiceFHI" || rptName == "InvoiceOthers")
{
//decimal nPP = 0;
if (rptName == "Invoice")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "Invoice.rpt";
}
//else if (rptName == "InvoiceFHI")
// rpt = @"\\gblnj4\GIS\Reports\" + "InvoiceFHI.rpt";
//else if (rptName == "InvoiceIngredion")
// rpt = @"\\gblnj4\GIS\Reports\" + "IngredionInvMfst.rpt";
//else if (rptName == "DraftInvoiceMfst")
// rpt = @"\\gblnj4\GIS\Reports\" + "IngredionInvMfstX.rpt";
else if (rptName == "InvoiceOthers")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceOthers.rpt";
}
crDoc.Load(rpt);
CrTables = crDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
if (rptName == "DraftInvoiceMfst")
{
sqlcmd = new SqlCommand("spInvoiceX", sqlcnn);
}
else if (rptName == "InvoiceFHI")
{
sqlcmd = new SqlCommand("spFHITemplate", sqlcnn);
}
else if (rptName == "InvoiceOthers")
{
sqlcmd = new SqlCommand("spInvoiceOthers", sqlcnn);
}
else
{
sqlcmd = new SqlCommand("spInvoice", sqlcnn);
}
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
//if (rptName == "Invoice")
//{
// crDoc.SetParameterValue("@InvNo", nInvNo, "InvOtherFees");
//}
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
//Open the PrintDialog
this.printDialog1.Document = this.printDocument1;
DialogResult dr = this.printDialog1.ShowDialog();
if (dr == DialogResult.OK)
{
//Get the Copy times
int nCopy = this.printDocument1.PrinterSettings.Copies;
//Get the number of Start Page
int sPage = this.printDocument1.PrinterSettings.FromPage;
//Get the number of End Page
int ePage = this.printDocument1.PrinterSettings.ToPage;
//Get the printer name
string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
try
{
//Set the printer name to print the report to. By default the sample
//report does not have a defult printer specified. This will tell the
//engine to use the specified printer to print the report. Print out
//a test page (from Printer properties) to get the correct value.
crDoc.PrintOptions.PrinterName = PrinterName;
//Start the printing process. Provide details of the print job
//using the arguments.
crDoc.PrintToPrinter(nCopy, false, sPage, ePage);
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
crReport.Visible = false;
this.Dispose();
}
else if (nQ == 3) //email
{
crReport.Refresh();
crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\Invoices\" + DateTime.Now.Year.ToString() + @"\I-" + nInvNo.ToString("0000000") + ".pdf";
crDoc.ExportOptions.DestinationOptions = objDiskOpt;
crDoc.Export();
objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\Invoices\" + DateTime.Now.Year.ToString() + @"\I-" + nInvNo.ToString("0000000") + "_" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("00") +
DateTime.Now.Day.ToString("00") + "_" + DateTime.Now.TimeOfDay.Hours.ToString("00") + DateTime.Now.TimeOfDay.Minutes.ToString("00") + DateTime.Now.TimeOfDay.Seconds.ToString("00") + ".pdf";
crDoc.Export();
this.Dispose();
}
}
else if (rptName == "InvoiceIngredion")
{
decimal nPP = 0;
string strQ = "", strQNo = "", strRNo = "";
int nI = 0;
DataTable dt = PSSClass.FinalBilling.LoadInvServiceFees(nInvNo);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
strQNo = dt.Rows[i]["QuoteNo"].ToString();
nI = strQNo.IndexOf("R");
strQ = strQNo.Substring(0, nI - 1);
strRNo = strQNo.Substring(nI + 1, strQNo.Length - (nI + 1));
DataTable dtPP = PSSClass.FinalBilling.InvPrepay(dt.Rows[i]["CompanyCode"].ToString(), strQ, Convert.ToInt16(strRNo));
if (dtPP != null && dtPP.Rows.Count != 0)
{
for (int j = 0; j < dtPP.Rows.Count; j++)
{
nPP = nPP + Convert.ToDecimal(dtPP.Rows[j]["AmtDue"]);
}
}
}
}
//string rpt = @"\\gblnj4\GIS\Reports\" + "Invoice.rpt";
rpt = @"\\gblnj4\GIS\Reports\" + "IngredionInvMfstX.rpt";
crDoc.Load(rpt);
//crDoc.DataDefinition.FormulaFields["nPP"].Text = "'" + nPP.ToString() + "'";
crDoc.DataDefinition.FormulaFields["nPP"].Text = "'0'";
sqlcmd = new SqlCommand("spInvoiceX", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
//Open the PrintDialog
this.printDialog1.Document = this.printDocument1;
DialogResult dr = this.printDialog1.ShowDialog();
if (dr == DialogResult.OK)
{
//Get the Copy times
int nCopy = this.printDocument1.PrinterSettings.Copies;
//Get the number of Start Page
int sPage = this.printDocument1.PrinterSettings.FromPage;
//Get the number of End Page
int ePage = this.printDocument1.PrinterSettings.ToPage;
//Get the printer name
string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
try
{
//Set the printer name to print the report to. By default the sample
//report does not have a defult printer specified. This will tell the
//engine to use the specified printer to print the report. Print out
//a test page (from Printer properties) to get the correct value.
crDoc.PrintOptions.PrinterName = PrinterName;
//Start the printing process. Provide details of the print job
//using the arguments.
crDoc.PrintToPrinter(nCopy, false, sPage, ePage);
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
crReport.Visible = false;
this.Dispose();
}
}
else if (rptName == "RptForInvoice.rpt")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "RptForInvoice.rpt";
crDoc.Load(rpt);
sqlcmd = new SqlCommand("spRptForInvoice", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
//sqlcmd.Parameters.AddWithValue("@InvNo", nInvNo);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
crDoc.PrintToPrinter(1, true, 0, 0);
crReport.Visible = false;
this.Dispose();
}
//else if (nQ == 3)
//{
// crReport.Refresh();
// crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
// crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
// DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
// objDiskOpt.DiskFileName = @"\\gblnj4\GIS\Reports\I-" + nInvNo.ToString() + ".pdf";
// crDoc.ExportOptions.DestinationOptions = objDiskOpt;
// crDoc.Export();
// this.Dispose();
//}
}
else if (rptName == "POBalance")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "POBalance.rpt";
crDoc.Load(rpt);
sqlcmd = new SqlCommand("spPOBalance", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@SpID", nSpID);
sqlcmd.Parameters.AddWithValue("@PONo", strPO);
sqlcmd.Parameters.AddWithValue("@POBType", nPOBType);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.DataDefinition.FormulaFields["cPOBType"].Text = "'" + nPOBType.ToString() + "'";
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
crDoc.PrintToPrinter(1, true, 0, 0);
crReport.Visible = false;
this.Dispose();
}
//else if (nQ == 3)
//{
// crReport.Refresh();
// crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
// crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
// DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
// objDiskOpt.DiskFileName = @"\\gblnj4\GIS\Reports\I-" + nInvNo.ToString() + ".pdf";
// crDoc.ExportOptions.DestinationOptions = objDiskOpt;
// crDoc.Export();
// this.Dispose();
//}
}
else if (rptName == "POBalanceSum")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "POBalanceSum.rpt";
crDoc.Load(rpt);
sqlcmd = new SqlCommand("spPOBalanceSum", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
crDoc.PrintToPrinter(1, true, 0, 0);
crReport.Visible = false;
this.Dispose();
}
}
else if (rptName == "SOA")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "SOA.rpt";
crDoc.Load(rpt);
sqlcmd = new SqlCommand("spSOA", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@CustomerID", nSpID.ToString());
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
if (nQ == 1) //Preview
{
crReport.Refresh();
}
else if (nQ == 2) //Direct Print
{
crDoc.PrintToPrinter(1, true, 0, 0);
crReport.Visible = false;
this.Dispose();
}
else if (nQ == 3)
{
crReport.Refresh();
crDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\SOA\" + DateTime.Now.Year.ToString() + @"\SOA-" + nSpID.ToString() + ".pdf";
crDoc.ExportOptions.DestinationOptions = objDiskOpt;
crDoc.Export();
objDiskOpt.DiskFileName = @"\\PSAPP01\IT Files\PTS\PDF Reports\SOA\" + DateTime.Now.Year.ToString() + @"\SOA-" + nSpID.ToString() + "-" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("00") +
DateTime.Now.Day.ToString("00") + "_" + DateTime.Now.TimeOfDay.Hours.ToString("00") + DateTime.Now.TimeOfDay.Minutes.ToString("00") + DateTime.Now.TimeOfDay.Seconds.ToString("00") + ".pdf";
crDoc.ExportOptions.DestinationOptions = objDiskOpt;
crDoc.Export();
}
}
else if (rptName == "Comparative Revenue Report" || rptName == "Comparative Revenue Report - Grouped by Sponsor")
{
if (rptName == "Comparative Revenue Report")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceComparativeReport.rpt";
}
else
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceComparativeReport-BySponsor.rpt";
}
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptInvoiceComparativeReport", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.ShowGroupTreeButton = false;
crReport.Refresh();
}
else if (rptName == "TTM")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "TTM.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE 12-MONTH PERIOD: " + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptMngtTTM", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.ShowGroupTreeButton = false;
crReport.Refresh();
}
else if (rptName == "Exceptions List")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "AdjustmentsList.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptAdjustmentsList", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.ShowGroupTreeButton = false;
crReport.Refresh();
}
else if (rptName == "Invoices To Be Posted" || rptName == "Invoices To Be Posted - Grouped by Sponsor" || rptName == "Invoices To Be Posted - Sorted by Sponsor ASC")
{
if (rptName == "Invoices To Be Posted")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoicesToBePosted.rpt";
}
else if (rptName == "Invoices To Be Posted - Grouped by Sponsor")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoicesToBePosted_GrpBySponsor.rpt";
}
else if (rptName == "Invoices To Be Posted - Sorted by Sponsor ASC")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoicesToBePostedBySponsorAsc.rpt";
}
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptInvoiceComparativeReport", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.ShowGroupTreeButton = false;
crReport.Refresh();
dTable.Dispose();
}
else if (rptName == "TemporaryInvoice")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvoiceTemp.rpt";
crDoc.Load(rpt);
sqlcmd = new SqlCommand("spInvoiceTemp", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@PONo", strPO);
sqlcmd.Parameters.AddWithValue("@ConID", nConID);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.ShowGroupTreeButton = false;
crReport.Refresh();
}
this.WindowState = FormWindowState.Maximized;
}
public void GenerateReport_Inside(string parameter)
{
try
{
ReportDocument objReport1 = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo ConInfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
if (File.Exists(_path + _reportName_Inside))
{
objReport1.Load(_path + _reportName_Inside);
}
else
{
objReport1.Load(ClsConfig.LotCardPCSReportPath_Trial + _reportName_Inside);
}
crParameterDiscreteValue.Value = parameter;
crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//objReport1.SetParameterValue("@LotCardGroupNo", _formNos.ToString().Trim(), objReport1.Subreports[0].Name.ToString());
string sUserID = ClsConfig.ReportUser;
string sPassword = ClsConfig.ReportPassword_BarcodeDB;
string sServerName = ClsConfig.ReportServer_BarcodeDB;
string sDatabaseName = ClsConfig.ReportDatabase_BarcodeDB;
crConnectionInfo.ServerName = sServerName;
crConnectionInfo.DatabaseName = sDatabaseName;
crConnectionInfo.UserID = sUserID;
crConnectionInfo.Password = sPassword;
CrTables = objReport1.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
ConInfo = CrTable.LogOnInfo;
ConInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(ConInfo);
}
docB = objReport1;
reportViewer2.ViewerCore.ReportSource = docB;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Report1()
{
//creating an object of ParameterField class
ParameterField paramField1 = new ParameterField();
// ParameterField paramField2 = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields1 = new ParameterFields();
// ParameterFields paramFields2 = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
//ParameterDiscreteValue paramDiscreteValue2 = new ParameterDiscreteValue();
//set the parameter field name
paramField1.Name = "id";
// paramField2.Name = "cheque no";
//set the parameter value
paramDiscreteValue1.Value = x;
//paramDiscreteValue2.Value = cmbAccountDNo.Text;
//add the parameter value in the ParameterField object
paramField1.CurrentValues.Add(paramDiscreteValue1);
//paramField2.CurrentValues.Add(paramDiscreteValue2);
//add the parameter in the ParameterFields object
paramFields1.Add(paramField1);
// paramFields2.Add(paramField2);
//set the parameterfield information in the crystal report
ReportViewer f2 = new ReportViewer();
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "tcp:KyotoServer,49172";
with1.DatabaseName = "BankReconciliationDBProNovember";
with1.UserID = "sa";
with1.Password = "******";
Reports.ChequeDestroy cr = new Reports.ChequeDestroy();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields1;
// f2.crystalReportViewer1.ParameterFieldInfo = paramFields2; //set the parameterfield information in the crystal report
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
private void btnRptView_Click(object sender, EventArgs e)
{
// try
// {
// frmReportViewer objRpt = new frmReportViewer();
// ReportDocument objRptDoc = new ReportDocument();
// ConnectionInfo objConInfo = new ConnectionInfo();
// TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
// Tables objCrTables;
// objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVehInOutDet.rpt");
// objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
// objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
// objConInfo.UserID = GeneralBLL.GetDBUserName();
// objConInfo.Password = GeneralBLL.GetDBPwd();
// objConInfo.IntegratedSecurity = false;
// objCrTables = objRptDoc.Database.Tables;
// foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables)
// {
// objTableLogOnInfo = objCrTable.LogOnInfo;
// objTableLogOnInfo.ConnectionInfo = objConInfo;
// objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
// }
// DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text);
// DateTime mToDate = Convert.ToDateTime(dtpToDate.Text);
// int tempValue;
// string strSelect;
// strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({VEHINOUTDETAIL.ENTRYDATE}) <= #" + mToDate.ToString("yyyy-MM-dd") + "# ";
//// CONVERT(varchar, mFromDate, 23)
// //if (cboType.Text == "ALL")
// //{
// // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
// // strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
// //}
// if (cboType.Text == "COMPANY")
// {
// tempValue = 1;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// }
// else if (cboType.Text == "IN/OUT OTHER")
// {
// tempValue = 4;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// }
// objRptDoc.RecordSelectionFormula = strSelect;
// objRpt.crystalReportViewer1.ReportSource = objRptDoc;
// objRpt.MdiParent = this.MdiParent;
// objRpt.WindowState = FormWindowState.Maximized;
// objRpt.crystalReportViewer1.Refresh();
// objRpt.Show();
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// }
try
{
frmReportViewer objRpt = new frmReportViewer();
rptVehInOutDet objRptDoc = new rptVehInOutDet();
ConnectionInfo objConInfo = new ConnectionInfo();
TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
Tables objCrTables;
if (cboType.Text == "COMPANY")
{
objRptDoc.SetParameterValue("@Type", 4);
}
else if (cboType.Text == "IN/OUT OTHER")
{
objRptDoc.SetParameterValue("@Type", 1);
}
objRptDoc.SetParameterValue("@FromDate", dtpFromDate.Value.Date);
objRptDoc.SetParameterValue("@ToDate", dtpToDate.Value.Date);
//objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVehInOutDet.rpt");
objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
objConInfo.UserID = GeneralBLL.GetDBUserName();
objConInfo.Password = GeneralBLL.GetDBPwd();
objConInfo.IntegratedSecurity = false;
objCrTables = objRptDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables)
{
objTableLogOnInfo = objCrTable.LogOnInfo;
objTableLogOnInfo.ConnectionInfo = objConInfo;
objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
}
//DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text);
//DateTime mToDate = Convert.ToDateTime(dtpToDate.Text);
//int tempValue;
//string strSelect;
//strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({VEHINOUTDETAIL.ENTRYDATE}) <= #" + mToDate.ToString("yyyy-MM-dd") + "# ";
//// CONVERT(varchar, mFromDate, 23)
////if (cboType.Text == "ALL")
////{
//// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
//// strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
////}
//if (cboType.Text == "COMPANY")
//{
// tempValue = 1;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
//}
//else if (cboType.Text == "IN/OUT OTHER")
//{
// tempValue = 4;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
//}
//objRptDoc.RecordSelectionFormula = strSelect;
objRpt.crystalReportViewer1.ReportSource = objRptDoc;
objRpt.MdiParent = this.MdiParent;
objRpt.WindowState = FormWindowState.Maximized;
objRpt.crystalReportViewer1.Refresh();
objRpt.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void GenerateReport(string parameter)
{
try
{
string _Report = string.Empty;
if (_reportType == "Normal")
{
_Report = _reportName_Outside;
}
else if (_reportType == "Replacement")
{
_Report = _reportName_Outside_Replacement;
}
else
{
_Report = _reportName_Outside_Sample;
}
ReportDocument objReport1 = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo ConInfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
if (File.Exists(_path + _Report))
{
objReport1.Load(_path + _Report);
}
else
{
objReport1.Load(ClsConfig.LotCardCantierReportPath_Trial + _Report);
}
crParameterDiscreteValue.Value = parameter;
crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
string sUserID = ClsConfig.ReportUser;
string sPassword = ClsConfig.ReportPassword;
string sServerName = ClsConfig.ReportServer;
string sDatabaseName = ClsConfig.ReportDatabase_LotCard;
crConnectionInfo.ServerName = sServerName;
crConnectionInfo.DatabaseName = sDatabaseName;
crConnectionInfo.UserID = sUserID;
crConnectionInfo.Password = sPassword;
CrTables = objReport1.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
ConInfo = CrTable.LogOnInfo;
ConInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(ConInfo);
}
docA = objReport1;
reportViewer.ViewerCore.ReportSource = docA;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private bool genReport()
{
DataTable dtMap = new DataTable("GSOrder"); //*** DataTable Map DataSet.xsd ***//
DataTable m_dt = (DataTable)Session["DATATABLE"];
DataRow dr = null;
dtMap.Columns.Add(new DataColumn("RTVData", typeof(string)));
dtMap.Columns.Add(new DataColumn("CustName", typeof(string)));
dtMap.Columns.Add(new DataColumn("GSOrderNo", typeof(string)));
dtMap.Columns.Add(new DataColumn("CreatedDate", typeof(string)));
dtMap.Columns.Add(new DataColumn("Remark", typeof(string)));
dtMap.Columns.Add(new DataColumn("Description", typeof(string)));
dtMap.Columns.Add(new DataColumn("ProdName", typeof(string)));
dtMap.Columns.Add(new DataColumn("Barcode", typeof(System.Byte[])));
for (int i = 0; i < (m_dt.Rows.Count); i++)
{
dr = dtMap.NewRow();
FileStream fiStream = new FileStream(Server.MapPath("~/Barcode/" + m_dt.Rows[i]["TransBillNo"].ToString() + ".jpeg"), FileMode.Open, FileAccess.Read);
BinaryReader binReader = new BinaryReader(fiStream);
byte[] pic1 = { };
pic1 = binReader.ReadBytes((int)fiStream.Length);
fiStream.Close();
binReader.Close();
dr["RTVData"] = m_dt.Rows[i]["RTVData"];
dr["CustName"] = m_dt.Rows[i]["CustName"];
dr["GSOrderNo"] = m_dt.Rows[i]["GSOrderNo"];
dr["CreatedDate"] = m_dt.Rows[i]["CreatedDate"];
dr["Remark"] = m_dt.Rows[i]["Remark"];
dr["Description"] = m_dt.Rows[i]["Description"];
dr["ProdName"] = m_dt.Rows[i]["ProdName"];
dr["Barcode"] = pic1;
dtMap.Rows.Add(dr);
}
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("~/Report/GSOrderReport.rpt"));
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in rpt.Database.Tables)
{
TableLogOnInfo tableLogOnInfo = crTable.LogOnInfo;
object connectionInfo = tableLogOnInfo.ConnectionInfo;
crTable.ApplyLogOnInfo(tableLogOnInfo);
}
rpt.SetDataSource(dtMap);
crVW.ReportSource = rpt;
// crVw.RefreshReport();
return(true);
}
private void toolStripButtonPrint_Click(object sender, EventArgs e)
{
try
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "InformeTesFacturasEnviadas.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@FechaDesde";
ParametroValue.Value = this.dateTimePickerFechaDesde.Value.ToString("yyyy-MM-dd 00:00:00");
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//2° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@FechaHasta";
ParametroValue.Value = this.dateTimePickerFechaHasta.Value.ToString("yyyy-MM-dd 23:59:59");
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//3° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@codEmp";
ParametroValue.Value = Clases.Usuario.EmpresaLogeada.EmpresaIngresada;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ShowLiquidationReportForRead(int? iBatchId, int? iReadId)
{
try
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
var rptLiquidation = new LiquidationSummary_PS();
string sVersion, sSiteName;
GetVersion_SiteName(out sVersion, out sSiteName);
rptLiquidation.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
rptLiquidation.SetParameterValue("@BatchId", iBatchId);
rptLiquidation.SetParameterValue("@ReadId", iReadId);
rptLiquidation.SetParameterValue("BMCVersion", sVersion);
rptLiquidation.SetParameterValue("@BatchId", iBatchId, "Liquidation_Summary_PS_Sub.rpt");
rptLiquidation.SetParameterValue("@ReadId", iReadId, "Liquidation_Summary_PS_Sub.rpt");
rptLiquidation.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
rptLiquidation.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol(), "Liquidation_Summary_PS_Sub.rpt");
rptLiquidation.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString);
List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_ExchangeConnectionString);
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = rptLiquidation.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = rptLiquidation;
AuditReports();
strReportName = "Report Liquidation Summary";
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void toolStripButtonPrint_Click(object sender, EventArgs e)
{
try
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "PrecioUltimaCompraFactura.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@Anio";
ParametroValue.Value = this.textBoxAnio.Text;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//2° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@Mes";
ParametroValue.Value = this.textBoxMes.Text;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//3° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@codEmp";
ParametroValue.Value = (this.comboBoxEmpresa.SelectedIndex == 0) ? "EGES":"RSC";
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//4° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@TipoINF";
if (this.comboBoxTipoInf.SelectedIndex == 0)
{
ParametroValue.Value = "LPR";
}
if (this.comboBoxTipoInf.SelectedIndex == 2)
{
ParametroValue.Value = "OSO";
}
if (this.comboBoxTipoInf.SelectedIndex == 1)
{
ParametroValue.Value = "ART";
}
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//5° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@Articulo";
if (this.comboBoxTipoInf.SelectedIndex == 0)
{
ParametroValue.Value = "NULL";
}
if (this.comboBoxTipoInf.SelectedIndex == 1)
{
ParametroValue.Value = this.comboBoxProductos.SelectedValue;
}
if (this.comboBoxTipoInf.SelectedIndex == 2)
{
ParametroValue.Value = "NULL";
}
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//6° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@ObraSocial";
if (this.comboBoxTipoInf.SelectedIndex == 0)
{
ParametroValue.Value = "NULL";
}
if (this.comboBoxTipoInf.SelectedIndex == 1)
{
ParametroValue.Value = "NULL";
}
if (this.comboBoxTipoInf.SelectedIndex == 2)
{
ParametroValue.Value = this.comboBoxObraSocial.SelectedValue;
}
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
if (checkBoxListaPreciosOS.Checked)
{
InformeListaPreciosXOS();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//
public void ShowNonSGVILiquidationReport(DataSet dsReportsDataSet, DataSet dsSummaryReport, int BatchNo)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowLiquidationReport method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
NonSGVILiquidation LiquidationReport = new NonSGVILiquidation();
BMC.Presentation.POS.Reports.NonSGVILiquidationSummary LiquidationSummaryReport = new BMC.Presentation.POS.Reports.NonSGVILiquidationSummary();
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
LiquidationReport.SetDataSource(dsReportsDataSet);
LiquidationSummaryReport.SetDataSource(dsSummaryReport);
LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info);
LiquidationReport.SetParameterValue("@Batch_No", BatchNo);
LiquidationSummaryReport.SetParameterValue("@Batch_No", BatchNo);
IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString);
List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_ExchangeConnectionString);
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = LiquidationReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crDatabase = LiquidationSummaryReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
ReportDocument doc = LiquidationReport.OpenSubreport("NonSGVILiquidationSummary.rpt");
doc.SetDataSource(dsSummaryReport);
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = LiquidationReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "System Balancing Report";
}
catch (Exception ex)
{
throw ex;
}
}
private void PurchaseRequisitionRpt_Load(object sender, EventArgs e)
{
SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection();
if (sqlcnn == null)
{
MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact your administrator.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
ReportDocument crDoc = new ReportDocument();
SqlCommand sqlcmd = new SqlCommand();
SqlDataReader sqldr;
Tables CrTables;
ConnectionInfo crConnectionInfo = new ConnectionInfo();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
crConnectionInfo.Type = ConnectionInfoType.SQL;
crConnectionInfo.ServerName = "172.16.4.12";
crConnectionInfo.DatabaseName = "PTS";
crConnectionInfo.IntegratedSecurity = false;
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
if (DlvrTo == 1)
{
rptName = "PRForm16.rpt";
}
else
{
rptName = "PRForm122.rpt";
}
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + rptName;
crDoc.Load(rpt);
CrTables = crDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
sqlcmd = new SqlCommand("spRptPRForm", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@CmpyCode", CmpyCode);
sqlcmd.Parameters.AddWithValue("@PRNo", PRNo);
sqldr = sqlcmd.ExecuteReader();
DataTable dTable = new DataTable();
try
{
dTable.Load(sqldr);
sqlcnn.Dispose();
}
catch
{
sqlcnn.Dispose();
}
crDoc.SetDataSource(dTable);
crReport.ReportSource = crDoc;
crReport.Refresh();
}
public void ShowPartCollection(int NoofRecords,string ExchangeConn, String TicketingConn)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowPartCollection method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
PartCollectionReport Partcol = new PartCollectionReport();
Partcol.SetParameterValue("@NumberofRecords", NoofRecords);
Partcol.SetParameterValue("SiteName", sSiteName);
Partcol.SetParameterValue("Version", sVersion);
Partcol.SetParameterValue("Region", Settings.Region);
Partcol.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
IReports objReports = ReportsBusinessObject.CreateInstance(ExchangeConn, TicketingConn);
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(ExchangeConn);
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = Partcol.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = Partcol;
AuditReports();
strReportName = "Part Collection Report";
}
catch (Exception ex)
{
throw ex;
}
}
private void frmRComprasTrabajador_Load(object sender, EventArgs e)
{
try
{
string fechaInicio = frmReporteComprasTrabajador.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd");
string fechaFin = frmReporteComprasTrabajador.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd");
int idTrabajador = Convert.ToInt32(frmReporteComprasTrabajador.f1.cbProducto.SelectedValue);
ReportDocument repdoc = new ReportDocument();
// repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RComprasTrabajador.rpt");
repdoc.Load(@"D:\Reportes\RComprasTrabajador.rpt");
ParameterFieldDefinitions pfds;
ParameterFieldDefinition pfd;
ParameterValues pvs = new ParameterValues();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pdv.Value = Convert.ToDateTime(fechaInicio + " 00:00:00");
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@fechaInicio"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
pdv.Value = Convert.ToDateTime(fechaFin + " 23:59:59");
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@fechaFin"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
pdv.Value = idTrabajador;
pfds = repdoc.DataDefinition.ParameterFields;
pfd = pfds["@idTrabajador"];
pvs.Add(pdv);
pfd.ApplyCurrentValues(pvs);
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS";
crConnectionInfo.DatabaseName = "SISVENTAS_CA";
crConnectionInfo.UserID = "admin";
crConnectionInfo.Password = "******";
/*
* crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS";
* crConnectionInfo.DatabaseName = "db_restauranteAlmacen";
* crConnectionInfo.UserID = "martin";
* crConnectionInfo.Password = "******";*/
CrTables = repdoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
cvVentas.ReportSource = repdoc;
cvVentas.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("ERROR" + ex);
}
}
public void ShowVaultEventDetailReport(int Vault_Id, string Type, int No_Of_Records, string searchkey, DateTime StartDate, DateTime EndDate)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside Show Vault Event Details Report method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
CashDispenserTransactionDetails VaultEventDet = new CashDispenserTransactionDetails();
VaultEventDet.SetParameterValue("SiteCode", Settings.SiteCode);
VaultEventDet.SetParameterValue("@EventType", Type);
VaultEventDet.SetParameterValue("@No_Of_Records", No_Of_Records);
VaultEventDet.SetParameterValue("@SearchKey", searchkey);
VaultEventDet.SetParameterValue("@StartDate", StartDate);
VaultEventDet.SetParameterValue("@EndDate", EndDate);
VaultEventDet.SetParameterValue("SiteName", sSiteName);
VaultEventDet.SetParameterValue("Version", sVersion);
VaultEventDet.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
VaultEventDet.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
VaultEventDet.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
IReports objReports = ReportsBusinessObject.CreateInstance();
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = VaultEventDet.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = VaultEventDet;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Vault Event Details Report";
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateReport()
{
Tables CrTables;
ConnectionInfo crConnectionInfo = new ConnectionInfo();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
crConnectionInfo.Type = ConnectionInfoType.SQL;
crConnectionInfo.ServerName = "172.16.4.12";
crConnectionInfo.DatabaseName = "PTS";
crConnectionInfo.IntegratedSecurity = false;
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection();
if (sqlcnn == null)
{
MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
SqlCommand sqlcmd = new SqlCommand();
SqlDataReader sqldr;
crDoc = new ReportDocument();
if (rptName == "InvYrTotal")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InvYrTotal.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spInvYrTotRpt", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "LogYrTotal")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "LogYrTotal.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cGBL"].Text = "" + nGBL + "";
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spLogYrTotRpt", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
sqlcmd.Parameters.AddWithValue("@GBL", nGBL);
}
else if (rptName == "RptYrTotal")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "RptYrTotal.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cGBL"].Text = "" + nGBL + "";
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spRptYrTot", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
sqlcmd.Parameters.AddWithValue("@GBL", nGBL);
}
else if (rptName == "NewSponsors")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "NewSponsors.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE YEAR " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spNewCustomers", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "InactiveSponsors")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "InactiveSponsors.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE YEAR " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spInactiveCustomers", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "MgmtGraph")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtSummary.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'FY " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spMgmtTotRpt", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "MgmtQuoteRpt")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "QuotesByDept.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FY " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spQuoteAnaDept", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
sqlcmd.Parameters.AddWithValue("@Sort", 1);
}
else if (rptName == "ProformaRev")
{
string rpt = "";
if (nMgmtRev >= 1 && nMgmtRev <= 4)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "ProformaRev.rpt";
}
else
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "ProformaRevSC.rpt";
}
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FY " + nYr.ToString() + "'";
if (nMgmtRev == 1)
{
crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'ALL SPONSORS'";
sqlcmd = new SqlCommand("spProformaRevAll", sqlcnn);
}
//else if (nMgmtRev == 2)
//{
// crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'NON-INGREDION SPONSORS'";
// sqlcmd = new SqlCommand("spProformaRev", sqlcnn);
//}
//else if (nMgmtRev == 3)
//{
// crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'INGREDION'";
// sqlcmd = new SqlCommand("spProformaRevIng", sqlcnn);
//}
else if (nMgmtRev == 4)
{
crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'STABILITY'";
sqlcmd = new SqlCommand("spProformaRevSta", sqlcnn);
}
//else if (nMgmtRev == 5)
//{
// crDoc.DataDefinition.FormulaFields["cCategory"].Text = "'STERILIZATION'";
// sqlcmd = new SqlCommand("spProformaRevSter", sqlcnn);
//}
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Year", nYr);
sqlcmd.Parameters.AddWithValue("@SpID", SpID);
sqlcmd.Parameters.AddWithValue("@SC", SC);
sqlcmd.CommandTimeout = 60;
}
else if (rptName == "IngredionRevenue")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "IngredionRevenue.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cYear"].Text = "'" + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spIngredionRevRpt", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "IngredionProfDtls")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "IngredionProfDtls.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cYear"].Text = "'" + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spIngredionProfDtls", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "MgmtRevenue")
{
string rpt = "";
if (nMgmtRev == 1 || nMgmtRev == 2)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevenue.rpt";
}
else if (nMgmtRev == 3 || nMgmtRev == 4)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSC.rpt";
}
else if (nMgmtRev >= 5 && nMgmtRev <= 8)
{
if (nMgmtRev == 5 || nMgmtRev == 6)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSpSumm.rpt";
}
else
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSpDtls.rpt";
}
}
else if (nMgmtRev >= 9 && nMgmtRev <= 12)
{
if (nMgmtRev == 9 || nMgmtRev == 10)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSCSumm.rpt";
}
else
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "MgmtRevSCDtls.rpt";
}
}
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FY " + nYr.ToString() + "'";
sqlcmd = new SqlCommand("spRevPivotRpt", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Year", nYr);
if (nMgmtRev == 1 || nMgmtRev == 3 || nMgmtRev == 5 || nMgmtRev == 7 || nMgmtRev == 9 || nMgmtRev == 11)
{
sqlcmd.Parameters.AddWithValue("@SpID", 0);
sqlcmd.Parameters.AddWithValue("@SC", 0);
}
else if (nMgmtRev == 2 || nMgmtRev == 4 || nMgmtRev == 6 || nMgmtRev == 8 || nMgmtRev == 10 || nMgmtRev == 12)
{
sqlcmd.Parameters.AddWithValue("@SpID", SpID);
sqlcmd.Parameters.AddWithValue("@SC", SC);
}
}
else if (rptName == "PSSFinancial")
{
sqlcnn.Close(); sqlcmd.Dispose();
sqlcnn = PSSClass.DBConnection.MDFConnection("172.16.4.12", "PTSFinancials", false, "sa", "Pass2018", "");
if (sqlcnn == null)
{
MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
sqlcmd = new SqlCommand();
crConnectionInfo.DatabaseName = "PTSFinancials";
crConnectionInfo.IntegratedSecurity = false;
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
this.Text = "FINANCIAL REPORT";
string strDay = "";
decimal nIT = PSSClass.Financials.IncomeTax(nYr);
string[] strMonths = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
int[] nLYMonths = new int[] { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
int[] nNLYMonths = new int[] { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
int nR = nYr % 4;
if (nR == 0)
{
strDay = nLYMonths[nMo - 1].ToString();
}
else
{
strDay = nNLYMonths[nMo - 1].ToString();
}
string rpt = "";
if (nFSFormat == 0)
{
//rpt = Application.StartupPath + @"\Reports\" + "PSSFinancial.rpt";
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancial.rpt";
}
else if (nFSFormat == 1)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFSSummary.rpt";
}
else if (nFSFormat == 2)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialNoPer.rpt";
}
else if (nFSFormat == 3)
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialGL.rpt";
}
crDoc.Load(rpt);
CrTables = crDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE PERIOD ENDED " + strMonths[nMo - 1].ToUpper() + " " + strDay + ", " + nYr.ToString() + "'";
crDoc.DataDefinition.FormulaFields["strMo"].Text = "'" + nMo.ToString() + "'";
crDoc.DataDefinition.FormulaFields["cTaxes"].Text = nIT.ToString();
sqlcmd = new SqlCommand("spLinkFinancial", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName == "PSSFinancial_12Month")
{
sqlcnn.Close(); sqlcmd.Dispose();
sqlcnn = PSSClass.DBConnection.MDFConnection("172.16.4.12", "PTSFinancials", false, "sa", "Pass2018", "");
if (sqlcnn == null)
{
MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact the IT Department.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
sqlcmd = new SqlCommand();
crConnectionInfo.DatabaseName = "PTSFinancials";
crConnectionInfo.IntegratedSecurity = false;
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
this.Text = "FINANCIAL REPORT::12 MONTH OVERVIEW";
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancial_12Month.rpt";
//string strDay = "";
//decimal nIT = PSSClass.Financials.IncomeTax(nYr);
//string[] strMonths = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
//int[] nLYMonths = new int[] { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
//int[] nNLYMonths = new int[] { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
//int nR = nYr % 4;
//if (nR == 0)
// strDay = nLYMonths[nMo - 1].ToString();
//else
// strDay = nNLYMonths[nMo - 1].ToString();
//string rpt = "";
//if (nFSFormat == 0)
// rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancial_12Month.rpt";
//else if (nFSFormat == 1)
// rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFSSummary.rpt";
//else if (nFSFormat == 2)
// rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialNoPer.rpt";
//else if (nFSFormat == 3)
// rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PSSFinancialGL.rpt";
crDoc.Load(rpt);
CrTables = crDoc.Database.Tables;
//foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
//{
// crtableLogoninfo = CrTable.LogOnInfo;
// crtableLogoninfo.ConnectionInfo = crConnectionInfo;
// CrTable.ApplyLogOnInfo(crtableLogoninfo);
//}
//crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'FOR THE PERIOD ENDED " + strMonths[nMo - 1].ToUpper() + " " + strDay + ", " + nYr.ToString() + "'";
//crDoc.DataDefinition.FormulaFields["strMo"].Text = "'" + nMo.ToString() + "'";
//crDoc.DataDefinition.FormulaFields["cTaxes"].Text = nIT.ToString();
sqlcmd = new SqlCommand("spLinkFinancial", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
}
else if (rptName.IndexOf("Variance") != -1)
{
this.Text = "VARIANCE REPORT - BUDGET VS. ACTUAL";
string strDay = "";
string rpt = "";
decimal nIT = PSSClass.Financials.IncomeTax(nYr);
string[] strMonths = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
int[] nLYMonths = new int[] { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
int[] nNLYMonths = new int[] { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
int nR = nYr % 4;
if (nR == 0)
{
strDay = nLYMonths[nMo - 1].ToString();
}
else
{
strDay = nNLYMonths[nMo - 1].ToString();
}
if (rptName == "VarianceYTD")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "Variance.rpt";
}
else if (rptName == "VarianceMonthly")
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "VarianceMonthly.rpt";
}
else
{
rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "VarianceQtrly.rpt";
}
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cMo"].Text = "'" + nMo.ToString() + "'";
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'" + nYr.ToString() + "'";
crDoc.DataDefinition.FormulaFields["cDay"].Text = "'" + strDay + "'";
crDoc.DataDefinition.FormulaFields["cQtr"].Text = "'" + nQtr.ToString() + "'";
}
else if (rptName == "TestsCompleted")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "TestsCompleted.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptTestsCompleted", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqlcmd.Parameters.AddWithValue("@DeptList", strDept); //nDeptID
}
else if (rptName == "OutstandingTests")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "OutstandingTests.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptOutstandingGBLTesting", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqlcmd.Parameters.AddWithValue("@DeptList", strDept); //nDeptID
}
else if (rptName == "TestsForCompletion")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "TestsForCompletion.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptTestsForCompletion", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
}
else if (rptName == "StabilityReport")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "StabilityReport-New.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'RANGE PERIOD: " + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spStabilityReport", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@SDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EDate", dteEnd);
}
else if (rptName == "StudyDirReport")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "StudyDirRpt.rpt";
crDoc.Load(rpt);
if (dteStart == dteEnd)
{
crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'FOR THE PERIOD: " + dteStart.ToShortDateString() + "'";
}
else
{
crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'FOR THE PERIOD: " + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'";
}
sqlcmd = new SqlCommand("spStudyDirReport", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqlcmd.Parameters.AddWithValue("@SDID", nSDID);
}
else if (rptName == "UnmailedReports")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "UnmailedReports.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptUnmailedReports", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
}
else if (rptName == "EqptServiceSched")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "EquipmentServiceSched.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["dteStart"].Text = "'" + dteStart.ToShortDateString() + "'";
crDoc.DataDefinition.FormulaFields["dteEnd"].Text = "'" + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptEqptSrvcSched", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
}
else if (rptName == "SCDepartments")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "SCDepartments.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'" + dteStart.ToShortDateString() + " - " + dteEnd.ToShortDateString() + "'";
sqlcmd = new SqlCommand("spRptDeptSCSP", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@StartDate", dteStart);
sqlcmd.Parameters.AddWithValue("@EndDate", dteEnd);
sqlcmd.Parameters.AddWithValue("@DeptID", nDeptID);
sqlcmd.Parameters.AddWithValue("@SC", SC);
}
else if (rptName == "DocExpiring")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "DocExpiring.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cPeriod"].Text = "'As of " + DateTime.Now.ToString("MMMM dd, yyyy") + "'";
sqlcmd = new SqlCommand("spDocExpiringAlert", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
}
else if (rptName == "SpeedResponse")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "SpeedResponse.rpt";
string strSpName = PSSClass.Sponsors.SpName(SpID);
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'" + nYr.ToString("###0") + "'";
crDoc.DataDefinition.FormulaFields["cMo"].Text = "'" + nMo.ToString("###0") + "'";
crDoc.DataDefinition.FormulaFields["cSpID"].Text = "'" + SpID.ToString() + "'";
crDoc.DataDefinition.FormulaFields["cSpName"].Text = "'" + strSpName + "'";
}
else if (rptName == "RptGBLErrors")
{
string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "RptGBLErrors.rpt";
crDoc.Load(rpt);
crDoc.DataDefinition.FormulaFields["cYr"].Text = "'" + nYr.ToString() + "'";
crDoc.DataDefinition.FormulaFields["cGBL"].Text = "'" + nGBL.ToString() + "'";
sqlcmd = new SqlCommand("spRptGBLErrors", sqlcnn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Yr", nYr);
sqlcmd.Parameters.AddWithValue("@IncGBL", nGBL);
sqlcmd.CommandTimeout = 60;
}
DataTable dTable = new DataTable();
if (rptName == "PSSFinancial")
{
dTable = PSSClass.Financials.AcctSummary(nYr);
}
else if (rptName == "PSSFinancial_12Month")
{
dTable = PSSClass.Financials.AcctSummary(nYr);
}
else if (rptName.IndexOf("Variance") != -1)
{
dTable = dtRpt;
}
else if (rptName == "SpeedResponse")
{
dTable.Columns.Add("Category", typeof(int));
dTable.Columns.Add("NoDays", typeof(int));
dTable.Columns.Add("DayCount", typeof(int));
//LogTests Start Date
DataTable dtX = PSSClass.ManagementReports.SpeedResponse(1, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "LT.StartDate", Convert.ToInt16(SpID));
for (int i = 0; i < dtX.Rows.Count; i++)
{
DataRow dR = dTable.NewRow();
dR["Category"] = dtX.Rows[i]["Category"];
dR["NoDays"] = dtX.Rows[i]["NoDays"];
dR["DayCount"] = dtX.Rows[i]["DayCount"];
dTable.Rows.Add(dR);
}
//FinalRptLog DateOn LogTests End Date
dtX = PSSClass.ManagementReports.SpeedResponse(2, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "FL.DateOn", Convert.ToInt16(SpID));
for (int i = 0; i < dtX.Rows.Count; i++)
{
DataRow dR = dTable.NewRow();
dR["Category"] = dtX.Rows[i]["Category"];
dR["NoDays"] = dtX.Rows[i]["NoDays"];
dR["DayCount"] = dtX.Rows[i]["DayCount"];
dTable.Rows.Add(dR);
}
//LogTests End Date
dtX = PSSClass.ManagementReports.SpeedResponse(3, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "LT.EndDate", Convert.ToInt16(SpID));
for (int i = 0; i < dtX.Rows.Count; i++)
{
DataRow dR = dTable.NewRow();
dR["Category"] = dtX.Rows[i]["Category"];
dR["NoDays"] = dtX.Rows[i]["NoDays"];
dR["DayCount"] = dtX.Rows[i]["DayCount"];
dTable.Rows.Add(dR);
}
//FinalRptLog DateOff
dtX = PSSClass.ManagementReports.SpeedResponse(4, Convert.ToInt16(nYr), Convert.ToInt16(nMo), "FL.DateOff", Convert.ToInt16(SpID));
for (int i = 0; i < dtX.Rows.Count; i++)
{
DataRow dR = dTable.NewRow();
dR["Category"] = dtX.Rows[i]["Category"];
dR["NoDays"] = dtX.Rows[i]["NoDays"];
dR["DayCount"] = dtX.Rows[i]["DayCount"];
dTable.Rows.Add(dR);
}
//LogTest Start Date vs FinalRptLog DateOn
dtX = PSSClass.ManagementReports.SpeedResponseSD(4, Convert.ToInt16(nYr), Convert.ToInt16(nMo), Convert.ToInt16(SpID));
for (int i = 0; i < dtX.Rows.Count; i++)
{
DataRow dR = dTable.NewRow();
dR["Category"] = dtX.Rows[i]["Category"];
dR["NoDays"] = dtX.Rows[i]["NoDays"];
dR["DayCount"] = dtX.Rows[i]["DayCount"];
dTable.Rows.Add(dR);
}
}
else
{
sqldr = sqlcmd.ExecuteReader();
try
{
dTable.Load(sqldr);
}
catch { }
}
crDoc.SetDataSource(dTable);
CrTables = crDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
crReport.ReportSource = crDoc;
crReport.ShowGroupTreeButton = false;
crReport.Refresh();
sqlcnn.Close(); sqlcnn.Dispose();
this.WindowState = FormWindowState.Maximized;
}
internal void ShowCrossPropertyLiabilityTransferSummaryReport(string p, DataSet dtDataset, DateTime StartDate, DateTime EndDate)
{
try
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo();
DbConnectionDetails.DatabaseName = "TICKETING";
connectionInfo.ServerName = DbConnectionDetails.ServerName;
connectionInfo.UserID = DbConnectionDetails.UserName;
connectionInfo.Password = DbConnectionDetails.Password;
connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName;
string sVersion, sSiteName;
var vCrossPropertyLiabilityTransferSummaryReport = new CrossPropertyLiabilityTransferSummaryReport();
vCrossPropertyLiabilityTransferSummaryReport.SetDataSource(dtDataset);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("@STARTDATE", StartDate);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("@ENDDATE", EndDate);
GetVersion_SiteName(out sVersion, out sSiteName);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("SiteCode", Settings.SiteCode);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("siteName", sSiteName);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("BMCVersion", sVersion);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
vCrossPropertyLiabilityTransferSummaryReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
crDatabase = vCrossPropertyLiabilityTransferSummaryReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = vCrossPropertyLiabilityTransferSummaryReport;
AuditReports();
strReportName = "Cross Property Liability Transfer Summary Report";
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void toolStripButtonPrint_Click(object sender, EventArgs e)
{
try
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "InformeRequerimientosInternos.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@FechaDesde";
ParametroValue.Value = this.dateTimePickerFechaDesde.Value.ToString("yyyy-MM-dd 00:00:00");
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//2° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@FechaHasta";
ParametroValue.Value = this.dateTimePickerFechaHasta.Value.ToString("yyyy-MM-dd 23:59:59");
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//3er PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@Tipo";
if (this.radioButtonTodo.Checked)
{
ParametroValue.Value = "TOD";
}
if (this.radioButtonAnulados.Checked)
{
ParametroValue.Value = "ANU";
}
if (this.radioButtonRechazados.Checked)
{
ParametroValue.Value = "REC";
}
if (this.radioButtonAutorizados.Checked)
{
ParametroValue.Value = "AUT";
}
if (this.radioButtonPendientes.Checked)
{
ParametroValue.Value = "PEN";
}
if (this.radioButtonSectorUnico.Checked)
{
ParametroValue.Value = "SEC";
}
if (this.radioButtonPorNro.Checked)
{
ParametroValue.Value = "NRO";
}
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//4° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@codEmp";
ParametroValue.Value = Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString();
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//5° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@Sector";
if (this.radioButtonSectorUnico.Checked)
{
ParametroValue.Value = Clases.Usuario.UsuarioLogeado.Id_Sector;
}
else
{
ParametroValue.Value = null;
}
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//6° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@usuario_id";
ParametroValue.Value = Clases.Usuario.UsuarioLogeado.id_usuario_Logeado;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//7° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@NroReq";
ParametroValue.Value = Convert.ToInt32(textBoxNroReq.Text == "" ? "0" : textBoxNroReq.Text);
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ShowStackerLevelDetailReport(DataSet dsStackerDetails, int StackerLevel,string siteCode)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowStackerLevelDetailReport method", LogManager.enumLogLevel.Info);
StackerLevelDetailsReport stackerDetailReport = new StackerLevelDetailsReport();
GetVersion_SiteName(out sVersion, out sSiteName);
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
stackerDetailReport.SetDataSource(dsStackerDetails);
stackerDetailReport.SetParameterValue("SiteName", sSiteName);
stackerDetailReport.SetParameterValue("Version", sVersion);
stackerDetailReport.SetParameterValue("@StackerLevel", StackerLevel);
stackerDetailReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
stackerDetailReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
stackerDetailReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
stackerDetailReport.SetParameterValue("SiteCode", siteCode);
//stackerDetailReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture, "StackerLevelDetailsReport.rpt");
//stackerDetailReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol(), "StackerLevelDetailsReport.rpt");
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo();
DbConnectionDetails.DatabaseName = "EXCHANGE";
connectionInfo.ServerName = DbConnectionDetails.ServerName;
connectionInfo.UserID = DbConnectionDetails.UserName;
connectionInfo.Password = DbConnectionDetails.Password;
connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName;
crDatabase = stackerDetailReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = stackerDetailReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Stacker Level Details Report";
}
catch (Exception ex)
{
throw ex;
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
if (radioIM.Checked)
{
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "IndicacionesMedicas.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
}
else if (chckVertical.Checked)
{
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "HojaEnfermeriaVertical.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
}
else
{
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "HojaEnfermeria.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
}
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSISTMED"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@PACIENTE_ID";
ParametroValue.Value = Clases.Paciente.PacienteIngresado;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
////2° PARAMETRO
//ParametroField = new ParameterField();
//ParametroValue = new ParameterDiscreteValue();
//ParametroField.Name = "@TODOS";
//ParametroValue.Value = this.radioTodos.Checked;
//ParametroField.CurrentValues.Add(ParametroValue);
//Parametros.Add(ParametroField);
////3° PARAMETRO
//ParametroField = new ParameterField();
//ParametroValue = new ParameterDiscreteValue();
//ParametroField.Name = "@SEDE";
//ParametroValue.Value = Clases.Paciente.PacienteSede;
//ParametroField.CurrentValues.Add(ParametroValue);
//Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ShowCollectionReport(int BatchNo, int WeekNo)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowBatchWinLossReport method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
CollectionReport oCollectionReport = new CollectionReport();
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info);
oCollectionReport.SetParameterValue("@BatchNo", BatchNo);
oCollectionReport.SetParameterValue("@WeekCollection", WeekNo > 0 ? true : false);
oCollectionReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
oCollectionReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
oCollectionReport.SetParameterValue("Version", sVersion);
oCollectionReport.SetParameterValue("Region", Settings.Region);
IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString);
List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(BMC.Business.CashDeskOperator.CommonUtilities.SiteConnectionString(_ExchangeConnectionString));
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = oCollectionReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = oCollectionReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "batch winloss report";
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("test3ed");
Response.End();
// since we are using Crystal to do everything, the web page is built here
if (!IsPostBack)
{
Session["dtPrint"] = null;
if (Session["UserName"] == null)
{
UserPrefix = "NoUser";
}
else
{
UserPrefix = Session["UserName"].ToString().Trim();
}
if (Request.QueryString["ShipperNo"] != null)
{
ShipperNo = Request.QueryString["ShipperNo"].ToString();
// clear out any previous exports first
DirectoryInfo OldPages = new DirectoryInfo(Server.MapPath(@"SOEShipper"));
// Get a reference to each file in that directory.
FileInfo[] AllOldPages = OldPages.GetFiles();
// go through the files
foreach (FileInfo OldPage in AllOldPages)
{
if (OldPage.Name.Substring(0, UserPrefix.Length) == UserPrefix)
{
OldPage.Delete();
}
}
// load the crystal report using the path in an app pref record
DataSet dsAppPref = new DataSet();
dsAppPref = SqlHelper.ExecuteDataset(connectionString, "[UGEN_SP_Select]",
new SqlParameter("@tableName", "AppPref with (NOLOCK)"),
new SqlParameter("@displayColumns", "AppOptionValue"),
new SqlParameter("@whereCondition", " (ApplicationCd = 'SOE') AND (AppOptionType = 'InvoiceLocation')"));
CrystalPath = dsAppPref.Tables[0].Rows[0]["AppOptionValue"].ToString();
Response.Write("Windows Account which runs ASP.NET is: " + Environment.Username);
Response.Write("test3");
Response.End();
try
{
ShipperDoc.Load(CrystalPath + "SOEShipper.rpt", OpenReportMethod.OpenReportByTempCopy);
}
catch (Exception ex)
{
throw ex;
}
// set the database connections for the report
SqlConnectionStringBuilder ConnectBuilder = new SqlConnectionStringBuilder();
ConnectBuilder.ConnectionString = connectionString;
ConnectionInfo ConnectInfo = new ConnectionInfo();
ConnectInfo.DatabaseName = ConnectBuilder["Initial Catalog"].ToString();
ConnectInfo.UserID = ConnectBuilder["User Id"].ToString();
ConnectInfo.Password = ConnectBuilder["Password"].ToString();
ConnectInfo.ServerName = ConnectBuilder["Data Source"].ToString();
// AutoDataBind="true"
foreach (CrystalDecisions.CrystalReports.Engine.Table ShipperTable in ShipperDoc.Database.Tables)
{
TableLogOnInfo ShipperTableLogonInfo = ShipperTable.LogOnInfo;
ShipperTableLogonInfo.ConnectionInfo = ConnectInfo;
ShipperTable.ApplyLogOnInfo(ShipperTableLogonInfo);
}
ShipperDoc.RecordSelectionFormula = "{SOHeaderRel.OrderNo}=" + ShipperNo;
// we are ready to go
ShipperDoc.Refresh();
// Now set up the export
DiskFileDestinationOptions diskOpts = ExportOptions.CreateDiskFileDestinationOptions();
ExportOptions exportOpts = new ExportOptions();
exportOpts.ExportFormatType = ExportFormatType.HTML40;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.ExportDestinationOptions = diskOpts;
HTMLFormatOptions htmlFormatOpts = new HTMLFormatOptions();
htmlFormatOpts.FirstPageNumber = 1;
htmlFormatOpts.HTMLEnableSeparatedPages = true;
htmlFormatOpts.HTMLHasPageNavigator = false;
htmlFormatOpts.HTMLBaseFolderName = Server.MapPath("");
htmlFormatOpts.HTMLFileName = UserPrefix + "ShipperExport.htm";
exportOpts.ExportFormatOptions = htmlFormatOpts;
ShipperDoc.Export(exportOpts);
ShipperDoc.Close();
// now that we have created the individual pages, make one big page
DirectoryInfo PageFiles = new DirectoryInfo(Server.MapPath(@"SOEShipper"));
// Get a reference to each file in that directory.
FileInfo[] AllPages = PageFiles.GetFiles();
// start the HTML page
Response.Write("<head>\n");
// write the styles
Response.Write("<style type=\"text/css\">\n");
Response.Write(".barcode{height:30px;font-size:15pt;color:#000000;font-family:IDAutomationC39M;font-weight:normal;overflow:hidden;}\n");
Response.Write("</style>\n");
// finish the header start the body
Response.Write("\n<title>Shipper Document</title>\n</head>\n<body LEFTMARGIN=31 TOPMARGIN=31 >\n");
PagePosition = (decimal)0.0;
foreach (FileInfo InvPage in AllPages)
{
// get only the files for the current user
if (InvPage.Name.Substring(0, UserPrefix.Length) == UserPrefix)
{
WriteOK = false;
Response.Write("<DIV style=\"position:absolute; left:0px; top:" + PagePosition.ToString() + "pt; height:590px \">\n");
//Response.Write("");
using (StreamReader sr = new StreamReader(InvPage.FullName))
{
String line;
// Read and display lines from the file until the end of
// the file is reached.
while ((line = sr.ReadLine()) != null)
{
if (line.Contains("</BODY>"))
{
WriteOK = false;
}
if (line.Contains("<style>"))
{
WriteOK = true;
}
if (line.Contains("images/"))
{
line = line.Replace("images/", ConfigurationManager.AppSettings["SOESiteURL"].ToString() + "SOEShipper/images/");
}
// write the line
if (WriteOK)
{
Response.Write(line + "\n");
}
if (line.Contains("</style>"))
{
WriteOK = false;
}
if (line.Contains("<BODY"))
{
WriteOK = true;
}
}
}
Response.Write("</DIV>\n");
if (PagePosition == (decimal)0.0)
{
PagePosition += (decimal)590;
}
}
}
Response.Write("</body>\n</html>\n");
}
}
}
private static void GetLogoninfo(TableLogOnInfo li, XmlWriter writer)
{
WriteAndTraceStartElement(writer, "Logoninfo");
writer.WriteAttributeString("ReportName", li.ReportName);
writer.WriteAttributeString("TableName", li.TableName);
GetConnectioInfo(li.ConnectionInfo, writer);
writer.WriteEndElement();
}
private bool GenerarPDFOC(string _codEmp, int _NroOrdenCompra, string Email)
{
try
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "OrdenDeCompra.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
//PAOS LOS PARAMTROS EN ORDEN
objReport.SetParameterValue(0, _codEmp);
objReport.SetParameterValue(1, "OC");
objReport.SetParameterValue(2, _NroOrdenCompra);
objReport.SetParameterValue(3, _NroOrdenCompra);
objReport.SetParameterValue(4, null);
objReport.SetParameterValue(5, null);
objReport.SetParameterValue(6, 1);
objReport.SetParameterValue(7, "");
objReport.SetParameterValue(8, null);
objReport.SetParameterValue(9, null);
//GUARDO EN FORMATO PDF
string _path = ConfigurationManager.AppSettings["PDF"] + "\\PDF\\" + "OrdenDeCompra.PDF";
objReport.ExportToDisk(ExportFormatType.PortableDocFormat, _path);
//_codEmp = (_codEmp == "EGES") ? "EGESAC S.A." : "RSC S.A.";
if (EnviarMail(_codEmp, _path, Email))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
/// <summary>
/// Thiết lập các thông tin kết nối cơ sở dữ liệu cho báo cáo
/// </summary>
/// <param name="reportDocument"></param>
private void SetDBLogonForReport(ReportDocument reportDocument)
{
crConnectioninfo = new ConnectionInfo();
crConnectioninfo.ServerName = WorkingContext.Setting.Server;
crConnectioninfo.DatabaseName = WorkingContext.Setting.Database;
crConnectioninfo.UserID = WorkingContext.Setting.UserName;
crConnectioninfo.Password = WorkingContext.Setting.Password;
crTables = reportDocument.Database.Tables;
crDatabase = reportDocument.Database;
crTables = crDatabase.Tables;
foreach (Table crTable in crTables)
{
try
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectioninfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
catch
{
string str = WorkingContext.LangManager.GetString("frmListReport_thongbao");
string str1 = WorkingContext.LangManager.GetString("frmListReport_thongbao_Title");
//MessageBox.Show("Không thể đăng nhập được vào cơ sở dữ liệu","Thông báo",MessageBoxButtons.OK,MessageBoxIcon.Error);
MessageBox.Show(str, str1, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// since we are using Crystal to do everything, the web page is built here
if (!IsPostBack)
{
Session["dtPrint"] = null;
if (Session["UserName"] == null)
{
UserPrefix = "NoUser";
}
else
{
UserPrefix = Session["UserName"].ToString().Trim();
}
if ((Request.QueryString["InvoiceNo"] != null) || (Request.QueryString["OrderNo"] != null))
{
// clear out any previous exports first
DirectoryInfo OldPages = new DirectoryInfo(Server.MapPath(DocName));
if (OldPages.Exists)
{
// Get a reference to each file in that directory.
FileInfo[] AllOldPages = OldPages.GetFiles();
// go through the files
foreach (FileInfo OldPage in AllOldPages)
{
if (OldPage.Name.Substring(0, UserPrefix.Length) == UserPrefix)
{
OldPage.Delete();
}
}
}
// get the TEST watermark indicator
DataSet dsAppPref = new DataSet();
dsAppPref = SqlHelper.ExecuteDataset(connectionString, "[UGEN_SP_Select]",
new SqlParameter("@tableName", "SystemMaster with (NOLOCK)"),
new SqlParameter("@displayColumns", "PrintRqst"),
new SqlParameter("@whereCondition", " SystemMasterID = 0"));
PrintRequest = dsAppPref.Tables[0].Rows[0]["PrintRqst"].ToString().Trim();
// load the crystal report using the path in an app pref record
dsAppPref = SqlHelper.ExecuteDataset(connectionString, "[UGEN_SP_Select]",
new SqlParameter("@tableName", "AppPref with (NOLOCK)"),
new SqlParameter("@displayColumns", "AppOptionValue"),
new SqlParameter("@whereCondition", " (ApplicationCd = 'SOE') AND (AppOptionType = 'InvoiceLocation')"));
CrystalPath = dsAppPref.Tables[0].Rows[0]["AppOptionValue"].ToString();
RGRDoc.Load(CrystalPath + DocName + ".rpt", OpenReportMethod.OpenReportByTempCopy);
// set the database connections for the report
SqlConnectionStringBuilder ConnectBuilder = new SqlConnectionStringBuilder();
ConnectBuilder.ConnectionString = connectionString;
ConnectionInfo ConnectInfo = new ConnectionInfo();
ConnectInfo.DatabaseName = ConnectBuilder["Initial Catalog"].ToString();
ConnectInfo.UserID = ConnectBuilder["User Id"].ToString();
ConnectInfo.Password = ConnectBuilder["Password"].ToString();
ConnectInfo.ServerName = ConnectBuilder["Data Source"].ToString();
// AutoDataBind="true"
foreach (CrystalDecisions.CrystalReports.Engine.Table RGRTable in RGRDoc.Database.Tables)
{
TableLogOnInfo RGRTableLogonInfo = RGRTable.LogOnInfo;
RGRTableLogonInfo.ConnectionInfo = ConnectInfo;
RGRTable.ApplyLogOnInfo(RGRTableLogonInfo);
}
// set the selection criteria
if (Request.QueryString["InvoiceNo"] != null)
{
RGRDoc.RecordSelectionFormula = "{SOHeaderHist.InvoiceNo}=\"" + Request.QueryString["InvoiceNo"].ToString() + "\" and isnull({SODetailHist.DeleteDt})";
}
if (Request.QueryString["OrderNo"] != null)
{
RGRDoc.RecordSelectionFormula = "{SOHeaderHist.OrderNo}=" + Request.QueryString["OrderNo"].ToString() + " and isnull({SODetailHist.DeleteDt})";
}
// we are ready to go
RGRDoc.Refresh();
// Now set up the export
DiskFileDestinationOptions diskOpts = ExportOptions.CreateDiskFileDestinationOptions();
ExportOptions exportOpts = new ExportOptions();
exportOpts.ExportFormatType = ExportFormatType.HTML40;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.ExportDestinationOptions = diskOpts;
HTMLFormatOptions htmlFormatOpts = new HTMLFormatOptions();
htmlFormatOpts.FirstPageNumber = 1;
htmlFormatOpts.HTMLEnableSeparatedPages = true;
htmlFormatOpts.HTMLHasPageNavigator = false;
htmlFormatOpts.HTMLBaseFolderName = Server.MapPath("");
htmlFormatOpts.HTMLFileName = UserPrefix + "InvoiceExport.htm";
exportOpts.ExportFormatOptions = htmlFormatOpts;
// set the parameters
if (PrintRequest == "T")
{
RGRDoc.SetParameterValue("IsTest", true);
}
else
{
RGRDoc.SetParameterValue("IsTest", false);
}
// Export the report to separate html files
RGRDoc.Export(exportOpts);
RGRDoc.Close();
// now that we have created the individual pages, make one big page
DirectoryInfo PageFiles = new DirectoryInfo(Server.MapPath(DocName));
// Get a reference to each file in that directory.
FileInfo[] AllPages = PageFiles.GetFiles();
// start the HTML page
Response.Write("<head>\n<title>RGR Document</title>\n");
if ((Request.QueryString["ScriptX"] != null) && (Request.QueryString["ScriptX"] == "YES"))
{
// Embed ScriptX objects
using (StreamReader sr = new StreamReader(Server.MapPath("common/include/ScriptX.inc")))
{
String incline;
// Read and display lines from the Spriptx include file
while ((incline = sr.ReadLine()) != null)
{
Response.Write(incline + "\n");
}
}
// Load ScriptX javascript function
Response.Write("<script src=\"" + ConfigurationManager.AppSettings["SOESiteURL"].ToString() + "Common/JavaScript/ScriptX.js\" type=\"text/javascript\"></script>\n");
}
Response.Write("</head>\n<body style=\"margin: 0px\" >\n");
PagePosition = (decimal)0.0;
foreach (FileInfo InvPage in AllPages)
{
// get only the files for the current user
if (InvPage.Name.Substring(0, UserPrefix.Length) == UserPrefix)
{
WriteOK = false;
Response.Write("<DIV style=\"position:absolute; top:" + PagePosition.ToString() + "pt; height:1000px \">\n");
//Response.Write("");
using (StreamReader sr = new StreamReader(InvPage.FullName))
{
String line;
// Read and display lines from the file until the end of
// the file is reached.
while ((line = sr.ReadLine()) != null)
{
if (line.Contains("</BODY>"))
{
WriteOK = false;
}
if (line.Contains("<style>"))
{
WriteOK = true;
}
if (line.Contains("class=\"crystalstyle\""))
{
line = line.Replace("31", "0");
}
if (line.Contains("images/"))
{
line = line.Replace("images/", ConfigurationManager.AppSettings["SOESiteURL"].ToString() + DocName + "/images/");
}
if (line.Contains("<DIV style=\"position:absolute; top:"))
{
WriteOK = false;
}
if (line.Contains("</TR></TABLE></CENTER></Div>"))
{
WriteOK = false;
}
// write the line
if (WriteOK)
{
Response.Write(line + "\n");
}
if (line.Contains("</style>"))
{
WriteOK = false;
}
if (line.Contains("<BODY"))
{
WriteOK = true;
}
}
}
Response.Write("</DIV>\n");
if (PagePosition == (decimal)0.0)
{
PagePosition += (decimal)757;
}
}
}
Response.Write("</body>\n");
if ((Request.QueryString["ScriptX"] != null) && (Request.QueryString["ScriptX"] == "YES"))
{
Response.Write("<script language=\"javascript\">\n");
Response.Write("SetPrintSettings(true, 0.25, 0.25, 0.25, 0.25);\n");
Response.Write("</script>\n");
}
Response.Write("</html>\n");
}
}
}
private bool genReport()
{
DataTable dtMap = new DataTable("job"); //*** DataTable Map DataSet.xsd ***//
DataTable m_dt = (DataTable)Session["DATATABLE"];
DataRow dr = null;
dtMap.Columns.Add(new DataColumn("job_id", typeof(string)));
dtMap.Columns.Add(new DataColumn("job_name", typeof(string)));
dtMap.Columns.Add(new DataColumn("job_date", typeof(string)));
dtMap.Columns.Add(new DataColumn("place_get_job", typeof(string)));
dtMap.Columns.Add(new DataColumn("container_type", typeof(string)));
dtMap.Columns.Add(new DataColumn("container_dim", typeof(string)));
dtMap.Columns.Add(new DataColumn("cust_dest", typeof(string)));
dtMap.Columns.Add(new DataColumn("code_name", typeof(string)));
dtMap.Columns.Add(new DataColumn("appointed_time", typeof(string)));
dtMap.Columns.Add(new DataColumn("doc_no", typeof(string)));
dtMap.Columns.Add(new DataColumn("place_send_job", typeof(string)));
dtMap.Columns.Add(new DataColumn("send_company", typeof(string)));
dtMap.Columns.Add(new DataColumn("remark", typeof(string)));
dtMap.Columns.Add(new DataColumn("barcode", typeof(System.Byte[])));
FileStream fiStream = new FileStream(Server.MapPath("~/Barcode/" + m_dt.Rows[0]["job_id"].ToString() + ".jpeg"), FileMode.Open, FileAccess.Read);
BinaryReader binReader = new BinaryReader(fiStream);
byte[] pic1 = { };
pic1 = binReader.ReadBytes((int)fiStream.Length);
fiStream.Close();
binReader.Close();
for (int i = 0; i < (m_dt.Rows.Count); i++)
{
dr = dtMap.NewRow();
dr["job_id"] = m_dt.Rows[i]["job_id"];
dr["job_name"] = m_dt.Rows[i]["job_name"];
dr["job_date"] = m_dt.Rows[i]["job_date"];
dr["place_get_job"] = m_dt.Rows[i]["place_get_job"];
dr["container_type"] = m_dt.Rows[i]["container_type"];
dr["container_dim"] = m_dt.Rows[i]["container_dim"];
dr["cust_dest"] = m_dt.Rows[i]["cust_dest"];
dr["code_name"] = m_dt.Rows[i]["code_name"];
dr["appointed_time"] = m_dt.Rows[i]["appointed_time"];
dr["doc_no"] = m_dt.Rows[i]["doc_no"];
dr["place_send_job"] = m_dt.Rows[i]["place_send_job"];
dr["send_company"] = m_dt.Rows[i]["send_company"];
dr["remark"] = m_dt.Rows[i]["remark"];
dr["Barcode"] = pic1;
dtMap.Rows.Add(dr);
}
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("~/Report/job.rpt"));
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in rpt.Database.Tables)
{
TableLogOnInfo tableLogOnInfo = crTable.LogOnInfo;
object connectionInfo = tableLogOnInfo.ConnectionInfo;
crTable.ApplyLogOnInfo(tableLogOnInfo);
}
rpt.SetDataSource(dtMap);
crVw.ReportSource = rpt;
// crVw.RefreshReport();
return(true);
}
private void Generate_Reports()
{
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
cryRpt.Load(Server.MapPath("Graph.rpt"));
//crConnectionInfo.ServerName = "213.171.197.149,49296";
//crConnectionInfo.DatabaseName = "DBCML";
//crConnectionInfo.UserID = "CMLT";
//crConnectionInfo.Password = "******";
crConnectionInfo.ServerName = Constants.CMLTConstants.serverName;
crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName;
crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName;
crConnectionInfo.Password = Constants.CMLTConstants.dbPassword;
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
//string _s = "MEP";
//string selectionformula = "{CAS_RPT.BZONE}='" + _s + "' and {CAS_RPT.CATE}=\"DB\"";
//SelectionFormula(cryRpt, (string)Session["zone"], (string)Session["cat"], (string)Session["flvl"], (string)Session["fed"]);
string _graph = "";
_graph = "Summary - " + drtype.SelectedItem.Text;
if ((string)Session["zone"] == null)
{
Session["zone"] = "All";
}
if ((string)Session["flvl"] == null)
{
Session["flvl"] = "All";
}
if ((string)Session["cat"] == null)
{
Session["cat"] = "All";
}
if ((string)Session["fed"] == null)
{
Session["fed"] = "All";
}
if ((string)Session["loc"] == null)
{
Session["loc"] = "All";
}
string _name = lblsch.Text;
if (lblprj.Text == "SRH" && (lblsch.Text == "25" || lblsch.Text == "26"))
{
_name = lblsch.Text + "_" + lblprj.Text;
}
cryRpt.SetParameterValue("name", _name);
cryRpt.SetParameterValue("project", get_project());
cryRpt.SetParameterValue("data_title", Get_Title());
cryRpt.SetParameterValue("graph", _graph);
cryRpt.SetParameterValue("bz", (string)Session["zone"]);
cryRpt.SetParameterValue("cat", (string)Session["cat"]);
cryRpt.SetParameterValue("fl", (string)Session["flvl"]);
cryRpt.SetParameterValue("ff", (string)Session["fed"]);
cryRpt.SetParameterValue("lo", (string)Session["loc"]);
CrystalReportViewer1.ReportSource = cryRpt;
CrystalReportViewer1.DataBind();
Session["Report"] = cryRpt;
}
private bool PrintReport(string sql)
{
if (report_var.customer_cr == null)
{
report_var.customer_cr = new ReportDocument();
}
else
{
report_var.customer_cr.Close();
report_var.customer_cr = null;
report_var.customer_cr = new ReportDocument();
}
//检测报表文件是否存在
if (File.Exists(rms_var.GetReportPath() + report_var.customer_rpt_filename))
{
report_var.customer_cr = report_var.LoadReport(rms_var.GetReportPath() + report_var.customer_rpt_filename, sql, "view_customer");
TableLogOnInfo logOnInfo = new TableLogOnInfo();
int i;
// 对报表中的每个表依次循环。
for (i = 0; i <= report_var.customer_cr.Database.Tables.Count - 1; i++)
{
// 设置当前表的连接信息。
logOnInfo.ConnectionInfo.ServerName = rms_var.ReadStrfromReg("SQLServerName", "");
logOnInfo.ConnectionInfo.DatabaseName = rms_var.ReadStrfromReg("DataBaseName", "");
logOnInfo.ConnectionInfo.UserID = rms_var.ReadStrfromReg("SQL_User", "");
logOnInfo.ConnectionInfo.Password = rms_var.ReadStrfromReg("SQL_PSW", "");
report_var.customer_cr.Database.Tables[i].ApplyLogOnInfo(logOnInfo);
}
report_var.customer_cr.PrintToPrinter(1, true, 1, 1);
return true;
}
else
{
MessageBox.Show("报表文件不存在，请检查系统初始化中的设置是否正确。如果问题依然存在，请联系系统供应商。");
return false;
}
}
static void ExportToMSMail(string _codEmp, int _NroOrdenCompra)
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "OrdenDeCompra.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
//PAOS LOS PARAMTROS EN ORDEN
objReport.SetParameterValue(0, _codEmp);
objReport.SetParameterValue(1, "OC");
objReport.SetParameterValue(2, _NroOrdenCompra);
objReport.SetParameterValue(3, _NroOrdenCompra);
objReport.SetParameterValue(4, null);
objReport.SetParameterValue(5, null);
objReport.SetParameterValue(6, 1);
//PdfRtfWordFormatOptions pdfOpts = ExportOptions.CreatePdfRtfWordFormatOptions();
PdfFormatOptions pdfOpts = new PdfFormatOptions();
MicrosoftMailDestinationOptions mailOpts = ExportOptions.CreateMicrosoftMailDestinationOptions();
ExportOptions exportOpts = new ExportOptions();
pdfOpts.UsePageRange = false;
exportOpts.ExportFormatOptions = pdfOpts;
mailOpts.MailCCList = "*****@*****.**";
mailOpts.MailMessage = "PRUEBA DE CORREO OC HECTOR";
mailOpts.MailSubject = "PRUEBA";
mailOpts.MailToList = "*****@*****.**";
mailOpts.Password = "******";
mailOpts.UserName = "******";
exportOpts.ExportDestinationOptions = mailOpts;
exportOpts.ExportDestinationType = ExportDestinationType.MicrosoftMail;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
objReport.Export(exportOpts);
}
