/// <summary> /// 通过ID搜索对应的操作事件类型对象 /// </summary> /// <param name="TypeID">需要查找的ID</param> /// <returns>如果返回的ID为-1为查找失败,其他情况为查找成功</returns> public static OperEvent FindOperEventListByID(int TypeID) { OperEvent node = new OperEvent(); node.EventID = -1; string querystr = "SELECT EventID,EventName from OperEvent where EventID = @index"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@index", SqlDbType.Int) }; para[0].Value = TypeID; SqlDataReader reader = SqlHelper.ExecuteReader(querystr, para); while (reader.Read()) { node.EventID = Convert.ToInt32(reader[0]); node.EventName = reader[1].ToString(); } reader.Close(); return(node); }
/// <summary> /// 通过关键词搜索操作事件类型对象,支持模糊查找 /// </summary> /// <param name="keyword">关键词</param> /// <param name="FuzzyMode">模糊搜索模式,true为开启,false为关闭</param> /// <returns></returns> public static List <OperEvent> FindOperEventListByKeyword(string keyword, bool FuzzyMode) { List <OperEvent> list = new List <OperEvent>(); string FindStr = ""; if (FuzzyMode == true) { FindStr = " like "; } else { FindStr = " = "; } string sqlstr = "SELECT EventID,EventName from OperEvent where EventName" + FindStr + "@SearchName"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@SearchName", SqlDbType.VarChar) }; if (FuzzyMode == true) { para[0].Value = "%" + keyword + "%"; } else { para[0].Value = keyword; } SqlDataReader reader = SqlHelper.ExecuteReader(sqlstr, para); while (reader.Read()) { OperEvent node = new OperEvent(); node.EventID = Convert.ToInt32(reader[0]); node.EventName = Convert.ToString(reader[1]); list.Add(node); } reader.Close(); return(list); }
/// <summary> /// 获取所有的操作事件类型对象 /// </summary> /// <returns>返回list</returns> public static List <OperEvent> GetAllEventType() { List <OperEvent> list = new List <OperEvent>(); string sqlstr = "select EventID,EventName from OperEvent"; SqlDataReader reader = SqlHelper.ExecuteReader(sqlstr); while (reader.Read()) { OperEvent node = new OperEvent(); node.EventID = Convert.ToInt32(reader[0]); node.EventName = Convert.ToString(reader[1]); list.Add(node); } reader.Close(); return(list); }