public static bool GetUser(string id, string pwd)
{
string sqlCommand = string.Format("select id from Admin where name=@UserId and pwd=@UserPwd", new object[0]);
SqlParameter[] prams = new SqlParameter[] { SqlDBA.MakeInParam("@UserId", SqlDbType.VarChar, 10, id), SqlDBA.MakeInParam("@UserPwd", SqlDbType.VarChar, 10, pwd) };
DataTable dBToDataTable = DBAi.GetDBToDataTable(sqlCommand, prams);
if (dBToDataTable == null)
{
return(false);
}
if (dBToDataTable.Rows.Count == 0)
{
return(false);
}
return(true);
}
public static string getstrConnection(string db, string server)
{
try
{
if (db == null)
{
db = "rxjhgame";
}
if (db == "PublicDb")
{
return(ConfigurationManager.AppSettings["PublicDb"].ToString());
}
string sqlCommand = string.Format("select * from serverlist WHERE serverid = @serverid", new object[0]);
SqlParameter[] prams = new SqlParameter[] { SqlDBA.MakeInParam("@serverid", SqlDbType.VarChar, 30, server) };
DataTable dBToDataTable = DBAi.GetDBToDataTable(sqlCommand, prams);
if (dBToDataTable != null)
{
if (dBToDataTable.Rows.Count > 0)
{
if (db == "rxjhaccount")
{
return(string.Format("Data Source={0};uid={1};pwd={2};database={3};Packet Size=4096;Pooling=true;Max Pool Size=512;Min Pool Size=1"
, dBToDataTable.Rows[0]["DbIp"].ToString(), dBToDataTable.Rows[0]["DbUser"].ToString(), dBToDataTable.Rows[0]["DbPass"].ToString(), dBToDataTable.Rows[0]["DbAccount"].ToString()));
}
return(string.Format("Data Source={0};uid={1};pwd={2};database={3};Packet Size=4096;Pooling=true;Max Pool Size=512;Min Pool Size=1",
dBToDataTable.Rows[0]["DbIp"].ToString(), dBToDataTable.Rows[0]["DbUser"].ToString(), dBToDataTable.Rows[0]["DbPass"].ToString(), dBToDataTable.Rows[0]["DbGame"].ToString()));
}
return(null);
}
return(null);
}
catch
{
return(null);
}
}
public static void SetLog(string 用户, string IP, string 操作类型, string 操作内容)
{
DBAi.ExeSqlCommand(string.Format("INSERT INTO 操作日志(用户,IP,操作类型,操作内容) VALUES('{0}','{1}','{2}','{3}')",
用户, IP, 操作类型, 操作内容));
}
public static void SetItmeLog(long id, string ItmeName, string name, string sx, string server, string sm)
{
DBAi.ExeSqlCommand(string.Format("INSERT INTO Itme_Log (ItmeId,ItmeName,[name],shuxing,server,sm)values({0},'{1}','{2}','{3}','{4}','{5}')",
id, ItmeName, name, sx, server, sm));
}
