/// <summary> /// 添加礼券 /// </summary> /// <param name="model">礼券信息</param> /// <returns></returns> public int AddCoupon(CouponInfoModel model) { const string sql = @"INSERT INTO coupon_card (innerid,shopid, title, titlesub, amount,buyprice, costprice, logourl, vtype, vstart, vend, value1, value2, maxcount, count,cardtype, codetype,needpoint,usedesc, createdtime, modifiedtime, isenabled) VALUES (@innerid,@shopid,@title,@titlesub,@amount,@buyprice, @costprice,@logourl,@vtype,@vstart,@vend,@value1,@value2,@maxcount,@count,@cardtype,@codetype,@needpoint,@usedesc,@createdtime,@modifiedtime,@isenabled);"; using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { conn.Execute(sql, model, tran); tran.Commit(); return 1; } catch (Exception ex) { tran.Rollback(); return 0; } } }
/// <summary> /// 修改礼券库存 /// </summary> /// <param name="model">礼券信息</param> /// <returns></returns> public int UpdateStock(CouponInfoModel model) { const string sql = "update coupon_card set maxcount=maxcount+@count,count=count+@count where innerid=@innerid"; using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { conn.Execute(sql, new { innerid = model.Innerid, count = model.Count }, tran); tran.Commit(); return 1; } catch (Exception ex) { tran.Rollback(); return 0; } } }
/// <summary> /// 修改礼券有效期 /// </summary> /// <param name="model">礼券信息</param> /// <returns></returns> public int UpdateValidity(CouponInfoModel model) { try { if (model.Vtype == 1) { const string sql = "update coupon_card set vstart=@vstart,vend=@vend where innerid=@innerid"; Helper.Execute(sql, new { innerid = model.Innerid, vstart = model.Vstart, vend = model.Vend }); } else { const string sql = "update coupon_card set value1=@value1,value2=@value2 where innerid=@innerid"; Helper.Execute(sql, new { innerid = model.Innerid, value1 = model.Value1, value2 = model.Value2 }); } return 1; } catch (Exception ex) { return 0; } }
/// <summary> /// 修改礼券 /// </summary> /// <param name="model">礼券信息</param> /// <returns></returns> public int UpdateCoupon(CouponInfoModel model) { //var sql = "update coupon_card set title=@title,titlesub=@titlesub,amount=@amount,logourl=@logourl, where innerid = @innerid"; var sqlStr = new StringBuilder("update coupon_card set "); sqlStr.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sqlStr.Append(" where innerid = @innerid"); using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { conn.Execute(sqlStr.ToString(), model, tran); tran.Commit(); return 1; } catch (Exception ex) { tran.Rollback(); return 0; } } }