/// <summary>
/// 获取开通了订单关闭的卖家SESSIONKEY
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static string GetCloseOrderSessionKey(string sellerNick)
{
try
{
string query = @"select S.SESSKEY from Seller S
inner join CloseOrderConfig R on S.NICK = R.sellerNick
where S.endDate > getdate() and R.isAutoCloseOrder = 1
and S.NICK = @NICK ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@NICK", sellerNick)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
return(dt.Rows[0]["SESSKEY"].ToString());
}
return("");
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return("");
}
}
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 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);
}
}
/// <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>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetSellerRateConfig(string sellerNick)
{
try
{
string query = @"select content1,content2,content3,result from RateConfig where isAutoRating = 1 and sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", sellerNick)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
return(dt);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(null);
}
}
/// <summary>
/// 获取卖家订单基础拦截策略
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetCloseOrderConfig(string sellerNick)
{
try
{
string query = @"select * from dbo.CloseOrderConfig where sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", sellerNick)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
return(dt);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(null);
}
}
/// <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);
}
}
/// <summary>
/// 获取卖家保存的自动评价策略
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetSellerAutoRateConfig(string sellerNick)
{
try
{
string query = @"SELECT [sellerNick]
,[isMiaoRate]
,[isWaitBuyerRate]
,[waitBuyerTimeDay]
,[waitBuyerTimeHour]
,[waitBuyerTimeFen]
,[blackBuyerRatedIsRate]
,[blackBuyerNoRateQiangRateDay]
,[blackBuyerNoRateQiangRateHour]
,[blackBuyerNoRateQiangRateFen]
,[isQiangRate]
,[qiangRateTimeDay]
,[qiangRateTimeHour]
,[qiangRateTimeFen]
,[atuoAddBlackListBadRate]
,[atuoAddBlackListTuiKuan]
,[badRateContent]
,[result]
,[content1]
,[content2]
,[content3]
,[contentChoice]
,[isAutoRating]
FROM [RateConfig] where isAutoRating = 1 and sellerNick = @sellerNick";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", sellerNick)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
return(dt);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(null);
}
}
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);
}
}
/// <summary>
/// 查询主动通知信息从DB开始用于发送短信:只取交易完成的数据用于秒评
/// </summary>
/// <returns></returns>
public static DataTable GetTradeData(string sellerNick)
{
try
{
string query = @"select tid,seller_nick,status,buyer_nick,createDate,payment from NotifyTrade where status = 'taobao_trade_TradeSuccess' ";
List <SqlParameter> list = new List <SqlParameter>();
if (!string.IsNullOrEmpty(sellerNick))
{
query += " and seller_nick = @seller_nick ";
SqlParameter p1 = new SqlParameter("@seller_nick", sellerNick);
list.Add(p1);
}
SqlParameter[] strParam = list.ToArray();
DataTable dt = DataBaseTool.ExecuteDt(query, strParam, CommandType.Text);
return(dt);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(null);
}
}
public static Boolean CheckNoteTradeIsExit(string tid)
{
try
{
string query = @"select 1 from NotifyTrade where tid = @tid";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@tid", tid)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
/// <summary>
/// 判断卖家是否开通秒评
/// </summary>
/// <param name="sellerNick"></param>
/// <param name="buerNick"></param>
/// <returns></returns>
public static Boolean CheckSellerIsOpenMiao(string sellerNick)
{
try
{
string query = @"select 1 from RateConfig where sellerNick = @sellerNick and isMiaoRate = 1 and isAutoRating = 1";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", sellerNick)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
/// <summary>
/// 检查秒评用户是否是黑名单用户
/// </summary>
/// <param name="sellerNick"></param>
/// <param name="buerNick"></param>
/// <returns></returns>
public static Boolean CheckIsBlacklst(string sellerNick, string buerNick)
{
try
{
string query = @"select 1 from BlakList where sellerNick = @sellerNick and blakName = @blakName";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", sellerNick),
new SqlParameter("@blakName", buerNick)
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
/// <summary>
/// 地址拦截配置
/// </summary>
/// <param name="sellerNick"></param>
/// <returns></returns>
public static DataTable GetCloseOrderAddressConfig(string sellerNick, string receiverName, string phone, string receiverAddress)
{
try
{
string query = @"select matchType,receiverName,receiverAddress,phone from CloseAddressConfig
where sellerNick = @sellerNick
and (receiverName = @receiverName or phone = @phone or receiverAddress like @receiverAddress)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", sellerNick),
new SqlParameter("@receiverName", receiverName),
new SqlParameter("@phone", phone),
new SqlParameter("@receiverAddress", "%" + receiverAddress + "%")
};
DataTable dt = DataBaseTool.ExecuteDt(query, param, CommandType.Text);
return(dt);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(null);
}
}