62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
/// <summary>
///User
/// </summary>
public class User
{
public User()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 添加
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public bool InsertUser(Model User)
{
string sql = "insert into Book(Name,QQ,Message) values('" + User.Name + "','" + User.QQ + "','" + User.Message + "')";
DataBase Pn163 = new DataBase
if (Pn163.ExecuteCmd(sql) > 0)
return true;
else return false;
}
/// <summary>
/// 显示
/// </summary>
/// <returns></returns>
public DataSet DataSet()
{
DataBase Pn163 = new DataBase(); string sql = "select * from Book order by id desc";
return Pn163.GetDataSet(sql);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public bool Delete(Model User)
{
string sql = "delete from Book where id=" + User.id;
DataBase Pn163 = new DataBase(); if (Pn163.ExecuteCmd(sql) > 0)
return true;
else return false;
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
/// <summary>
///User
/// </summary>
public class User
{
DataBase Pn163 = new DataBase();
public User()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 添加
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public bool InsertUser(Model User)
{
string sql = "insert into Book(Name,QQ,Message) values('" + User.Name + "','" + User.QQ + "','" + User.Message + "')";
if (Pn163.ExecuteCmd(sql) > 0)
return true;
else return false;
}
/// <summary>
/// 显示
/// </summary>
/// <returns></returns>
public DataSet DataSet()
{
string sql = "select * from Book order by id desc";
return Pn163.GetDataSet(sql);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="User"></param>
/// <returns></returns>
public bool Delete(Model User)
{
string sql = "delete from Book where id=" + User.id;
if (Pn163.ExecuteCmd(sql) > 0)
return true;
else return false;
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
/// <summary>
///User
/// </summary>
public class User
{
private DataBase Pn163;
public User()
{
Pn163 = new DataBase();
}
......
}