public Results CreateType(Guid id, string name, int inOrOut, DateTime createOn, Guid createBy, string remark)
{
if (StringHelper.IsNullOrEmptyOrWhiteSpace(name))
{
return(new Results("类型名不能为空"));
}
TypesModel model = new TypesModel();
model.Id = id;
model.Name = name;
model.InOrOut = inOrOut;
model.CreateOn = createOn;
model.CreateBy = createBy;
model.Remark = remark;
return(_typesDapper.Create(model));
}
public Results CreateFromCsv(Guid memberShipId, string path)
{
//判断是不是有类型Type
Guid typeOutId = Guid.Empty;
var typeOut = _typesDapper.GetTypeByName("支付宝支出").ToList();
if (typeOut.Count < 1)
{
TypesModel typeOutModel = new TypesModel();
typeOutModel.Id = Guid.NewGuid();
typeOutModel.InOrOut = 1;
typeOutModel.CreateBy = memberShipId;
typeOutModel.CreateOn = DateTime.Now;
typeOutModel.Name = "支付宝支出";
var createTypeOutResult = _typesDapper.Create(typeOutModel);
if (createTypeOutResult.Success)
{
typeOutId = typeOutModel.Id;
}
else
{
return(new Results("创建类型失败"));
}
}
else
{
typeOutId = typeOut[0].Id;
}
Guid typeInId = Guid.Empty;
var typeIn = _typesDapper.GetTypeByName("支付宝收入").ToList();
if (typeIn.Count < 1)
{
TypesModel typeInModel = new TypesModel();
typeInModel.Id = Guid.NewGuid();
typeInModel.InOrOut = 0;
typeInModel.CreateBy = memberShipId;
typeInModel.CreateOn = DateTime.Now;
typeInModel.Name = "支付宝收入";
var createTypeInResult = _typesDapper.Create(typeInModel);
if (createTypeInResult.Success)
{
typeInId = typeInModel.Id;
}
else
{
return(new Results("创建类型失败"));
}
}
else
{
typeInId = typeIn[0].Id;
}
//添加数据
var dt = FileHelper.OpenCSV(path);
var length = dt.Rows.Count;
var type1 = dt.Rows[2][10].ToString();
List <RecordsModel> list = new List <RecordsModel>();
for (int i = 0; i < length; i++)
{
if (!StringHelper.IsNullOrEmptyOrWhiteSpace(dt.Rows[i][10].ToString()))
{
RecordsModel model = new RecordsModel();
model.Id = Guid.NewGuid();
model.Money = decimal.Parse(dt.Rows[i][9].ToString());
model.Remark = dt.Rows[i][8].ToString();
model.CreateBy = memberShipId;
model.CreateOn = StringHelper.DateTimeConver(dt.Rows[i][2].ToString().Split(' ')[0]);
model.Source = "支付宝";
var type = dt.Rows[i][10].ToString().TrimEnd();
if (type == "收入")
{
model.TypeId = typeInId;
}
if (type == "支出")
{
model.TypeId = typeOutId;
}
list.Add(model);
}
}
foreach (var item in list)
{
_recordDapper.Create(item);
}
return(new Results());
}