public static bool AddCollect(Tab_collect collect)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_emaile", collect.U_emaile),
new SqlParameter("@u_collect", collect.U_collect),
new SqlParameter("@t_content", collect.T_content),
new SqlParameter("@UploadTime", collect.UploadTime)
};
int i = SQLHelper.ExecuteNonQuery("AddCollect", CommandType.StoredProcedure, p);
return(i > 0);
}
public static Tab_collect GetCollectById(int u_id)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@u_id", u_id)
};
SqlDataReader dr = SQLHelper.ExecuteReader("GetCollectById", CommandType.StoredProcedure, p);
Tab_collect tab_collect = new Tab_collect();
if (dr.Read())
{
tab_collect.U_id = Convert.ToInt32(dr["u_id"]);
tab_collect.U_emaile = Convert.ToString(dr["u_emaile"]);
tab_collect.U_emaile = Convert.ToString(dr["u_collect"]);
tab_collect.T_content = Convert.ToString(dr["t_content"]);
}
return(tab_collect);
}
/// <summary>
/// 添加收藏
/// </summary>
/// <param name="collect"></param>
/// <returns></returns>
public static bool AddCollect(Tab_collect collect)
{
return(DAL.CollectAccess.AddCollect(collect));
}
