public C_ROUTE_DETAIL_RETURN GetById(string id, OleExec DB)
{
string strSql = $@"select * from c_route_detail_return where id=:id";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", id) };
DataTable res = DB.ExecuteDataTable(strSql, CommandType.Text, paramet);
if (res.Rows.Count > 0)
{
Row_C_ROUTE_DETAIL_RETURN ret = (Row_C_ROUTE_DETAIL_RETURN)NewRow();
ret.loadData(res.Rows[0]);
return(ret.GetDataObject());
}
else
{
return(null);
}
}
public List <C_ROUTE_DETAIL_RETURN> GetByRturn_Route_DetailId(string return_route_detailid, OleExec DB)
{
string strSql = $@"select * from c_route_detail_return where return_route_detail_id=:return_route_detail_id";
OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":return_route_detail_id", return_route_detailid) };
DataTable res = DB.ExecuteDataTable(strSql, CommandType.Text, paramet);
if (res.Rows.Count > 0)
{
List <C_ROUTE_DETAIL_RETURN> retlist = new List <C_ROUTE_DETAIL_RETURN>();
for (int i = 0; i < res.Rows.Count; i++)
{
Row_C_ROUTE_DETAIL_RETURN ret = (Row_C_ROUTE_DETAIL_RETURN)NewRow();
ret.loadData(res.Rows[i]);
retlist.Add(ret.GetDataObject());
}
return(retlist);
}
else
{
return(null);
}
}
