/// <summary>
/// 批量删除
/// </summary>
public ResultSet DeleteList(string where)
{
Func<string, ResultStatus> validate = (_where) =>
{
if (String.IsNullOrEmpty(_where))
return new ResultStatus()
{
Code = StatusCollection.ParameterError.Code,
Description = "参数 where 不能为空",
Success = false
};
return new ResultStatus();
};
Func<string,ResultStatus> op = (_where) =>
{
int ret = new ProductDal().DeleteList(_where);
if (ret > 0)
return new ResultStatus();
else
return new ResultStatus()
{
Success = false,
Code = StatusCollection.UpdateFailed.Code,
Description = StatusCollection.UpdateFailed.Description
};
};
return HandleBusiness(where, op, validate);
}
/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(Product entity)
{
Func<Product, ResultStatus> validate = (_entity) =>
{
return new ResultStatus();
};
Func<Product, ResultStatus> op = (_entity) =>
{
int ret = new ProductDal().Add(entity);
if (ret > 0)
return new ResultStatus();
else
return new ResultStatus()
{
Success = false,
Code = StatusCollection.AddFailed.Code,
Description = StatusCollection.AddFailed.Description
};
};
return HandleBusiness(entity, op, validate);
}
/// <summary>
/// 更新
/// </summary>
public ResultSet Update(string fields, object param, string where)
{
Func<string, object, string, ResultStatus> validate = (_fields, _param, _where) =>
{
if (String.IsNullOrEmpty(_fields))
return new ResultStatus()
{
Code = StatusCollection.ParameterError.Code,
Description = "参数 fields 不能为空",
Success = false
};
if (_param == null)
return new ResultStatus()
{
Code = StatusCollection.ParameterError.Code,
Description = "参数 param 不能为空",
Success = false
};
return new ResultStatus();
};
Func<string, object, string, ResultStatus> op = (_fields, _param, _where) =>
{
int ret = new ProductDal().Update(_fields, _param, _where);
if (ret > 0)
return new ResultStatus();
else
return new ResultStatus()
{
Success = false,
Code = StatusCollection.UpdateFailed.Code,
Description = StatusCollection.UpdateFailed.Description
};
};
return HandleBusiness(fields, param, where, op, validate);
}
/// <summary>
/// 连表获取产品
/// </summary>
/// <param name="fields"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="where"></param>
/// <param name="param"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public ResultSet<Page<Product>> GetJoinAll(string fields, int pageIndex, int pageSize, string where, object param, string orderBy)
{
Func<string, int, int, string, object, string, ResultStatus> validate = (_fields, _pageIndex, _pageSize, _where, _param, _orderBy) =>
{
if (_pageIndex <= 0)
return new ResultStatus()
{
Code = StatusCollection.ParameterError.Code,
Description = "参数 pageIndex 必须大于0",
Success = false
};
if (_pageSize <= 0 || _pageSize > 100)
return new ResultStatus()
{
Code = StatusCollection.ParameterError.Code,
Description = "参数 pageSize 必须大于0，且小于等于100",
Success = false
};
return new ResultStatus();
};
Func<string, int, int, string, object, string, Page<Product>> op = (_fields, _pageIndex, _pageSize, _where, _param, _orderBy) =>
{
int recordCount = 0;
IList<Product> list = new ProductDal().GetJoinAll(_fields, _pageIndex, _pageSize, _where, _param, _orderBy, out recordCount);
return new Page<Product>(_pageIndex, _pageSize, recordCount, list);
};
return HandleBusiness(fields, pageIndex, pageSize, where, param, orderBy, op, validate);
}