/// <summary>
/// 第五版的自定义显示菜单和左边菜单
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETINDEXMENUNEW(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
DataTable dtModel = new JH_Auth_ModelB().GETMenuList(UserInfo, P1);
dtModel.Columns.Add("ISSY", Type.GetType("System.Int32"));
dtModel.Columns.Add("FunData", typeof(DataTable));
if (dtModel != null && dtModel.Rows.Count > 0)
{ //获取用户设置首页显示APP
List <string> userCustom = new JH_Auth_UserCustomDataB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.UserName == UserInfo.User.UserName && d.DataType == P1 && d.DataContent1 == "Y").Select(d => d.DataContent).ToList();
foreach (DataRow row in dtModel.Rows)
{
if (userCustom.Count > 0)
{
row["ISSY"] = 0;
if (row["UserAPPID"].ToString() != "")
{
row["ISSY"] = 1;
}
}
else
{
row["ISSY"] = 1;
}
row["FunData"] = new JH_Auth_RoleB().GetModelFun(UserInfo.User.ComId.Value, UserInfo.UserRoleCode, row["ID"].ToString());
}
}
msg.Result = dtModel;
msg.Result2 = UserInfo.User.isSupAdmin;
}
public QyJsonResult WX_AddTagMember(JH_Auth_UserRole Model)
{
var role = new JH_Auth_RoleB().GetEntity(p => p.RoleCode == Model.RoleCode);
QyJsonResult Ret = new QyJsonResult();
if (Qyinfo.IsUseWX == "Y")
{
string[] userList = { Model.UserName };
int bqid = Int32.Parse(role.WXBQCode.ToString());
Ret = MailListApi.AddTagMember(GetToken(), bqid, userList, null);
}
return(Ret);
}
/// <summary>
/// 从企业微信同步到系统里
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void TBTXL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
int bmcount = 0;
int rycount = 0;
if (P1 == "")
{
msg.ErrorMsg = "请输入初始密码";
return;
}
WXHelp wx = new WXHelp(UserInfo.QYinfo);
#region 更新部门
GetDepartmentListResult bmlist = wx.WX_GetBranchList("");
foreach (var wxbm in bmlist.department.OrderBy(d => d.parentid))
{
var bm = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == wxbm.id);
if (bm == null)
{
#region 新增部门
JH_Auth_Branch jab = new JH_Auth_Branch();
jab.WXBMCode = int.Parse(wxbm.id.ToString());
jab.ComId = UserInfo.User.ComId;
jab.DeptName = wxbm.name;
jab.DeptDesc = wxbm.name;
jab.DeptShort = int.Parse(wxbm.order.ToString());
if (wxbm.parentid == 0)//如果是跟部门,设置其跟部门为-1
{
jab.DeptRoot = -1;
}
else
{
var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == wxbm.parentid);
jab.DeptRoot = bm1.DeptCode;
jab.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, jab.DeptRoot);
}
new JH_Auth_BranchB().Insert(jab);
jab.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, jab.DeptRoot) + jab.DeptCode;
new JH_Auth_BranchB().Update(jab);
bmcount = bmcount + 1;
#endregion
}
else
{
//同步部门时放弃更新现有部门
}
}
#endregion
#region 更新人员
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptRoot == -1 && d.ComId == UserInfo.User.ComId);
GetDepartmentMemberInfoResult yg = wx.WX_GetDepartmentMemberInfo(branchModel.WXBMCode.Value);
foreach (var u in yg.userlist)
{
var user = new JH_Auth_UserB().GetUserByUserName(UserInfo.QYinfo.ComId, u.userid);
if (user == null)
{
#region 新增人员
JH_Auth_User jau = new JH_Auth_User();
jau.ComId = UserInfo.User.ComId;
jau.UserName = u.userid;
jau.UserPass = CommonHelp.GetMD5(P1);
jau.UserRealName = u.name;
jau.Sex = u.gender == 1 ? "男" : "女";
if (u.department.Length > 0)
{
int id = int.Parse(u.department[0].ToString());
var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == id);
jau.BranchCode = bm1.DeptCode;
jau.remark = bm1.Remark1.Split('-')[0];//用户得部门路径
}
jau.mailbox = u.email;
jau.mobphone = u.mobile;
jau.zhiwu = string.IsNullOrEmpty(u.position) ? "员工" : u.position;
jau.IsUse = "Y";
if (u.status == 1 || u.status == 4)
{
jau.isgz = u.status.ToString();
}
jau.txurl = u.avatar;
new JH_Auth_UserB().Insert(jau);
rycount = rycount + 1;
#endregion
//为所有人增加普通员工的权限
JH_Auth_Role rdefault = new JH_Auth_RoleB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.isSysRole == "Y" && p.RoleName == "员工");//找到默认角色
if (rdefault != null)
{
JH_Auth_UserRole jaurdefault = new JH_Auth_UserRole();
jaurdefault.ComId = UserInfo.User.ComId;
jaurdefault.RoleCode = rdefault.RoleCode;
jaurdefault.UserName = jau.UserName;
new JH_Auth_UserRoleB().Insert(jaurdefault);
}
}
else
{
//同步人员时放弃更新现有人员
#region 更新人员
user.UserRealName = u.name;
if (u.department.Length > 0)
{
int id = int.Parse(u.department[0].ToString());
var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == id);
user.BranchCode = bm1.DeptCode;
}
user.mailbox = u.email;
user.mobphone = u.mobile;
user.zhiwu = string.IsNullOrEmpty(u.position) ? "员工" : u.position;
user.Sex = u.gender == 1 ? "男" : "女";
if (u.status == 1 || u.status == 4)
{
user.IsUse = "Y";
user.isgz = u.status.ToString();
}
else if (u.status == 2)
{
user.IsUse = "N";
}
user.txurl = u.avatar;
new JH_Auth_UserB().Update(user);
#endregion
}
#region 更新角色(职务)
if (!string.IsNullOrEmpty(u.position))
{
var r = new JH_Auth_RoleB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.RoleName == u.position);
if (r == null)
{
JH_Auth_Role jar = new JH_Auth_Role();
jar.ComId = UserInfo.User.ComId;
jar.RoleName = u.position;
jar.RoleDec = u.position;
jar.PRoleCode = 0;
jar.isSysRole = "N";
jar.IsUse = "Y";
jar.leve = 0;
jar.DisplayOrder = 0;
new JH_Auth_RoleB().Insert(jar);
JH_Auth_UserRole jaur = new JH_Auth_UserRole();
jaur.ComId = UserInfo.User.ComId;
jaur.RoleCode = jar.RoleCode;
jaur.UserName = u.userid;
new JH_Auth_UserRoleB().Insert(jaur);
}
else
{
}
}
#endregion
}
#endregion
msg.Result1 = bmcount;
msg.Result2 = rycount;
}
catch (Exception ex)
{
msg.ErrorMsg = ex.ToString();
}
}
public void SAVEIMPORTUSER(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string branchMsg = "", branchErrorMsg = "", userMsg = "";
int i = 0, j = 0;
DataTable dt = new DataTable();
dt = JsonConvert.DeserializeObject <DataTable>(P1);
dt.Columns.Add("BranchCode");
JH_Auth_Branch branchroot = new JH_Auth_BranchB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.DeptRoot == -1);
foreach (DataRow row in dt.Rows)
{
int bRootid = branchroot.DeptCode;
string branchName = row[4].ToString();
if (branchName != "")
{
string[] branchNames = branchName.Split('/');
string strBranch = branchNames[0];
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strBranch && d.ComId == UserInfo.User.ComId);
if (branchModel == null)
{
branchModel = new JH_Auth_Branch();
branchModel.DeptName = branchNames[0];
branchModel.DeptDesc = branchNames[0];
branchModel.ComId = UserInfo.User.ComId;
branchModel.DeptRoot = bRootid;
branchModel.CRDate = DateTime.Now;
branchModel.CRUser = UserInfo.User.UserName;
new JH_Auth_BranchB().Insert(branchModel);
branchModel.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, branchModel.DeptRoot) + branchModel.DeptCode;
new JH_Auth_BranchB().Update(branchModel);
}
}
}
int rowIndex = 0;
foreach (DataRow row in dt.Rows)
{
rowIndex++;
string branchName = row[4].ToString();
if (branchName != "")
{
string[] branchNames = branchName.Split('/');
string strPBranch = branchNames[0];
JH_Auth_Branch PbranchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strPBranch && d.ComId == UserInfo.User.ComId);
int bRootid = PbranchModel.DeptCode;
for (int l = 1; l < branchNames.Length; l++)
{
string strBranch = branchNames[1];
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strBranch && d.DeptRoot == PbranchModel.DeptCode && d.ComId == UserInfo.User.ComId);
if (branchModel != null)
{
bRootid = branchModel.DeptCode;
if (l == branchNames.Length - 1)
{
row["BranchCode"] = branchModel.DeptCode;
}
}
else
{
branchModel = new JH_Auth_Branch();
branchModel.DeptName = strBranch;
branchModel.DeptDesc = strBranch;
branchModel.ComId = UserInfo.User.ComId;
branchModel.DeptRoot = bRootid;
branchModel.CRDate = DateTime.Now;
branchModel.CRUser = UserInfo.User.UserName;
new JH_Auth_BranchB().Insert(branchModel);
branchModel.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, branchModel.DeptRoot) + branchModel.DeptCode;
new JH_Auth_BranchB().Update(branchModel);
try
{
bRootid = branchModel.DeptCode;
if (l == branchNames.Length - 1)
{
row["BranchCode"] = branchModel.DeptCode;
}
i++;
branchMsg += "新增部门“" + strBranch + "”成功<br/>";
}
catch (Exception ex)
{
branchErrorMsg += "部门：" + strBranch + "失败 " + msg.ErrorMsg + "<br/>";
}
}
}
string userName = row[2].ToString();
JH_Auth_User userModel = new JH_Auth_UserB().GetEntity(d => d.UserName == userName && d.ComId == UserInfo.User.ComId);
if (userModel == null)
{
JH_Auth_User userNew = new JH_Auth_User();
if (row["BranchCode"].ToString() != "")
{
int tempcode = int.Parse(row["BranchCode"].ToString());
JH_Auth_Branch branchTemp = new JH_Auth_BranchB().GetEntity(d => d.DeptCode == tempcode && d.ComId == UserInfo.User.ComId);
userNew.BranchCode = branchTemp.DeptCode;
userNew.remark = branchTemp.Remark1.Split('-')[0];
}
else
{
userNew.BranchCode = bRootid;
}
userNew.ComId = UserInfo.User.ComId;
userNew.IsUse = "Y";
userNew.mailbox = row[3].ToString();
userNew.mobphone = row[2].ToString();
userNew.RoomCode = row[7].ToString();
userNew.Sex = row[1].ToString();
userNew.telphone = row[9].ToString();
DateTime result;
if (DateTime.TryParse(row[10].ToString(), out result))
{
userNew.Birthday = result;
}
userNew.UserGW = row[6].ToString();
userNew.UserName = row[2].ToString();
userNew.UserRealName = row[0].ToString();
userNew.zhiwu = row[5].ToString() == "" ? "员工" : row[5].ToString();
userNew.UserPass = CommonHelp.GetMD5(P2);
userNew.CRDate = DateTime.Now;
userNew.CRUser = UserInfo.User.UserName;
if (!string.IsNullOrEmpty(row[8].ToString()))
{
int orderNum = 0;
int.TryParse(row[8].ToString(), out orderNum);
userNew.UserOrder = orderNum;
}
try
{
msg.ErrorMsg = "";
if (string.IsNullOrEmpty(userNew.UserName))
{
msg.ErrorMsg = "用户名必填";
}
//Regex regexPhone = new Regex("^0?1[3|4|5|8|7][0-9]\\d{8}$");
//if (!regexPhone.IsMatch(userNew.UserName))
//{
// msg.ErrorMsg = "用户名必须为手机号";
//}
if (string.IsNullOrEmpty(userNew.mobphone))
{
msg.ErrorMsg = "手机号必填";
}
//if (!regexPhone.IsMatch(userNew.mobphone))
//{
// msg.ErrorMsg = "手机号填写不正确";
//}
Regex regexOrder = new Regex("^[0-9]*$");
if (userNew.UserOrder != null && !regexOrder.IsMatch(userNew.UserOrder.ToString()))
{
msg.ErrorMsg = "序号必须是数字";
}
if (msg.ErrorMsg != "")
{
userMsg += "第" + rowIndex + "行" + msg.ErrorMsg + "<br/>";
}
if (msg.ErrorMsg == "")
{
new JH_Auth_UserB().Insert(userNew);
JH_Auth_Role role = new JH_Auth_RoleB().GetEntity(d => d.RoleName == userNew.zhiwu && d.ComId == UserInfo.User.ComId);
if (role == null)
{
role = new JH_Auth_Role();
role.PRoleCode = 0;
role.RoleName = userNew.zhiwu;
role.RoleDec = userNew.zhiwu;
role.IsUse = "Y";
role.isSysRole = "N";
role.leve = 0;
role.ComId = UserInfo.User.ComId;
role.DisplayOrder = 0;
new JH_Auth_RoleB().Insert(role);
}
string strSql = string.Format("INSERT into JH_Auth_UserRole (UserName,RoleCode,ComId) Values('{0}',{1},{2})", userNew.UserName, role.RoleCode, UserInfo.User.ComId);
new JH_Auth_RoleB().ExsSql(strSql);
string isFS = context.Request["issend"] ?? "";
if (isFS.ToLower() == "true")
{
string content = string.Format("尊敬的" + userNew.UserName + "用户您好：你已被添加到" + UserInfo.QYinfo.QYName + ",账号：" + userNew.mobphone + "，密码" + P2 + ",登录请访问" + UserInfo.QYinfo.WXUrl);
new SZHL_DXGLB().SendSMS(userNew.mobphone, content, userNew.ComId.Value);
}
j++;
}
}
catch (Exception ex)
{
userMsg += "第" + rowIndex + "行" + msg.ErrorMsg + "<br/>";
}
}
else
{
userMsg += "第" + rowIndex + "行" + "用户“" + row[2].ToString() + "”已存在<br/>";
}
}
else
{
branchErrorMsg += "第" + rowIndex + "行所在部门必填<br/>";
}
}
msg.Result = branchErrorMsg + "<br/>" + userMsg;
msg.Result1 = "新增部门" + i + "个,新增用户" + j + "个<br/>" + branchMsg + (branchMsg == "" ? "" : "<br/>");
}
