public string GetUser_Rate(eRate eDataRate, string sUID = "", string sAccount = "")
{
if (StartServerAliveCheck() == false)
{
return(string.Empty);
}
string sString = string.Empty;
string sID = sUID == "" ? m_sMyUID : sUID;
string sAcc = sAccount == "" ? m_sMyAccount : sAccount;
string m_sConnect = string.Format("Server={0};Database=ck_netgame;Uid={1};Pwd={2}", m_gServer, m_gID, m_gPass);
string sRate = string.Empty;
switch (eDataRate)
{
case eRate.E_RATE_DRAW:
sRate = "UDRAW";
break;
case eRate.E_RATE_WIN:
sRate = "UWIN";
break;
case eRate.E_RATE_LOSE:
sRate = "ULOSE";
break;
}
using (MySqlConnection conn = new MySqlConnection(m_sConnect))
{
conn.Open();
string sql = string.Format("SELECT {0} FROM userinfo where UID='{1}' and UACCOUNT='{2}'", sRate, sID, sAcc);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
sString = rdr[0].ToString();
}
rdr.Close();
}
return(sString);
}
public void SetUpdate_Rate(int nVal, eRate eDataRate, string sUID = "", string sAccount = "")
{
if (StartServerAliveCheck() == false)
{
return;
}
string m_sConnect = string.Format("Server={0};Database=ck_netgame;Uid={1};Pwd={2}", m_gServer, m_gID, m_gPass);
string sID = sUID == "" ? m_sMyUID : sUID;
string sAcc = sAccount == "" ? m_sMyAccount : sAccount;
string sRate = string.Empty;
switch (eDataRate)
{
case eRate.E_RATE_DRAW:
sRate = "UDRAW";
break;
case eRate.E_RATE_WIN:
sRate = "UWIN";
break;
case eRate.E_RATE_LOSE:
sRate = "ULOSE";
break;
}
using (MySqlConnection m_pSqlCon = new MySqlConnection(m_sConnect))
{
m_pSqlCon.Open();
string sSql = string.Format("UPDATE userinfo SET {0}='{1}' where UID='{2}' and UACCOUNT='{3}'", sRate, nVal.ToString(), sID, sAcc);
MySqlCommand pCmd = new MySqlCommand(sSql, m_pSqlCon);
pCmd.ExecuteNonQuery();
}
}
