public int UpdateDislike(int trreccord_id) { string sql = "update travel_record set Dislike=Dislike+1 where trreccord_id=@trreccord_id"; SqlParameter[] para = { new SqlParameter("@trreccord_id", trreccord_id) }; return(DBHelper.GetExcuteNonQuery(sql, para)); }
//删除 public int DeleteAct(int UserID) { string sql = "delete from UserInfo where UserID=@UserID"; SqlParameter[] sp = { new SqlParameter("@UserID", UserID) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int UpdateClickNum(int trcol_id) { string sql = "update trrecord_col set col_num=col_num+1 where trcol_id=@trcol_id"; SqlParameter[] sp = { new SqlParameter("@trcol_id", trcol_id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除 public int DeleteAct(int NewsID) { string sql = "delete from NewsInfo where NewsID=@NewsID"; SqlParameter[] sp = { new SqlParameter("@NewsID", NewsID) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int DeleteTravel_re(int trreply_id) { string sql = "delete from travel_comt_reply where trreply_id=@trreply_id"; SqlParameter[] sp = { new SqlParameter("@trreply_id", trreply_id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int UpdateLike(int riarticle_id) { string sql = "update rider_article set Like=Like+1 where riarticle_id=@riarticle_id"; SqlParameter[] para = { new SqlParameter("@riarticle_id", riarticle_id) }; return(DBHelper.GetExcuteNonQuery(sql, para)); }
public int DeleteAct(int VideoID) { string sql = "delete from Video where VideoID=@VideoID"; SqlParameter[] sp = { new SqlParameter("@VideoID", VideoID) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int UpdateCol(int trrecord_id) { string sql = "update travel_record set col_count=col_count+1 where trrecord_id=@trrecord_id"; SqlParameter[] para = { new SqlParameter("@trrecord_id", trrecord_id) }; return(DBHelper.GetExcuteNonQuery(sql, para)); }
public int InsertOrder(int UserID) //从购物车表插入订单表 { SqlParameter[] para = { new SqlParameter("@UserID", UserID) }; return(DBHelper.GetExcuteNonQuery("ShoppingCart_Order", System.Data.CommandType.StoredProcedure, para)); }
//删除用户信息 public int Delete(Users us) { string sql = "delete into Users values(@users_id)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@users_id", us.Users_id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int Dianzan(int T_Id) { string sql = "update Tiezi set t_DianzanNum=t_DianzanNum+1 where T_Id=@T_Id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@T_Id", T_Id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//存数据 public int Insert(Course course) { string sql = "insert into Course values(@CourseID,@CourseName,@TypeName)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@CourseID", course.CourseID), new SqlParameter("@CourseName", course.CourseName), new SqlParameter("@TypeName", course.TypeName) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
/// <summary> /// 更新下载量 /// </summary> /// <param name="V_Id"></param> /// <returns></returns> public int updatev_downloadNum(int V_Id) { string sql = "update Video set v_downloadNum=v_downloadNum+1 where V_Id=@V_Id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@V_Id", V_Id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int updateS_clickNum(int S_Id) { string sql = "update Saishi set s_clickNum=s_clickNum+1 where S_Id=@S_Id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@S_Id", S_Id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//存数据库 public int Insert(AdminInfo admininfo) { string sql = "insert into AdminInfo values(@AdminID,@AdminName,@Password)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@AdminID", admininfo.AdminID), new SqlParameter("@AdminName", admininfo.AdminName), new SqlParameter("@Password", admininfo.Password) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int DeleteDiscussion_re(int direply_id) { string sql = "delete from discussion_reply where direply_id=@direply_id"; SqlParameter[] sp = { new SqlParameter("@direply_id", direply_id), }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int DeleteReplyComments(int ReplyComID) { string sql = "delete from ReplyComments where ReplyComID=@ReplyComID"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ReplyComID", ReplyComID) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int DeleteArticle(int Art_id) { string sql = "delete from Article where Art_id=@Art_id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@Art_id", Art_id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除图书评论 public static int delete(string bcid) { string sql = "delete Book_Comment where bc_id=@bc_id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@bc_id", bcid) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int Insert(users us) { string sql = "insert into Users(user_name,user_pwd) values(@User_name,@User_pwd)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@User_name", us.user_name), new SqlParameter("@User_pwd", us.user_pwd), }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//更新用户编号 public int UpdataTheme(int UserID) { string sql = "update Theme set UserID=@UserID"; SqlParameter[] sp = { new SqlParameter("@UserID", UserID) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除书单中的某一图书 public static int delete(string listbookkeepid) { string sql = "delete List_book_keep where list_book_keep_id=@list_book_keep_id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@list_book_keep_id", listbookkeepid) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除创作评论 public static int delete(string wcid) { string sql = "delete Write_Comment where wc_id=@wc_id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@wc_id", wcid) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int DeleteStore_comt(int stcomt_id) { string sql = "delete from store_comt where stcomt_id=@stcomt_id "; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@stcomt_id", stcomt_id) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除图书 public static int delete(string bookname) { string sql = "delete Book where book_name=@book_name"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@book_name", bookname) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除创作收藏 public static int delete(string writekeep) { string sql = "delete Write_Keep where wk_id=@wk_id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@wk_id", writekeep) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除用户 public static int delete(string username) { string sql = "delete Users where User_name=@user_name"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@user_name", username) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int insertDynamic(Dynamic Dyna) { string sql = "insert into Dynamic values(@DynamicID,@DyContent,@CreateTime,@UserID)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@DynamicID", Dyna.DynamicID), new SqlParameter("@DyContent", Dyna.DyContent), new SqlParameter("@CreateTime", Dyna.CreateTime), new SqlParameter("@UserID", Dyna.UserID) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
//删除创作 public static int delete(string wriname) { string sql = "delete Write where wri_name=@wri_name"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@wri_name", wriname) }; return(DBHelper.GetExcuteNonQuery(sql, sp)); }
public int DeleteShoppingCart(int ShoppingCartID) { string sql = "delete from MallItemCart where ShoppingCartID=@ShoppingCartID"; SqlParameter[] para = { new SqlParameter("@ShoppingCartID", ShoppingCartID) }; return(DBHelper.GetExcuteNonQuery(sql, para)); }