public static bool UpdateJifenConfigStauts(JifenConfig o) { try { string query = @"update SellerJifenConfig set flag = @flag,tradeAmount = @tradeAmount,canGetJifen = @canGetJifen where sellerNick = @sellerNick "; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@flag", o.Flag), new SqlParameter("@tradeAmount", o.TradeAmount), new SqlParameter("@canGetJifen", o.CanGetJifen), new SqlParameter("@sellerNick", o.SellerNick) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool AddJifenConfig(JifenConfig jifen) { try { string query = @"insert into SellerJifenConfig(sellerNick,tradeAmount,canGetJifen,startDate,flag) values(@sellerNick,@tradeAmount,@canGetJifen,@startDate,@flag)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@sellerNick", jifen.SellerNick), new SqlParameter("@tradeAmount", jifen.TradeAmount), new SqlParameter("@canGetJifen", jifen.CanGetJifen), //累计买家剩余积分 new SqlParameter("@startDate", jifen.StartDate), new SqlParameter("@flag", jifen.Flag) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool UpdateJifenConfigStauts(JifenConfig o) { o.SellerNick = Users.Nick; return(JifenDAL.UpdateJifenConfigStauts(o)); }
public static bool AddJifenConfig(JifenConfig jifens) { return(JifenDAL.AddJifenConfig(jifens)); }