public SqlSELECT(object select, string from, object where = null) : this() { if (select != null) { if (select.GetType().IsArray) { SELECT.AddRange((object[])select); } else { SELECT.Add(select); } } FROM = from; if (where != null) { var whereArr = where as IEnumerable <object>; if (whereArr == null) { WHERE.Add(where); } else { WHERE.AddRange(whereArr); } } }
// プレイ画面に戻る void SelectPlay() { this.state = STATE.FIRST; this.modeSelect = SELECT.PLAY; Time.timeScale = 1.0f; this.gameObject.SetActive(false); }
// 設定を変更し前の画面に戻る処理 void SelectChange() { this.state = STATE.FIRST; this.modeSelect = SELECT.PLAY; this.volumeUI.SetActive(false); // ボリュームを変更する処理 for (int i = 0; i < sliderObjects.Length; i++) { preSliderValue[i] = sliders[i].value; } }
public static void Auth(string data) { try { var req = SELECT.SelectLoginRequest("*", "users", Items.GetLoginList(), Items.SetLoginList(data)); RequestToDB.CreateRequest(req, "LoginRequest"); } catch (Exception ex) { FormsManaging.TextGenerator(ex.ToString()); } }
public int AddCompetencyLearningResource(int resourceRefID, string resourceName, string description, string resourceType, string link, string catalogue, decimal rating, int competencyID, int adminId) { return(connection.ExecuteScalar <int>( @$ " DECLARE @learningResourceReferenceID int IF NOT EXISTS(SELECT * FROM LearningResourceReferences WHERE @resourceRefID = resourceRefID) BEGIN INSERT INTO LearningResourceReferences( ResourceRefID, OriginalResourceName, OriginalDescription, OriginalResourceType, ResourceLink, OriginalCatalogueName, OriginalRating, AdminID, Added) VALUES( @resourceRefID, @resourceName, @description, @resourceType, @link, @catalogue, @rating, @adminID, GETDATE()) SELECT @learningResourceReferenceID = SCOPE_IDENTITY() END ELSE BEGIN SELECT TOP 1 @learningResourceReferenceID = ID FROM LearningResourceReferences WHERE @resourceRefID = resourceRefID END INSERT INTO CompetencyLearningResources(CompetencyID, LearningResourceReferenceID, AdminID) VALUES (@competencyID, @learningResourceReferenceID, @adminID) SELECT SCOPE_IDENTITY() AS CompetencyLearningResourceId", new { resourceRefID, resourceName, description, resourceType, link, catalogue, rating, competencyID, adminId } )); }
public static string RequestLeaderboards(int id) { SELECT Select = new SELECT(); //string count = RequestToDB.CreateRequest(Select.SelectData("*", "scores", "score"), "GetLeaderboardsRequest", id); //var CountOfItems = count.Split(' ').Count(); //var result = new List<LeaderList>(CountOfItems); //for (int i = 0; i < result.Capacity; i++) //{ // result.Add(new LeaderList { data = count }); //} //return count; return(null); }
private void Update() { this.horizontal = Input.GetAxisRaw("Horizontal"); this.vertical = Input.GetAxisRaw("Vertical") * -1; // 上下の移動量格納 if (preVertical == 0) { if (vertical > 0) { this.value++; } else if (vertical < 0) { this.value--; } } // 左右の移動量格納 if (preHorizontal == 0 && modeSelect == SELECT.CANCEL || modeSelect == SELECT.CHANGE) { if (horizontal > 0) { this.value = (int)SELECT.CHANGE; } else if (horizontal < 0) { this.value = (int)SELECT.CANCEL; } } // 最小値と最大値以内に値を設定する this.value = Mathf.Clamp(value, 0, (int)SELECT.CHANGE); // 値をモード選択状態に代入 this.modeSelect = (SELECT)value; // ボリュームを変更する処理へ if (modeSelect != SELECT.CANCEL && modeSelect != SELECT.CHANGE) { ChangeVolume(); } // 1フレーム前の値を格納 this.preHorizontal = horizontal; this.preVertical = vertical; }
public static void Insert(int new_All, int new_Firma, int new_Detal, int new_Diagnostik, long ID_ZAKAZ) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(@"new_All", SqlDbType.Int) { Value = new_All }, new SqlParameter(@"new_Firma", SqlDbType.Int) { Value = new_Firma }, new SqlParameter(@"new_Detal", SqlDbType.Int) { Value = new_Detal }, new SqlParameter(@"new_Diagnostik", SqlDbType.Int) { Value = new_Diagnostik }, new SqlParameter(@"ID_ZAKAZ", SqlDbType.BigInt) { Value = ID_ZAKAZ } }; #region sql string sqlText = @$ " -- получаем предыдущие значения, запоминаем и их логируем declare @old_All int ,@old_Firma int ,@old_Detal int ,@old_Diagnostik int; SELECT @old_All=MoneyAll ,@old_Firma=MoneyFirm ,@old_Detal=MoneyDetal ,@old_Diagnostik=MoneyDiagnostik FROM Zakaz WHERE ID_ZAKAZ=@ID_ZAKAZ INSERT INTO [LogMoney] (
public static string RequestLeaderboards() { string count = RequestToDB.CreateRequest(SELECT.SelectData("*", "scores", "score"), "GetLeaderboardsRequest"); int CountOfItems = count.Split(' ').Count(); List <LeaderList> result = new List <LeaderList>(CountOfItems); for (int i = 0; i < result.Capacity; i++) { result.Add(new LeaderList() { data = count }); } var responce = count; return(responce); }
public string BasicImportStart(bool dropTableFirst) { if (dropTableFirst) { return(@$ " {LogMessageInScript($" Importing { FullFilePath } ")} SELECT @JSON = BulkColumn FROM OPENROWSET(BULK '{FullFilePath}', SINGLE_CLOB) AS j {DropTableStatement(TableName)} SELECT * INTO {TableName} FROM OPENJSON(@JSON) "); }
void Update() { // ロック中ならこれ以降処理を読まない if (GameMgr.IsLock) { return; } this.horizontal = Input.GetAxisRaw("Horizontal"); this.vertical = Input.GetAxisRaw("Vertical") * -1; switch (state) { case STATE.FIRST: FirstUI(); break; case STATE.SECOND: SecondUI(); break; } // 値をモード選択状態に代入 this.modeSelect = (SELECT)value; // 1フレーム前の値を格納 this.preHorizontal = horizontal; this.preVertical = vertical; // アニメーション状態処理 AnimationState(); // Bボタンでモード選択 if (Input.GetButtonDown("PAD_B_BUTTON") && CheckStartAnimation()) { ModeTransition(); } }
WHERE cr.CourseRunId IN ( SELECT DISTINCT c.CourseRunId FROM [Pttcd].[FindACourseIndex] c
/****** Object: Database [UserInfor] Script Date: 08/15/2019 09:36:38 ******/ IF EXISTS (SELECT name FROM sys.databases WHERE name = N'UserInfor')
/// <summary> /// /// </summary> /// <param name="name"></param> public void GetByName(string name) { SELECT select = new SELECT(Table); select.AddWhere(new Column(NameColumnName), Operator.Equals, name, Vendjuuren.SQL.Boolean.AND); base.GetByStatement(select); }
FROM (SELECT IDNOCR, COUNT(*) AS ADDCOUNT FROM SRLIB.RGLIDCH
// 設定画面表示 void SelectSetting() { this.volumeUI.SetActive(true); this.state = STATE.SECOND; this.modeSelect = SELECT.MASTER; }
LEFT JOIN (SELECT IDNOCR, COUNT(*) AS DROPCOUNT FROM SRLIB.RGLIDCH
/// <summary> /// /// </summary> /// <param name="group"></param> /// <param name="number"></param> public void GetByLetterNumber(Group group, int number) { SELECT select = new SELECT(Table); select.AddWhere(new Column(GroupIDColumnName), Operator.Equals, group.ID, Vendjuuren.SQL.Boolean.AND); select.AddWhere(new Column(NumberColumnName), Operator.Equals, number, Vendjuuren.SQL.Boolean.AND); base.GetByStatement(select); }
public static void GetUserScores(string username) { RequestToDB.CreateRequest(SELECT.SelectLoginRequest("score", "scores", "username", Items.GetScoreList(username)), "GetScoreRequest"); }
/// <summary> /// /// </summary> /// <remarks> /// TODO: 1 algemene method maken /// </remarks> /// <param name="id"></param> public void GetAllByProgramID(Guid id) { SELECT select = new SELECT(Table); select.AddWhere(new Column(ProgramIDColumnName), Operator.Equals, id, Vendjuuren.SQL.Boolean.AND); base.GetAllByStatement(select); }
AS ( SELECT T1.ID, T1.NOMBRE, T1.DESCRIPCION, T1.ICONO, T1.ACTIVO, T1.IDPADRE, T1.IDVISTA_MVC, T1.ORDEN
/// <summary> /// /// </summary> /// <param name="letter"></param> public void GetByLetter(Letter letter) { SELECT select = new SELECT(Table); select.AddWhere(new Column(LetterColumnName), Operator.Equals, letter, Vendjuuren.SQL.Boolean.AND); base.GetByStatement(select); }
FROM ( SELECT groups.[Id],
/// <summary> /// /// </summary> /// <param name="name"></param> public void GetByBrandAndType(Brand brand, string type) { SELECT select = new SELECT(Table); select.AddWhere(new Column(BrandIDColumnName), Operator.Equals, brand.ID, Vendjuuren.SQL.Boolean.AND); select.AddWhere(new Column(TypeColumnName), Operator.Equals, type, Vendjuuren.SQL.Boolean.AND); base.GetByStatement(select); }
private void RetrieveLine2_MSAS( Dictionary <Level, HashSet <Member> > src, Line ALine, Hierarchy intelligenceh, StringBuilder WHERE, List <long> idxmul, List <Level> idxlevels, MOlapCube cube, ref StringBuilder WITH, List <Hierarchy> sources, string MeasureName, ref StringBuilder SELECT, ref long idx, ref StringBuilder SUBCUBE) { //DebugLogging.WriteLine("MdEngine.RetrieveLine2_MSAS(aline={0})", ALine.ToString()); var single = true; var subcubeCounter = 0; var lh = new List <Hierarchy>(2); if (cube.Is2000) { WHERE.Append(MeasureName); foreach (var h in sources) // visual totals { if (h.Filtered) { cube.MakeVisualTotals(h, WITH); lh.Add(h); } } } else { if (ALine.Measure.IsKPI) { switch (ALine.fMode.Mode) { case MeasureShowModeType.smKPIValue: case MeasureShowModeType.smSpecifiedByEvent: WHERE.Append("KPIValue"); break; case MeasureShowModeType.smKPIGoal: WHERE.Append("KPIGoal"); break; case MeasureShowModeType.smKPIStatus: WHERE.Append("KPIStatus"); break; case MeasureShowModeType.smKPITrend: WHERE.Append("KPITrend"); break; case MeasureShowModeType.smKPIWeight: WHERE.Append("KPIWeight"); break; } WHERE.Append("(\""); WHERE.Append(ALine.Measure.UniqueName); WHERE.Append("\")"); } else { WHERE.Append(MeasureName); } } var lh2 = new List <Hierarchy>(); var singles = new SortedList <string, Member>(); foreach (var h in FGrid.FFilteredHierarchies) // subcube filtered { Member m = null; var _done = false; if (cube.Is2000) { if (lh.Contains(h)) { continue; // already processed (visualtotals) } foreach (var probe in src) { bool ss; if (probe.Key.Hierarchy == h) { _done = true; cube.MakeWhere(h, WITH, WHERE, probe.Value, out ss); single = single && ss; if (single && probe.Value.Count == 1) { if (m != null) { single = false; } else { m = probe.Value.First(); } } } } } else { if (h.RetrieveFilteredMember() != null && !IsHierarchyInLevels(h, ALine.Levels)) { foreach (var probe in src) { if (probe.Key.Hierarchy == h) { cube.MakeWhere(h, WITH, WHERE, probe.Value, out single); if (single) { var m1 = probe.Value.First(); singles.Add(h.UniqueName, m1); if (h == intelligenceh && WITH.ToString().Contains("{0}")) { // sets restriction member to the intelligence script WITH = new StringBuilder(WITH.ToString().Replace("{0}", m.UniqueName)); } } lh2.Add(h); break; } } } } if (cube.Is2000) { if (!_done) { cube.MakeWhere(h, WITH, WHERE, null, out single); } if (single) { singles.Add(h.UniqueName, m); if (h == intelligenceh && WITH.ToString().Contains("{0}")) { WITH = new StringBuilder(WITH.ToString().Replace("{0}", m.UniqueName)); } } lh2.Add(h); } else { if (lh2.Contains(h)) { continue; } if (SUBCUBE == null) { SUBCUBE = new StringBuilder("SELECT "); } if (subcubeCounter > 0) { SUBCUBE.Append(","); SUBCUBE.AppendLine(); } SUBCUBE.Append("{"); //SUBCUBE.Append(cube.DoSubcubeFilter(h, m)); SUBCUBE.Append(cube.DoSubcubeFilter(h, null)); SUBCUBE.Append("} ON "); SUBCUBE.Append(subcubeCounter++); lh2.Add(h); } } string contextsubcube = null; if (cube.Is2000) { foreach (var probe in src) // apply other restrictions { if (probe.Value.Count > 1 || probe.Key.Hierarchy == null) { continue; } if (!lh2.Contains(probe.Key.Hierarchy)) { if (sources.Contains(probe.Key.Hierarchy) && (!ALine.Levels.Contains(probe.Key) || probe.Key.Hierarchy.Origin == HierarchyOrigin.hoParentChild)) { continue; } if (probe.Key.Hierarchy.Origin == HierarchyOrigin.hoParentChild) { if (probe.Value.Count == 1 && ALine.Levels.Contains(probe.Key)) { if (probe.Value.First().Depth == ALine.fDepthes[ALine.Levels.IndexOf(probe.Key)] - 1) { continue; } } } if (src.Keys.Any(item => item.Hierarchy == probe.Key.Hierarchy && item.Index > probe.Key.Index)) { continue; } cube.MakeWhere(probe.Key.Hierarchy, WITH, WHERE, probe.Value, out single); if (!single) { continue; } } if (!singles.ContainsKey(probe.Key.Hierarchy.UniqueName) && probe.Value.Count == 1) { singles.Add(probe.Key.Hierarchy.UniqueName, probe.Value.First()); if (probe.Key.Hierarchy == intelligenceh && WITH.ToString().Contains("{0}")) { WITH = new StringBuilder(WITH.ToString().Replace("{0}", probe.Value.First().UniqueName)); } } idx += probe.Value.First().ID *ALine.Multipliers[ALine.Levels.IndexOf(probe.Key)]; } } else { contextsubcube = cube.GetContextFilterSubcube(FGrid); if (SUBCUBE != null) { SUBCUBE.AppendLine(); SUBCUBE.Append("FROM "); SUBCUBE.Append(contextsubcube); } } // make crossjoin var b = false; for (var i = 0; i < ALine.Levels.Count; i++) { var l = ALine.Levels[i]; if (singles.ContainsKey(l.Hierarchy.UniqueName)) { continue; } idxlevels.Add(l); idxmul.Add(ALine.Multipliers[ALine.Levels.IndexOf(l)]); if (b) { SELECT.Append("*"); } var me = new HashSet <Member>(); foreach (var probe in src) { if (probe.Key.Hierarchy == l.Hierarchy) { me = probe.Value; break; } } SELECT.Append(cube.MakeCrossjoin(l, WITH, me, ALine.fDepthes[i])); if (l.Hierarchy == intelligenceh && WITH.ToString().Contains("{0}")) { // sets "currentmember" for the crossjoin hierarchy to the intelligence script WITH = new StringBuilder(WITH.ToString().Replace("{0}", l.Hierarchy.UniqueName + ".CURRENTMEMBER")); } b = true; } if (idxlevels.Count == 0) { SELECT = new StringBuilder("SELECT "); } else { if (cube.MDXCellsetThreshold > 0 && cube.Is2000 == false) { SELECT.Append("}), " + cube.MDXCellsetThreshold + ")} DIMENSION PROPERTIES MEMBER_TYPE ON 0 "); } else { SELECT.Append("} DIMENSION PROPERTIES MEMBER_TYPE ON 0 "); } } if (cube.Is2000) { SELECT.AppendLine(); SELECT.Append("FROM "); SELECT.Append(cube.ApplySubcubeFilter()); SELECT.AppendLine(); WHERE.Append(")"); } else { if (SUBCUBE == null) { SELECT.Append("FROM "); SELECT.Append(contextsubcube); } else { SELECT.Append("FROM ("); SELECT.Append(SUBCUBE); SELECT.Append(")"); } SELECT.AppendLine(); WHERE.Append(")"); } }
LEFT OUTER JOIN (SELECT COUNT(1) as LiveCourseCount,
LEFT OUTER JOIN (SELECT COUNT(1) AS LiveTLevelCount,
AND (SELECT DATEDIFF(DAY, [startDate], @startDate)) = 0