private List <MoneyRequestSearchResult> selectToGenerateList() { List <MoneyRequestSearchResult> toGenerateList = new List <MoneyRequestSearchResult>(); for (int i = 0; i < ctlReqGrid.Rows.Count; i++) { CheckBox chkSelect = (CheckBox)ctlReqGrid.Rows[i].Cells[0].FindControl("ctlSelect"); if (chkSelect != null) { if (chkSelect.Checked) { MoneyRequestSearchResult moneyRequest = new MoneyRequestSearchResult(); Label DocumentNo = (Label)ctlReqGrid.Rows[i].Cells[1].FindControl("ctlRequestNo"); moneyRequest.DocumentNo = DocumentNo.Text; moneyRequest.CompanyCode = DocumentNo.Text.Substring(4, 4); DateTime tmpYear = DateTime.Today; moneyRequest.Year = tmpYear.Year; Label DocumentID = (Label)ctlReqGrid.Rows[i].Cells[5].FindControl("ctlDocumentID"); moneyRequest.DocumentID = Convert.ToInt64(DocumentID.Text); moneyRequest.RequestDateOfAdvance = ctlCalendar.Value; toGenerateList.Add(moneyRequest); } } } return(toGenerateList); }
public int RequestCount() { MoneyRequestSearchResult searchResultCriteria = GetSearchResultCriteria(); int count = ScgDbQueryProvider.DbMoneyRequestQuery.CountMoneyRequestByCriteria(searchResultCriteria); return(count); }
public MoneyRequestSearchResult GetSearchResultCriteria() { MoneyRequestSearchResult searchResultCriteria = new MoneyRequestSearchResult(); searchResultCriteria.RequestDateOfAdvance = (DateTime)ctlCalendar.Value; string companyList = GetCompanyCodeList(txtCompanyList.Text); searchResultCriteria.CompanyCode = companyList; searchResultCriteria.LetterNo = ctlLetterId.Text; searchResultCriteria.IsIncludeGeneratedLetter = ctlChkGeneratedLetter.Checked; return(searchResultCriteria); }
public long AddLetterDetail(MoneyRequestSearchResult moneyRequest, string letterNo) { DbCompany company = ScgDbQueryProvider.DbCompanyQuery.getDbCompanyBankAccountByCompanyCode(moneyRequest.CompanyCode); DbBuyingLetterDetail letterDetail = new DbBuyingLetterDetail(); letterDetail.AccountNo = company.AccountNo; letterDetail.AccountType = company.AccountType; letterDetail.BuyingDate = moneyRequest.RequestDateOfAdvance; letterDetail.CompanyName = company.CompanyName; letterDetail.LetterNo = letterNo; letterDetail.BankName = company.BankName; letterDetail.BankBranch = company.BankBranch; letterDetail.CreBy = UserAccount.UserID; letterDetail.CreDate = DateTime.Now; letterDetail.UpdBy = UserAccount.UserID; letterDetail.UpdDate = DateTime.Now; return(ScgDbDaoProvider.DbBuyingLetterDetailDao.Save(letterDetail)); }
public Object RequestData(int startRow, int pageSize, string sortExpression) { MoneyRequestSearchResult searchResultCriteria = GetSearchResultCriteria(); return(ScgDbQueryProvider.DbMoneyRequestQuery.GetMoneyRequestList(searchResultCriteria, startRow, pageSize, sortExpression)); }