public ResponseMessage <IEnumerable <UserInfo> > Get(int pageIndex, int pageSize) { int total = 0; var result = _us.FindList(e => true, o => o.Id, out total, true, pageIndex, pageSize); return(CreateResult.For(result, total)); }
public ResponseMessage <List <Guid> > Get(int pageIndex, int pageSize) { int total = 0; var result = _adminService.LoadEntities(e => true, o => o.Id, "asc", pageIndex, pageSize, out total).Select(e => e.Id).ToList(); return(CreateResult.For(result, total)); }
public ResponseMessage <object> TeacherTestTrans_D() { dynamic result; var teacher = new T_Teacher() { F_TeacherName = $"Test_{ (DateTime.Now.Ticks - 621356256000000000) / 10000}" }; var bl = _SqlDB.ExecuteWithTransaction((conn, trans) => { var r = conn.Execute($"INSERT INTO T_Teacher (F_TeacherName) VALUES(@F_TeacherName);", teacher, trans, null, null); r += conn.Execute("delete from T_Teacher where f_id=@id", new { id = 1 }, trans, null, null); return(r); }); if (bl) { result = CreateResult.For(); } else { result = CreateResult.For("00001", "新增出现错误"); } return(result); }
public ResponseMessage <List <AEmployee> > Get() { var list = _employeeService.LoadEntities(e => true).Select(e => new AEmployee { Id = e.Id, Name = e.Name }).ToList(); return(CreateResult.For(list)); }
public ResponseMessage <IEnumerable <Dictionary <string, string> > > Get() { var list = from c in User.Claims select new Dictionary <string, string> { { c.Type, c.Value } }; return(CreateResult.For(list)); }
public ResponseMessage <List <T_Teacher> > GetTeachersList_D() { dynamic result; var list = _SqlDB.Query <T_Teacher>("SELECT * FROM T_Teacher"); result = CreateResult.For(list, list.Count); return(result); }
public ResponseMessage <List <TTeacher> > GetTeachersList() { dynamic result; var list = _dbContext.TTeacher.ToList(); result = CreateResult.For(list, list.Count); return(result); }
public ResponseMessage <T_Teacher> GetTeachersListById_D(int id) { //LogHelper.Info("测试GetTeachersListById_D"); dynamic result; var m = _SqlDB.QueryFirst <T_Teacher>("SELECT * FROM T_Teacher WHERE F_ID =@id", new { id }); result = CreateResult.For(m); return(result); }
public ResponseMessage <List <T_Teacher> > GetTeachersListByName_D(string name) { dynamic result; var list = _SqlDB.Query <T_Teacher>("SELECT * FROM T_Teacher WHERE F_TeacherName LIKE @name", new { name = "%" + name + "%" }); result = CreateResult.For(list, list.Count); return(result); }
public ResponseMessage <object> InsertTeacher_D() { dynamic result; var teacher = new T_Teacher() { F_TeacherName = $"Test_{ (DateTime.Now.Ticks - 621356256000000000) / 10000}" }; var n = _SqlDB.Excute($"INSERT INTO T_Teacher (F_TeacherName) VALUES(@F_TeacherName)", teacher); if (n > 0) { result = CreateResult.For(); } else { result = CreateResult.For("00001", "新增出现错误"); } return(result); }
public ResponseMessage <List <T_Class> > GetClassAndTeachersListByName_D(string name) { dynamic result; var e = new Dictionary <int, T_Class>(); var list = _SqlDB.Query <T_Class, T_Teacher, T_Class>(@"SELECT * FROM T_Class AS c JOIN T_Teacher AS t ON c.F_TID=t.F_ID WHERE c.F_ClassName LIKE @name", map: (c, t) => { T_Class entity; if (!e.TryGetValue(c.F_ID.Value, out entity)) { entity = c; entity.Teacher = t; } return(entity); }, param: new { name = "%" + name + "%" }, splitOn: "F_TID"); result = CreateResult.For(list, list.Count); return(result); }
public ResponseMessage <object> DELETE(int id) { _us.DelByQuery(e => id == e.Id); return(CreateResult.For()); }
public ResponseMessage <object> PUT(UserInfo ui) { _us.Update(ui); return(CreateResult.For()); }
public ResponseMessage <object> Post(UserInfo ui) { _us.Add(ui); return(CreateResult.For()); }