public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return(rpt);
}
private void Form1_Load(object sender, EventArgs e)
{
#region 水晶报表
CrystalReport1 cr = new CrystalReport1();
var title = cr.Section1.ReportObjects["TextTitle"];
if (title.Kind == ReportObjectKind.TextObject)
{
((TextObject)title).Text = "XX一览";
}
cr.ParameterFields["type"].CurrentValues.AddValue("这是水晶报表");
crystalReportViewer1.ReportSource = cr;
#endregion
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from orderUser where id = " + j + "";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable1);
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "select * from items where order_id = " + j + "";
cmd2.ExecuteNonQuery();
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(ds.DataTable2);
da2.Fill(dt2);
tot = 0;
foreach (DataRow dr2 in dt2.Rows)
{
tot = tot + Convert.ToInt32(dr2["total"].ToString());
}
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(ds);
myreport.SetParameterValue("total", tot.ToString());
crystalReportViewer1.ReportSource = myreport;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from issue_books where books_return_date=''";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable1);
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(ds);
crystalReportViewer1.ReportSource = myreport;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void loadPrint()
{
if (salescommit == "1")
{
string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'";
string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'";
try
{
aa.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(q1, aa);
DataSet1 mydataset = new DataSet1();
da.Fill(mydataset, "Sales");
da.Dispose();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = new SqlCommand(q2, aa);
da2.Fill(mydataset, "SalesSummary");
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(mydataset);
PrintMemo pm = new PrintMemo();
pm.crystalReportViewer1.ReportSource = myreport;
pm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
aa.Close();
}
}
else
{
MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void CRReloader()
{
calendar1.Visible = true;
try
{
if (comboBox1.Text == "View all readings in a selected date" || comboBox1.Text == "Average Per Hour")
{
calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vmYear);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vm12Years);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmMonth, MonthCalendar.ViewMode.vm120Years);
calendar1.OnlyMonthMode = true;
if (comboBox1.Text == "View all readings in a selected date")
{
PictureLoad();
string source = "SELECT [Systolic],[Diastolic],[CDate],[CTime],[Status] from Record WHERE [PatientID] = '" + MainForm.patientID + "' and [CDate] = #" + calendar1.SelectedDate + "#";
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport1 rep = new CrystalReport1();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
else if (comboBox1.Text == "Average Per Hour")
{
PictureLoad();
string source = "SELECT Sys, Dias, Hour, CDate, Stat From HourTable Where PatientID ='" + MainForm.patientID + "' and CDate = #" + calendar1.SelectedDate + "#";
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport2 rep = new CrystalReport2();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
}
else if (comboBox1.Text == "Average Per Month")
{
PictureLoad();
calendar1.OnlyMonthMode = false;
calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vmYear);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vm12Years);
calendar1.SetViewMode(MonthCalendar.ViewMode.vmYear, MonthCalendar.ViewMode.vm120Years);
string source = "SELECT Sys, Dias, Month, Year, Stat From MonthTable Where PatientID ='" + MainForm.patientID + "' and Year = " + calendar1.SelectedDate.Year;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport3 rep = new CrystalReport3();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
else if (comboBox1.Text == "Average Per Year")
{
PictureLoad();
calendar1.OnlyMonthMode = false;
calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vmYear);
calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vm12Years);
calendar1.SetViewMode(MonthCalendar.ViewMode.vm12Years, MonthCalendar.ViewMode.vm120Years);
string source = "SELECT Sys, Dias, Year, Stat From YearTable Where PatientID ='" + MainForm.patientID + "' and Year BETWEEN " + calendar1.year1 + " and " + calendar1.year12;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
OleDbDataAdapter adapt = new OleDbDataAdapter(source, con);
DataSet ds = new DataSet();
ds.Tables.Add();
adapt.Fill(ds.Tables[0]);
con.Close();
source = "SELECT * from Profile WHERE PatientID ='" + MainForm.patientID + "'";
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Patient\'s Record.accdb");
con.Open();
adapt = new OleDbDataAdapter(source, con);
ds.Tables.Add();
adapt.Fill(ds.Tables[1]);
con.Close();
CrystalReport4 rep = new CrystalReport4();
rep.Database.Tables[0].SetDataSource(ds.Tables[0]);
rep.Database.Tables[1].SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
}
}
catch (Exception)
{
MessageBox.Show("Invalid operation has been detected!");
Application.Exit();
}
}
private void button9_Click(object sender, EventArgs e)
{
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=Kyrsovaya.mdb";
OleDbConnection connection = new OleDbConnection();
connection.ConnectionString = ConnectionString;
OleDbCommand myCommand;
string sq1;
sq1 = "SELECT * FROM [Вид техники]";
myCommand = new OleDbCommand(sq1, connection);
connection.Open();
OleDbDataAdapter da = new OleDbDataAdapter(myCommand);
DataSet ds = new DataSet();
da.Fill(ds, "Результат");
ds.WriteXmlSchema("schema.xml");
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rpt;
connection.Close();
}
private void loadPrint()
{
if(commit == "1")
{
string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'";
string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'";
try
{
aa.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(q1, aa);
DataSet1 mydataset = new DataSet1();
da.Fill(mydataset, "Sales");
da.Dispose();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = new SqlCommand(q2, aa);
da2.Fill(mydataset, "SalesSummary");
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(mydataset);
PrintMemo pm = new PrintMemo();
pm.crystalReportViewer1.ReportSource = myreport;
pm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
aa.Close();
}
}
else
{
MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return rpt;
}
