public object SavePlanSet(PlanSet entity)
{
using (var db = new WeeklyEntities())
{
var loginner = FormsAuth.GetUserData<LoginerBase>();
int execCount = 0;
if (entity.Id == 0)
{
entity.CreateBy = loginner.Name;
entity.CreateById = loginner.UserID;
entity.CreateByDate = DateTime.Now;
db.PlanSets.Add(entity);
}
else
{
var oldEntity = db.PlanSets.First(p => p.Id == entity.Id);
oldEntity.PBegin = entity.PBegin;
oldEntity.BeginDay = entity.BeginDay;
oldEntity.PEnd = entity.PEnd;
oldEntity.EndDay = entity.EndDay;
oldEntity.Content = entity.Content;
oldEntity.Place = entity.Place;
oldEntity.Leads = entity.Leads;
oldEntity.UndertakeDept = entity.UndertakeDept;
oldEntity.ParticipationDept = entity.ParticipationDept;
oldEntity.PState = entity.PState;
}
execCount = db.SaveChanges();
if (execCount > 0)
return new { status = "success", message = "操作成功！" };
else
return new { status = "error", message = "操作失败,请检查！" };
}
}
public object SaveNotice(Notice entity)
{
using (var db = new WeeklyEntities())
{
var loginner = FormsAuth.GetUserData<LoginerBase>();
int execCount = 0;
if (entity.Id == 0)
{
entity.CreateBy = loginner.Name;
entity.CreateById = loginner.UserID;
entity.CreateByDate = DateTime.Now;
if (entity.State == 1)
entity.ReleaseDate = DateTime.Now;
db.Notices.Add(entity);
}
else
{
var oldEntity = db.Notices.First(p => p.Id == entity.Id);
oldEntity.Title = entity.Title;
oldEntity.Content = entity.Content;
oldEntity.State = entity.State;
if (entity.State == 1)
oldEntity.ReleaseDate = DateTime.Now;
}
execCount = db.SaveChanges();
if (execCount > 0)
return new { status = "success", message = "操作成功！" };
else
return new { status = "error", message = "操作失败,请检查！" };
}
}
public object SaveTask(Task entity)
{
using (var db = new WeeklyEntities())
{
var loginner = FormsAuth.GetUserData<LoginerBase>();
int execCount = 0;
if (entity.Id == 0)
{
entity.State = 1;
entity.CreateBy = loginner.Name;
entity.CreateById = loginner.UserID;
entity.CreateByDate = DateTime.Now;
db.Tasks.Add(entity);
}
else
{
var oldEntity = db.Tasks.First(p => p.Id == entity.Id);
oldEntity.WeeklyYear = entity.WeeklyYear;
oldEntity.WeeklyWeeks = entity.WeeklyWeeks;
oldEntity.WeeklyBegin = entity.WeeklyBegin;
oldEntity.WeeklyEnd = entity.WeeklyEnd;
oldEntity.PlanBegin = entity.PlanBegin;
oldEntity.PlanEnd = entity.PlanEnd;
}
execCount = db.SaveChanges();
if (execCount > 0)
return new { status = "success", message = "操作成功！" };
else
return new { status = "error", message = "操作失败,请检查！" };
}
}
public object saveRole(Role entity)
{
using (var db = new WeeklyEntities())
{
var loginner = FormsAuth.GetUserData<LoginerBase>();
int execCount = 0;
if (entity.Id == 0)
{
entity.CreateBy = loginner.Name;
entity.CreateById = loginner.UserID;
entity.CreateByDate = DateTime.Now;
db.Roles.Add(entity);
}
else
{
var oldEntity = db.Roles.First(p => p.Id == entity.Id);
oldEntity.Name = entity.Name;
oldEntity.OrgTypeId = entity.OrgTypeId;
}
execCount = db.SaveChanges();
if (execCount > 0)
return new { status = "success", message = "操作成功！" };
else
return new { status = "error", message = "操作失败,请检查！" };
}
}
public object GetDataByRoleId(int RoleID)
{
using (var db = new WeeklyEntities())
{
db.Configuration.ProxyCreationEnabled = false;
return db.RoleMenus.Where(p => p.RoleId == RoleID).ToList();
}
}
public object GetAllData()
{
using (var db = new WeeklyEntities())
{
db.Configuration.ProxyCreationEnabled = false;
return db.OrgTypes.OrderBy(p => p.Sort).ToList();
}
}
public object GetNewDetail()
{
using (var db = new WeeklyEntities())
{
Task tk = db.Tasks.OrderByDescending(t => t.Id).FirstOrDefault();
return tk;
}
}
public object getAllMenu()
{
using (var db = new WeeklyEntities())
{
string sql = "SELECT Name, PermCode, CASE WHEN len(PermCode) = 2 THEN '00' ELSE LEFT(PermCode, len(PermCode) - 2) END AS Url,IsShow,Sort FROM Menu";
var Menus = db.Database.SqlQuery<Menu>(sql).ToList();
return Menus;
}
}
public object saveRoleMenu(List<RoleMenu> entitys)
{
delRoleMenu(entitys[0].RoleId);
using (var db = new WeeklyEntities())
{
db.RoleMenus.AddRange(entitys);
db.SaveChanges();
return new { status = "success", message = "操作成功！" };
}
}
public object DelNotice(string ids)
{
using (var db = new WeeklyEntities())
{
var execCount = 0;
string sql = string.Format("delete Notice where Id in ({0})", ids);
execCount = db.Database.ExecuteSqlCommand(sql);
if (execCount == ids.Split(',').Length)
return new { status = "success", message = "操作成功！" };
else
return new { status = "error", message = "操作失败,请检查！" };
}
}
public object delRoleMenu(int? RoleID)
{
using (var db = new WeeklyEntities())
{
var roleMenus = db.RoleMenus.Where(m => m.RoleId == RoleID).ToList();
if (roleMenus.Count > 0)
{
db.RoleMenus.RemoveRange(roleMenus);
db.SaveChanges();
}
return new { status = "success", message = "操作成功！" };
}
}
public string GetMainList(int pageIndex, int pageSize)
{
dynamic result = new ExpandoObject();
using (var db = new WeeklyEntities())
{
var customs = (from custom in db.Notices
where custom.State == 1
select custom
).OrderByDescending(t => t.ReleaseDate).Skip(0 * 10).Take(10);
result.data = customs;
var json = JsonConvert.SerializeObject(result);
return json;
}
}
public object getMenuTree()
{
var loginner = FormsAuth.GetUserData<LoginerBase>();
int RoleId = loginner.RoleId;
if (RoleId != 0)
{
using (var db = new WeeklyEntities())
{
var Menus = db.VRoleMenus.Where(p => p.RoleId == RoleId).OrderBy(p => p.Sort).ToList();
return Menus;
}
}
return null;
}
public string GetDataList(int pageIndex, int pageSize)
{
dynamic result = new ExpandoObject();
using (var db = new WeeklyEntities())
{
var total = db.PlanSets.Count();
if (total <= 0 || pageSize <= 0)
{
return null;
}
var customs = (from custom in db.PlanSets
select custom
).OrderBy(t => t.Id).Skip(pageIndex * pageSize).Take(pageSize);
result.total = total;
result.data = customs;
var json = JsonConvert.SerializeObject(result);
return json;
}
}
public string GetDataList(int pageIndex, int pageSize, string Title)
{
dynamic result = new ExpandoObject();
using (var db = new WeeklyEntities())
{
var total = db.Notices.Where(t => t.Title.Contains(Title)).Count();
if (total <= 0 || pageSize <= 0)
{
return null;
}
var customs = (from custom in db.Notices
where custom.Title.Contains(Title)
select custom
).OrderByDescending(t => t.Id).Skip(pageIndex * pageSize).Take(pageSize);
result.total = total;
result.data = customs;
var json = JsonConvert.SerializeObject(result);
return json;
}
}
public string getRole(int pageIndex, int pageSize)
{
dynamic result = new ExpandoObject();
using (var db = new WeeklyEntities())
{
var total = db.Roles.Count();
if (total <= 0 || pageSize <= 0)
{
return null;
}
var customs = (from custom in db.Roles
join o in db.OrgTypes on custom.OrgTypeId equals o.Id
orderby custom.Id
select new { custom.Id, custom.Name, custom.OrgTypeId, OrgTypeName = o.Name }
).Skip(pageIndex * pageSize).Take(pageSize);
result.total = total;
result.data = customs;
var json = JsonConvert.SerializeObject(result);
return json;
}
}
public object Login(string UserName, string Password)
{
using (var db = new WeeklyEntities())
{
//用户名密码检查
if (String.IsNullOrEmpty(UserName) || String.IsNullOrEmpty(Password))
return new { status = "error", message = "用户名或密码不能为空" };
//用户名密码验证
var q = from u in db.Emps
select u;
q = q.Where(p => p.LoginName == UserName);
q = q.Where(p => p.Pwd == Password);
var list = q.ToList();
if (list.Count == 0)
return new { status = "error", message = "用户名或密码不正确！" };
//调用框架中的登陆机制
var loginer = new LoginerBase
{
UserID = list[0].Id,
RoleId = list[0].RoleId == null ? 0 : (int)list[0].RoleId,
LoginName = list[0].LoginName,
Name = list[0].Name,
OrganizationId = list[0].OrganizationId == null ? 0 : (int)list[0].OrganizationId,
OrganizationName = list[0].Organization.Name
};
var effectiveHours = ZConfig.GetConfigInt("LoginEffectiveHours");
FormsAuth.SignIn(loginer.LoginName, loginer, 60 * effectiveHours);
LF.Utils.ZCookies.WriteCookies("UserID", 0, list[0].Id.ToString());
return new { status = "success", message = "登陆成功！", url = "/Home" };
}
}
