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()); }