public VOAdvanceOverDueReport BindCriteria()
{
VOAdvanceOverDueReport vo = new VOAdvanceOverDueReport();
vo.CompanyID = UIHelper.ParseLong(ctlCompanyField.CompanyID);
vo.FromLocationCode = ctlFromLocationField.LocationCode;
vo.ToLocationCode = ctlToLocationField.LocationCode;
vo.FromDueDate = ctlFromDueDateCalendar.DateValue;
vo.ToDueDate = ctlToDueDateCalendar.DateValue;
vo.FromAdvanceAmount = UIHelper.ParseDouble(ctlFromAdvanceAmount.Text);
vo.ToAdvanceAmount = UIHelper.ParseDouble(ctlToAdvanceAmount.Text);
vo.FromOverDue = UIHelper.ParseInt(ctlFromOverdueDay.Text);
vo.ToOverDue = UIHelper.ParseInt(ctlToOverdueDay.Text);
vo.AdvanceType = ctlDocumentType.SelectedValue;
if (!string.IsNullOrEmpty(ctlRequesterData.UserID))
{
IList <SuUser> userList = SuUserService.FindByUserName(ctlRequesterData.UserID);
if (userList.Count > 0)
{
long userid = userList[0].Userid;
vo.RequesterID = userid;
}
}
//vo.LanguageID = UserAccount.CurrentLanguageID;
return(vo);
}
public Object RequestData(int startRow, int pageSize, string sortExpression)
{
VOAdvanceOverDueReport vo = ctlAdvanceOverDueCriteria.BindCriteria();
vo.LanguageID = UserAccount.CurrentLanguageID;
list = ScgeAccountingQueryProvider.SCGDocumentQuery.GetAdvanceDocumentReportList(startRow, pageSize, sortExpression, vo);
return(list);
}
public int RequestCount()
{
VOAdvanceOverDueReport vo = ctlAdvanceOverDueCriteria.BindCriteria();
vo.LanguageID = UserAccount.CurrentLanguageID;
int count = ScgeAccountingQueryProvider.SCGDocumentQuery.CountByAdvanceReportCriteria(vo);
return(count);
}
public string BindEmployeeUnclearAdvenceOverdueInbox()
{
//SearchCriteria criteria = new SearchCriteria();
//criteria.UserID = UserAccount.UserID;
//criteria.FlagOutstanding = WorkFlowStateFlag.OutstandingOverdue;
//criteria.FlagQuery = "Employee";
//IList<SearchResultData> criteriaList = ScgeAccountingQueryProvider.SCGDocumentQuery.FindInboxEmployeeSummaryCriteria(criteria);
//return criteriaList.Count.ToString();
VOAdvanceOverDueReport vo = new VOAdvanceOverDueReport();
vo.RequesterID = UserAccount.UserID;
vo.LanguageID = UserAccount.CurrentLanguageID;
vo.FromOverDue = 1;
int count = ScgeAccountingQueryProvider.SCGDocumentQuery.CountByAdvanceReportCriteria(vo);
return(count.ToString());
}
