public static string GetXML(this WX_MenuEvent e, string toUserName, string fromUserName) { string resultXml = ""; switch (e.ResponType) { case "text": resultXml = string.Format("<xml><ToUserName><![CDATA[{0}]]></ToUserName><FromUserName><![CDATA[{1}]]></FromUserName><CreateTime>{2}</CreateTime><MsgType><![CDATA[text]]></MsgType><Content><![CDATA[{3}]]></Content></xml>", fromUserName, toUserName, DateTime_EX.GetTimeStamp(), e.ResponContent); break; case "news": WX_Media_News news = new WXDataEntities().WX_Media.Where(i => i.AppId.Equals(e.AppId) && i.MediaId.Equals(e.ResponContent)).FirstOrDefault().TransitionToNews(); resultXml = string.Format("<xml><ToUserName><![CDATA[{0}]]></ToUserName><FromUserName><![CDATA[{1}]]></FromUserName><CreateTime>{2}</CreateTime><MsgType><![CDATA[news]]></MsgType><ArticleCount>1</ArticleCount><Articles><item><Title><![CDATA[{3}]]></Title><Description><![CDATA[{4}]]></Description><PicUrl><![CDATA[{5}]]></PicUrl><Url><![CDATA[{6}]]></Url></item></Articles></xml>", fromUserName, toUserName, DateTime_EX.GetTimeStamp(), news.title, news.digest, news.GetPicUrl(), news.url); break; //case "voice": // string format = XmlTools.GetNodeInnerText(xml, "/xml/MediaId"); // resultXml = string.Format("<xml><ToUserName><![CDATA[{0}]]></ToUserName><FromUserName><![CDATA[{1}]]></FromUserName><CreateTime>{2}</CreateTime><MsgType><![CDATA[voice]]></MsgType><Voice><MediaId><![CDATA[{3}]]></MediaId></Voice></xml>", fromUserName, toUserName, createTime, format); // break; //case "image": // string mediaId = XmlTools.GetNodeInnerText(xml, "/xml/MediaId"); // resultXml = string.Format("<xml><ToUserName><![CDATA[{0}]]></ToUserName><FromUserName><![CDATA[{1}]]></FromUserName><CreateTime>{2}</CreateTime><MsgType><![CDATA[image]]></MsgType><Image><MediaId><![CDATA[{3}]]></MediaId></Image></xml>", fromUserName, toUserName, createTime, mediaId); // break; //case "video": // string video = XmlTools.GetNodeInnerText(xml, "/xml/MediaId"); // string thumbMediaId = XmlTools.GetNodeInnerText(xml, "/xml/ThumbMediaId"); // resultXml = string.Format("<xml><ToUserName><![CDATA[{0}]]></ToUserName><FromUserName><![CDATA[{1}]]></FromUserName><CreateTime>{2}</CreateTime><MsgType><![CDATA[video]]></MsgType><Video><MediaId><![CDATA[{3}]]></MediaId><Title><![CDATA['Test']]></Title><Description><![CDATA['描述']]></Description></Video></xml>", fromUserName, toUserName, createTime, video); // break; } return(resultXml); }
public bool Clear(string appid) { WXDataEntities db = new WXDataEntities(); var result = db.Database.ExecuteSqlCommand(@"Delete from WX_Menu where AppId=@AppId", new SqlParameter("AppId", appid)); return(result > 0); }
/// <summary> /// 修改用户所属客服 /// </summary> /// <param name="OpenId"></param> /// <param name="UserId"></param> /// <returns></returns> public bool UpUserId(string OpenId, int UserId) { WXDataEntities db = new WXDataEntities(); WX_User user = db.WX_User.Find(OpenId); user.UserId = UserId; return(db.SaveChanges() > 0); }
/// <summary> /// 根据id逻辑删除菜单 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Delect_id(int id) { WXDataEntities db = new WXDataEntities(); var shi = db.WX_Menu.Find(id); shi.MenuVisable = 1; return(db.SaveChanges() > 0); }
public bool ClearRight(int roleId) { using (WXDataEntities db = new WXDataEntities()) { int i = db.Database.ExecuteSqlCommand("delete SYS_Right where RoleId=" + roleId); return(i > 0); } }
public virtual bool Update(T info) { using (WXDataEntities db = new WXDataEntities()) { db.Entry <T>(info).State = EntityState.Modified;//附加实体类 return(db.SaveChanges() > 0); } }
//清空标签表 public bool ClearTag(WX_User user) { using (var db = new WXDataEntities()) { var p_openid = new SqlParameter("@openid", user.OpenID); var result = db.Database.ExecuteSqlCommand(@"Delete from WX_UserTagRelation where OpenId=@openid", p_openid); return(result > 0); } }
public bool NewUpdate(WX_User user) { WXDataEntities db = new WXDataEntities(); WX_User users = db.WX_User.Find(user.OpenID); users.UserName = user.UserName; users.Telphone = user.Telphone; user.Remark = users.Remark; return(db.SaveChanges() > 0); }
public bool Delete(int tagid, string appid) { using (var db = new WXDataEntities()) { var p_tagid = new SqlParameter("@tagid", tagid); var result = db.Database.ExecuteSqlCommand(@"Delete from WX_UserTagRelation where TagId=@tagid", p_tagid); result = db.SaveChanges(); } return(base.Delete(new object[] { tagid, appid })); }
//给用户添加标签 public bool AddTag(WX_User user, int tagid) { using (var db = new WXDataEntities()) { var p_tagid = new SqlParameter("@tagid", tagid); var p_openid = new SqlParameter("@openid", user.OpenID); var p_appid = new SqlParameter("@appid", user.AppId); var result = db.Database.ExecuteSqlCommand(@"Insert into WX_UserTagRelation values(@tagid,@openid,@appid)", p_tagid, p_openid, p_appid); return(result > 0); } }
/// <summary> /// 新建子级元素判断二级菜单是否超过五个 /// </summary> /// <returns></returns> public bool Add_zi_pd(int id) { WXDataEntities db = new WXDataEntities(); int count = (db.WX_Menu.Where(g => g.ParentMenuId == id && g.MenuVisable == 0).ToList()).Count; if (count < 5) { return(true); } else { return(false); } }
/// <summary> /// 新增一级菜单 判断当前公众号的一级菜单是否超过3个 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Add_yiji_pd(string AppId) { WXDataEntities db = new WXDataEntities(); int count = (db.WX_Menu.Where(g => g.ParentMenuId == null && g.AppId == AppId && g.MenuVisable == 0).ToList()).Count; if (count < 3) { return(true); } else { return(false); } }
public virtual bool Delete(object [] pkList) { using (WXDataEntities db = new WXDataEntities()) { var info = db.Set <T>().Find(pkList); if (info != null) { db.Set <T>().Remove(info); return(db.SaveChanges() > 0); } else { return(false); } } }
public virtual bool Add(T info) { try { // 写数据库 using (WXDataEntities db = new WXDataEntities()) { db.Set <T>().Add(info); return(db.SaveChanges() > 0); } } catch (DbEntityValidationException dbEx) { return(false); } }
public static List <SYS_Function> GetChildByRole(this SYS_Function func, int roleId) { using (WXDataEntities db = new WXDataEntities()) { SYS_Role role = db.SYS_Role.Find(roleId); List <SYS_Function> list = new List <SYS_Function>(); if (role.RoleSign.Equals("SYS_ADMIN")) { list = func.SYS_Function1.ToList(); } else { list = func.SYS_Function1.Where(s => s.SYS_Role.Where(r => r.RoleId == roleId).Count() > 0).ToList(); } return(list); } }
public static List <SYS_Function> GetMainFunction(this SYS_Role role) { List <SYS_Function> list = new List <SYS_Function>(); if (role.RoleSign.Equals("SYS_ADMIN")) { list = new WXDataEntities().SYS_Function.Where(s => s.ParentID == null).ToList(); return(list); } foreach (var i in role.SYS_Function.Where(s => s.ParentID != null)) { if (!list.HasFunction(i.SYS_Function2) && i.SYS_Function2.ParentID == null) { list.Add(i.SYS_Function2); } } return(list); }
public override bool Update(SYS_Role info) { using (WXDataEntities db = new WXDataEntities()) { db.Database.ExecuteSqlCommand("delete SYS_Right where RoleId=" + info.RoleId); var info1 = db.SYS_Role.Find(info.RoleId); info1.RoleId = info.RoleId; info1.RoleName = info.RoleName; foreach (var item in info.SYS_Function) { info1.SYS_Function.Add(db.SYS_Function.Find(item.FunctionID)); } return(db.SaveChanges() > 0); } }
public virtual T GetByPK(object pk) { WXDataEntities db = new WXDataEntities(); return(db.Set <T>().Find(pk)); }
public static bool IsHasEvent(this WX_Menu menu) { var r = new WXDataEntities().WX_MenuEvent.Where(m => m.MenuKey.Equals(menu.MenuKey)).Count() > 0; return(r); }
public virtual List <T> Where(Func <T, bool> predicate) { WXDataEntities db = new WXDataEntities(); return(db.Set <T>().Where(predicate).ToList()); }
public virtual List <T> GetAll() { WXDataEntities db = new WXDataEntities(); return(db.Set <T>().ToList()); }