public int Uptdate(Model.GroupBooking Model)
{
string sql = $"UPDATE GroupBooking SET ColonelID={Model.ColonelID},CommodityId={Model.CommodityId},GroupBookingName='{Model.GroupBookingName}',GroupBookingRemark='{Model.GroupBookingRemark}',GroupBookingUnit='{Model.GroupBookingUnit}',GroupBookingSdate='{Model.GroupBookingSdate}',GroupBookingZdate='{Model.GroupBookingZdate}',GroupBookingResults={Model.GroupBookingResults},GroupBookingNumber={Model.GroupBookingNumber},GroupBookingSellLimitNum={Model.GroupBookingSellLimitNum},GroupBookingSort={Model.GroupBookingSort},GroupBookingTemplate={Model.GroupBookingTemplate},GroupBookingState={Model.GroupBookingState},GroupBookingPrice={Model.GroupBookingPrice},GroupBookingLimitNum={Model.GroupBookingLimitNum} where GroupBookingID ={Model.GroupBookingID}";
string sql2 = $"insert into Lognote values (NULL,'修改',NOW(),'GroupBooking拼团表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql));
}
public int Insert(Model.GroupBooking Model)
{
string sql = $"insert into GroupBooking values(null,{Model.ColonelID},{Model.CommodityId},'{Model.GroupBookingName}','{Model.GroupBookingRemark}','{Model.GroupBookingUnit}','{Model.GroupBookingSdate}','{Model.GroupBookingZdate}',{ Model.GroupBookingResults},{ Model.GroupBookingNumber},{ Model.GroupBookingSellLimitNum},{ Model.GroupBookingSort},{ Model.GroupBookingTemplate},{ Model.GroupBookingState},{ Model.GroupBookingPrice},{ Model.GroupBookingLimitNum}) ";
string sql2 = $"insert into Lognote values (NULL,'添加',NOW(),'GroupBooking拼团表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql));
}
public int GroupBookingAdd([FromForm] Model.GroupBooking groupBooking)
{
try
{
logger.Debug($"用户对拼团列表进行添加,添加的名称为:{groupBooking.GroupBookingName}");
int i = _groupBookingRepository.Insert(groupBooking);
return(i);
}
catch (Exception)
{
throw;
}
}
public int GroupBookingUpt([FromForm] Model.GroupBooking groupBooking)
{
try
{
logger.Debug($"用户对拼团列表进行修改,修改的名称为:{groupBooking.GroupBookingID}");
int i = _groupBookingRepository.Uptdate(groupBooking);
return(i);
}
catch (Exception)
{
throw;
}
}
public int UptZt(int bid)
{
string sql = "select * FROM groupbooking";
List <Model.GroupBooking> lg = DapperHelper.GetList <Model.GroupBooking>(sql);
Model.GroupBooking mg = lg.FirstOrDefault(x => x.GroupBookingID.Equals(bid));
string sql1 = "";
if (mg.GroupBookingState == 0)
{
sql1 = $"UPDATE GroupBooking SET GroupBookingState=GroupBookingState+1 WHERE GroupBookingID={bid}";
}
else
{
sql1 = $"UPDATE GroupBooking SET GroupBookingState=GroupBookingState-1 WHERE GroupBookingID={bid}";
}
string sql2 = $"insert into Lognote values (NULL,'修改状态',NOW(),'GroupBooking拼团表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql1));
}
