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