/**
* 获取游戏接口参数
*
* @param id
* 游戏接口参数编号
* @return 游戏接口参数
*/
public wh.game.model.GameInterfaceParams get(int id) throws Exception{
wh.game.model.GameInterfaceParams model = null;
Map<String, Object> inParameters = new HashMap<String, Object>();
inParameters.put("GameInterfaceParamsId", id);
OutParameters outParameters = new OutParameters();
outParameters.putOutParmType("ErrNo", java.sql.Types.INTEGER);
outParameters.putOutParmType("ErrMsg", java.sql.Types.NVARCHAR);
ResultSet rs = null;
CallableStatement cstmt = null;
int errNo = 0;
String errMsg = "";
try {
rs = SQLHelper.runProcedure(Config.CONNECTION_STRING_ULD, "{call WH_Game_GameInterfaceParams_Get(?,?,?)}", inParameters, outParameters);
if (rs != null) {
rs.next();
model = getModel(rs);
cstmt = (CallableStatement)rs.getStatement();
errNo = cstmt.getInt("ErrNo");
errMsg = cstmt.getString("ErrMsg");
}
} catch (Exception e) {
throw new Exception(e.getMessage(), e);
} finally{
SQLHelper.closeAll(cstmt);
}
MyErr.checkErr(errNo, errMsg);
return model;
}
/**
* 创建更新激活码
*
* @param model
* 激活码
* @return 激活码编号
*/
public int createUpdate(wh.game.model.ActiveCode model) throws Exception{
Map<String, Object> inParameters = new HashMap<String, Object>();
inParameters.put("ActiveCodeId", model.getActiveCodeId());
inParameters.put("GameId", model.getGameId());
inParameters.put("ServerId", model.getServerId());
inParameters.put("Name", model.getName());
inParameters.put("Code", model.getCode());
inParameters.put("ActiveCodeType", model.getActiveCodeType());
inParameters.put("CreateDate", Utility.getSqlDate(model.getCreateDate()));
inParameters.put("ModifyDate", Utility.getSqlDate(model.getModifyDate()));
inParameters.put("Status", model.getStatus());
inParameters.put("UsedType", model.getUsedType());
OutParameters outParameters = new OutParameters();
outParameters.putOutParmType("ErrNo", java.sql.Types.INTEGER);
outParameters.putOutParmType("ErrMsg", java.sql.Types.NVARCHAR);
int parasCount = inParameters.size() + outParameters.getOutParmTypes().size();
StringBuilder sbBuilder = new StringBuilder();
for (int i = 0; i < parasCount; i++) {
if (0 == i) {
sbBuilder.append("?");
} else {
sbBuilder.append(",?");
}
}
int retValue = SQLHelper.runProcedureNonQuery(Config.CONNECTION_STRING_ULD,
"{? = call WH_Game_ActiveCode_CreateUpdate(" + sbBuilder.toString() + ")}", inParameters, outParameters);
int errNo = Integer.valueOf(outParameters.getOutParmValue("ErrNo").toString());
String errMsg = outParameters.getOutParmValue("ErrMsg").toString();
MyErr.checkErr(errNo, errMsg);
return retValue;
}
/**
* 删除游戏接口参数
*
* @param id 游戏接口参数编号
*/
public void remove(int id) throws Exception{
Map<String, Object> inParameters = new HashMap<String, Object>();
inParameters.put("GameInterfaceParamsId", id);
OutParameters outParameters = new OutParameters();
outParameters.putOutParmType("ErrNo", java.sql.Types.INTEGER);
outParameters.putOutParmType("ErrMsg", java.sql.Types.NVARCHAR);
try {
SQLHelper.runProcedureNonQuery(Config.CONNECTION_STRING_ULD, "{call WH_Game_GameInterfaceParams_Remove(?,?,?)}", inParameters, outParameters);
} catch (Exception e) {
throw new Exception(e.getMessage(), e);
}
int errNo = Integer.valueOf(outParameters.getOutParmValue("ErrNo").toString());
String errMsg = outParameters.getOutParmValue("ErrMsg").toString();
MyErr.checkErr(errNo, errMsg);
}
/**
* 创建更新游戏接口参数
*
* @param model
* 游戏接口参数
* @return 游戏接口参数编号
*/
public int createUpdate(wh.game.model.GameInterfaceParams model) throws Exception{
Map<String, Object> inParameters = new HashMap<String, Object>();
inParameters.put("GameInterfaceParamsId", model.getGameInterfaceParamsId());
inParameters.put("GameInterfaceId", model.getGameInterfaceId());
inParameters.put("GameId", model.getGameId());
inParameters.put("ParamName", model.getParamName());
inParameters.put("ParamValue", model.getParamValue());
inParameters.put("ParamExplain", model.getParamExplain());
inParameters.put("SignType", model.getSignType());
inParameters.put("SignIndex", model.getSignIndex());
inParameters.put("ParamType", model.getParamType());
inParameters.put("ParamInType", model.getParamInType());
inParameters.put("ParamOutType", model.getParamOutType());
inParameters.put("SignFormatValue", model.getSignFormatValue());
OutParameters outParameters = new OutParameters();
outParameters.putOutParmType("ErrNo", java.sql.Types.INTEGER);
outParameters.putOutParmType("ErrMsg", java.sql.Types.NVARCHAR);
int parasCount = inParameters.size() + outParameters.getOutParmTypes().size();
StringBuilder sbBuilder = new StringBuilder();
for (int i = 0; i < parasCount; i++) {
if (0 == i) {
sbBuilder.append("?");
} else {
sbBuilder.append(",?");
}
}
int retValue = SQLHelper.runProcedureNonQuery(Config.CONNECTION_STRING_ULD,
"{? = call WH_Game_GameInterfaceParams_CreateUpdate(" + sbBuilder.toString() + ")}", inParameters, outParameters);
int errNo = Integer.valueOf(outParameters.getOutParmValue("ErrNo").toString());
String errMsg = outParameters.getOutParmValue("ErrMsg").toString();
MyErr.checkErr(errNo, errMsg);
return retValue;
}