private void frmRptSachTre_Load(object sender, System.EventArgs e)
{
dtMuonSach myDataSet = new dtMuonSach();
string sql = "select * from docgia";
SqlConnection con = new SqlConnection(SqlHelper.ConnectString);
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "docgia");
sql = "select * from quyensach";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "quyensach");
sql = "select * from muonsach";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "muonsach");
sql = "select * from chitietphieumuon where hantra<'" + DateTime.Now + "'";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "chitietphieumuon");
rptSachTre1 = new rptSachTre();
rptSachTre1.SetDataSource(myDataSet);
ReportViewer.ReportSource = rptSachTre1;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.ReportViewer = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
this.rptSachTre1 = new Quanlythuvien.rptSachTre();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.SuspendLayout();
//
// ReportViewer
//
this.ReportViewer.ActiveViewIndex = -1;
this.ReportViewer.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.ReportViewer.DisplayGroupTree = false;
this.ReportViewer.Location = new System.Drawing.Point(0, 0);
this.ReportViewer.Name = "ReportViewer";
this.ReportViewer.ReportSource = null;
this.ReportViewer.Size = new System.Drawing.Size(784, 560);
this.ReportViewer.TabIndex = 0;
this.ReportViewer.Load += new System.EventHandler(this.ReportViewer_Load);
//
// rptSachTre1
//
this.rptSachTre1.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation;
this.rptSachTre1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
this.rptSachTre1.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Upper;
this.rptSachTre1.PrintOptions.PrinterDuplex = CrystalDecisions.Shared.PrinterDuplex.Default;
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "MUONSACH", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("SOPHIEUMUON", "SOPHIEUMUON"),
new System.Data.Common.DataColumnMapping("MSDG", "MSDG"),
new System.Data.Common.DataColumnMapping("MSNV", "MSNV"),
new System.Data.Common.DataColumnMapping("NGAYMUON", "NGAYMUON"),
new System.Data.Common.DataColumnMapping("Expr1", "Expr1"),
new System.Data.Common.DataColumnMapping("MSSACH", "MSSACH"),
new System.Data.Common.DataColumnMapping("HANTRA", "HANTRA")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT MUONSACH.SOPHIEUMUON, MUONSACH.MSDG, MUONSACH.MSNV, MUONSACH.NGAYMUON, CHITIETPHIEUMUON.SOPHIEUMUON AS Expr1, CHITIETPHIEUMUON.MSSACH, CHITIETPHIEUMUON.HANTRA FROM MUONSACH INNER JOIN CHITIETPHIEUMUON ON MUONSACH.SOPHIEUMUON = CHITIETPHIEUMUON.SOPHIEUMUON";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Integrated Security=SSPI;Packet Size=4096;Data Source=THANH;Tag with column collation when possible=False;Initial Catalog=Thuvien;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOLEDB.1"";Workstation ID=THANH;Use Encryption for Data=False";
//
// frmRptSachTre
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(792, 566);
this.Controls.Add(this.ReportViewer);
this.Name = "frmRptSachTre";
this.Text = "frmRptSachTre";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.frmRptSachTre_Load);
this.ResumeLayout(false);
}
