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