userdal.cs

CRM管理系统 CRM管理系统

//------------------------------------
//版权所有：杭州商易信息技术有限公司
//功能描述：用户操作类
//    作者：沈伟
//    日期：2008/08/21
//------------------------------------
using System;
using System.Data;
using System.Text;
using SystemFrameworks;

namespace Itsv.DAL.SystemManage
{
    public class UserDAL
    {
        public UserDAL()
        { }
        #region  成员方法

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string account)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from Users where account='" + account + "'");
            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            int cmdresult;
            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
            {
                cmdresult = 0;
            }
            else
            {
                cmdresult = int.Parse(obj.ToString());
            }
            if (cmdresult == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(Itsv.Model.User model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Users(");
            strSql.Append("account,name,password,inuse,departmentcode,departmentname,departmentlayer,add_account,add_user,add_date,last_access_date");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("'" + model.account + "',");
            strSql.Append("'" + model.name + "',");
            strSql.Append("'" + model.password + "',");
            if (model.inuse)
                strSql.Append("1,");
            else
                strSql.Append("0,");
            strSql.Append("'" + model.departmentcode + "',");
            strSql.Append("'" + model.departmentname + "',");
            strSql.Append("" + model.departmentlayer + ",");
            strSql.Append("'" + model.add_account + "',");
            strSql.Append("'" + model.add_user + "',");
            strSql.Append("'" + model.add_date + "',");
            strSql.Append("'" + model.last_access_date + "'");
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Itsv.Model.User model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Users set ");
            strSql.Append("account='" + model.account + "',");
            strSql.Append("name='" + model.name + "',");
            strSql.Append("inuse=");
            if (model.inuse)
                strSql.Append("1,");
            else
                strSql.Append("0,");
            strSql.Append("departmentcode='" + model.departmentcode + "',");
            strSql.Append("departmentname='" + model.departmentname + "',");
            strSql.Append("departmentlayer=" + model.departmentlayer + " ");

            strSql.Append(" where user_id=" + model.user_id + "");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 修改用户密码
        /// </summary>
        public void UpdatePassword(Itsv.Model.User model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Users set ");
            strSql.Append("password='" + model.password + "'");
            strSql.Append(" where account= '" + model.account + "'");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int user_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete Users ");
            strSql.Append(" where user_id=" + user_id);
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }
        /// <summary>
        /// 通过用户帐号得到用户信息
        /// </summary>
        public Itsv.Model.User GetModelByAccount(string account)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Users ");
            strSql.Append(" where account='" + account+"'");
            Itsv.Model.User model = new Itsv.Model.User();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            model.account = account;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
                model.name = ds.Tables[0].Rows[0]["name"].ToString();
                model.password = ds.Tables[0].Rows[0]["password"].ToString();
                if (ds.Tables[0].Rows[0]["inuse"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["inuse"].ToString() == "1") || (ds.Tables[0].Rows[0]["inuse"].ToString().ToLower() == "true"))
                    {
                        model.inuse = true;
                    }
                    else
                    {
                        model.inuse = false;
                    }
                }

                model.departmentcode = ds.Tables[0].Rows[0]["departmentcode"].ToString();
                model.departmentname = ds.Tables[0].Rows[0]["departmentname"].ToString();
                if (ds.Tables[0].Rows[0]["departmentlayer"].ToString() != "")
                {
                    model.departmentlayer = int.Parse(ds.Tables[0].Rows[0]["departmentlayer"].ToString());
                }
                model.add_account = ds.Tables[0].Rows[0]["add_account"].ToString();
                model.add_user = ds.Tables[0].Rows[0]["add_user"].ToString();
                if (ds.Tables[0].Rows[0]["add_date"].ToString() != "")
                {
                    model.add_date = DateTime.Parse(ds.Tables[0].Rows[0]["add_date"].ToString());
                }
                if (ds.Tables[0].Rows[0]["last_access_date"].ToString() != "")
                {
                    model.last_access_date = DateTime.Parse(ds.Tables[0].Rows[0]["last_access_date"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Itsv.Model.User GetModel(int user_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Users ");
            strSql.Append(" where user_id=" + user_id);
            Itsv.Model.User model = new Itsv.Model.User();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            model.user_id = user_id;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.account = ds.Tables[0].Rows[0]["account"].ToString();
                model.name = ds.Tables[0].Rows[0]["name"].ToString();
                model.password = ds.Tables[0].Rows[0]["password"].ToString();
                if (ds.Tables[0].Rows[0]["inuse"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["inuse"].ToString() == "1") || (ds.Tables[0].Rows[0]["inuse"].ToString().ToLower() == "true"))
                    {
                        model.inuse = true;
                    }
                    else
                    {
                        model.inuse = false;
                    }
                }

                model.departmentcode = ds.Tables[0].Rows[0]["departmentcode"].ToString();
                model.departmentname = ds.Tables[0].Rows[0]["departmentname"].ToString();
                if (ds.Tables[0].Rows[0]["departmentlayer"].ToString() != "")
                {
                    model.departmentlayer = int.Parse(ds.Tables[0].Rows[0]["departmentlayer"].ToString());
                }
                model.add_account = ds.Tables[0].Rows[0]["add_account"].ToString();
                model.add_user = ds.Tables[0].Rows[0]["add_user"].ToString();
                if (ds.Tables[0].Rows[0]["add_date"].ToString() != "")
                {
                    model.add_date = DateTime.Parse(ds.Tables[0].Rows[0]["add_date"].ToString());
                }
                if (ds.Tables[0].Rows[0]["last_access_date"].ToString() != "")
                {
                    model.last_access_date = DateTime.Parse(ds.Tables[0].Rows[0]["last_access_date"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Users ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 批量更新部门
        /// </summary>
        /// <param name="dept_id">部门id</param>
        /// <param name="deptCode">部门code</param>
        /// <param name="deptName">部门名称</param>
        /// <returns></returns>
        public bool UpdateDept(int dept_id,string deptCode, string deptName)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Users set ");

            strSql.Append("departmentcode='" + dept_id + "|" + deptCode + "',");
            strSql.Append("departmentname='" + deptName + "'");

            strSql.Append(" where substring(departmentcode,0,charindex('|',departmentcode))=" + dept_id +"");
            DbHelperSQL.ExecuteSql(strSql.ToString());
            return true;
        }

        /// <summary>
        /// 读取用户id
        /// </summary>
        /// <param name="account">用户名</param>
        public string GetIdByAccount(string account)
        {
            DataSet ds = this.GetList("account = '" + account + "'");
            if (ds == null)
            {
                return null;
            }

            if (ds.Tables[0].Rows.Count == 0)
            {
                return null;
            }

            return ds.Tables[0].Rows[0]["user_id"].ToString();
        }
        #endregion  成员方法
    }
}