public List <Rcbp1> Get_Rcbp1_SpsList(Rcbp request)
{
List <Rcbp1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
int count = int.Parse(request.RecordCount);
string strWhere = "";
if (!string.IsNullOrEmpty(request.BusinessPartyName))
{
strWhere = " Where PartyType='CL' And BusinessPartyName LIKE '" + request.BusinessPartyName + "%'";
}
string strSelect = "SELECT " +
"r1.*, (Select Top 1 CountryName From Rccy1 Where CountryCode=r1.CountryCode) AS CountryName " +
"FROM Rcbp1 r1," +
"(SELECT TOP " + (count + 20) + " row_number() OVER (ORDER BY BusinessPartyName ASC) n, TrxNo FROM Rcbp1 " + strWhere + ") r2 " +
"WHERE r1.TrxNo = r2.TrxNo AND r2.n > " + count;
string strOrderBy = " ORDER BY r2.n ASC";
string strSQL = strSelect + strOrderBy;
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())
{
if (!string.IsNullOrEmpty(request.BusinessPartyName))
{
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);
}
else if (!string.IsNullOrEmpty(request.TrxNo))
{
string strSQL = "Select top 1 *,(Select Top 1 CountryName From Rccy1 Where CountryCode=Rcbp1.CountryCode) AS CountryName From Rcbp1 Where IsNUll(StatusCode,'')<>'DEL' And TrxNo=" + int.Parse(request.TrxNo);
Result = db.Select <Rcbp1>(strSQL);
}
//else
//{
// string strSQL = "Select Top 10 *,(Select Top 1 CountryName From Rccy1 Where CountryCode=Rcbp1.CountryCode) AS CountryName From Rcbp1 Where IsNUll(StatusCode,'')<>'DEL' Order By BusinessPartyName Asc";
// Result = db.Select<Rcbp1>(strSQL);
//}
}
}
catch { throw; }
return(Result);
}
public List <Rcdg1> Get_Rcdg1UnNo_List(Rcbp request)
{
List <Rcdg1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
if (!string.IsNullOrEmpty(request.UnNo))
{
if (request.UnNoFlag == "Y")
{
string strSQL = "Select UnNo,DGClass,DGDescription From Rcdg1 Where UnNo = '" + request.UnNo + "' ";
Result = db.Select <Rcdg1>(strSQL);
}
else
{
string strSQL = "Select UnNo,DGClass,DGDescription From Rcdg1 Where UnNo LIKE '" + request.UnNo + "%' Order By UnNo Asc";
Result = db.Select <Rcdg1>(strSQL);
}
}
else
{
Result = null;
}
}
}
catch { throw; }
return(Result);
}
public List <Rcbp1> Get_Rcbp1_List(Rcbp request)
{
List <Rcbp1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
if (!string.IsNullOrEmpty(request.BusinessPartyName))
{
string strSQL = "Select Address1 , Address2,Address3 ,Address4 ,BusinessPartyCode, BusinessPartyName, StatusCode From Rcbp1 Where StatusCode = 'USE' And BusinessPartyName LIKE '" + request.BusinessPartyName + "%' Order By BusinessPartyCode Asc";
Result = db.Select <Rcbp1>(strSQL);
}
else if (!string.IsNullOrEmpty(request.BusinessPartyCode))
{
string strSQL = "Select Address1 , Address2,Address3 ,Address4 , BusinessPartyCode, BusinessPartyName, StatusCode From Rcbp1 Where StatusCode = 'USE' And BusinessPartyCode LIKE '" + request.BusinessPartyCode + "%' Order By BusinessPartyCode Asc";
Result = db.Select <Rcbp1>(strSQL);
}
else
{
Result = null;
}
}
}
catch { throw; }
return(Result);
}
public List <Rcbp1> Get_Rcbp1_All(Rcbp request)
{
List <Rcbp1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
string strSQL = "Select ISNULL(BusinessPartyCode,'') AS BusinessPartyCode From Rcbp1 Where PartyType = 'TR' And BusinessPartyCode !=''";
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("WMS"))
{
if (!string.IsNullOrEmpty(request.UserDefine01))
{
string strSQL = "Select Top 10 * From imgr1 Where IsNUll(StatusCode,'')<>'DEL' And UserDefine01 LIKE '" + request.UserDefine01 + "%' Order By UserDefine01 Asc";
Result = db.Select<Rcbp1>(strSQL);
}
}
}
catch { throw; }
return Result;
}
