/// <summary>
/// 增加一条管理员信息
/// </summary>
/// <param name="manager"></param>
/// <returns></returns>
public int AddManager(Manager manager)
{
int result = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into T_Sys_Manager(");
strSql.Append(" RoleId,DeptId,UserName,UserPwd,UserSalt,RealName,Tel,IsLock,Level,AddTime)");
strSql.Append(" values (");
strSql.Append(" @RoleId,@DeptId,@UserName,@UserPwd,@UserSalt,@RealName,@Tel,@IsLock,@Level,@AddTime)");
strSql.Append(" ;select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@RoleId", SqlDbType.Int,4),
new SqlParameter("@DeptId", SqlDbType.Int,4),
new SqlParameter("@UserName", SqlDbType.NVarChar,50),
new SqlParameter("@UserPwd", SqlDbType.NVarChar,100),
new SqlParameter("@UserSalt", SqlDbType.NVarChar,20),
new SqlParameter("@RealName", SqlDbType.NVarChar,100),
new SqlParameter("@Tel", SqlDbType.NVarChar,20),
new SqlParameter("@IsLock", SqlDbType.Int,2),
new SqlParameter("@Level", SqlDbType.Int,2),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = manager.RoleId;
parameters[1].Value = manager.DeptId;
parameters[2].Value = manager.UserName;
parameters[3].Value = manager.UserPwd;
parameters[4].Value = manager.UserSalt;
parameters[5].Value = manager.RealName;
parameters[6].Value = manager.Tel;
parameters[7].Value = manager.IsLock;
parameters[8].Value = manager.Level;
parameters[9].Value = manager.AddTime;
object obj = SqlHelper.ExecuteScalar(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters);
if (obj != null)
{
result = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_Manager//AddManager" + e.Message); //发生异常，记录
}
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CheckAdminLevel("DrugManager"); //判断操作权限
manager = GetAdminInfo();
action = DTRequest.GetQueryString("action");
BindData(action);
if (action == "edit")
{
this.txtDrugName.Enabled = false; //药品名 不能更改
BindDrug(int.Parse(DTRequest.GetQueryString("id")));
}
}
}
/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
this.keywords = DTRequest.GetQueryString("keywords");
this.pageSize = GetPageSize(10); //默认每页显示十条数据
if (!IsPostBack)
{
CheckAdminLevel("BossQuery");//判断操作权限
manager = GetAdminInfo();
listDept = BLL_Department.GetDepartmentList(" TypeId=4 or TypeId=2 or TypeId=5 or TypeId=6 "); //获取，药店 乡镇 救助类别 患者类别 信息
BindDept(); //绑定下拉列表
BindData(this.keywords);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.keywords = DTRequest.GetQueryString("keywords");
this.pageSize = GetPageSize(10); //默认每页显示十条数据
if (!IsPostBack)
{
CheckAdminLevel("Civil");//判断操作权限
manager = GetAdminInfo();
listDept = BLL_Department.GetDepartmentList(" TypeId=1 or TypeId=3 or TypeId=4 "); //获取，医院 诊所 药店的部门信息
BindData(this.keywords);
}
}
/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
//分页使用
this.keywords = DTRequest.GetQueryString("keywords");
int.TryParse(DTRequest.GetQueryString("homeId"), out homeId);
int.TryParse(DTRequest.GetQueryString("helpClass"), out helpClass);
int.TryParse(DTRequest.GetQueryString("patientClass"), out patientClass);
int.TryParse(DTRequest.GetQueryString("typeId"), out typeId);
this.pageSize = GetPageSize(10); //默认每页显示十条数据
if (!IsPostBack)
{
CheckAdminLevel("Hospital");//判断操作权限
manager = GetAdminInfo();
listDept = BLL_Department.GetDepartmentList(" TypeId=6 or TypeId=5 or TypeId=2 "); //获取，救助类别 患者类别 乡镇 的部门数据
BindDept(); //绑定下拉列表
BindData(this.keywords);
}
}
/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
this.keywords = DTRequest.GetQueryString("keywords");
this.pageSize = GetPageSize(10); //默认每页显示十条数据
listDept = BLL_Department.GetDepartmentList(" TypeId=4 ");//找出所有的药店
if (!IsPostBack)
{
CheckAdminLevel("DrugManager"); //判断操作权限
manager = GetAdminInfo();
BindDpet();
BindData(this.keywords);
}
}
/// <summary>
/// 管理 管理员 添加 or 修改
/// </summary>
/// <param name="type">edit add</param>
/// <returns></returns>
private bool AdminManager(string type)
{
var manager = new Med_Model.Manager();
CheckTheData(ref manager); //检查数据合法性
if (type == "add")
{
//如果添加管理员成功 同时成功记录操作日志的话 返回true
return (BLL_Manager.AddManager(manager) > 0) && (AddSysLog(CommonEnum.ActionType.Add.ToString(), "添加管理员") ? true : false);
}
if (type == "edit" || type == "ChangePwd")
{
//如果更新管理员信息成功，同时添加日志成功 返回true 否则返回false 更改密码后 下一次登录有效
return (BLL_Manager.UpdateManager(manager)) && (AddSysLog(CommonEnum.ActionType.Update.ToString(), "修改管理员信息") ? true : false);
}
return false; //目前只有添加 修改两种操作，以后可能扩展
}
private static readonly DAL_Manager DalManager = new DAL_Manager(); //实例化
#endregion Fields
#region Methods
/// <summary>
/// 增加一条管理员信息
/// </summary>
/// <param name="manager">管理员实体</param>
/// <returns></returns>
public static int AddManager(Manager manager)
{
return DalManager.AddManager(manager);
}
/// <summary>
/// 更新一条管理员记录信息
/// </summary>
/// <param name="manager"></param>
/// <returns>
/// 成功：true
/// 失败：false
/// </returns>
public static bool UpdateManager(Manager manager)
{
return DalManager.UpdateManager(manager);
}
/// <summary>
/// 更新一条管理员记录信息
/// </summary>
/// <param name="manager"></param>
/// <returns>
/// 成功：true
/// 失败：false
/// </returns>
public bool UpdateManager(Manager manager)
{
bool result = false;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update T_Sys_Manager set");
strSql.Append(" RoleId=@RoleId,");
strSql.Append(" DeptId=@DeptId,");
strSql.Append(" UserPwd=@UserPwd,");
strSql.Append(" UserSalt=@UserSalt,");
strSql.Append(" RealName=@RealName,");
strSql.Append(" Tel=@Tel,");
strSql.Append(" IsLock=@IsLock,");
strSql.Append(" Level=@Level,");
strSql.Append(" AddTime=@AddTime");
strSql.Append(" where UserName=@UserName");
SqlParameter[] parameters = {
new SqlParameter("@RoleId", SqlDbType.Int,4),
new SqlParameter("@DeptId", SqlDbType.Int,4),
new SqlParameter("@UserPwd", SqlDbType.NVarChar,100),
new SqlParameter("@UserSalt", SqlDbType.NVarChar,20),
new SqlParameter("@RealName", SqlDbType.NVarChar,100),
new SqlParameter("@Tel", SqlDbType.NVarChar,20),
new SqlParameter("@IsLock", SqlDbType.Int,2),
new SqlParameter("@Level", SqlDbType.Int,2),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UserName", SqlDbType.NVarChar,50)
};
parameters[0].Value = manager.RoleId;
parameters[1].Value = manager.DeptId;
parameters[2].Value = manager.UserPwd;
parameters[3].Value = manager.UserSalt;
parameters[4].Value = manager.RealName;
parameters[5].Value = manager.Tel;
parameters[6].Value = manager.IsLock;
parameters[7].Value = manager.Level;
parameters[8].Value = manager.AddTime;
parameters[9].Value = manager.UserName;
if (SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters) > 0) //更改成功 影响条数为1
{
result = true; //更新成功设置为true
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_Manager//UpdateManager" + e.Message); //发生异常，记录
}
return result;
}
/// <summary>
/// 根据真实姓名或者用户名得到管理员实体信息
/// </summary>
/// <param name="Name">姓名或者用户名</param>
/// <param name="typeId">
/// 0：用户名
/// 1：真实姓名
/// </param>
/// <returns></returns>
public Manager SelectManagerByName(string Name, int typeId = 0)
{
Manager manager = new Manager();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select top 1 Id,RoleId,DeptId,UserName,UserName,UserPwd,UserSalt,RealName,Tel,IsLock,Level,AddTime from T_Sys_Manager");
if (typeId == 1)
strSql.Append(" where RealName=@Name");
strSql.Append(" where UserName=@Name");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,50)};
parameters[0].Value = Name;
// manager = LoadEntity(SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters).Tables[0]);
manager = SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.StoredProcedure, "sp_divpage", parameters).Tables[0].ToList<Manager>()[0]; //当前List<> 中只有一条记录，用这种方式得到
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_Manager//SelectManagerByName" + e.Message); //发生异常，记录
}
return manager;
}
/// <summary>
/// 根据管理员编号找到相应管理员信息
/// </summary>
/// <param name="id">管理员编号</param>
/// <returns></returns>
public Manager SelectManagerById(int id)
{
Manager manager = new Manager();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select top 1 Id,RoleId,DeptId,UserName,UserName,UserPwd,UserSalt,RealName,Tel,IsLock,Level,AddTime from T_Sys_Manager");
strSql.Append(" where Id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int)};
parameters[0].Value = id;
// manager = LoadEntity(SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters).Tables[0]);
manager = SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters).Tables[0].ToList<Manager>()[0];//当前List<> 中只有一条记录，用这种方式得到
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_Manager//SelectManagerByName" + e.Message); //发生异常，记录
}
return manager;
}
/// <summary>
/// 根据用户名密码返回一个实体
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="userPwd">密码</param>
/// <returns></returns>
public Manager GetManager(string userName, string userPwd)
{
string salt = this.GetSaltByUserName(userName);
if (string.IsNullOrEmpty(salt))
{
return null;
}
Manager manager = new Manager();
//把明文进行加密重新赋值
userPwd = DESEncrypt.Encrypt(userPwd, salt);
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,RoleId,DeptId,UserName,UserPwd,UserSalt,RealName,Tel,IsLock,Level,AddTime from T_Sys_Manager");
strSql.Append(" where UserName=@UserName and UserPwd=@UserPwd ");
SqlParameter[] parameters = {
new SqlParameter("@UserName", SqlDbType.NVarChar,50),
new SqlParameter("@UserPwd", SqlDbType.NVarChar,50)};
parameters[0].Value = userName;
parameters[1].Value = userPwd;
manager = SqlHelper.ExecuteDataset(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters).Tables[0].ToModel<Manager>();
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_Manager//GetManager" + e.Message); //发生异常，记录
}
return manager;
}
