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