public void Update(string functionId, string administratorId, IList <string> tableColumnIds) { using (var dal = new BaseDal()) { var list = dal.TableColumnAndAdmin.Where(o => ((o.FunctionId == functionId) && (o.AdministratorId == administratorId))); var tableColumnList = dal.TableColumn.Where(o => o.FunctionId == functionId); dal.TableColumnAndAdmin.RemoveRange(list); foreach (var p in tableColumnIds) { var tableColumn = tableColumnList.SingleOrDefault(o => o.TableColumnId == p); if (tableColumn == null) { continue; } dal.TableColumnAndAdmin.Add(new TableColumnAndAdminDefinition() { TableColumnId = p, FunctionId = functionId, AdministratorId = administratorId, }); } dal.SaveChanges(); } }
public IList <FunctionDefinition> QueryParentOrderByName() { using (var dal = new BaseDal()) { return(dal.Function.Where(o => o.ParentId == "0").OrderBy(o => o.Name).ToList()); } }
public IList <FunctionDefinition> QueryByParentId(string id) { using (var dal = new BaseDal()) { return((from o in dal.Function where o.ParentId == id select o).ToArray()); } }
public IList <LogDefinition> QueryNearN(int n) { using (var dal = new BaseDal()) { return(dal.Log.OrderByDescending(o => o.UpdateDateTime).Take(n).ToList()); } }
public FunctionDefinition FindByPage(string page) { using (var dal = new BaseDal()) { return(dal.Function.Single(o => o.Page == page)); } }
public string GetValue(string configName, string defaultValue) { if (string.IsNullOrEmpty(defaultValue)) { throw new Exception(string.Format("配置项{0}不能为空", configName)); } using (var dal = new BaseDal()) { var p = dal.Config.Find(configName); if (p == null) { dal.Config.Add(new ConfigDefinition() { Name = configName, Value = defaultValue, Comment = "" }); dal.SaveChanges(); return(defaultValue); } else { if (string.IsNullOrEmpty(p.Value)) { throw new Exception(string.Format("配置项{0}不能为空", p.Name)); } return(p.Value); } } }
public bool HasByFunctionId(string functionId) { using (var dal = new BaseDal()) { return(dal.TableColumn.Any(o => o.FunctionId == functionId)); } }
public IList <TableColumnDefinition> QueryByFunctionIdAndVisible(string functionId) { using (var dal = new BaseDal()) { return(dal.TableColumn.Where(o => (o.FunctionId == functionId) && (o.Visible)).OrderBy(o => o.Index).ToList()); } }
public TableColumnDefinition FindByFunctionIdTableColumnId(string functionId, string tableColumnId) { using (var dal = new BaseDal()) { return(dal.TableColumn.SingleOrDefault(o => o.FunctionId == functionId && (o.TableColumnId == tableColumnId))); } }
public IList <CommandDefinition> QueryByFunctionId(string functionId) { using (var dal = new BaseDal()) { return(dal.Command.Where(o => o.FunctionId == functionId).OrderBy(o => o.Index).ToList()); } }
public void Update(string roleId, IList <string> functionIds, IList <string> commandIds) { using (var dal = new BaseDal()) { var oldRoleAndFunction = dal.RoleAndFunction.Where(o => o.RoleId == roleId); dal.RoleAndFunction.RemoveRange(oldRoleAndFunction); var oldRoleAndCommand = dal.RoleAndCommand.Where(o => o.RoleId == roleId); dal.RoleAndCommand.RemoveRange(oldRoleAndCommand); foreach (var p in functionIds) { dal.RoleAndFunction.Add(new RoleAndFunctionDefinition() { RoleId = roleId, FunctionId = p }); } foreach (var p in commandIds) { dal.RoleAndCommand.Add(new RoleAndCommandDefinition() { RoleId = roleId, CommandId = p }); } dal.SaveChanges(); } }
public IList <GrainDefinition> QueryByGrainTypeId(int grainTypeId) { using (var dal = new BaseDal()) { return(dal.Grain.Where(o => o.GrainTypeId == grainTypeId).ToList()); } }
public IList <string> QueryTableColumnIdByAdministratorIdFunctionId(string administratorId, string functionId) { using (var dal = new BaseDal()) { return(dal.TableColumnAndAdmin.Where(o => ((o.AdministratorId == administratorId) && (o.FunctionId == functionId))).Select(o => o.TableColumnId).ToList()); } }
public IList <FunctionDefinition> QueryDisplay() { using (var dal = new BaseDal()) { return(dal.Function.Where(o => o.Display).OrderBy(o => o.Postion).ToList()); } }
public virtual IList <T> Query() { using (var bll = new BaseDal()) { return((from o in bll.Set <T>() select o).AsNoTracking().ToList()); } }
public AdministratorDefinition FindByAccounts(string accounts) { using (var dal = new BaseDal()) { return(dal.Administrator.SingleOrDefault(o => o.Accounts == accounts)); } }
public T Find(params object[] p) { using (var bll = new BaseDal()) { return(bll.Set <T>().Find(p)); } }
public IList <RoleAndFunctionDefinition> QueryByRoleId(string roleId) { using (var dal = new BaseDal()) { return(dal.RoleAndFunction.Where(o => o.RoleId == roleId).ToList()); } }
public virtual void Add(T p) { using (var bll = new BaseDal()) { bll.Set <T>().Add(p); bll.SaveChanges(); } }
public virtual void Update(T p) { using (var bll = new BaseDal()) { bll.Entry(p).State = EntityState.Modified; bll.SaveChanges(); } }
public virtual void Remove(T p) { using (var bll = new BaseDal()) { bll.Set <T>().Attach(p); bll.Set <T>().Remove(p); bll.SaveChanges(); } }
//public void ExecuteNonQuery(string sql) //{ // using (var dal = new BaseDal()) // { // dal.Database.ExecuteNonQuery(sql); // } //} public void Clear() { using (var dal = new BaseDal()) { var list = (from o in dal.Set <T>() select o).ToList(); dal.Set <T>().RemoveRange(list); dal.SaveChanges(); } }
public void RemoveById(string functionId) { using (var dal = new BaseDal()) { var p = dal.Function.Find(functionId); dal.Function.Remove(p); dal.SaveChanges(); } }
public IList <ZkGetOrderDefinition> QueryByParam(QueryByParamIn param) { using (var dal = new BaseDal()) { var list = from o in dal.ZkGetOrder where (true)select o; param.Total = list.Count(); list = from o in list orderby o.ManufacturingDate select o; list = list.Skip((param.Page - 1) * param.Rows).Take(param.Rows); return((list).ToList()); } }
public void SetValue(string configName, string value) { GetValue(configName, value); using (var dal = new BaseDal()) { var p = dal.Config.Find(configName); p.Value = value; dal.Entry(p).State = EntityState.Modified; dal.SaveChanges(); } }
public IList <TableColumnDefinition> QueryByAdministratorIdFunctionIdAndVisible(string administratorId, string functionId) { using (var dal = new BaseDal()) { var list = from tableColumn in dal.TableColumn from tableColumnAndAdmin in dal.TableColumnAndAdmin where ((tableColumn.FunctionId == tableColumnAndAdmin.FunctionId) && (tableColumn.TableColumnId == tableColumnAndAdmin.TableColumnId) && (tableColumnAndAdmin.AdministratorId == administratorId) && (tableColumnAndAdmin.FunctionId == functionId) && (tableColumn.Visible)) select tableColumn; return(list.ToList().OrderBy(o => o.Index).ToList()); } }
public void DeleteByFunctionId(string functionId) { using (var dal = new BaseDal()) { var list = dal.TableColumnAndAdmin.Where(o => o.FunctionId == functionId).ToList(); if (list.Count() > 0) { dal.TableColumnAndAdmin.RemoveRange(list); dal.SaveChanges(); } } }
public IList <FunctionDefinition> QueryDisplayByRoleId(string roleId) { using (var dal = new BaseDal()) { var tree = from item in dal.Function join roleAndFunction in dal.RoleAndFunction on item.FunctionId equals roleAndFunction.FunctionId where ((item.Display) && (item.FunctionId == roleAndFunction.FunctionId) && (roleAndFunction.RoleId == roleId)) select item; return((tree).ToList()); } }
public IList <GranariesDefinition> QueryByParam1(QueryByParam1In param) { //param.BeginDateTime = param.BeginDateTime.Date; //param.EndDateTime = param.EndDateTime.AddDays(1); using (var dal = new BaseDal()) { var list = from o in dal.Granaries where (true)select o; param.Total = list.Count(); list = from o in list orderby o.GranariesName select o; list = list.Skip((param.Page - 1) * param.Rows).Take(param.Rows); return((list).ToList()); } }
public IList <LogDefinition> QueryByParam1(QueryByParam1In param) { param.BeginDateTime = param.BeginDateTime.Date; param.EndDateTime = param.EndDateTime.AddDays(1); using (var dal = new BaseDal()) { var list = from o in dal.Log where ((o.UpdateDateTime >= param.BeginDateTime) && (o.UpdateDateTime < param.EndDateTime)) select o; param.Total = list.Count(); list = from o in list orderby o.UpdateDateTime select o; list = list.Skip((param.Page - 1) * param.Rows).Take(param.Rows); return((list).ToList()); } }