//删除
public static int delete(ModelSproduct sproduct)
{
SqlParameter[] parter = new SqlParameter[]
{
new SqlParameter("Sproductid", sproduct.Sproductid)
};
return(DBhelp.NotqueryProc("Sproduct_del", parter));
}
/// <summary>
/// 删除公告 删除数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int NoticeDel(ModelNotice model)
{
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@NoticeID", model.NoticeID),
};
return(DBhelp.NotqueryProc("NoticeDel", sqlpar));
}
/// <summary>
/// 修改用户状态
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UsersStateupdate(ModelUsers model)
{
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@UsersState", model.usersState),
new SqlParameter("@Userid", model.Userid),
};
return(DBhelp.NotqueryProc("UsersStateupdate", sqlpar));
}
//修改
public static int update(ModelSproduct sproduct)
{
SqlParameter[] parter = new SqlParameter[]
{
new SqlParameter("Sproductcontent", sproduct.Sproductcontent),
new SqlParameter("Sproductprice", sproduct.Sproductprice)
};
return(DBhelp.NotqueryProc("Sproduct_upt", parter));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int NoticeInsert(ModelNotice model)
{
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@NoticeTitle", model.NoticeTitle),
new SqlParameter("@NoticeContent", model.NoticeContent),
};
return(DBhelp.NotqueryProc("NoticeInsert", sqlpar));
}
/// <summary>
/// 修改级别
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int ApproveUpdate(ModelApprove model)
{
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@ApproveID", model.ApproveID),
new SqlParameter("@ApproveLevel", model.ApproveLevel),
new SqlParameter("@Userid", model.Userid),
};
return(DBhelp.NotqueryProc("ApproveUpdate", sqlpar));
}
//添加
public static int insert(ModelSproduct sproduct)
{
SqlParameter[] parter = new SqlParameter[]
{
new SqlParameter("Sproductname", sproduct.Sproductname),
new SqlParameter("Sproductcontent", sproduct.Sproductcontent),
new SqlParameter("Sproductprice", sproduct.Sproductprice),
new SqlParameter("Sproductimg", sproduct.Sproductimg)
};
return(DBhelp.NotqueryProc("Sproduct_ins", parter));
}