protected void GetUser(int id)
{
BLL.BASE_USERGROUP ugbll = new BLL.BASE_USERGROUP();
DataView dvList = new DataView(ugbll.GetUserGroupList("").Tables[0]);
LoadGroupList("0", 0, dvList);
BLL.BASE_USER bll = new BLL.BASE_USER();
Entity.BASE_USER model = new Entity.BASE_USER();
model = bll.GetUserModel(id);
uid.Text = id.ToString();
txt_name.Text = model.UserName;
GroupList.SelectedValue = model.UserGroup.ToString();
txt_email.Text = model.Email;
StateList.SelectedValue = model.Status.ToString();
Lab_time1.Text = model.CreateTime.ToString("yyyy-MM-dd HH:mm:ss");
ArrayList rid = model.RoleID;
for (int i = 0; i < rid.Count; i++)
{
string[] r = rid[i].ToString().Split(',');
RoleList.Items.Add(new ListItem(r[1], r[0]));
}
//string stime = model.LastLoginTime.ToString("yyyy-MM-dd HH:mm:ss");
//if (stime != "0001-01-01 00:00:00")
//{
// Lab_time2.Text = stime;
//}
}
public Entity.BASE_USER GetUser(string username, string pwd)
{
Entity.BASE_USER model = new Entity.BASE_USER();
var dt = dal.GetList(string.Format("USERNAME='******' AND USERPWD='{1}'",
username,
pwd)).Tables[0];
if (dt != null && dt.Rows.Count != 0)
{
model.BIRTHDAY = (DateTime)dt.Rows[0]["BIRTHDAY"];
model.DEGREE = dt.Rows[0]["DEGREE"].ToString();
model.DEPTID = Convert.ToInt32(dt.Rows[0]["DEPTID"].ToString());
model.FACE = dt.Rows[0]["FACE"].ToString();
model.IDNUMBER = dt.Rows[0]["IDNUMBER"].ToString();
model.JOBNUMBER = dt.Rows[0]["JOBNUMBER"].ToString();
model.PARENTID = Convert.ToInt32(dt.Rows[0]["PARENTID"].ToString());
model.PHONE = dt.Rows[0]["PHONE"].ToString();
model.PHOTO = dt.Rows[0]["PHOTO"].ToString();
model.PROF = dt.Rows[0]["PROF"].ToString();
model.REMARK = dt.Rows[0]["REMARK"].ToString();
model.SEX = Convert.ToInt32(dt.Rows[0]["SEX"].ToString());
model.STSTUS = Convert.ToInt32(dt.Rows[0]["STSTUS"].ToString());
model.USERID = Convert.ToInt32(dt.Rows[0]["USERID"].ToString());
model.USERNAME = dt.Rows[0]["USERNAME"].ToString();
model.USERPWD = dt.Rows[0]["USERPWD"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 创建一个新用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateUser(Entity.BASE_USER model)
{
int ret = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_User(");
strSql.Append("UserName,Password,Email,UserGroup,CreateTime,IsLimit)");
strSql.Append(" values (");
strSql.Append("@UserName,@Password,@Email,@UserGroup,@CreateTime,@IsLimit)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 128),
new SqlParameter("@Password", SqlDbType.NVarChar, 128),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@UserGroup", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IsLimit", SqlDbType.Bit, 1)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Password;
parameters[2].Value = model.Email;
parameters[3].Value = model.UserGroup;
parameters[4].Value = DateTime.Now;
parameters[5].Value = model.IsLimit;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
ret = int.Parse(obj.ToString());
}
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string _action = Request.QueryString["action"];
string _deptName = Request.QueryString["deptname"];
string _deptId = Request.QueryString["deptid"];
switch (_action)
{
case "add":
this.LabName.Text = "添加单位用户信息";
ViewState["action"] = "ADD";
txtUnit.Text = _deptName;
hfdUnitId.Value = _deptId;
break;
case "update":
this.LabName.Text = "编辑单位用户信息";
ViewState["action"] = "EDIT";
string _userId = Request.QueryString["userid"];
txtUnit.Text = new BASE_DEPT().GetEntity(decimal.Parse(_deptId)).DPTNAME;
hfdUnitId.Value = _deptId;
int userid = Convert.ToInt32(_userId);
ViewState["USERID"] = userid.ToString();
Entity.BASE_USER model = bll.GetUser(userid);
SetEntity(model);
break;
}
}
}
/// <summary>
/// 初始化信息实体
/// </summary>
/// <returns></returns>
private Entity.BASE_USER GetEntity()
{
Entity.BASE_USER model = new Entity.BASE_USER();
#region 需要字段
//model.USERID = Convert.ToDecimal(this.hidPrimary.Value); //主键，用户ID编号
//model.BIRTHDAY = DateTime.Parse(txtBIRTHDAY.Text);
//model.DEGREE = txtDEGREE.Text;
//DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment");//找到用户控件中的子控件
//model.FACE = txtFACE.Text; //政治面貌
//model.IDNUMBER = txtIDNUMBER.Text; //身份证号码
//model.PROF = txtPROF.Text; //专业
//model.SEX = Convert.ToInt32(ddlSex.SelectedValue); //性别
//model.PHOTO = this.fileupPhoto.FileName; //人员照片
#endregion
model.DEPTID = Convert.ToInt32(hfdUnitId.Value);
model.JOBNUMBER = txtJOBNUMBER.Text; //工作证号
model.PHONE = txtPhone.Text; //联系电话
model.REMARK = txtRemark.Text; //备注
model.USERNAME = txtUserName.Text; //用户账号
model.USERPWD = Smart.Security.Encrypter.Encrypt(txtPassword.Text, ConfigurationManager.AppSettings["EncryptKey"]); //用户密码
model.STSTUS = 0; //状态
model.PARENTID = 0; //用户父ID编号（用于多个子账户）
model.REALNAME = this.TxtRealName.Text; //真实姓名
return(model);
}
/// <summary>
/// 创建一个新用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateUser(Entity.BASE_USER model)
{
if (!UserExists(model.UserName))
{
return(dal.CreateUser(model));
}
else
{
return(2);
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private void Updatestate(int id)
{
Entity.BASE_USER model = bll.GetUser(id);
model.STSTUS = 1;
if (bll.Update(model))
{
AjaxAlert(this.UpdatePanel1, "删除成功！");
}
else
{
AjaxAlert(this.UpdatePanel1, "删除失败！");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_USER entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_User(");
strSql.Append("UserName,Password,Email,Question,Answer,RoleID,UserGroup,CreateTime,LastLoginTime,Status,IsOnline,IsLimit");
strSql.Append(") values (");
strSql.Append("@UserName,@Password,@Email,@Question,@Answer,@RoleID,@UserGroup,@CreateTime,@LastLoginTime,@Status,@IsOnline,@IsLimit");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 128),
new SqlParameter("@Password", SqlDbType.NVarChar, 128),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@Question", SqlDbType.NVarChar, 100),
new SqlParameter("@Answer", SqlDbType.NVarChar, 100),
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@UserGroup", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@IsOnline", SqlDbType.Bit, 1),
new SqlParameter("@IsLimit", SqlDbType.Bit, 1)
};
parameters[0].Value = entity.UserName;
parameters[1].Value = entity.Password;
parameters[2].Value = entity.Email;
parameters[3].Value = entity.Question;
parameters[4].Value = entity.Answer;
parameters[5].Value = entity.RoleID;
parameters[6].Value = entity.UserGroup;
parameters[7].Value = entity.CreateTime;
parameters[8].Value = entity.LastLoginTime;
parameters[9].Value = entity.Status;
parameters[10].Value = entity.IsOnline;
parameters[11].Value = entity.IsLimit;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 按钮事件：提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (CheckUserSubmitFrom())
{
string _action = ViewState["action"].ToString();
if (_action == "ADD") //添加用户
{
Entity.BASE_USER model = GetEntity();
//model.PHOTO = UpLoadPhoto();
bll.Add(model);
//日志添加
LogAdd("用户管理", "添加用户");
//重新加载当前页
//Response.Redirect(Request.Url.AbsoluteUri, true);
//添加完成后页面跳转
AjaxAlertAndRedirect(UpdatePanel1, "用户信息添加成功", "UserCenter.aspx?deptid=" + hfdUnitId.Value + "&deptName=" + txtUnit.Text);
}
else //修改用户
{
Entity.BASE_USER model = GetEntity();
model.USERID = Convert.ToInt32(ViewState["USERID"].ToString());
//model.PHOTO = UpLoadPhoto();
if (bll.Update(model))
{
//日志添加
LogAdd("用户管理", "修改用户");
//重新加载当前页
//Response.Redirect(Request.Url.AbsoluteUri, true);
//添加完成后页面跳转
AjaxAlertAndRedirect(UpdatePanel1, "用户信息修改成功", "UserCenter.aspx?deptid=" + hfdUnitId.Value + "&deptName=" + txtUnit.Text);
}
else
{
AjaxAlert(this.UpdatePanel1, "用户信息修改失败");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
userSession = (Utility.UserSession)Session["user"];
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
Entity.BASE_MESSAGE m = new Entity.BASE_MESSAGE();
m = bll.GetEntity(id);
Entity.BASE_USER userModel = new Entity.BASE_USER();
userModel = bllUser.GetUser(Convert.ToInt32(m.SENDER));
txtAccept.Text = userModel.USERNAME;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_USER(");
strSql.Append("IDNUMBER,JOBNUMBER,PHOTO,PROF,REMARK,STSTUS,PHONE,USERNAME,USERPWD,PARENTID,SEX,DEPTID,BIRTHDAY,DEGREE,FACE,REALNAME");
strSql.Append(") values (");
strSql.Append(":IDNUMBER,:JOBNUMBER,:PHOTO,:PROF,:REMARK,:STSTUS,:PHONE,:USERNAME,:USERPWD,:PARENTID,:SEX,:DEPTID,:BIRTHDAY,:DEGREE,:FACE,:REALNAME");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":IDNUMBER", OracleType.VarChar, 18),
new OracleParameter(":JOBNUMBER", OracleType.VarChar, 50),
new OracleParameter(":PHOTO", OracleType.VarChar, 200),
new OracleParameter(":PROF", OracleType.VarChar, 50),
new OracleParameter(":REMARK", OracleType.VarChar, 50),
new OracleParameter(":STSTUS", OracleType.Number, 4),
new OracleParameter(":PHONE", OracleType.VarChar, 50),
new OracleParameter(":USERNAME", OracleType.VarChar, 50),
new OracleParameter(":USERPWD", OracleType.VarChar, 32),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":SEX", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":BIRTHDAY", OracleType.DateTime),
new OracleParameter(":DEGREE", OracleType.VarChar, 50),
new OracleParameter(":FACE", OracleType.VarChar, 50),
new OracleParameter(":REALNAME", OracleType.VarChar, 50)
};
parameters[0].Value = model.IDNUMBER;
parameters[1].Value = model.JOBNUMBER;
parameters[2].Value = model.PHOTO;
parameters[3].Value = model.PROF;
parameters[4].Value = model.REMARK;
parameters[5].Value = model.STSTUS;
parameters[6].Value = model.PHONE;
parameters[7].Value = model.USERNAME;
parameters[8].Value = model.USERPWD;
parameters[9].Value = model.PARENTID;
parameters[10].Value = model.SEX;
parameters[11].Value = model.DEPTID;
parameters[12].Value = model.BIRTHDAY;
parameters[13].Value = model.DEGREE;
parameters[14].Value = model.FACE;
parameters[15].Value = model.REALNAME;
return(OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
protected void btnSend_Click(object sender, EventArgs e)
{
litmsg.Visible = false;
if (!CheckInput())
{
return;
}
//split 接收者
string[] acceptUser = txtAccept.Text.Split(',');
//发送
for (int i = 0; i < acceptUser.Length; i++)
{
Entity.BASE_MESSAGE m = new Entity.BASE_MESSAGE();
m.MESSAGEBODY = txtContent.Text.Trim();
m.SENDDATE = DateTime.Now;
m.SENDER = userSession.USERID;
m.STATE = 0;
//根据用户ID获取Model
Entity.BASE_USER userModel = new Entity.BASE_USER();
userModel = bllUser.GetUser(acceptUser[i].ToString());
m.TOUSER = userModel.USERID; //接收者
bll.Add(m);
//短信提醒
if (chkSMSAlert.Checked)
{
string smsContent = "";
if (txtContent.Text.Length > 70)
{
smsContent = txtContent.Text.Substring(0, 65) + "...";
}
Smart.Sms.SendSms.Send1086Com(userModel.PHONE, smsContent);
}
}
//提示发送成功
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>消息发送成功!</div>";
txtAccept.Focus();
txtAccept.Text = "";
txtContent.Text = "";
chkSMSAlert.Checked = false;
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
private void SetEntity(Entity.BASE_USER model)
{
#region 多余字段
//txtBIRTHDAY.Text = model.BIRTHDAY.ToString("yyyy-MM-dd");
//txtDEGREE.Text = model.DEGREE;
//txtFACE.Text = model.FACE;
//txtIDNUMBER.Text = model.IDNUMBER;
//txtPROF.Text = model.PROF;
#endregion
this.hidPrimary.Value = model.USERID.ToString();
txtJOBNUMBER.Text = model.JOBNUMBER;
txtPhone.Text = model.PHONE;
txtRemark.Text = model.REMARK;
txtUserName.Text = model.USERNAME;
txtPassword.Text = Smart.Security.Encrypter.Decrypt(model.USERPWD, ConfigurationManager.AppSettings["EncryptKey"]);
TxtRealName.Text = model.REALNAME;
}
/// <summary>
/// 更新用户基本信息
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public int UpdateUser(Entity.BASE_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_User set UserName=@UserName,UserGroup=@UserGroup,Email=@Email,Status=@Status where UserID=@UserID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 128),
new SqlParameter("@UserGroup", SqlDbType.Int, 4),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserGroup;
parameters[3].Value = model.Email;
parameters[4].Value = model.Status;
return(SqlServerHelper.ExecuteSql(strSql.ToString(), parameters));
}
protected void Btn_ok_Click(object sender, EventArgs e)
{
BLL.BASE_USER bll = new BLL.BASE_USER();
Entity.BASE_USER model = new Entity.BASE_USER();
model.UserID = int.Parse(uid.Text);
model.UserName = txt_name.Text;
model.UserGroup = int.Parse(GroupList.SelectedItem.Value);
model.Email = txt_email.Text;
model.Status = int.Parse(StateList.SelectedItem.Value);
if (bll.UpdateUser(model) >= 1)
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("用户信息更新成功!");
strinfo.Visible = true;
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("用户信息更新失败!");
strinfo.Visible = true;
}
}
public void RegisterUser(Entity.BASE_USER entity)
{
userDal.Add(entity);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_USER set ");
strSql.Append(" IDNUMBER = :IDNUMBER , ");
strSql.Append(" JOBNUMBER = :JOBNUMBER , ");
strSql.Append(" PHOTO = :PHOTO , ");
strSql.Append(" PROF = :PROF , ");
strSql.Append(" REMARK = :REMARK , ");
strSql.Append(" STSTUS = :STSTUS , ");
strSql.Append(" PHONE = :PHONE , ");
strSql.Append(" USERNAME = :USERNAME , ");
strSql.Append(" USERPWD = :USERPWD , ");
strSql.Append(" PARENTID = :PARENTID , ");
strSql.Append(" SEX = :SEX , ");
strSql.Append(" DEPTID = :DEPTID , ");
strSql.Append(" BIRTHDAY = :BIRTHDAY , ");
strSql.Append(" DEGREE = :DEGREE , ");
strSql.Append(" FACE = :FACE,");
strSql.Append(" REALNAME=:REALNAME ");
strSql.Append(" where USERID=:USERID ");
OracleParameter[] parameters =
{
new OracleParameter(":IDNUMBER", OracleType.VarChar, 18),
new OracleParameter(":JOBNUMBER", OracleType.VarChar, 50),
new OracleParameter(":PHOTO", OracleType.VarChar, 200),
new OracleParameter(":PROF", OracleType.VarChar, 50),
new OracleParameter(":REMARK", OracleType.VarChar, 50),
new OracleParameter(":STSTUS", OracleType.Number, 4),
new OracleParameter(":PHONE", OracleType.VarChar, 50),
new OracleParameter(":USERNAME", OracleType.VarChar, 50),
new OracleParameter(":USERPWD", OracleType.VarChar, 32),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":SEX", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":BIRTHDAY", OracleType.DateTime),
new OracleParameter(":DEGREE", OracleType.VarChar, 50),
new OracleParameter(":FACE", OracleType.VarChar, 50),
new OracleParameter(":REALNAME", OracleType.VarChar, 50),
new OracleParameter(":USERID", OracleType.Number, 4)
};
parameters[0].Value = model.IDNUMBER;
parameters[1].Value = model.JOBNUMBER;
parameters[2].Value = model.PHOTO;
parameters[3].Value = model.PROF;
parameters[4].Value = model.REMARK;
parameters[5].Value = model.STSTUS;
parameters[6].Value = model.PHONE;
parameters[7].Value = model.USERNAME;
parameters[8].Value = model.USERPWD;
parameters[9].Value = model.PARENTID;
parameters[10].Value = model.SEX;
parameters[11].Value = model.DEPTID;
parameters[12].Value = model.BIRTHDAY;
parameters[13].Value = model.DEGREE;
parameters[14].Value = model.FACE;
parameters[15].Value = model.REALNAME;
parameters[16].Value = model.USERID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(Entity.BASE_USER model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="user">用户实体</param>
/// <returns></returns>
public bool Update(Entity.BASE_USER user)
{
return(dal.Update(user));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_USER GetEntity(decimal USERID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select USERID, IDNUMBER, JOBNUMBER, PHOTO, PROF, REMARK, STSTUS, PHONE, USERNAME, USERPWD, PARENTID, SEX, DEPTID, BIRTHDAY, DEGREE, FACE,REALNAME ");
strSql.Append(" from BASE_USER ");
strSql.Append(" where USERID=:USERID ");
OracleParameter[] parameters =
{
new OracleParameter(":USERID", OracleType.Number, 4)
};
parameters[0].Value = USERID;
Entity.BASE_USER entity = new Entity.BASE_USER();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["USERID"].ToString() != "")
{
entity.USERID = decimal.Parse(dt.Rows[0]["USERID"].ToString());
}
entity.IDNUMBER = dt.Rows[0]["IDNUMBER"].ToString();
entity.JOBNUMBER = dt.Rows[0]["JOBNUMBER"].ToString();
entity.PHOTO = dt.Rows[0]["PHOTO"].ToString();
entity.PROF = dt.Rows[0]["PROF"].ToString();
entity.REMARK = dt.Rows[0]["REMARK"].ToString();
if (dt.Rows[0]["STSTUS"].ToString() != "")
{
entity.STSTUS = decimal.Parse(dt.Rows[0]["STSTUS"].ToString());
}
entity.PHONE = dt.Rows[0]["PHONE"].ToString();
entity.USERNAME = dt.Rows[0]["USERNAME"].ToString();
entity.USERPWD = dt.Rows[0]["USERPWD"].ToString();
if (dt.Rows[0]["PARENTID"].ToString() != "")
{
entity.PARENTID = decimal.Parse(dt.Rows[0]["PARENTID"].ToString());
}
if (dt.Rows[0]["SEX"].ToString() != "")
{
entity.SEX = decimal.Parse(dt.Rows[0]["SEX"].ToString());
}
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
if (dt.Rows[0]["BIRTHDAY"].ToString() != "")
{
entity.BIRTHDAY = DateTime.Parse(dt.Rows[0]["BIRTHDAY"].ToString());
}
entity.DEGREE = dt.Rows[0]["DEGREE"].ToString();
entity.FACE = dt.Rows[0]["FACE"].ToString();
entity.REALNAME = dt.Rows[0]["REALNAME"].ToString();
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_USER entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_User set ");
strSql.Append(" UserName = @UserName , ");
strSql.Append(" Password = @Password , ");
strSql.Append(" Email = @Email , ");
strSql.Append(" Question = @Question , ");
strSql.Append(" Answer = @Answer , ");
strSql.Append(" RoleID = @RoleID , ");
strSql.Append(" UserGroup = @UserGroup , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" LastLoginTime = @LastLoginTime , ");
strSql.Append(" Status = @Status , ");
strSql.Append(" IsOnline = @IsOnline , ");
strSql.Append(" IsLimit = @IsLimit ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 128),
new SqlParameter("@Password", SqlDbType.NVarChar, 128),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@Question", SqlDbType.NVarChar, 100),
new SqlParameter("@Answer", SqlDbType.NVarChar, 100),
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@UserGroup", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@IsOnline", SqlDbType.Bit, 1),
new SqlParameter("@IsLimit", SqlDbType.Bit, 1)
};
parameters[12].Value = entity.UserID;
parameters[13].Value = entity.UserName;
parameters[14].Value = entity.Password;
parameters[15].Value = entity.Email;
parameters[16].Value = entity.Question;
parameters[17].Value = entity.Answer;
parameters[18].Value = entity.RoleID;
parameters[19].Value = entity.UserGroup;
parameters[20].Value = entity.CreateTime;
parameters[21].Value = entity.LastLoginTime;
parameters[22].Value = entity.Status;
parameters[23].Value = entity.IsOnline;
parameters[24].Value = entity.IsLimit;
int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据用户名得到用户对象实体
/// </summary>
public Entity.BASE_USER GetUserModel(string UserName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Base_User ");
strSql.Append(" where UserName=@UserName ");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 128)
};
parameters[0].Value = UserName;
Entity.BASE_USER model = new Entity.BASE_USER();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.Question = ds.Tables[0].Rows[0]["Question"].ToString();
model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
if (ds.Tables[0].Rows[0]["UserGroup"].ToString() != "")
{
model.UserGroup = int.Parse(ds.Tables[0].Rows[0]["UserGroup"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "")
{
model.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOnline"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsOnline"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsOnline"].ToString().ToLower() == "true"))
{
model.IsOnline = true;
}
else
{
model.IsOnline = false;
}
}
if (ds.Tables[0].Rows[0]["IsLimit"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsLimit"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsLimit"].ToString().ToLower() == "true"))
{
model.IsLimit = true;
}
else
{
model.IsLimit = false;
}
}
//读取角色
model.RoleID = GetUserRoleArray(model.UserID);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新用户基本信息
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public int UpdateUser(Entity.BASE_USER model)
{
return(dal.UpdateUser(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_USER GetEntity(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserID, UserName, Password, Email, Question, Answer, RoleID, UserGroup, CreateTime, LastLoginTime, Status, IsOnline, IsLimit ");
strSql.Append(" from Base_User ");
strSql.Append(" where UserID=@UserID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
Entity.BASE_USER entity = new Entity.BASE_USER();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
entity.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
entity.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
entity.Password = ds.Tables[0].Rows[0]["Password"].ToString();
entity.Email = ds.Tables[0].Rows[0]["Email"].ToString();
entity.Question = ds.Tables[0].Rows[0]["Question"].ToString();
entity.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
if (ds.Tables[0].Rows[0]["UserGroup"].ToString() != "")
{
entity.UserGroup = int.Parse(ds.Tables[0].Rows[0]["UserGroup"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
entity.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "")
{
entity.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
entity.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOnline"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsOnline"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsOnline"].ToString().ToLower() == "true"))
{
entity.IsOnline = true;
}
else
{
entity.IsOnline = false;
}
}
if (ds.Tables[0].Rows[0]["IsLimit"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsLimit"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsLimit"].ToString().ToLower() == "true"))
{
entity.IsLimit = true;
}
else
{
entity.IsLimit = false;
}
}
//读取角色
entity.RoleID = GetUserRoleArray(entity.UserID);
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 绑定用户信息
/// </summary>
/// <param name="userId">用户ID</param>
private void BindingUserInfo(int userId)
{
BLL.BASE_USER_ROLE userRoleBLL = new BLL.BASE_USER_ROLE();
var dt = userRoleBLL.GetList(userId); //获取用户权限集合
#region 绑定用户基本信息
BLL.BASE_USER userBLL = new BLL.BASE_USER();
Entity.BASE_USER userModel = new Entity.BASE_USER();
userModel = userBLL.GetUser(userId);
this.BIRTHDAY = userModel.BIRTHDAY;
this.DEGREE = userModel.DEGREE;
this.DEPTID = userModel.DEPTID;
this.FACE = userModel.FACE;
this.IDNUMBER = userModel.IDNUMBER;
this.JOBNUMBER = userModel.JOBNUMBER;
this.PARENTID = userModel.PARENTID;
this.PHONE = userModel.PHONE;
this.PHOTO = userModel.PHONE;
this.PROF = userModel.PROF;
this.REMARK = userModel.REMARK;
this.SEX = userModel.SEX;
this.STSTUS = userModel.STSTUS;
this.USERID = userModel.USERID;
this.USERNAME = userModel.USERNAME;
this.USERPWD = userModel.USERPWD;
#endregion
//绑定部门
BLL.BASE_DEPT deptBLL = new BLL.BASE_DEPT();
_Department = deptBLL.GetEntity(userModel.DEPTID);
/*
#region 绑定角色信息
* var roles = userRoleBLL.Query(
* string.Format("SELECT distinct ROLEID FROM base_user_role WHERE userid = {0}",
* userId.ToString()));
* BLL.BASE_ROLE roleBll = new BLL.BASE_ROLE();
* foreach (DataRow dr in roles.Rows) {
* Entity.BASE_ROLE roleModel = new Entity.BASE_ROLE();
* roleModel = roleBll.GetEntity(Convert.ToInt32(dr["ROLEID"]));
*
* Utility.UserRole role = new UserRole();
* role.ROLEID = roleModel.ROLEID;
* role.ROLEINFO = roleModel.ROLEINFO;
* role.ROLENAME = roleModel.ROLENAME;
*
#region 绑定菜单
* var menus = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1}",
* userId.ToString(),
* roleModel.ROLEID.ToString()));
* BLL.BASE_MENU bllMenu = new BLL.BASE_MENU();
* foreach (DataRow menuDr in menus.Rows) {
* Entity.BASE_MENU menuModel = new Entity.BASE_MENU();
* menuModel = bllMenu.GetEntity(Convert.ToInt32(menuDr["MENUID"]));
*
* Utility.UserMenu menu = new UserMenu();
* menu.ICON = menuModel.ICON;
* menu.MENUID = menuModel.MENUID;
* menu.MENUINFO = menuModel.MENUINFO;
* menu.MENUNAME = menuModel.MENUNAME;
* menu.MENUURL = menuModel.MENUURL;
* menu.PARENTID = menuModel.PARENTID;
* menu.STATUS = menuModel.STATUS;
*
#region 绑定菜单的Action
* var actions = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1} AND MENUID={2}",
* userId.ToString(),
* roleModel.ROLEID.ToString(),
* menu.MENUID.ToString()));
* BLL.BASE_ACTION actionBLL = new BLL.BASE_ACTION();
* foreach (DataRow actionDr in actions.Rows) {
* Entity.BASE_ACTION actionModel = new Entity.BASE_ACTION();
* actionModel = actionBLL.GetEntity(Convert.ToInt32(actionDr["ACTIONID"].ToString()));
*
* menu.UserAction.Add(actionModel); //动作信息加载菜单中
* }
#endregion
*
* role.UserMenu.Add(menu); //菜单加入角色组中
* }
#endregion
*
* UserRole.Add(role); //角色组加入集合中
* }
#endregion
*/
}
