private void LoadData()
{
NZString TableName = cboDataType.SelectedValue == null ? new NZString() : cboDataType.SelectedValue.ToString().ToNZString();
if (TableName.IsNull)
{
//MessageDialog.ShowBusiness(this, new EVOFramework.Message(TKPMessages.eValidate.VLM0183.ToString()));
return;
}
InvTranLogController ctl = new InvTranLogController();
LogInquiryCriteriaDTO cri = new LogInquiryCriteriaDTO();
cri.FromDate = new NZDateTime(dtPeriodBegin, dtPeriodBegin.Value);
cri.ToDate = new NZDateTime(dtPeriodEnd, dtPeriodEnd.Value);
cri.TableName = TableName;
m_dtLog = ctl.LoadLogData(cri);
//shtView.DataSource = m_AllIssueTransData;
FindDataFromMemory();
// CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
internal DataTable LoadLogData(LogInquiryCriteriaDTO criteria)
{
InvTranLogBIZ biz = new InvTranLogBIZ();
return(biz.LoadLogData(criteria));
}
public DataTable LoadLogData(Database database, LogInquiryCriteriaDTO criteria)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" SELECT * ");
sb.AppendLine(" FROM " + criteria.TableName);
sb.AppendLine(" WHERE " + InvTranLogDTO.eColumns.OPERATION_DATE + " BETWEEN :FROMDATE AND :TODATE ");
#endregion
DataRequest req = new DataRequest(sb.ToString());
req.Parameters.Add("FROMDATE", DataType.DateTime, criteria.FromDate.StrongValue.Date);
req.Parameters.Add("TODATE", DataType.DateTime, criteria.ToDate.StrongValue.Date);
DataSet ds = db.ExecuteDataSet(req);
DataTable dt = null;
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
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));
}
