/// <summary>
/// Select
/// </summary>
/// <param name="sysAreaQuery"></param>
/// <param name="DataCount"></param>
/// <param name="ErrorMsg"></param>
/// <returns></returns>
public List <SysAreaVm> Select(SysAreaQuery sysAreaQuery, ref int DataCount, ref string ErrorMsg)
{
try
{
SelectInfo <SysArea> selectInfo = new SelectInfo <SysArea>("SysArea");
Expression <Func <SysArea, bool> > predicate = null;
var DbRequest = selectInfo
.SetWhere(predicate, DataBaseType.SqlServer, DataDeleteFlag.IsNotDelete)
.SetType(TableType.Table)
.OrderBy(EF => EF.CreateTime)
.OrderByDescending(EF => EF.ObjectId)
.Check(ref erolt)
.Run <SysAreaVm>(db, erolt);
//selectInfo
// .GetById("123")
// .Run();
//var DbRequest = selectInfo.SetSqlStr("select * from SysArea").Run<SysAreaVm>();
//var DbRequest = DbContextExtensions.Query<SysAreaVm>(new MSSqlDBContext(), new DbContextSqlQueryCommands
//{
// Sql = sql
//}).ToList();
//ErrorMsg = "Select Success";
return(DbRequest);
}
catch (Exception ex)
{
ErrorMsg = "Select Error";
return(null);
}
}
public IActionResult SelectJson([FromBody] SysAreaQuery sysAreaQuery)
{
string ErrorMsg = string.Empty;
int DataCount = 0;
var flag = sysAreaService.SelectJson(sysAreaQuery, ref DataCount, ref ErrorMsg);
if (flag != null)
{
return(new JsonResult(
ResponseHelper.IsSuccess_Msg_Data_HttpCode(ErrorMsg, flag, DataCount)
));
}
else
{
return(new JsonResult(
ResponseHelper.Error_Msg_Ecode_Elevel_HttpCode(ErrorMsg, flag)
));
}
}
/// <summary>
/// SelectJson
/// </summary>
/// <param name="sysAreaQuery"></param>
/// <param name="DataCount"></param>
/// <param name="ErrorMsg"></param>
/// <returns></returns>
public string SelectJson(SysAreaQuery sysAreaQuery, ref int DataCount, ref string ErrorMsg)
{
return(null);
}