public HttpResponseMessage QueryOrdertable(selectparm reparm)
{
try
{
string result = "";
using (YYPlayContext context = new YYPlayContext())
{
DataTable dt = rule.GetQueryDate("", "tbleMerchant", "fldMerchID='" + reparm.MerchID + "'");
if (dt.Rows.Count > 0)
{
//验证签名
notsign notsign = new notsign();
notsign.MerchID = reparm.MerchID;
notsign.OrderID = reparm.OrderID;
RulePayBehavior behavior = new RulePayBehavior();
//转换成JSON
string json = JsonHelper.SerializeObject(notsign);
//实体转字典类型
Dictionary <string, string> pairs = behavior.ObjectToMap(notsign, false);
//排序后的字段
string sign = behavior.AsciiDesc(pairs);
//加上key值 然后对比
sign += "key=" + dt.Rows[0]["fldSecretKey"].ToString();
string newsign = behavior.EncryptionMd5(sign);
if (newsign != reparm.Sign)
{
result = rule.JsonStr("error", "验签失败", "");
new InsertException(newsign, "Transaction", "GetOrdertableExcelDate", sign);
}
else
{
//查询订单表
DataTable table = rule.GetQueryDate("", "vwDownOrdertable", " 1=1 and MerchID='" + reparm.MerchID + "' and OrderID='" + reparm.OrderID + "'", "*");
if (table.Rows.Count > 0)
{
result = rule.JsonStr("ok", "查询成功", table);
}
else
{
result = rule.JsonStr("error", "查询不到这条订单，请核对订单号和商户号！", "");
}
}
}
else
{
result = rule.JsonStr("error", "商户ID不存在", "");
}
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
catch (Exception e)
{
throw new InsertException(e.Message, "Transaction", "GetOrdertableExcelDate", "");
}
}
