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 *,(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 *,(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 20 *,(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 <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 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 int Update_Rcbp1(Rcbp request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
Result = db.Update <Rcbp1>(
new
{
BusinessPartyName = request.rcbp1.BusinessPartyName,
Address1 = request.rcbp1.Address1,
Address2 = request.rcbp1.Address2,
Address3 = request.rcbp1.Address3,
Address4 = request.rcbp1.Address4,
CityCode = request.rcbp1.CityCode,
CountryCode = request.rcbp1.CountryCode,
Telephone = request.rcbp1.Telephone,
Fax = request.rcbp1.Fax,
Email = request.rcbp1.Email,
WebSite = request.rcbp1.WebSite
},
p => p.TrxNo == request.rcbp1.TrxNo
);
}
}
catch { throw; }
return(Result);
}
public int Delete_Rcbp3(Rcbp request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
db.Delete <Rcbp3>(r3 => r3.BusinessPartyCode == request.BusinessPartyCode && r3.LineItemNo == int.Parse(request.LineItemNo));
Result = 1;
}
}
catch { throw; }
return(Result);
}
public int Insert_Rcbp3(Rcbp request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
db.Insert(
new Rcbp3
{
BusinessPartyCode = request.rcbp3.BusinessPartyCode,
LineItemNo = request.rcbp3.LineItemNo,
Birthday = null,
ContactName = request.rcbp3.ContactName,
Department = request.rcbp3.Department,
Dislike = request.rcbp3.Dislike,
Email = request.rcbp3.Email,
Facebook = request.rcbp3.Facebook,
Fax = request.rcbp3.Fax,
Handphone = request.rcbp3.Handphone,
Like = request.rcbp3.Like,
MSN = request.rcbp3.MSN,
NameCard = null,
Others = request.rcbp3.Others,
QQ = request.rcbp3.QQ,
Skype = request.rcbp3.Skype,
Telephone = request.rcbp3.Telephone,
Title = request.rcbp3.Title,
Twitter = request.rcbp3.Twitter
}
);
Result = 1;
}
}
catch { throw; }
return(Result);
}
public int Update_Rcbp3(Rcbp request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
Result = db.Update <Rcbp3>(
new
{
//Birthday = request.rcbp3.Birthday,
ContactName = request.rcbp3.ContactName,
Department = request.rcbp3.Department,
Dislike = request.rcbp3.Dislike,
Email = request.rcbp3.Email,
Facebook = request.rcbp3.Facebook,
Fax = request.rcbp3.Fax,
Handphone = request.rcbp3.Handphone,
Like = request.rcbp3.Like,
MSN = request.rcbp3.MSN,
//NameCard = request.rcbp3.NameCard,
Others = request.rcbp3.Others,
QQ = request.rcbp3.QQ,
Skype = request.rcbp3.Skype,
Telephone = request.rcbp3.Telephone,
Title = request.rcbp3.Title,
Twitter = request.rcbp3.Twitter
},
p => p.BusinessPartyCode == request.rcbp3.BusinessPartyCode && p.LineItemNo == request.rcbp3.LineItemNo
);
}
}
catch { throw; }
return(Result);
}
public List <Rcbp3> Read_Rcbp3_List(Rcbp request)
{
List <Rcbp3> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
if (!string.IsNullOrEmpty(request.BusinessPartyCode))
{
if (!string.IsNullOrEmpty(request.LineItemNo))
{
Result = db.Where <Rcbp3>(r1 => r1.BusinessPartyCode == request.BusinessPartyCode && r1.LineItemNo == int.Parse(request.LineItemNo));
}
else
{
Result = db.Where <Rcbp3>(r1 => r1.BusinessPartyCode == request.BusinessPartyCode);
}
}
}
}
catch { throw; }
return(Result);
}
