public static bool AddJifen(Jifen jifen) { try { string query = @"insert into BuyerJifen(buyer_nick,orderNo,jifenHis,jifenAmount,jifenComeFrom,createDate,sellerNick)values (@buyer_nick,@orderNo,@jifenHis,@jifenAmount,@jifenComeFrom,getdate(),@sellerNick)"; //如果第一次增加积分 int initJifen = Convert.ToInt32(GetBuyerTotalJifen(jifen.Buyer_Nick, jifen.SellerNick)); if (initJifen == 0) { initJifen = jifen.jifenHis; } else { initJifen = initJifen + jifen.jifenHis; } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@buyer_nick", jifen.Buyer_Nick), new SqlParameter("@orderNo", jifen.OrderNo), new SqlParameter("@jifenHis", jifen.jifenHis), //累计买家剩余积分 new SqlParameter("@jifenAmount", initJifen), new SqlParameter("@sellerNick", jifen.SellerNick), new SqlParameter("@jifenComeFrom", jifen.JifenComeFrom) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool MinusJifen(Jifen jifen) { try { string query = @"insert into BuyerJifen(buyer_nick,orderNo,jifenHis,jifenAmount,jifenComeFrom,createDate,sellerNick)values (@buyer_nick,@orderNo,@jifenHis,@jifenAmount,@jifenComeFrom,getdate(),@sellerNick)"; int jifenAmount = Convert.ToInt32(GetBuyerTotalJifen(jifen.Buyer_Nick, jifen.SellerNick)) - Convert.ToInt32(jifen.jifenHis); if (jifenAmount < 0) { return(false); } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@buyer_nick", jifen.Buyer_Nick), new SqlParameter("@orderNo", jifen.OrderNo), new SqlParameter("@jifenHis", Convert.ToInt32("-" + jifen.jifenHis)), //累计买家剩余积分 new SqlParameter("@jifenAmount", Convert.ToString(Convert.ToInt32(GetBuyerTotalJifen(jifen.Buyer_Nick, jifen.SellerNick)) - Convert.ToInt32(jifen.jifenHis))), new SqlParameter("@jifenComeFrom", "手工消耗积分"), new SqlParameter("@sellerNick", jifen.SellerNick) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool MinusJifen(Jifen jifen) { return(JifenDAL.MinusJifen(jifen)); }
public static bool AddJifen(Jifen jifen) { return(JifenDAL.AddJifen(jifen)); }