public int UptDate(Model.Bargain Model) { string sql = $"UPDATE Bargain set CommodityId={Model.CommodityId},PeopleNum={Model.PeopleNum},KNum={Model.KNum},BeginDate='{Model.BeginDate}',EndDate='{Model.EndDate}',Astrict={Model.Astrict},ActionState={Model.ActionState},PartNum={Model.PartNum},MinPrice={Model.MinPrice}, SurplusNum ={Model.SurplusNum},SurplusBargain={Model.SurplusBargain},BargainName='{Model.BargainName}',BargainRemark='{Model.BargainRemark}',Template={Model.Template},LimitNum={Model.LimitNum},BargainSum ={Model.BargainSum} where BargainId={Model.BargainId}"; string sql2 = $"insert into Lognote values (NULL,'修改',NOW(),'Bargain砍价表');"; DapperHelper.Execute(sql2); return(DapperHelper.Execute(sql)); }
public int Insert(Model.Bargain Model) { string sql = $"insert into Bargain VALUES (null,{Model.CommodityId},{Model.PeopleNum},{Model.KNum},'{Model.BeginDate}','{Model.EndDate}',{Model.Astrict},{Model.ActionState},{Model.PartNum},{Model.MinPrice},{Model.SurplusNum},{Model.SurplusBargain},'{Model.BargainName}','{Model.BargainRemark}',{Model.Template},{Model.LimitNum},{Model.BargainSum})"; string sql2 = $"insert into Lognote values (NULL,'添加',NOW(),'Bargain砍价表');"; DapperHelper.Execute(sql2); return(DapperHelper.Execute(sql)); }
public int UptBargain([FromForm] Model.Bargain bargain) { try { logger.Debug($"用户对砍价列表进行修改,修改的ID为:{bargain.BargainId}"); int i = _bargainRepository.UptDate(bargain); return(i); } catch (Exception) { throw; } }
public int AddBargain([FromForm] Model.Bargain bargain) { try { logger.Debug($"用户对砍价列表进行添加,添加的名称为:{bargain.BargainName}"); int i = _bargainRepository.Insert(bargain); return(i); } catch (Exception) { throw; } }
public IActionResult ShowBargainFT(int ftid) { try { //获取全部数据 var ls = _bargainRepository.Query(); Model.Bargain aa = ls.FirstOrDefault(x => x.BargainId.Equals(ftid)); return(Ok(aa)); } catch (Exception) { throw; } }
public int UptZt(int bid) { string sql = "SELECT a.*,b.CommodityName,b.CommodityPic from Bargain a JOIN Commodity b ON a.CommodityId=b.CommodityId"; List <Model.Bargain> lb = DapperHelper.GetList <Model.Bargain>(sql); Model.Bargain ba = lb.FirstOrDefault(x => x.BargainId.Equals(bid)); string sql1 = ""; if (ba.ActionState == 0) { sql1 = $"UPDATE Bargain SET ActionState=ActionState+1 WHERE BargainId=1"; } else { sql1 = $"UPDATE Bargain SET ActionState=ActionState-1 WHERE BargainId=1"; } return(DapperHelper.Execute(sql1)); }
public int UptZt(int bid) { string sql = "select * FROM Bargain"; List <Model.Bargain> lb = DapperHelper.GetList <Model.Bargain>(sql); Model.Bargain ba = lb.FirstOrDefault(x => x.BargainId.Equals(bid)); string sql1 = ""; if (ba.ActionState == 0) { sql1 = $"UPDATE Bargain SET ActionState=ActionState+1 WHERE BargainId={bid}"; } else { sql1 = $"UPDATE Bargain SET ActionState=ActionState-1 WHERE BargainId={bid}"; } string sql2 = $"insert into Lognote values (NULL,'修改状态',NOW(),'Bargain砍价表');"; DapperHelper.Execute(sql2); int i = DapperHelper.Execute(sql1); return(i); }
public int UptBargain(Model.Bargain bargain) { int i = _bargainRepository.UptDate(bargain); return(i); }
public int AddBargain(Model.Bargain bargain) { int i = _bargainRepository.Insert(bargain); return(i); }