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);
}
}
