public int insert(Model.OrderInfos orderInfo)
{
string sql = $"SELECT CONCAT(DATE_FORMAT(now(), '%Y%m%d%H%i%s'),lpad(round(round(rand(),4)*1000),4,'0'))";
var num = DapperHelper.Exescalar(sql);
string sqla = $"SELECT CONCAT(DATE_FORMAT(now(), '%Y%m%d%H%i%s'),lpad(round(round(rand(),4)*1000),4,'0'))";
var nums = DapperHelper.Exescalar(sqla);
string sqls = $"insert INTO OrderInfo values(NULL,'{num}','{nums}','{orderInfo.CommodityId}','{orderInfo.UserId}','{orderInfo.SendWay}','{orderInfo.OrderState}','{orderInfo.Remark}','{orderInfo.CommodityPrice}','{orderInfo.DistributionCosts}','{orderInfo.OrderPrice}','{orderInfo.CouponPrice}','{orderInfo.AmountPaid}','{orderInfo.StartTime}')";
return(DapperHelper.Execute(sqls));
}
public int insert(Model.OrderInfos orderInfo)
{
try
{
int i = _orderInfoRepository.insert(orderInfo);
return(i);
}
catch (Exception)
{
throw;
}
}
public int UptOrderState([FromForm] Model.OrderInfos Model)
{
try
{
int i = _orderInfoRepository.UptOrderState(Model);
return(i);
}
catch (Exception)
{
throw;
}
}
public int UptOrderState(Model.OrderInfos Model)
{
string sql = $"UPDATE OrderInfo SET OrderState='{Model.OrderState}' where Orderid={Model.Orderid}";
return(DapperHelper.Execute(sql));
}
public int UptSendWay(Model.OrderInfos Model)
{
string sql = $"UPDATE OrderInfo SET SendWay='{Model.SendWay}' where Orderid={Model.Orderid}";
return(DapperHelper.Execute(sql));
}
public int UptRemark(Model.OrderInfos Model)
{
string sql = $"UPDATE OrderInfo SET Remark='{Model.Remark}' where Orderid={Model.Orderid}";
return(DapperHelper.Execute(sql));
}
public int Insert(Model.OrderInfos Model)
{
throw new NotImplementedException();
}
