/// <summary> /// /// </summary> /// <param name="ClassInfoCD"></param> /// <returns></returns> public LookupData LoadLookupLogTable() { InvTranLogDAO dao = new InvTranLogDAO(CommonLib.Common.CurrentDatabase); DataTable dt = dao.LoadLogTable(null); LookupData lookupData = new LookupData(dt, LogTableDTO.eColumns.TABLE_DESCRIPTION.ToString(), LogTableDTO.eColumns.TABLE_NAME.ToString()); return(lookupData); }
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)); }