/// <summary>
/// 執行刪除TPEM操作
/// </summary>
/// <param name="oFilter"></param>
/// <returns></returns>
ReturnValueInfo DeleteTPEMData(TransitionFilter oFilter)
{
ReturnValueInfo objReturn = new ReturnValueInfo();
StringBuilder strSql = new StringBuilder();
strSql.AppendLine(DeleteTPEMDataSQL(oFilter));
try
{
using (TPEMDBDataContext db = new TPEMDBDataContext())
{
int iDel = db.ExecuteCommand(strSql.ToString(), new object[] { });
objReturn.boolValue = true;
}
}
catch (Exception Ex)
{
objReturn.boolValue = false;
objReturn.isError = true;
objReturn.messageText = Ex.Message;
}
return objReturn;
}
/// <summary>
/// 獲取TPEM系統最大Seq
/// </summary>
/// <returns></returns>
int GetMaxSeq()
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("SELECT Max(jobt_iSeq) As MaxSeq From TPEMJOBT");
try
{
using (TPEMDBDataContext db = new TPEMDBDataContext())
{
var result = db.ExecuteQuery<int>(strSql.ToString(), new object[] { });
if (result != null)
{
List<int> objRet = result.ToList();
return objRet[0];
}
}
}
catch
{
return 0;
}
return 0;
}
/// <summary>
/// 根據傳入的Key 獲取TPEM系統機台速度1和速度2
/// </summary>
/// <param name="cMachineKey"></param>
/// <param name="iSpeed1"></param>
/// <param name="iSpeed2"></param>
/// <returns></returns>
bool GetTPEMAllMachine(TransitionFilter oFilter, ref Dictionary<string, decimal[]> dicSpeed)
{
bool retValue = false;
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("SELECT A.MCHN_CCODE As cMachineCode,A.MCHN_CNAME,B.DEPT_CNAME,A.MCHN_CLCT,A.MCHN_CGRP,");
strSql.AppendLine("CONVERT(char(10),A.MCHN_DTPEMDT,103),A.MCHN_CCAP,A.MCHN_fSpeed As fSpeed,A.MCHN_fSpeed2 As fSpeed2,A.MCHN_CCAT,");
strSql.AppendLine("CONVERT(char(11),A.MCHN_DADDDT,103)+RIGHT(CONVERT(char(20),A.MCHN_DADDDT,109),8)+' '+RIGHT(CONVERT(char(26),A.MCHN_DADDDT,109),2),");
strSql.AppendLine("A.MCHN_CADDBY,CONVERT(char(11),A.MCHN_DLASTDT,103)+RIGHT(CONVERT(char(20),A.MCHN_DLASTDT,109),8)+' '+RIGHT(CONVERT(char(26),A.MCHN_DLASTDT,109),2),");
strSql.AppendLine("A.MCHN_CLASTBY ");
strSql.AppendLine("FROM TPEMMCHN A ");
strSql.AppendLine("LEFT JOIN TPEMDEPT B ON A.MCHN_CDEPT=B.DEPT_CCODE ");
strSql.AppendLine("Where 1=1 And A.MCHN_CCAT<>'D-024'");
if (oFilter.cMachineList.Count > 0 && oFilter.cMachineFilter != string.Empty)
{
strSql.AppendLine("And mchn_ccode In(" + oFilter.cMachineFilter + ")");
}
using (TPEMDBDataContext db = new TPEMDBDataContext())
{
var result = db.ExecuteQuery<_TPEMMachineSpeed>(strSql.ToString(), new object[] { });
if (result != null)
{
List<_TPEMMachineSpeed> objRet = result.ToList();
foreach (_TPEMMachineSpeed objItem in objRet)
{
decimal[] speed = { objItem.fSpeed, objItem.fSpeed2 };
dicSpeed.Add(objItem.cMachineCode.ToString().Trim(), speed);
}
retValue = true;
}
}
return retValue;
}
