sysuser.cs

某个公司需要维持良好的客户关系

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using CRM.IDAL;
using CRM.Model;

namespace CRM.SQLServerDAL
{
	/// <summary>
	/// SysUser 的摘要说明。
	/// </summary>
	public class SysUser : ISysUser
	{
		#region ISysUser 成员

		public void Insert(SysUserInfo user,string roleid)
		{
			string userid= Common.GetNextIdByTable("SysUserInfo","UserId","SingleLayer",null,10);
			object[] parms = {
								 userid,
								 user.LoginName,
								 Common.Encrypt(user.LoginPwd),
								 user.TrueName,
								 user.Sex,
								 user.Birthday,
								 user.Address,
								 user.Phone,
								 user.MobilePhone,
								 user.PostCode,
								 user.Email,
								 user.BZ
							 };
			DAI.RunProcNonQuery("CRM_SysUser_Insert",parms);
			DAI.RunProcNonQuery("CRM_SysUser_UserRoleInsert",userid,roleid);
		}
		
		public void InsertCustomer(string userid,string customerId)
		{
			DAI.RunProcNonQuery("CRM_SysUser_UserCustomerInsert",userid,customerId);
		}
		public DataTable GetAllSysUser()
		{
			return DAI.RunProcTable("CRM_SysUser_GetAllSysUser");
		}
		public  DataTable GetUserFuncById(string userid)
		{
			return DAI.RunProcTable("CRM_SysUser_GetUserFuncById",userid);
		}
		public SysUserInfo GetSysUserById(string userId)
		{
			SysUserInfo user = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysUser_GetSysUserById",userId))
			{
				if (rdr.Read())
				{
					user = new SysUserInfo();

					user.UserId = rdr["UserId"].ToString();
					user.LoginName = rdr["LoginName"].ToString();
					user.LoginPwd = Common.Encrypt(rdr["LoginPwd"].ToString());
					user.TrueName = rdr["TrueName"].ToString();
					user.Sex = rdr["Sex"].ToString();
					user.Birthday = rdr["Birthday"].ToString();
					user.Address = rdr["Address"].ToString();
					user.Phone = rdr["Address"].ToString();
					user.MobilePhone = rdr["MobilePhone"].ToString();
					user.PostCode = rdr["PostCode"].ToString();
					user.Email = rdr["Email"].ToString();
					user.BZ = rdr["BZ"].ToString();
				}
			}
			return user;
		}

		public void Delete(string userId)
		{
			DAI.RunProcNonQuery("CRM_SysUser_Delete",userId);
		}

		public void Update(SysUserInfo user,string roleid)
		{
			object[] parms = {
								 user.UserId,
								 user.LoginName,
								 Common.Encrypt(user.LoginPwd),
								 user.TrueName,
								 user.Sex,
								 user.Birthday,
								 user.Address,
								 user.Phone,
								 user.MobilePhone,
								 user.PostCode,
								 user.Email,
								 user.BZ
							 };
			DAI.RunProcNonQuery("CRM_SysUser_Update",parms);
			DAI.RunProcNonQuery("CRM_SysUser_UserRoleInsert",user.UserId,roleid);
		}
		public void Update(SysUserInfo user)
		{
			object[] parms = {
								 user.UserId,
								 user.LoginName,
								 Common.Encrypt(user.LoginPwd),
								 user.TrueName,
								 user.Sex,
								 user.Birthday,
								 user.Address,
								 user.Phone,
								 user.MobilePhone,
								 user.PostCode,
								 user.Email,
								 user.BZ
							 };
			DAI.RunProcNonQuery("CRM_SysUser_Update",parms);
		}
		public bool UpdatePWD(string userid,string oldpwd,string newpwd)
		{
			object[] parms = {
								 userid,
								 Common.Encrypt(oldpwd),
								 Common.Encrypt(newpwd)
							 };
			return (DAI.RunProcNonQuery("CRM_SysUser_UpdatePWD",parms)>0 ? true:false);
		}	

		public CRM.Model.SysUserInfo UserLoginCheck(string loginname,string loginpwd )
		{
			SysUserInfo user = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysUser_UserLoginCheck",loginname,Common.Encrypt(loginpwd)))
			{
				if (rdr.Read())
				{
					user = new SysUserInfo();

					user.UserId = rdr["UserId"].ToString();
					user.LoginName = rdr["LoginName"].ToString();
					user.LoginPwd = Common.Encrypt(rdr["LoginPwd"].ToString().Trim());
					user.TrueName = rdr["TrueName"].ToString();
					user.Sex = rdr["Sex"].ToString();
					user.Birthday = rdr["Birthday"].ToString();
					user.Address = rdr["Address"].ToString();
					user.Phone = rdr["Address"].ToString();
					user.MobilePhone = rdr["MobilePhone"].ToString();
					user.PostCode = rdr["PostCode"].ToString();
					user.Email = rdr["Email"].ToString();
					user.BZ = rdr["BZ"].ToString();
				}
			}
			return user;
		}


		public DataTable GetUserPowerById(string userid)
		{
			return DAI.RunProcTable("CRM_SysUser_GetUserPowerById",userid);
		}
		public SysRoleInfo GetUserRoleById(string userid)
		{
			SysRoleInfo role = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysUser_GetUserRoleById",userid))
			{
				if (rdr.Read())
				{
					role = new SysRoleInfo();
					role.RoleId = rdr["RoleId"].ToString();
				}
			}
			return role;
		}
		public DataTable GetCustomerByUserId(string userid)
		{
			return DAI.RunProcTable("CRM_SysUser_GetCustomerByUserId",userid);
		}
		public DataTable GetEmployee()
		{
			return DAI.RunProcTable("CRM_SysUser_GetEmployee");
		}
		public void  CustomerChange(string userid1,string userid2)
		{
			DAI.RunProcNonQuery("CRM_SysUser_CustomerChange",userid1,userid2);
		}
		#endregion
	}
}