/// <summary>注册
/// 注册
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool AddUser(Login zhuce)
{
// //定义
// string sql = string.Format(@"
//
//INSERT INTO [dbo].[UserInfo]
// ([UserName]
// ,[UserPwd]
// ,[QQ]
// ,[Phone]
// ,[Address]
// ,[CreateTime])
// VALUES
// ('{0}'
// ,'{1}'
// ,'{2}'
// ,'{3}'
// ,'{4}'
// ,'{5}')
//", user.UserName, user.UserPwd, user.QQ, user.Phone, user.Address, user.CreateTime);
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@name", zhuce.YHM),
new SqlParameter("@mima", zhuce.MIMA),
new SqlParameter("@youxiang", zhuce.YouXiang),
new SqlParameter("@tupian", zhuce.Userpic),
new SqlParameter("@time", zhuce.Zhuceshijian)
};
return(DBHelper.Excute("pro_zhuce", parm));
}
/// <summary>发布菜单的数据添加
/// 发布菜单的数据添加
/// </summary>
/// <param name="caidan"></param>
/// <returns></returns>
public static bool Addfabucaidan(fabucaidan caidan)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@yuanchuang", caidan.Yuanchuang),
new SqlParameter("@biaoti", caidan.Biaoti),
new SqlParameter("@gongyi", caidan.Gongyi),
new SqlParameter("@kowei", caidan.Kowei),
new SqlParameter("@nandu", caidan.Nandu),
new SqlParameter("@zunbeishijian", caidan.Zunbeishijian),
new SqlParameter("@penrenshijian", caidan.Penrenshijian),
new SqlParameter("@renshu", caidan.Renshu),
new SqlParameter("@chengpintupian", caidan.Chengpintupian),
new SqlParameter("@fenxiangxinqin ", caidan.Fenxiangxinqin),
new SqlParameter("@zhuliaomingcheng", caidan.Zhuliaomingcheng),
new SqlParameter("@zhuliaoyongliang", caidan.Zhuliaoyongliang),
new SqlParameter("@fuliaomingcheng", caidan.Fuliaomingcheng),
new SqlParameter("@fuliaoyongliang", caidan.Fuliaoyongliang),
new SqlParameter("@buzoutupian", caidan.Buzoutupian),
new SqlParameter("@buzoumiaosu ", caidan.Buzoumiaosu),
new SqlParameter("@zuizhongxiaoguotu", caidan.Zuizhongxiaoguotu),
new SqlParameter("@fabushijian", caidan.Fabushijian),
new SqlParameter("@caiputitle", caidan.Caiputitle),
new SqlParameter("@userid", caidan.Userid),
new SqlParameter("@renqi", caidan.Renqi)
};
return(DBHelper.Excute("pro_fabucaidanADD", parm));
}
/// <summary>发布评论
///
/// </summary>
/// <param name="pl"></param>
/// <returns></returns>
public static bool tianjia(pinglun pl)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@pinglunneirong", pl.pinglunneirong),
new SqlParameter("@caipuid", pl.caipuid),
new SqlParameter("@userid", pl.userid),
new SqlParameter("@pinglunshijian", pl.pinglunshijian)
};
return(DBHelper.Excute("pro_fabupinglun_tianjia", parm));
}
public static bool tianjia(woyaozhaocaipu wycp)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@Title", wycp.Title),
new SqlParameter("@neirong", wycp.Neirong),
new SqlParameter("@fabutupian", wycp.Fabutupian),
new SqlParameter("@fabutime", wycp.Fabutime),
new SqlParameter("@useid", wycp.Useid)
};
return(DBHelper.Excute("pro_woyaozhaocaipu_tianjia", parm));
}