/// <summary>
///根据条件删除
/// </summary>
public bool DeleteList(a_shebei Query)
{
#region 关键字过滤 ;
//string 类型需要过滤 ;
//Query.name = "%" + StaticBase.KeyFilter(Query.name) + "%";
#endregion ;
ResultView rv = respository.DeleteList <a_shebei>(" where id = @id ", Query);
if (rv.Result == 1)
{
return(true);
}
return(false);
}
/// <summary>
///根据条件查询列表
/// </summary>
public List <a_shebei> SearchList(a_shebei Query)
{
#region 关键字过滤 ;
//string 类型需要过滤 ;
//Query.name = "%" + StaticBase.KeyFilter(Query.name) + "%";
#endregion ;
ResultView rv = respository.GetList <a_shebei>(" where id = @id ", Query);
if (rv.Result == 1)
{
return(rv.Info);
}
return(null);
}
/// <summary>
///分页查询列表
/// </summary>
/// <param name="Query">查询条件</param>
/// <param name="pageindex">第几页</param>
/// <param name="pagecount">每页条数</param>
public AShebei_View SearchListPage(a_shebei Query, int pageindex = 1, int pagecount = 10)
{
AShebei_View model = new AShebei_View();
#region 关键字过滤 ;
//string 类型需要过滤 ;
//Query.name = "%" + StaticBase.KeyFilter(Query.name) + "%";
#endregion ;
var rv = respository.GetListPage <a_shebei>(pageindex, pagecount, "where id = @id ", "id", Query);
model.pagecount = rv.RecordCount;
model.AShebei_list = rv.ContentList;
if (model.AShebei_list == null)
{
model.AShebei_list = new List <a_shebei>();
}
return(model);
}
/// <summary>
///查询数据总条数（分页使用)
/// </summary>
/// <param name="Query">查询条件</param>
public int SearchListPageCount(a_shebei Query)
{
PageInfo model = new PageInfo();
#region 关键字过滤 ;
//string 类型需要过滤 ;
//Query.name = "%" + StaticBase.KeyFilter(Query.name) + "%";
#endregion ;
var rv = respository.ExecuteScalar <PageInfo>("select count(1) as Count from a_shebei where id = @id ", Query);
if (rv.Result == 1)
{
model.Count = rv.Info;
}
if (model == null)
{
return(0);
}
return(model.Count);
}
