public int Uptdate(Model.SeckillCom Model)
{
string sql = $"update SeckillCom set ActivityId={ Model.ActivityId},CommodityId={Model.CommodityId},SeckillTitle='{Model.SeckillTitle}',SeckillRemaek='{Model.SeckillRemaek}',SeckillModel={ Model.SeckillModel},TackTime={ Model.TackTime},ActionDate='{Model.ActionDate}',State={ Model.State},SeckilPrice={ Model.SeckilPrice},LimitNum={ Model.LimitNum} where SeckillComId={Model.SeckillComId}";
string sql2 = $"insert into Lognote values (NULL,'修改',NOW(),'SeckillCom秒杀商品表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql));
}
public int Insert(Model.SeckillCom Model)
{
string sql = $"insert into SeckillCom values (null,{Model.ActivityId},{Model.CommodityId},'{Model.SeckillTitle}','{Model.SeckillRemaek}',{Model.SeckillModel},{Model.TackTime},'{Model.ActionDate}',{Model.State},{Model.SeckilPrice},{Model.LimitNum},NOW())";
string sql2 = $"insert into Lognote values (NULL,'添加',NOW(),'SeckillCom秒杀商品表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql));
}
public int UptZt(int sid)
{
string sql = "select * FROM SeckillCom";
List <Model.SeckillCom> la = DapperHelper.GetList <Model.SeckillCom>(sql);
Model.SeckillCom aa = la.FirstOrDefault(x => x.SeckillComId.Equals(sid));
string sql1 = "";
if (aa.State == 0)
{
sql1 = $"UPDATE SeckillCom SET State=State+1 where SeckillComId={sid}";
}
else
{
sql1 = $"UPDATE SeckillCom SET State=State-1 where SeckillComId={sid}";
}
string sql2 = $"insert into Lognote values (NULL,'修改状态',NOW(),'SeckillCom秒杀商品表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql1));
}
public int Uptdate(Model.SeckillCom Model)
{
string sql = $"update SeckillCom set ActivityId={ Model.ActivityId},CommodityId={Model.CommodityId},SeckillTitle='{Model.SeckillTitle}',SeckillRemaek='{Model.SeckillRemaek}',SeckillModel={ Model.SeckillModel},TackTime={ Model.TackTime},ActionDate='{Model.ActionDate}',State={ Model.State}.SeckilPrice={ Model.SeckilPrice},LimitNum={ Model.LimitNum} where SeckillComId={Model.SeckillComId}";
return(DapperHelper.Execute(sql));
}
public int Insert(Model.SeckillCom Model)
{
string sql = $"insert into SeckillCom values (null,{Model.ActivityId},{Model.CommodityId},'{Model.SeckillTitle}','{Model.SeckillRemaek}',{Model.SeckillModel},{Model.TackTime},'{Model.ActionDate}',{Model.State},{Model.SeckilPrice},{Model.LimitNum})";
return(DapperHelper.Execute(sql));
}