/// <summary> /// 连连复核处理 /// </summary> /// <param name="LLcashid"></param> /// <returns></returns> public ActionResult LLCashPay(int LLcashid) { string str11 = ""; DataTable dt = getinfo(LLcashid); if (dt.Rows.Count > 0) { string no_order = dt.Rows[0]["no_order"].ToString(); M_LLPay m = new M_LLPay(); m.Acct_name = dt.Rows[0]["acct_name"].ToString(); m.Card_no = dt.Rows[0]["card_no"].ToString(); m.No_order = dt.Rows[0]["no_order"].ToString(); m.Dt_order = dt.Rows[0]["dt_order"].ToString(); m.Money_order = dt.Rows[0]["money_order"].ToString(); m.City_code = dt.Rows[0]["city_code"].ToString(); m.Bank_code = dt.Rows[0]["bank_code"].ToString(); m.Brabank_name = dt.Rows[0]["brabank_name"].ToString(); string sql = "update hx_td_LL_cash set paystate=5 where paystate=3 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); BLL.EF.LLpay llp = new BLL.EF.LLpay(); string str = llp.cashpay(m); //Response.Write(str); YinTongUtil.writelog("单个批付及时处理" + no_order + "批付成功 str=" + str); var Objlist = JObject.Parse(str); if (Objlist["ret_code"].ToString() == "0000") { sql = "update hx_td_LL_cash set paystate=1 ,OperTime='" + DateTime.Now.ToString() + "' where paystate= 5 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); // CommonOperate.Show_Msg("批付成功"); str11 = StringAlert.Alert("批付成功"); YinTongUtil.writelog("单个批付及时处理" + no_order + "批付成功 sql=" + sql); Response.End(); } else { sql = "update hx_td_LL_cash set paystate=2 ,OperTime='" + DateTime.Now.ToString() + "' where paystate= 5 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); str11 = StringAlert.Alert("批付失败"); //CommonOperate.Show_Msg("批付失败"); // Response.End(); } YinTongUtil.writelog("前面处理付款:" + str); } return(Content(str11)); // return View(); }
public ActionResult LLCashProcessingmore(string str2) { string json = ""; if (string.IsNullOrEmpty(str2)) { json = @"{""ret"":0,""msg"":""参数错误""}"; } // json = @"{""ret"":-1,""msg"":""功能待完善""}"; string bid = str2; string[] s = bid.Split(new char[] { ',' }); string sqllist = ""; for (int i = 0; i < s.Length; i++) { if (i == s.Length - 1) { sqllist = sqllist + "'" + s[i] + "'"; } else { sqllist = sqllist + "'" + s[i] + "',"; } } string sql = " select LLcashid,no_order,dt_order,money_order,acct_name,province_code,city_code,brabank_name,ordertime,card_no,paystate,Usrid,BankName,bank_code from V_LL_Cash_User where LLcashid in (" + sqllist + ") and h_state=1 and paystate=3"; DataTable dt = DbHelperSQL.GET_DataTable_List(sql); int succ = 0, lost = 0; for (int i = 0; i < dt.Rows.Count; i++) { M_LLPay m = new M_LLPay(); m.Acct_name = dt.Rows[i]["acct_name"].ToString(); m.Card_no = dt.Rows[i]["card_no"].ToString(); m.No_order = dt.Rows[i]["no_order"].ToString(); m.Dt_order = dt.Rows[i]["dt_order"].ToString(); m.Money_order = dt.Rows[i]["money_order"].ToString(); m.City_code = dt.Rows[i]["city_code"].ToString(); m.Bank_code = dt.Rows[i]["bank_code"].ToString(); m.Brabank_name = dt.Rows[i]["brabank_name"].ToString(); sql = "update hx_td_LL_cash set paystate=5 where paystate=3 and LLcashid in (" + sqllist + ") "; DbHelperSQL.RunSql(sql); BLL.EF.LLpay llp = new BLL.EF.LLpay(); string str = llp.cashpay(m); string no_order = dt.Rows[i]["no_order"].ToString(); var Objlist = JObject.Parse(str); if (Objlist["ret_code"].ToString() == "0000") { sql = "update hx_td_LL_cash set paystate=1,OperTime='" + DateTime.Now.ToString() + "' where paystate=5 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); // CommonOperate.Show_Msg("批付成功"); YinTongUtil.writelog(no_order + "批量批付成功sql=" + sql); succ = succ + 1; //Response.End(); } else { // CommonOperate.Show_Msg("批付失败"); sql = "update hx_td_LL_cash set paystate=2,OperTime='" + DateTime.Now.ToString() + "' where paystate=5 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); // CommonOperate.Show_Msg("批付成功"); YinTongUtil.writelog(no_order + "批付失败sql=" + sql); lost = lost + 1; } // Response.Write(dt.Rows[i]["card_no"].ToString() + str + "<br>"); YinTongUtil.writelog(dt.Rows[i]["card_no"].ToString() + "批处理付款:" + str); } json = @"{""ret"":1,""msg"":""成功AB笔,失败BB笔""}"; json = json.Replace("AB", succ.ToString()).Replace("BB", lost.ToString()); return(Content(json, "text/json")); }
public ActionResult ReLLCash(string no_order, int bu) { //原页面路径:/admin/ReLLCash.aspx string json = ""; if (string.IsNullOrEmpty(no_order) || bu <= 0) { json = @"{""ret"":0,""msg"":""参数错误""}"; } if (bu > 0 && no_order != "") { //生成连连新支付单号 string LLNew_ordid = YinTongUtil.getCurrentDateTimeStr(); string sql = " select Acct_name,Card_no,no_order,dt_order,money_order,city_code,bank_code,brabank_name from hx_td_LL_cash where paystate=2 and no_order='" + no_order + "' "; // sql = " select OutAcctId,InAcctId,TransAmt from hx_td_LLpay_re_cash where htype=0 and h_state=0 and OrdId='" + OrdId + "' and no_order='" + no_order + "'"; DataTable dt = DbHelperSQL.GET_DataTable_List(sql); if (dt.Rows.Count > 0) { string Remarks = "原订单号:" + no_order + " 支付失败 替新订单 " + LLNew_ordid + " 重新支付 <br>"; sql = "update hx_td_LL_cash set no_order='" + LLNew_ordid + "' ,Remarks='" + Remarks + "' where paystate=2 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); sql = " update hx_td_LLpay_re_cash set no_order='" + LLNew_ordid + "' where htype=1 and no_order='" + no_order + "'"; DbHelperSQL.RunSql(sql); M_LLPay m = new M_LLPay(); m.Acct_name = dt.Rows[0]["acct_name"].ToString(); m.Card_no = dt.Rows[0]["card_no"].ToString(); m.No_order = LLNew_ordid; m.Dt_order = dt.Rows[0]["dt_order"].ToString(); m.Money_order = dt.Rows[0]["money_order"].ToString(); m.City_code = dt.Rows[0]["city_code"].ToString(); m.Bank_code = dt.Rows[0]["bank_code"].ToString(); m.Brabank_name = dt.Rows[0]["brabank_name"].ToString(); sql = "update hx_td_LL_cash set paystate=5 where paystate=2 and no_order='" + LLNew_ordid + "'"; DbHelperSQL.RunSql(sql); BLL.EF.LLpay llp = new BLL.EF.LLpay(); string str = llp.cashpay(m); Response.Write(str); YinTongUtil.writelog("单个重新批付及时处理" + no_order + "批付成功 str=" + str); var Objlist = JObject.Parse(str); if (Objlist["ret_code"].ToString() == "0000") { sql = "update hx_td_LL_cash set paystate=1 ,OperTime='" + DateTime.Now.ToString() + "' where paystate= 5 and no_order='" + LLNew_ordid + "'"; DbHelperSQL.RunSql(sql); json = @"{""ret"":1,""msg"":""重新批付成功""}"; // CommonOperate.Show_Msg("重新批付成功 :" + sql); YinTongUtil.writelog("单个重新批付及时处理" + no_order + "批付成功 "); Response.End(); } else { sql = "update hx_td_LL_cash set paystate=2 ,OperTime='" + DateTime.Now.ToString() + "' where paystate= 5 and no_order='" + LLNew_ordid + "'"; DbHelperSQL.RunSql(sql); json = @"{""ret"":0,""msg"":""批付失败""}"; //CommonOperate.Show_Msg("批付失败"); Response.End(); } YinTongUtil.writelog("前面处理付款:" + str); } } //json = @"{""ret"":-1,""msg"":""功能待完善""}"; return(Content(json, "text/json")); }