C# CIMES中查表,最后返回一个List
例子,WORuncardInfo页面的GetRuncardData方法
public static List<WORuncardInfo> GetRuncardData(WorkOrderInfoEx woData, bool includeDeleteData) { if (woData == null) return new List<WORuncardInfo>(); string sql = @"SELECT * FROM AOI_WO_RUNCARD WHERE WPC_WO_SID = #[STRING]"; if (includeDeleteData == false) { sql += " AND STATUS != '" + StatusString.Deleted + "'"; } sql += " ORDER BY WO_RUNCARD_SID"; List<WORuncardInfo> runcardList = InfoCenter.GetList<WORuncardInfo>(sql, woData.WorkOrderSID); return runcardList; }