public Result_1343 CustRegisterSignYeePayInterface(string requestNumber, ReqView_1343 reqView_1343)
{
SpotTranInterface client = new SpotTranInterface();
var req_1343 = new Req_1343();
req_1343.SupAcctId = reqView_1343.SupAcctId;
req_1343.ThirdCustId = reqView_1343.ThirdCustId;
req_1343.AcctId = reqView_1343.AcctId;
req_1343.CustName = reqView_1343.CustName;
req_1343.IdType = reqView_1343.IdType;
req_1343.IdCode = reqView_1343.IdCode;
req_1343.MobilePhone = reqView_1343.MobilePhone;
req_1343.CpFlag = 2;
req_1343.BankType = 1;
req_1343.BankName = "平安银行";
req_1343.BankCode = "";
req_1343.Reserve = "1343";
req_1343.SBankCode = "307584007998";
var result = client.CustRegisterSignYeePayInterface(requestNumber, req_1343);
var resview_1343 = new Result_1343();
resview_1343.RspCode = result.RspCode;
resview_1343.RspMsg = result.RspMsg;
if (result.Model != null)
{
resview_1343.ThirdCustId = result.Model.ThirdCustId;
resview_1343.SerialNo = result.Model.SerialNo;
resview_1343.Reserve = result.Model.Reserve;
}
return(resview_1343);
}
/// <summary>
/// 处理1343的请求
/// </summary>
/// <param name="req_1343"></param>
/// <returns></returns>
public static int AddOrUpdateMemberInfo(Req_1343 req_1343, string serialNo)
{
string sql = "select count(1) from MemberInfo where SupAcctId=@SupAcctId and ThirdCustId=@ThirdCustId and MobilePhone=@MobilePhone and Status=0 and DealStatus=-1";
var obj = MySqlHelper.ExecuteScalar(strConnection, sql, new MySqlParameter[] {
new MySqlParameter("@SupAcctId", req_1343.SupAcctId),
new MySqlParameter("@ThirdCustId", req_1343.ThirdCustId),
new MySqlParameter("@MobilePhone", req_1343.MobilePhone),
new MySqlParameter("@AcctId", req_1343.AcctId),
});
int retValue = -1;
if (obj != null)
{
var param = new MySqlParameter[] {
new MySqlParameter("@SupAcctId", req_1343.SupAcctId),
new MySqlParameter("@ThirdCustId", req_1343.ThirdCustId),
new MySqlParameter("@CustName", req_1343.CustName),
new MySqlParameter("@IdType", req_1343.IdType),
new MySqlParameter("@IdCode", req_1343.IdCode),
new MySqlParameter("@CpFlag", req_1343.CpFlag),
new MySqlParameter("@AcctId", req_1343.AcctId),
new MySqlParameter("@BankType", req_1343.BankType),
new MySqlParameter("@BankName", req_1343.BankName),
new MySqlParameter("@BankCode", req_1343.BankCode),
new MySqlParameter("@SBankCode", req_1343.SBankCode),
new MySqlParameter("@MobilePhone", req_1343.MobilePhone),
new MySqlParameter("@EmailAddr", req_1343.EmailAddr),
new MySqlParameter("@RegAddress", req_1343.RegAddress),
new MySqlParameter("@Zip", req_1343.Zip),
new MySqlParameter("@ErpAddress", req_1343.Address),
new MySqlParameter("@ContactUser", req_1343.ContactUser),
new MySqlParameter("@Reserve", req_1343.Reserve),
new MySqlParameter("@SerialNo", serialNo)
};
if (int.TryParse(obj.ToString(), out retValue) &&
retValue == 0 &&
!string.IsNullOrEmpty(serialNo)
)
{
//添加
sql = "insert into MemberInfo(`SupAcctId`,`ThirdCustId`,`CustName`,`IdType`,`IdCode`,`CpFlag`,`AcctId`,`BankType`,`BankName`,`BankCode`,`SBankCode`,`MobilePhone`,`EmailAddr`,`RegAddress`,`Zip`,`ErpAddress`,`ContactUser`,`Reserve`,`SerialNo`,`DealStatus`,`LastOption`) values(";
sql += " @SupAcctId,@ThirdCustId,@CustName,@IdType,@IdCode,@CpFlag,@AcctId,@BankType,@BankName,@BankCode,@SBankCode,@MobilePhone,@EmailAddr,@RegAddress,@Zip,@ErpAddress,@ContactUser,@Reserve,@SerialNo,-1,'add_1303' ) ";
obj = MySqlHelper.ExecuteScalar(strConnection, sql + ";select @@IDENTITY;", param);
int.TryParse(obj.ToString(), out retValue);
}
}
return(retValue);
}
public Result_1343 CustErpRegisterSignYeePayInterface(string requestNumber, Req_1343 req_1343)
{
SpotTranInterface client = new SpotTranInterface();
var result = client.CustRegisterSignYeePayInterface(requestNumber, req_1343);
var resview_1343 = new Result_1343();
resview_1343.RspCode = result.RspCode;
resview_1343.RspMsg = result.RspMsg;
if (result.Model != null)
{
resview_1343.ThirdCustId = result.Model.ThirdCustId;
resview_1343.SerialNo = result.Model.SerialNo;
resview_1343.Reserve = result.Model.Reserve;
}
return(resview_1343);
}
/// <summary>
/// 会员注册签约易宝【1343】
/// </summary>
/// <param name="serialNumber">请求流水号</param>
/// <param name="req_1343">请求信息</param>
/// <param name="counterId">操作员号 5位</param>
/// <returns></returns>
public DataResult CustRegisterSignYeePayInterface(string serialNumber, Req_1343 req_1343, string counterId = "")
{
//用于存放生成请求报文的参数
ExHashTable parmaKeyDict = new ExHashTable();
//请求流水号
//string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
//交易码
parmaKeyDict.Add("TranFunc", "1343");
//请求流水号
parmaKeyDict.Add("ThirdLogNo", serialNumber);
//操作员号
parmaKeyDict.Add("CounterId", counterId);
//传递对象
parmaKeyDict.Add("Model", req_1343);
//获取结果
var retKeyDict = GetResult(parmaKeyDict);
if (retKeyDict.RspCode.Equals("000000"))
{
retKeyDict.Model = retKeyDict.ToModel <Res_1343>();
}
return(retKeyDict);
}