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