public override void Update(AdjType r)
{
try
{
string sql = String.Format("update {0}.ADJ_TYPE set "
+ " ADJ_TYPE = :ADJ_TYPE "
+ " ,APPLY_AFTER_FINAL_COST = :APPLY_AFTER_FINAL_COST "
+ " ,DESCR = :DESCR "
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":ADJ_TYPE", CheckNull(r.ADJ_TYPE), OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":APPLY_AFTER_FINAL_COST", (r.APPLY_AFTER_FINAL_COST == true) ? 'Y' : 'N', OracleType.Char, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":DESCR", CheckNull(r.DESCR), OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
r.Modified = false;
}
catch (OracleException ex)
{
throw ex;
}
catch (Exception x)
{
throw x;
}
}
public void OnChanged(List <IListenerTracker> trackers)
{
if (trackers[3].OnGetCurrentTransform().name.ToLower().Equals("is"))
{
trackers.Sort((p, q) => q.GetViewportPos().x.CompareTo(p.GetViewportPos().x));
}
if (trackers[2].OnGetChildTransform() == null || trackers[3].OnGetCurrentTransform().GetComponent <WordTrackableEventHandler>().wordType != WordType.adj)
{
return;
}
point = CombineControl.Instance.GetPoint();
question = CombineControl.Instance.GetQuestion();
parent = trackers[trackers.Count - 1].OnGetCurrentTransform();
mountPoint = parent.Find("MountPoint");
if (mountPoint == null)
{
GameObject tempGo = new GameObject("MountPoint");
mountPoint = tempGo.transform;
mountPoint.SetParent(parent);
}
//设置mountPoint的位置
mountPoint.transform.localPosition = new Vector3(2f, 0, 0);
mountPoint.transform.localRotation = Quaternion.Euler(Vector3.zero);
OnMarked(mountPoint);
SoundPlay(trackers);
string sub = trackers[3].OnGetCurrentTransform().name.ToUpper();
AdjType adj = (AdjType)Enum.Parse(typeof(AdjType), sub);
model = trackers[2].OnGetChildTransform().gameObject;
if (!model.activeSelf)
{
model.SetActive(true);
}
OnStatusChange(model, adj);
}
protected override void RowConverter(AdjType r, DataRow record)
{
try
{
r.ADJ_TYPE = CastDbValueRow(record, "ADJ_TYPE");
r.DESCR = CastDbValueRow(record, "DESCR");
r.APPLY_AFTER_FINAL_COST = CastDbValueRow(record, "APPLY_AFTER_FINAL_COST", true, "Bool");
r.Modified = false;
}
catch (Exception ex)
{
throw ex;
}
}
public override void Remove(AdjType package)
{
string sql;
try
{
sql = String.Format("DELETE FROM {0}.ADJ_TYPE WHERE "
+ " ADJ_TYPE = :ADJ_TYPE"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":ADJ_TYPE", package.ADJ_TYPE, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
package.Modified = false;
}
catch (OracleException ex)
{
throw ex;
}
}
public virtual ReturnMessageClass GetData()
{
ReturnMessageClass msg = new ReturnMessageClass(MessageDisplay.MSG_NO_DATA);
msg.Status = ResultStatus.Fail;
Dt = Dao.GetData(TxtDate, AsAdjType, AdjType.SubStr(1, 1));
//無資料時return fail (不產檔)
if (Dt != null)
{
if (Dt.Rows.Count > 0)
{
msg.Status = ResultStatus.Success;
}
}
Dt.Filter("ab_type in ('A','-')");
return(msg);
}
public override ReturnMessageClass GetData()
{
ReturnMessageClass msg = new ReturnMessageClass(MessageDisplay.MSG_NO_DATA);
Dt = Dao.GetData(TxtDate, AsAdjType, AdjType.SubStr(1, 1));
//一般 / 股票 要多撈一次資料
if (AdjType == "0B")
{
DataTable dtTmp = Dao.GetData(TxtDate, "3", AdjType.SubStr(1, 1));
if (dtTmp != null)
{
if (dtTmp.Rows.Count > 0)
{
foreach (DataRow r in dtTmp.Rows)
{
DataRow addRow = r;
Dt.ImportRow(r);
}
}
}
}
if (Dt == null)
{
msg.Status = ResultStatus.Fail;
return(msg);
}
if (Dt.Rows.Count <= 0)
{
msg.Status = ResultStatus.Fail;
return(msg);
}
msg.Status = ResultStatus.Success;
return(msg);
}
public override AdjType Get(AdjType entity)
{
throw new NotImplementedException();
}
private void OnStatusChange(GameObject obj, AdjType type)
{
WordTrackableEventHandler track = obj.transform.parent.GetComponent <WordTrackableEventHandler>();
switch (type)
{
case AdjType.BIG:
ChangeScale(obj, 1.5f);
resetValue = 1f / 1.5f;
break;
case AdjType.LITTLE:
ChangeScale(obj, 1f / 1.5f);
resetValue = 1.5f;
break;
case AdjType.RED:
track.ChangeColor(Color.red);
break;
case AdjType.YELLOW:
track.ChangeColor(Color.yellow);
break;
case AdjType.BLUE:
track.ChangeColor(Color.blue);
break;
case AdjType.GREEN:
track.ChangeColor(Color.green);
break;
case AdjType.BLACK:
track.ChangeColor(Color.black);
break;
case AdjType.BLOND:
track.ChangeColor(Tips.blond);
break;
case AdjType.BROWN:
track.ChangeColor(Tips.brown);
break;
case AdjType.PINK:
track.ChangeColor(Tips.pink);
break;
case AdjType.SILVER:
track.ChangeColor(Tips.silver);
break;
case AdjType.PURPLE:
track.ChangeColor(Tips.purple);
break;
case AdjType.WHITE:
track.ChangeColor(Color.white);
break;
case AdjType.GREY:
track.ChangeColor(Color.grey);
break;
default:
break;
}
}
