private string SQLSelect(SQLSelectType SQLSelectType = SQLSelectType.SQLForList)
{
string stSQL = "";
switch (SQLSelectType)
{
case SQLSelectType.SQLForReport:
stSQL = "SELECT chq.BranchID, brnch.BranchCode, chq.TerminalNo, chq.SyncID, chq.ChequePaymentID, chq.TransactionID, chq.ChequeNo, chq.Amount, chq.ValidityDate, chq.Remarks, chq.TransactionNo, chq.CreatedOn, chq.LastModified, trx.CustomerID, trx.CustomerName, trx.CashierName, trx.AgentName " +
"FROM tblChequePayment chq " +
" INNER JOIN tblBranch brnch ON chq.BranchID = brnch.BranchID " +
" INNER JOIN tblTransactions trx ON trx.BranchID = chq.BranchID AND trx.TerminalNo = chq.TerminalNo AND chq.TransactionID = trx.TransactionID ";
break;
case SQLSelectType.SQLForList:
default:
stSQL = "SELECT chq.BranchID, chq.TerminalNo, chq.SyncID, chq.ChequePaymentID, chq.TransactionID, chq.ChequeNo, chq.Amount, chq.ValidityDate, chq.Remarks, chq.TransactionNo, chq.CreatedOn, chq.LastModified " +
"FROM tblChequePayment chq ";
break;
}
return(stSQL);
}
private string SQLSelect(SQLSelectType SQLSelectType = SQLSelectType.SQLForList)
{
string stSQL = "";
switch (SQLSelectType)
{
case SQLSelectType.SQLForReport:
stSQL = "SELECT chq.BranchID, brnch.BranchCode, chq.TerminalNo, chq.SyncID, chq.ChequePaymentID, chq.TransactionID, chq.ChequeNo, chq.Amount, chq.ValidityDate, chq.Remarks, chq.TransactionNo, chq.CreatedOn, chq.LastModified, trx.CustomerID, trx.CustomerName, trx.CashierName, trx.AgentName " +
"FROM tblChequePayment chq " +
" INNER JOIN tblBranch brnch ON chq.BranchID = brnch.BranchID " +
" INNER JOIN tblTransactions trx ON trx.BranchID = chq.BranchID AND trx.TerminalNo = chq.TerminalNo AND chq.TransactionID = trx.TransactionID ";
break;
case SQLSelectType.SQLForList:
default:
stSQL = "SELECT chq.BranchID, chq.TerminalNo, chq.SyncID, chq.ChequePaymentID, chq.TransactionID, chq.ChequeNo, chq.Amount, chq.ValidityDate, chq.Remarks, chq.TransactionNo, chq.CreatedOn, chq.LastModified " +
"FROM tblChequePayment chq ";
break;
}
return stSQL;
}
