/// <summary> /// 会议室详细信息 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETHYSMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); SZHL_HYGL_ROOM model = new SZHL_HYGL_ROOMB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); var st = DateTime.Now; var list = new SZHL_HYGLB().GetEntities(p => p.ComId == UserInfo.User.ComId && p.RoomID == model.ID && p.IsDel == 0 && st < p.EndTime).OrderBy(p => p.StartTime); List <int> li = new List <int>(); foreach (var l in list) { var pi = new Yan_WF_PIB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.ID == l.intProcessStanceid); if (pi != null) { if (pi.IsCanceled == "Y") { li.Add(l.ID); } } } var list1 = list.Where(p => !li.Contains(p.ID)); msg.Result = model; msg.Result1 = list1; }
/// <summary> /// 删除会议室 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void DELHYS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); int ss = int.Parse(P2); SZHL_HYGL_ROOM model = new SZHL_HYGL_ROOMB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); model.IsDel = ss; model.DelUser = UserInfo.User.UserName; model.DelDate = DateTime.Now; new SZHL_HYGL_ROOMB().Update(model); }
/// <summary> /// 添加会议室 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1">客户信息</param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void ADDHYS(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { SZHL_HYGL_ROOM hys = JsonConvert.DeserializeObject <SZHL_HYGL_ROOM>(P1); if (string.IsNullOrEmpty(hys.Name)) { msg.ErrorMsg = "会议室名称不能为空!"; } //if (string.IsNullOrEmpty(hys.Location )) //{ // msg.ErrorMsg =msg.ErrorMsg+ "位置不能为空!"; //} //if (string.IsNullOrEmpty(hys.AdminUser )) //{ // msg.ErrorMsg = msg.ErrorMsg + "管理员不能为空!"; //} if (string.IsNullOrEmpty(msg.ErrorMsg)) { if (hys.ID == 0) { var hys1 = new SZHL_HYGL_ROOMB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.Name == hys.Name); if (hys1 != null) { msg.ErrorMsg = "系统已经存在此会议室名称!"; } else { hys.CRDate = DateTime.Now; hys.CRUser = UserInfo.User.UserName; hys.ComId = UserInfo.User.ComId; hys.Status = "1"; hys.IsDel = 0; new SZHL_HYGL_ROOMB().Insert(hys); msg.Result = hys; } } else { var hys1 = new SZHL_HYGL_ROOMB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.Name == hys.Name && p.ID != hys.ID); if (hys1 != null) { msg.ErrorMsg = "系统已经存在此会议室名称"; } else { new SZHL_HYGL_ROOMB().Update(hys); msg.Result = hys; } } } }
/// <summary> /// 查看可用会议室列表 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETKYHYSLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { //var list = new SZHL_HYGL_ROOMB().GetEntities(p => p.Status == "1" && p.IsDel == 0); DataTable dt = new SZHL_HYGL_ROOMB().GetDTByCommand("select * from dbo.SZHL_HYGL_ROOM where IsDel=0 and Status='1' and ComId=" + UserInfo.User.ComId); dt.Columns.Add("ZT", Type.GetType("System.String")); dt.Columns.Add("ZYSJ", Type.GetType("System.String")); foreach (DataRow dr in dt.Rows) { int rid = Int32.Parse(dr["ID"].ToString()); var st = DateTime.Now; var et = DateTime.Now.AddHours(3); var list = new SZHL_HYGLB().GetEntities(p => p.RoomID == rid && p.IsDel == 0 && ((st >= p.StartTime && st < p.EndTime) || (et > p.StartTime && et <= p.EndTime) || (et > p.StartTime && st <= p.StartTime) || (et >= p.EndTime && st < p.EndTime)) && p.ComId == UserInfo.User.ComId).OrderBy(p => p.StartTime); List <int> li = new List <int>(); foreach (var l in list) { var pi = new Yan_WF_PIB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.ID == l.intProcessStanceid); if (pi != null) { if (pi.IsCanceled == "Y") { li.Add(l.ID); } } } var list1 = list.Where(p => !li.Contains(p.ID)); if (list1.Count() == 0) { dr["ZT"] = "0"; dr["ZYSJ"] = ""; } else { dr["ZT"] = "1"; dr["ZYSJ"] = list1.First().StartTime.Value.ToString("yyyy-MM-dd HH:mm") + "~" + list1.First().EndTime.Value.ToString("yyyy-MM-dd HH:mm"); } } msg.Result = dt; }
public void SENDMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); var model = new SZHL_HYGLB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); var rm = new SZHL_HYGL_ROOMB().GetEntity(p => p.ID == model.RoomID && p.ComId == UserInfo.User.ComId); Article ar0 = new Article(); ar0.Title = "会议通知"; ar0.Description = "发起人:" + new JH_Auth_UserB().GetUserRealName(UserInfo.User.ComId.Value, model.CRUser) + "\r\n您有新的会议[" + model.Title + "],会议室[" + rm.Name + "],请尽快查看吧"; ar0.Url = model.ID.ToString(); List <Article> al = new List <Article>(); al.Add(ar0); //new JH_Auth_User_CenterB().SendMsg(UserInfo, "HYGL", strContent, model.ID.ToString(), model.JSR, "B", model.intProcessStanceid); WXHelp wx = new WXHelp(UserInfo.QYinfo); wx.SendTH(al, "HYGL", "A", model.CYUser); }
/// <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_TX(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_HYGLB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId); if (model != null) { var rm = new SZHL_HYGL_ROOMB().GetEntity(p => p.ID == model.RoomID && p.ComId == UserInfo.User.ComId); Article ar0 = new Article(); ar0.Title = "会议提醒"; ar0.Description = "发起人:" + UserInfo.User.UserRealName + "\r\n您有会议[" + model.Title + "],会议室[" + rm.Name + "],将于" + model.StartTime.Value.ToString("yyyy-MM-dd HH:mm") + "开始,请及时参加"; ar0.Url = model.ID.ToString(); List <Article> al = new List <Article>(); al.Add(ar0); string jsr = string.Empty; if (!string.IsNullOrEmpty(model.FQUser)) { jsr = model.FQUser; } if (!string.IsNullOrEmpty(model.CYUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.CYUser; } else { jsr = model.CYUser; } } if (!string.IsNullOrEmpty(model.ZCUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.ZCUser; } else { jsr = model.ZCUser; } } if (!string.IsNullOrEmpty(model.JLUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.JLUser; } else { jsr = model.JLUser; } } if (!string.IsNullOrEmpty(model.SXUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.SXUser; } else { jsr = model.SXUser; } } ////发送消息 string content = ar0.Description; new JH_Auth_User_CenterB().SendMsg(UserInfo, "HYGL", content, model.ID.ToString(), jsr, "B", model.intProcessStanceid, tx.ISCS); if (!string.IsNullOrEmpty(jsr)) { WXHelp wx = new WXHelp(UserInfo.QYinfo); wx.SendTH(al, "HYGL", "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 SZHL_HYGLB().GetEntity(p => p.ID == msgid && p.ComId == UserInfo.User.ComId); if (model != null) { var user = new JH_Auth_UserB().GetUserByUserName(model.ComId.Value, model.CRUser); var rm = new SZHL_HYGL_ROOMB().GetEntity(p => p.ID == model.RoomID && p.ComId == UserInfo.User.ComId); Article ar0 = new Article(); ar0.Title = "会议通知"; ar0.Description = "发起人:" + user.UserRealName + "\r\n您有新的会议[" + model.Title + "],会议室[" + rm.Name + "],请尽快查看吧"; ar0.Url = model.ID.ToString(); List <Article> al = new List <Article>(); al.Add(ar0); string jsr = string.Empty; if (!string.IsNullOrEmpty(model.FQUser)) { jsr = model.FQUser; } if (!string.IsNullOrEmpty(model.CYUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.CYUser; } else { jsr = model.CYUser; } } if (!string.IsNullOrEmpty(model.ZCUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.ZCUser; } else { jsr = model.ZCUser; } } if (!string.IsNullOrEmpty(model.JLUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.JLUser; } else { jsr = model.JLUser; } } if (!string.IsNullOrEmpty(model.SXUser)) { if (!string.IsNullOrEmpty(jsr)) { jsr = jsr + "," + model.SXUser; } else { jsr = model.SXUser; } } UserInfo = new JH_Auth_UserB().GetUserInfo(model.ComId.Value, model.CRUser); if (!string.IsNullOrEmpty(jsr)) { //发送消息 string content = user.UserRealName + "邀请您参加会议:" + model.Title; new JH_Auth_User_CenterB().SendMsg(UserInfo, "HYGL", content, model.ID.ToString(), jsr, "B", model.intProcessStanceid, tx.ISCS); WXHelp wx = new WXHelp(UserInfo.QYinfo); wx.SendTH(al, "HYGL", "A", jsr); } if (model.TXSJ > 0) { DateTime dt = model.StartTime.ToDateTime().AddMinutes(-model.TXSJ.Value); SZHL_TXSX tx1 = new SZHL_TXSX(); tx1.ComId = model.ComId; tx1.APIName = "HYGL"; tx1.MsgID = model.ID.ToString(); tx1.FunName = "SENDWXMSG_TX"; tx1.Date = dt.ToString("yyyy-MM-dd HH:mm:ss"); tx1.CRUser = model.CRUser; tx1.CRDate = DateTime.Now; TXSX.TXSXAPI.AddALERT(tx1); //时间为发送时间 //TXSX.TXSXAPI.AddALERT(UserInfo.User.ComId.Value, "HYGL", "SENDWXMSG_TX", model.ID.ToString(), dt); //时间为发送时间 } } }