public void AddSystemMailAndSend(CSCommon.Data.SystemMailData data, ServerFrame.DB.DBConnect connect) { if (this.mDBConnect.mConnection == null) { this.mDBConnect = connect; } DataTable tab = connect._ExecuteSql(data.SelectSql, "roleinfo"); if (tab != null) { foreach (DataRow i in tab.Rows) { ulong id = Convert.ToUInt64(i["RoleId"]); var role = GetRole(id); if (role != null && role.PlanesConnect != null) { SendPlayerMail(id); } } } }