/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(ThreadPartLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.Board = jsonObject.Board; result.OpPostNum = jsonObject.OpPostNum; result.FromPost = jsonObject.FromPost; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(PostLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.Board = jsonObject.Board; result.OpPostNum = jsonObject.OpPostNum; result.PostNum = jsonObject.PostNum; }
protected override void OnEndRefreshList() { string SelectValorizacion = "SELECT SUM(costo*stock_actual) FROM articulos"; if (this.Definicion.Joins != null && this.Definicion.Joins.Count > 0) { foreach (qGen.Join Jo in this.Definicion.Joins) { SelectValorizacion += Jo.ToString(); } } if (this.CustomFilters.Count > 0) { SelectValorizacion += " WHERE " + this.CustomFilters.ToString(); } this.Contadores[0].Total = this.Connection.FieldDecimal(SelectValorizacion); SelectValorizacion = "SELECT SUM(pvp*stock_actual) FROM articulos"; if (this.Definicion.Joins != null && this.Definicion.Joins.Count > 0) { foreach (qGen.Join Jo in this.Definicion.Joins) { SelectValorizacion += Jo.ToString(); } } if (this.CustomFilters.Count > 0) { SelectValorizacion += " WHERE " + this.CustomFilters.ToString(); } this.Contadores[1].Total = this.Connection.FieldDecimal(SelectValorizacion); base.OnEndRefreshList(); }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(CaptchaLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.CaptchaType = jsonObject.CaptchaType; result.CaptchaContext = jsonObject.CaptchaContext; result.CaptchaId = jsonObject.CaptchaId; result.Board = jsonObject.Board; result.ThreadId = jsonObject.ThreadId; }
protected void cmdSave_Click(object sender, EventArgs e) { Jo jo = new Jo(g_user_id, g_lang); Message msg = new Message(g_user_id, g_lang); ComLibrary com = new ComLibrary(); jo.plan_no = txtLOT_NO.Text; jo.catg_cd = txtDEL_TYPE.Text; jo.demand_no = txtLOT_NO2.Text; if (ddlTYPE.SelectedValue == "Block") { if (jo.Inv_ManWhsInsert() == ComConst.FAILED) { lblMsg.Text = jo.strErr; lblMsg.ForeColor = Color.Red; return; } } if (ddlTYPE.SelectedValue == "Head") { if (jo.Inv_ManWhsInsertA() == ComConst.FAILED) { lblMsg.Text = jo.strErr; lblMsg.ForeColor = Color.Red; return; } } if (ddlTYPE.SelectedValue == "Crank Shaft") { if (jo.Inv_ManWhsInsertB() == ComConst.FAILED) { lblMsg.Text = jo.strErr; lblMsg.ForeColor = Color.Red; return; } } if (ddlTYPE.SelectedValue == "Conn Rod") { if (jo.Inv_ManWhsInsertC() == ComConst.FAILED) { lblMsg.Text = jo.strErr; lblMsg.ForeColor = Color.Red; return; } } lblMsg.Text = msg.GetMessage("NORMAL_UPDATE"); lblMsg.ForeColor = Color.Blue; txtLOT_NO.Text = ""; txtDEL_TYPE.Text = ""; txtLOT_NO2.Text = ""; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(ThreadTagLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.Board = jsonObject.Board; result.Tag = jsonObject.Tag; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(UriLink result, Jo jsonObject) { result.Uri = jsonObject.Uri; }
public override string ToString() { System.Text.StringBuilder Command = new System.Text.StringBuilder(); Command.Append("SELECT "); if (this.Window != null && this.Window.Limit > 0) { switch (this.SqlMode) { case SqlModes.MySql: case SqlModes.PostgreSql: // Nada. Se hace con LIMIT x OFFSET y break; case SqlModes.Ansi: // Nada. Se hace con OFFSET x FETCH y break; default: Command.Append("ROW_NUMBER() OVER (ORDER BY key ASC) AS window_function_rownum, "); break; } } Command.Append(Fields); if (Tables != null && Tables.Length > 0) { string[] TableList = Tables.Split(','); if (TableList.Length == 1) { //Single table Command.Append(" FROM " + Tables); } else { Command.Append(" FROM " + TableList[0]); } foreach (Join Jo in Joins) { Command.Append(Jo.ToString()); } } if (WhereClause != null) { string WhereString = WhereClause.ToString(m_Mode); if (WhereString.Length > 0) { Command.Append(" WHERE " + WhereString); } } if (Group != null && Group.Length > 0) { Command.Append(" GROUP BY " + Group); } if (HavingClause != null) { string HavingString = HavingClause.ToString(m_Mode); if (HavingString.Length > 0) { Command.Append(" HAVING " + HavingString); } } if (Order != null && Order.Length > 0) { Command.Append(" ORDER BY " + Order); } if (this.Window != null && this.Window.Limit > 0) { switch (this.SqlMode) { case SqlModes.MySql: case SqlModes.PostgreSql: case SqlModes.SQLite: // TODO: Postgre desde la versión 9 permite el estándar ANSI SQL:2008 (OFFSET x FETCH y ONLY) Command.Append(" LIMIT " + this.Window.Limit.ToString()); if (this.Window.Offset > 0) { Command.Append(" OFFSET " + this.Window.Offset.ToString()); } break; case SqlModes.Ansi: // Estándar ANSI SQL:2008 if (this.Window.Offset > 0) { Command.Append(" OFFSET " + this.Window.Offset.ToString()); } Command.Append(" FETCH " + this.Window.Limit.ToString() + " ONLY"); break; case SqlModes.Oracle: // Casi lo mismo que el estándar, pero sin AS ... ya que Oracle no soporta ni requiere etiquetar las subconsultas Command.Insert(0, "SELECT * FROM ("); Command.Append(") WHERE window_function_rownum>" + this.Window.Limit.ToString()); if (this.Window.Offset > 0) { Command.Append(" AND window_function_rownum <=(" + this.Window.Offset.ToString() + "+" + this.Window.Limit.ToString() + ")"); } break; default: Command.Insert(0, "SELECT * FROM ("); Command.Append(") AS window_function WHERE window_function_rownum>" + this.Window.Limit.ToString()); if (this.Window.Offset > 0) { Command.Append(" AND window_function_rownum <=(" + this.Window.Offset.ToString() + "+" + this.Window.Limit.ToString() + ")"); } break; } } if (this.ForUpdate) { Command.Append(" FOR UPDATE"); } return(Command.ToString()); }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(EngineUriLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.Uri = jsonObject.Uri; }
public override void SimulateUpdateAlways() { if (StatMaster.isClient) { return; } if (Key25.IsPressed && 自动索敌.IsActive) { currentLocking = MyTargetSelector(); LockingTimer = currentLocking ? 0 : -1; } //烧坏 if (HasBurnedOut && !StatMaster.GodTools.UnbreakableMode) { currentLocking = null; LockingTimer = -1; currentTarget = null; } if (自动索敌.IsActive) { return; } //鼠标瞄准模式 if (模式.Value == 1 && !聪明模式.IsActive) { AcquireTarget(Camera.main.ScreenPointToRay(Input.mousePosition)); } //按键瞄准模式 if (Key1.IsPressed && !HasBurnedOut && 模式.Value == 0) { AcquireTarget(Camera.main.ScreenPointToRay(Input.mousePosition)); } //按键瞄准模式-取消 if (Key2.IsPressed && 模式.Value == 0) { currentLocking = null; LockingTimer = -1; currentTarget = null; } //后坐力 if (VisualController == null) { return; } if (VisualController.Block == null) { return; } if (VisualController.Block.jointsToMe == null) { return; } foreach (Joint Jo in VisualController.Block.jointsToMe) { if (VisualController == null) { return; } if (VisualController.Block == null) { return; } if (VisualController.Block.jointsToMe == null) { return; } if (Jo.GetComponentInParent <CanonBlock>()) { CanonBlock cb = Jo.GetComponentInParent <CanonBlock>(); cb.knockbackSpeed = 8000 * ((100 - KnockBackStablizierAdjuster.Value) / 100); cb.randomDelay = 0.000001f; shoott = StatMaster.isMP ? shoott : Input.GetMouseButtonDown(0); if (FireOnMouseClick.IsActive && 模式.Value == 1 && shoott) { cb.Shoot(); } } } shoott = false; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(BoardLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.Board = jsonObject.Board; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(RootLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(YoutubeLink result, Jo jsonObject) { result.YoutubeId = jsonObject.YoutubeId; }
/// <summary> /// Заполнить значения. /// </summary> /// <param name="result">Результат.</param> /// <param name="jsonObject">JSON-объект.</param> protected override void FillValues(CatalogLink result, Jo jsonObject) { result.Engine = jsonObject.Engine; result.Board = jsonObject.Board; result.SortMode = (BoardCatalogSort)jsonObject.Sort; }