public DataSet LoadIVR010_InventorySheet(ReportCriteriaDTO.IVR010 argCriteria) { DataSet dsReturn = null; ReportDAO dao = new ReportDAO(CommonLib.Common.CurrentDatabase); dsReturn = dao.LoadIVR010_InventorySheet(argCriteria); return(dsReturn); }
public DataSet LoadIVR010_InventorySheet(ReportCriteriaDTO.IVR010 argCriteria) { DataSet dsReturn = null; Database db = m_db; DataRequest req = new DataRequest(); req.CommandText = "S_IVR010_InventorySheet"; req.CommandType = CommandType.StoredProcedure; req.Timeout = 180; req.Parameters.Add("@YearMonth", argCriteria.YearMonth); dsReturn = m_db.ExecuteDataSet(req); return(dsReturn); }
private void ExportOnHandForAccounting() { string strFileName = GenerateFileName("IVR010"); string strTemplateFileName = @"Report\IVR010_InventorySheet.xls"; string strTemplatePath = Path.Combine(Application.StartupPath, strTemplateFileName); string strExportPath = SaveDialogUtil.GetBrowseFileDialogForExport(strFileName); if (!"".Equals(strExportPath)) { ReportBIZ bizReport = new ReportBIZ(); ReportCriteriaDTO.IVR010 objCriteria = new ReportCriteriaDTO.IVR010(); if (this.dtPeriodBegin.Value.HasValue) { objCriteria.YearMonth = this.dtPeriodBegin.Value.Value.ToString("yyyyMM"); } else { objCriteria.YearMonth = DateTime.Today.ToString("yyyyMM"); } DataSet dsIVR010 = bizReport.LoadIVR010_InventorySheet(objCriteria); ExportUtil.Export(dsIVR010, strTemplatePath, strExportPath); MessageDialog.ShowInformation(this, null, new EVOFramework.Message(Messages.eInformation.INF9003.ToString()).MessageDescription); if (File.Exists(strExportPath)) { System.Diagnostics.Process.Start(strExportPath); } } }