public DataTable LoadLogData(LogInquiryCriteriaDTO criteria) { EVOFramework.Database.DatabaseCredential dbCre = new EVOFramework.Database.DatabaseCredential(); dbCre.DatabaseName = CommonLib.Common.CurrentDatabase.Credential.DatabaseName + "_HIST"; dbCre.Password = CommonLib.Common.CurrentDatabase.Credential.Password; dbCre.Provider = CommonLib.Common.CurrentDatabase.Credential.Provider; dbCre.ServerName = CommonLib.Common.CurrentDatabase.Credential.ServerName; dbCre.Username = CommonLib.Common.CurrentDatabase.Credential.Username; EVOFramework.Database.Database db = EVOFramework.Database.DatabaseManager.CreateDatabase(dbCre); InvTranLogDAO dao = new InvTranLogDAO(db); return(dao.LoadLogData(null, criteria)); }
public System.Data.DataTable LoadAllInvTranLogPeriod(EVOFramework.NZDateTime FromDate, EVOFramework.NZDateTime ToDate, EVOFramework.NZString ScreenType) { //EVOFramework.Database.DatabaseCredential dbCre = CommonLib.Common.CurrentDatabase.Credential;//new EVOFramework.Database.DatabaseCredential (); //dbCre.DatabaseName = dbCre.DatabaseName + "_HIST"; EVOFramework.Database.DatabaseCredential dbCre = new EVOFramework.Database.DatabaseCredential(); dbCre.DatabaseName = CommonLib.Common.CurrentDatabase.Credential.DatabaseName + "_HIST"; dbCre.Password = CommonLib.Common.CurrentDatabase.Credential.Password; dbCre.Provider = CommonLib.Common.CurrentDatabase.Credential.Provider; dbCre.ServerName = CommonLib.Common.CurrentDatabase.Credential.ServerName; dbCre.Username = CommonLib.Common.CurrentDatabase.Credential.Username; EVOFramework.Database.Database db = EVOFramework.Database.DatabaseManager.CreateDatabase(dbCre); InvTranLogDAO dao = new InvTranLogDAO(db); List <InvTranLogDTO> dtoList = dao.LoadAllInvTranLogPeriod(db, FromDate, ToDate, ScreenType); return(DTOUtility.ConvertListToDataTable(dtoList)); }