public string CreateWithdrawalsLog(string jsonRequest)
{
string jsonRequestInfo = Encrypt.AESDecode(jsonRequest);
if (string.Empty == jsonRequestInfo) //aes校验
{
Dictionary <string, string> retJson = new Dictionary <string, string>();
retJson.Add("ret", "1");
retJson.Add("msg", "request json false");
return(JSONHelper.ToJson(retJson));
}
Dictionary <string, object> retRequest = new Dictionary <string, object>();
retRequest = JSONHelper.FromJson <Dictionary <string, object> >(jsonRequestInfo);
//插入log数据
string sql = "insert into CF_User_Withdrawals_Log values ('" + Guid.NewGuid().ToString() + "','" + retRequest["idCard"].ToString() + "','" + retRequest["no_order"].ToString() + "','" + retRequest["oid_partner"].ToString() + "','" + retRequest["oid_paybill"].ToString() + "','" + retRequest["ret_code"].ToString() + "','" + retRequest["ret_msg"].ToString() + "','" + retRequest["sign"].ToString() + "','" + retRequest["sign_type"].ToString() + "','" + 0 + "','" + retRequest["fee"].ToString() + "','" + DateTime.Now.ToString() + "')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
return("111");
}
