/// <summary>
/// Grid数据导出全部
/// <para>此方法需要被重写后调用</para>
/// <para>一行代码调用即可：base.ExportAllAction(gdGrid);</para>
/// </summary>
/// <param name="paramGrid">需要导出的UltraGrid对象</param>
/// <param name="paramGridName">需要导出的Grid的名称</param>
public virtual void ExportAllAction(UltraGrid paramGrid, string paramGridName = "")
{
if (paramGrid == null)
{
return;
}
if (paramGridName == null)
{
return;
}
try
{
var saveFileDialog = new SaveFileDialog
{
InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop),
FileName = $"Export{paramGridName + DateTime.Now.ToString(FormatConst.DATE_TIME_FORMAT_03)}_All",
Filter = FormatConst.FILE_TYPE_FILTER_EXCEL_03,
};
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
var gdGridExcelExporter = new UltraGridExcelExporter();
gdGridExcelExporter.Export(paramGrid).Save(saveFileDialog.FileName);
MessageBox.Show("导出成功！", SysConst.CHS_MSG_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("导出失败！", SysConst.CHS_MSG_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Fix Attendance List.xls" + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridList, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
/// <summary>
/// Exports contents of <see cref="Infragistics.Win.UltraWinGrid"/> to Excel file.
/// </summary>
/// <param name="grid"><see cref="Infragistics.Win.UltraWinGrid"/> whose contents are to be exported.</param>
/// <param name="fileName">File name to write the data.</param>
/// <param name="worksheetName">Name of the worksheet.</param>
/// <exception cref="ArgumentNullException">When <see cref="Infragistics.Win.UltraWinGrid"/> is null.</exception>
public static void ExportToExcel(this UltraGrid grid, string fileName, string worksheetName = "Results")
{
if (grid == null)
{
throw new ArgumentNullException("grid");
}
if (fileName == null)
{
throw new ArgumentNullException("fileName");
}
if (worksheetName == null)
{
throw new ArgumentNullException("worksheetName");
}
_log.Info("Exporting to Excel ...");
// Validate file name
try
{
_log.DebugFormat("Validating path for file {0} ...", fileName);
Path.GetFullPath(fileName);
}
catch (Exception ex)
{
var message = string.Format("Error saving grid contents to Excel. File {0} is not valid.", fileName);
_log.Error(message);
_log.Error(ex.Message, ex);
throw new Exception(message, ex);
}
// Export data
try
{
var workbookFormat = WorkbookFormat.Excel2007;
var extension = Path.GetExtension(fileName);
if (extension.Trim().ToLower() == ".xls")
{
workbookFormat = WorkbookFormat.Excel97To2003;
}
var wkbk = new Workbook(workbookFormat);
var resultsSheet = wkbk.Worksheets.Add(worksheetName);
var excelExporrter = new UltraGridExcelExporter();
excelExporrter.Export(grid, resultsSheet, 0, 0);
_log.DebugFormat("Saving Excel worksheet to file {0} ...", fileName);
wkbk.Save(fileName);
_log.DebugFormat("Excel worksheet saved.");
_log.Info("Export complete.");
}
catch (Exception ex)
{
var message = string.Format("Error exporting grid to Excel file {0}.", fileName);
_log.Error(message);
_log.Error(ex.Message, ex);
throw new Exception(message, ex);
}
}
public static void ExportUltraGridToExcel(UltraGrid grid, string fileName)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.ValidateNames = true;
saveFileDialog.FileName = fileName + ".xls";
saveFileDialog.Filter = "Microsoft Excel Spreadsheet (*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
if (File.Exists(saveFileDialog.FileName))
{
if (MessageBox.Show(saveFileDialog.FileName + " already exists." + Environment.NewLine + Environment.NewLine +
"Do you want to replace it?",
"Save As", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.No)
{
return;
}
}
int columnsCount = grid.DisplayLayout.Bands[0].Columns.Count;
int rowsCount = grid.DisplayLayout.Rows.Count;
if (columnsCount <= 256 && rowsCount <= 65535)
{
UltraGridExcelExporter exporter = new UltraGridExcelExporter();
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add("Sheet1"); // 8.3.4 - CMD - Hardwire Excel sheet name
exporter.Export(grid, worksheet);
try
{
workbook.Save(saveFileDialog.FileName);
}
catch (IOException ex)
{
Utility.DisplayApplicationErrorMessage(ex.Message);
return;
}
DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'");
}
else
{
MessageBox.Show(
"The maximum amount of data that can be exported to Excel has been exceeded." +
Environment.NewLine + Environment.NewLine +
"Please reduce the number of rows and/or coulumns to be exported.",
"Export limit reached"
, MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string ProssType = "", SectId = "0", Band = "";
ProssType = gridProssType.ActiveRow.Cells["ProssType"].Value.ToString();
SectId = gridSec.ActiveRow.Cells["SectId"].Value.ToString();
Band = gridBand.ActiveRow.Cells["varName"].Value.ToString();
String sqlquary = "Exec rptNightAllowance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "'," + SectId + ",'" + Band + "','" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "',2";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Night";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Night"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Night Allowance Report" + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string SQLQuery = "";
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Salary Sheet"))
{
SQLQuery = "Exec [rptSalaryDriver] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridUnit.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "',1,'Salary Sheet'";
}
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "tblSal";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblSal"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnImprimir_Click(object sender, EventArgs e)
{
//FrmReporteArticulos frm = new FrmReporteArticulos();
//frm.Texto = txtBuscar.Text;
//frm.ShowDialog();
UltraGridExcelExporter ultraGridExcelExporter1 = new UltraGridExcelExporter();
string Archivo = "Lotes.xls";
ultraGridExcelExporter1.Export(ultraGrid1, Archivo);
System.Diagnostics.Process.Start(Archivo);
}
private void btnExcelType_Click(object sender, EventArgs e)
{
dsDetails = new DataSet();
ArrayList arQuery = new ArrayList();
GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
string SQLQuery = "", MenuId = "0";
MenuId = gridMenu.ActiveRow.Cells["MenuId"].Value.ToString();
SQLQuery = "Exec rptMenuList 1, '" + MenuId + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Menu Permission List_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
UltraGridExcelExporter ultraGridExcelExporter1 = new UltraGridExcelExporter();
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.FileName = string.Format("{0} Pre-Liquidación de Atención", _service.v_Pacient);
saveFileDialog1.Filter = "Files (*.xls;*.xlsx;*)|*.xls;*.xlsx;*";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
ultraGridExcelExporter1.Export(this.grdLiquidacion, saveFileDialog1.FileName);
MessageBox.Show("Se exportaron correctamente los datos.", " ¡ INFORMACIÓN !", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string SQLQuery = "";
SQLQuery = "Exec rptIncrementYearly " + Common.Classes.clsMain.intComId + " ,'" + this.clsProc.GTRDate(this.dtInc.Value.ToString()) + "',0";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "YearlyInc";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["YearlyInc"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Yearly Increment" + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
public static void ExportToExcel(UltraGrid grid)
{
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.OK)
{
UltraGridExcelExporter ultraGridExcelExporter = new UltraGridExcelExporter();
ultraGridExcelExporter.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
ultraGridExcelExporter.Export(grid, dlgSurveyExcel.FileName);
}
}
/// <summary>
/// 导出当前页
/// </summary>
/// <param name="paramGrid"></param>
/// <param name="paramDefaultFilePath"></param>
/// <param name="paramGridName"></param>
private void ExportCurPage(UltraGrid paramGrid, ref string paramDefaultFilePath, string paramGridName = "")
{
if (paramGrid == null)
{
return;
}
if (paramGridName == null)
{
return;
}
try
{
var saveFileDialog = new SaveFileDialog
{
FileName = $"Export{paramGridName + DateTime.Now.ToString(FormatConst.DATE_TIME_FORMAT_03)}",
Filter = FormatConst.FILE_TYPE_FILTER_EXCEL_03,
};
if (!string.IsNullOrEmpty(paramDefaultFilePath))
{
saveFileDialog.InitialDirectory = paramDefaultFilePath;
saveFileDialog.FileName = saveFileDialog.FileName + ".xls";
}
else
{
saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
}
//获取保存文件的上一级目录
Directory.SetCurrentDirectory(Directory.GetParent(saveFileDialog.FileName).FullName);
paramDefaultFilePath = Directory.GetCurrentDirectory();
var gdGridExcelExporter = new UltraGridExcelExporter();
gdGridExcelExporter.Export(paramGrid).Save(saveFileDialog.FileName);
MessageBox.Show("导出" + paramGridName + "成功！", SysConst.CHS_MSG_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("导出" + paramGridName + "失败！", SysConst.CHS_MSG_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void ExportExcel(SaveFileDialog sfd, UltraGridExcelExporter exporter, UltraGrid grid, string strTitle, string strOperName)
{
//Helper.ExportExcel(saveFileDialog1,ultraGridExcelExporter1,ultraGrid1);
try
{
if (grid.Rows.Count == 0)
{
throw new BusinessException("导出", "请先查询出结果再导出");
}
grid.BeginUpdate();
//grid.DisplayLayout.BorderStyle = UIElementBorderStyle.None;
//grid.UseAppStyling = false;
//grid.DisplayLayout.Override.RowSelectors = DefaultableBoolean.False;;
AddGridTitle(grid, strTitle, strOperName);
grid.EndUpdate();
sfd.Filter = "Excel文件 (*.xls)|*.xls|All files (*.*)|*.*";
sfd.FilterIndex = 1;
sfd.RestoreDirectory = true;
if (sfd.ShowDialog() == DialogResult.OK)
{
string strFileName = sfd.FileName;
exporter.Export(grid, strFileName);
}
grid.BeginUpdate();
//this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].Hidden = false;
//grid.DisplayLayout.BorderStyle = UIElementBorderStyle.Solid;
//grid.UseAppStyling = true;
//grid.DisplayLayout.Override.RowSelectors = DefaultableBoolean.True;
RemoveGridTitle(grid, strOperName);
grid.EndUpdate();
}
catch (BusinessException bex)
{
MessageBox.Show(bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 导出零库存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
//导出零库存盘库明细表
if (gdGrid == null)
{
return;
}
var saveFileDialog = new SaveFileDialog
{
InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop),
FileName = $"Export{SysConst.ZeroInventoryStockDetail + DateTime.Now.ToString(FormatConst.DATE_TIME_FORMAT_03)}",
Filter = FormatConst.FILE_TYPE_FILTER_EXCEL_03,
};
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
var gdGridExcelExporter = new UltraGridExcelExporter();
gdGridExcelExporter.Export(gdGrid).Save(saveFileDialog.FileName);
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string sqlquary = "", EmpId = "0", TrainingName = "0", RptType = "";
EmpId = gridEmployeeID.ActiveRow.Cells["EmpId"].Value.ToString();
TrainingName = gridName.ActiveRow.Cells["TName"].Value.ToString();
if (optCriteria.Value.ToString().ToUpper() == "Employee".ToUpper())
{
sqlquary = "Exec rptTraining " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', " + EmpId + ",'0','0','1'";
}
else if (optCriteria.Value.ToString().ToUpper() == "Training".ToUpper())
{
sqlquary = "Exec rptTraining " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', 0,'" + TrainingName + "','0','2'";
}
else if (optCriteria.Value.ToString().ToUpper() == "dtDate".ToUpper())
{
sqlquary = "Exec rptTraining " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', 0,'0','0','3'";
}
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Training";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Training"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Training Report" + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string SectId = "0", EmpId = "0", Band = "=All=", EmpType = "", SubSectId = "0";
EmpType = gridEmpType.ActiveRow.Cells["varName"].Value.ToString();
if (optCriteria.Value.ToString().ToUpper() == "All".ToUpper())
{
}
else if (optCriteria.Value.ToString().ToUpper() == "Section".ToUpper())
{
SectId = gridSection.ActiveRow.Cells["SectId"].Value.ToString();
}
else if (optCriteria.Value.ToString().ToUpper() == "Employee".ToUpper())
{
EmpId = gridEmployeeID.ActiveRow.Cells["EmpId"].Value.ToString();
}
else if (optCriteria.Value.ToString().ToUpper() == "Band".ToUpper())
{
Band = gridBand.ActiveRow.Cells["varName"].Value.ToString();
}
if ((gridRpt.ActiveRow.Cells["rptname"].Text.ToString() == "Attendance Summary"))
{
SQLQuery = "Exec rptAttendMonthly " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', " + SectId + ", '', '', " + EmpId + ",'" + Band + "','" + EmpType + "',0";
}
else if ((gridRpt.ActiveRow.Cells["rptname"].Text.ToString() == "Monthly Absent"))
{
SQLQuery = "Exec rptAttendMonthlyAbsent " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', " + SectId + ", '', '', " + EmpId + ",'" + Band + "','" + EmpType + "',0";
}
else if ((gridRpt.ActiveRow.Cells["rptname"].Text.ToString() == "Monthly Late"))
{
SQLQuery = "Exec rptAttendMonthlyLate " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', " + SectId + ", '', '', " + EmpId + ",'" + Band + "','" + EmpType + "',0";
}
else if ((gridRpt.ActiveRow.Cells["rptname"].Text.ToString() == "Monthly OT"))
{
SQLQuery = "Exec rptMonthlyAttend " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', " + SectId + ", '', '', " + EmpId + ",'" + Band + "','" + EmpType + "',0";
}
else if ((gridRpt.ActiveRow.Cells["rptname"].Text.ToString() == "Monthly Job Card"))
{
SQLQuery = "Exec rptMonthlyAttend " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', " + SectId + ", '', '', " + EmpId + ",'" + Band + "','" + EmpType + "',1";
}
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "MonthlyAtten";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["MonthlyAtten"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = gridRpt.ActiveRow.Cells["rptname"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string Band = "";
Band = gridBand.ActiveRow.Cells["varName"].Value.ToString();
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Salary Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Salary Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Summary Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Summary Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Addition Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Arrear Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Advance Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Advance Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Deduction Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Deduction Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Loan Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Loan Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "PF Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','PF Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Denomination"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Denomination'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Bank Sheet"))
{
string sqlquary = "Exec [rptSalarySheetExcelB] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + cboPayMode.Value.ToString() + "', '" + cboEmpType.Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + Band + "','" + cboStatus.Value.ToString() + "','Bank Sheet'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Salary";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Salary"];
}
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string ReportPath = "", SQLQuery = "", DataSourceName = "DataSet1", FormCaption = "";
DataSourceName = "DataSet1";
FormCaption = "Report :: Increment Report ...";
string SectId = "0", EmpId = "0", Type = "", EmpType = "";
EmpId = gridEmp.ActiveRow.Cells["EmpId"].Value.ToString();
SectId = gridArea.ActiveRow.Cells["SectId"].Value.ToString();
Type = gridIncrType.ActiveRow.Cells["IncrType"].Value.ToString();
EmpType = gridEmpType.ActiveRow.Cells["EmpType"].Value.ToString();
if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Increment")
{
SQLQuery = "Exec rptIncrement " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Promotion")
{
SQLQuery = "Exec rptIncrement " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Increment with Promotion")
{
SQLQuery = "Exec rptIncrement " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Adjustment")
{
SQLQuery = "Exec rptIncrement " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Revised")
{
SQLQuery = "Exec rptIncrement " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Increment Entitle")
{
SQLQuery = "Exec rptIncrementEntitle " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "Confirmation Entitle")
{
SQLQuery = "Exec rptIncrementEntitle " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if (gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() == "New Confirmation Entitle")
{
SQLQuery = "Exec rptIncrementEntitle " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', '" + EmpType + "', '', " + SectId + ", 0, '" + Type + "'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = gridIncrType.ActiveRow.Cells["IncrType"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "General".ToUpper())
{
string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "','General'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "ML".ToUpper())
{
string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'ML'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "FirstML".ToUpper())
{
string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'FirstML'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "LastML".ToUpper())
{
string sqlquary = "Exec rptLeave " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'LastML'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "Details".ToUpper())
{
string sqlquary = "Exec rptLeaveBalance " + Common.Classes.clsMain.intComId + ", '" + cboFinyear.Value.ToString() + "', '" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'Details'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "Summary".ToUpper())
{
string sqlquary = "Exec rptLeaveBalance " + Common.Classes.clsMain.intComId + ", " + cboFinyear.Value.ToString() + ",'" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "','Summary'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
else if (gridCriteria.ActiveRow.Cells[0].Value.ToString().ToUpper() == "MonthDetails".ToUpper())
{
string sqlquary = "Exec rptLeaveBalanceDetails " + Common.Classes.clsMain.intComId + ", " + cboFinyear.Value.ToString() + ",'" + (gridSec.ActiveRow.Cells["sectid"].Value.ToString()) + "', '" + (gridEmp.ActiveRow.Cells["empid"].Value.ToString()) + "','" + (gridActive.ActiveRow.Cells["SL"].Value.ToString()) + "','" + (gridEmpType.ActiveRow.Cells["varName"].Value.ToString()) + "', 'MonthDetails'";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "tblLeaveDetails";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["tblLeaveDetails"];
}
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = gridCriteria.ActiveRow.Cells["Criteria"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string sqlquary = "", ProssType = "", Rpt = "";
ProssType = gridProssType.ActiveRow.Cells["ProssType"].Value.ToString();
Rpt = gridReportCategory.ActiveRow.Cells["rptName"].Value.ToString();
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Cadre Attendance"))
{
sqlquary = "Exec rptCadreAttendance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "','" + clsProc.GTRDate(dtPross.Value.ToString()) + "',0,0,'','',2";
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Cadre Attendance Summary"))
{
sqlquary = "Exec rptCadreAttendance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "','" + clsProc.GTRDate(dtPross.Value.ToString()) + "',0,0,'','',3";
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Struck Off Summary"))
{
sqlquary = "Exec rptCadreAttendance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "','" + clsProc.GTRDate(dtPross.Value.ToString()) + "',0,0,'','',4";
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Cadre Absent Analysis"))
{
sqlquary = "Exec rptCadreAttendance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "','" + clsProc.GTRDate(dtPross.Value.ToString()) + "',0,0,'" + clsProc.GTRDate(dtFrom.Value.ToString()) + "','" + clsProc.GTRDate(dtTo.Value.ToString()) + "',5";
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Struck Off Summary Analysis"))
{
sqlquary = "Exec rptCadreAttendance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "','" + clsProc.GTRDate(dtPross.Value.ToString()) + "',0,0,'" + clsProc.GTRDate(dtFrom.Value.ToString()) + "','" + clsProc.GTRDate(dtTo.Value.ToString()) + "',6";
}
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Cadre";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Cadre"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = gridReportCategory.ActiveRow.Cells["rptName"].Value.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string SQLQuery = "";
string SectId = "0", type = "", EmpId = "0", Status = "0", Grade = "";
SectId = gridArea.ActiveRow.Cells["SectId"].Value.ToString();
EmpId = gridEmp.ActiveRow.Cells["EmpId"].Value.ToString();
Status = gridEmpStatus.ActiveRow.Cells["EmpStatus"].Value.ToString();
type = gridEmpType.ActiveRow.Cells["EmpType"].Value.ToString();
Grade = gridBand.ActiveRow.Cells["Grade"].Value.ToString();
if ((gridEmpStatus.ActiveRow.Cells["EmpStatus"].Text.ToString() == "=ALL="))
{
SQLQuery = "Exec rptInsuranceList " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', " + SectId + " , '" + Status + "', '" + EmpId + "' ,'" + type + "','" + Grade + "' ";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if ((gridEmpStatus.ActiveRow.Cells["EmpStatus"].Text.ToString() == "Active"))
{
SQLQuery = "Exec rptInsuranceList " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', " + SectId + " , '" + Status + "', '" + EmpId + "' ,'" + type + "','" + Grade + "' ";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if ((gridEmpStatus.ActiveRow.Cells["EmpStatus"].Text.ToString() == "Inactive"))
{
SQLQuery = "Exec rptInsuranceList " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', " + SectId + " , '" + Status + "', '" + EmpId + "' ,'" + type + "','" + Grade + "' ";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if ((gridEmpStatus.ActiveRow.Cells["EmpStatus"].Text.ToString() == "New Joining"))
{
SQLQuery = "Exec rptInsuranceList " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', " + SectId + " , '" + Status + "', '" + EmpId + "' ,'" + type + "','" + Grade + "' ";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
else if ((gridEmpStatus.ActiveRow.Cells["EmpStatus"].Text.ToString() == "Released"))
{
SQLQuery = "Exec rptInsuranceList " + Common.Classes.clsMain.intComId + ", '" + clsProc.GTRDate(dtFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtTo.Value.ToString()) + "', " + SectId + " , '" + Status + "', '" + EmpId + "','" + type + "','" + Grade + "' ";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, SQLQuery);
dsList.Tables[0].TableName = "List";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["List"];
}
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Employee Insurance List.xls" + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void InitializeComponent()
{
this.components = (IContainer) new Container();
Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance2 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance3 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance4 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance5 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance6 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance7 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance8 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance9 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance10 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance11 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance12 = new Infragistics.Win.Appearance();
ComponentResourceManager componentResourceManager = new ComponentResourceManager(typeof(FrmMC601LogInfoViewer));
this.btnReadLog = new Button();
this.btnExportToExcel = new Button();
this.grdInfoLog = new UltraGrid();
this.saveFileDialog1 = new SaveFileDialog();
this.ultraGridExcelExporter1 = new UltraGridExcelExporter(this.components);
//this.grdInfoLog.BeginInit();
this.SuspendLayout();
this.btnReadLog.Location = new Point(13, 12);
this.btnReadLog.Name = "btnReadLog";
this.btnReadLog.Size = new Size(75, 23);
this.btnReadLog.TabIndex = 0;
this.btnReadLog.Text = "Read Log";
this.btnReadLog.UseVisualStyleBackColor = true;
this.btnReadLog.Click += new EventHandler(this.btnReadLog_Click);
this.btnExportToExcel.Location = new Point(94, 12);
this.btnExportToExcel.Name = "btnExportToExcel";
this.btnExportToExcel.Size = new Size(97, 23);
this.btnExportToExcel.TabIndex = 2;
this.btnExportToExcel.Text = "Export to Excel";
this.btnExportToExcel.UseVisualStyleBackColor = true;
this.btnExportToExcel.Click += new EventHandler(this.btnExportToExcel_Click);
this.grdInfoLog.Anchor = AnchorStyles.Top | AnchorStyles.Bottom | AnchorStyles.Left | AnchorStyles.Right;
appearance1.BackColor = SystemColors.Window;
appearance1.BorderColor = SystemColors.InactiveCaption;
this.grdInfoLog.DisplayLayout.Appearance = (AppearanceBase)appearance1;
this.grdInfoLog.DisplayLayout.AutoFitStyle = AutoFitStyle.ExtendLastColumn;
this.grdInfoLog.DisplayLayout.BorderStyle = UIElementBorderStyle.Solid;
this.grdInfoLog.DisplayLayout.CaptionVisible = DefaultableBoolean.False;
appearance2.BackColor = SystemColors.ActiveBorder;
appearance2.BackColor2 = SystemColors.ControlDark;
appearance2.BackGradientStyle = GradientStyle.Vertical;
appearance2.BorderColor = SystemColors.Window;
this.grdInfoLog.DisplayLayout.GroupByBox.Appearance = (AppearanceBase)appearance2;
appearance3.ForeColor = SystemColors.GrayText;
this.grdInfoLog.DisplayLayout.GroupByBox.BandLabelAppearance = (AppearanceBase)appearance3;
this.grdInfoLog.DisplayLayout.GroupByBox.BorderStyle = UIElementBorderStyle.Solid;
appearance4.BackColor = SystemColors.ControlLightLight;
appearance4.BackColor2 = SystemColors.Control;
appearance4.BackGradientStyle = GradientStyle.Horizontal;
appearance4.ForeColor = SystemColors.GrayText;
this.grdInfoLog.DisplayLayout.GroupByBox.PromptAppearance = (AppearanceBase)appearance4;
this.grdInfoLog.DisplayLayout.MaxColScrollRegions = 1;
this.grdInfoLog.DisplayLayout.MaxRowScrollRegions = 1;
appearance5.BackColor = SystemColors.Window;
appearance5.ForeColor = SystemColors.ControlText;
this.grdInfoLog.DisplayLayout.Override.ActiveCellAppearance = (AppearanceBase)appearance5;
appearance6.BackColor = SystemColors.Highlight;
appearance6.ForeColor = SystemColors.HighlightText;
this.grdInfoLog.DisplayLayout.Override.ActiveRowAppearance = (AppearanceBase)appearance6;
this.grdInfoLog.DisplayLayout.Override.BorderStyleCell = UIElementBorderStyle.Dotted;
this.grdInfoLog.DisplayLayout.Override.BorderStyleRow = UIElementBorderStyle.Dotted;
appearance7.BackColor = SystemColors.Window;
this.grdInfoLog.DisplayLayout.Override.CardAreaAppearance = (AppearanceBase)appearance7;
appearance8.BorderColor = Color.Silver;
appearance8.TextTrimming = TextTrimming.EllipsisCharacter;
this.grdInfoLog.DisplayLayout.Override.CellAppearance = (AppearanceBase)appearance8;
this.grdInfoLog.DisplayLayout.Override.CellClickAction = CellClickAction.EditAndSelectText;
this.grdInfoLog.DisplayLayout.Override.CellPadding = 0;
appearance9.BackColor = SystemColors.Control;
appearance9.BackColor2 = SystemColors.ControlDark;
appearance9.BackGradientAlignment = GradientAlignment.Element;
appearance9.BackGradientStyle = GradientStyle.Horizontal;
appearance9.BorderColor = SystemColors.Window;
this.grdInfoLog.DisplayLayout.Override.GroupByRowAppearance = (AppearanceBase)appearance9;
appearance10.TextHAlignAsString = "Left";
this.grdInfoLog.DisplayLayout.Override.HeaderAppearance = (AppearanceBase)appearance10;
this.grdInfoLog.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortMulti;
this.grdInfoLog.DisplayLayout.Override.HeaderStyle = HeaderStyle.WindowsXPCommand;
appearance11.BackColor = SystemColors.Window;
appearance11.BorderColor = Color.Silver;
this.grdInfoLog.DisplayLayout.Override.RowAppearance = (AppearanceBase)appearance11;
this.grdInfoLog.DisplayLayout.Override.RowSelectors = DefaultableBoolean.False;
appearance12.BackColor = SystemColors.ControlLight;
this.grdInfoLog.DisplayLayout.Override.TemplateAddRowAppearance = (AppearanceBase)appearance12;
this.grdInfoLog.DisplayLayout.ScrollBounds = ScrollBounds.ScrollToFill;
this.grdInfoLog.DisplayLayout.ScrollStyle = ScrollStyle.Immediate;
this.grdInfoLog.DisplayLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;
this.grdInfoLog.Location = new Point(0, 41);
this.grdInfoLog.Name = "grdInfoLog";
this.grdInfoLog.Size = new Size(665, 439);
this.grdInfoLog.TabIndex = 3;
this.grdInfoLog.Text = "grdInfoLog";
this.grdInfoLog.InitializeLayout += new InitializeLayoutEventHandler(this.grdInfoLog_InitializeLayout);
this.AutoScaleDimensions = new SizeF(6f, 13f);
//this.AutoScaleMode = AutoScaleMode.Font;
this.ClientSize = new Size(662, 479);
this.Controls.Add((Control)this.grdInfoLog);
this.Controls.Add((Control)this.btnExportToExcel);
this.Controls.Add((Control)this.btnReadLog);
//this.Icon = (Icon) componentResourceManager.GetObject("$this.Icon");
this.Name = "FrmMC601LogInfoViewer";
this.ShowIcon = false;
this.ShowInTaskbar = false;
this.Text = "MC601 Log Info Viewer";
// this.grdInfoLog.EndInit();
this.ResumeLayout(false);
}
private void esportaGridExcel()
{
var grids = getFormGrid(MainStandardForm_Fill_Panel.Controls);
if (grids.Count > 0)
{
try
{
var grid = findCurrentGrid(grids);
if (grid != null)
{
var pathTempFile = Utility.GetTempFolder(grid.DisplayLayout.Bands[0].Header.Caption + ".xlsx", "xlsx");
try
{
var ultraGridExcelExporter1 = new UltraGridExcelExporter(components);
ultraGridExcelExporter1.Export(grid, pathTempFile, WorkbookFormat.Excel2007);
ultraGridExcelExporter1.ExportValueLists = false;
ultraGridExcelExporter1.Dispose();
}
catch (Exception ex)
{
log.ErrorFormat("Errore l'esportazione della grid in excel - (EXPORT) - {0} - grid:{1} - path:{2} - form text:{3} - azienda:{4}", ex, Utility.GetMethodDescription(), grid.Name, pathTempFile, Text, Login.Instance.CurrentLogin().Azienda);
throw;
}
System.Diagnostics.Process.Start(pathTempFile);
}
}
catch (Exception ex)
{
log.ErrorFormat("Errore durante l'esportazione dei dati in excel - {0} - azienda:{1}", ex, Utility.GetMethodDescription(), Login.Instance.CurrentLogin().Azienda);
}
}
}
private void InitializeComponent()
{
this.components = (IContainer) new Container();
Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance2 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance3 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance4 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance5 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance6 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance7 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance8 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance9 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance10 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance11 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance12 = new Infragistics.Win.Appearance();
ComponentResourceManager componentResourceManager = new ComponentResourceManager(typeof(FrmMC601RegisterViewer));
this.grdView = new UltraGrid();
this.btnExportToExcel = new Button();
this.ultraGridExcelExporter1 = new UltraGridExcelExporter(this.components);
this.saveFileDialog1 = new SaveFileDialog();
this.btnPrint = new Button();
this.ultraPrintPreviewDialog1 = new UltraPrintPreviewDialog(this.components);
this.grdView.BeginInit();
this.SuspendLayout();
this.grdView.Anchor = AnchorStyles.Top | AnchorStyles.Bottom | AnchorStyles.Left | AnchorStyles.Right;
appearance1.BackColor = SystemColors.Window;
appearance1.BorderColor = SystemColors.InactiveCaption;
this.grdView.DisplayLayout.Appearance = (AppearanceBase)appearance1;
this.grdView.DisplayLayout.BorderStyle = UIElementBorderStyle.Solid;
this.grdView.DisplayLayout.CaptionVisible = DefaultableBoolean.False;
appearance2.BackColor = SystemColors.ActiveBorder;
appearance2.BackColor2 = SystemColors.ControlDark;
appearance2.BackGradientStyle = GradientStyle.Vertical;
appearance2.BorderColor = SystemColors.Window;
this.grdView.DisplayLayout.GroupByBox.Appearance = (AppearanceBase)appearance2;
appearance3.ForeColor = SystemColors.GrayText;
this.grdView.DisplayLayout.GroupByBox.BandLabelAppearance = (AppearanceBase)appearance3;
this.grdView.DisplayLayout.GroupByBox.BorderStyle = UIElementBorderStyle.Solid;
appearance4.BackColor = SystemColors.ControlLightLight;
appearance4.BackColor2 = SystemColors.Control;
appearance4.BackGradientStyle = GradientStyle.Horizontal;
appearance4.ForeColor = SystemColors.GrayText;
this.grdView.DisplayLayout.GroupByBox.PromptAppearance = (AppearanceBase)appearance4;
this.grdView.DisplayLayout.MaxColScrollRegions = 1;
this.grdView.DisplayLayout.MaxRowScrollRegions = 1;
appearance5.BackColor = SystemColors.Window;
appearance5.ForeColor = SystemColors.ControlText;
this.grdView.DisplayLayout.Override.ActiveCellAppearance = (AppearanceBase)appearance5;
appearance6.BackColor = SystemColors.Highlight;
appearance6.ForeColor = SystemColors.HighlightText;
this.grdView.DisplayLayout.Override.ActiveRowAppearance = (AppearanceBase)appearance6;
this.grdView.DisplayLayout.Override.AllowDelete = DefaultableBoolean.False;
this.grdView.DisplayLayout.Override.AllowUpdate = DefaultableBoolean.False;
this.grdView.DisplayLayout.Override.BorderStyleCell = UIElementBorderStyle.Dotted;
this.grdView.DisplayLayout.Override.BorderStyleRow = UIElementBorderStyle.Dotted;
appearance7.BackColor = SystemColors.Window;
this.grdView.DisplayLayout.Override.CardAreaAppearance = (AppearanceBase)appearance7;
appearance8.BorderColor = Color.Silver;
appearance8.TextTrimming = TextTrimming.EllipsisCharacter;
this.grdView.DisplayLayout.Override.CellAppearance = (AppearanceBase)appearance8;
this.grdView.DisplayLayout.Override.CellClickAction = CellClickAction.EditAndSelectText;
this.grdView.DisplayLayout.Override.CellPadding = 0;
appearance9.BackColor = SystemColors.Control;
appearance9.BackColor2 = SystemColors.ControlDark;
appearance9.BackGradientAlignment = GradientAlignment.Element;
appearance9.BackGradientStyle = GradientStyle.Horizontal;
appearance9.BorderColor = SystemColors.Window;
this.grdView.DisplayLayout.Override.GroupByRowAppearance = (AppearanceBase)appearance9;
appearance10.TextHAlignAsString = "Left";
this.grdView.DisplayLayout.Override.HeaderAppearance = (AppearanceBase)appearance10;
this.grdView.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortMulti;
this.grdView.DisplayLayout.Override.HeaderStyle = HeaderStyle.WindowsXPCommand;
appearance11.BackColor = SystemColors.Window;
appearance11.BorderColor = Color.Silver;
this.grdView.DisplayLayout.Override.RowAppearance = (AppearanceBase)appearance11;
this.grdView.DisplayLayout.Override.RowSelectors = DefaultableBoolean.False;
appearance12.BackColor = SystemColors.ControlLight;
this.grdView.DisplayLayout.Override.TemplateAddRowAppearance = (AppearanceBase)appearance12;
this.grdView.DisplayLayout.ScrollBounds = ScrollBounds.ScrollToFill;
this.grdView.DisplayLayout.ScrollStyle = ScrollStyle.Immediate;
this.grdView.Location = new Point(0, 36);
this.grdView.Name = "grdView";
this.grdView.Size = new Size(819, 504);
this.grdView.TabIndex = 0;
this.grdView.Text = " ";
this.btnExportToExcel.Location = new Point(12, 7);
this.btnExportToExcel.Name = "btnExportToExcel";
this.btnExportToExcel.Size = new Size(97, 23);
this.btnExportToExcel.TabIndex = 1;
this.btnExportToExcel.Text = "Export to Excel";
this.btnExportToExcel.UseVisualStyleBackColor = true;
this.btnExportToExcel.Click += new EventHandler(this.btnExportToExcel_Click);
this.saveFileDialog1.DefaultExt = "xls";
this.saveFileDialog1.Filter = "Excel files|*.xls|All files|*.*";
this.saveFileDialog1.Title = "Enter Excel file to save to.";
this.btnPrint.Location = new Point(115, 7);
this.btnPrint.Name = "btnPrint";
this.btnPrint.Size = new Size(97, 23);
this.btnPrint.TabIndex = 2;
this.btnPrint.Text = "Print";
this.btnPrint.UseVisualStyleBackColor = true;
this.btnPrint.Click += new EventHandler(this.btnPrint_Click);
this.ultraPrintPreviewDialog1.Name = "ultraPrintPreviewDialog1";
this.AutoScaleDimensions = new SizeF(6f, 13f);
this.AutoScaleMode = AutoScaleMode.Font;
this.ClientSize = new Size(819, 540);
this.Controls.Add((Control)this.btnPrint);
this.Controls.Add((Control)this.btnExportToExcel);
this.Controls.Add((Control)this.grdView);
this.Icon = (Icon)componentResourceManager.GetObject("$this.Icon");
this.Name = "FrmMC601RegisterViewer";
this.ShowIcon = false;
this.ShowInTaskbar = false;
this.Text = "MC601 Register Viewer";
this.Load += new EventHandler(this.frmMC601RegisterViewer_Load);
this.grdView.EndInit();
this.ResumeLayout(false);
}
private void btnExportToSelected_ButtonClick(object sender, EventArgs e)
{
var item = (ToolStripSplitButton)sender;
string selectedFormat = item.Tag.ToString();
if (selectedFormat == ExportFormats.Excel)
{
var exp = new UltraGridExcelExporter();
SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Excel|*.xls");
if (sfd.ShowDialog() == DialogResult.OK)
{
exp.Export(_view.grdData, sfd.FileName, WorkbookFormat.Excel97To2003);
}
}
else if (selectedFormat == ExportFormats.Excel2007)
{
var exp = new UltraGridExcelExporter();
SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Excel 2007|*.xlsx");
if (sfd.ShowDialog() == DialogResult.OK)
{
exp.Export(_view.grdData, sfd.FileName, WorkbookFormat.Excel2007);
}
}
else if (selectedFormat == ExportFormats.Pdf)
{
var exp = new UltraGridDocumentExporter();
SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Pdf|*.pdf");
if (sfd.ShowDialog() == DialogResult.OK)
{
exp.Export(_view.grdData, sfd.FileName, GridExportFileFormat.PDF);
}
}
else if (selectedFormat == ExportFormats.Xps)
{
var exp = new UltraGridDocumentExporter();
SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Xps|*.xps");
if (sfd.ShowDialog() == DialogResult.OK)
{
exp.Export(_view.grdData, sfd.FileName, GridExportFileFormat.XPS);
}
}
else if (selectedFormat == ExportFormats.Xml)
{
// var exp = new UltraGridDocumentExporter();
SaveFileDialog sfd = DialogFactory.Instance.GetSaveFormatDialog("Xml|*.xml");
if (sfd.ShowDialog() == DialogResult.OK)
{
if (_view.grdData.DataSource is DataSet)
{
var ds = (DataSet)_view.grdData.DataSource;
ds.WriteXml(sfd.FileName, XmlWriteMode.IgnoreSchema);
}
else if (_view.grdData.DataSource is DataTable)
{
var dt = (DataTable)_view.grdData.DataSource;
dt.WriteXml(sfd.FileName, XmlWriteMode.IgnoreSchema);
}
}
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
dsDetails = new DataSet();
ArrayList arQuery = new ArrayList();
GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
string ReportPath = "", SQLQuery = "", Band = "";
Band = gridBand.ActiveRow.Cells["varName"].Value.ToString();
if ((cboType.Text.ToString() == "Transport"))
{
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Allowance Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheet] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Summary Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheetSum] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Denomination"))
{
SQLQuery = "Exec [rptAllowanceDeno] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
}
else if ((cboType.Text.ToString() == "Friday"))
{
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Allowance Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheet] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Summary Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheetSum] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Denomination"))
{
SQLQuery = "Exec [rptAllowanceDeno] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
}
else if ((cboType.Text.ToString() == "Holiday"))
{
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Allowance Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheet] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Summary Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheetSum] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Denomination"))
{
SQLQuery = "Exec [rptAllowanceDeno] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
}
else if ((cboType.Text.ToString() == "Night"))
{
if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Allowance Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheet] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Summary Sheet"))
{
SQLQuery = "Exec [rptAllowanceSheetSum] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if ((gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() == "Denomination"))
{
SQLQuery = "Exec [rptAllowanceDeno] " + Common.Classes.clsMain.intComId + ", '" + gridProssType.ActiveRow.Cells[0].Value.ToString() + "','" + gridSec.ActiveRow.Cells[0].Value.ToString() + "','" + gridEmployee.ActiveRow.Cells[0].Value.ToString() + "','" + cboType.Text.ToString() + "','" + Band + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
}
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = cboType.Text.ToString() + "-" + gridReportCategory.ActiveRow.Cells["rptname"].Text.ToString() + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcelType_Click(object sender, EventArgs e)
{
dsDetails = new DataSet();
ArrayList arQuery = new ArrayList();
GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
string EmpId = "0", UserId = "0", Type = "=ALL=";
EmpId = gridEmployeeID.ActiveRow.Cells["EmpId"].Value.ToString();
UserId = gridList.ActiveRow.Cells["LUserId"].Value.ToString();
Type = gridType.ActiveRow.Cells["Type"].Value.ToString();
if (optCriteria.Value.ToString().ToUpper() == "Employee".ToUpper())
{
string SQLQuery = "Exec rptTranLog '" + UserId + "',1, '" + EmpId + "','" + Type + "','Employee','" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
else if (optCriteria.Value.ToString().ToUpper() == "User".ToUpper())
{
string SQLQuery = "Exec rptTranLog '" + UserId + "',1, '" + EmpId + "','" + Type + "','User','" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "'";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, SQLQuery);
dsDetails.Tables[0].TableName = "Rpt";
gridExcel.DataSource = null;
gridExcel.DataSource = dsDetails.Tables["Rpt"];
}
if (dsDetails.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Data Not Found");
return;
}
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Transection Log_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
private void btnExcel_Click(object sender, EventArgs e)
{
string Description = "";
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(dtFrom.DateTime.Month).ToString();
Description = strMonthName + "-" + (dtFrom.DateTime.Year);
clsConnection clscon = new clsConnection();
dsList = new System.Data.DataSet();
string Band = "";
Band = "=ALL=";
String sqlquary = "Exec [rptTiffinSheet] " + Common.Classes.clsMain.intComId + ", '" + Description + "',0,0,'" + Band + "',1";
clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary);
dsList.Tables[0].TableName = "Tiffin";
gridExcel.DataSource = null;
gridExcel.DataSource = dsList.Tables["Tiffin"];
DialogResult dlgRes =
MessageBox.Show("Do You Want to Save the Data Sheet");
if (dlgRes != DialogResult.OK)
{
return;
}
SaveFileDialog dlgSurveyExcel = new SaveFileDialog();
dlgSurveyExcel.Filter = "Excel WorkBook (*.xls)|.xls";
dlgSurveyExcel.FileName = "Tiffin List" + "_" + DateTime.Now.ToShortDateString().Replace(@"/", "_");
dlgSurveyExcel.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
DialogResult dlgResSaveFile = dlgSurveyExcel.ShowDialog();
if (dlgResSaveFile == DialogResult.Cancel)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
UltraGridExcelExporter GridToToExcel = new UltraGridExcelExporter();
GridToToExcel.FileLimitBehaviour = FileLimitBehaviour.TruncateData;
GridToToExcel.InitializeColumn += new InitializeColumnEventHandler(GridToToExcel_InitializeColumn);
GridToToExcel.Export(gridExcel, dlgSurveyExcel.FileName);
MessageBox.Show("Download complete.");
}
