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());
}
