public void ApiScorePostTestNormalWithNoRights() { string userName = "******"; UserApi api = new UserApi(Common.DefaultConfig); api.ApiUserPost(Common.AdminAuth, new User(userName, userName, new List <UserRole>())); string authorization = Common.GetAuthHeader(userName, userName); ScoreItem item = new ScoreItem(null, Common.GameName, null, null, 100, Common.UserName); var ex = Assert.Catch(() => instance.ApiScorePost(authorization, item)) as ApiException; Assert.AreEqual(Common.ForbiddenCode, ex.ErrorCode); }
public GameView(TextureManager _t, SoundManagerEx _s, int level, Player p) { texturemanager = _t; soundmanager = _s; rendererlevel = level; this.player = p; GameEntityRenderer = Stage1State._renderer; //获取控制器处的renderer // _Particles = new Particle.FlyingFlowersParticles(texturemanager); ScoreRenderer = new ScoreItem(_t); leftBottomBox = new LeftBottomBox(texturemanager); TitleStartBox = new GameViewComponent.TitleStartBox(texturemanager); BGMChangeBox = new GameViewComponent.BGMChangeBox(texturemanager); }
public void ApiScorePostTestMassiveSequence() { int itemsToSend = 100; string checkAuthorization = Common.AdminAuth; string authorization = Common.AdminAuth; ScoreItem item = new ScoreItem(null, Common.GameName, null, null, 100, Common.UserName); for (int i = 0; i < itemsToSend; i++) { var result = instance.ApiScorePost(authorization, item); Assert.IsNotNull(instance.ApiScoreHistoryGet(checkAuthorization).Select(obj => obj.Key == result.Key)); } }
public static ScoreItemList CreateFromJSON(string jsonString) { ScoreItemList scoreItemList = new ScoreItemList(); var delimeter = '|'; string[] scoreStrings = jsonString.Split(delimeter); foreach (string scoreString in scoreStrings) { ScoreItem scoreItem = ScoreItem.CreateFromJSON(scoreString); scoreItemList.scores.Add(scoreItem); } return(scoreItemList); }
private static async Task Do() { IMongoDatabase database = _client.GetDatabase("school"); IMongoCollection <Item> collection = database.GetCollection <Item>("students"); List <Item> t = await collection.Find(new BsonDocument()).ToListAsync(); foreach (Item item in t) { ScoreItem lowerst = item.Scores.OrderBy(x => x.Score).First(x => x.Type == "homework"); item.Scores.Remove(lowerst); ReplaceOneResult result = await collection.ReplaceOneAsync(x => x.Id == item.Id, item); } }
private void GetClosestScoreItem() { _treasure = FindObjectsOfType <ScoreItem>(); var distance = float.MaxValue; foreach (var t in _treasure) { var d = Vector3.Distance(transform.position, t.transform.position); if (d < distance) { distance = d; _targetItem = t; } } }
public void SetScore(params bool[] rightAnswers) { gameObject.SetActive(true); int index = 1; foreach (var answer in rightAnswers) { ScoreItem item = Instantiate(prefab.gameObject, holder).GetComponent <ScoreItem>(); item.Activate(true); item.SetIndex(index); item.SetCorrect(answer); index++; } }
// GET: SelfRate public ActionResult Index() { try { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { //Log.Error(ex + ex.StackTrace); TempData["SessionExipred"] = "true"; //TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "Login", null)); } MysqlDBA <ScoreItem> mysqlDBA = new MysqlDBA <ScoreItem>(FunctionController.CONNSTR); //MysqlDBA<InstScoreTable> mysqlDBAInstScoreTable = new MysqlDBA<InstScoreTable>(FunctionController.CONNSTR); List <ScoreItem> lstScoreItem = new List <ScoreItem>(); DataSet scoreItemsdateSet = mysqlDBA.getDataSet(string.Format("SELECT * FROM ScoreItem WHERE ItemParentNo='-1'")); List <InstScoreTable> instScoreTables = Utility.Utility.getInstScore(Session["INSTNO"].ToString(), (DateTime.Now.Year - 1911).ToString()); foreach (DataRow scoreItem in scoreItemsdateSet.Tables[0].Rows) { ScoreItem score_Item = new ScoreItem(); score_Item.ItemNo = scoreItem["ItemNo"].ToString(); score_Item.ItemParentNo = scoreItem["ItemParentNo"].ToString(); score_Item.ItemDesc = scoreItem["ItemDesc"].ToString(); score_Item.ItemGrade = scoreItem["ItemGrade"].ToString(); score_Item.ItemScore = scoreItem["ItemScore"].ToString(); score_Item.EvalYear = scoreItem["EvalYear"].ToString(); score_Item.EvalType = scoreItem["EvalType"].ToString(); score_Item.CreateDate = scoreItem["CreateDate"].ToString(); score_Item.getChildItem(Session["INSTNO"].ToString(), score_Item.ItemNo); lstScoreItem.Add(score_Item); if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } } TempData["ScoreItems"] = lstScoreItem; TempData["InstScores"] = instScoreTables; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "SelfRate", null)); } return(View()); }
void Explode() { int bricksLayerMask = LayerMask.GetMask("Bricks"); Vector3 p0 = transform.position + Vector3.up * bombVerticalRange; Vector3 p1 = transform.position + Vector3.down * bombVerticalRange; Collider[] colliders = Physics.OverlapCapsule(p0, p1, explosionRadius, bricksLayerMask); Obstacle obstacle = colliders.Length > 0 ? colliders[0].GetComponentInParent <Obstacle>() : null; if (obstacle != null) { foreach (Collider collider in colliders) { bool isGold = collider.CompareTag("Gold"); if (isGold && !InputManager.Instance.isSuperBombActive) { continue; } GameObject shatteredPrefab = isGold ? shatteredGoldBrickPrefab : shatteredBrickPrefab; GameObject scatteredBrick = Instantiate(shatteredPrefab, collider.transform.position, collider.transform.rotation); obstacle.AddToScatters(scatteredBrick); Destroy(collider.gameObject); foreach (Rigidbody rb in scatteredBrick.GetComponentsInChildren <Rigidbody>()) { rb.AddExplosionForce(explosionForce, transform.position, explosionRadius); } } ScoreItem scoreItem = new ScoreItem(colliders.Length, scorePerBrick * colliders.Length); ScoreManager.Instance.AddScore(ScoreType.Brick, scoreItem); } if (explosionVFX) { ParticleSystem explosionVFXInstance = Instantiate(explosionVFX, transform.position, Quaternion.identity, MemoryManager.Instance.transform); explosionVFXInstance.gameObject.transform.LookAt(GameManager.mainCamera.transform); } GameManager.mainCamera.Shake(screenShakeMagnitude); AudioManager.Instance.Play(explosionSFX); trail.transform.SetParent(MemoryManager.Instance.transform); Destroy(gameObject); }
public void Update(ScoreItem item) { lock ( _context ) { ScoreItem score = _context.Scores.Find(item.Key); if (score != null) { score.Date = item.Date; score.Game = item.Game; score.Param = item.Param; score.Score = item.Score; score.User = item.User; score.Version = item.Version; _context.SaveChanges(); } } }
private void CreateScoreBoardClient() { if (scoreJsonMsg != null) { SaveScoreJsonMsg(scoreJsonMsg); } for (int i = 0; i < scoreMsg.scoreList.Count && i < maxScoreNum; i++) { ScoreItem item = scoreMsg.scoreList[i]; GameObject scoreRow = Instantiate(scoreRowPefab) as GameObject; ScoreRow scoreRowScript = scoreRow.GetComponent <ScoreRow>(); scoreRowScript.rankNum.text = item.account.ToString(); scoreRowScript.score.text = item.score.ToString(); scoreRowScript.dateTime.text = item.time.ToString(); scoreRow.transform.SetParent(contentPanel, false); //Debug.Log(scoreRow.transform.localPosition.ToString()); } }
// прочитать счет обоих режимов из файла public ClassScoreManager ReadScores() { try { var sdCardPath = Android.OS.Environment.ExternalStorageDirectory.AbsolutePath; var filePath = System.IO.Path.Combine(sdCardPath + "/Application/Dageron Studio", "dageron_angry_pacman.xml"); FileStream fStream = new FileStream(filePath, FileMode.Open, FileAccess.Read); var myBinaryFormatter = new BinaryFormatter(); var mc = (ClassScoreManager)myBinaryFormatter.Deserialize(fStream); fStream.Close(); return(mc); } catch (Exception e) { Score = new ScoreItem(); return(this); } }
public int CompareTo(object obj) { if (obj == null) { return(1); } ScoreItem otherItem = obj as ScoreItem; if (otherItem != null) { return(this.score.CompareTo(otherItem.score)); } else { throw new ArgumentException("Object is not a ScoreItem"); } }
public IActionResult Create([FromBasicAuth] string auth, [FromBody] ScoreItem item) { if (item == null) { return(BadRequest()); } if (!Auth.IsAllowed(auth, item.Game, UserPermission.PostScores)) { return(Auth.Result); } if (GameItems.Find(item.Game) == null) { return(BadRequest("Game not found")); } item.Date = DateTime.Now; ScoreItems.Add(item); return(CreatedAtRoute("GetScore", new { id = item.Key }, item)); }
public void AddScore(IMove move, int score) { ScoreItem new_item = new ScoreItem(move, score, _sortBySpace); lock (_sync) { //if(_scores.Count < _scores.Capacity) //{ _scores.Add(new_item); _scores.Sort(); //} //else if (new_item.CompareTo(_scores.Last()) > 0) //{ // _scores[_scores.Count - 1] = new_item; // _scores.Sort(); //} } }
public void AddScore(ScoreType type, ScoreItem item) { scoresByType[type] += item; float newScore = Score; scoreSlider.value = newScore; int currentLevel = LevelManager.level; if (newScore >= currentLevelMaxScore) { scoreSlider.minValue = currentLevelMaxScore; currentLevelMaxScore = GetLevelMaxScore(currentLevel + 1); scoreSlider.maxValue = currentLevelMaxScore; LevelManager.Instance.LevelUp(); } }
// прочитать счет обоих режимов из файла public ClassScoreManager ReadScores() { try { var sdCardPath = Android.OS.Environment.ExternalStorageDirectory.AbsolutePath; var filePath = System.IO.Path.Combine(sdCardPath+"/Application/Dageron Studio", "dageron_angry_pacman.xml"); FileStream fStream = new FileStream(filePath, FileMode.Open, FileAccess.Read); var myBinaryFormatter = new BinaryFormatter(); var mc = (ClassScoreManager) myBinaryFormatter.Deserialize(fStream); fStream.Close(); return mc; } catch (Exception e) { Score = new ScoreItem (); return this; } }
/** * Get Scores saved on PlayerPrefs **/ public List <ScoreItem> GetSavedTopScores() { var lst = new List <ScoreItem>(); var i = 0; while (i < MaxScoresSaved && PlayerPrefs.HasKey("Scores[" + i + "].name")) { var strAux = PlayerPrefs.GetString("Scores[" + i + "].playerType"); var pTypeAux = strAux == PlayerType.Boss.ToString() ? PlayerType.Boss : PlayerType.Employee; var tmp = new ScoreItem( PlayerPrefs.GetInt("Scores[" + i + "].score"), PlayerPrefs.GetString("Scores[" + i + "].name"), pTypeAux); lst.Add(tmp); i++; } return(lst); }
public static string getScoreTitle(string itemNo) { string strRet = string.Empty; try { MysqlDBA <ScoreItem> mysqlDBA_AttrBase = new MysqlDBA <ScoreItem>(FunctionController.CONNSTR); ScoreItem baseattr = new ScoreItem(); baseattr.ItemNo = itemNo; List <ScoreItem> objLst = (List <ScoreItem>)mysqlDBA_AttrBase.getDataList(baseattr); if (objLst.Count > 0) { strRet = objLst[0].ItemDesc; } } catch (Exception ex) { throw ex; } return(strRet); }
public void Init() { if (ScoreSheet == null) { return; } GridItems.ColumnDefinitions.Clear(); GridItems.Children.Clear(); for (int i = 0; i < ScoreSheet.Items.Count; i++) { ScoreItem item = ScoreSheet.Items[i]; if (item.Type == ScoreObjectType.ScoreGroup) { UCScoreGroupViewer ucScoreGroup = new UCScoreGroupViewer(); ucScoreGroup.ScoreGroup = item as ScoreGroup; if (i > 0) { ucScoreGroup.BorderThickness = new Thickness(1, 0, 0, 0); } GridItems.ColumnDefinitions.Add(new ColumnDefinition()); GridItems.Children.Add(ucScoreGroup); ucScoreGroup.SetValue(Grid.ColumnProperty, i); ucScoreGroup.Init(); } else { UCStandardViewer ucStandard = new UCStandardViewer(); ucStandard.Standard = item as Standard; if (i > 0) { ucStandard.BorderThickness = new Thickness(1, 0, 0, 0); } GridItems.ColumnDefinitions.Add(new ColumnDefinition()); GridItems.Children.Add(ucStandard); ucStandard.SetValue(Grid.ColumnProperty, i); ucStandard.Init(); } } ScoreObject_OnPropertyChanged(this, null); }
private void InitScoreGroupList() { mListScoreGroups.Clear(); if (ScoreSheet == null) { return; } ScoreSheet.SetItemLevel(); List <ScoreItem> listItems = new List <ScoreItem>(); ScoreSheet.GetAllScoreItem(ref listItems); for (int i = 0; i < listItems.Count; i++) { ScoreItem item = listItems[i]; ScoreGroup group = item as ScoreGroup; if (group != null) { mListScoreGroups.Add(group); } } mListScoreGroups.Add(ScoreSheet); }
private void win() { minClok1.Pause(); clok1.Pause(); Console.WriteLine(minClok1.Minutes.ToString() + ":" + clok1.Seconds.ToString()); ListViewItem lvi = new ListViewItem(); lvi.Text = player; //(This is the 'name' property of our form) lvi.SubItems.Add(minClok1.Minutes.ToString() + ":" + clok1.Seconds.ToString()); lvi.SubItems.Add(rollCount.Text); lvScores.Items.Add(lvi); ScoreItem s = new ScoreItem(); s.Name = player; s.Time = minClok1.Minutes.ToString() + ":" + clok1.Seconds.ToString(); s.Moves = Convert.ToInt32(rollCount.Text); ExistingScoresList.Add(s); save(); output.Text = "You Win!!!"; }
/// <summary> /// initialize score list /// </summary> void InitScore() { HashSet <float> scores = new HashSet <float>(); if (PlayerPrefs.HasKey("ScoreData")) { // gettings scores from prefs scores = new HashSet <float>(JsonUtility.FromJson <ScoreData>(PlayerPrefs.GetString("ScoreData", "")).scores.OrderByDescending(x => x)); } int count = 0; //spawn score items foreach (float score in scores) { count++; ScoreItem item = Instantiate(scorePref, scorePref.transform.parent); item.score.text = score.ToString(); item.gameObject.SetActive(true); item.image.color = scoreGradient.Evaluate(((float)scores.Count / (float)count) / (float)scores.Count); // setup color for score item } }
void ScoreObject_OnPropertyChanged(object sender, PropertyChangedEventArgs e) { ScoreItem scoreItem = ScoreGroup; if (scoreItem != null) { VisualStyle style = scoreItem.TitleStyle; if (style != null) { LbTitle.Foreground = new SolidColorBrush(style.ForeColor); BorderTitle.Background = new SolidColorBrush(style.BackColor); if (style.FontFamily != null) { LbTitle.FontFamily = style.FontFamily; } if (style.FontSize != 0) { LbTitle.FontSize = style.FontSize; } LbTitle.FontWeight = style.FontWeight; } style = scoreItem.PanelStyle; if (style != null) { if (style.Width != 0) { BorderPanel.Width = style.Width; } else { BorderPanel.ClearValue(WidthProperty); } BorderPanel.Background = new SolidColorBrush(style.BackColor); } } }
private void CreateFlagIcons() { if (ScoreItem == null) { return; } if (mPanelFlags == null) { return; } mPanelFlags.Children.Clear(); IconButton iconItem; ScoreSetting setting; ScoreLangauge langauge; //描述 if (!string.IsNullOrEmpty(ScoreItem.Description)) { iconItem = new IconButton(); iconItem.Name = "BtnDescription"; iconItem.Display = "Description"; iconItem.ToolTip = "Show or Close Description"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T102"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/info.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_DESCRIPTION"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } //备注 if (ScoreItem.Comments.Count > 0 && !(ScoreItem is ScoreSheet)) { iconItem = new IconButton(); iconItem.Name = "BtnComments"; iconItem.Display = "Comments"; iconItem.ToolTip = "Show or Close Comments"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T103"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/showcomment.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_COMMENT_ITEM"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } //关键项 if (ScoreItem.IsKeyItem) { iconItem = new IconButton(); iconItem.Name = "BtnKeyItem"; iconItem.Display = "KeyItem"; iconItem.ToolTip = "Key Item"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T104"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/keyitem.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_KEY_ITEM"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } //附加项 if (ScoreItem.IsAddtionItem) { iconItem = new IconButton(); iconItem.Name = "BtnAdditionItem"; iconItem.Display = "AdditionItem"; iconItem.ToolTip = "Addition Item"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T105"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/additionalitem.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_ADD_ITEM"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } //自动评分项 var standard = ScoreItem as Standard; if (standard != null && standard.IsAutoStandard) { iconItem = new IconButton(); iconItem.Name = "BtnAutoStandardItem"; iconItem.Display = "AutoStandardItem"; iconItem.ToolTip = "AutoStandard Item"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T109"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/autostandard.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_AUTO_ITEM"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } var controlFlag = ScoreItem.ControlFlag; //控制源 if ((controlFlag & 1) != 0) { iconItem = new IconButton(); iconItem.Name = "BtnControlSource"; iconItem.Display = "ControlSource"; iconItem.ToolTip = "Control Source Item"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T106"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } List <ControlItem> listControlItems = new List <ControlItem>(); ScoreItem.GetControlScoreItem(ref listControlItems); if (listControlItems.Count > 0) { string strToolTip = string.Empty; for (int i = 0; i < listControlItems.Count; i++) { var item = listControlItems[i]; strToolTip += string.Format("\r\n({0}) {1}", i, item.GetControlInfo()); } iconItem.ToolTip += strToolTip; } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/controlitem.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_CTL_SRC"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } //控制目标 if ((controlFlag & 2) != 0) { iconItem = new IconButton(); iconItem.Name = "BtnControlTarget"; iconItem.Display = "ControlTarget"; iconItem.ToolTip = "Control Target Item"; if (Languages != null) { langauge = Languages.FirstOrDefault(l => l.LangID == LangID && l.Category == "ScoreViewer" && l.Code == "T107"); if (langauge != null) { iconItem.ToolTip = langauge.Display; } } List <ControlItem> listControledItems = new List <ControlItem>(); ScoreItem.GetControledScoreItem(ref listControledItems); if (listControledItems.Count > 0) { string strToolTip = string.Empty; for (int i = 0; i < listControledItems.Count; i++) { var item = listControledItems[i]; strToolTip += string.Format("\r\n({0}) {1}", i, item.GetControlInfo()); } iconItem.ToolTip += strToolTip; } iconItem.IconPath = "/UMPScoreSheet;component/Themes/Images/controltarget.png"; if (Settings != null) { setting = Settings.FirstOrDefault(s => s.Category == "I" && s.Code == "I_CTL_TGT"); if (setting != null) { iconItem.IconPath = setting.Value; } } iconItem.Click += IconButton_Click; mPanelFlags.Children.Add(iconItem); } }
public IHttpActionResult GetResults(int id, int? groupId = null) { Fixture found = Database.GetFixture(id); Dictionary<Team, int> result = new Dictionary<Team, int>(); if (found == null) { return NotFound(); } else { switch (found.Mode) { case MatchMode.Tournament: //TODO:Retrive teams according positions, once it is ended if (groupId.HasValue) { var group = found.Groups.SingleOrDefault(g => g.Id == groupId.Value); result = group == null ? null : group.Scores; } break; case MatchMode.LeagueOneWay: case MatchMode.LeagueTwoWay: result = found.TeamScores; break; } List<ScoreItem> scores =new List<ScoreItem>(); foreach (var keyValue in result) { var score = new ScoreItem() {TeamName = keyValue.Key.Name, Score = keyValue.Value}; scores.Add(score); } scores.Sort(new ScoreComparer()); return Ok(scores); } }
public static ScoreItem LoggedInPlayerScore(string UserCode, string LevelName) { ScoreItem playerScore = new ScoreItem(); var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["jhealthConnection"].ConnectionString); using (var db = new HpbDbContext(connection)) { //var cmd = db.Database.Connection.CreateCommand(); //cmd.CommandText = "SP_GetPlayerScore_HPB"; //cmd.CommandType = System.Data.CommandType.StoredProcedure; //DbParameter param1 = cmd.CreateParameter(); //param1.DbType = DbType.String; //param1.ParameterName = "@UserCode"; //param1.Value = UserCode; //cmd.Parameters.Add(param1); //try //{ // if (db.Database.Connection.State != ConnectionState.Open) // db.Database.Connection.Open(); // var reader = cmd.ExecuteReader(); // var rsBadges = ((IObjectContextAdapter)db).ObjectContext.Translate<ScoreItem>(reader); // playerScore = rsBadges.First(); //} //catch (Exception exp) //{ // throw exp; //} //finally //{ // db.Database.Connection.Close(); //} var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "SP_LeaderBoardHS_HPB"; cmd.CommandType = System.Data.CommandType.StoredProcedure; DbParameter param1 = cmd.CreateParameter(); param1.DbType = DbType.String; param1.ParameterName = "@UserId"; param1.Value = UserCode; cmd.Parameters.Add(param1); DbParameter param2 = cmd.CreateParameter(); param2.DbType = DbType.String; param2.ParameterName = "@LevelName"; param2.Value = LevelName; cmd.Parameters.Add(param2); DbParameter param3 = cmd.CreateParameter(); param3.DbType = DbType.Int32; param3.ParameterName = "@PageStart"; param3.Value = 0; cmd.Parameters.Add(param3); DbParameter param4 = cmd.CreateParameter(); param4.DbType = DbType.Int32; param4.ParameterName = "@PageLength"; param4.Value = 10; cmd.Parameters.Add(param4); try { if (db.Database.Connection.State != ConnectionState.Open) { db.Database.Connection.Open(); } var reader = cmd.ExecuteReader(); //var rsCount = ((IObjectContextAdapter)db).ObjectContext.Translate<int>(reader); //playerScore.Count = rsCount.FirstOrDefault<int>(); reader.NextResult(); //var rsScores = ((IObjectContextAdapter)db).ObjectContext.Translate<ScoreItem>(reader); //playerScore.LeaderboardScores = rsScores.ToArray<ScoreItem>().ToList(); reader.NextResult(); var rsPlayerScore = ((IObjectContextAdapter)db).ObjectContext.Translate <ScoreItem>(reader); playerScore = rsPlayerScore.FirstOrDefault <ScoreItem>(); } catch (Exception exp) { throw exp; } finally { db.Database.Connection.Close(); } } return(playerScore); }
private OperationReturn LoadScoreItem(SessionInfo session, ScoreItem parent, string scoreID) { OperationReturn optReturn = new OperationReturn(); optReturn.Result = true; optReturn.Code = 0; try { string rentToken = session.RentInfo.Token; ScoreSheet scoreSheet = parent.ScoreSheet; if (scoreSheet == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ScoreSheet is null"); return(optReturn); } string temp1 = string.Empty; string temp2 = string.Empty; if (!string.IsNullOrWhiteSpace(scoreID)) { temp1 = string.Format(",T3109.C005 AS NA"); temp2 = string.Format(" LEFT JOIN T_31_009_{0} T3109 ON T3102.C002=T3109.C002", rentToken); } string strSql; DataSet objDataSet; switch (session.DBType) { case 2: strSql = string.Format( "SELECT T3102.*{4} FROM T_31_002_{0} T3102{5} WHERE T3102.C003 = {1} AND T3102.C004 = {2}{3} ", rentToken, scoreSheet.ID, parent.ID, scoreID, temp1, temp2); optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } objDataSet = optReturn.Data as DataSet; break; case 3: strSql = string.Format( "SELECT T3102.*{4} FROM T_31_002_{0} T3102{5} WHERE T3102.C003 = {1} AND T3102.C004 = {2}{3} ", rentToken, scoreSheet.ID, parent.ID, scoreID, temp1, temp2); optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } objDataSet = optReturn.Data as DataSet; break; default: optReturn.Result = false; optReturn.Code = Defines.RET_PARAM_INVALID; optReturn.Message = string.Format("DBType invalid"); return(optReturn); } if (objDataSet == null || objDataSet.Tables.Count <= 0) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("DataSet is null or DataTables empty"); return(optReturn); } List <ScoreItem> listItems = new List <ScoreItem>(); for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { DataRow dr = objDataSet.Tables[0].Rows[i]; ScoreItem scoreItem; bool isStandard = dr["C009"].ToString() == "Y"; if (isStandard) { Standard standard = null; StandardType standardType = (StandardType)Convert.ToInt32(dr["C015"]); switch (standardType) { case StandardType.Numeric: NumericStandard numericStandard = new NumericStandard(); numericStandard.Type = ScoreObjectType.NumericStandard; numericStandard.MaxValue = Convert.ToDouble(dr["C027"]); numericStandard.MinValue = Convert.ToDouble(dr["C028"]); numericStandard.DefaultValue = string.IsNullOrWhiteSpace(dr["C029"].ToString()) ? 0 : Convert.ToDouble(dr["C029"]); numericStandard.ScoreClassic = StandardClassic.TextBox; standard = numericStandard; break; case StandardType.YesNo: YesNoStandard yesNoStandard = new YesNoStandard(); yesNoStandard.Type = ScoreObjectType.YesNoStandard; if (string.IsNullOrWhiteSpace(dr["C029"].ToString())) { yesNoStandard.DefaultValue = false; } else { if (Convert.ToDouble(dr["C029"]) == 1.0) { yesNoStandard.DefaultValue = true; } else { yesNoStandard.DefaultValue = false; } } yesNoStandard.ReverseDisplay = dr["C104"].ToString() == "1"; yesNoStandard.ScoreClassic = StandardClassic.YesNo; standard = yesNoStandard; break; case StandardType.Slider: SliderStandard sliderStandard = new SliderStandard(); sliderStandard.Type = ScoreObjectType.SliderStandard; sliderStandard.MinValue = Convert.ToDouble(dr["C023"]); sliderStandard.MaxValue = Convert.ToDouble(dr["C024"]); sliderStandard.Interval = Convert.ToDouble(dr["C026"]); sliderStandard.DefaultValue = string.IsNullOrWhiteSpace(dr["C029"].ToString()) ? 0 : Convert.ToDouble(dr["C029"]); sliderStandard.ScoreClassic = StandardClassic.Slider; standard = sliderStandard; break; case StandardType.Item: ItemStandard itemStandard = new ItemStandard(); itemStandard.Type = ScoreObjectType.ItemStandard; itemStandard.ScoreClassic = StandardClassic.DropDownList; itemStandard.DefaultIndex = string.IsNullOrWhiteSpace(dr["C029"].ToString())?0: Convert.ToInt32(dr["C029"]); standard = itemStandard; break; } if (standard == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("Standard is null"); return(optReturn); } standard.PointSystem = Convert.ToDouble(dr["C018"]); standard.StandardType = standardType; standard.IsAutoStandard = dr["C101"].ToString() == "Y"; if (!string.IsNullOrWhiteSpace(scoreID)) { if (string.IsNullOrWhiteSpace(dr["NA"].ToString())) { standard.IsNA = false; } else { standard.IsNA = dr["NA"].ToString() == "Y" ? true : false; } } string strStaID = dr["C102"].ToString(); long staID; if (long.TryParse(strStaID, out staID)) { standard.StatisticalID = staID; } scoreItem = standard; } else { ScoreGroup scoreGroup = new ScoreGroup(); scoreGroup.Type = ScoreObjectType.ScoreGroup; scoreGroup.IsAvg = dr["C016"].ToString() == "Y"; scoreItem = scoreGroup; } scoreItem.ScoreSheet = parent.ScoreSheet; scoreItem.Parent = parent; scoreItem.ItemID = Convert.ToInt32(dr["C001"]); scoreItem.ID = Convert.ToInt64(dr["C002"]); scoreItem.OrderID = Convert.ToInt32(dr["C005"]); scoreItem.Title = dr["C006"].ToString(); scoreItem.Description = dr["C007"].ToString(); scoreItem.TotalScore = Convert.ToDouble(dr["C008"]); scoreItem.IsAbortScore = dr["C010"].ToString() == "Y"; scoreItem.ControlFlag = dr["C011"].ToString() == "Y" ? 1 : 0; scoreItem.IsKeyItem = dr["C012"].ToString() == "Y"; scoreItem.IsAllowNA = dr["C013"].ToString() == "Y"; scoreItem.IsJumpItem = dr["C014"].ToString() == "Y"; scoreItem.IsAddtionItem = dr["C017"].ToString() == "Y"; scoreItem.UsePointSystem = dr["C019"].ToString() == "Y"; scoreItem.ScoreType = dr["C020"].ToString() == "F" ? ScoreType.YesNo : dr["C020"].ToString() == "P" ? ScoreType.Pecentage : ScoreType.Numeric; scoreItem.Tip = dr["C022"].ToString(); scoreItem.AllowModifyScore = dr["C103"].ToString() == "Y"; #region 子项 //如果是 ScoreGroup 加载子项 if (!isStandard) { ScoreGroup scoreGroup = scoreItem as ScoreGroup; optReturn = LoadScoreItem(session, scoreGroup, scoreID); if (!optReturn.Result) { return(optReturn); } List <ScoreItem> subItems = optReturn.Data as List <ScoreItem>; if (subItems == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ListItems is null"); return(optReturn); } for (int j = 0; j < subItems.Count; j++) { ScoreItem subItem = subItems[j]; scoreGroup.Items.Add(subItem); } scoreGroup.Items = scoreGroup.Items.OrderBy(j => j.OrderID).ToList(); } //如果是多值型评分标准,加载评分标准子项 ItemStandard temp = scoreItem as ItemStandard; if (temp != null) { optReturn = LoadStandardItem(session, temp); if (!optReturn.Result) { return(optReturn); } List <StandardItem> valueItems = optReturn.Data as List <StandardItem>; if (valueItems == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ValueItems is null"); return(optReturn); } for (int j = 0; j < valueItems.Count; j++) { StandardItem valueItem = valueItems[j]; temp.ValueItems.Add(valueItem); } temp.ValueItems = temp.ValueItems.OrderBy(j => j.OrderID).ToList(); } #endregion #region 备注 OperationReturn commentReturn; commentReturn = LoadComment(session, scoreItem); if (!commentReturn.Result) { return(commentReturn); } List <Comment> listComments = commentReturn.Data as List <Comment>; if (listComments == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("listComments is null"); return(optReturn); } for (int j = 0; j < listComments.Count; j++) { Comment comment = listComments[j]; scoreItem.Comments.Add(comment); } scoreItem.Comments = scoreItem.Comments.OrderBy(j => j.OrderID).ToList(); #endregion #region 样式 OperationReturn styleReturn; styleReturn = LoadVisualStyle(session, scoreItem, "T"); if (!styleReturn.Result) { if (styleReturn.Code != Defines.RET_NOT_EXIST) { return(styleReturn); } scoreItem.TitleStyle = null; } else { VisualStyle style = styleReturn.Data as VisualStyle; if (style != null) { style.ScoreSheet = scoreSheet; scoreItem.TitleStyle = style; } } styleReturn = LoadVisualStyle(session, scoreItem, "P"); if (!styleReturn.Result) { if (styleReturn.Code != Defines.RET_NOT_EXIST) { return(styleReturn); } scoreItem.PanelStyle = null; } else { VisualStyle style = styleReturn.Data as VisualStyle; if (style != null) { style.ScoreSheet = scoreSheet; scoreItem.PanelStyle = style; } } #endregion listItems.Add(scoreItem); } optReturn.Data = listItems; } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; } return(optReturn); }
public static void Initialize(QuizContext context) { context.Database.EnsureCreated(); if (context.QuizItems.Any()) { return; } var quizItems = new QuizItem[] { new QuizItem { Title = "Is Lorem Ipsum the industry's standard dummy text?", Answer = "Yes", Option1 = "No", Option2 = "Lorem ipsum dolor sit amet" }, new QuizItem { Title = "Why?", Answer = "I don't know man, I just came for the pizza", Option1 = "Yeet", Option2 = "This is the right answer" }, new QuizItem { Title = "Have you tried Vegemite?", Answer = "Oi mate, I got that vegemite stuck in me peen", Option1 = "Vegemite is just up-side-down Marmite", Option2 = "I svea rike använder vi enbart Tartex och smörgåsgurka" }, new QuizItem { Title = "PK fire?", Answer = "PK FIRE! PK FIRE! PK FIRE! PK FIRE!", Option1 = "Backthrow needs a buff", Option2 = "PK Thunder is a great recovery" }, new QuizItem { Title = "How much wood would a woodchuck chuck if a woodchuck could feel happyness?", Answer = "80 painful years", Option1 = "null", Option2 = "NaN" }, new QuizItem { Title = "Does thou skrrt skrrt?", Answer = "Yes but on the inside I hurt hurt", Option1 = "Big Shaq boom boom", Option2 = "lmao ye man" }, new QuizItem { Title = "What's your story", Answer = "...", Option1 = "I was finally awake! I tried to cross the border and walked right into that imperial ambush same as that thief over there.", Option2 = "At age six I was born without a face." }, new QuizItem { Title = "Hello there!", Answer = "General Kenobi!", Option1 = "I came to chew ass and kick bubblegum", Option2 = "Oj! Vilken överaskning! Kommer och filmar mig när jag går på muggen!" }, new QuizItem { Title = "What in Oblivion is that!?", Answer = "a footlong Dragon D***o", Option1 = "Crocs", Option2 = "My will to live" }, new QuizItem { Title = "What have we got to lose?", Answer = "Nothing but our chains", Option1 = "Deez nutz", Option2 = "seething hatred for the muffinman" } }; context.AddRange(quizItems); context.SaveChanges(); if (context.ScoreItems.Any()) { return; } var scoreItems = new ScoreItem[] { new ScoreItem() { User = "******", Score = 8 }, new ScoreItem() { User = "******", Score = 2 }, new ScoreItem() { User = "******", Score = 0 }, new ScoreItem() { User = "******", Score = 5 }, new ScoreItem() { User = "******", Score = 12 }, }; context.ScoreItems.AddRange(scoreItems); context.SaveChanges(); }
public void Start() { itemGen = this.gameObject.GetComponent <ItemGenerator>(); scoreItem = this.gameObject.GetComponent <ScoreItem>(); }
public void Start() { ScoreRenderer = new ScoreItem(texturemanager); leftBottomBox = new LeftBottomBox(texturemanager); leftBottomBox = new LeftBottomBox(texturemanager); TitleStartBox = new GameViewComponent.TitleStartBox(texturemanager,0,220); TitleStartBox.BindStage(GameViewComponent.TitleStartBox.Stage1); //绑定为Stage1 BGMChangeBox = new GameViewComponent.BGMChangeBox(texturemanager,0,420); //绑定BGM盒 }
private OperationReturn LoadComment(SessionInfo session, ScoreItem scoreItem) { OperationReturn optReturn = new OperationReturn(); optReturn.Result = true; optReturn.Code = 0; try { string rentToken = session.RentInfo.Token; ScoreSheet scoreSheet = scoreItem.ScoreSheet; if (scoreSheet == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ScoreSheet is null"); return(optReturn); } string strSql; DataSet objDataSet; switch (session.DBType) { case 2: strSql = string.Format( "SELECT * FROM T_31_004_{0} WHERE C002 = {1} AND C003 = {2}", rentToken, scoreItem.ID, scoreSheet.ID); optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } objDataSet = optReturn.Data as DataSet; break; case 3: strSql = string.Format( "SELECT * FROM T_31_004_{0} WHERE C002 = {1} AND C003 = {2}", rentToken, scoreItem.ID, scoreSheet.ID); optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } objDataSet = optReturn.Data as DataSet; break; default: optReturn.Result = false; optReturn.Code = Defines.RET_PARAM_INVALID; optReturn.Message = string.Format("DBType invalid"); return(optReturn); } if (objDataSet == null || objDataSet.Tables.Count <= 0) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("DataSet is null or DataTables empty"); return(optReturn); } List <Comment> listComments = new List <Comment>(); for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { DataRow dr = objDataSet.Tables[0].Rows[i]; Comment comment; int intCommentStyle = Convert.ToInt32(dr["C008"]); switch (intCommentStyle) { case (int)CommentStyle.Text: TextComment textComment = new TextComment(); textComment.Type = ScoreObjectType.TextComment; textComment.DefaultText = dr["C005"].ToString(); comment = textComment; break; case (int)CommentStyle.Item: ItemComment itemComment = new ItemComment(); itemComment.Type = ScoreObjectType.ItemComment; comment = itemComment; break; default: optReturn.Result = false; optReturn.Code = Defines.RET_NOT_EXIST; optReturn.Message = string.Format("CommentStyle not exist"); return(optReturn); } comment.Style = (CommentStyle)intCommentStyle; comment.ID = Convert.ToInt64(dr["C001"]); comment.ScoreItem = scoreItem; comment.ScoreSheet = scoreSheet; comment.OrderID = Convert.ToInt32(dr["C004"]); comment.Title = dr["C009"].ToString(); #region 样式 OperationReturn styleReturn; styleReturn = LoadVisualStyle(session, comment, "T"); if (!styleReturn.Result) { if (styleReturn.Code != Defines.RET_NOT_EXIST) { return(styleReturn); } comment.TitleStyle = null; } else { VisualStyle style = styleReturn.Data as VisualStyle; if (style != null) { style.ScoreSheet = scoreSheet; comment.TitleStyle = style; } } styleReturn = LoadVisualStyle(session, comment, "P"); if (!styleReturn.Result) { if (styleReturn.Code != Defines.RET_NOT_EXIST) { return(styleReturn); } comment.PanelStyle = null; } else { VisualStyle style = styleReturn.Data as VisualStyle; if (style != null) { style.ScoreSheet = scoreSheet; comment.PanelStyle = style; } } #endregion #region 子项 var temp = comment as ItemComment; if (temp != null) { OperationReturn commentItemReturn; commentItemReturn = LoadCommentItem(session, temp); if (!commentItemReturn.Result) { return(commentItemReturn); } List <CommentItem> listItems = commentItemReturn.Data as List <CommentItem>; if (listItems == null) { commentItemReturn.Result = false; commentItemReturn.Code = Defines.RET_OBJECT_NULL; commentItemReturn.Message = string.Format("ListCommentItems is null"); return(commentItemReturn); } for (int j = 0; j < listItems.Count; j++) { temp.ValueItems.Add(listItems[j]); } temp.ValueItems = temp.ValueItems.OrderBy(j => j.OrderID).ToList(); } #endregion listComments.Add(comment); } optReturn.Data = listComments; } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; } return(optReturn); }
public void Add(ScoreItem si) { scores.Add (si); }
private List<ScoreItem> CompileLists(List<string> hitList, List<string> savedList) { List<ScoreItem> scoreLists = new List<ScoreItem>(); bool shouldCreateNewItem= true; foreach (string hit in hitList) { foreach (ScoreItem item in scoreLists) { if (hit == item.name) { item.AddAmount(); item.AddHit(); shouldCreateNewItem= false; break; } } if (shouldCreateNewItem) { ScoreItem newItem = new ScoreItem(hit); scoreLists.Add(newItem); newItem.AddHit(); } shouldCreateNewItem = true; } shouldCreateNewItem = true; foreach (string saved in savedList) { foreach (ScoreItem item in scoreLists) { if (saved == item.name) { item.AddAmount(); item.AddSaved(); shouldCreateNewItem= false; break; } } if (shouldCreateNewItem) { ScoreItem newItem = new ScoreItem(saved); scoreLists.Add(newItem); newItem.AddSaved(); } shouldCreateNewItem = true; } return scoreLists; }
Particle.Particles _Particles; //粒子效果 #endregion Fields #region Constructors public GameView(TextureManager _t, SoundManagerEx _s , int level , Player p) { texturemanager = _t; soundmanager = _s; rendererlevel = level; this.player = p; GameEntityRenderer = Stage1State._renderer; //获取控制器处的renderer // _Particles = new Particle.FlyingFlowersParticles(texturemanager); ScoreRenderer = new ScoreItem(_t); leftBottomBox = new LeftBottomBox(texturemanager); TitleStartBox = new GameViewComponent.TitleStartBox(texturemanager); BGMChangeBox = new GameViewComponent.BGMChangeBox(texturemanager); }
private OperationReturn LoadScoreSheet(SessionInfo session, string scoreSheetID, string scoreID) { OperationReturn optReturn = new OperationReturn(); optReturn.Result = true; optReturn.Code = 0; try { string rentToken = session.RentInfo.Token; string strSql; DataSet objDataSet; switch (session.DBType) { case 2: strSql = string.Format( "SELECT * FROM T_31_001_{0} WHERE C001 = {1}", rentToken, scoreSheetID); optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } objDataSet = optReturn.Data as DataSet; break; case 3: strSql = string.Format( "SELECT * FROM T_31_001_{0} WHERE C001 = {1}", rentToken, scoreSheetID); optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } objDataSet = optReturn.Data as DataSet; break; default: optReturn.Result = false; optReturn.Code = Defines.RET_PARAM_INVALID; optReturn.Message = string.Format("DBType invalid"); return(optReturn); } if (objDataSet == null || objDataSet.Tables.Count <= 0) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("DataSet is null or DataTables empty"); return(optReturn); } if (objDataSet.Tables[0].Rows.Count <= 0) { optReturn.Result = false; optReturn.Code = Defines.RET_NOT_EXIST; optReturn.Message = string.Format("ScoreSheet not exist"); return(optReturn); } DataRow dr = objDataSet.Tables[0].Rows[0]; ScoreSheet scoreSheet = new ScoreSheet(); scoreSheet.Type = ScoreObjectType.ScoreSheet; scoreSheet.ScoreSheet = scoreSheet; scoreSheet.ID = Convert.ToInt64(dr["C001"]); scoreSheet.Title = dr["C002"].ToString(); scoreSheet.ViewClassic = dr["C003"].ToString() == "C" ? ScoreItemClassic.Table : ScoreItemClassic.Tree; scoreSheet.TotalScore = Convert.ToDouble(dr["C004"]); scoreSheet.Creator = Convert.ToInt64(dr["C005"]); scoreSheet.CreateTime = Convert.ToDateTime(dr["C006"]); scoreSheet.DateFrom = Convert.ToDateTime(dr["C009"]); scoreSheet.DateTo = Convert.ToDateTime(dr["C010"]); scoreSheet.QualifiedLine = Convert.ToDouble(dr["C011"]); scoreSheet.ScoreType = dr["C014"].ToString() == "F" ? ScoreType.YesNo : dr["C014"].ToString() == "P" ? ScoreType.Pecentage : ScoreType.Numeric; scoreSheet.UseTag = Convert.ToInt32(dr["C017"]); scoreSheet.Description = dr["C019"].ToString(); scoreSheet.CalAdditionalItem = dr["C020"].ToString() != "N"; scoreSheet.UsePointSystem = dr["C021"].ToString() != "N"; string strScoreWidth = dr["C101"].ToString(); string strTipWidth = dr["C102"].ToString(); double intScoreWidth, intTipWidth; if (double.TryParse(strScoreWidth, out intScoreWidth)) { scoreSheet.ScoreWidth = intScoreWidth; } if (double.TryParse(strTipWidth, out intTipWidth)) { scoreSheet.TipWidth = intTipWidth; } scoreSheet.HasAutoStandard = dr["C103"].ToString() != "N"; scoreSheet.AllowModifyScore = dr["C104"].ToString() != "N"; #region 子项 if (scoreID == "0") { scoreID = string.Empty; } else { scoreID = string.Format(" AND T3109.C003={0}", scoreID); } //加载子项 optReturn = LoadScoreItem(session, scoreSheet, scoreID); if (!optReturn.Result) { return(optReturn); } List <ScoreItem> listItems = optReturn.Data as List <ScoreItem>; if (listItems == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ListItems is null"); return(optReturn); } for (int i = 0; i < listItems.Count; i++) { ScoreItem scoreItem = listItems[i]; scoreSheet.Items.Add(scoreItem); } scoreSheet.Items = scoreSheet.Items.OrderBy(i => i.OrderID).ToList(); #endregion 子项 #region 样式 OperationReturn styleReturn; styleReturn = LoadVisualStyle(session, scoreSheet, "T"); if (!styleReturn.Result) { if (styleReturn.Code != Defines.RET_NOT_EXIST) { return(styleReturn); } scoreSheet.TitleStyle = null; } else { VisualStyle style = styleReturn.Data as VisualStyle; if (style != null) { style.ScoreSheet = scoreSheet; scoreSheet.TitleStyle = style; } } styleReturn = LoadVisualStyle(session, scoreSheet, "P"); if (!styleReturn.Result) { if (styleReturn.Code != Defines.RET_NOT_EXIST) { return(styleReturn); } scoreSheet.PanelStyle = null; } else { VisualStyle style = styleReturn.Data as VisualStyle; if (style != null) { style.ScoreSheet = scoreSheet; scoreSheet.PanelStyle = style; } } #endregion #region 备注 OperationReturn commentReturn; commentReturn = LoadComment(session, scoreSheet); if (!commentReturn.Result) { return(commentReturn); } List <Comment> listComments = commentReturn.Data as List <Comment>; if (listComments == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("listComments is null"); return(optReturn); } for (int i = 0; i < listComments.Count; i++) { Comment comment = listComments[i]; scoreSheet.Comments.Add(comment); } scoreSheet.Comments = scoreSheet.Comments.OrderBy(j => j.OrderID).ToList(); #endregion #region 控制项 OperationReturn controlReturn; controlReturn = LoadControlItem(session, scoreSheet); if (!controlReturn.Result) { return(controlReturn); } List <ControlItem> listControlItems = controlReturn.Data as List <ControlItem>; if (listControlItems == null) { optReturn.Result = false; optReturn.Code = Defines.RET_OBJECT_NULL; optReturn.Message = string.Format("ListCotnrolItems is null"); return(optReturn); } for (int i = 0; i < listControlItems.Count; i++) { ControlItem controlItem = listControlItems[i]; scoreSheet.ControlItems.Add(controlItem); } scoreSheet.ControlItems = scoreSheet.ControlItems.OrderBy(j => j.OrderID).ToList(); #endregion optReturn.Data = scoreSheet; } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; } return(optReturn); }