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