string IPayBLL.Query(string mer_id, string sheet_no, string pay_type)
{
DB.IDB db = new DB.DBByAutoClose(Appsetting.conn);
string status = "0";
try
{
//微信支付生成微信预支付订单
if (pay_type == "W")
{
try
{
Wxpay.MicroPay bll = new Wxpay.MicroPay();
int eid = 0;
string emsg = "";
bll.WXMicroPayQuery(mer_id, sheet_no, out eid, out emsg);
if (eid == 0)
{
status = "1";
}
else if (eid == 1)
{
status = "2";
throw new Exception("微信扫码支付失败[" + eid.ToString() + "]:" + emsg);
}
else
{
status = "0";
}
}
catch (Exception ex2)
{
throw ex2;
}
}
else if (pay_type == "Z")
{
try
{
IBLL.ISysBLL bll = new BLL.SysBLL();
body.alipay acc = bll.GetMerAlipayById(mer_id);
if (acc == null)
{
throw new Exception("未初始化支付宝商家帐户");
}
Com.Alipay.AliPay alibll = new Com.Alipay.AliPay();
var emsg = "";
var res = alibll.Alipay_Query(acc.app_id, acc.rsa1_private, acc.rsa1, sheet_no, out emsg);
if (!res)
{
throw new Exception("支付宝扫码支付失败:" + emsg);
}
else
{
status = "1";
}
}
catch (Exception ex2)
{
throw ex2;
}
}
//
if (status != "1")
{
string sql = "update ot_pay_record set status=@status where sheet_no=@sheet_no ";
var pars = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@sheet_no", sheet_no),
new System.Data.SqlClient.SqlParameter("@status", status)
};
db.ExecuteScalar(sql, pars);
}
return(status);
}
catch (Exception ex)
{
LogHelper.writeLog("PayBLL.Query()", ex.ToString(), sheet_no, mer_id, pay_type);
throw ex;
}
}
void IPayBLL.MicroPay(string ori_sheet_no, string mer_id, string jh, string pay_type, decimal pay_amt, string barcode, out string sheet_no, out string status, out int errId, out string errMsg)
{
DB.IDB db = new DB.DBByAutoClose(Appsetting.conn);
sheet_no = "";
errId = 0;
errMsg = "";
status = "0";
try
{
sheet_no = mer_id + create_sheet_no();//商家编号+14位单号
//微信支付生成微信预支付订单
if (pay_type == "W")
{
try
{
Wxpay.MicroPay bll = new Wxpay.MicroPay();
int eid = 0;
string emsg = "";
bll.WXMicroPay(mer_id, sheet_no, pay_amt, barcode, jh, out eid, out emsg);
errId = eid;
errMsg = emsg;
if (eid == 0)
{
status = "1";
}
else if (eid == 1)
{
status = "2";
throw new Exception("微信扫码支付失败[" + eid.ToString() + "]:" + errMsg);
}
else
{
status = "0";
}
}
catch (Exception ex2)
{
throw ex2;
}
}
else if (pay_type == "Z")
{
try
{
IBLL.ISysBLL bll = new BLL.SysBLL();
body.alipay acc = bll.GetMerAlipayById(mer_id);
if (acc == null)
{
throw new Exception("未初始化支付宝商家帐户");
}
Com.Alipay.AliPay alibll = new Com.Alipay.AliPay();
var emsg = "";
var res = alibll.Alipay_BarcodePay(acc.app_id, acc.rsa1_private, acc.rsa1, sheet_no, "commongoods", pay_amt, barcode, acc.pid, out emsg);
status = "1";
if (!res)
{
status = "2";
errId = -1;
errMsg = emsg;
throw new Exception("支付宝扫码支付失败:" + emsg);
}
}
catch (Exception ex2)
{
throw ex2;
}
}
//
string sql = "insert into ot_pay_record(sheet_no,mer_id,jh,pay_type,pay_scene,pay_amt,status,create_time,ori_sheet_no)";
sql += "values(@sheet_no,@mer_id,@jh,@pay_type,@pay_scene,@pay_amt,@status,getdate(),@ori_sheet_no) ";
var pars = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@sheet_no", sheet_no),
new System.Data.SqlClient.SqlParameter("@ori_sheet_no", ori_sheet_no),
new System.Data.SqlClient.SqlParameter("@mer_id", mer_id),
new System.Data.SqlClient.SqlParameter("@jh", jh),
new System.Data.SqlClient.SqlParameter("@pay_type", pay_type),
new System.Data.SqlClient.SqlParameter("@pay_amt", pay_amt),
new System.Data.SqlClient.SqlParameter("@status", status),
new System.Data.SqlClient.SqlParameter("@pay_scene", "barcode_pay")
};
db.ExecuteScalar(sql, pars);
}
catch (Exception ex)
{
LogHelper.writeLog("PayBLL.MicroPay()", ex.ToString(), sheet_no, ori_sheet_no, mer_id, pay_type, jh, pay_amt.ToString());
throw ex;
}
}
