public void InsertHelp(HelpInfo help)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@ClassID", help.ClassID);
objParams[1] = new SqlParameter("@HelpTitle", help.HelpTitle);
objParams[2] = new SqlParameter("@HelpContent", help.HelpContent);
objSqlHelper.ExecuteNonQuery("je_Help_InsertHelp", objParams);
}
public int UpdateHelp(HelpInfo help)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@ClassID", help.ClassID);
objParams[1] = new SqlParameter("@HelpTitle", help.HelpTitle);
objParams[2] = new SqlParameter("@HelpContent", help.HelpContent);
objParams[3] = new SqlParameter("@HelpID", help.HelpID);
return objSqlHelper.ExecuteNonQuery("je_Help_UpdateHelp", objParams);
}
public HelpInfo GetHelpByID(int helpID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@helpID", SqlDbType.Int, 4);
objParams[0].Value = helpID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Help_GetHelpByID", objParams);
HelpInfo item = new HelpInfo();
while (reader.Read())
{
item.HelpID = reader.GetInt32(reader.GetOrdinal("HelpID"));
item.ClassID = reader.GetInt32(reader.GetOrdinal("ClassID"));
item.ClassName = reader.GetString(reader.GetOrdinal("ClassName"));
item.HelpTitle = reader.GetString(reader.GetOrdinal("helpTitle"));
item.HelpContent = reader.GetString(reader.GetOrdinal("helpContent"));
item.AddDate = reader.GetDateTime(reader.GetOrdinal("AddDate"));
}
reader.Close();
return item;
}
/// <summary>
/// 更新帮助信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdateHelp(HelpInfo Help)
{
return helps.UpdateHelp(Help);
}
/// <summary>
/// 添加帮助信息
/// </summary>
/// <param name="link"></param>
public static void InsertHelp(HelpInfo Help)
{
helps.InsertHelp(Help);
}
