public JsonResponse AddAccount([FromBody] AccountDto dto)
{
//判断用户是否登录
if (!TokenHelper.CheckLoginStateByUserId(dto.UserId))
{
return(BadResponse("用户未登录", null, false));
}
string sql = "INSERT INTO " + dto.TableName + " VALUES ";
foreach (Account model in dto.List)
{
//(
sql += "(";
//RecorderId
sql += ("'" + model.RecorderId + "',");
//UserId
sql += ("'" + model.UserId + "',");
//CreateDate
sql += ("'" + DateTime.Now + "',");
//Money
sql += ("" + model.Money + ",");
//Category
sql += ("'" + model.Category + "',");
//Note
sql += ("'" + model.Note + "'");
//)
sql += "),";
}
sql = sql.Substring(0, sql.Length - 1);
if (!BaseBll <Account> .ExecuteSql(sql))
{
BadResponse("添加失败！");
}
return(OkResponse(null, "添加成功！"));
}
public JsonResponse AddAccountList([FromBody] AccountListDto dto)
{
//判断用户是否登录
if (!TokenHelper.CheckLoginStateByUserId(dto.UserId))
{
return(BadResponse("用户未登录", null, false));
}
string accountName = "我的手账";
//若用户没有写账单名则默认为“我的手账”；若有“我的手账”则命名为“我的手账1”
if (dto.Name != null && dto.Name != "")
{
List <AccountList> accountList = AccountListBll.GetListByCreateUserId(dto.UserId).ToList();
int flag = 1;
for (int i = 0; i < accountList.Count; i++)
{
if (accountList[i].Name == accountName)
{
accountName = (accountName + flag.ToString());
flag++;
}
}
}
else
{
accountName = dto.Name;
}
//往AccountList写账单基本信息
DateTime time = DateTime.Now;
AccountList model = new AccountList
{
AllUserId = dto.AllUserId,
Code = "Z" + (time.Year - 2000).ToString() + time.Month.ToString() + time.Day.ToString()
+ TokenHelper.GetRandomString(3, false, true, true, false, "") + TokenHelper.GetRandomString(5, true, true, true, false, ""),
CreateDate = time,
CreateUserId = dto.UserId,
Member = dto.AllUserId.Split(',').Length,
Name = accountName
};
//新建账单表
if (BaseBll <AccountList> .ExecuteSql("exec proc_CreateAccountTable '" + model.Code + "'") &&
AccountListBll.Insert(model))
{
return(OkResponse(null, "添加成功！"));
}
else
{
return(BadResponse("添加失败！", null));
}
}
