using System;
using System.Collections.Generic;
using System.Text;
using M = MODEL;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
public class User
{
/// <summary>
/// 判断一个用户对象是否存在
/// </summary>
/// <param name="model">要判断的目标对象</param>
/// <returns></returns>
public bool Exists(M.User model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select Count(*) From T_User Where ");
sql.Append("U_name='" + model.U_name + "' and");
sql.Append(" U_pwd='" + model.U_pwd + "'");
int i = Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
if (i > 0)
return true;
else
/// 返回当前用户总数
/// </summary>
/// <returns></returns>
public int Count()
{
StringBuilder sql = new StringBuilder();
sql.Append("Select Count(1) From T_User");
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
}
/// <summary>
/// 返回系统中符合条件的数据行数量
/// </summary>
/// <param name="where">要查询的条件,例如 "name like '%thc%'"</param>
/// <returns></returns>
public int Count(string where)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select Count(1) From T_User");
sql.Append(" Where " + where);
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
///添加一个实体到数据库
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns></returns>
public int Add(M.User model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Insert into T_User(U_name,U_pwd) values('" + model.U_name + "','" + model.U_pwd + "')");
sql.Append(" Select @@IDENTITY");
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
/// 根据传入的实体对象更新数据库
/// </summary>
/// <param name="model">要更新的实体对象</param>
/// <returns></returns>
public bool Update(M.User model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update T_User Set ");
sql.Append("U_name='" + model.U_name + "',");
sql.Append("U_pwd='" + model.U_pwd + "' ");
sql.Append(" Where U_id=" + model.U_id);
int i = Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql.ToString()));
if (i > 0)
return true;
else
return false;
/// 删除指定的数据行
/// </summary>
/// <param name="u_id">要删除的对象ID</param>
/// <returns></returns>
public bool Delete(int u_id)
{
StringBuilder sql = new StringBuilder();
sql.Append("Delete T_User Where U_id=");
sql.Append(u_id);
int i = Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql.ToString()));
if (i > 0)
return true;
else
return false;
/// 根据条件进行删除
/// </summary>
/// <param name="where">要删除那些条件的数据行</param>
/// <param name="tf">确认删除</param>
/// <returns></returns>
public int Delete(string where, bool tf)
{
int i = 0;
StringBuilder sql = new StringBuilder();
sql.Append("Delete T_User ");
if (where.Trim() != "")
sql.Append("Where " + where);
if (tf)
{
i = Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql.ToString()));
}
return i;
/// 查询指定ID的实体
/// </summary>
/// <param name="id">要查询的实体ID</param>
/// <returns></returns>
public MODEL.User GetModel(int id)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User Where U_id=" + id);
DataSet ds = SQLHelper.GetList(sql.ToString(), "user");
MODEL.User mu = new MODEL.User();
if(ds.Tables["user"].Rows.Count>0)
{
if (ds.Tables["user"].Rows[0]["U_id"] != null)
mu.U_id = Convert.ToInt32(ds.Tables["user"].Rows[0]["U_id"]);
mu.U_name = ds.Tables["user"].Rows[0]["U_name"].ToString();
mu.U_pwd = ds.Tables["user"].Rows[0]["U_pwd"].ToString();
}
return mu;
/// 返回全部用户列表
/// </summary>
/// <returns></returns>
public DataSet GetAll()
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
return SQLHelper.GetList(sql.ToString(), "user");
/// 返回符合条件的数据行为一个DataSet
/// </summary>
/// <param name="where">要查询的条件,例如 "name like '%thc%'"</param>
/// <returns></returns>
public DataSet GetAll(string where)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
if (where.Trim() != "")
sql.Append("Where " + where);
return SQLHelper.GetList(sql.ToString(), "user");
/// 返回一个数据流
/// </summary>
/// <returns></returns>
public SqlDataReader GetReader()
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
return SQLHelper.ExecuteReader(sql.ToString());
/// 返回符合条件的数据行为一个DataReader
/// </summary>
/// <param name="where">要查询的条件,例如 "name like '%thc%'"</param>
/// <returns></returns>
public SqlDataReader GetReader(string where)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
if (where.Trim() != "")
sql.Append("Where " + where);
return SQLHelper.ExecuteReader(sql.ToString());
}
/// <summary>
/// 返回指定用户密码的账号的ID
/// </summary>
/// <returns></returns>
public int GetId(string name, string pwd)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select U_id From T_User");
sql.Append(" Where U_name='" + name + "' and U_pwd='" + pwd + "'");
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
}
}
}
using System.Collections.Generic;
using System.Text;
using M = MODEL;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
public class User
{
/// <summary>
/// 判断一个用户对象是否存在
/// </summary>
/// <param name="model">要判断的目标对象</param>
/// <returns></returns>
public bool Exists(M.User model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select Count(*) From T_User Where ");
sql.Append("U_name='" + model.U_name + "' and");
sql.Append(" U_pwd='" + model.U_pwd + "'");
int i = Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
if (i > 0)
return true;
else
return false;
}
/// 返回当前用户总数
/// </summary>
/// <returns></returns>
public int Count()
{
StringBuilder sql = new StringBuilder();
sql.Append("Select Count(1) From T_User");
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
}
/// <summary>
/// 返回系统中符合条件的数据行数量
/// </summary>
/// <param name="where">要查询的条件,例如 "name like '%thc%'"</param>
/// <returns></returns>
public int Count(string where)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select Count(1) From T_User");
sql.Append(" Where " + where);
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
}
///添加一个实体到数据库
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns></returns>
public int Add(M.User model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Insert into T_User(U_name,U_pwd) values('" + model.U_name + "','" + model.U_pwd + "')");
sql.Append(" Select @@IDENTITY");
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
}
/// 根据传入的实体对象更新数据库
/// </summary>
/// <param name="model">要更新的实体对象</param>
/// <returns></returns>
public bool Update(M.User model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update T_User Set ");
sql.Append("U_name='" + model.U_name + "',");
sql.Append("U_pwd='" + model.U_pwd + "' ");
sql.Append(" Where U_id=" + model.U_id);
int i = Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql.ToString()));
if (i > 0)
return true;
else
return false;
}
/// 删除指定的数据行
/// </summary>
/// <param name="u_id">要删除的对象ID</param>
/// <returns></returns>
public bool Delete(int u_id)
{
StringBuilder sql = new StringBuilder();
sql.Append("Delete T_User Where U_id=");
sql.Append(u_id);
int i = Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql.ToString()));
if (i > 0)
return true;
else
return false;
}
/// 根据条件进行删除
/// </summary>
/// <param name="where">要删除那些条件的数据行</param>
/// <param name="tf">确认删除</param>
/// <returns></returns>
public int Delete(string where, bool tf)
{
int i = 0;
StringBuilder sql = new StringBuilder();
sql.Append("Delete T_User ");
if (where.Trim() != "")
sql.Append("Where " + where);
if (tf)
{
i = Convert.ToInt32(SQLHelper.ExecuteNonQuery(sql.ToString()));
}
return i;
}
/// 查询指定ID的实体
/// </summary>
/// <param name="id">要查询的实体ID</param>
/// <returns></returns>
public MODEL.User GetModel(int id)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User Where U_id=" + id);
DataSet ds = SQLHelper.GetList(sql.ToString(), "user");
MODEL.User mu = new MODEL.User();
if(ds.Tables["user"].Rows.Count>0)
{
if (ds.Tables["user"].Rows[0]["U_id"] != null)
mu.U_id = Convert.ToInt32(ds.Tables["user"].Rows[0]["U_id"]);
mu.U_name = ds.Tables["user"].Rows[0]["U_name"].ToString();
mu.U_pwd = ds.Tables["user"].Rows[0]["U_pwd"].ToString();
}
return mu;
}
/// 返回全部用户列表
/// </summary>
/// <returns></returns>
public DataSet GetAll()
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
return SQLHelper.GetList(sql.ToString(), "user");
}
/// 返回符合条件的数据行为一个DataSet
/// </summary>
/// <param name="where">要查询的条件,例如 "name like '%thc%'"</param>
/// <returns></returns>
public DataSet GetAll(string where)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
if (where.Trim() != "")
sql.Append("Where " + where);
return SQLHelper.GetList(sql.ToString(), "user");
}
/// 返回一个数据流
/// </summary>
/// <returns></returns>
public SqlDataReader GetReader()
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
return SQLHelper.ExecuteReader(sql.ToString());
}
/// 返回符合条件的数据行为一个DataReader
/// </summary>
/// <param name="where">要查询的条件,例如 "name like '%thc%'"</param>
/// <returns></returns>
public SqlDataReader GetReader(string where)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select * From T_User");
if (where.Trim() != "")
sql.Append("Where " + where);
return SQLHelper.ExecuteReader(sql.ToString());
}
/// <summary>
/// 返回指定用户密码的账号的ID
/// </summary>
/// <returns></returns>
public int GetId(string name, string pwd)
{
StringBuilder sql = new StringBuilder();
sql.Append("Select U_id From T_User");
sql.Append(" Where U_name='" + name + "' and U_pwd='" + pwd + "'");
return Convert.ToInt32(SQLHelper.ExecuteScalar(sql.ToString()));
}
}
}