/// <summary>
/// 会员签解约维护【1303】
/// </summary>
/// <param name="parmaKeyDict"></param>
/// <returns></returns>
public string BuildString_1303(ExHashTable parmaKeyDict)
{
string result = string.Empty;
//接收的数据
var req = Utils.ToDataResult(parmaKeyDict, GlobalData.B2BSpotVersion);
if (req != null)
{
Req_1303 reqModel = req.ToModel <Req_1303>();
var resModel = new Res_1303();
var notifyResult = new NotifyResult()
{
ReqData = reqModel,
RspData = resModel,
DataResult = req
};
//处理业务
var handler = BuildHandler.GetHandler();
if (handler != null)
{
handler.Process(req.FuncCode, notifyResult);
}
//业务处理成功后更改 响应码:RspCode 为成功 "000000"
parmaKeyDict.Set("RspCode", notifyResult.RspStatus.Code);
parmaKeyDict.Set("RspMsg", notifyResult.RspStatus.Msg);
//返回内容
result = Utils.JoinModelString <Res_1303>(notifyResult.RspData);
}
return(result);
}
/// <summary>
/// 处理1303的请求
/// </summary>
/// <param name="req_1303"></param>
/// <returns></returns>
public static int AddOrUpdateMemberInfo(Req_1303 req_1303)
{
string sql = "select count(1) from MemberInfo where CustAcctId=@CustAcctId";
var obj = MySqlHelper.ExecuteScalar(strConnection, sql, new MySqlParameter[] {
new MySqlParameter("@CustAcctId", req_1303.CustAcctId)
});
int retValue = -1;
if (obj != null)
{
var param = new MySqlParameter[] {
new MySqlParameter("@SupAcctId", req_1303.SupAcctId),
new MySqlParameter("@CustAcctId", req_1303.CustAcctId),
new MySqlParameter("@CustName", req_1303.CustName),
new MySqlParameter("@ThirdCustId", req_1303.ThirdCustId),
new MySqlParameter("@IdType", req_1303.IdType),
new MySqlParameter("@IdCode", req_1303.IdCode),
new MySqlParameter("@RelatedAcctId", req_1303.RelatedAcctId),
new MySqlParameter("@AcctFlag", req_1303.AcctFlag),
new MySqlParameter("@TranType", req_1303.TranType),
new MySqlParameter("@AcctName", req_1303.AcctName),
new MySqlParameter("@BankCode", req_1303.BankCode),
new MySqlParameter("@BankName", req_1303.BankName),
new MySqlParameter("@OldRelatedAcctId", req_1303.OldRelatedAcctId),
new MySqlParameter("@Reserve", req_1303.Reserve)
};
if (int.TryParse(obj.ToString(), out retValue) &&
retValue == 0)
{
if (req_1303.FuncFlag == 1)
{
var list = new List <MySqlParameter>();
list.AddRange(param);
list.Add(new MySqlParameter("@Status", 1));
list.Add(new MySqlParameter("@DealStatus", 0));
//添加
sql = "insert into MemberInfo(`Status`,`DealStatus`,`SupAcctId`,`CustAcctId`,`CustName`,`ThirdCustId`,`IdType`,`IdCode`,`RelatedAcctId`,`AcctFlag`,`TranType`,`AcctName`,`BankCode`,`BankName`,`OldRelatedAcctId`,`Reserve`,`LastOption`) values(";
sql += " @Status,@DealStatus,@CustAcctId,@RelatedAcctId,@AcctFlag,@TranType,@AcctName,@BankCode,@BankName,@Address,@OldRelatedAcctId,@Reserve,'add_1303' ) ";
obj = MySqlHelper.ExecuteScalar(strConnection, sql + ";select @@IDENTITY;", list.ToArray());
int.TryParse(obj.ToString(), out retValue);
}
}
else
{
var list = new List <MySqlParameter>();
list.AddRange(param);
list.Add(new MySqlParameter("@Status", req_1303.FuncFlag == 2));
//修改
sql = " update MemberInfo set Status=@Status," + (req_1303.FuncFlag == 2 ? " DealStatus=0, " : "") + " SupAcctId=@SupAcctId,CustAcctId=@CustAcctId,CustName=@CustName,ThirdCustId=@ThirdCustId,IdType=@IdType,IdCode=@IdCode,RelatedAcctId=@RelatedAcctId,AcctFlag=@AcctFlag,TranType=@TranType,AcctName=@AcctName,BankCode=@BankCode,BankName=@BankName,OldRelatedAcctId=@OldRelatedAcctId, Reserve=@Reserve,LastOption='update_1303' where CustAcctId=@CustAcctId";
obj = MySqlHelper.ExecuteNonQuery(strConnection, sql, param);
int.TryParse(obj.ToString(), out retValue);
}
}
return(retValue);
}
public void Process(string funcCode, NotifyResult notifyResult)
{
//通讯信息
var recvResult = notifyResult.DataResult;
switch (funcCode)
{
case "1301":
{
//接收业务数据
Req_1301 req_1301 = notifyResult.ReqData as Req_1301;
//处理业务
//MemberInfoDataAccess.AddOrUpdateMemberInfo(req_1301);
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1301";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "1315": //出入金账户维护【1315】
{
Req_1315 req_1315 = notifyResult.ReqData as Req_1315;
//处理业务
//记录签约后返回来的子账户和出入金账号 后续用到
//MemberInfoDataAccess.AddOrUpdateMemberInfo(req_1315);
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1315";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "1303": //会员签解约维护【1303】
{
//接收业务数据
Req_1303 req_1303 = notifyResult.ReqData as Req_1303;
//处理业务
//MemberInfoDataAccess.AddOrUpdateMemberInfo(req_1303);
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1303";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "1310": //入金（银行发起）【1310】
{
Req_1310 req_1310 = notifyResult.ReqData as Req_1310;
//处理业务
//....
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1310";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "1312": //出金（银行发起）【1312】
{
Req_1312 req_1312 = notifyResult.ReqData as Req_1312;
//处理业务
//....
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1312";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "1019": //查交易网端会员管理账户余额
{
Req_1019 req_1019 = notifyResult.ReqData as Req_1019;
//处理业务
//....
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1019";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "1326": //银行复核通知
{
Req_1326 req_1326 = notifyResult.ReqData as Req_1326;
//处理业务
//....
//构造返回结果
string serialNumber = AssistantHelper.GetOrderId(6, "yyyyMMddHHmmss", "");
notifyResult.RspData.ThirdLogNo = serialNumber;
notifyResult.RspData.Reserve = "1326";
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "FILE04": //ERP文件上传、下载结果通知
{
Req_FILE04 req_FILE04 = notifyResult.ReqData as Req_FILE04;
//处理业务 跨行快付的业务
//....
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
case "F002": //银行通知 明细报表生成通知接口
{
Req_F002 req_F002 = notifyResult.ReqData as Req_F002;
//记录日志
notifyResult.RspStatus.Code = "000000";
notifyResult.RspStatus.Msg = "交易成功";
}
break;
default:
break;
}
}
