public int UpdDState([FromForm] string m)
{
LMS_ShouJi model = JsonConvert.DeserializeObject <LMS_ShouJi>(m);
if (model == null)
{
return(0);
}
else
{
var d = db.LMS_Ding.Find(model.SJId);
db.Entry(d).State = EntityState.Modified;
d.DSzt = 11;
var a = Convert.ToInt32(d.DFMoney) / Convert.ToInt32(d.DCount);
var b = DateTime.Now;
using (IDbConnection db = new SqlConnection(conn))
{
for (int i = 1; i <= d.DCount; i++)
{
b = b.AddMonths(1);
string sql1 = $"insert into RepaymentSchedule values({i},'{DateTime.Now}',{a},{a * d.DLi / 100},{0},{a + a * d.DLi / 100},{0},'{b}',{d.DId})";
db.Execute(sql1);
}
}
db.LMS_ShouJi.Add(model);
return(db.SaveChanges());
}
}
public int Add([FromForm] string m)
{
LMS_ShouJi model = JsonConvert.DeserializeObject <LMS_ShouJi>(m);
if (model == null)
{
return(0);
}
else
{
db.LMS_ShouJi.Add(model);
return(db.SaveChanges());
}
}
public int Xiu2([FromForm] string m)
{
LMS_ShouJi model = JsonConvert.DeserializeObject <LMS_ShouJi>(m);
if (model == null)
{
return(0);
}
else
{
var d = db.LMS_Ding.Find(model.SJId);
db.Entry(d).State = EntityState.Modified;
d.DSzt += 2;
db.LMS_ShouJi.Add(model);
return(db.SaveChanges());
}
}
