public ActionResult AppAuditing(int a_id)
{
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();
string glpt = "";
string zf = "";
string szmrdj = "";
string yy = "";
if (a_id > 0)
{
model = bll.SelectId(a_id);
#region 根据应用子类型获取风险等级
JMP.BLL.jmp_risklevelallocation ribll = new JMP.BLL.jmp_risklevelallocation();
List <JMP.MDL.jmp_risklevelallocation> rilist = new List <JMP.MDL.jmp_risklevelallocation>();
rilist = ribll.SelectAppType(model.a_apptype_id);
ViewBag.rilist = rilist;
#endregion
}
ViewBag.model = model;
ViewBag.glpt = glpt;
ViewBag.zf = zf;
ViewBag.yy = yy;
ViewBag.szmrdj = szmrdj;
return(View());
}
public ActionResult down()
{
#region 获取用户实名认证状态信息
JMP.BLL.jmp_user sm_bll = new JMP.BLL.jmp_user();
JMP.MDL.jmp_user sm_model = new JMP.MDL.jmp_user();
int u_ids = UserInfo.Uid;
//查询登录信息
sm_model = sm_bll.GetModel(u_ids);
ViewBag.auditstate = sm_model.u_auditstate;
ViewBag.linkEmail = sm_model.u_email;
#endregion
int appid = string.IsNullOrEmpty(Request["appid"]) ? 0 : Int32.Parse(Request["appid"]);
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app modapp = new JMP.MDL.jmp_app();
if (appid > 0)
{
modapp = bll.SelectAppId(appid);
}
string payfs = SelectPay(modapp.a_paymode_id);
string[] pay = payfs.Split(',');
ViewBag.pay = pay;
ViewBag.modapp = modapp;
return(View());
}
public JsonResult DeleteApp()
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();//应用实体类
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
int a_id = string.IsNullOrEmpty(Request["a_id"]) ? 0 : Int32.Parse(Request["a_id"].ToString());
if (a_id > 0)
{
model = bll.GetModel(a_id);
model.a_state = -1;
if (bll.Update(model))
{
// AddLocLog.AddUserLog(Int32.Parse(UserInfo.UserId), 3, RequestHelper.GetClientIp(), "删除应用", "删除应用，应用id为：" + model.a_id);
Logger.OperateLog("删除应用", "删除应用");
retJson = new { success = 1, msg = "操作成功" };
}
else
{
retJson = new { success = 0, msg = "操作失败" };
}
}
return(Json(retJson));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.jmp_app model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into jmp_app(");
strSql.Append("a_auditstate,a_secretkey,a_time,a_showurl,a_auditor,a_rid,a_appurl,a_appsynopsis,a_user_id,a_name,a_platform_id,a_paymode_id,a_apptype_id,a_notifyurl,a_key,a_state");
strSql.Append(") values (");
strSql.Append("@a_auditstate,@a_secretkey,@a_time,@a_showurl,@a_auditor,@a_rid,@a_appurl,@a_appsynopsis,@a_user_id,@a_name,@a_platform_id,@a_paymode_id,@a_apptype_id,@a_notifyurl,@a_key,@a_state");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@a_auditstate", SqlDbType.Int, 4),
new SqlParameter("@a_secretkey", SqlDbType.NVarChar, -1),
new SqlParameter("@a_time", SqlDbType.DateTime),
new SqlParameter("@a_showurl", SqlDbType.NVarChar, -1),
new SqlParameter("@a_auditor", SqlDbType.NVarChar, 50),
new SqlParameter("@a_rid", SqlDbType.Int, 4),
new SqlParameter("@a_appurl", SqlDbType.NVarChar, 500),
new SqlParameter("@a_appsynopsis", SqlDbType.NVarChar, -1),
new SqlParameter("@a_user_id", SqlDbType.Int, 4),
new SqlParameter("@a_name", SqlDbType.NVarChar, -1),
new SqlParameter("@a_platform_id", SqlDbType.Int, 4),
new SqlParameter("@a_paymode_id", SqlDbType.NVarChar, -1),
new SqlParameter("@a_apptype_id", SqlDbType.Int, 4),
new SqlParameter("@a_notifyurl", SqlDbType.NVarChar, -1),
new SqlParameter("@a_key", SqlDbType.NVarChar, -1),
new SqlParameter("@a_state", SqlDbType.Int, 4)
};
parameters[0].Value = model.a_auditstate;
parameters[1].Value = model.a_secretkey;
parameters[2].Value = model.a_time;
parameters[3].Value = model.a_showurl;
parameters[4].Value = model.a_auditor;
parameters[5].Value = model.a_rid;
parameters[6].Value = model.a_appurl;
parameters[7].Value = model.a_appsynopsis;
parameters[8].Value = model.a_user_id;
parameters[9].Value = model.a_name;
parameters[10].Value = model.a_platform_id;
parameters[11].Value = model.a_paymode_id;
parameters[12].Value = model.a_apptype_id;
parameters[13].Value = model.a_notifyurl;
parameters[14].Value = model.a_key;
parameters[15].Value = model.a_state;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 微信公众号第一次跳转
/// </summary>
/// <param name="Oid">订单id</param>
private void OnJump(int Oid)
{
try
{
string str = "";
JMP.MDL.jmp_app mo = new JMP.MDL.jmp_app();
JMP.BLL.jmp_app blls = new JMP.BLL.jmp_app();
mo = JMP.TOOL.MdlList.ToModel <JMP.MDL.jmp_app>(blls.GetList(" a_id=(SELECT o_app_id FROM jmp_order WHERE o_id=" + Oid + ") ").Tables[0]);
if (mo != null)
{
SelectInterface SeIn = new SelectInterface();
string cache = "wxgfgzh" + Oid;
SeIn = SelectInfo(cache, mo.a_rid, mo.a_id, int.Parse(ConfigurationManager.AppSettings["CacheTime"].ToString()));
if (SeIn == null || SeIn.PayId <= 0 || string.IsNullOrEmpty(SeIn.UserId) || string.IsNullOrEmpty(SeIn.UserKey))
{
str = "{\"Message\":\"支付通道未配置\",\"ErrorCode\":106}";
Response.Write(str);
}
JMP.BLL.jmp_order bll = new JMP.BLL.jmp_order();
JMP.MDL.jmp_order morder = bll.SelectOrderGoodsName(Oid, "jmp_order");
if (morder.o_price < SeIn.minmun)
{
str = "{\"Message\":\"订单金额不能小于单笔最小支付金额\",\"ErrorCode\":8990}";
Response.Write(str);
}
if (morder.o_price > SeIn.maximum)
{
str = "{\"Message\":\"订单金额不能大于单笔最大支付金额\",\"ErrorCode\":8989}";
Response.Write(str);
}
if (bll.UpdatePay(Oid, SeIn.PayId))
{
string redirect_uri = ConfigurationManager.AppSettings["WxGzhRturnUrl"].ToString() + Oid + ".html";
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息：" + "回调地址:" + redirect_uri, summary: "微信官方公众号第一次跳转支付接口错误信息", channelId: Oid);
string url = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=" + SeIn.wxappid + "&redirect_uri=" + redirect_uri + "&response_type=code&scope=snsapi_base#wechat_redirect";
Response.Redirect(url, false);
}
}
else
{
str = "{\"Message\":\"支付接口异常\",\"ErrorCode\":102}";
Response.Write(str);
}
}
catch (Exception ex)
{
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息：" + ex.Message, summary: "微信官方公众号第一次跳转支付接口错误信息", channelId: Oid);
Response.Write("非法访问！");
}
}
public ActionResult Upload()
{
int appid = string.IsNullOrEmpty(Request["appid"]) ? 0 : Int32.Parse(Request["appid"]);
ViewBag.appid = appid;
JMP.BLL.jmp_appsdk bll = new JMP.BLL.jmp_appsdk();
JMP.MDL.jmp_appsdk model = new JMP.MDL.jmp_appsdk();
JMP.BLL.jmp_app bllapp = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app mo = new JMP.MDL.jmp_app();
if (appid > 0)
{
model = bll.SelectModel(appid);
mo = bllapp.GetModel(appid);
}
ViewBag.model = model == null ? new JMP.MDL.jmp_appsdk() : model;
ViewBag.mo = mo == null ? new JMP.MDL.jmp_app() : mo;
return(View());
}
/// <summary>
/// 根据应用id查询所属用户
/// </summary>
/// <param name="APPID">应用id</param>
/// <param name="tname">接口名称</param>
/// <param name="noticestr">传入的字符串</param>
/// <returns></returns>
private int selectUserID(int APPID, string tname, string noticestr)
{
int aid = 0;
try
{
JMP.MDL.jmp_app app = new JMP.MDL.jmp_app();
JMP.BLL.jmp_app appbll = new JMP.BLL.jmp_app();
string notfrurl = "notfrurl" + APPID;//缓存名称
//判读是否存在缓存
if (JMP.TOOL.CacheHelper.IsCache(notfrurl))
{
app = JMP.TOOL.CacheHelper.GetCaChe <JMP.MDL.jmp_app>(notfrurl);//获取缓存
if (app != null)
{
aid = app.u_id;
}
}
else
{
app = appbll.SelectId(APPID);
if (app != null)
{
aid = app.u_id;
JMP.TOOL.CacheHelper.CacheObjectLocak <JMP.MDL.jmp_app>(app, notfrurl, 5);//存入缓存
}
else
{
//AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, tname + "通知接口错误", "应用id：" + APPID + ",获取用户id失败！获取的参数：" + noticestr);//写入报错日志
PayNotifyGlobalErrorLogger.Log("应用id：" + APPID + ",获取用户id失败！获取的参数：" + noticestr, summary: tname + "通知接口错误");
}
}
}
catch (Exception ex)
{
// AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, tname + "通知接口错误", "查询用户id失败，报错信息：" + ex.ToString() + ",获取的参数:" + noticestr);//写入报错日志
PayNotifyGlobalErrorLogger.Log("查询用户id失败，报错信息：" + ex.ToString() + ",获取的参数:" + noticestr, summary: tname + "通知接口错误");
}
return(aid);
}
/// <summary>
/// 冻结或解冻应用
/// </summary>
/// <returns></returns>
public JsonResult UpdateStateDt()
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();//应用实体类
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
int a_id = string.IsNullOrEmpty(Request["a_id"]) ? 0 : Int32.Parse(Request["a_id"].ToString());
model = bll.GetModel(a_id);
model.a_state = string.IsNullOrEmpty(Request["state"]) ? 0 : Int32.Parse(Request["state"].ToString());
string xgzfc = ""; //组装说明
string tsmsg = ""; //提示
if (bll.Update(model))
{
if (model.a_state == 1)
{
xgzfc = "解冻ID为" + a_id;
tsmsg = "解冻成功";
}
else
{
tsmsg = "冻结成功";
xgzfc = "冻结ID为：" + a_id;
}
Logger.OperateLog("应用冻结或解冻", xgzfc);
retJson = new { success = 1, msg = tsmsg };
}
else
{
retJson = new { success = 0, msg = "操作失败" };
}
return(Json(retJson));
}
public ActionResult UpdateApp()
{
#region 获取用户实名认证状态信息
JMP.BLL.jmp_user sm_bll = new JMP.BLL.jmp_user();
JMP.MDL.jmp_user sm_model = new JMP.MDL.jmp_user();
int u_ids = UserInfo.Uid;
//查询登录信息
sm_model = sm_bll.GetModel(u_ids);
ViewBag.auditstate = sm_model.u_auditstate;
ViewBag.linkEmail = sm_model.u_email;
#endregion
int appid = string.IsNullOrEmpty(Request["appid"]) ? 0 : Int32.Parse(Request["appid"]);
JMP.BLL.jmp_app appbll = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();
string yy = "";
if (appid > 0)
{
model = appbll.SelectId(appid);
#region =========获取应用平台在用信息=========
JMP.BLL.jmp_platform bll = new JMP.BLL.jmp_platform();
DataTable dt = bll.GetList(" 1=1 and p_state='1' ").Tables[0];//获取应用平台在用信息
List <JMP.MDL.jmp_platform> yypt = JMP.TOOL.MdlList.ToList <JMP.MDL.jmp_platform>(dt);
ViewBag.glptdt = yypt;
#endregion
#region ========获取应用类型在用信息======
JMP.BLL.jmp_apptype yybll = new JMP.BLL.jmp_apptype();
string where = " t_id in (select DISTINCT(t_topid) from jmp_apptype where t_topid in( select t_id from jmp_apptype where t_topid='0' )) and t_state='1' order by t_sort desc";
DataTable yydt = yybll.GetList(where).Tables[0];//获取应用类型在用信息
JMP.MDL.jmp_apptype models = new JMP.MDL.jmp_apptype();
int t_topid = 0;
if (model.a_apptype_id > 0)
{
models = yybll.GetModel(model.a_apptype_id);//查询单条信息
t_topid = models.t_topid;
}
string yyid = "";
if (model.a_auditstate == 1)
{
yy += "<select id='xzyylx' disabled ='disabled' > ";
}
else
{
yy += "<select id='xzyylx' onclick='xzyylx()'> ";
}
for (int j = 0; j < yydt.Rows.Count; j++)
{
yyid = yydt.Rows[j]["t_id"].ToString();
if (t_topid > 0)
{
if (Int32.Parse(yydt.Rows[j]["t_id"].ToString()) == models.t_topid)
{
yy += "<option value='" + yyid + "' selected=selected >" + yydt.Rows[j]["t_name"] + "</option>";
}
else
{
yy += "<option value='" + yyid + "' >" + yydt.Rows[j]["t_name"] + "</option>";
}
}
else
{
yy += "<option value='" + yyid + "' >" + yydt.Rows[j]["t_name"] + "</option>";
}
}
yy += "</select>";
#endregion
}
#region 获取所有支付方式
JMP.BLL.jmp_paymode zfbll = new JMP.BLL.jmp_paymode();
DataTable zfdt = new DataTable();
List <JMP.MDL.jmp_paymode> zflist = new List <JMP.MDL.jmp_paymode>();
zfdt = zfbll.GetList(" 1=1 and p_state='1' ").Tables[0];//获取支付类型在用信息
zflist = JMP.TOOL.MdlList.ToList <JMP.MDL.jmp_paymode>(zfdt);
ViewBag.appid = appid;
ViewBag.list = zflist;
#endregion
ViewBag.yy = yy;
ViewBag.model = model;
//支付方式
string[] zffs = model.a_paymode_id.Split(',');
ViewBag.zffs = zffs;
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int oid = !string.IsNullOrEmpty(Request["pid"]) ? Convert.ToInt32(Request["pid"].ToString()) : 0; //订单表ID
if (oid > 0)
{
//获取缓存
try
{
string code = !string.IsNullOrEmpty(Request["code"]) ? Request["code"] : "";
if (!string.IsNullOrEmpty(code))
{
string url = "";
System.Threading.Thread.Sleep(new Random().Next(100, 500));
if (JMP.TOOL.CacheHelper.IsCache(oid.ToString()) == false)
{
url = "/pfwxgzhorder" + oid + ".html?code=" + code;
JMP.TOOL.CacheHelper.CacheObject(url, oid.ToString(), 1);//存入缓存
}
else
{
url = JMP.TOOL.CacheHelper.GetCaChe <string>(oid.ToString());
}
Response.Redirect(url, false);
}
else
{
string appid = "";
JMP.MDL.jmp_app mo = new JMP.MDL.jmp_app();
JMP.BLL.jmp_app blls = new JMP.BLL.jmp_app();
mo = JMP.TOOL.MdlList.ToModel <JMP.MDL.jmp_app>(blls.GetList(" a_id=(SELECT o_app_id FROM jmp_order WHERE o_id=" + oid + ") ").Tables[0]);
int pay_id = SelectUserInfo(mo.a_rid, mo.a_id);
JMP.BLL.jmp_order bll = new JMP.BLL.jmp_order();
if (pay_id > 0)
{
if (bll.UpdatePay(oid, pay_id))
{
string ddjj = Get_paystr(pay_id.ToString());
appid = ddjj.ToString().Split(',')[2];
string url = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=" + appid + "&redirect_uri=" + ConfigurationManager.AppSettings["redirecturipf"].ToString() + oid + ".html&response_type=code&scope=snsapi_base&state=1#wechat_redirect";
Response.Redirect(url, false);
}
}
else
{
Response.Write("非法访问！");
}
}
}
catch (Exception ex)
{
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息：" + ex.Message, summary: "浦发银行公众号支付接口错误信息", channelId: oid);
Response.Write("非法访问！");
}
}
else
{
Response.Write("非法访问！");
}
}
}
/// <summary>
/// 威富通微信公众号支付
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
int oid = !string.IsNullOrEmpty(Request["pid"]) ? Convert.ToInt32(Request["pid"].ToString()) : 0;
if (oid > 0)
{
//获取缓存
try
{
string appid = "";
string appms = "";
string code = !string.IsNullOrEmpty(Request["code"]) ? Request["code"] : "";
if (!String.IsNullOrEmpty(code))
{
//第二次
JMP.MDL.jmp_order morder = new JMP.BLL.jmp_order().SelectOrderGoodsName(oid, "jmp_order");
string ddjj = Get_paystr(morder.o_interface_id.ToString());
appid = ddjj.ToString().Split(',')[2];
appms = ddjj.ToString().Split(',')[3];
string openid = "";
string URL = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + appid + "&secret=" + appms + "&code=" + code + "&grant_type=authorization_code";
Encoding encoding = Encoding.UTF8;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
request.Timeout = 3000;
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
using (StreamReader reader = new StreamReader(response.GetResponseStream(), System.Text.Encoding.UTF8))
{
string jmpay = reader.ReadToEnd();
//解析json对象
JavaScriptSerializer serializer = new JavaScriptSerializer();
Dictionary <string, object> json = (Dictionary <string, object>)serializer.DeserializeObject(jmpay);
object value = null;
json.TryGetValue("openid", out value);
openid = value.ToString();
}
string str = "";
ClientResponseHandler resHandler = new ClientResponseHandler();
PayHttpClient pay = new PayHttpClient();
RequestHandler reqHandler = new RequestHandler(null);
Dictionary <string, string> cfg = Utils.Load_CfgInterfaceId(morder.o_interface_id);
reqHandler.setGateUrl(cfg["req_url"].ToString());
reqHandler.setKey(cfg["key"].ToString());
reqHandler.setParameter("out_trade_no", morder.o_code); //我们的订单号
reqHandler.setParameter("body", morder.o_goodsname); //商品描述
// reqHandler.setParameter("attach", string.IsNullOrEmpty(morder.o_privateinfo) ? "404" : morder.o_privateinfo);//附加信息
reqHandler.setParameter("total_fee", (Convert.ToInt32(morder.o_price * 100)).ToString()); //价格
reqHandler.setParameter("mch_create_ip", HttpContext.Current.Request.UserHostAddress); //终端IP
reqHandler.setParameter("service", "pay.weixin.jspay");
reqHandler.setParameter("mch_id", cfg["mch_id"].ToString());
reqHandler.setParameter("version", cfg["version"].ToString());
reqHandler.setParameter("notify_url", ConfigurationManager.AppSettings["notifyurl"].ToString().Replace("{0}", morder.o_interface_id.ToString())); //回掉地址
reqHandler.setParameter("callback_url", ConfigurationManager.AppSettings["callbackurl"].ToString().Replace("{0}", oid.ToString())); //同步回掉地址
reqHandler.setParameter("sub_openid", openid); //获取openid
reqHandler.setParameter("nonce_str", Utils.random()); //随机字符串
reqHandler.setParameter("charset", "UTF-8");
reqHandler.setParameter("sign_type", "MD5");
reqHandler.setParameter("is_raw", "1");//原生JS
#region 判断是否需要禁用信用卡
//JMP.MDL.jmp_app moapp = new JMP.MDL.jmp_app();
//int tid = 0;
//string hc = "gzhpdxykjy" + morder.o_app_id;
//if (JMP.TOOL.CacheHelper.IsCache(hc))//判读是否存在缓存
//{
// moapp = JMP.TOOL.CacheHelper.GetCaChe<JMP.MDL.jmp_app>(hc);//获取缓存
// if (moapp != null)
// {
// tid = moapp.a_apptype_id > 0 ? moapp.a_apptype_id : 0;
// if (tid == 0)
// {
// JMP.BLL.jmp_app blapp = new JMP.BLL.jmp_app();
// moapp = blapp.SelectId(morder.o_app_id);
// JMP.TOOL.CacheHelper.CacheObjectLocak<JMP.MDL.jmp_app>(moapp, hc, 5);//存入缓存
// }
// }
// else
// {
// JMP.BLL.jmp_app blapp = new JMP.BLL.jmp_app();
// moapp = blapp.SelectId(morder.o_app_id);
// tid = moapp.a_apptype_id > 0 ? moapp.a_apptype_id : 0;
// JMP.TOOL.CacheHelper.CacheObjectLocak<JMP.MDL.jmp_app>(moapp, hc, 5);//存入缓存
// }
//}
//else
//{
// JMP.BLL.jmp_app blapp = new JMP.BLL.jmp_app();
// moapp = blapp.SelectId(morder.o_app_id);
// tid = moapp.a_apptype_id > 0 ? moapp.a_apptype_id : 0;
// JMP.TOOL.CacheHelper.CacheObjectLocak<JMP.MDL.jmp_app>(moapp, hc, 5);//存入缓存
//}
//if (tid == 71)
//{
// reqHandler.setParameter("limit_credit_pay", "1");//是否限制信用卡（1：限制，0：不限制）
//}
#endregion
reqHandler.createSign();
string datawft = Utils.toXml(reqHandler.getAllParameters());
Dictionary <string, string> reqContent = new Dictionary <string, string>();
reqContent.Add("url", reqHandler.getGateUrl());
reqContent.Add("data", datawft);
pay.setReqContent(reqContent);
if (pay.call())
{
resHandler.setContent(pay.getResContent());
resHandler.setKey(cfg["key"].ToString());
Hashtable param = resHandler.getAllParameters();
Dictionary <string, string> dic = JMP.TOOL.UrlStr.hastable(param);
string wftmsg = JMP.TOOL.JsonHelper.DictJsonstr(dic);
if (resHandler.isTenpaySign())
{
if (int.Parse(param["status"].ToString()) == 0 && int.Parse(param["result_code"].ToString()) == 0)
{
string pay_info = dic["pay_info"];
if (!string.IsNullOrEmpty(pay_info))
{
Dictionary <string, object> List = new Dictionary <string, object>();
List = JMP.TOOL.JsonHelper.DataRowFromJSON(pay_info);
try
{
string chengstr = "<script type=\"text/javascript\">function onBridgeReady(){WeixinJSBridge.invoke( 'getBrandWCPayRequest', {\"appId\": \"" + List["appId"] + "\", \"timeStamp\": \"" + List["timeStamp"] + "\", \"nonceStr\": \"" + List["nonceStr"] + "\",\"package\":\"" + List["package"] + "\",\"signType\": \"MD5\",\"paySign\": \"" + List["paySign"] + "\" },function(res) {if (res.err_msg ==\"get_brand_wcpay_request:ok\") { window.location.href=\"" + List["callback_url"] + "\" }else{ alert(res.err_msg) } });}if (typeof WeixinJSBridge == \"undefined\"){if (document.addEventListener){document.addEventListener('WeixinJSBridgeReady', onBridgeReady, false);}else if (document.attachEvent){document.attachEvent('WeixinJSBridgeReady', onBridgeReady); document.attachEvent('onWeixinJSBridgeReady', onBridgeReady);} }else{onBridgeReady();}</script> ";
Response.Write(chengstr);
}
catch
{
string wftzfsbxin = "威富通公众号支付失败信息，错误信息：" + wftmsg;
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息openid:" + openid + "：" + wftzfsbxin, summary: "威富通公众号接口错误信息2", channelId: oid);
str = "{\"Message\":\"支付通道异常\",\"ErrorCode\":104}";
}
}
else
{
string wftzfsbxin = "威富通公众号支付失败信息，错误信息：" + wftmsg;
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息openid:" + openid + "：" + wftzfsbxin, summary: "威富通公众号接口错误信息4", channelId: oid);
str = "{\"Message\":\"支付通道异常\",\"ErrorCode\":104}";
}
}
else
{
string wftzfsbxin = "威富通公众号支付失败信息，错误信息：" + wftmsg;
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息openid:" + openid + "：" + wftzfsbxin, summary: "威富公众号通接口错误信息3", channelId: oid);
str = "{\"Message\":\"支付通道异常\",\"ErrorCode\":104}";
}
}
else
{
str = "{\"Message\":\"支付通道异常\",\"ErrorCode\":104}";
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息openid:" + openid, summary: "威富公众号通接口错误信息4", channelId: oid);
}
}
else
{
str = "{\"Message\":\"支付通道异常\",\"ErrorCode\":104}";
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息openid:" + openid, summary: "威富公众号通接口错误信息5", channelId: oid);
}
Response.Write(str);
}
else
{
JMP.MDL.jmp_app mo = new JMP.MDL.jmp_app();
JMP.BLL.jmp_app blls = new JMP.BLL.jmp_app();
mo = JMP.TOOL.MdlList.ToModel <JMP.MDL.jmp_app>(blls.GetList(" a_id=(SELECT o_app_id FROM jmp_order WHERE o_id=" + oid + ") ").Tables[0]);
if (mo != null)
{
Dictionary <string, string> cfg = Utils.loadCfgWxgzh(mo.a_rid, mo.a_id);
JMP.BLL.jmp_order bll = new JMP.BLL.jmp_order();
if (bll.UpdatePay(oid, int.Parse(cfg["pay_id"].ToString())))
{
string ddjj = Get_paystr(cfg["pay_id"].ToString());
appid = ddjj.ToString().Split(',')[2];
appms = ddjj.ToString().Split(',')[3];
string url = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=" + appid + "&redirect_uri=" + ConfigurationManager.AppSettings["redirecturi"].ToString() + oid + ".html&response_type=code&scope=snsapi_base#wechat_redirect";
Response.Redirect(url, false);
}
}
else
{
string str = "{\"Message\":\"支付接口异常\",\"ErrorCode\":102}";
Response.Write(str);
}
}
}
catch (Exception ex)
{
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息：" + ex.ToString() + "订单表id：" + oid, summary: "威富公众号通接口错误信息", channelId: oid);
Response.Write("非法访问！");
}
}
else
{
PayApiDetailErrorLogger.UpstreamPaymentErrorLog("报错信息：第一步判断，订单表id：" + oid, summary: "威富公众号通接口错误信息", channelId: oid);
Response.Write("非法访问！");
}
}
public override void ProcessNotify(int tid)
{
WxPayData notifyData = GetNotifyData(tid);
//检查支付结果中transaction_id是否存在
if (!notifyData.IsSet("transaction_id"))
{
//若transaction_id不存在，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "支付结果中微信订单号不存在");
page.Response.Write(res.ToXml());
page.Response.End();
}
string transaction_id = notifyData.GetValue("transaction_id").ToString();
//查询订单，判断订单真实性
string ordertime = notifyData.GetValue("time_end").ToString();
if (ordertime == "null")
{
//若订单查询失败，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "订单查询失败");
page.Response.Write(res.ToXml());
page.Response.End();
}
//查询订单成功
else
{
//商户订单号
string out_trade_no = notifyData.GetValue("out_trade_no").ToString();
//交易号
string trade_no = notifyData.GetValue("transaction_id").ToString();
//交易状态
string trade_status = notifyData.GetValue("result_code").ToString();
//买家账号
string buyer_email = notifyData.GetValue("transaction_id").ToString();
//买家付款时间
string gmt_payment = ordertime;
//交易金额（单位：分转换成元）
decimal o_price = decimal.Parse((decimal.Parse(notifyData.GetValue("total_fee").ToString()) / 100).ToString("f2"));
if (trade_status == "SUCCESS")
{
try
{
JMP.BLL.jmp_order order = new JMP.BLL.jmp_order();
JMP.MDL.jmp_order morder = new JMP.MDL.jmp_order();
string TableName = "jmp_order";
string orderTableName = JMP.TOOL.WeekDateTime.GetOrderTableName(DateTime.ParseExact(gmt_payment, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy-MM-dd"));//获取订单表名
morder = order.GetModelbycode(out_trade_no, TableName);
if (morder != null)
{
if (morder.o_price == o_price)
{
int payid = !string.IsNullOrEmpty(morder.o_paymode_id) ? Int32.Parse(morder.o_paymode_id) : 0;
if (JMP.TOOL.OrderProportion.ddbl(morder.o_app_id, o_price, payid))
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
page.Response.Write(res.ToXml());
page.Response.End();
}
else
{
if (morder.o_state != 1)
{
morder.o_tradeno = trade_no;
morder.o_ptime = DateTime.ParseExact(gmt_payment, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture);
morder.o_payuser = buyer_email;
morder.o_state = 1;
morder.o_noticestate = 0;
morder.o_price = o_price;
order.Update(morder, TableName);
JMP.MDL.jmp_app app = new JMP.MDL.jmp_app();
JMP.BLL.jmp_app appbll = new JMP.BLL.jmp_app();
app = appbll.SelectId(morder.o_app_id);
if (app != null)
{
JMP.MDL.jmp_queuelist quli = new JMP.MDL.jmp_queuelist();
JMP.BLL.jmp_queuelist bllq = new JMP.BLL.jmp_queuelist();
quli.q_address = morder.o_address;
quli.q_sign = new JMP.BLL.jmp_app().GetModel(morder.o_app_id).a_secretkey;
quli.q_noticestate = 0;
quli.q_times = 0;
quli.q_noticetimes = DateTime.Now;
quli.q_tablename = orderTableName;
quli.q_o_id = morder.o_id;
quli.trade_type = Int32.Parse(morder.o_paymode_id);
quli.trade_time = morder.o_ptime;
quli.trade_price = morder.o_price;
quli.trade_paycode = morder.o_tradeno;
quli.trade_code = morder.o_code;
quli.trade_no = morder.o_bizcode;
quli.q_privateinfo = morder.o_privateinfo;
quli.q_uersid = app.u_id;
int cg = bllq.Add(quli);
if (cg > 0)
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
page.Response.Write(res.ToXml());
page.Response.End();
}
else
{
//AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, "微信官网通知错误", "订单号：" + morder.o_code + "添加到通知队列失败");//写入报错日志
PayApiGlobalErrorLogger.Log("订单号：" + morder.o_code + "添加到通知队列失败", summary: "微信官网通知错误");
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "FAIL");
page.Response.Write(res.ToXml());
page.Response.End();
}
}
else
{
//AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, "微信官网通知错误", "应用id：" + morder.o_app_id + ",获取用户id失败！");//写入报错日志
PayApiGlobalErrorLogger.Log("应用id：" + morder.o_app_id + ",获取用户id失败！", summary: "微信官网通知错误");
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "FAIL");
page.Response.Write(res.ToXml());
page.Response.End();
}
}
else
{
//AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, "微信官网通知接口错误", "订单号：" + out_trade_no + ",未查询到相关信息！");//写入报错日志
PayApiGlobalErrorLogger.Log("订单号：" + out_trade_no + ",未查询到相关信息！", summary: "微信官网通知接口错误");
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
page.Response.Write(res.ToXml());
page.Response.End();
}
}
}
else
{
if (JMP.TOOL.UpdateOrder.OrderState.UpdateOrderState(morder.o_code, TableName))
{
string ddsm = "订单号：" + morder.o_code + ",支付信息异常请核实！";//短信说明
JMP.TOOL.Auditor.IAuditor audit = new JMP.TOOL.Auditor.OrderAbnormalAuditor(morder.o_code, orderTableName, morder.o_app_id, ddsm, trade_no, DateTime.ParseExact(gmt_payment, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture), o_price, "成功", morder.o_price);
audit.Add();
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
page.Response.Write(res.ToXml());
page.Response.End();
}
else
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "FAIL");
page.Response.Write(res.ToXml());
page.Response.End();
}
}
}
else
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "FAIL");
page.Response.Write(res.ToXml());
page.Response.End();
}
}
catch
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "FAIL");
page.Response.Write(res.ToXml());
page.Response.End();
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.jmp_app model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jmp_app set ");
strSql.Append(" a_auditstate = @a_auditstate , ");
strSql.Append(" a_secretkey = @a_secretkey , ");
strSql.Append(" a_time = @a_time , ");
strSql.Append(" a_showurl = @a_showurl , ");
strSql.Append(" a_auditor = @a_auditor , ");
strSql.Append(" a_rid = @a_rid , ");
strSql.Append(" a_appurl = @a_appurl , ");
strSql.Append(" a_appsynopsis = @a_appsynopsis , ");
strSql.Append(" a_user_id = @a_user_id , ");
strSql.Append(" a_name = @a_name , ");
strSql.Append(" a_platform_id = @a_platform_id , ");
strSql.Append(" a_paymode_id = @a_paymode_id , ");
strSql.Append(" a_apptype_id = @a_apptype_id , ");
strSql.Append(" a_notifyurl = @a_notifyurl , ");
strSql.Append(" a_key = @a_key , ");
strSql.Append(" a_state = @a_state ");
strSql.Append(" where a_id=@a_id ");
SqlParameter[] parameters =
{
new SqlParameter("@a_id", SqlDbType.Int, 4),
new SqlParameter("@a_auditstate", SqlDbType.Int, 4),
new SqlParameter("@a_secretkey", SqlDbType.NVarChar, -1),
new SqlParameter("@a_time", SqlDbType.DateTime),
new SqlParameter("@a_showurl", SqlDbType.NVarChar, -1),
new SqlParameter("@a_auditor", SqlDbType.NVarChar, 50),
new SqlParameter("@a_rid", SqlDbType.Int, 4),
new SqlParameter("@a_appurl", SqlDbType.NVarChar, 500),
new SqlParameter("@a_appsynopsis", SqlDbType.NVarChar, -1),
new SqlParameter("@a_user_id", SqlDbType.Int, 4),
new SqlParameter("@a_name", SqlDbType.NVarChar, -1),
new SqlParameter("@a_platform_id", SqlDbType.Int, 4),
new SqlParameter("@a_paymode_id", SqlDbType.NVarChar, -1),
new SqlParameter("@a_apptype_id", SqlDbType.Int, 4),
new SqlParameter("@a_notifyurl", SqlDbType.NVarChar, -1),
new SqlParameter("@a_key", SqlDbType.NVarChar, -1),
new SqlParameter("@a_state", SqlDbType.Int, 4)
};
parameters[0].Value = model.a_id;
parameters[1].Value = model.a_auditstate;
parameters[2].Value = model.a_secretkey;
parameters[3].Value = model.a_time;
parameters[4].Value = model.a_showurl;
parameters[5].Value = model.a_auditor;
parameters[6].Value = model.a_rid;
parameters[7].Value = model.a_appurl;
parameters[8].Value = model.a_appsynopsis;
parameters[9].Value = model.a_user_id;
parameters[10].Value = model.a_name;
parameters[11].Value = model.a_platform_id;
parameters[12].Value = model.a_paymode_id;
parameters[13].Value = model.a_apptype_id;
parameters[14].Value = model.a_notifyurl;
parameters[15].Value = model.a_key;
parameters[16].Value = model.a_state;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改应用
/// </summary>
/// <returns></returns>
public ActionResult UpdateAPP(int a_id)
{
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();
string glpt = "";
string zf = "";
string szmrdj = "";
string yy = "";
if (a_id > 0)
{
model = bll.SelectId(a_id);
#region =========获取应用平台在用信息=========
JMP.BLL.jmp_platform bllpl = new JMP.BLL.jmp_platform();
DataTable dt = bllpl.GetList(" 1=1 and p_state='1' ").Tables[0];//获取应用平台在用信息
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Int32.Parse(dt.Rows[i]["p_id"].ToString()) == model.a_platform_id)
{
glpt += "<option value=\"" + dt.Rows[i]["p_id"] + "\" selected=\"selected\" >" + dt.Rows[i]["p_name"] + "</option>";
}
else
{
glpt += "<option value=\"" + dt.Rows[i]["p_id"] + "\">" + dt.Rows[i]["p_name"] + "</option>";
}
}
#endregion
#region =====获取支付类型在用信息======
JMP.BLL.jmp_paymode zfbll = new JMP.BLL.jmp_paymode();
DataTable zfdt = zfbll.GetList(" 1=1 and p_state='1' ").Tables[0];//获取支付类型在用信息
string[] a_paymode = model.a_paymode_id.Split(',');
for (int k = 0; k < zfdt.Rows.Count; k++)
{
bool check = true;
for (int i = 0; i < a_paymode.Length; i++)
{
if (zfdt.Rows[k]["p_id"].ToString() == a_paymode[i])
{
zf += " <input type=\"checkbox\" name=\"zflx\" class=\"inputChck\" id=paytype_" + zfdt.Rows[k]["p_id"] + " data-stat=" + zfdt.Rows[k]["p_islocked"] + " value=" + zfdt.Rows[k]["p_id"] + " checked=\"checked\" /> " + zfdt.Rows[k]["p_name"];
check = false;
break;
}
}
if (check)
{
zf += " <input type=\"checkbox\" name=\"zflx\" class=\"inputChck\" id=paytype_" + zfdt.Rows[k]["p_id"] + " data-stat=" + zfdt.Rows[k]["p_islocked"] + " value=" + zfdt.Rows[k]["p_id"] + " /> " + zfdt.Rows[k]["p_name"];
}
}
#endregion
#region ========获取应用类型在用信息======
JMP.BLL.jmp_apptype yybll = new JMP.BLL.jmp_apptype();
string where = " t_id in (select DISTINCT(t_topid) from jmp_apptype where t_topid in( select t_id from jmp_apptype where t_topid='0' )) and t_state='1' order by t_sort desc";
DataTable yydt = yybll.GetList(where).Tables[0];//获取应用类型在用信息
JMP.MDL.jmp_apptype models = new JMP.MDL.jmp_apptype();
int t_topid = 0;
if (model.a_apptype_id > 0)
{
models = yybll.GetModel(model.a_apptype_id);//查询单条信息
t_topid = models.t_topid;
}
string yyid = "";
for (int j = 0; j < yydt.Rows.Count; j++)
{
yyid = "yy" + yydt.Rows[j]["t_id"].ToString();
if (t_topid > 0)
{
if (Int32.Parse(yydt.Rows[j]["t_id"].ToString()) == models.t_topid)
{
szmrdj = yyid;
yy += "<input type=\"button\" id='" + yyid + "' name=\"yyname\" onclick=\"xzyylx(this.id,0)\" class=\"xzinput\" value=" + yydt.Rows[j]["t_name"] + " />";
}
else
{
yy += "<input type=\"button\" id='" + yyid + "' name=\"yyname\" onclick=\"xzyylx(this.id,0)\" class=\"inpuwxz\" value=" + yydt.Rows[j]["t_name"] + " />";
}
}
else
{
yy += "<input type=\"button\" id='" + yyid + "' name=\"yyname\" onclick=\"xzyylx(this.id,0)\" class=\"inpuwxz\" value=" + yydt.Rows[j]["t_name"] + " />";
}
}
#endregion
#region 根据应用子类型获取风险等级
JMP.BLL.jmp_risklevelallocation ribll = new JMP.BLL.jmp_risklevelallocation();
List <JMP.MDL.jmp_risklevelallocation> rilist = new List <JMP.MDL.jmp_risklevelallocation>();
rilist = ribll.SelectAppType(model.a_apptype_id);
ViewBag.rilist = rilist;
#endregion
}
ViewBag.model = model;
ViewBag.glpt = glpt;
ViewBag.zf = zf;
ViewBag.yy = yy;
ViewBag.szmrdj = szmrdj;
return(View());
}
/// <summary>
/// 添加或修改应用
/// </summary>
/// <returns></returns>
public JsonResult InsertUpdateApp(JMP.MDL.jmp_app mod)
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
//string xgzfc = "";
if (string.IsNullOrEmpty(mod.a_paymode_id))
{
retJson = new { success = 0, msg = "请选择支付类型" };
}
else
{
if (mod.a_apptype_id == 0)
{
retJson = new { success = 0, msg = "请选择应用类型" };
}
else
{
if (mod.a_id > 0)
{
#region 修改应用
JMP.MDL.jmp_app modapp = new JMP.MDL.jmp_app();
modapp = bll.GetModel(mod.a_id);
//克隆对象
// object modclone = CloneObject.Clone(modapp);
var modclone = modapp.Clone();
if (mod.a_apptype_id != modapp.a_apptype_id)
{
modapp.a_auditstate = 0; //应用审核状态(0未审核)
modapp.a_rid = 0; //风险等级配置表id
}
modapp.a_name = mod.a_name; //应用名称
modapp.a_platform_id = mod.a_platform_id; //关联平台ID
modapp.a_paymode_id = mod.a_paymode_id; //关联支付类型ID
modapp.a_apptype_id = mod.a_apptype_id; //关联应用类型ID
modapp.a_notifyurl = mod.a_notifyurl; //回掉地址
modapp.a_user_id = mod.a_user_id; //开发者ID
modapp.a_showurl = mod.a_showurl; //同步地址
modapp.a_appurl = mod.a_appurl; //应用审核地址
modapp.a_appsynopsis = mod.a_appsynopsis; //应用简介
if (mod.a_auditstate != 0)
{
if (string.IsNullOrEmpty(mod.a_auditor))
{
mod.a_auditor = UserInfo.UserName;
}
}
else
{
mod.a_auditor = "";
}
if (bll.Update(modapp))
{
Logger.ModifyLog("修改应用", modclone, modapp);
retJson = new { success = 1, msg = "修改成功" };
}
else
{
retJson = new { success = 0, msg = "修改失败" };
}
#endregion
}
else
{
#region 添加应用
mod.a_state = 1;
mod.a_auditstate = 0;
mod.a_key = "";
mod.a_secretkey = "";
mod.a_time = DateTime.Now;
int cg = bll.Add(mod);
if (cg > 0)
{
Logger.CreateLog("添加应用", mod);
//while (true)
//{
mod.a_key = DESEncrypt.Encrypt(mod.a_user_id + ";" + cg + ";" + DateTime.Now.ToString("yyyyMMddssmmfff"));
//if (!bll.Existss(mod.a_key))
//{
// break;
//}
//}
mod.a_secretkey = DESEncrypt.Encrypt(cg + ";" + mod.a_key + ";" + DateTime.Now.ToString("yyyyMMddssmmfff"));
mod.a_id = cg;
if (bll.Update(mod))
{
Logger.OperateLog("修改应用key", mod.a_key);
retJson = new { success = 1, msg = "添加成功" };
}
else
{
retJson = new { success = 0, msg = "添加失败" };
}
}
else
{
retJson = new { success = 0, msg = "添加失败" };
}
#endregion
}
}
}
return(Json(retJson));
}
public JsonResult InsertUpdateApp(JMP.MDL.jmp_app mod)
{
object retJson = new { success = 0, msg = "操作失败" };
JMP.BLL.jmp_app bll = new JMP.BLL.jmp_app();
if (mod.a_apptype_id == 0)
{
retJson = new { success = 0, msg = "请选择应用类型" };
}
else
{
if (mod.a_id > 0)
{
#region 修改应用
JMP.MDL.jmp_app modapp = new JMP.MDL.jmp_app();
modapp = bll.GetModel(mod.a_id);
var modclone = modapp.Clone();
modapp.a_name = mod.a_name; //应用名称
modapp.a_platform_id = mod.a_platform_id; //关联平台ID
modapp.a_paymode_id = mod.a_paymode_id; //关联支付类型ID
modapp.a_apptype_id = mod.a_apptype_id; //关联应用类型ID
modapp.a_notifyurl = mod.a_notifyurl; //回掉地址
modapp.a_showurl = mod.a_showurl; //同步地址
modapp.a_appurl = mod.a_appurl; //应用审核地址
modapp.a_appsynopsis = mod.a_appsynopsis; //应用简介
//mod.a_auditstate = modapp.a_auditstate;//应用审核状态
//mod.a_key = modapp.a_key;
//mod.a_state = modapp.a_state;
//mod.a_secretkey = modapp.a_secretkey;
//mod.a_time = modapp.a_time;
//mod.a_user_id = modapp.a_user_id;
//mod.a_rid = modapp.a_rid;
if (bll.Update(modapp))
{
Logger.ModifyLog("修改应用", modclone, mod);
retJson = new { success = mod.a_id, msg = "修改成功" };
}
else
{
retJson = new { success = 0, msg = "修改失败" };
}
#endregion
}
else
{
#region 添加应用
mod.a_rid = 0;
mod.a_auditor = "";
mod.a_state = 1;
mod.a_auditstate = 0;
mod.a_key = "";
mod.a_secretkey = "";
mod.a_time = DateTime.Now;
mod.a_user_id = UserInfo.UserId;
int cg = bll.Add(mod);
if (cg > 0)
{
AddLocLog.AddUserLog(UserInfo.UserId, 3, RequestHelper.GetClientIp(), "添加应用", "添加应用");
mod.a_key = DESEncrypt.Encrypt(mod.a_user_id + ";" + cg + ";" + DateTime.Now.ToString("yyyyMMddssmmfff"));
mod.a_secretkey = DESEncrypt.Encrypt(cg + ";" + mod.a_key + ";" + DateTime.Now.ToString("yyyyMMddssmmfff"));
mod.a_id = cg;
if (bll.Update(mod))
{
Logger.CreateLog("新增应用", mod);
retJson = new { success = 1, msg = "添加成功" };
}
else
{
retJson = new { success = 0, msg = "添加失败" };
}
}
else
{
retJson = new { success = 0, msg = "添加失败" };
}
#endregion
}
}
return(Json(retJson));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.jmp_app GetModel(int a_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select a_id, a_auditstate, a_secretkey, a_time, a_showurl, a_auditor, a_rid, a_appurl, a_appsynopsis, a_user_id, a_name, a_platform_id, a_paymode_id, a_apptype_id, a_notifyurl, a_key, a_state ");
strSql.Append(" from jmp_app ");
strSql.Append(" where a_id=@a_id");
SqlParameter[] parameters =
{
new SqlParameter("@a_id", SqlDbType.Int, 4)
};
parameters[0].Value = a_id;
JMP.MDL.jmp_app model = new JMP.MDL.jmp_app();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["a_id"].ToString() != "")
{
model.a_id = int.Parse(ds.Tables[0].Rows[0]["a_id"].ToString());
}
if (ds.Tables[0].Rows[0]["a_auditstate"].ToString() != "")
{
model.a_auditstate = int.Parse(ds.Tables[0].Rows[0]["a_auditstate"].ToString());
}
model.a_secretkey = ds.Tables[0].Rows[0]["a_secretkey"].ToString();
if (ds.Tables[0].Rows[0]["a_time"].ToString() != "")
{
model.a_time = DateTime.Parse(ds.Tables[0].Rows[0]["a_time"].ToString());
}
model.a_showurl = ds.Tables[0].Rows[0]["a_showurl"].ToString();
model.a_auditor = ds.Tables[0].Rows[0]["a_auditor"].ToString();
if (ds.Tables[0].Rows[0]["a_rid"].ToString() != "")
{
model.a_rid = int.Parse(ds.Tables[0].Rows[0]["a_rid"].ToString());
}
model.a_appurl = ds.Tables[0].Rows[0]["a_appurl"].ToString();
model.a_appsynopsis = ds.Tables[0].Rows[0]["a_appsynopsis"].ToString();
if (ds.Tables[0].Rows[0]["a_user_id"].ToString() != "")
{
model.a_user_id = int.Parse(ds.Tables[0].Rows[0]["a_user_id"].ToString());
}
model.a_name = ds.Tables[0].Rows[0]["a_name"].ToString();
if (ds.Tables[0].Rows[0]["a_platform_id"].ToString() != "")
{
model.a_platform_id = int.Parse(ds.Tables[0].Rows[0]["a_platform_id"].ToString());
}
model.a_paymode_id = ds.Tables[0].Rows[0]["a_paymode_id"].ToString();
if (ds.Tables[0].Rows[0]["a_apptype_id"].ToString() != "")
{
model.a_apptype_id = int.Parse(ds.Tables[0].Rows[0]["a_apptype_id"].ToString());
}
model.a_notifyurl = ds.Tables[0].Rows[0]["a_notifyurl"].ToString();
model.a_key = ds.Tables[0].Rows[0]["a_key"].ToString();
if (ds.Tables[0].Rows[0]["a_state"].ToString() != "")
{
model.a_state = int.Parse(ds.Tables[0].Rows[0]["a_state"].ToString());
}
return(model);
}
else
{
return(null);
}
}
