private void glassButton3_Click(object sender, EventArgs e) { _cmd = new SqlCommand("select PHOTO from T_IMAGE", frmMainForm._MasterCon); _da = new SqlDataAdapter(_cmd); DataTable dt2 = new DataTable(); _da.Fill(dt2); frmEmpMange r = new frmEmpMange(); byte[] imageData; imageData = r.ReadFile(Application.StartupPath + @"\back.BMP"); dt2.Rows[0]["PHOTO"] = imageData; if (!checkBox2.Checked) { rptCardBack card = new rptCardBack(); frmReportViewer2 viewreport = new frmReportViewer2(); card.Database.Tables["T_IMAGE"].SetDataSource(dt2); viewreport.crystalReportViewer1.ReportSource = card; viewreport.ShowDialog(); } else { rptCardBack_PS card = new rptCardBack_PS(); frmReportViewer2 viewreport = new frmReportViewer2(); card.Database.Tables["T_IMAGE"].SetDataSource(dt2); viewreport.crystalReportViewer1.ReportSource = card; viewreport.ShowDialog(); } }
private void glassButton1_Click(object sender, EventArgs e) { string sort = ""; if (radioButton1.Checked) { sort = "Order by [Employee Name],[Transaction Date]"; } if (radioButton2.Checked) { sort = "Order by [Card Number],[Transaction Date]"; } if (radioButton3.Checked) { sort = "Order by [Transaction Date]"; } if (radioButton4.Checked) { sort = "Order by Department,[Card Number],[Transaction Date]"; } _cmd = new SqlCommand(Str2 + sort, frmMainForm._MasterCon); //Str = "select [Employee Name] ,[Card Number],[Transaction Date],Time,Place,Job,Department from VTransactions " + FilterString; _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); ////////////////////////////////////////////////////// AllTransRpt EmpTransRpt = new AllTransRpt(); //EmpTransRptAr EmpTransRptAr = new EmpTransRptAr(); ///////////////////////////////////////////////////////////////////// frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ////////////////////////////////////////////////////// EmpTransRpt.Database.Tables["VAllTrans"].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); ////////////////////////////////////////////////////// ////////////////////////////////////////////////////// }
private void Btncancel_Click(object sender, EventArgs e) { _cmd = new SqlCommand(); _cmd.Connection = _MasterCon; if (comboBox1.SelectedIndex == 0) { _cmd.CommandText = "SELECT EMPLOYEE_CARDS.PhotoBytes , EMPLOYEE_CARDS.CRD_NO, EMPLOYEE_CARDS.CRD_NAME, rtrim(convert(char(20),AA.TRN_TIME,103))+' '+rtrim(convert(char(20),AA.TRN_TIME,24))as TRN_TIME, EMPLOYEE_CARDS.CRD_JOB, EMPLOYEE_CARDS.CRD_DEPARTMENT, AA.TRN_PLACE FROM (SELECT MAX(TRN_TIME) AS TRN_TIME, TRN_CARD_NO, TRN_PLACE FROM EMPLOYEE_TRANSACTIONS_MONITOR WHERE (TRN_PLACE = 'In') AND TRN_TIME>(dbo.GET_MAX_OUT(TRN_CARD_NO)) AND (TRN_TIME BETWEEN DATEADD(dd,-1,GETDATE()) AND GETDATE()) GROUP BY TRN_CARD_NO, TRN_PLACE) AS AA INNER JOIN EMPLOYEE_CARDS ON EMPLOYEE_CARDS.CRD_NO = AA.TRN_CARD_NO ORDER BY TRN_TIME"; } else if (comboBox1.SelectedIndex == 1) { _cmd.CommandText = "SELECT EMPLOYEE_CARDS.PhotoBytes , EMPLOYEE_CARDS.CRD_NO, EMPLOYEE_CARDS.CRD_NAME, rtrim(convert(char(20),AA.TRN_TIME,103))+' '+rtrim(convert(char(20),AA.TRN_TIME,24))as TRN_TIME, EMPLOYEE_CARDS.CRD_JOB, EMPLOYEE_CARDS.CRD_DEPARTMENT, AA.TRN_PLACE FROM (SELECT MAX(TRN_TIME) AS TRN_TIME, TRN_CARD_NO, TRN_PLACE ,TRN_MACHINE FROM EMPLOYEE_TRANSACTIONS_MONITOR WHERE (TRN_PLACE = 'In')AND TRN_MACHINE IN ('in','out') AND TRN_TIME>(dbo.GET_MAX_OUT(TRN_CARD_NO)) AND (TRN_TIME BETWEEN DATEADD(dd,-1,GETDATE()) AND GETDATE()) GROUP BY TRN_CARD_NO, TRN_PLACE,TRN_MACHINE) AS AA INNER JOIN EMPLOYEE_CARDS ON EMPLOYEE_CARDS.CRD_NO = AA.TRN_CARD_NO ORDER BY TRN_TIME"; } else if (comboBox1.SelectedIndex == 2) { _cmd.CommandText = "SELECT EMPLOYEE_CARDS.PhotoBytes , EMPLOYEE_CARDS.CRD_NO, EMPLOYEE_CARDS.CRD_NAME, rtrim(convert(char(20),AA.TRN_TIME,103))+' '+rtrim(convert(char(20),AA.TRN_TIME,24))as TRN_TIME, EMPLOYEE_CARDS.CRD_JOB, EMPLOYEE_CARDS.CRD_DEPARTMENT, AA.TRN_PLACE FROM (SELECT MAX(TRN_TIME) AS TRN_TIME, TRN_CARD_NO, TRN_PLACE ,TRN_MACHINE FROM EMPLOYEE_TRANSACTIONS_MONITOR WHERE (TRN_PLACE = 'In')AND TRN_MACHINE IN ('new in','new out') AND TRN_TIME>(dbo.GET_MAX_OUT(TRN_CARD_NO)) AND (TRN_TIME BETWEEN DATEADD(dd,-1,GETDATE()) AND GETDATE()) GROUP BY TRN_CARD_NO, TRN_PLACE,TRN_MACHINE) AS AA INNER JOIN EMPLOYEE_CARDS ON EMPLOYEE_CARDS.CRD_NO = AA.TRN_CARD_NO ORDER BY TRN_TIME"; } _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); DataTable _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } In_COM_Rpt EmpTransRpt = new In_COM_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_IN_OUT.ParameterFieldName, "IN"); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); }
private void glassButton1_Click(object sender, EventArgs e) { _cmd = new SqlCommand(); _cmd.Connection = frmMainForm._MasterCon; _cmd.CommandType = CommandType.StoredProcedure; _cmd.CommandText = "GET_NUM_HOURS"; _cmd.CommandTimeout = 2000; _cmd.Parameters.Add("@FROMDATE", SqlDbType.VarChar).Value = dtpDateFrom.Value.ToString("yyyy/MM/dd"); _cmd.Parameters.Add("@TODATE", SqlDbType.VarChar).Value = dtpDateTo.Value.ToString("yyyy/MM/dd"); //Str = "select CARD,NAME,JOB,Department,DATE,[Enter Time],[Exit Time],[WORK HOURS] from VTransaction_IN_OUT_FINAL " + FilterString; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); ////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////// frmReportViewer2 Viewer = new frmReportViewer2(); //if (_Dt.Rows.Count == 0) //{ // MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} SummaryRpt Rpt = new SummaryRpt(); Rpt.Database.Tables["GET_NUM_HOURS;1"].SetDataSource(_Dt); Rpt.SetParameterValue(Rpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text); Rpt.SetParameterValue(Rpt.Parameter_To.ParameterFieldName, dtpDateTo.Text); Rpt.SetParameterValue(Rpt.Parameter_FROMDATE.ParameterFieldName, dtpDateFrom.Value.ToString("yyyy/MM/dd")); Rpt.SetParameterValue(Rpt.Parameter_TODATE.ParameterFieldName, dtpDateFrom.Value.ToString("yyyy/MM/dd")); Viewer.crystalReportViewer1.ReportSource = Rpt; Viewer.ShowDialog(); }
private void BtnPrintPreview_Click(object sender, EventArgs e) { string sort = ""; /*if (radioButton1.Checked) * { * if (rbut_find_in.Checked || rbut_find_out.Checked) * { * sort = " ) Order by [CRD_NAME],[ENT_TIME]"; * } * else * { * sort = " ) Order by [CRD_NAME],[TRN_TIME]"; * } * } * if (radioButton2.Checked) * { * if (rbut_find_in.Checked || rbut_find_out.Checked||rbut_find_att.Checked||rbut_find_abs.Checked) * { * sort = " ) Order by [CRD_NO]"; * } * else * { * sort = " ) Order by [TRN_CARD_NO]"; * } * } * if (radioButton3.Checked) * { * if (rbut_find_in.Checked || rbut_find_out.Checked) * { * sort = " ) Order by [ENT_TIME]"; * } * else * { * sort = " ) Order by [TRN_TIME]"; * } * } * if (radioButton4.Checked) * { * if (rbut_find_in.Checked || rbut_find_out.Checked || rbut_find_att.Checked || rbut_find_abs.Checked) * { * sort = " ) Order by [CRD_DEPARTMENT], [CRD_NO]"; * } * else * { * sort = " ) Order by [CRD_DEPARTMENT],[TRN_CARD_NO]"; * } * }*/ if (rbut_find_in.Checked || rbut_find_out.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } In_COM_Rpt EmpTransRpt = new In_COM_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_IN_OUT.ParameterFieldName, IN_OUT); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } else if (rbut_find_abs.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Absence_Rpt EmpTransRpt = new Absence_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } else if (rbut_find_att.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Attendance_Rpt EmpTransRpt = new Attendance_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } else if (rbut_OUT.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } EmpOutRpt EmpTransRpt = new EmpOutRpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_DATE1.ParameterFieldName, dtpDateFrom.Value.ToString("dd/MM/yyyy")); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_DATE2.ParameterFieldName, dtpDateTo.Value.ToString("dd/MM/yyyy")); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } }
private void BtnPrintPreview_Click(object sender, EventArgs e) { if (rbut_find_in.Checked || rbut_find_out.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } In_COM_Rpt EmpTransRpt = new In_COM_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_IN_OUT.ParameterFieldName, IN_OUT); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } else if (rbut_find_abs.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Absence_Rpt EmpTransRpt = new Absence_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } else if (rbut_find_att.Checked) { _cmd = new SqlCommand(Str, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Attendance_Rpt EmpTransRpt = new Attendance_Rpt(); EmpTransRpt.Database.Tables[0].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, DateTime.Now.ToString("dd/MM/yyyy")); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); } }
private void button1_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 2000; cmd.Connection = frmMainForm._MasterCon; string FilterString = ""; bool FilterFlag = false; string inFilter = ""; if (cmbLocation.SelectedItem != null) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " LOCATION ='" + cmbLocation.SelectedItem.ToString() + "' "; } if (cmbCompany.SelectedItem != null) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " COMPANY = '" + cmbCompany.SelectedItem.ToString() + "' "; } if (cmbDep.SelectedValue.ToString() != "") { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + "CRD_DEPARTMENT = '" + cmbDep.SelectedValue.ToString() + "'"; } if (cmb_permit.SelectedValue.ToString() != "") { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " PERMITION = '" + cmb_permit.SelectedValue.ToString() + "' and (VALID_TO between '" + dateTimePickerValid.Text + "' and '" + dateTimePickervalidTo.Text + "') "; } if (cmb_status.SelectedValue.ToString() != "") { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " STATUS = '" + cmb_permit.SelectedValue.ToString() + "'"; } if (checkBox1.Checked) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " IN_JOB = 1"; } if (!checkBox1.Checked) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " IN_JOB = 0"; } inFilter = ""; if (!FilterFlag) { inFilter = " where "; FilterFlag = true; } else { inFilter = " and "; } FilterString += inFilter + " CRD_NAME NOT LIKE '%V' "; cmd.CommandText = "SELECT EMPLOYEE_CARDS.CRD_NO, EMPLOYEE_CARDS.CRD_NAME, EMPLOYEE_CARDS.CRD_STARTING_DATE, EMPLOYEE_CARDS.CRD_EXPIRY_DATE, EMPLOYEE_CARDS.CRD_JOB, EMPLOYEE_CARDS.CRD_LAST_TRANSACTION_TYPE, EMPLOYEE_CARDS.CRD_DEPARTMENT,EMPLOYEE_CARDS.LOCATION,EMPLOYEE_CARDS.COMPANY FROM EMPLOYEE_CARDS " + FilterString + " order by CRD_NAME"; DataTable dt = new DataTable(); SqlDataAdapter _da = new SqlDataAdapter(cmd); _da.Fill(dt); frmReportViewer2 Viewer = new frmReportViewer2(); EmployeeRpt2 rpt = new EmployeeRpt2(); rpt.Database.Tables[0].SetDataSource(dt); Viewer.crystalReportViewer1.ReportSource = rpt; Viewer.ShowDialog(); this.Close(); }
private void glassButton2_Click(object sender, EventArgs e) { //string sort = ""; //if (radioButton1.Checked) //{ // sort = "Order by [NAME],[Date]"; //} //if (radioButton2.Checked) //{ // sort = "Order by [Card Number],[Transaction Date]"; //} //if (radioButton3.Checked) //{ // sort = "Order by [Transaction Date]"; //} //if (radioButton4.Checked) //{ // sort = "Order by Department,[Card Number],[Transaction Date]"; //} _cmd = new SqlCommand(); _cmd.Connection = frmMainForm._MasterCon; _cmd.CommandType = CommandType.StoredProcedure; _cmd.CommandText = "GET_REAL_TIME"; _cmd.CommandTimeout = 2000; //_cmd.Parameters.Add("@FROMDATE", SqlDbType.VarChar).Value = "'"+dtpDateFrom.Value.ToString("yyyy/MM/dd")+"'"; //_cmd.Parameters.Add("@TODATE", SqlDbType.VarChar).Value = "'" + dtpDateTo.Value.ToString("yyyy/MM/dd")+"'"; //_cmd.Parameters.Add("@DEP", SqlDbType.VarChar).Value = "'" + cmbDep.SelectedValue.ToString()+"'"; //_cmd.Parameters.Add("@CARD", SqlDbType.VarChar).Value = "'" + cmbEmployee.SelectedValue.ToString()+"'"; //_cmd.Parameters.Add("@LOC", SqlDbType.VarChar).Value = "'Cairo'"; //_cmd.Parameters.Add("@COM", SqlDbType.VarChar).Value = "'PhPC'"; _cmd.Parameters.Add("@FROMDATE", SqlDbType.VarChar).Value = dtpDateFrom.Value.ToString("yyyy/MM/dd"); _cmd.Parameters.Add("@TODATE", SqlDbType.VarChar).Value = dtpDateTo.Value.ToString("yyyy/MM/dd"); _cmd.Parameters.Add("@DEP", SqlDbType.VarChar).Value = cmbDep.SelectedValue.ToString(); _cmd.Parameters.Add("@CARD", SqlDbType.VarChar).Value = cmbEmployee.SelectedValue.ToString(); _cmd.Parameters.Add("@LOC", SqlDbType.VarChar).Value = "Cairo"; _cmd.Parameters.Add("@COM", SqlDbType.VarChar).Value = "PhPC"; //Str = "select CARD,NAME,JOB,Department,DATE,[Enter Time],[Exit Time],[WORK HOURS] from VTransaction_IN_OUT_FINAL " + FilterString; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); /*_cmd = new SqlCommand(Str3 + sort, frmMainForm._MasterCon); * //Str = "select [Employee Name] ,[Card Number],[Transaction Date],Time,Place,Job,Department from VTransactions " + FilterString; * _cmd.CommandTimeout = 2000; * _da = new SqlDataAdapter(_cmd); * _Dt = new DataTable(); * _Dt.Reset(); * * _da.Fill(_Dt); */ ////////////////////////////////////////////////////// EmpTrans_REAL_Rpt EmpTransRpt = new EmpTrans_REAL_Rpt(); //EmpTransRptAr EmpTransRptAr = new EmpTransRptAr(); ///////////////////////////////////////////////////////////////////// frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ////////////////////////////////////////////////////// EmpTransRpt.Database.Tables["GET_REAL_TIME"].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); ////////////////////////////////////////////////////// ////////////////////////////////////////////////////// }
private void glassButton2_Click(object sender, EventArgs e) { rptVisitorCard card = new rptVisitorCard(); frmReportViewer2 viewreport = new frmReportViewer2(); DataTable dt = new DataTable(); string floor; try { _cmd = new SqlCommand("select * from EMPLOYEE_CARDS where CRD_NO='" + txtCardNo.Text + "'", frmMainForm._MasterCon); _da = new SqlDataAdapter(_cmd); _da.Fill(dt); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } frmEmpMange r = new frmEmpMange(); byte[] imageData; if (radioButton1.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor1.jpg"); floor = radioButton1.Text; } else if (radioButton2.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor2.jpg"); floor = radioButton2.Text; } else if (radioButton3.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor3.jpg"); floor = radioButton3.Text; } else if (radioButton4.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor4.jpg"); floor = radioButton4.Text; } else if (radioButton5.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor5.jpg"); floor = radioButton5.Text; } else if (radioButton6.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor6.jpg"); floor = radioButton6.Text; } else if (radioButton7.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor7.jpg"); floor = radioButton7.Text; } else if (radioButton8.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor8.jpg"); floor = radioButton8.Text; } else if (radioButton9.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Visitor9.jpg"); floor = radioButton9.Text; } else //if (radioButton10.Checked) { imageData = r.ReadFile(Application.StartupPath + @"\Blank_Visitor.jpg"); floor = ""; } if (dt.Rows.Count == 0) { MessageBox.Show("There is no member"); return; } dt.Rows[0]["PhotoBytes"] = imageData; card.Database.Tables["EMPLOYEE_CARDS"].SetDataSource(dt); card.SetParameterValue(card.Parameter_Num.ParameterFieldName, txtCardNo.Text); card.SetParameterValue(card.Parameter_Floor.ParameterFieldName, floor); if (checkBox1.Checked) { card.SetParameterValue(card.Parameter_Visitor.ParameterFieldName, txtCompanyName.Text); } else { card.SetParameterValue(card.Parameter_Visitor.ParameterFieldName, "Visitor"); } viewreport.crystalReportViewer1.ReportSource = card; viewreport.ShowDialog(); }
private void glassButton3_Click(object sender, EventArgs e) { //DataTable dt = new DataTable(); string sort = ""; if (radioButton1.Checked) { sort = "Order by [NAME],DATE,[Enter Time]"; } if (radioButton2.Checked) { sort = "Order by [CARD],DATE,[Enter Time]"; } if (radioButton3.Checked) { sort = "Order by DATE,[Enter Time]"; } if (radioButton4.Checked) { sort = "Order by Department,[CARD],DATE,[Enter Time]"; } _cmd = new SqlCommand(Str + sort, frmMainForm._MasterCon); _cmd.CommandTimeout = 2000; //Str = "select CARD,NAME,JOB,Department,DATE,[Enter Time],[Exit Time],[WORK HOURS] from VTransaction_IN_OUT_FINAL " + FilterString; _da = new SqlDataAdapter(_cmd); _Dt = new DataTable(); _Dt.Reset(); _da.Fill(_Dt); ////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////// frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } /*if (checkBoxSHIFT.Checked) * { * EmpShiftTransRpt EmpSHIFTTransRpt = new EmpShiftTransRpt(); * EmpSHIFTTransRpt.Database.Tables["VSHIFT_FINAL"].SetDataSource(_Dt); * EmpSHIFTTransRpt.SetParameterValue(EmpSHIFTTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text); * EmpSHIFTTransRpt.SetParameterValue(EmpSHIFTTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text); * Viewer.crystalReportViewer1.ReportSource = EmpSHIFTTransRpt; * } * else * {*/ EmpTransRptWithG EmpTransRpt = new EmpTransRptWithG(); EmpTransRpt.Database.Tables["VTransaction_IN_OUT_FINAL"].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_ca_start.ParameterFieldName, maskedTextBox1.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_ca_end.ParameterFieldName, maskedTextBox2.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_ps_start.ParameterFieldName, maskedTextBox3.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_ps_end.ParameterFieldName, maskedTextBox4.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_service_start.ParameterFieldName, maskedTextBox5.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_service_end.ParameterFieldName, maskedTextBox6.Text); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; //} Viewer.ShowDialog(); }