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