public List <Sibl2> Read_Sibl2_List(Sibl request)
{
List <Sibl2> 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);
}
public List <Sibl2> Get_Sibl2_List(Sibl request)
{
List <Sibl2> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
string strSQL = "Select TrxNo, LineItemNo, ISNULL(ContainerNo,'') AS ContainerNo, ISNULL(CntrRemark,'') AS CntrRemark,ISNULL(CargoStatusCode,'') AS CargoStatusCode, ISNULL(GoodsDescription01,'') AS GoodsDescription01 From Sibl2 Where TrxNo=" + int.Parse(request.TrxNo);
Result = db.Select <Sibl2>(strSQL);
}
}
catch { throw; }
return(Result);
}
public int Update_Sibl2(Sibl request)
{
int Result = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection())
{
Result = db.Update <Sibl2>(
new
{
ContainerNo = request.ContainerNo,
CntrRemark = request.CntrRemark,
CargoStatusCode = request.CargoStatusCode
},
p => p.TrxNo == int.Parse(request.TrxNo) && p.LineItemNo == int.Parse(request.LineItemNo)
);
}
}
catch { throw; }
return(Result);
}
