public bool CheckBuyStoneOrderExist(string userName, string orderNumber)
{
MySqlConnection myconn = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
MySqlCommand mycmd = myconn.CreateCommand();
string sqlTextA = "select count(id) from buystonesrecord where OrderNumber = @OrderNumber and BuyerUserName = @BuyerUserName ";
mycmd.Parameters.AddWithValue("@OrderNumber", orderNumber);
mycmd.Parameters.AddWithValue("@BuyerUserName", DESEncrypt.EncryptDES(userName));
mycmd.CommandText = sqlTextA;
object objValue = mycmd.ExecuteScalar();
mycmd.Dispose();
int value = Convert.ToInt32(objValue);
if (value == 1)
{
return(true);
}
return(false);
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public WaitToReferAwardRecord[] GetWaitToAwardExpRecord(string newRegisterUserName)
{
WaitToReferAwardRecord[] records = null;
MySqlConnection myconn = null;
try
{
DataTable dt = new DataTable();
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string cmdText = "select * from waittoawardexprecord where NewRegisterUserNme = @NewRegisterUserNme ";
MySqlCommand mycmd = new MySqlCommand(cmdText, myconn);
mycmd.Parameters.AddWithValue("@NewRegisterUserNme", DESEncrypt.EncryptDES(newRegisterUserName));
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(dt);
records = MetaDBAdapter <WaitToReferAwardRecord> .GetWaitToAwardExpRecordListFromDataTable(dt);
dt.Clear();
dt.Dispose();
adapter.Dispose();
mycmd.Dispose();
return(records);
}
catch (Exception exc)
{
throw exc;
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public bool AddAgentAwardRecord(AgentAwardRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "insert into agentawardrecord " +
" (`AgentID`, `AgentUserName`, `PlayerID`, `PlayerUserName`, `PlayerInchargeRMB`, `AgentAwardRMB`, `PlayerInchargeContent`, `Time`) " +
" values (@AgentID, @AgentUserName, @PlayerID, @PlayerUserName, @PlayerInchargeRMB, @AgentAwardRMB, @PlayerInchargeContent, @Time)";
mycmd = myTrans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@AgentID", record.AgentID);
mycmd.Parameters.AddWithValue("@AgentUserName", DESEncrypt.EncryptDES(record.AgentUserName));
mycmd.Parameters.AddWithValue("@PlayerID", record.PlayerID);
mycmd.Parameters.AddWithValue("@PlayerUserName", DESEncrypt.EncryptDES(record.PlayerUserName));
mycmd.Parameters.AddWithValue("@PlayerInchargeRMB", record.PlayerInchargeRMB);
mycmd.Parameters.AddWithValue("@AgentAwardRMB", record.AgentAwardRMB);
mycmd.Parameters.AddWithValue("@PlayerInchargeContent", record.PlayerInchargeContent);
mycmd.Parameters.AddWithValue("@Time", record.Time.ToDateTime());
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddPlayerBuyDiamondShoppingItemRecord(PlayerBuyDiamondShoppingItemRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into playerbuydiamondshoppingitemrecord " +
"(`OrderNumber`,`UserID`,`DiamondShoppingItemID`,`SendAddress`,`BuyTime`,`ShoppingState`) " +
" values (@OrderNumber,@UserID,@DiamondShoppingItemID,@SendAddress,@BuyTime,@ShoppingState )";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@DiamondShoppingItemID", record.DiamondShoppingItemID);
mycmd.Parameters.AddWithValue("@SendAddress", DESEncrypt.EncryptDES(record.SendAddress));
mycmd.Parameters.AddWithValue("@BuyTime", record.BuyTime.ToDateTime());
mycmd.Parameters.AddWithValue("@ShoppingState", (int)record.ShoppingState);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveWaitToAwardExpRecord(WaitToReferAwardRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into waittoawardexprecord " +
"(`ReferrerUserName`,`NewRegisterUserNme`,`AwardLevel`) " +
" values (@ReferrerUserName, @NewRegisterUserNme,@AwardLevel)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@ReferrerUserName", DESEncrypt.EncryptDES(record.ReferrerUserName));
mycmd.Parameters.AddWithValue("@NewRegisterUserNme", DESEncrypt.EncryptDES(record.NewRegisterUserName));
mycmd.Parameters.AddWithValue("@AwardLevel", record.AwardLevel);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool LockOrder(LockSellStonesOrder lockOrder, CustomerMySqlTransaction trans)
{
//1.修改订单状态；
//2.添加锁定信息记录。
MySqlCommand mycmd = null;
try
{
string textDel = "delete from locksellstonesorder where OrderNumber = @OrderNumber;";
string textA = "update sellstonesorder set OrderState = @OrderState where OrderNumber = @OrderNumber;";
string textB = "insert into locksellstonesorder " +
"(`OrderNumber`, `PayUrl`, `LockedByUserName`, `LockedTime` ) " +
" values " +
"(@OrderNumber, @PayUrl, @LockedByUserName, @LockedTime); ";
mycmd = trans.CreateCommand();
mycmd.CommandText = textDel + textA + textB;
mycmd.Parameters.AddWithValue("@OrderState", (int)SellOrderState.Lock);
mycmd.Parameters.AddWithValue("@OrderNumber", lockOrder.StonesOrder.OrderNumber);
mycmd.Parameters.AddWithValue("@PayUrl", lockOrder.PayUrl);
mycmd.Parameters.AddWithValue("@LockedByUserName", DESEncrypt.EncryptDES(lockOrder.LockedByUserName));
mycmd.Parameters.AddWithValue("@LockedTime", lockOrder.LockedTime);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool EditAdmin(string userName, string loginPassword, string actionPassword, AdminGroupType groupType, string mac)
{
var myconn = MyDBHelper.Instance.CreateConnection();
MySqlCommand mycmd = null;
try
{
myconn.Open();
mycmd = myconn.CreateCommand();
string cmdTextA = "update admininfo set `UserName` = @UserName, `LoginPassword` = @LoginPassword, `GroupType` = @GroupType, `Mac` = @Mac where `UserName` = @UserName ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
mycmd.Parameters.AddWithValue("@LoginPassword", DESEncrypt.EncryptDES(loginPassword));
mycmd.Parameters.AddWithValue("@ActionPassword", DESEncrypt.EncryptDES(actionPassword));
mycmd.Parameters.AddWithValue("@GroupType", (int)groupType);
mycmd.Parameters.AddWithValue("@Mac", mac);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool DeleteTestUserLogState(string userName)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
mycmd = myconn.CreateCommand();
string cmdTextA = "delete from testuserlogstate where UserName = @UserName; ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public bool ConfirmWithdrawRMB(WithdrawRMBRecord record, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "update withdrawrmbrecord set " +
"`RMBWithdrawState` = @RMBWithdrawState, `AdminUserName` = @AdminUserName, `AlipayOrderNumber` = @AlipayOrderNumber, `PayTime` = @PayTime, `Message` = @Message " +
" where id = @id ";
mycmd = trans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@RMBWithdrawState", (int)record.State);
mycmd.Parameters.AddWithValue("@AdminUserName", DESEncrypt.EncryptDES(record.AdminUserName));
mycmd.Parameters.AddWithValue("@AlipayOrderNumber", record.AlipayOrderNumber);
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime);
mycmd.Parameters.AddWithValue("@Message", record.Message);
mycmd.Parameters.AddWithValue("@id", record.id);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddUserRemoteHandleServiceRecord(UserRemoteHandleServiceRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into userremotehandleservicerecord " +
"(`UserID`, `ServiceTime`,`WorkerName`,`ServiceContent`,`AdminUserName`) " +
" values (@UserID, @ServiceTime, @WorkerName,@ServiceContent,@AdminUserName)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@ServiceTime", record.ServiceTime);
mycmd.Parameters.AddWithValue("@WorkerName", DESEncrypt.EncryptDES(record.WorkerName));
mycmd.Parameters.AddWithValue("@ServiceContent", DESEncrypt.EncryptDES(record.ServiceContent));
mycmd.Parameters.AddWithValue("@AdminUserName", DESEncrypt.EncryptDES(record.AdminUserName));
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool PayOrder(BuyStonesOrder buyOrder, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
string textC = "insert into buystonesrecord " +
"(`OrderNumber`, `BuyerUserName`, `BuyTime`, `AwardGoldCoin` ) " +
" values " +
"(@OrderNumber, @BuyerUserName, @BuyTime, @AwardGoldCoin); ";
mycmd = trans.CreateCommand();
mycmd.CommandText = textC;
mycmd.Parameters.AddWithValue("@OrderNumber", buyOrder.StonesOrder.OrderNumber);
string encryptUserName = DESEncrypt.EncryptDES(buyOrder.BuyerUserName);
mycmd.Parameters.AddWithValue("@BuyerUserName", encryptUserName);
mycmd.Parameters.AddWithValue("@BuyTime", buyOrder.BuyTime);
mycmd.Parameters.AddWithValue("@AwardGoldCoin", buyOrder.AwardGoldCoin);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public int GetDeletedPlayerCountByPlayerUserLoginName(string userLoginName)
{
MySqlConnection myconn = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string cmdText = "select count(id) from deletedplayerinfo where UserLoginName = @UserLoginName";
MySqlCommand mycmd = new MySqlCommand(cmdText, myconn);
mycmd.Parameters.AddWithValue("@UserLoginName", DESEncrypt.EncryptDES(userLoginName));
object objResult = mycmd.ExecuteScalar();
mycmd.Dispose();
if (objResult == DBNull.Value)
{
return(0);
}
return(Convert.ToInt32(objResult));
}
catch (Exception exc)
{
throw exc;
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public bool SaveAlipayRechargeRecord(AlipayRechargeRecord alipayRecord, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into alipayrechargerecord " +
"(`out_trade_no`, `trade_type`,`alipay_trade_no`,`user_name`,`buyer_email`,`total_fee`,`value_rmb`,`pay_time`) " +
" values (@out_trade_no, @trade_type, @alipay_trade_no,@user_name,@buyer_email,@total_fee,@value_rmb,@pay_time)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@out_trade_no", alipayRecord.out_trade_no);
mycmd.Parameters.AddWithValue("@trade_type", (int)alipayRecord.trade_type);
mycmd.Parameters.AddWithValue("@alipay_trade_no", alipayRecord.alipay_trade_no);
mycmd.Parameters.AddWithValue("@user_name", DESEncrypt.EncryptDES(alipayRecord.user_name));
mycmd.Parameters.AddWithValue("@buyer_email", alipayRecord.buyer_email);
mycmd.Parameters.AddWithValue("@total_fee", alipayRecord.total_fee);
mycmd.Parameters.AddWithValue("@pay_time", alipayRecord.pay_time);
mycmd.Parameters.AddWithValue("@value_rmb", alipayRecord.value_rmb);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddWithdrawRMBShowImageRecord(WithdrawRMBShowImageRecord record)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
string sqlText = "insert into withdrawrmbshowimagerecord ( `PlayerUserName`, `ShowImageTime`, `ImageSource`, `WithdrawRMBRecordID` )" +
" values (@PlayerUserName, @ShowImageTime, @ImageSource, @WithdrawRMBRecordID )";
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@PlayerUserName", DESEncrypt.EncryptDES(record.PlayerUserName));
mycmd.Parameters.AddWithValue("@ShowImageTime", record.ShowImageTime.ToDateTime());
mycmd.Parameters.AddWithValue("@ImageSource", record.ImageSource);
mycmd.Parameters.AddWithValue("@WithdrawRMBRecordID", record.WithdrawRMBRecordID);
myconn.Open();
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public bool AddTestUserLogState(string userName, string mac, string ip)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
mycmd = myconn.CreateCommand();
string cmdTextA = "insert into testuserlogstate " +
"(`UserName`, `Mac`, `IP`) values " +
" (@UserName, @Mac, @IP); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
mycmd.Parameters.AddWithValue("@Mac", mac);
mycmd.Parameters.AddWithValue("@IP", ip);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
/// <summary>
/// 返回-1，表示失败
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public decimal GetPlayerAlipayRechargeMoneyYuan(string userName, AlipayTradeInType[] types)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
string sqlText = "select sum(`total_fee`) as total_fee from alipayrechargerecord where user_name = @userName ";
if (types != null && types.Length > 0)
{
string subsql = " and `trade_type` in ( ";
for (int i = 0; i < types.Length; i++)
{
subsql += " @trade_type" + i;
if (i != types.Length - 1)
{
subsql += ",";
}
}
subsql += ")";
sqlText += subsql;
}
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@userName", DESEncrypt.EncryptDES(userName));
if (types != null && types.Length > 0)
{
for (int i = 0; i < types.Length; i++)
{
mycmd.Parameters.AddWithValue("@trade_type" + i.ToString(), (int)types[i]);
}
}
myconn.Open();
object objResult = mycmd.ExecuteScalar();
if (objResult == DBNull.Value)
{
return(0);
}
return(Convert.ToDecimal(objResult));
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public bool AddRouletteWinnerRecord(RouletteWinnerRecord record)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string sqlInsertText = "insert into roulettewinnerrecord " +
" (`UserID`, `AwardItemID`, `WinTime`, `IsGot`, `GotTime`, `IsPay`, `PayTime`, `GotInfo1`, `GotInfo2`) " +
" values (@UserID, @AwardItemID, @WinTime, @IsGot, @GotTime, @IsPay, @PayTime, @GotInfo1, @GotInfo2)";
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlInsertText;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@AwardItemID", record.AwardItem.ID);
mycmd.Parameters.AddWithValue("@WinTime", record.WinTime.ToDateTime());
mycmd.Parameters.AddWithValue("@IsGot", record.IsGot);
if (record.GotTime == null)
{
mycmd.Parameters.AddWithValue("@GotTime", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@GotTime", record.GotTime.ToDateTime());
}
mycmd.Parameters.AddWithValue("@IsPay", record.IsPay);
if (record.PayTime == null)
{
mycmd.Parameters.AddWithValue("@PayTime", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime.ToDateTime());
}
mycmd.Parameters.AddWithValue("@GotInfo1", DESEncrypt.EncryptDES(record.GotInfo1));
mycmd.Parameters.AddWithValue("@GotInfo2", DESEncrypt.EncryptDES(record.GotInfo2));
mycmd.ExecuteNonQuery();
mycmd.Dispose();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public MinesBuyRecord GetMineTradeRecord(string userName, string orderNumber)
{
MySqlConnection myconn = MyDBHelper.Instance.CreateConnection();
MySqlCommand mycmd = null;
try
{
DataTable table = new DataTable();
myconn.Open();
mycmd = myconn.CreateCommand();
string cmdText = "select a.*, b.UserName from minesbuyrecord a left join playersimpleinfo b on a.UserID=b.id ";
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(orderNumber))
{
builder.Append(" a.OrderNumber = @OrderNumber ");
mycmd.Parameters.AddWithValue("@OrderNumber", orderNumber);
}
if (!string.IsNullOrEmpty(userName))
{
builder.Append(" b.UserName = @UserName ");
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
}
mycmd.CommandText = cmdText;
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(table);
var lists = MetaDBAdapter <MinesBuyRecord> .GetMinesBuyRecordFromDataTable(table);
table.Clear();
table.Dispose();
adapter.Dispose();
if (lists == null || lists.Length == 0)
{
return(null);
}
return(lists[0]);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public UserRemoteServerBuyRecord GetUserLastBuyOnceRemoteServiceRecord(string playerUserName)
{
UserRemoteServerBuyRecord[] records = null;
MySqlConnection myconn = null;
try
{
DataTable dt = new DataTable();
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
MySqlCommand mycmd = myconn.CreateCommand();
string sqlTextA = "select a.* from userremoteserverbuyrecord a " +
" where a.UserID = ( select id from playersimpleinfo where UserName = @UserName ) " +
" and a.`ServerType`=@ServerType order by a.`ID` desc limit 1 ";
string encryptUserName = DESEncrypt.EncryptDES(playerUserName);
mycmd.Parameters.AddWithValue("@UserName", encryptUserName);
mycmd.Parameters.AddWithValue("@ServerType", (int)RemoteServerType.Once);
string sqlAllText = "select ttt.*, s.UserName as UserName from " +
" ( " + sqlTextA +
" ) ttt " +
" left join playersimpleinfo s on ttt.UserID = s.id ";
mycmd.CommandText = sqlAllText;
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(dt);
if (dt != null || dt.Rows.Count != 0)
{
records = MetaDBAdapter <UserRemoteServerBuyRecord> .GetUserRemoteServerBuyRecordListFromDataTable(dt);
}
dt.Clear();
dt.Dispose();
adapter.Dispose();
mycmd.Dispose();
if (records == null || records.Length == 0)
{
return(null);
}
return(records[0]);
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public bool TransferPlayer(int recordID, string adminUserName)
{
return(MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd =>
{
string sqlText = "update oldplayertransferregisterinfo set `isTransfered`=@isTransfered,`HandledTime`=@HandledTime,`HandlerName`=@HandlerName where `ID`=@ID ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@isTransfered", true);
mycmd.Parameters.AddWithValue("@HandledTime", DateTime.Now);
mycmd.Parameters.AddWithValue("@HandlerName", DESEncrypt.EncryptDES(adminUserName));
mycmd.Parameters.AddWithValue("@ID", recordID);
mycmd.ExecuteNonQuery();
}));
}
public WithdrawRMBRecord GetWithdrawRMBRecord(int state, string playerUserName, int withdrawRMB, DateTime createTime)
{
WithdrawRMBRecord record = null;
MySqlConnection myconn = null;
try
{
DataTable dt = new DataTable();
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
MySqlCommand mycmd = myconn.CreateCommand();
string sqlTextA = "select ttt.*, s.UserName as PlayerUserName from " +
" (SELECT w.* " +
" FROM withdrawrmbrecord w " +
" where w.PlayerUserID = (select id from playersimpleinfo where UserName=@UserName ) and w.RMBWithdrawState = @RMBWithdrawState and w.WidthdrawRMB = @WidthdrawRMB and w.CreateTime = @CreateTime " +
" ) ttt " +
" left join playersimpleinfo s on ttt.PlayerUserID = s.id ";
string encrypedUserName = DESEncrypt.EncryptDES(playerUserName);
mycmd.Parameters.AddWithValue("@UserName", encrypedUserName);
mycmd.Parameters.AddWithValue("@RMBWithdrawState", state);
mycmd.Parameters.AddWithValue("@WidthdrawRMB", withdrawRMB);
mycmd.Parameters.AddWithValue("@CreateTime", createTime);
mycmd.CommandText = sqlTextA;
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(dt);
if (dt != null)
{
var records = MetaDBAdapter <WithdrawRMBRecord> .GetWithdrawRMBRecordListFromDataTable(dt);
if (records != null && records.Length != 0)
{
record = records[0];
}
}
dt.Clear();
dt.Dispose();
adapter.Dispose();
mycmd.Dispose();
return(record);
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public int GetRegisteredCountByUserLoginName(string userName)
{
int count = 0;
MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd =>
{
string sqlText = "select count(ID) from oldplayertransferregisterinfo where UserName =@UserName ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
count = Convert.ToInt32(mycmd.ExecuteScalar());
});
return(count);
}
public bool AddSellOrder(SellStonesOrder order, int userID, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string cmdTextA = "insert into sellstonesorder " +
"(`OrderNumber`, `SellerUserName`, `SellStonesCount`, `Expense`, `ValueRMB`, `SellTime`, `OrderState` ) " +
" values " +
"(@OrderNumber, @SellerUserName, @SellStonesCount, @Expense, @ValueRMB, @SellTime, @OrderState); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", order.OrderNumber);
mycmd.Parameters.AddWithValue("@SellerUserName", DESEncrypt.EncryptDES(order.SellerUserName));
mycmd.Parameters.AddWithValue("@SellStonesCount", order.SellStonesCount);
mycmd.Parameters.AddWithValue("@Expense", order.Expense);
mycmd.Parameters.AddWithValue("@ValueRMB", order.ValueRMB);
mycmd.Parameters.AddWithValue("@SellTime", order.SellTime);
mycmd.Parameters.AddWithValue("@OrderState", order.OrderState);
mycmd.ExecuteNonQuery();
PlayerLastSellStoneRecord lastrecord = new PlayerLastSellStoneRecord()
{
UserID = userID,
SellStoneOrderNumber = order.OrderNumber,
SellTime = order.SellTime
};
string cmdTextB = "delete from playerlastsellstonerecord where `UserID` = @UserID ;" +
"insert into playerlastsellstonerecord " +
"(`UserID`, `SellStoneOrderNumber`, `SellTime` ) " +
" values " +
"(@UserID, @OrderNumber, @SellTime ); ";
mycmd.CommandText = cmdTextB;
mycmd.Parameters.AddWithValue("@UserID", lastrecord.UserID);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool AddWithdrawRMBRecord(WithdrawRMBRecord record, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "insert into withdrawrmbrecord " +
"(`PlayerUserID`, `AlipayAccount`, `AlipayRealName`, `WidthdrawRMB`, `ValueYuan`,`CreateTime`, `RMBWithdrawState`, `AdminUserName`, `PayTime`) " +
" values (@PlayerUserID, @AlipayAccount, @AlipayRealName, @WidthdrawRMB, @ValueYuan, @CreateTime, @RMBWithdrawState, @AdminUserName, @PayTime)";
mycmd = trans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@PlayerUserID", record.PlayerUserID);
mycmd.Parameters.AddWithValue("@AlipayAccount", DESEncrypt.EncryptDES(record.AlipayAccount));
mycmd.Parameters.AddWithValue("@AlipayRealName", DESEncrypt.EncryptDES(record.AlipayRealName));
mycmd.Parameters.AddWithValue("@WidthdrawRMB", record.WidthdrawRMB);
mycmd.Parameters.AddWithValue("@ValueYuan", record.ValueYuan);
mycmd.Parameters.AddWithValue("@CreateTime", record.CreateTime);
mycmd.Parameters.AddWithValue("@RMBWithdrawState", RMBWithdrawState.Waiting);
if (string.IsNullOrEmpty(record.AdminUserName))
{
mycmd.Parameters.AddWithValue("@AdminUserName", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@AdminUserName", DESEncrypt.EncryptDES(record.AdminUserName));
}
if (record.PayTime == null || !record.PayTime.HasValue)
{
mycmd.Parameters.AddWithValue("@PayTime", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime);
}
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddOldPlayerTransferRecord(OldPlayerTransferRegisterInfo record)
{
return(MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd =>
{
string sqlText = "insert into oldplayertransferregisterinfo (`UserName`,`AlipayAccount`,`AlipayRealName`,`Email`,`NewServerUserLoginName`,`NewServerPassword`,`SubmitTime`,`isTransfered`) " +
" values (@UserName,@AlipayAccount,@AlipayRealName,@Email,@NewServerUserLoginName,@NewServerPassword,@SubmitTime,@isTransfered) ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(record.UserLoginName));
mycmd.Parameters.AddWithValue("@AlipayAccount", DESEncrypt.EncryptDES(record.AlipayAccount));
mycmd.Parameters.AddWithValue("@AlipayRealName", DESEncrypt.EncryptDES(record.AlipayRealName));
mycmd.Parameters.AddWithValue("@Email", DESEncrypt.EncryptDES(record.Email));
mycmd.Parameters.AddWithValue("@NewServerUserLoginName", DESEncrypt.EncryptDES(record.NewServerUserLoginName));
mycmd.Parameters.AddWithValue("@NewServerPassword", DESEncrypt.EncryptDES(record.NewServerPassword));
mycmd.Parameters.AddWithValue("@SubmitTime", record.SubmitTime.ToDateTime());
mycmd.Parameters.AddWithValue("@isTransfered", false);
mycmd.ExecuteNonQuery();
}));
}
public AdminInfo GetAdmin(string userName)
{
AdminInfo admin = null;
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
DataTable dt = new DataTable();
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string cmdText = "select * from AdminInfo where `UserName` = @UserName";
mycmd = new MySqlCommand(cmdText, myconn);
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
admin = MetaDBAdapter <AdminInfo> .GetAdminInfoListFromDataTable(dt)[0];
dt.Clear();
dt.Dispose();
adapter.Dispose();
return(admin);
}
catch (Exception exc)
{
throw exc;
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SavePlayerBetInfo(RaiderPlayerBetInfo betInfo)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
//1. Save to DB
string sqlTextA = "";
#if V1
sqlTextA = "insert into raiderplayerbetinfo (`RaiderRoundID`,`UserID`,`UserName`,`BetStones`,`Time`) values ( @RaiderRoundID,@UserID,@UserName,@BetStones,@Time) ;";
#else
sqlTextA = "insert into raiderplayerbetinfo (`RaiderRoundID`,`UserID`,`BetStones`,`Time`) values ( @RaiderRoundID,@UserID,@BetStones,@Time) ;";
#endif
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlTextA;
mycmd.Parameters.AddWithValue("@RaiderRoundID", betInfo.RaiderRoundID);
mycmd.Parameters.AddWithValue("@UserID", betInfo.UserID);
#if V1
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(betInfo.UserName));
#endif
mycmd.Parameters.AddWithValue("@BetStones", betInfo.BetStones);
mycmd.Parameters.AddWithValue("@Time", betInfo.Time.ToDateTime());
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public TestUserLogState GetTestUserLogStateByUserName(string userName)
{
MySqlConnection myconn = MyDBHelper.Instance.CreateConnection();
MySqlCommand mycmd = null;
try
{
DataTable table = new DataTable();
myconn.Open();
mycmd = myconn.CreateCommand();
string cmdText = "select * from testuserlogstate where UserName = @UserName ";
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
mycmd.CommandText = cmdText;
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(table);
var lists = MetaDBAdapter <TestUserLogState> .GetTestUserLogStateFromDataTable(table);
table.Clear();
table.Dispose();
adapter.Dispose();
if (lists == null || lists.Length == 0)
{
return(null);
}
return(lists[0]);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}
public bool DeleteAdmin(string userName)
{
MySqlConnection myconn = MyDBHelper.Instance.CreateConnection();
MySqlCommand mycmd = null;
try
{
string textB = "delete from admininfo where UserName = @UserName;";
myconn.Open();
mycmd = myconn.CreateCommand();
mycmd.CommandText = textB;
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool SetWinnerRecordGot(RouletteWinnerRecord record)
{
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string sqlInsertText = "update roulettewinnerrecord " +
" set `IsGot` = @IsGot, `GotTime` = @GotTime, `GotInfo1` = @GotInfo1, `GotInfo2` = @GotInfo2 where `id` = @ID ";
mycmd = myconn.CreateCommand();
mycmd.CommandText = sqlInsertText;
mycmd.Parameters.AddWithValue("@IsGot", record.IsGot);
mycmd.Parameters.AddWithValue("@GotTime", record.GotTime.ToDateTime());
mycmd.Parameters.AddWithValue("@GotInfo1", DESEncrypt.EncryptDES(record.GotInfo1));
mycmd.Parameters.AddWithValue("@GotInfo2", DESEncrypt.EncryptDES(record.GotInfo2));
mycmd.Parameters.AddWithValue("@ID", record.RecordID);
mycmd.ExecuteNonQuery();
mycmd.Dispose();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
if (myconn != null)
{
myconn.Close();
myconn.Dispose();
}
}
}