// 解封账号dst
private OpRes startAcc(DestGmUser dst, GMUser user, ParamStartStopGmAcc p)
{
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("state", GmState.STATE_NORMAL, FieldType.TypeNumber);
if (dst.m_accType == AccType.ACC_GENERAL_AGENCY ||
dst.m_accType == AccType.ACC_AGENCY ||
dst.m_accType == AccType.ACC_API)
{
string sql = gen.getResultSql(TableName.GM_ACCOUNT,
string.Format(" createCode like '{0}%' ", dst.m_createCode));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
// 解封账号之下的玩家
gen.reset();
gen.addField("enable", 1, FieldType.TypeNumber);
sql = gen.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA,
string.Format(" createCode like '{0}%' ", dst.m_createCode));
user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
else
{
string sql = gen.getResultSql(TableName.GM_ACCOUNT,
string.Format(" acc= '{0}' ", p.m_acc));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
}
public OpRes dispatch(ParamModifyGmRight p, GMUser user)
{
DestGmUser dst = new DestGmUser(p.m_acc, user);
if (!dst.m_isExists)
{
return(OpRes.op_res_no_right);
}
bool res = DyOpModifyGmRight.canDispatchRight(user, dst.m_accType,
() => { return(dst.m_owner == user.m_user); });
if (!res)
{
return(OpRes.op_res_no_right);
}
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("gmRight", p.m_right, FieldType.TypeString);
string sql = gen.getResultSql(TableName.GM_ACCOUNT,
string.Format("acc='{0}'", p.m_acc));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
private void TranslateCommandTree(DbCommandTree commandTree, DbCommand command)
{
SqlBaseGenerator sqlGenerator = null;
DbQueryCommandTree select;
DbInsertCommandTree insert;
DbUpdateCommandTree update;
DbDeleteCommandTree delete;
if ((select = commandTree as DbQueryCommandTree) != null)
{
sqlGenerator = new SqlSelectGenerator(select);
}
else if ((insert = commandTree as DbInsertCommandTree) != null)
{
sqlGenerator = new SqlInsertGenerator(insert);
}
else if ((update = commandTree as DbUpdateCommandTree) != null)
{
sqlGenerator = new SqlUpdateGenerator(update);
}
else if ((delete = commandTree as DbDeleteCommandTree) != null)
{
sqlGenerator = new SqlDeleteGenerator(delete);
}
else
{
// TODO: get a message (unsupported DbCommandTree type)
throw new ArgumentException();
}
sqlGenerator.BuildCommand(command);
}
private OpRes updateWashRatio(ParamModifyGmProperty p, DestGmUser dst, GMUser user)
{
if (dst.m_owner != user.m_user)
{
return(OpRes.op_res_no_right);
}
ParamCreateGmAccount param = new ParamCreateGmAccount();
param.m_washRatio = p.m_param;
double washRatio = 0;
if (!ItemHelp.isValidWashRatio(param, user, ref washRatio))
{
return(OpRes.op_res_param_not_valid);
}
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("washRatio", washRatio, FieldType.TypeNumber);
string sql = gen.getResultSql(TableName.GM_ACCOUNT, string.Format(" acc='{0}' ", p.m_acc));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
/// <summary>
///
/// </summary>
/// <param name="instance"></param>
/// <returns></returns>
public virtual bool Update(TEntity instance)
{
using (var connection = DbConnectionFactory.CreateConnection())
{
connection.Open();
var sql = SqlUpdateGenerator.GetUpdate();
return(connection.Execute(sql, instance) > 0);
}
}
// orderState OrderState类型
public static string genUpdateSql(string orderId, int orderState)
{
SqlUpdateGenerator up = new SqlUpdateGenerator();
up.addField("orderState", orderState, FieldType.TypeNumber);
string cmd = up.getResultSql(TableName.PLAYER_ORDER_WAIT, string.Format("orderId='{0}' ", orderId));
return(cmd);
}
/// <summary>
///
/// </summary>
/// <param name="instance"></param>
/// <returns></returns>
public virtual async Task <bool> UpdateAsync(TEntity instance)
{
using (var connection = DbConnectionFactory.CreateConnection())
{
connection.Open();
var sql = SqlUpdateGenerator.GetUpdate();
await connection.QueryAsync <int>(sql, instance);
return(true);
}
}
OpRes autoForwardOrder(ParamPlayerOrder p, GMUser user)
{
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("forwardOrder", p.m_isAutoForward, FieldType.TypeNumber);
string cond = string.Format(" acc = '{0}' ", user.m_user);
string sqlCmd = gen.getResultSql(TableName.GM_ACCOUNT, cond);
int count = user.sqlDb.executeOp(sqlCmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
// 解封玩家账号
int startPlayerAcc(ParamPlayerOp p)
{
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("enable", 1, FieldType.TypeNumber);
string sql = gen.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA,
string.Format(" acc='{0}' ", p.m_playerAcc));
int count = m_gmUser.sqlDb.executeOp(sql, MySqlDbName.DB_XIANXIA);
return(count > 0 ? RetCode.RET_SUCCESS : RetCode.RET_DB_ERROR);
}
public override OpRes doDyop(object param, GMUser user)
{
ParamModifyGmProperty p = (ParamModifyGmProperty)param;
DestGmUser dst = new DestGmUser(p.m_acc, user);
if (!dst.m_isExists)
{
return(OpRes.op_res_no_right);
}
OpRes res = OpRes.op_res_failed;
int count = 0;
switch (p.m_whichProperty)
{
case ParamModifyGmProperty.MODIFY_ALIASNAME:
{
if (!dst.isDerivedFrom(user))
{
return(OpRes.op_res_no_right);
}
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("aliasName", p.m_param, FieldType.TypeString);
string sql = gen.getResultSql(TableName.GM_ACCOUNT, string.Format(" acc='{0}' ", p.m_acc));
count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
res = count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed;
}
break;
case ParamModifyGmProperty.MODIFY_AGENT_RATION:
{
res = updateAgentRatio(p, dst, user);
}
break;
case ParamModifyGmProperty.MODIFY_WASH_RATION:
{
res = updateWashRatio(p, dst, user);
}
break;
case ParamModifyGmProperty.MODIFY_ACC_STATE:
{
res = modifyAccState(p, user);
}
break;
}
return(res);
}
private void save(string key)
{
long cur = m_count[key];
m_count[key] = cur + 1;
MySqlDb sql = new MySqlDb();
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("curValue", cur + 1, FieldType.TypeNumber);
string cmd = gen.getResultSql(TableName.CREATE_CONFIG, string.Format("appType='{0}' ", key));
sql.executeOp(cmd, 0, MySqlDbName.DB_XIANXIA);
}
// 修改玩家别名
public OpRes modifyPlayerAliasName(string acc, string newName, GMUser user)
{
if (!canOpPlayer(acc, user))
{
return(OpRes.op_res_no_right);
}
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("aliasName", newName, FieldType.TypeString);
string cmd = gen.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA,
string.Format("acc='{0}'", acc));
int count = user.sqlDb.executeOp(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
private void ButtonGenerateUpdate_Click(object sender, RoutedEventArgs e)
{
if (lstSelectedTables.SelectedItems.Count > 0)
{
string output = string.Empty;
foreach (var item in lstSelectedTables.SelectedItems)
{
if (item is TSqlObject table)
{
var gen = new SqlUpdateGenerator(GeneratorSettings, table, true);
output += gen.Generate();
}
}
txtOutput.Text = output;
}
}
bool updateChildNodeNumber(GMUser user, CreateInfo info)
{
GMUser dstUser = AccountSys.getInstance().getUser(info.m_acc);
if (dstUser != null)
{
dstUser.m_childCount++;
}
info.m_childCount++;
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("childNodeNumber", info.m_childCount, FieldType.TypeNumber);
string sqlCmd = gen.getResultSql(TableName.GM_ACCOUNT, string.Format(" acc='{0}' ", info.m_acc));
int count = user.sqlDb.executeOp(sqlCmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0);
}
private OpRes delGmAcc(ParamDelAcc p, GMUser user)
{
DestGmUser dst = new DestGmUser(p.m_acc, user);
if (dst.m_isSelf)
{
return(OpRes.op_res_no_right);
}
if (!dst.m_isExists)
{
return(OpRes.op_res_no_right);
}
if (!dst.isDerivedFrom(user))
{
return(OpRes.op_res_no_right);
}
int childCount = (int)user.sqlDb.getRecordCount(TableName.GM_ACCOUNT,
string.Format("owner='{0}' ", dst.m_owner), 0, MySqlDbName.DB_XIANXIA);
SqlUpdateGenerator up = new SqlUpdateGenerator();
up.addField("childNodeNumber", childCount, FieldType.TypeNumber);
string sql = up.getResultSql(TableName.GM_ACCOUNT, string.Format("acc='{0}' and childNodeNumber=0 ", dst.m_owner));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
if (count >= 0)
{
SqlDeleteGenerator gen = new SqlDeleteGenerator();
string cmd1 = gen.getResultSql(TableName.GM_ACCOUNT,
string.Format(" createCode like '{0}%' ", dst.m_createCode));
user.sqlDb.executeOp(cmd1, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
string cmd2 = gen.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA,
string.Format(" createCode like '{0}%' ", dst.m_createCode));
count = user.sqlDb.executeOp(cmd2, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count >= 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
return(OpRes.op_res_db_failed);
}
public override OpRes doDyop(object param, GMUser user)
{
if (!user.isAPIAcc())
{
return(OpRes.op_res_no_right);
}
string gameCloseList = (string)param;
string gameList = ItemHelp.getReverseGameList(gameCloseList);
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("gameClose", gameList, FieldType.TypeString);
string sql = gen.getResultSql(TableName.GM_ACCOUNT,
string.Format("acc='{0}'", user.m_user));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
protected void onModifyHome(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("home", m_home.Text, FieldType.TypeString);
string sql = gen.getResultSql(TableName.GM_ACCOUNT, string.Format(" acc='{0}' ", m_acc.Text));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
if (count > 0)
{
m_res.InnerText = OpResMgr.getInstance().getResultString(OpRes.opres_success);
}
else
{
m_res.InnerText = OpResMgr.getInstance().getResultString(OpRes.op_res_db_failed);
}
}
/*
* gm给玩家上分，先扣gm的钱，若订单处理失败，需要把钱返还gm
* gm给玩家下分，先处理订单，若订单处理成功，则需要给gm钱
*/
private void returnMoneyToGM(OrderInfo info)
{
if (info.m_gmAcc == "admin") // 操作者是管理员，不用返还
{
return;
}
long retMoney = 0;
switch (info.m_orderState)
{
case PlayerReqOrderState.STATE_FINISH: // 处理成功了，若是下分，需要返还
{
if (!ScropOpType.isAddScore(info.m_orderType))
{
retMoney = info.m_money;
}
}
break;
case PlayerReqOrderState.STATE_FAILED: // 处理失败了，若是上分，需要返还
{
if (ScropOpType.isAddScore(info.m_orderType))
{
retMoney = info.m_money;
}
}
break;
}
if (retMoney > 0)
{
SqlUpdateGenerator up = new SqlUpdateGenerator();
up.addField("money",
string.Format("money+{0}", retMoney),
FieldType.TypeNumber);
// 可以通知到web后台
string cmd = up.getResultSql(TableName.GM_ACCOUNT, string.Format("acc='{0}'", info.m_gmAcc));
m_sqlDb.executeOp(cmd, CMySqlDbName.DB_XIANXIA);
}
}
internal void TranslateCommandTree(Version serverVersion, DbCommandTree commandTree, DbCommand command, bool createParametersForNonSelect = true)
{
SqlBaseGenerator sqlGenerator;
DbQueryCommandTree select;
DbInsertCommandTree insert;
DbUpdateCommandTree update;
DbDeleteCommandTree delete;
DbFunctionCommandTree function;
if ((select = commandTree as DbQueryCommandTree) != null)
{
sqlGenerator = new SqlSelectGenerator(select);
}
else if ((insert = commandTree as DbInsertCommandTree) != null)
{
sqlGenerator = new SqlInsertGenerator(insert);
}
else if ((update = commandTree as DbUpdateCommandTree) != null)
{
sqlGenerator = new SqlUpdateGenerator(update);
}
else if ((delete = commandTree as DbDeleteCommandTree) != null)
{
sqlGenerator = new SqlDeleteGenerator(delete);
}
else if ((function = commandTree as DbFunctionCommandTree) != null)
{
sqlGenerator = new SqlFunctionGenerator(function);
}
else
{
// TODO: get a message (unsupported DbCommandTree type)
throw new ArgumentException();
}
sqlGenerator.CreateParametersForConstants = select == null && createParametersForNonSelect;
sqlGenerator.Command = (NpgsqlCommand)command;
sqlGenerator.Version = serverVersion;
sqlGenerator.BuildCommand(command);
}
public override OpRes doDyop(object param, GMUser user)
{
ParamModifyGmRight p = (ParamModifyGmRight)param;
if (p.m_op == 1)
{
return(dispatch(p, user));
}
DestGmUser dst = new DestGmUser(p.m_acc, user);
if (!dst.m_isExists)
{
return(OpRes.op_res_no_right);
}
if (!dst.isDerivedFrom(user))
{
return(OpRes.op_res_no_right);
}
if (!dst.isAccType(AccType.ACC_AGENCY) &&
!dst.isAccType(AccType.ACC_GENERAL_AGENCY) &&
!dst.isAccType(AccType.ACC_SUPER_ADMIN_SUB))
{
return(OpRes.op_res_no_right);
}
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("gmRight", p.m_right, FieldType.TypeString);
string sql = gen.getResultSql(TableName.GM_ACCOUNT,
string.Format("acc='{0}'", p.m_acc));
int count = user.sqlDb.executeOp(sql, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
return(count > 0 ? OpRes.opres_success : OpRes.op_res_db_failed);
}
public bool insertData(string playerAcc, DateTime now)
{
ResultStatWinLose result = (ResultStatWinLose)m_stat.getStatResult();
if (result.empty())
{
//LogMgr.log.InfoFormat("{0}, {1}, 数据空", now, playerAcc);
return(true);
}
int count = 0;
// string playerAcc = Convert.ToString(exitGamePlayer["playerAcc"]);
//DateTime now = DateTime.Now.Date;
string cond = string.Format(" date='{0}' and playerAcc='{1}' ", now.Date.ToString(ConstDef.DATE_TIME24),
playerAcc);
// 判定当天的记录是否存在
bool exists = m_sqlDb.keyExists(TableName.PLAYER_WIN_LOSE, cond, MySqlDbName.DB_XIANXIA);
if (exists) // 该玩家当天记录存在，更新
{
SqlUpdateGenerator gen = new SqlUpdateGenerator();
gen.addField("playerOutlay", string.Format("playerOutlay+{0}", result.m_playerOutlay), FieldType.TypeNumber);
gen.addField("playerIncome", string.Format("playerIncome+{0}", result.m_playerIncome), FieldType.TypeNumber);
gen.addField("washCount", string.Format("washCount+{0}", result.m_washCount), FieldType.TypeNumber);
string sql = gen.getResultSql(TableName.PLAYER_WIN_LOSE, cond);
count = m_sqlDb.executeOp(sql, MySqlDbName.DB_XIANXIA);
}
else // 插入一条新的记录
{
string createCode = null;
string creator = null;
string sql = string.Format("select createCode, creator from {0} where acc='{1}' ",
TableName.PLAYER_ACCOUNT_XIANXIA, playerAcc);
Dictionary <string, object> data = m_sqlDb.queryOne(sql, MySqlDbName.DB_XIANXIA);
if (data != null)
{
creator = Convert.ToString(data["creator"]);
createCode = Convert.ToString(data["createCode"]);
}
else
{
createCode = "noPlayer";
creator = "noPlayer";
}
SqlInsertGenerator gen = new SqlInsertGenerator();
gen.addField("date", now.Date.ToString(ConstDef.DATE_TIME24), FieldType.TypeString);
gen.addField("playerAcc", playerAcc, FieldType.TypeString);
gen.addField("playerCreator", creator, FieldType.TypeString);
gen.addField("playerCreateCode", createCode, FieldType.TypeString);
gen.addField("playerOutlay", result.m_playerOutlay, FieldType.TypeNumber);
gen.addField("playerIncome", result.m_playerIncome, FieldType.TypeNumber);
gen.addField("washCount", result.m_washCount, FieldType.TypeNumber);
sql = gen.getResultSql(TableName.PLAYER_WIN_LOSE);
count = m_sqlDb.executeOp(sql, MySqlDbName.DB_XIANXIA);
}
return(count > 0);
}
public JarvisClient(string SqliteDatabaseFile)
{
this.SqliteDatabaseFile = SqliteDatabaseFile;
this.SqlUpdateGenerator = new SqlUpdateGenerator();
}
public static async Task WriteSqlScriptsFileAsync(TSqlModel model, GeneratorSettings generatorSettings, Action <double> progressHandler = null)
{
var fileName = generatorSettings.OutputPath_SqlScripts;
var tables = model.GetAllTables().ToDictionary(currTable => currTable.Name.Parts[1].ToLower());
double progress = 0.0;
var fileStream = File.Open(fileName, FileMode.Create, FileAccess.Write);
var bufferSize = 5 * 1024 * 1024; // 5 MB
using (StreamWriter writer = new StreamWriter(fileStream, Encoding.UTF8, bufferSize))
{
// Flush stream after every table loop, manually
writer.AutoFlush = false;
// Loop only on selected tables, or on every table in model if GenerateForAllTables == true
IEnumerable <string> tableNames;
if (generatorSettings.RunGeneratorForAllTables)
{
tableNames = tables.Keys;
}
else
{
tableNames = (IEnumerable <string>)generatorSettings.RunGeneratorForSelectedTables ?? new string[0];
}
var tablesCount = tableNames.Count();
foreach (var currTableName in tableNames)
{
string sql = "";
var currTable = tables.ContainsKey(currTableName.ToLower()) ? tables[currTableName.ToLower()] : null;
if (currTable != null)
{
sql = new SqlInsertGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlTableTypeGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlBulkInsertGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlUpdateGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlDeleteGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlSelectAllGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlSelectByPKGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlSelectByPKListGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
sql = new SqlSelectByUKGenerator(generatorSettings, currTable).Generate();
if (sql != string.Empty)
{
writer.WriteLine(sql);
}
await writer.FlushAsync();
progress += 100.0 / tablesCount;
progressHandler?.Invoke((int)progress);
}
}
}
return;
}
// 返回处理后订单的新状态
public int process(OrderInfo info)
{
if (info.m_money <= 0)
{
info.m_failReason = RetCode.RET_MONEY_NOT_VALID;
return(PlayerReqOrderState.STATE_FAILED);
}
bool exist = query(info.m_playerAcc);
if (!exist)
{
info.m_failReason = RetCode.RET_NO_PLAYER;
return(PlayerReqOrderState.STATE_FAILED);
}
Dictionary <string, object> data =
MongodbPlayer.Instance.ExecuteGetBykey(TableName.PLAYER_INFO, "account", info.m_playerAcc, new string[] { "SyncLock" });
if (data == null)
{
info.m_failReason = RetCode.RET_NO_PLAYER;
return(PlayerReqOrderState.STATE_FAILED);
}
if (data.ContainsKey("SyncLock"))
{
int LockS = Convert.ToInt32(data["SyncLock"]);
if (LockS == 2) // 玩家被锁了
{
info.m_failReason = RetCode.RET_PLYAER_LOCKED;
return(PlayerReqOrderState.STATE_FAILED);
}
}
if (m_state == PlayerState.STATE_GAME) // 订单返回到这里，发现玩家又上线了，订单重发。
{
info.m_failReason = RetCode.RET_PLYAER_LOCKED;
return(PlayerReqOrderState.STATE_WAIT);
}
SqlUpdateGenerator up = new SqlUpdateGenerator();
switch (info.m_orderType)
{
case ScropOpType.ADD_SCORE: // 上分订单
{
up.addField("money",
string.Format("money+{0}", info.m_money),
FieldType.TypeNumber);
}
break;
case ScropOpType.EXTRACT_SCORE: // 下分订单
{
if (m_money < info.m_money)
{
info.m_failReason = RetCode.RET_MONEY_NOT_ENOUGH;
return(PlayerReqOrderState.STATE_FAILED);
}
up.addField("money",
string.Format("money-{0}", info.m_money),
FieldType.TypeNumber);
}
break;
}
// 可以通知到web后台
string cmd = up.getResultSql(TableName.PLAYER_ACCOUNT_XIANXIA,
string.Format("acc='{0}' and state={1} ", info.m_playerAcc, PlayerState.STATE_IDLE));
int count = m_sqlDb.executeOp(cmd, CMySqlDbName.DB_XIANXIA);
if (count > 0)
{
info.m_playerRemainMoney = getRemainMoney(info.m_playerAcc);
return(PlayerReqOrderState.STATE_FINISH);
}
info.m_failReason = RetCode.RET_DB_ERROR;
return(PlayerReqOrderState.STATE_FAILED);
}
