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