public static CSTToolTypePictureInfo GetDataByFileName(string fileName) { string sSQL = @" SELECT * FROM CST_TOOL_TYPE_PICT WHERE FILENAME = #[STRING] "; return(InfoCenter.GetBySQL <CSTToolTypePictureInfo>(sSQL, fileName)); }
/// <summary> /// 依據機台簡碼來取得機台資訊 /// </summary> /// <param name="equipmentCode"></param> /// <returns></returns> public static EquipmentInfoEx GetDataByEquipmentCode(string equipmentCode) { string sSQL = @"SELECT * FROM MES_EQP_EQP WHERE CODE = #[STRING]"; return(InfoCenter.GetBySQL <EquipmentInfoEx>(sSQL, equipmentCode)); }
/// <summary> /// 依照輸入LotID取得相關欄位資料及相關Button設定 /// </summary> /// <param name="LotID">批號名稱</param> private void LoadControlByLot(string LotID) { // 清除欄位資訊 ClearField(); var lsLotData = LotInfoEx.GetLotByLot(LotID).ChangeTo <LotInfoEx>(); //若在製找不到,換到MES_WIP_LOT_NONACTIVE找 if (lsLotData == null) { string sql = @"SELECT * FROM MES_WIP_LOT_NONACTIVE WHERE LOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, LotID); lsLotData = InfoCenter.GetBySQL <LotInfoEx>(sa); } // 若該批號無資料可顯示,離開程式並顯示訊息 if (lsLotData == null) { btnPrint.Enabled = false; throw new Exception(TextMessage.Error.T00060(LotID)); } btnPrint.Enabled = true; lotData = lsLotData; }
/************************以上FUNCTION, INDEX 已確認,新增FUNCTION請往下新增**************************/ public static CSTToolDeviceDetailInfo GetDataListByDeviceAndEquipmantNameAndToolType(string deviceName, string equipmentName, string toolType) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE_DETAIL WHERE DEVICE = #[STRING] AND EQP = #[STRING] AND TOOLTYPE = #[STRING]"; return(InfoCenter.GetBySQL <CSTToolDeviceDetailInfo>(sSQL, deviceName, equipmentName, toolType)); }
public static CSTWIPDefectJudgementInfo GetDataByWIPDefectSID(string WIPDefectSID) { string sSQL = @" SELECT * FROM CST_WIP_DEFECT_JUDGEMENT WHERE WIP_DEFECT_SID = #[STRING]"; return(InfoCenter.GetBySQL <CSTWIPDefectJudgementInfo>(sSQL, WIPDefectSID)); }
public static CSTWIPDefectJudgementInfo GetDataByLot(string lot) { string sSQL = @" SELECT * FROM CST_WIP_DEFECT_JUDGEMENT WHERE LOT = #[STRING] ORDER BY WIP_DEFECT_JUDGEMENT_SID"; return(InfoCenter.GetBySQL <CSTWIPDefectJudgementInfo>(sSQL, lot)); }
public static EquipGroupEquipInfoEx GetEquipGroupByEquipmentName(string equipmentName) { string sSQL = @"SELECT * FROM MES_EQP_GROUP_EQP WHERE EQUIPMENT = #[STRING]"; return(InfoCenter.GetBySQL <EquipGroupEquipInfoEx>(sSQL, equipmentName)); }
/************************以上FUNCTION, INDEX 已確認,新增FUNCTION請往下新增**************************/ public static CSTAPIEAPServerInfo GetDataByEAPNameAndLine(string EAPName, string line) { string sSQL = @" SELECT * FROM CST_API_EAP_SERVER WHERE EAP_NAME = #[STRING] AND LINE = #[STRING]"; return(InfoCenter.GetBySQL <CSTAPIEAPServerInfo>(sSQL, EAPName, line)); }
/// <summary> /// 取得最新建立的SID資料 /// </summary> /// <returns></returns> public static ComponentInfoEx GetDataByLatestSID() { string sql = @"SELECT * FROM MES_WIP_COMP WHERE CPF_SN IS NOT NULL ORDER BY WIP_COMP_SID DESC"; SqlAgent sa = SQLCenter.Parse(sql); return(InfoCenter.GetBySQL <ComponentInfoEx>(sa)); }
public static CSTToolRepairInfo GetDataByToolName(string toolName) { string sSQL = @"SELECT * FROM CST_TOOL_REPAIR WHERE TOOLNAME =#[STRING] AND ACTUAL_DATE_OF_RETURN IS NULL"; return(InfoCenter.GetBySQL <CSTToolRepairInfo>(sSQL, toolName)); }
public static LotDefectInfoEx GetDataByLotAndComponentID(string lot, string componentID) { string sql = @"SELECT * FROM MES_WIP_DEFECT WHERE LOT = #[STRING] AND COMPONENTID = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, lot, componentID); return(InfoCenter.GetBySQL <LotDefectInfoEx>(sa)); }
public static CSTCMSCarProcessInfo GetDataByLine(string line) { string sSQL = @"SELECT * FROM CST_CMS_CAR_PROCESS WHERE LINE = #[STRING] ORDER BY UPDATETIME DESC"; return(InfoCenter.GetBySQL <CSTCMSCarProcessInfo>(sSQL, line)); }
public static CSTCMSCarProcessInfo GetDataByLoadLotFlagIsY(string line, string carSequence) { string sSQL = @"SELECT * FROM CST_CMS_CAR_PROCESS WHERE LOADLOT_FLAG = 'Y' AND LINE = #[STRING] AND CAR_SEQ = #[STRING] ORDER BY UPDATETIME DESC"; return(InfoCenter.GetBySQL <CSTCMSCarProcessInfo>(sSQL, line, carSequence)); }
public static MaterialLotInfoEx GetDataByMaterialNo(string materialNo) { string sql = @"SELECT * FROM MES_MMS_MLOT WHERE MATERIALNO = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, materialNo); return(InfoCenter.GetBySQL <MaterialLotInfoEx>(sa)); }
public static MaterialLotComponentInfoEx GetMLotDataByComponentID(string componentID) { string sql = @"SELECT * FROM MES_MMS_COMP WHERE COMPONENTID = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, componentID); return(InfoCenter.GetBySQL <MaterialLotComponentInfoEx>(sa)); }
/// <summary> /// 依據傳入location及CPF_SN參數取得資料 /// </summary> /// <param name="location"></param> /// <param name="CPF_SN"></param> /// <returns></returns> public static ComponentInfoEx GetDataByLocationAndCPFSN(string location, string CPF_SN) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE LOCATION = #[STRING] AND CPF_SN = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, location, CPF_SN); return(InfoCenter.GetBySQL <ComponentInfoEx>(sa)); }
/************************以上FUNCTION, INDEX 已確認,新增FUNCTION請往下新增**************************/ public static CSTWorkOrderLotInfo GetWorkOrderLotDataByWOLotAndMLotOrInvLot(string workOrderLot, string MLotOrInvLot) { string sSQL = @" SELECT * FROM CST_WPC_WO_LOT WHERE WOLOT = #[STRING] AND (INVLOT = #[STRING] OR MATERIALLOT = #[STRING])"; return(InfoCenter.GetBySQL <CSTWorkOrderLotInfo>(sSQL, workOrderLot, MLotOrInvLot, MLotOrInvLot)); }
/// <summary> /// 依據傳入CPF_SN參數及FORGING_FLAG=Y取得資料 /// </summary> /// <param name="location"></param> /// <param name="CPF_SN"></param> /// <returns></returns> public static ComponentInfoEx GetDataByCPFSN(string CPF_SN) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE FORGING_FLAG = 'Y' AND CPF_SN = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, CPF_SN); return(InfoCenter.GetBySQL <ComponentInfoEx>(sa)); }
public static QCInspectionInfoEx GetCPFQCDataByObjectName(string objectName) { string sql = @"SELECT * FROM MES_QC_INSP INNER JOIN MES_QC_INSP_OBJ ON (MES_QC_INSP.QC_INSP_SID = MES_QC_INSP_OBJ.QC_INSP_SID) WHERE OBJECTNAME=#[STRING] AND STATUS='WaitQC' AND CREATEUSER='******' ORDER BY MES_QC_INSP.QC_INSP_SID DESC"; SqlAgent sa = SQLCenter.Parse(sql, objectName); return(InfoCenter.GetBySQL <QCInspectionInfoEx>(sa)); }
public static ComponentInfoEx GetOneComponentByDMCCode(string dmcCode) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE DMC = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, dmcCode); return(InfoCenter.GetBySQL <ComponentInfoEx>(sa)); }
public static LotInfoEx GetLotByLot(string lot) { lot = CustomizeFunction.ConvertDMCCode(lot); string sql = @"SELECT * FROM MES_WIP_LOT WHERE LOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, lot); return(InfoCenter.GetBySQL <LotInfoEx>(sa)); }
public static CSTUserWorkTimeInfo GetUserWorkTimeByWOAndUserIDAndWorkPlace(string lot, string workUserID, string userWorkPlace) { if (userWorkPlace.IsNullOrTrimEmpty()) { return(InfoCenter.GetBySQL <CSTUserWorkTimeInfo>("SELECT * FROM CST_USR_WORKTIME WHERE LOT = #[STRING] AND WORKUSERID = #[STRING] AND ENDTIME IS NULL", lot, workUserID)); } else { return(InfoCenter.GetBySQL <CSTUserWorkTimeInfo>("SELECT * FROM CST_USR_WORKTIME WHERE LOT = #[STRING] AND WORKUSERID = #[STRING] AND USR_WORKPALCE = #[STRING] AND ENDTIME IS NULL", lot, workUserID, userWorkPlace)); } }
public static ComponentInfoEx GetComponentByComponentID(string componentID) { componentID = CustomizeFunction.ConvertDMCCode(componentID); string sql = @"SELECT * FROM MES_WIP_COMP WHERE COMPONENTID = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, componentID); return(InfoCenter.GetBySQL <ComponentInfoEx>(sa)); }
public static QCInspectionInfoEx GetInspDataListByEquipmentAndLot(string equipment, string lot) { string sql = @"SELECT * FROM MES_QC_INSP INNER JOIN MES_QC_INSP_OBJ ON MES_QC_INSP.QC_INSP_SID = MES_QC_INSP_OBJ.QC_INSP_SID WHERE MES_QC_INSP.EQUIPMENT = #[STRING] AND MES_QC_INSP_OBJ.OBJECTNAME = #[STRING] AND MES_QC_INSP.QCTYPE = 'FAI' AND MES_QC_INSP.RESULT IS NULL"; return(InfoCenter.GetBySQL <QCInspectionInfoEx>(sql, equipment, lot)); }
/// <summary> /// 依據傳入Location及SNFlag參數取得第一筆SN的資料 /// </summary> /// <param name="location">鍛造的位置</param> /// <param name="SNFlag">鍛造紀錄是否有領過序號</param> /// <returns></returns> public static ComponentInfoEx GetDataByLocationAndSNFlag(string location, string SNFlag) { string sql = @"SELECT * FROM ( SELECT * FROM MES_WIP_COMP WHERE LOCATION = #[STRING] AND SNFLAG = #[STRING] AND FORGING_FLAG = 'Y' ORDER BY CAST(SN AS INT) ASC) MWC WHERE ROWNUM < 2"; SqlAgent sa = SQLCenter.Parse(sql, location, SNFlag); return(InfoCenter.GetBySQL <ComponentInfoEx>(sa)); }
/// <summary> /// 依照輸入LotID取得相關欄位資料及相關Button設定 /// </summary> /// <param name="LotID">批號名稱</param> private void LoadControlByLot(string LotID) { // 清除欄位資訊 ClearField(); // 一定在MES_WIP_LOT_NONACTIVE因為已經入庫 var lsLotData = InfoCenter.GetBySQL <LotInfoEx>("SELECT * FROM MES_WIP_LOT_NONACTIVE WHERE LOT = #[STRING]", LotID); if (lsLotData == null) { lsLotData = InfoCenter.GetBySQL <LotInfoEx>("SELECT * FROM MES_WIP_LOT_NONACTIVE WHERE INVNO = #[STRING]", LotID); } // 若該批號無資料可顯示,離開程式並顯示訊息 if (lsLotData == null) { btnPrint.Enabled = false; throw new Exception(TextMessage.Error.T00060(LotID)); } btnPrint.Enabled = true; lotData = lsLotData; }
/// <summary> /// 取得IQCInfo資料經由爐號+批號+進料日當關鍵值 /// </summary> /// <param name="iqcRunID"></param> /// <param name="iqcLot"></param> /// <param name="iqcTime"></param> /// <returns></returns> public static CSTMMSIqcInfo GetIQCInfoData(string iqcRunID, string iqcLot, string iqcTime) { string sSQL = @" SELECT * FROM CST_MMS_IQC_INFO WHERE RUNID = #[STRING] AND LOT = #[STRING] AND IQCTIME = #[STRING] "; return(InfoCenter.GetBySQL <CSTMMSIqcInfo>(sSQL, iqcRunID, iqcLot, iqcTime)); }
public static CSTPrcLineInfo GetLineInfoByLine(string line) { return(InfoCenter.GetBySQL <CSTPrcLineInfo>("SELECT * FROM CST_PRC_LINE WHERE LINE = #[STRING]", line)); }
public static CSTWIPPackInfo GetPackInfoByBoxNo(string boxNo) { string sSQL = @"SELECT * FROM CST_WIP_PACK WHERE BOXNO = #[STRING] "; return(InfoCenter.GetBySQL <CSTWIPPackInfo>(sSQL, boxNo)); }
public static CSTEquipmentDeviceReleaseInfo GetDataByEquipmentAndDevice(string equipment, string device) { return(InfoCenter.GetBySQL <CSTEquipmentDeviceReleaseInfo>("SELECT * FROM CST_EQP_DEVICE_RELEASE WHERE EQUIP = #[STRING] AND DEVICE = #[STRING]", equipment, device)); }