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