/// <summary>
/// 更新用户
/// </summary>
/// <returns></returns>
public string updateUsers()
{
string s = string.Empty;
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
#region 密码加密
string pwd = helpcommon.PasswordHelp.encrypt(Request.Form["userPwd"]);
pwd = helpcommon.PasswordHelp.encrypt(pwd);
#endregion
var Id = helpcommon.ParmPerportys.GetNumParms(Request.Form["Id"]);
var personaId = helpcommon.ParmPerportys.GetNumParms(Request.Form["personaId"]);
var userName = Request.Form["userName"];
//var userPwd = Request.Form["userPwd"];//密码
var userPwd = pwd;//密码
var userRealName = Request.Form["userRealName"];
var userSex = helpcommon.ParmPerportys.GetNumParms(Request.Form["userSex"]);
var UserPhone = Request.Form["UserPhone"];
var UserAddress = Request.Form["UserAddress"];
var UserEmail = Request.Form["UserEmail"];
var userIndex = helpcommon.ParmPerportys.GetNumParms(Request.Form["userIndex"]);
var UserManage = helpcommon.ParmPerportys.GetNumParms(Request.Form["UserManage"]);
//var UserId = helpcommon.ParmPerportys.GetNumParms(Request.Form["UserId"]);
var Def1 = Request.Form["Def1"];
var Def2 = Request.Form["Def2"];
var Def3 = Request.Form["Def3"];
var Def4 = Request.Form["Def4"];
var Def5 = Request.Form["Def5"];
int UserId = userInfo.User.Id;
PublicHelpController ph = new PublicHelpController();
bll.usersbll usersBll = new bll.usersbll();
DataTable mytable = usersBll.getDataEdit(Id);
string[] ssName = usersBll.getDataName("users");
string[] ss = ph.getFiledPermisson(roleId, menuId, funName.updateName);
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("id", SqlDbType.Int, 4),
new SqlParameter("personaId", SqlDbType.Int, 4),
new SqlParameter("usersName", SqlDbType.NVarChar, 20),
new SqlParameter("usersPwd", SqlDbType.NVarChar, 100),
new SqlParameter("usersRealName", SqlDbType.NVarChar, 20),
new SqlParameter("usersSex", SqlDbType.Int, 4),
new SqlParameter("usersPhone", SqlDbType.NVarChar, 20),
new SqlParameter("usersAddress", SqlDbType.NVarChar, 200),
new SqlParameter("usersEmail", SqlDbType.NVarChar, 20),
new SqlParameter("usersIndex", SqlDbType.Int, 4),
new SqlParameter("usersManage", SqlDbType.Int, 4),
new SqlParameter("userId", SqlDbType.Int, 4),
new SqlParameter("Def1", SqlDbType.NVarChar, 50),
new SqlParameter("Def2", SqlDbType.NVarChar, 50),
new SqlParameter("Def3", SqlDbType.NVarChar, 50),
new SqlParameter("Def4", SqlDbType.NVarChar, 50),
new SqlParameter("Def5", SqlDbType.NVarChar, 50)
};
for (int i = 0; i < ssName.Length; i++)
{
if (ss.Contains(ssName[i]))
{
if (ssName[i] == "Id")
{
ipara[i].Value = Id;
}
if (ssName[i] == "personaId")
{
ipara[i].Value = personaId;
}
if (ssName[i] == "userName")
{
ipara[i].Value = userName;
}
if (ssName[i] == "userPwd")
{
ipara[i].Value = userPwd;
}
if (ssName[i] == "userRealName")
{
ipara[i].Value = userRealName;
}
if (ssName[i] == "userSex")
{
ipara[i].Value = userSex;
}
if (ssName[i] == "UserPhone")
{
ipara[i].Value = UserPhone;
}
if (ssName[i] == "UserAddress")
{
ipara[i].Value = UserAddress;
}
if (ssName[i] == "UserEmail")
{
ipara[i].Value = UserEmail;
}
if (ssName[i] == "userIndex")
{
ipara[i].Value = userIndex;
}
if (ssName[i] == "UserManage")
{
ipara[i].Value = UserManage;
}
if (ssName[i] == "UserId")
{
ipara[i].Value = UserId;
}
if (ssName[i] == "Def1")
{
ipara[i].Value = Def1;
}
if (ssName[i] == "Def2")
{
ipara[i].Value = Def2;
}
if (ssName[i] == "Def3")
{
ipara[i].Value = Def3;
}
if (ssName[i] == "Def4")
{
ipara[i].Value = Def4;
}
if (ssName[i] == "Def5")
{
ipara[i].Value = Def5;
}
}
else
{
ipara[i].Value = mytable.Rows[0][mytable.Columns[i].ColumnName].ToString();
}
}
s = usersBll.Update(ipara, "updateUsers");
usersBll = null;
return(s);
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <returns></returns>
public string getData()
{
string roleJumpId = string.Empty; //外部跳转roleId
Dictionary <string, string> dic = new Dictionary <string, string>();
if (Request.Form["id"] != null && Request.Form["id"] != "0")
{
roleJumpId = Request.Form["id"].ToString();
dic.Add("roleId", roleJumpId);
}
///查询参数
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
List <model.users> list = new List <model.users>();
StringBuilder s = new StringBuilder();
bll.usersbll usersBll = new bll.usersbll();
string[] ssName = usersBll.getDataName("users");
//DataTable dt = new DataTable();
//DataTable dt = usersBll.getData();
DataTable dt = usersBll.getData(dic);
PublicHelpController ph = new PublicHelpController();
string[] ss = ph.getFiledPermisson(roleId, menuId, funName.selectName);
#region TABLE添加
s.Append("<tr>");
s.Append("<th colspan='50' class='mytableadd'>");
s.Append("<div style='padding-top: 20px;'>");
if (ph.isFunPermisson(roleId, menuId, funName.addName))
{
s.Append("<a href='#' onclick='javascript: showDiv()' >添加</a>");
}
s.Append("</div>");
s.Append("</th>");
s.Append("<tr>");
#endregion
#region TABLE表头
s.Append("<tr>");
for (int z = 0; z < ssName.Length; z++)
{
if (ss.Contains(ssName[z]))
{
s.Append("<td>");
if (ssName[z] == "personaId")
{
s.Append("角色");
}
if (ssName[z] == "userName")
{
s.Append("用户名");
}
if (ssName[z] == "userPwd")
{
s.Append("密码");
}
if (ssName[z] == "userRealName")
{
s.Append("姓名");
}
if (ssName[z] == "userSex")
{
s.Append("性别");
}
if (ssName[z] == "UserPhone")
{
s.Append("电话");
}
if (ssName[z] == "UserAddress")
{
s.Append("地址");
}
if (ssName[z] == "UserEmail")
{
s.Append("邮箱");
}
if (ssName[z] == "userIndex")
{
s.Append("排序");
}
if (ssName[z] == "UserManage")
{
s.Append("管理");
}
if (ssName[z] == "UserId")
{
s.Append("操作人");
}
if (ssName[z] == "Def1")
{
s.Append("默认1");
}
if (ssName[z] == "Def2")
{
s.Append("默认2");
}
if (ssName[z] == "Def3")
{
s.Append("默认3");
}
if (ssName[z] == "Def4")
{
s.Append("默认4");
}
if (ssName[z] == "Def5")
{
s.Append("默认5");
}
s.Append("</td>");
}
}
s.Append("<td>编辑</td><td>删除</td>");
s.Append("</tr>");
#endregion
#region TABLE内容
for (int i = 0; i < dt.Rows.Count; i++)
{
s.Append("<tr>");
for (int j = 0; j < ss.Length; j++)
{
if (ss[j].ToLower() == "id")
{
s.Append("<td>");
s.Append("<label id='lblId'>" + dt.Rows[i][ss[j]].ToString() + "</label>");
s.Append("</td>");
}
else
{
s.Append("<td>");
s.Append(dt.Rows[i][ss[j]].ToString());
s.Append("</td>");
}
}
#region 编辑
s.Append("<td>");
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<a href='#' onclick='javascript: showDivEdit();userEdit(" + dt.Rows[i][0].ToString() + ")'>编辑</a>");
}
else
{
s.Append("<a href='#'>无编辑权限</a>");
}
s.Append("</td>");
#endregion
#region 除
s.Append("<td>");
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<a href='#' onclick='del(" + dt.Rows[i][0].ToString() + ")'>删除</a>");
}
else
{
s.Append("<a href='#'>无删除权限</a>");
}
s.Append("</td>");
#endregion
s.Append("</tr>");
}
#endregion
usersBll = null;
return(s.ToString());
}
/// <summary>
/// 编辑用户
/// </summary>
/// <returns></returns>
public string editUsers()
{
StringBuilder s = new StringBuilder();
List <model.users> list = new List <model.users>();
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["id"]);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
bll.usersbll usersBll = new bll.usersbll();
DataTable dt = usersBll.getDataEdit(id);
string[] ssName = usersBll.getDataName("users");
PublicHelpController ph = new PublicHelpController();
string[] ss = ph.getFiledPermisson(roleId, menuId, funName.updateName);
s.Append("<div style='float:left'>");
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < ssName.Length; j++)
{
if (ss.Contains(ssName[j]))
{
s.Append("<div style='width:250px;float:left;'>");
if (ssName[j] == "Id")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>编号:</span>");
}
if (ssName[j] == "personaId")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>角色:</span>");
}
if (ssName[j] == "userName")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>用户名:</span>");
}
if (ssName[j] == "userPwd")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>密码:</span>");
}
if (ssName[j] == "userRealName")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>姓名:</span>");
}
if (ssName[j] == "userSex")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>性别:</span>");
}
if (ssName[j] == "UserPhone")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>电话:</span>");
}
if (ssName[j] == "UserAddress")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>地址:</span>");
}
if (ssName[j] == "UserEmail")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>邮箱:</span>");
}
if (ssName[j] == "userIndex")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>排序:</span>");
}
if (ssName[j] == "UserManage")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>管理:</span>");
}
if (ssName[j] == "UserId")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>操作人:</span>");
}
if (ssName[j] == "Def1")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认1:</span>");
}
if (ssName[j] == "Def2")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认2:</span>");
}
if (ssName[j] == "Def3")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认3:</span>");
}
if (ssName[j] == "Def4")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认4:</span>");
}
if (ssName[j] == "Def5")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认5:</span>");
}
if (ssName[j] == "userSex")
{
#region 性别
s.Append("<span style='width:135px;display:-moz-inline-box; display:inline-block;'>");
if (dt.Rows[i][ss[j]].ToString() == "0")
{
s.Append("<input style='width:18px;' id='usersSex' name='radio1' type='radio' value='0' checked='checked' />男");
s.Append("<input style='width:18px;' id='usersSex1' name='radio1' type='radio' value='1' />女");
}
else
{
s.Append("<input style='width:18px;' id='usersSex' name='radio1' type='radio' value='0' />男");
s.Append("<input style='width:18px;' id='usersSex1' name='radio1' type='radio' value='1' checked='checked' />女");
}
s.Append("</span>");
#endregion
}
else if (ssName[j] == "personaId")
{
#region 角色
RoleHelperController RH = new RoleHelperController();
s.Append("<select id='usersRoleEdit' title='" + dt.Rows[i][ss[j]].ToString() + "'>" + RH.getRoleData() + "</select>");
#endregion
}
else if (ssName[j] == "userPwd")
{
#region 密码
s.Append("<input type='password' value='" + dt.Rows[i][ss[j]] + "' id='" + ssName[j] + "' />");
#endregion
}
else
{
s.Append("<input type='text' value='" + dt.Rows[i][ss[j]] + "' id='" + ssName[j] + "' />");
}
s.Append("</div>");
}
}
}
shopbll sbl = new shopbll();
DataTable dtShop = sbl.GetAllShop();
string[] dtPerssionshop = usersBll.GetShopAllocation(id.ToString());
s.Append("<div style='width:450px;margin:auto'>");
for (int i = 0; i < dtShop.Rows.Count; i++)
{
if (dtPerssionshop.Contains(dtShop.Rows[i]["Id"].ToString()))
{
s.Append("<label style='width: 150px;float:left;text-align:left'><input class='Check' style='width:20px;' type='checkbox' checked='checked' shopid='" + dtShop.Rows[i]["Id"] + "' />" + dtShop.Rows[i]["ShopName"] + "</label>");
}
else
{
s.Append("<label style='width: 150px;float:left;text-align:left'><input class='Check' style='width:20px;' type='checkbox' shopid='" + dtShop.Rows[i]["Id"] + "' />" + dtShop.Rows[i]["ShopName"] + "</label>");
}
}
s.Append("</div>");
s.Append("</div>");
s.Append("<div><button id='btnSave' value='保存' onclick='userSave()'>保存</button></div>");
usersBll = null;
return(s.ToString());
}