public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rp_HoatDongNhanVien rpt = new rp_HoatDongNhanVien(); rpt.Site = this.Site; return(rpt); }
private void btnBaoCao_Click(object sender, EventArgs e) { if (Program.conn.State == ConnectionState.Closed) { Program.conn.Open(); } String strLenh = "dbo.[SP_RP_KiemTraHoatDongNV]"; Program.sqlcmd = Program.conn.CreateCommand(); Program.sqlcmd.CommandType = CommandType.StoredProcedure; Program.sqlcmd.CommandText = strLenh; Program.sqlcmd.Parameters.Add("@MANV", SqlDbType.Int).Value = cmbMANV.Text; Program.sqlcmd.Parameters.Add("@STARTTIME", SqlDbType.Date).Value = convertStringToDateTime(dateNgayBatDau.Text.Trim()); Program.sqlcmd.Parameters.Add("@LASTTIME", SqlDbType.Date).Value = convertStringToDateTime(dateNgayKetThuc.Text.Trim()); Program.sqlcmd.Parameters.Add("@Ret", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; Program.sqlcmd.ExecuteNonQuery(); Program.conn.Close(); String Ret = Program.sqlcmd.Parameters["@Ret"].Value.ToString(); if (Ret.Equals("0")) { MessageBox.Show("Nhân viên chưa lập phiếu trong khoảng thời gian này!", "", MessageBoxButtons.OK); return; } else { DataTable dt = new DataTable(); String strLenh1 = "EXEC [SP_RP_InHoatDongNV] '" + cmbMANV.Text + "','" + convertStringToDateTime(dateNgayBatDau.Text.Trim()).ToString("yyyy-MM-dd") + "','" + convertStringToDateTime(dateNgayKetThuc.Text.Trim()).ToString("yyyy-MM-dd") + "'"; MessageBox.Show(strLenh1); dt = Program.ExecSqlQuery(strLenh1); rp_HoatDongNhanVien rp = new rp_HoatDongNhanVien(); rp.SetDataSource(dt); crystalReportViewer1.ReportSource = rp; } }