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()); } }