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