public void InsertHelpClass(HelpClassInfo HelpClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@ClassName", HelpClass.ClassName);
objParams[1] = new SqlParameter("@IsVisible", HelpClass.IsVisible);
objSqlHelper.ExecuteNonQuery("je_HC_InsertHelpClass", objParams);
}
public int UpdateHelpClass(HelpClassInfo HelpClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@ClassName", HelpClass.ClassName);
objParams[1] = new SqlParameter("@ClassID", HelpClass.ClassID);
objParams[2] = new SqlParameter("@IsVisible", HelpClass.IsVisible);
return objSqlHelper.ExecuteNonQuery("je_HC_UpdateHelpClass", objParams);
}
public HelpClassInfo GetHelpClassByID(int HelpClassID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@ClassID", SqlDbType.Int, 4);
objParams[0].Value = HelpClassID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_HC_GetHelpClassByID", objParams);
HelpClassInfo item = new HelpClassInfo();
while (reader.Read())
{
item.ClassID = reader.GetInt32(reader.GetOrdinal("ClassID"));
item.ClassName = reader.GetString(reader.GetOrdinal("ClassName"));
item.Order = reader.GetInt32(reader.GetOrdinal("Order"));
item.AddDate = reader.GetDateTime(reader.GetOrdinal("AddDate"));
item.IsVisible = reader.GetBoolean(reader.GetOrdinal("IsVisible"));
}
reader.Close();
return item;
}
/// <summary>
/// 删除帮助类别信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int DeleteHelpClass(HelpClassInfo HelpClass)
{
return helpClass.DeleteHelpClass(HelpClass);
}
/// <summary>
/// 更新帮助类别信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdateHelpClass(HelpClassInfo HelpClass)
{
return helpClass.UpdateHelpClass(HelpClass);
}
/// <summary>
/// 添加帮助类别信息
/// </summary>
/// <param name="link"></param>
public static void InsertHelpClass(HelpClassInfo HelpClass)
{
helpClass.InsertHelpClass(HelpClass);
}
public int DeleteHelpClass(HelpClassInfo HelpClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@classID", HelpClass.ClassID);
return objSqlHelper.ExecuteNonQuery("je_HC_DeleteHelpClass", objParams);
}
