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