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