public ActionResult <string> EXPORTYG()
{
var context = _accessor.HttpContext;
var tokenHeader = context.Request.Cookies["szhlcode"].ToString().Replace("Bearer ", "");
TokenModelJWT tokenModel = JwtHelper.SerializeJWT(tokenHeader);
JH_Auth_UserB.UserInfo UserInfo = new JH_Auth_UserB().GetUserInfo(10334, tokenModel.UserName);
JObject JsonData = new JObject();
string P1 = context.Request.Query["P1"].ToString();
string P2 = context.Request.Query["P2"].ToString();
string pagecount = context.Request.Query["pagecount"].ToString();
JsonData.Add("P1", P1);
JsonData.Add("P2", P2);
JsonData.Add("pagecount", pagecount);
new AuthManage().GETUSERBYCODENEWPAGE(JsonData, Model, P1, P2, UserInfo);
DataTable dt = Model.Result;
string sqlCol = "ID,UserOrder|序号,DeptName|部门,RoomCode|房间号,UserName|账号,UserRealName|姓名,Sex|性别,mobphone|手机,QQ|QQ,weixinCard|微信,mailbox|邮箱,telphone|座机,ROLENAME|职务,Usersign|职责,UserGW|岗位,IDCard|身份证,HomeAddress|家庭住址";
DataTable dtResult = dt.DelTableCol(sqlCol);
HSSFWorkbook workbook = new HSSFWorkbook();
workbook = CommonHelp.ExportToExcel(dtResult);
var stream = new NPOIMemoryStream();
workbook.Write(stream);
stream.Flush();
stream.Position = 0;
return(File(stream, "application/ms-excel", string.Format("{0}.xls", "员工_导出文件_" + DateTime.Now.Ticks)));
}
public void LCSPCHECK(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
SZHL_TXSX TX = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
//todo 需要根据PID找到对应的数据ID
Article ar0 = new Article();
ar0.Title = TX.TXContent;
ar0.Description = "";
ar0.Url = TX.MsgID;
List <Article> al = new List <Article>();
al.Add(ar0);
JH_Auth_UserB.UserInfo UserTXInfo = new JH_Auth_UserB().GetUserInfo(TX.ComId.Value, TX.CRUser);
if (!string.IsNullOrEmpty(TX.TXUser))
{
try
{
//发送PC消息
new JH_Auth_User_CenterB().SendMsg(UserTXInfo, TX.TXMode, TX.TXContent, TX.MsgID, TX.TXUser, "A", TX.intProcessStanceid, TX.ISCS);
}
catch (Exception)
{
}
//发送微信消息
WXHelp wx = new WXHelp(UserTXInfo.QYinfo);
wx.SendTH(al, TX.TXMode, "A", TX.TXUser);
}
}
/// <summary>
/// 生日提醒
/// </summary>
public static void AUTOALERTSR()
{
try
{
List <JH_Auth_QY> QyModel = new JH_Auth_QYB().GetEntities(d => d.ComId != 0).ToList();
WXHelp wx = new WXHelp(QyModel[0]);
var qdata = new JH_Auth_UserB().GetEntities(d => d.Birthday != null);
foreach (var item in qdata)
{
if (item.Birthday.Value.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd"))
{
Article ar0 = new Article();
ar0.Title = "生日提醒";
ar0.Description = "";
ar0.Url = "http://www.baidu.com";
ar0.PicUrl = "";
List <Article> al = new List <Article>();
al.Add(ar0);
wx.SendTPMSG("XXFB", al, item.UserName);
}
}
}
catch (Exception)
{
}
}
public void SaveTXFile(HttpContext cxt, HttpPostedFile file, string fileName, ref string fileid)
{
if (cxt.Request.Cookies["szhlcode"] != null && cxt.Request.Cookies["szhlcode"].ToString() != "")
{
JH_Auth_UserB.UserInfo usermodel = new JH_Auth_UserB().GetUserInfo(cxt.Request.Cookies["szhlcode"].Value.ToString());
string md5 = new CommonHelp().SaveFile(usermodel.QYinfo, fileName, file);
FT_File newfile = new FT_File();
newfile.ComId = usermodel.User.ComId;
newfile.Name = fileName;
newfile.FileMD5 = md5.Replace("\"", "").Split(',')[0];
newfile.zyid = md5.Split(',').Length == 2 ? md5.Split(',')[1] : md5.Split(',')[0];
newfile.FileSize = "0";
newfile.FileVersin = 0;
newfile.CRDate = DateTime.Now;
newfile.CRUser = usermodel.User.UserName;
newfile.UPDDate = DateTime.Now;
newfile.UPUser = usermodel.User.UserName;
newfile.FileExtendName = "jpg";
newfile.FolderID = 3;
newfile.ISYL = "Y";
new FT_FileB().Insert(newfile);
usermodel.User.UserLogoId = newfile.ID;
fileid = newfile.ID.ToString();
new JH_Auth_UserB().Update(usermodel.User);
}
}
public void SENDWXMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var tx = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int msgid = Int32.Parse(tx.MsgID);
var qyhd = new SZHL_QYHDNB().GetEntity(p => p.ID == msgid);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, qyhd.CRUser);
if (qyhd != null)
{
////发送消息
string content = qyhd.FQF + "发起了以（" + qyhd.Title + "）为主题的" + (qyhd.Type == 0 ? "活动" : "投票");
new JH_Auth_User_CenterB().SendMsg(UserInfo, "QYHD", content, qyhd.ID.ToString(), qyhd.CYR, qyhd.Type == 1 ? "A" : "B");
////发送微信消息
Article ar = new Article();
ar.Title = content;
ar.Description = "";
//ar.PicUrl = qyhd.
ar.Url = qyhd.ID.ToString();
List <Article> Msgs = new List <Article>();
Msgs.Add(ar);
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(Msgs, "QYHD", "B", qyhd.CYR);
}
}
public void SaveTXFile(HttpContext cxt, HttpPostedFile file, string fileName, ref string fileid)
{
if (cxt.Request.Cookies["szhlcode"] != null && cxt.Request.Cookies["szhlcode"].ToString() != "")
{
JH_Auth_UserB.UserInfo usermodel = new JH_Auth_UserB().GetUserInfo(cxt.Request.Cookies["szhlcode"].Value.ToString());
string URL = usermodel.QYinfo.FileServerUrl + "fileupload?qycode=" + usermodel.QYinfo.QYCode;
string md5 = SaveFile(URL, file, fileName);
FT_File newfile = new FT_File();
newfile.ComId = usermodel.User.ComId;
newfile.Name = fileName;
newfile.FileMD5 = md5.Replace("\"", "");
newfile.FileSize = "0";
newfile.FileVersin = 0;
newfile.CRDate = DateTime.Now;
newfile.CRUser = usermodel.User.UserName;
newfile.UPDDate = DateTime.Now;
newfile.UPUser = usermodel.User.UserName;
newfile.FileExtendName = "jpg";
newfile.FolderID = 3;
newfile.ISYL = "Y";
new FT_FileB().Insert(newfile);
usermodel.User.UserLogoId = newfile.ID;
fileid = newfile.ID.ToString();
new JH_Auth_UserB().Update(usermodel.User);
}
}
public void TSGLMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
SZHL_TXSX TX = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int rwid = 0;
int.TryParse(TX.MsgID, out rwid);
SZHL_TSGL jy = new SZHL_TSGLB().GetEntity(d => d.ID == rwid);
Article ar0 = new Article();
ar0.Title = TX.TXContent;
ar0.Description = jy == null ? "" : jy.TSName;
ar0.Url = TX.MsgID;
List <Article> al = new List <Article>();
al.Add(ar0);
if (!string.IsNullOrEmpty(TX.TXUser))
{
try
{
//发送PC消息
UserInfo = new JH_Auth_UserB().GetUserInfo(TX.ComId.Value, TX.CRUser);
new JH_Auth_User_CenterB().SendMsg(UserInfo, TX.TXMode, TX.TXContent, TX.MsgID, TX.TXUser, "A", 0, TX.ISCS);
}
catch (Exception)
{
}
}
//发送微信消息
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, TX.TXMode, "A", TX.TXUser);
}
public void EXPORTYCGL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int total = 0;
DataTable dt = new SZHL_YCGLB().GetDataPager("SZHL_YCGL yc left join SZHL_YCGL_CAR car on yc.CarID=car.ID", "yc.*,car.CarBrand,car.CarType,car.CarNum ,dbo.fn_PDStatus(yc.intProcessStanceid) AS StateName", 2000, 1, " yc.CRDate desc", "", ref total);
string sqlCol = "SYUser|使用人,XCType|行程类别,CarNum|使用车辆,SYRS|用车人数,JSR|驾驶员,Remark|使用说明,StartTime|开始时间,EndTime|结束时间,StartAddress|出发地点,EndAddress|到达地点";
CommonHelp ch = new CommonHelp();
DataTable dt2 = dt.DelTableCol(sqlCol);
foreach (DataRow dr in dt2.Rows)
{
try
{
dr["使用人"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, dr["使用人"].ToString());
if (!string.IsNullOrEmpty(dr["驾驶员"].ToString()))
{
dr["驾驶员"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, dr["驾驶员"].ToString());
}
}
catch (Exception)
{
}
}
msg.ErrorMsg = ch.ExportToExcel("用车记录", dt2);
}
public void SENDZANMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var tx = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int msgid = Int32.Parse(tx.MsgID);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, tx.CRUser);
var model = new SZHL_TSSQB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId);
if (model != null)
{
Article ar0 = new Article();
ar0.Title = "您收到一个赞";
ar0.Description = "话题:" + CommonHelp.RemoveHtml(model.HTNR) + "\r\n来自:" + UserInfo.User.UserRealName;
ar0.Url = model.ID.ToString();
List <Article> al = new List <Article>();
al.Add(ar0);
string jsr = string.Empty;
jsr = model.CRUser;
if (!string.IsNullOrEmpty(jsr))
{
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, "TSSQ", "A", jsr);
}
}
}
/// <summary>
/// 分享链接的信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void SENDWXMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var tx = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int msgid = Int32.Parse(tx.MsgID);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, tx.CRUser);
var model = new JH_Auth_WXMSGB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId);
if (model != null)
{
Article ar0 = new Article();
ar0.Title = model.Title;
ar0.Description = "您收到了" + tx.CRUserRealName + "创建的话题信息，请查阅";
ar0.Url = model.ID.ToString();
ar0.PicUrl = model.FileId;
List <Article> al = new List <Article>();
al.Add(ar0);
string jsr = string.Empty;
jsr = model.CRUser;
//发送消息
//string content = ar0.Description;
//new JH_Auth_User_CenterB().SendMsg(UserInfo, "CRM", content, model.ID.ToString(), jsr, "A");
if (!string.IsNullOrEmpty(jsr))
{
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, "TSSQ", "D", jsr);
}
}
}
/// <summary>
/// 发送微信信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void SENDXZMSG(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
SZHL_TXSX TX = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
Article ar0 = new Article();
ar0.Title = TX.TXContent;
ar0.Description = "";
ar0.Url = TX.MsgID;
List <Article> al = new List <Article>();
al.Add(ar0);
if (!string.IsNullOrEmpty(TX.TXUser))
{
try
{
//发送PC消息
UserInfo = new JH_Auth_UserB().GetUserInfo(TX.ComId.Value, TX.CRUser);
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, TX.TXMode, "A", TX.TXUser);
new JH_Auth_User_CenterB().SendMsg(UserInfo, TX.TXMode, TX.TXContent, TX.MsgID, TX.TXUser);
}
catch (Exception)
{
}
//发送微信消息
}
}
//同步关注状态
public void TBGZSTATUS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptRoot == -1 && d.ComId == UserInfo.User.ComId);
#region 步用户关注状态
WXHelp wx = new WXHelp(UserInfo.QYinfo);
GetDepartmentMemberInfoResult yg = wx.WX_GetDepartmentMemberInfo(branchModel.WXBMCode.Value);
if (yg != null && yg.userlist != null)
{
foreach (var u in yg.userlist)
{
JH_Auth_User user = new JH_Auth_UserB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.UserName == u.userid);
if (user != null && u != null && (u.status == 1 || u.status == 4))
{
user.isgz = u.status.ToString();
new JH_Auth_UserB().Update(user);
}
}
}
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
#endregion
}
public void SENDWXMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var tx = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int msgid = Int32.Parse(tx.MsgID);
var model = new SZHL_XXFBB().GetEntity(p => p.ID == msgid);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, model.CRUser);
if (model != null)
{
var item = new SZHL_XXFB_ITEMB().GetEntities(d => d.XXFBId == model.ID);
if (item.Count() > 0)
{
List <Article> Msgs = new List <Article>();
foreach (var v in item)
{
new JH_Auth_User_CenterB().SendMsg(UserInfo, "XXFB", model.CRUserName + "发布了一个企业信息", v.ID.ToString(), model.JSUser);
Article ar = new Article();
ar.Title = v.XXTitle;
ar.Description = v.XXTitle;
ar.PicUrl = v.ImageIds.Split(',')[0];
ar.Url = v.ID.ToString();
Msgs.Add(ar);
}
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(Msgs, "XXFB", "A", model.JSUser);
}
}
}
/// <summary>
/// @用的查询用户数据
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETUSERSBYKEY(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
DataTable dt1 = new JH_Auth_UserB().GetDTByCommand("SELECT TOP 5 UserName,UserRealName,C.DeptName +'/'+ B.DeptName as PNAME FROM JH_Auth_User a LEFT JOIN JH_Auth_Branch B on A.BranchCode=B.DeptCode INNER JOIN JH_Auth_Branch C on b.DeptRoot=c.DeptCode WHERE a.isTX='N' AND UserRealName LIKE '%" + P1 + "%'");
DataTable dt2 = new JH_Auth_UserB().GetDTByCommand("SELECT B.deptName +'/'+ A.deptName AS PNAME,A.DeptCode FROM JH_Auth_Branch A INNER JOIN JH_Auth_Branch B on A.DeptRoot=B.DeptCode WHERE A.deptName LIKE '%" + P1 + "%' OR B.deptName LIKE '%" + P1 + "%'");
msg.Result = dt1;
msg.Result1 = dt2;
}
/// <summary>
/// 获取我所监督的自律小组列表
/// </summary>
public void GETMYJIANDUGROUPTEAM(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
//我的自律小组名称
JH_Auth_User thisuser = new JH_Auth_UserB().GetEntity(d => d.ID == UserInfo.User.ID);
string viewname = "select Items as XiaoZu from dbo.Split(REPLACE('" + thisuser.JianDuXiaoZu + "',' ',''),';') ";
DataTable dt = new JH_Auth_UserB().GetDTByCommand(viewname);
msg.Result = dt;
msg.Result1 = thisuser.ZiLvXiaoZu;
}
/// <summary>
/// 登录
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1">用户名</param>
/// <param name="P2">密码（未解码的）</param>
/// <param name="UserInfo"></param>
public void LOGIN(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string password = context.Request["password"] ?? "";
string username = context.Request["UserName"] ?? "";
string chkcode = context.Request["chkcode"] ?? "";
msg.ErrorMsg = "";
//取消验证码 Weiler
//if (context.Session["chkcode"] != null)
//{
// if (!chkcode.ToUpper().Equals(context.Session["chkcode"].ToString()))
// {
// msg.ErrorMsg = "验证码不正确";
// return;
// }
//}
//else
//{
// msg.ErrorMsg = "验证码已过期";
// return;
//}
JH_Auth_QY qyModel = new JH_Auth_QYB().GetALLEntities().First();
password = CommonHelp.GetMD5(password);
JH_Auth_User userInfo = new JH_Auth_User();
List <JH_Auth_User> userList = new JH_Auth_UserB().GetEntities(d => (d.UserName == username || d.mobphone == username) && d.UserPass == password).ToList();
if (userList.Count() == 0)
{
msg.ErrorMsg = "用户名或密码不正确";
return;
}
else
{
userInfo = userList[0];
if (userInfo.IsUse != "Y")
{
msg.ErrorMsg = "用户被禁用,请联系管理员";
return;
}
if (string.IsNullOrEmpty(userInfo.pccode))
{
userInfo.pccode = CommonHelp.CreatePCCode(userInfo);
}
userInfo.logindate = DateTime.Now;
new JH_Auth_UserB().Update(userInfo);
msg.Result = userInfo.pccode;
msg.Result1 = userInfo.UserName;
msg.Result4 = userInfo;
}
}
/// <summary>
/// 根据小组名称获取自律小组信息，包含我所监督的小组
/// </summary>
public void GETGROUPTEAMBYCODE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
P1 = P1.Trim();
string viewname = "select U.* , wu.nickName from JH_Auth_User U LEFT JOIN WX_User wu on u.WxOpenid = wu.openid " +
"where u.ZiLvXiaoZu is not null and u.ZiLvXiaoZu <> '' and u.ZiLvXiaoZu = '" + P1 + "' "
+ "or ('" + P1 + "' like (select Items from dbo.Split(REPLACE(u.jianduxiaozu,' ',''),';') where items='" + P1 + "'))"
+ " order by u.UserOrder, u.IsZuZhang desc, u.UserRealName asc";
DataTable dt = new JH_Auth_UserB().GetDTByCommand(viewname);
msg.Result = dt;
}
public void GETMANGWFDATA(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
int PIID = int.Parse(P1);
if (PIID > 0)
{
Yan_WF_PI PIMODEL = new Yan_WF_PIB().GetEntity(d => d.ID == PIID);
if (PIMODEL == null)
{
msg.ErrorMsg = "流程数据已清除";
return;
}
else
{
DataTable dtList = new Yan_WF_TDB().GetEntities(d => d.ProcessDefinitionID == PIMODEL.PDID.Value).OrderBy(d => d.Taskorder).ToDataTable();
dtList.Columns.Add("userrealname");
dtList.Columns.Add("EndTime");
dtList.Columns.Add("TaskUserView");
dtList.Columns.Add("state");
foreach (DataRow dr in dtList.Rows)
{
string tdCode = dr["TDCODE"].ToString();
Yan_WF_TI tiModel = new Yan_WF_TIB().GetEntity(d => d.PIID == PIID && d.TDCODE == tdCode && d.EndTime != null);//
if (tiModel != null)
{
dr["userrealname"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, tiModel.TaskUserID);
dr["EndTime"] = tiModel.EndTime;
dr["TaskUserView"] = tiModel.TaskUserView;
dr["state"] = tiModel.TaskState;
}
}
msg.Result = dtList;
Yan_WF_PD pdmodel = new Yan_WF_PDB().GetEntity(d => d.ID == PIMODEL.PDID);
msg.Result1 = pdmodel;
msg.Result2 = "{ \"ISCANSP\":\"" + new Yan_WF_PIB().isCanSP(UserInfo.User.UserName, int.Parse(P1)) + "\",\"ISCANCEL\":\"" + new Yan_WF_PIB().isCanCancel(UserInfo.User.UserName, PIMODEL) + "\"}";
msg.Result3 = PIMODEL;//可修改字段
if (!string.IsNullOrEmpty(pdmodel.Files))
{
msg.Result4 = new FT_FileB().GetDTByCommand("SELECT * FROM FT_File WHERE ID IN (" + pdmodel.Files + ") ");
}
}
}
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
}
/// <summary>
/// 设置禁止被@
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void SETJZTZ(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
JH_Auth_User MODEL = new JH_Auth_UserB().GetEntity(D => D.UserName == P1);
MODEL.isTX = P2;
new JH_Auth_UserB().Update(MODEL);
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
}
/// <summary>
/// 同步通讯录
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1">初始化密码</param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
#region 企业号相关
/// <summary>
/// 将系统的组织架构同步到微信中去
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void TBBRANCHUSER(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
//判断是否启用微信后，启用部门需要同步添加微信部门
if (UserInfo.QYinfo.IsUseWX == "Y")
{
#region 步部门
//系统部门
List <JH_Auth_Branch> branchList = new JH_Auth_BranchB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.WXBMCode == null).ToList();
WXHelp wx = new WXHelp(UserInfo.QYinfo);
//微信部门
GetDepartmentListResult bmlist = wx.WX_GetBranchList("");
foreach (JH_Auth_Branch branch in branchList)
{
List <DepartmentList> departList = bmlist.department.Where(d => d.name == branch.DeptName).ToList();
WorkJsonResult result = null;
if (departList.Count() > 0)
{
branch.WXBMCode = int.Parse(departList[0].id.ToString());
result = wx.WX_UpdateBranch(branch);
}
else
{
int branchWxCode = int.Parse(wx.WX_CreateBranchTB(branch).ToString());
branch.WXBMCode = branchWxCode;
}
new JH_Auth_BranchB().Update(branch);
}
#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);
List <JH_Auth_User> userList = new JH_Auth_UserB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.UserName != "administrator").ToList();
foreach (JH_Auth_User user in userList)
{
if (yg.userlist.Where(d => d.name == user.UserName || d.mobile == user.mobphone).Count() > 0)
{
wx.WX_UpdateUser(user);
}
else
{
wx.WX_CreateUser(user);
}
}
#endregion
}
}
public void GETUSERINFOBYOPENID(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string _openid = CommonHelp.GetCookieString("openid");
WX_User u = new WX_UserB().GetEntity(d => d.Openid == _openid);
if (u != null)
{
JH_Auth_User localuser = new JH_Auth_UserB().GetEntity(d => d.WXopenid == _openid && d.IsWX == 1);
if (localuser != null)
{
msg.Result = localuser;
}
}
}
/// <summary>
/// 根据部门编号获取部门人员(基本设置列表)
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="strUserName"></param>
public void GETUSERJBSZLIST(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int deptCode = 0;
int.TryParse(P1, out deptCode);
JH_Auth_Branch branch = new JH_Auth_BranchB().GetBMByDeptCode(UserInfo.QYinfo.ComId, deptCode);
if (branch == null)
{
msg.ErrorMsg = "数据异常";
}
string strQXWhere = string.Format("And ( u.branchCode={0} or b.Remark1 like '{1}%')", deptCode, (branch.Remark1 == "" ? "" : branch.Remark1 + "-") + branch.DeptCode);
string branchqx = new JH_Auth_BranchB().GetBranchQX(UserInfo);
if (branch.DeptRoot == -1 && !string.IsNullOrEmpty(branchqx))
{
strQXWhere = " And (";
int i = 0;
foreach (int dept in branchqx.SplitTOInt(','))
{
JH_Auth_Branch branchQX = new JH_Auth_BranchB().GetBMByDeptCode(UserInfo.QYinfo.ComId, dept);
strQXWhere += string.Format((i == 0 ? "" : "And") + " ( u.branchCode!={0} And b.Remark1 NOT like '{1}%')", dept, (branchQX.Remark1 == "" ? "" : branchQX.Remark1 + "-") + branchQX.DeptCode);
i++;
}
strQXWhere += ")";
}
string tableName = " JH_Auth_User u inner join JH_Auth_Branch b on u.branchCode=b.DeptCode left join SZHL_GZGL_JCSZ z on u.UserName=z.UserName and u.ComId=z.ComId ";
string tableColumn = " z.*,u.ID as uid,u.UserName as un,u.UserRealName,u.mobphone,b.DeptName,b.DeptCode";
string strWhere = string.Format("u.ComId={0} {1}", UserInfo.User.ComId, strQXWhere);
if (P2 != "")
{
strWhere += string.Format(" And (u.UserName like '%{0}%' or u.UserRealName like '%{0}%' or b.DeptName like '%{0}%' or u.mobphone like '%{0}%' ) ", P2);
}
int page = 0;
int pagecount = 8;
int.TryParse(context.Request("p") ?? "0", out page);
int.TryParse(context.Request("pagecount") ?? "8", out pagecount);//页数
page = page == 0 ? 1 : page;
int total = 0;
DataTable dt = new JH_Auth_UserB().GetDataPager(tableName, tableColumn, pagecount, page, " DeptShort ,UserOrder asc", strWhere, ref total);
msg.Result = dt;
msg.Result1 = total;
}
public ActionResult <string> ExeAction(string Action, Object PostData)
{
Model.Action = Action;
var context = _accessor.HttpContext;
var tokenHeader = context.Request.Headers["Authorization"].ToString().Replace("Bearer ", "");
TokenModelJWT tokenModel = JwtHelper.SerializeJWT(tokenHeader);
if (new DateTimeOffset(DateTime.Now.AddMinutes(5)).ToUnixTimeSeconds() > tokenModel.Exp)
{
//需要更新Token
Model.uptoken = JwtHelper.CreateJWT(tokenModel.UserName, "Admin");
}
JH_Auth_UserB.UserInfo UserInfo = CacheHelp.Get(tokenModel.UserName) as JH_Auth_UserB.UserInfo;
if (UserInfo == null)
{
UserInfo = new JH_Auth_UserB().GetUserInfo(10334, tokenModel.UserName);
CacheHelp.Set(tokenModel.UserName, UserInfo);
}
try
{
JObject JsonData = JObject.FromObject(PostData);
string P1 = JsonData["P1"] == null ? "" : JsonData["P1"].ToString();
string P2 = JsonData["P2"] == null ? "" : JsonData["P2"].ToString();
// 1.Load(命名空间名称)，GetType(命名空间.类名)
Type type = Assembly.Load("QJY.API").GetType("QJY.API." + Action.Split('_')[0].ToUpper() + "Manage");
//2.GetMethod(需要调用的方法名称)
MethodInfo method = type.GetMethod(Action.Split('_')[1].ToUpper());
// 3.调用的实例化方法（非静态方法）需要创建类型的一个实例
object obj = Activator.CreateInstance(type);
//4.方法需要传入的参数
object[] parameters = new object[] { JsonData, Model, P1, P2, UserInfo };
method.Invoke(obj, parameters);
new JH_Auth_LogB().InsertLog(Model.Action, "--调用接口", "", UserInfo.User.UserName, UserInfo.User.UserRealName, UserInfo.QYinfo.ComId, "");
}
catch (Exception ex)
{
Model.ErrorMsg = Action + "接口调用失败,请检查日志";
Model.Result = ex.ToString();
new JH_Auth_LogB().InsertLog(Action, Model.ErrorMsg + ex.StackTrace.ToString(), ex.ToString(), tokenModel.UserName, "", 0, "");
}
return(ControHelp.CovJson(Model));
}
/// <summary>
/// 我的群，根据科室/职务来划分
/// </summary>
public void GETMYCROWD(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
//我的自律小组名称
JH_Auth_User thisuser = new JH_Auth_UserB().GetEntity(d => d.ID == UserInfo.User.ID);
string viewname = "select u.* , wu.nickName, b.DeptName from JH_Auth_User U LEFT JOIN WX_User wu on u.WxOpenid = wu.openid "
+ " left join JH_Auth_Branch b on u.BranchCode=b.DeptCode "
+ " where u.BranchCode=" + thisuser.BranchCode + " and u.UserGW = '" + thisuser.UserGW + "' "
+ " order by u.UserOrder, u.UserRealName asc";
DataTable dt = new JH_Auth_UserB().GetDTByCommand(viewname);
msg.Result = dt;
msg.Result1 = thisuser.UserGW;
if (dt.Rows.Count > 0)
{
msg.Result2 = thisuser.UserGW + "-" + dt.Rows[0]["DeptName"].ToString();
}
}
public void GETZXJLYHLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string userName = UserInfo.User.UserName;
int page = 0;
int pagecount = 8;
int.TryParse(context.Request["p"] ?? "1", out page); //页码
int.TryParse(context.Request["pagecount"] ?? "8", out pagecount); //页数
page = page == 0 ? 1 : page;
int recordCount = 0;
string strWhere = string.Format("ComId={0} ", UserInfo.User.ComId);
string strContent = context.Request["Content"] ?? "";
strWhere = strWhere + string.Format(" AND UserRealName like '%{0}%' ", strContent);;
DataTable dt = new JH_Auth_UserB().GetDataPager(@" JH_Auth_User ", " *", pagecount, page, " JH_Auth_User.UserOrder ", strWhere, ref recordCount);
msg.Result = dt;
msg.Result1 = recordCount;
}
/// <summary>
/// 用车管理日历视图
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETYCGLVIEW(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string strSql = string.Format("SELECT ycgl.ID,ycgl.intProcessStanceid,car.CarBrand,car.CarType,car.CarNum, ycgl.StartTime start, ycgl.EndTime end1 from SZHL_YCGL ycgl left outer join SZHL_YCGL_CAR car on ycgl.CarID = car.ID where 1=1 ");
if (P1 != "0")
{
strSql += string.Format(" and ycgl.CarID={0} ", P1);
}
DataTable dt = new JH_Auth_UserB().GetDTByCommand(strSql);
dt.Columns.Add("end");
dt.Columns.Add("title");
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["end"] = dt.Rows[i]["end1"];
dt.Rows[i]["title"] = dt.Rows[i]["CarBrand"].ToString() + "-" + dt.Rows[i]["CarType"].ToString() + dt.Rows[i]["CarNum"].ToString();
}
msg.Result = dt;
}
public void SENDHTMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var tx = JsonConvert.DeserializeObject <SZHL_TXSX>(P1);
int msgid = Int32.Parse(tx.MsgID);
UserInfo = new JH_Auth_UserB().GetUserInfo(tx.ComId.Value, tx.CRUser);
var model = new SZHL_TSSQB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId);
if (model != null)
{
Article ar0 = new Article();
ar0.Title = UserInfo.User.UserRealName + "发表了新话题";
ar0.Description = CommonHelp.RemoveHtml(model.HTNR);
ar0.Url = model.ID.ToString();
if (!string.IsNullOrEmpty(model.Files))
{
ar0.PicUrl = model.Files.Split(',')[0];
}
List <Article> al = new List <Article>();
al.Add(ar0);
string jsr = string.Empty;
if (!string.IsNullOrEmpty(model.CYR))
{
jsr = model.CYR;
}
else
{
jsr = new JH_Auth_UserB().GetEntities(p => p.ComId == UserInfo.QYinfo.ComId).Select(d => d.UserName).ToList().ListTOString(',');
}
//发送消息
string content = ar0.Description;
new JH_Auth_User_CenterB().SendMsg(UserInfo, "TSSQ", content, model.ID.ToString(), jsr, "A");
if (!string.IsNullOrEmpty(jsr))
{
WXHelp wx = new WXHelp(UserInfo.QYinfo);
wx.SendTH(al, "TSSQ", "A", jsr);
}
}
}
public ActionResult <string> WXINIT()
{
try
{
var context = _accessor.HttpContext;
#region 获取Code
Model.ErrorMsg = "";
string P1 = context.Request.Query["P1"].ToString();
string P2 = context.Request.Query["P2"].ToString();
string szhlcode = context.Request.Query["szhlcode"].ToString();
TokenModelJWT tokenModel = JwtHelper.SerializeJWT(szhlcode);
if (tokenModel.UserName == null)
{
Model.ErrorMsg = "NOCODE";
}
else
{
JH_Auth_UserB.UserInfo UserInfo = new JH_Auth_UserB().GetUserInfo(10334, tokenModel.UserName);
DataTable dtUsers = new JH_Auth_UserB().GetDTByCommand(" SELECT UserName,UserRealName,mobphone FROM JH_Auth_User where ComId='" + UserInfo.User.ComId + "'");
//获取选择用户需要的HTML和转化用户名需要的json数据
Model.Result = dtUsers;
JH_Auth_Common url = new JH_Auth_CommonB().GetEntity(p => p.ModelCode == P1 && p.MenuCode == P2);
if (url != null)
{
Model.Result1 = url.Url1;
}
Model.Result2 = UserInfo.User.UserName + "," + UserInfo.User.UserRealName + "," + UserInfo.User.BranchCode + "," + UserInfo.BranchInfo.DeptName;
Model.Result3 = UserInfo.QYinfo.FileServerUrl;
Model.Result4 = UserInfo.QYinfo.QYCode;
}
#endregion
}
catch (Exception ex)
{
Model.ErrorMsg = "WXINIT接口调用失败,请检查日志";
Model.Result = ex.ToString();
CommonHelp.WriteLOG(ex.ToString());
}
return(ControHelp.CovJson(Model));
}
public void REGISTERYS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string strXM = P2;
string strPhone = P1;
JH_Auth_User user1 = new JH_Auth_UserB().GetUserByUserName(10334, P1);
if (user1 != null)
{
msg.ErrorMsg = "用户已存在";
return;
}
JH_Auth_User user = new JH_Auth_User();
user.UserName = strPhone;
user.mobphone = strPhone;
user.UserRealName = P2;
user.UserPass = CommonHelp.GetMD5("abc123");
user.ComId = 10334;
user.BranchCode = 1728;
user.CRDate = DateTime.Now;
user.CRUser = "******";
user.logindate = DateTime.Now;
user.IsUse = "Y";
if (!new JH_Auth_UserB().Insert(user))
{
msg.ErrorMsg = "添加用户失败";
}
else
{
JH_Auth_QY QY = new JH_Auth_QYB().GetEntity(d => d.ComId == 10334);
WXHelp wx = new WXHelp(QY);
wx.WX_CreateUser(user);
//添加默认员工角色
JH_Auth_UserRole Model = new JH_Auth_UserRole();
Model.UserName = user.UserName;
Model.RoleCode = 1219;
Model.ComId = user.ComId;
new JH_Auth_UserRoleB().Insert(Model);
}
}
public ActionResult <string> Login(Object PostData)
{
JObject JsonData = JObject.FromObject(PostData);
string username = JsonData["UserName"] == null ? "" : JsonData["UserName"].ToString();
string password = JsonData["password"] == null ? "" : JsonData["password"].ToString();
Dictionary <string, string> results3 = JsonConvert.DeserializeObject <Dictionary <string, string> >(PostData.ToString());
Model.ErrorMsg = "";
JH_Auth_QY qyModel = new JH_Auth_QYB().GetALLEntities().First();
password = CommonHelp.GetMD5(password);
JH_Auth_User userInfo = new JH_Auth_User();
List <JH_Auth_User> userList = new JH_Auth_UserB().GetEntities(d => (d.UserName == username || d.mobphone == username) && d.UserPass == password).ToList();
if (userList.Count() == 0)
{
Model.ErrorMsg = "用户名或密码不正确";
}
else
{
userInfo = userList[0];
if (userInfo.IsUse != "Y")
{
Model.ErrorMsg = "用户被禁用,请联系管理员";
}
if (Model.ErrorMsg == "")
{
Model.Result = JwtHelper.CreateJWT(username, "Admin");
Model.Result1 = userInfo.UserName;
Model.Result2 = qyModel.FileServerUrl;
Model.Result4 = userInfo;
CacheHelp.Remove(userInfo.UserName);
}
}
return(ControHelp.CovJson(Model));;
}