public void delOaRoleByRoleCode(string RoleCode)
{
using (NETDISKDBEntities Db = new NETDISKDBEntities())
{
IQueryable <OaRole> list = Db.OaRole.Where(p => p.RoleCode == RoleCode);
foreach (var item in list)
{
Db.OaRole.Remove(item);
}
Db.SaveChanges();
}
}
public string GetOaRoleByRoleCode(string RoleCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select (stuff((select '★' + LinkCode + '★' from OaRole");
strSql.Append(string.Format(" where RoleCode = {0}", RoleCode));
strSql.Append(" for xml path('')),1,1,'★')) as LinkCodes");
using (NETDISKDBEntities Db = new NETDISKDBEntities())
{
string result1 = Db.Database.SqlQuery <string>(strSql.ToString()).FirstOrDefault();
return(result1);
}
}
//日志添加
public static int AddUserLog(string LogName, string LogNote)
{
BLL.Cookie GetCookie = new BLL.Cookie();
int reset = 0;
using (NETDISKDBEntities Db = new NETDISKDBEntities())
{
BLL.UserLog log = new BLL.UserLog();
log.LogCreatTime = DateTime.Now;
log.LogName = LogName;
log.LogNote = LogNote;
log.UserName = GetCookie.GetUserCookie().userName;
log.State = true;
Db.UserLog.Add(log);
reset = Db.SaveChanges();
}
return(reset);
}
