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