public async Task History()
{
var para = this.ParaForm <AssetM>();
List <AssetM> data = AssetBll.HistoryList(para);
if (data.Count == 0)
{
await this.Json(new { errmsg = para.ErrorMsg, errcode = para.ErrorCode });
return;
}
// 返回字段按需设定
var redata = AllFieldList(data);
// 按需字段列表
if (!string.IsNullOrWhiteSpace(para.Fields) && para.Fields.Split(',').Length > 0)
{
var list = SerializeHelp.ObjectsToDicts(redata, para.Fields.Split(','));
await this.Json(new { list, errcode = ErrCode.Success });
return;
}
// 所有字段
await this.Json(new { list = redata, errcode = ErrCode.Success });
}
public async Task Add()
{
AssetM para = this.ParaForm <AssetM>();
AssetBll.Add(para);
await this.Json(new { errcode = para.ErrorCode, errmsg = para.ErrorMsg });
}
public void HistoryList()
{
AssetM para = new AssetM();
para.Id = "5ce71c0d131f46cf9c36d1d68e48b763";
List <AssetM> data = AssetBll.HistoryList(para);
foreach (var item in data)
{
log.WriteLine(item.Title);
log.WriteLine(item.Ctime.ToString());
log.WriteLine(item.ItemCode);
log.WriteLine("-------------");
}
}
public async Task Item()
{
var para = this.ParaForm <AssetM>();
AssetM data = AssetBll.GetById(para);
if (data == null)
{
await this.Json(new { errmsg = para.ErrorMsg, errcode = para.ErrorCode });
return;
}
// 返回字段
var redata = new
{
data.Id,
data.Title,
data.Code,
data.Amount,
data.Value,
data.Positions,
data.Price,
data.Remark,
data.Profit,
data.ExcOrg,
data.Kind,
data.Risk,
ValueDate = data.ValueDate.ToString("yyyy/MM/dd HH:mm"),
ExpDate = data.ExpDate.ToString("yyyy/MM/dd HH:mm"),
data.Rate,
data.Action,
Ctime = data.Ctime.ToString("yyyy/MM/dd HH:mm"),
data.ItemCode
};
// 按需字段列表
if (!string.IsNullOrWhiteSpace(para.Fields) && para.Fields.Split(',').Length > 0)
{
var list = SerializeHelp.ObjectToDict(redata, para.Fields.Split(','));
await this.Json(new { list, errcode = ErrCode.Success });
return;
}
await this.Json(new { item = redata, errcode = ErrCode.Success });
}
public async Task TotalUp()
{
AssetM data = AssetBll.TotalUp();
if (data.ErrorCode >= 300)
{
await this.Json(new { errcode = data.ErrorCode, errmsg = data.ErrorMsg });
return;
}
var redata = new
{
date = data.TotalDate,
time = data.Ctime.ToString("yyyy/MM/dd HH:mm:ss"),
errcode = data.ErrorCode
};
await this.Json(redata);
}
public async Task Titles()
{
var para = this.ParaForm <AssetM>();
List <AssetM> data = AssetBll.HistoryTitles(para);
if (data.Count == 0)
{
await this.Json(new { errmsg = para.ErrorMsg, errcode = para.ErrorCode });
return;
}
// 字段
var redata = data.Select(o => new
{
o.Title,
o.Id
});
await this.Json(new { list = redata, errcode = 200 });
}
public async Task Statistic()
{
AssetM data = AssetBll.ValueTotal();
if (data.ErrorCode != 200)
{
await this.Json(new { errcode = 301, errmsg = data.ErrorMsg });
return;
}
// 风险等级
Dictionary <string, object>[] byRisk = AssetBll.ValueTotalByRisk();
// 机构
List <AssetM> byExcOrg = AssetBll.ValueTotalByExcOrg();
// 资产类型
List <AssetM> byKind = AssetBll.ValueTotalByKind();
// 近30更新日总值
List <AssetM> lasttotal30 = AssetBll.Last30TotalVal();
// 历史最高/低
AssetM[] maxmin = AssetBll.ValueMaxMinOfHis();
var redata = new
{
data.Value,
byRisk = data.Value == 0 ? null : byRisk,
byExcOrg = byExcOrg == null ? null :
SerializeHelp.ObjectsToDicts(byExcOrg, nameof(AssetM.ExcOrg), nameof(AssetM.Value)),
byKind = byKind == null ? null :
SerializeHelp.ObjectsToDicts(byKind, nameof(AssetM.Kind), nameof(AssetM.Value)),
lasttotal30 = lasttotal30 == null ? null :
SerializeHelp.ObjectsToDicts(lasttotal30, nameof(AssetM.Value), nameof(AssetM.TotalDate)),
max = maxmin[0] == null ? null : new { maxmin[0].Value, maxmin[0].TotalDate },
min = maxmin[1] == null ? null : new { maxmin[1].Value, maxmin[1].TotalDate },
errcode = data.ErrorCode
};
await this.Json(redata);
}
