public List <Rcbp1> Get_rcbp1_List(Rcbp request)
{
List <Rcbp1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
if (!string.IsNullOrEmpty(request.BookingNo))
{
string strSQL = "select isnull(Rcbp1.Handphone1, '') as Handphone1,isnull(Rcbp1.Telephone, '') as Telephone from Rcbp1 left join csbk1 on Rcbp1.BusinessPartyCode=csbk1.BookingCustomerCode where csbk1.BookingNo='" + request.BookingNo + "'";
Result = db.Select <Rcbp1>(strSQL);
}
}
}
catch { throw; }
return(Result);
}
public List <Rcbp1> Get_rcbp1_List(Rcbp request)
{
List <Rcbp1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("TMS"))
{
if (!string.IsNullOrEmpty(request.BusinessPartyName))
{
if (!string.IsNullOrEmpty(request.BusinessPartyName))
{
//string strSQL = "select DISTINCT CustomerCode as BusinessPartyCode ,CustomerName as BusinessPartyName from tjms1 where IsNUll(StatusCode,'')<>'DEL' And CustomerCode LIKE '" + request.BusinessPartyName + "%' Order By tjms1.CustomerCode Asc";
string strSQL = "Select Top 10 *,(Select Top 1 CountryName From Rccy1 Where CountryCode=Rcbp1.CountryCode) AS CountryName From Rcbp1 Where IsNUll(StatusCode,'')<>'DEL' And BusinessPartyName LIKE '" + request.BusinessPartyName + "%' Order By BusinessPartyCode Asc";
Result = db.Select <Rcbp1>(strSQL);
}
}
}
}
catch { throw; }
return(Result);
}
