public static void SelectBoCaiShop(string Periods, out List <BoCaiShopDB> dList)
{
dList = null;
try
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("SELECT rid, ID, BuyNum, WuPinID from t_bocai_shop where Periods={0}", Periods);
MySQLDataReader reader = conn.ExecuteReader(sql, new MySQLParameter[0]);
dList = new List <BoCaiShopDB>();
while (reader.Read())
{
BoCaiShopDB temp = new BoCaiShopDB();
temp.RoleID = Convert.ToInt32(reader["rid"].ToString());
temp.ID = Convert.ToInt32(reader["ID"].ToString());
temp.BuyNum = Convert.ToInt32(reader["BuyNum"].ToString());
temp.WuPinID = reader["WuPinID"].ToString();
temp.Periods = Convert.ToInt32(Periods);
dList.Add(temp);
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, string.Format("[ljl]{0}", ex.ToString()), null, true);
}
}
public static bool ReplaceBuyBoCai(BuyBoCai2SDB data)
{
int ret = -1;
try
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("REPLACE INTO t_bocai_buy_history(rid, RoleName, ZoneID, UserID, ServerID, BuyNum, BuyValue, IsSend, IsWin, BocaiType, DataPeriods, UpdateTime)VALUES({0},'{1}',{2},'{3}',{4}, {5},'{6}', {7}, {8}, {9}, {10}, '{11}');", new object[]
{
data.m_RoleID,
data.m_RoleName,
data.ZoneID,
data.strUserID,
data.ServerId,
data.BuyNum,
data.strBuyValue,
data.IsSend,
data.IsWin,
data.BocaiType,
data.DataPeriods,
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
});
ret = conn.ExecuteNonQuery(sql, 0);
}
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, string.Format("[ljl]{0}", ex.ToString()), null, true);
}
return(ret > -1);
}
public static bool ReplaceBoCaiShop(BoCaiShopDB data)
{
int ret = -1;
try
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("REPLACE INTO t_bocai_shop(rid, ID, BuyNum, Periods, WuPinID) VALUES({0},{1},{2},'{3}','{4}');", new object[]
{
data.RoleID,
data.ID,
data.BuyNum,
TimeUtil.NowDataTimeString("yyMMdd"),
data.WuPinID
});
ret = conn.ExecuteNonQuery(sql, 0);
}
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, string.Format("[ljl]{0}", ex.ToString()), null, true);
}
return(ret > -1);
}
private void ProcessArmorLevelStarUpCmd(GameServerClient client, int nID, byte[] cmdParams, int count)
{
int ret = 0;
RoleDataCmdT <RoleArmorData> data = DataHelper.BytesToObject <RoleDataCmdT <RoleArmorData> >(cmdParams, 0, count);
if (data != null && data.RoleID > 0)
{
DBManager dbMgr = DBManager.getInstance();
DBRoleInfo dbRoleInfo = dbMgr.GetDBRoleInfo(ref data.RoleID);
if (null != dbRoleInfo)
{
if (dbRoleInfo.ArmorData.Armor != data.Value.Armor || dbRoleInfo.ArmorData.Exp != data.Value.Exp)
{
dbRoleInfo.ArmorData.Armor = data.Value.Armor;
dbRoleInfo.ArmorData.Exp = data.Value.Exp;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("update t_roles set armor={1},armorexp={2} where rid={0}", data.RoleID, data.Value.Armor, data.Value.Exp);
ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]);
}
}
}
}
client.sendCmd(nID, string.Format("{0}", ret));
}
public static bool ReplaceOpenLottery(OpenLottery data)
{
int ret = -1;
try
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("REPLACE INTO t_bocai_open_lottery(DataPeriods, AllBalance, SurplusBalance, XiaoHaoDaiBi, BocaiType, strWinNum, WinInfo, IsAward) VALUES({0},{1},{2},{3},{4},'{5}','{6}', {7});", new object[]
{
data.DataPeriods,
data.AllBalance,
data.SurplusBalance,
data.XiaoHaoDaiBi,
data.BocaiType,
data.strWinNum,
data.WinInfo,
data.IsAward
});
ret = conn.ExecuteNonQuery(sql, 0);
}
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, string.Format("[ljl]{0}", ex.ToString()), null, true);
}
return(ret > -1);
}
public static bool Update(GoldAuctionDBItem Item)
{
int ret = -1;
try
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("UPDATE t_gold_auction SET BuyerData='{0}', AuctionTime='{1}', AuctionType='{2}', UpDBWay='{3}', UpdateTime='{4}' WHERE AuctionSource='{5}' AND ProductionTime='{6}'", new object[]
{
Item.BuyerData.getAttackerValue(),
Item.AuctionTime,
Item.AuctionType,
((DBAuctionUpEnum)Item.UpDBWay).ToString(),
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
Item.AuctionSource,
Item.ProductionTime
});
ret = conn.ExecuteNonQuery(cmdText, 0);
LjlLog.WriteLogFormat(LogTypes.Info, new string[]
{
"金团拍卖行更新",
(ret > -1).ToString(),
" ",
cmdText
});
}
}
catch (Exception ex)
{
LjlLog.WriteLog(LogTypes.Exception, ex.ToString(), "");
}
return(ret > -1);
}
private RoleCustomData QueryRoleCustomData(int roleId)
{
RoleCustomData roleCustomData = null;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
try
{
string cmdText = string.Format("select `occu_data`,`roledata4selector` from t_roledata where rid={0}", roleId);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
if (reader.Read())
{
byte[] bytes0 = reader[0] as byte[];
byte[] bytes = reader[1] as byte[];
roleCustomData = new RoleCustomData();
roleCustomData.roleId = roleId;
if (null != bytes0)
{
roleCustomData.customDataList = DataHelper.BytesToObject <List <RoleCustomDataItem> >(bytes0, 0, bytes0.Length);
}
if (null != bytes)
{
roleCustomData.roleData4Selector = DataHelper.BytesToObject <RoleData4Selector>(bytes, 0, bytes.Length);
}
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
}
return(roleCustomData);
}
public bool UpdateAccountActiveInfo(DBManager dbMgr, string strAccountID)
{
bool ret = false;
string today = DateTime.Now.ToString("yyyy-MM-dd");
AccountActiveData dataActive = this.GetAccountActiveInfo(dbMgr, strAccountID);
if (null == dataActive)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("INSERT INTO t_user_active_info(Account, createTime, seriesLoginCount, lastSeriesLoginTime) VALUES('{0}', '{1}', {2}, '{3}')", new object[]
{
strAccountID,
today,
1,
today
});
ret = conn.ExecuteNonQueryBool(cmdText, 0);
}
}
else
{
DateTime datePreDay = DateTime.Now.AddDays(-1.0);
DateTime dateLastLogin = DateTime.Parse(dataActive.strLastSeriesLoginTime + " 00:00:00");
if (datePreDay.DayOfYear == dateLastLogin.DayOfYear)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("UPDATE t_user_active_info SET seriesLoginCount={0}, lastSeriesLoginTime='{1}' WHERE Account='{2}'", dataActive.nSeriesLoginCount + 1, today, dataActive.strAccount);
ret = conn.ExecuteNonQueryBool(cmdText, 0);
}
}
}
return(ret);
}
public static void OnChangeName(int roleId, string oldName, string newName)
{
if (!string.IsNullOrEmpty(oldName) && !string.IsNullOrEmpty(newName))
{
lock (FuBenHistManager._Mutex)
{
if (FuBenHistManager._FuBenHistDict == null)
{
return;
}
foreach (KeyValuePair <int, FuBenHistData> kvp in FuBenHistManager._FuBenHistDict)
{
FuBenHistData data = kvp.Value;
if (data.RoleID == roleId)
{
data.RoleName = newName;
}
}
}
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("UPDATE t_fubenhist SET rname='{0}' WHERE rid={1}", newName, roleId);
conn.ExecuteNonQuery(sql, 0);
}
}
}
public void SetYaoSaiMissionData(GameServerClient client, int nID, byte[] cmdParams, int count)
{
try
{
Dictionary <int, List <YaoSaiMissionData> > missionDict = DataHelper.BytesToObject <Dictionary <int, List <YaoSaiMissionData> > >(cmdParams, 0, count);
foreach (KeyValuePair <int, List <YaoSaiMissionData> > item in missionDict)
{
foreach (YaoSaiMissionData mission in item.Value)
{
string cmdText = string.Format("insert into t_yaosaimission values ({0},{1},{2},{3},'{4}','{5}') on duplicate key update missionid={2},state={3},zhipaijingling='{4}',starttime='{5}';\r\n", new object[]
{
item.Key,
mission.SiteID,
mission.MissionID,
mission.State,
mission.ZhiPaiJingLing,
mission.StartTime
});
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", cmdText), EventLevels.Important);
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
conn.ExecuteNonQuery(cmdText, 0);
}
}
}
client.sendCmd <int>(nID, 0);
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Error, string.Format("YaoSaiMission :: 更新角色任务信息错误 cmd={0}, ex={1}", nID, ex.Message), null, true);
}
}
public static string TalentInfoModify(DBManager dbMgr, int roleID, int totalCount, long exp, long expAdd, int isUp, int zoneID)
{
int result = 1;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("REPLACE INTO t_talent(roleID, tatalCount, exp, zoneID) VALUES({0}, {1}, {2}, {3})", new object[]
{
roleID,
totalCount,
exp,
zoneID
});
int count = conn.ExecuteNonQuery(cmdText, 0);
if (count > 0)
{
result = 0;
TalentManager.TalentLogAdd(dbMgr, zoneID, roleID, 1, expAdd);
if (isUp > 0)
{
TalentManager.TalentLogAdd(dbMgr, zoneID, roleID, 2, 1L);
}
TalentManager.DbUpdateTalent(dbMgr, roleID, totalCount, exp);
}
}
return(result.ToString());
}
public static bool EquipFluorescentGem(DBManager dbMgr, FluorescentGemSaveDBData data)
{
bool result;
if (null == data)
{
result = false;
}
else
{
bool ret = false;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string equipTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string cmdText = string.Format("INSERT INTO t_fluorescent_gem_equip(roleid, goodsid, position, type, equiptime, bind) VALUES({0}, {1}, {2}, {3}, '{4}', {5})", new object[]
{
data._RoleID,
data._GoodsID,
data._Position,
data._GemType,
equipTime,
data._Bind
});
ret = conn.ExecuteNonQueryBool(cmdText, 0);
}
result = ret;
}
return(result);
}
private void OlympicsGuess(GameServerClient client, int nID, byte[] cmdParams, int count)
{
string[] fields = null;
int length = 2;
if (!CheckHelper.CheckTCPCmdFields(nID, cmdParams, count, out fields, length))
{
client.sendCmd <bool>(nID, false);
}
else
{
int roleID = int.Parse(fields[0]);
int dayID = int.Parse(fields[1]);
OlympicsGuessDataDB data = new OlympicsGuessDataDB();
data.RoleID = roleID;
data.DayID = dayID;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT a1,a2,a3,award1,award2,award3 FROM t_olympics_guess WHERE roleID='{0}' and dayID='{1}' ", roleID, dayID);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
data.A1 = int.Parse(reader["a1"].ToString());
data.A2 = int.Parse(reader["a2"].ToString());
data.A3 = int.Parse(reader["a3"].ToString());
data.Award1 = int.Parse(reader["award1"].ToString());
data.Award2 = int.Parse(reader["award2"].ToString());
data.Award3 = int.Parse(reader["award3"].ToString());
}
}
client.sendCmd <OlympicsGuessDataDB>(nID, data);
}
}
public List <ReturnData> ReturnList()
{
List <ReturnData> list = new List <ReturnData>();
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT id,activityID,activityDay,pzoneID,proleID,czoneID,croleID,vip,`level`,logTime,checkState,logState FROM t_user_return order by logTime", new object[0]);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
list.Add(new ReturnData
{
DBID = Convert.ToInt32(reader["id"].ToString()),
ActivityID = Convert.ToInt32(reader["activityID"].ToString()),
ActivityDay = reader["activityDay"].ToString(),
PZoneID = Convert.ToInt32(reader["pzoneID"].ToString()),
PRoleID = Convert.ToInt32(reader["proleID"].ToString()),
CZoneID = Convert.ToInt32(reader["czoneID"].ToString()),
CRoleID = Convert.ToInt32(reader["croleID"].ToString()),
Vip = Convert.ToInt32(reader["vip"].ToString()),
Level = Convert.ToInt32(reader["level"].ToString()),
LogTime = Convert.ToDateTime(reader["logTime"].ToString()),
StateCheck = Convert.ToInt32(reader["checkState"].ToString()),
StateLog = Convert.ToInt32(reader["logState"].ToString())
});
}
}
return(list);
}
private void CheckRoleZuoQiData(GameServerClient client, int nID, byte[] cmdParams, int count)
{
try
{
string cmdData = new UTF8Encoding().GetString(cmdParams, 0, count);
int roleID = Convert.ToInt32(cmdData);
DBRoleInfo dbRoleInfo = DBManager.getInstance().FindDBRoleInfo(ref roleID);
if (null == dbRoleInfo)
{
LogManager.WriteLog(LogTypes.Error, string.Format("发起请求的角色不存在，CMD={0}, RoleID={1}", (TCPGameServerCmds)nID, roleID), null, true);
client.sendCmd(30767, "0");
}
else
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("update t_zuoqi set isnew=0 where rid={0}", roleID);
conn.ExecuteNonQuery(cmdText, 0);
}
foreach (MountData item in dbRoleInfo.MountList)
{
item.IsNew = false;
}
client.sendCmd <int>(nID, 1);
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.Message);
client.sendCmd <int>(nID, -8);
}
}
public int insertWanMoTaData(DBManager dbMgr, WanMotaInfo data)
{
int ret = -1;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
try
{
string cmdText = string.Format("INSERT INTO t_wanmota (roleID, roleName, flushTime, passLayerCount, sweepLayer, sweepReward, sweepBeginTime) VALUES({0}, '{1}', {2}, {3}, {4}, '{5}', {6})", new object[]
{
data.nRoleID,
data.strRoleName,
data.lFlushTime,
data.nPassLayerCount,
data.nSweepLayer,
data.strSweepReward,
data.lSweepBeginTime
});
ret = conn.ExecuteNonQuery(cmdText, 0);
if (ret < 0)
{
return(ret);
}
ret = conn.GetSingleInt("SELECT LAST_INSERT_ID() AS LastID", 0, new MySQLParameter[0]);
}
catch (MySQLException)
{
ret = -2;
}
}
return(ret);
}
private List <AllyLogData> GetAllyLogData(int unionID)
{
List <AllyLogData> result;
lock (this._lock)
{
List <AllyLogData> list = new List <AllyLogData>();
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT unionID,unionZoneID,unionName,logTime,logState FROM t_ally_log WHERE myUnionID={0} ORDER BY logTime DESC LIMIT 20", unionID);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
list.Add(new AllyLogData
{
MyUnionID = unionID,
UnionID = int.Parse(reader["unionID"].ToString()),
UnionZoneID = int.Parse(reader["unionZoneID"].ToString()),
UnionName = reader["unionName"].ToString(),
LogTime = DateTime.Parse(reader["logTime"].ToString()),
LogState = int.Parse(reader["logState"].ToString())
});
}
}
result = list;
}
return(result);
}
private void RecvZhanMengHongBao(GameServerClient client, int nID, byte[] cmdParams, int count)
{
int ret = 0;
try
{
HongBaoRecvData args = DataHelper.BytesToObject <HongBaoRecvData>(cmdParams, 0, count);
if (args != null)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("replace into `t_hongbao_recv` (`hongbaoid`, `rid`, `bhid`, `zuanshi`, `recvtime`, `rname`) values('{0}','{1}','{2}','{3}','{4}','{5}');", new object[]
{
args.HongBaoID,
args.RoleId,
args.BhId,
args.ZuanShi,
args.RecvTime,
args.RoleName
});
ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]);
}
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
client.sendCmd <int>(nID, ret);
}
private void OlympicsGuessList(GameServerClient client, int nID, byte[] cmdParams, int count)
{
int roleID = DataHelper.BytesToObject <int>(cmdParams, 0, count);
List <OlympicsGuessDataDB> list = new List <OlympicsGuessDataDB>();
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT roleID,dayID,a1,a2,a3,award1,award2,award3 FROM t_olympics_guess WHERE roleID={0} ORDER BY dayID ", roleID);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
list.Add(new OlympicsGuessDataDB
{
RoleID = int.Parse(reader["roleID"].ToString()),
DayID = int.Parse(reader["dayID"].ToString()),
A1 = int.Parse(reader["a1"].ToString()),
A2 = int.Parse(reader["a2"].ToString()),
A3 = int.Parse(reader["a3"].ToString()),
Award1 = int.Parse(reader["award1"].ToString()),
Award2 = int.Parse(reader["award2"].ToString()),
Award3 = int.Parse(reader["award3"].ToString())
});
}
}
client.sendCmd <List <OlympicsGuessDataDB> >(nID, list);
}
private void GetJieRiHongBaoRankList(GameServerClient client, int nID, byte[] cmdParams, int count)
{
List <JieriHongBaoKingItemData> list = new List <JieriHongBaoKingItemData>();
try
{
List <string> args = DataHelper.BytesToObject <List <string> >(cmdParams, 0, count);
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT `rid`,`count`,`getawardtimes`,`lasttime`,`rname` FROM `t_hongbao_jieri_recv` WHERE `keystr`='{0}' ORDER BY `count` DESC,`lasttime` ASC,rid ASC limit {1};", args[0], args[1]);
using (MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]))
{
int ranking = 1;
while (reader.Read())
{
list.Add(new JieriHongBaoKingItemData
{
RoleID = Global.SafeConvertToInt32(reader[0].ToString(), 10),
TotalRecv = Global.SafeConvertToInt32(reader[1].ToString(), 10),
GetAwardTimes = Global.SafeConvertToInt32(reader[2].ToString(), 10),
Rolename = reader[4].ToString(),
Rank = ranking++
});
}
}
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
client.sendCmd <List <JieriHongBaoKingItemData> >(nID, list);
}
public ReturnData GetUserReturnData(string userID, int zoneID)
{
ReturnData result = null;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("select vip,level,checkState,logTime from t_user_return where userid='{0}' and zoneID='{1}' and activityDay='{2}' and activityID='{3}'", new object[]
{
userID,
zoneID,
UserReturnManager._activityInfo.ActivityDay,
UserReturnManager._activityInfo.ActivityID
});
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
if (reader.Read())
{
int inputMoneyInPeriod = DBQuery.GetUserInputMoney(TCPManager.getInstance().DBMgr, userID, 0, UserReturnManager._activityInfo.ActivityDay, "2050-01-01 00:00:00");
if (inputMoneyInPeriod < 0)
{
inputMoneyInPeriod = 0;
}
int roleYuanBaoInPeriod = Global.TransMoneyToYuanBao(inputMoneyInPeriod);
result = new ReturnData
{
Vip = Convert.ToInt32(reader["vip"].ToString()),
Level = Convert.ToInt32(reader["level"].ToString()),
StateCheck = Convert.ToInt32(reader["checkState"].ToString()),
LogTime = DateTime.Parse(reader["logTime"].ToString()),
LeiJiChongZhi = roleYuanBaoInPeriod
};
}
}
return(result);
}
internal void OnChangeName(int roleId, string oldName, string newName)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("UPDATE t_jingjichang SET roleName='{0}',name='{1}' WHERE roleId={2}", newName, newName, roleId);
conn.ExecuteNonQuery(sql, 0);
}
}
public static void ForceUnEquipFluorescentGem(DBManager dbMgr, ulong id)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("DELETE FROM t_fluorescent_gem_equip WHERE id={0}", id);
conn.ExecuteNonQuery(cmdText, 0);
}
}
private void UpdateZhanMengHongBao(GameServerClient client, int nID, byte[] cmdParams, int count)
{
int ret = 0;
HongBaoSendData data = DataHelper.BytesToObject <HongBaoSendData>(cmdParams, 0, count);
if (data != null)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText;
if (data.hongBaoID == 0)
{
cmdText = string.Format("insert into `t_hongbao_send` (`bhid`, `senderid`, `sendername`, `sendtime`, `endtime`, `msg`, `zuanshi`, `count`, `type`, `leftzuanshi`, `leftcount`, `state`) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','0');", new object[]
{
data.bhid,
data.senderID,
data.sender,
data.sendTime.ToString("yyyy-MM-dd HH:mm:ss"),
data.endTime.ToString("yyyy-MM-dd HH:mm:ss"),
data.message,
data.sumDiamondNum,
data.sumCount,
data.type,
data.leftZuanShi,
data.leftCount
});
}
else
{
cmdText = string.Format("replace into `t_hongbao_send` (`bhid`, `senderid`, `sendername`, `sendtime`, `endtime`, `msg`, `zuanshi`, `count`, `type`, `leftzuanshi`, `leftcount`, `state`,`id`) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',{12});", new object[]
{
data.bhid,
data.senderID,
data.sender,
data.sendTime.ToString("yyyy-MM-dd HH:mm:ss"),
data.endTime.ToString("yyyy-MM-dd HH:mm:ss"),
data.message,
data.sumDiamondNum,
data.sumCount,
data.type,
data.leftZuanShi,
data.leftCount,
data.hongBaoStatus,
data.hongBaoID
});
}
ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]);
if (ret >= 0 && data.hongBaoID == 0)
{
cmdText = "SELECT LAST_INSERT_ID();";
ret = conn.GetSingleInt(cmdText, 0, new MySQLParameter[0]);
}
}
}
client.sendCmd <int>(nID, ret);
}
private bool ExecNonQuery(string sql)
{
bool bResult = false;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
bResult = conn.ExecuteNonQueryBool(sql, 0);
}
return(bResult);
}
public static bool UpdateFluorescentPoint(DBManager dbMgr, int nRoleID, int nPoint)
{
bool ret = false;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("UPDATE t_roles SET fluorescent_point={0} where rid={1};", nPoint, nRoleID);
ret = conn.ExecuteNonQueryBool(cmdText, 0);
}
return(ret);
}
public static int updateWanMoTaData(DBManager dbMgr, int nRoleID, string[] fields, int startIndex)
{
int ret = -1;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = DBWriter.FormatUpdateSQL(nRoleID, fields, startIndex, WanMoTaDBController._fieldNames, "t_wanmota", WanMoTaDBController._fieldTypes, "roleID");
ret = conn.ExecuteNonQuery(cmdText, 0);
}
return(ret);
}
public bool ReturnDel(int dbID)
{
bool result;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("DELETE FROM t_user_return WHERE id={0}", dbID);
result = conn.ExecuteNonQueryBool(cmdText, 0);
}
return(result);
}
internal void OnChangeName(int roleid, string oldName, string newName)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("UPDATE t_wings SET rname='{0}' WHERE rid={1}", newName, roleid);
if (conn.ExecuteNonQuery(cmdText, 0) < 0)
{
LogManager.WriteLog(LogTypes.Error, string.Format("角色改名，更新t_wings失败, roleId={0}, oldName={1}, newName={2}", roleid, oldName, newName), null, true);
}
}
}
public bool DelUserReturnData(int id)
{
bool result;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("DELETE FROM t_user_return_back WHERE id={0}", id);
result = conn.ExecuteNonQueryBool(cmdText, 0);
}
return(result);
}
