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;
}
}
