protected void btnSave_Click(object sender, EventArgs e)
{
Ctrl_Sys_User dcUserInfo = new Ctrl_Sys_User();
if (dcUserInfo.Exists(int.Parse(hdUserId.Value), txtUserName.Text))
{
MessageBox.Show(this, "用户名称，不允许重复！");
return;
}
int iUserInfoId = int.Parse(hdUserId.Value.ToString());//取得区\县标识
UserInfoEntity userInfo = new UserInfoEntity();
userInfo.UserId = iUserInfoId;
userInfo.UserName = txtUserName.Text;
userInfo.UserNickName = txtUserNickName.Text;
userInfo.UserLevel = int.Parse(drpUserLevel.SelectedValue);
userInfo.StreetId = drpStreet.Enabled == true ? int.Parse(drpStreet.SelectedValue) : 0;
userInfo.CommunityId = drpCommunity.Enabled == true ? int.Parse(drpCommunity.SelectedValue) : 0;
if (iUserInfoId == 0)//代表添加
{
userInfo.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPwd.Text, "md5");
iUserInfoId = dcUserInfo.Add(userInfo);
if (iUserInfoId > 0)
{
dcUserInfo.AddUserRole(iUserInfoId, int.Parse(drpUserRole.SelectedValue));
MessageBox.ShowAndRedirect(this, "成功添加一条信息！", "OperManage.aspx");
}
else
{
MessageBox.Show(this, "添加信息失败，请与管理员联系！");
}
}
else
{
if (chkIsModPwd.Checked)
{
userInfo.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPwd.Text, "md5");
}
else
{
userInfo.UserPwd = hdUserPwd.Value;
}
if (dcUserInfo.UpdateUserRole(iUserInfoId, int.Parse(drpUserRole.SelectedValue)) && dcUserInfo.Update(userInfo))
{
MessageBox.ShowAndRedirect(this, "成功修改一条信息！", "OperManage.aspx");
}
else
{
MessageBox.Show(this, "修改信息失败，请与管理员联系！");
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(UserInfoEntity model)
{
int iExecute = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_User(");
strSql.Append("UserName,UserPwd,UserNickName,UserLevel,StreetId,CommunityId)");
strSql.Append(" values (");
strSql.Append("@UserName,@UserPwd,@UserNickName,@UserLevel,@StreetId,@CommunityId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserName", SqlDbType.NVarChar,30),
new SqlParameter("@UserPwd", SqlDbType.NVarChar,100),
new SqlParameter("@UserNickName", SqlDbType.NVarChar,30),
new SqlParameter("@UserLevel", SqlDbType.Int),
new SqlParameter("@StreetId", SqlDbType.Int),
new SqlParameter("@CommunityId", SqlDbType.Int)};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPwd;
parameters[2].Value = model.UserNickName;
parameters[3].Value = model.UserLevel;
parameters[4].Value = model.StreetId;
parameters[5].Value = model.CommunityId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
iExecute = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\Add" + e.Message);
}
return iExecute;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(UserInfoEntity model)
{
bool iExecute = false;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_User set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPwd=@UserPwd,");
strSql.Append("UserNickName=@UserNickName,");
strSql.Append("UserLevel=@UserLevel,");
strSql.Append("StreetId=@StreetId,");
strSql.Append("CommunityId=@CommunityId");
strSql.Append(" where Id=@UserId");
SqlParameter[] parameters = {
new SqlParameter("@UserName", SqlDbType.NVarChar,30),
new SqlParameter("@UserPwd", SqlDbType.NVarChar,100),
new SqlParameter("@UserNickName", SqlDbType.NVarChar,30),
new SqlParameter("@UserLevel", SqlDbType.Int),
new SqlParameter("@StreetId", SqlDbType.Int),
new SqlParameter("@CommunityId", SqlDbType.Int),
new SqlParameter("@UserId", SqlDbType.Int)};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPwd;
parameters[2].Value = model.UserNickName;
parameters[3].Value = model.UserLevel;
parameters[4].Value = model.StreetId;
parameters[5].Value = model.CommunityId;
parameters[6].Value = model.UserId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
iExecute = true;
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\Update" + e.Message);
}
return iExecute;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UserInfoEntity GetModel(int UserId)
{
UserInfoEntity model = null;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 A.Id as UserId,UserName,UserPwd,UserNickName,UserLevel,StreetId,CommunityId,RoleId from Sys_User as A inner join Sys_UserRole B");
strSql.Append(" on A.Id=B.UserId");
strSql.Append(" where A.Id=@UserId");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4)
};
parameters[0].Value = UserId;
model = new UserInfoEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserId"] != null && ds.Tables[0].Rows[0]["UserId"].ToString() != "")
{
model.UserId = int.Parse(ds.Tables[0].Rows[0]["UserId"].ToString());
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["UserPwd"] != null && ds.Tables[0].Rows[0]["UserPwd"].ToString() != "")
{
model.UserPwd = ds.Tables[0].Rows[0]["UserPwd"].ToString();
}
if (ds.Tables[0].Rows[0]["UserNickName"] != null && ds.Tables[0].Rows[0]["UserNickName"].ToString() != "")
{
model.UserNickName = ds.Tables[0].Rows[0]["UserNickName"].ToString();
}
if (ds.Tables[0].Rows[0]["UserLevel"] != null && ds.Tables[0].Rows[0]["UserLevel"].ToString() != "")
{
model.UserLevel = int.Parse(ds.Tables[0].Rows[0]["UserLevel"].ToString());
}
if (ds.Tables[0].Rows[0]["StreetId"] != null && ds.Tables[0].Rows[0]["StreetId"].ToString() != "")
{
model.StreetId = int.Parse(ds.Tables[0].Rows[0]["StreetId"].ToString());
}
if (ds.Tables[0].Rows[0]["CommunityId"] != null && ds.Tables[0].Rows[0]["CommunityId"].ToString() != "")
{
model.CommunityId = int.Parse(ds.Tables[0].Rows[0]["CommunityId"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleId"] != null && ds.Tables[0].Rows[0]["RoleId"].ToString() != "")
{
model.UserRole = int.Parse(ds.Tables[0].Rows[0]["RoleId"].ToString());
}
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetModel" + e.Message);
}
return model;
}
