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); }