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