/// <summary> /// 添加卖家评价 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool AddRateHisWithSeller(TradeRate obj, string rateType) { try { string query = @"insert into SellerRateHis(oid,tid,nick,result,created,content,rateType) values(@oid,@tid,@nick,@result,@created,@content,@rateType)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@oid", obj.Oid), new SqlParameter("@tid", obj.Tid), new SqlParameter("@nick", obj.Nick == null ? "" : obj.Nick), new SqlParameter("@result", obj.Result == null ? "" : obj.Result), new SqlParameter("@created", obj.Created == null ? "" : obj.Created), new SqlParameter("@content", obj.Content == null ? "" : obj.Content), new SqlParameter("@rateType", rateType) }; DataBaseTool.ExecuteSql(query, param); return(true); } catch (Exception ex) { //主键重复,发生异常。ExceptionReporter.WriteLog(ex, CHENGTUAN.Entity.ExceptionPostion.TBApply_Data); return(false); } }
public static bool AddNoteTradeToDB(NotifyTrade trade) { try { string query = @"INSERT INTO NotifyTrade(tid,buyer_nick,nick,status,oid,payment,seller_nick,createDate) VALUES(@tid,@buyer_nick,@nick,@status,@oid,@payment,@seller_nick,getdate())"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@tid", trade.Tid), new SqlParameter("@buyer_nick", trade.BuyerNick), new SqlParameter("@nick", trade.SellerNick), new SqlParameter("@status", trade.Status), new SqlParameter("@oid", trade.Oid), new SqlParameter("@payment", trade.Payment), new SqlParameter("@seller_nick", trade.SellerNick) }; DataBaseTool.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
/// <summary> /// 订单拦截日志 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool AddCloseOrderLog(CloseOrderLog obj) { try { string query = @"insert into CloseOrderLog(buyerNick,sellerNick,ordreNo,closeReason,closeTime,closeResult,faildReason) values(@buyerNick,@sellerNick,@ordreNo,@closeReason,@closeTime,@closeResult,@faildReason)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@buyerNick", obj.BuyerNick), new SqlParameter("@sellerNick", obj.SellerNick), new SqlParameter("@ordreNo", obj.OrdreNo), new SqlParameter("@closeReason", obj.CloseReason), new SqlParameter("@closeTime", DateTime.Now), new SqlParameter("@closeResult", obj.CloseResult), new SqlParameter("@faildReason", obj.FaildReason) }; DataBaseTool.ExecuteSql(query, param); return(true); } catch (Exception ex) { //主键重复,发生异常。ExceptionReporter.WriteLog(ex, CHENGTUAN.Entity.ExceptionPostion.TBApply_Data); return(false); } }
/// <summary> /// 删除秒评后的无效数据 /// </summary> /// <returns></returns> public static bool DeleteValidTradeForMiaoRate(string tid) { try { string query = @"delete from NotifyTrade where tid = @tid"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@tid", tid) }; DataBaseTool.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool UpdateNoteTradeToDB(NotifyTrade trade) { try { string query = @"update NotifyTrade set status = @status where tid = @tid"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@tid", trade.Tid), new SqlParameter("@status", trade.Status) }; DataBaseTool.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }