using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Youzi.Model;
using Youzi.DBUtility;

namespace Youzi.DAL
{
    public class UsersDAL
    {
        public DataSet SelectAll()
        {
            string sql = "select * from View_Users";
            return SQLHelper.SelectAll(sql);
        }

        public SqlDataReader Select(UsersInfo entity)
        {
            string sql = "select * from Users where UserID='"+entity.UserID+"'and UserPass='"+entity.UserPass+"'";
            return SQLHelper.ExecuteDataQuery(sql);
        }


        public DataSet  SelectGrade(UsersInfo entity)
        {
            string sql = "select UserPurview from Users where UserID='" + entity.UserID + "'and UserPass='" + entity.UserPass + "'";
            return SQLHelper.Select(sql);
        }
        public int Delete(int id)
        {
            string sql = "delete from Users where UserID=" + id;
            return SQLHelper.ExecuteNonQuery(sql);
        }

        public int Insert(UsersInfo entity)
        {
            string sql = "insert into Users values('" + entity.UserName + "','" + entity.UserPass + "','" + entity.UserPurview + "','" + entity.OperateDate + "','admin')";
            return SQLHelper.ExecuteNonQuery(sql);
        }

        public int UpdatePwd(UsersInfo entity)
        {
            string sql = "update Users set UserPass='" + entity.UserPass + "'where UserID='" + entity.UserID + "'";
            return SQLHelper.ExecuteNonQuery(sql);
        }

        public int Update(UsersInfo entity)
        {
            string sql = "update Users set UserName='" + entity.UserName + "',UserPass='" + entity.UserPass + "',UserPurview='" + entity.UserPurview + "',OperateDate='" + entity.OperateDate + "',Operator='" + entity.Operator + "'where UserID=" + entity.UserID;
            return SQLHelper.ExecuteNonQuery(sql);
        }
    }
}