public ObservableCollection <ChartPart> GetValuesGroupedBySubCategory()
{
DateTime minDate = new DateTime(2016, 1, 1);
DateTime maxDate = DateTime.Today;
return(new ObservableCollection <ChartPart>(StatisticsDal.GetExpensesFromCategoryGroupedBySubCategoryInRange(minDate, maxDate, Tag)));
}
/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(Statistics entity)
{
Func <Statistics, ResultStatus> validate = (_entity) =>
{
return(new ResultStatus());
};
Func <Statistics, ResultStatus> op = (_entity) =>
{
int ret = new StatisticsDal().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 StatisticsDal().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));
}
#endregion
#region Extend
#endregion
}
}
/// <summary>
/// 获取所有
/// </summary>
public ResultSet <Page <Statistics> > GetAll(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 <Statistics> > op = (_fields, _pageIndex, _pageSize, _where, _param, _orderBy) =>
{
int recordCount = 0;
IList <Statistics> list = new StatisticsDal().GetAll(_fields, _pageIndex, _pageSize, _where, _param, _orderBy, out recordCount);
return(new Page <Statistics>(_pageIndex, _pageSize, recordCount, list));
};
return(HandleBusiness(fields, pageIndex, pageSize, where, param, orderBy, op, validate));
}
