public IHttpActionResult Get(ODataQueryOptions <CODE_TITLEEntity> odataQueryOptions)
{
Expression <Func <CODE_TITLEEntity, bool> > myfilter = null;
if (odataQueryOptions.Filter != null)
{
myfilter = odataQueryOptions.Filter.ToExpression <CODE_TITLEEntity>();
}
try
{
CODE_TITLEService service = new CODE_TITLEService();
object id;
var expression = LinqExtensions.True <CODE_TITLEEntity>();
if (myfilter != null)
{
expression = expression.And(myfilter);
}
var query = service.IQueryRecord(expression).ToList();
return(Ok(query.AsQueryable()));
}
catch (Exception)
{
return(NotFound());
}
}
public IHttpActionResult Patch([FromODataUri] string key, Delta <CODE_TITLEEntity> patch)
{
CODE_TITLEService service = new CODE_TITLEService();
object id;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (patch.GetChangedPropertyNames().Contains("TITLEID") && patch.TryGetPropertyValue("TITLEID", out id) && (string)id != key)
{
return(BadRequest("The key from the url must match the key of the entity in the body"));
}
try
{
var query = service.GetEntity(key);
patch.Patch(query);
service.UpdateEntity(query);
return(Updated(query));
}
catch (Exception)
{
return(NotFound());
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public IHttpActionResult Delete([FromODataUri] string key)
{
CODE_TITLEService service = new CODE_TITLEService();
try
{
service.PhysicalDelRecord(key);
return(Ok(true));
}
catch (Exception)
{
return(Ok(false));
}
}
public IHttpActionResult RecordPagination(Pagination pagination)
{
CODE_TITLEService service = new CODE_TITLEService();
try
{
var query = service.RecordPagination(pagination);
var packageEntity = query.PackageEntityPaginations(pagination);
return(Json(packageEntity));
}
catch (Exception)
{
PackageResultEntity <object> packageResultEntity = new PackageResultEntity <object>()
{
list = null,
msg = "failed"
};
return(Json(packageResultEntity));
}
}
public IHttpActionResult RecordQuery(string key)
{
CODE_TITLEService service = new CODE_TITLEService();
try
{
var query = service.GetEntity(key.ToString());
var packageEntity = query.PackageResult();
return(Json(packageEntity));
}
catch (Exception)
{
PackageResultEntity <object> packageResultEntity = new PackageResultEntity <object>()
{
list = null,
msg = "failed"
};
return(Json(packageResultEntity));
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="model"></param>
public void Post(CODE_TITLEEntity model)
{
CODE_TITLEService service = new CODE_TITLEService();
service.SaveEntity(model);;
}
/// <summary>
/// 更新数据，幂等
/// </summary>
/// <param name="key"></param>
/// <param name="model"></param>
public void Put([FromODataUri] string key, CODE_TITLEEntity model)
{
CODE_TITLEService service = new CODE_TITLEService();
service.UpdateEntity(model);
}