/// <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 virtual bool Update(T info)
{
using (WXDataEntities db = new WXDataEntities())
{
db.Entry <T>(info).State = EntityState.Modified;//附加实体类
return(db.SaveChanges() > 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);
}
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 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 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);
}
}