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