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

 

posted on 2024-12-11 13:56  写个笔记  阅读(8)  评论(0)    收藏  举报

导航