protected object ctlMonitoringInBoxGrid_RequestData()
{
MonitoringInBoxSearchCriteria Criteria = new MonitoringInBoxSearchCriteria();
Criteria.Company = ctlCompanyField.CompanyCode;
Criteria.BusinessGroup = ctlBUDropdown.SelectedValue;
Criteria.FromDate = ctlRequestDateFrom.Value;
Criteria.ToDate = ctlRequestDateTo.Value;
IList <DocumentMonitoringInbox> Jlis = ScgeAccountingQueryProvider.DbMonitoringInboxQuery.DataMonitoringInBox(Criteria);
var jsonSerialiser = new JavaScriptSerializer();
var json = jsonSerialiser.Serialize(Jlis);
return(json);
}
public IList <DocumentMonitoringInbox> DataMonitoringInBox(MonitoringInBoxSearchCriteria criteria)
{
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("en-US");
ISQLQuery query = GetCurrentSession().CreateSQLQuery("EXECUTE FindMonitoringInbox :CompanyCode,:BUCode,:DateFrom,:DateTo");
query.SetString("CompanyCode", criteria.Company)
.SetString("BUCode", criteria.BusinessGroup)
.SetString("DateFrom", !criteria.FromDate.HasValue ? string.Empty : criteria.FromDate.Value.ToString(culture))
.SetString("DateTo", !criteria.ToDate.HasValue ? string.Empty : criteria.ToDate.Value.ToString(culture));
query.AddScalar("CompanyCode", NHibernateUtil.String)
.AddScalar("BuName", NHibernateUtil.String)
.AddScalar("Col1", NHibernateUtil.Int32)
.AddScalar("Col2", NHibernateUtil.Int32)
.AddScalar("Col3", NHibernateUtil.Int32)
.AddScalar("Col4", NHibernateUtil.Int32)
.AddScalar("Col5", NHibernateUtil.Int32);
query.SetResultTransformer(Transformers.AliasToBean(typeof(DocumentMonitoringInbox)));
DocumentMonitoringInbox result = new DocumentMonitoringInbox();
IList <DocumentMonitoringInbox> list = query.List <DocumentMonitoringInbox>();
return(list);
}
