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());
}
