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