/// <summary> /// 根據UDC09(出貨清單)查詢批號(箱號)清單 /// </summary> /// <param name="udc09"></param> /// <returns></returns> public static List <LotNonActiveInfoEx> GetLotListByUDC09(string udc09) { string sql = @"SELECT * FROM MES_WIP_LOT_NONACTIVE WHERE USERDEFINECOL09 = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, udc09); return(InfoCenter.GetList <LotNonActiveInfoEx>(sa)); }
protected void ttbEquipment_TextChanged(object sender, EventArgs e) { try { if (ttbEquipment.Text.Trim().IsNullOrTrimEmpty()) { return; } string sEquipment = ttbEquipment.Text.Trim(); _EquipmentInfo = EquipmentInfo.GetEquipmentByName(sEquipment); if (_EquipmentInfo == null) { ttbEquipment.Text = ""; AjaxFocus(ttbEquipment); throw new RuleCimesException(TextMessage.Error.T00030(lblEquipment.Text, sEquipment)); } ddlOperation.Items.Clear(); var lstOepration = DBCenter.GetStringList(SQLCenter.Parse( "SELECT DISTINCT OPERATION FROM CST_TOOL_DEVICE_DETAIL WHERE EQP=#[STRING] AND OPERATION IS NOT NULL", sEquipment)); lstOepration.ForEach(p => { ddlOperation.Items.Add(p); }); if (lstOepration.Count > 1) { ddlOperation.Items.Insert(0, ""); } } catch (Exception ex) { HandleError(ex); } }
/// <summary> /// 取得同小工單的COMPONENT /// </summary> /// <param name="WOLOT"></param> /// <returns></returns> public static List <ComponentInfoEx> GetAllComponentByWOLot(string woLot) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE WOLOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, woLot); return(InfoCenter.GetList <ComponentInfoEx>(sa)); }
/// <summary> /// 取的runcard的資料來源 /// </summary> /// <param name="LotDataList"></param> /// <returns></returns> private DataSet GetRunCardDataSource(LotInfoEx LotData) { string sql = @"SELECT * FROM MES_WIP_LOT_NONACTIVE WHERE INVNO = #[STRING]"; sql = string.Format(sql); SqlAgent sa = SQLCenter.Parse(sql, LotData.InventoryNo); var lsInvLot = InfoCenter.GetList <LotInfoEx>(sa); if (lsInvLot.Count == 0) { throw new Exception(TextMessage.Error.T00060("InventoryNO:" + LotData.InventoryNo)); } string sBoxInString = ""; lsInvLot.ForEach(p => { sBoxInString += "'" + p.Lot + "',"; }); sBoxInString = sBoxInString.EndsWith(",") ? sBoxInString.Substring(0, sBoxInString.Length - 1) : sBoxInString; var dtInvData = DBCenter.GetDataTable(@" SELECT WO,INVLOT,SUM(QUANTITY) QUANTITY,DEVICE FROM MES_WIP_LOT_NONACTIVE WHERE LOT IN ( SELECT CURRENTLOT FROM MES_WIP_COMP_NONACTIVE WHERE COMPONENTID IN ( SELECT COMPONENTID FROM CST_WIP_PACK INNER JOIN CST_WIP_PACK_DATA ON (CST_WIP_PACK.WIP_PACK_SID = CST_WIP_PACK_DATA.WIP_PACK_SID) WHERE BOXNO IN (" + sBoxInString + "))) GROUP BY WO,INVLOT,DEVICE"); dtInvData.TableName = "INVData"; #region 定義 LOTDATA 資料表 //DataTable dtInvData = lsInvLot.CopyDataToTable("INVData"); dtInvData.Columns.Add("INVDate"); dtInvData.Columns.Add("ITEM"); dtInvData.Columns.Add("DeviceDescr"); dtInvData.Columns.Add("Remark"); dtInvData.Columns.Add("Loaction"); dtInvData.Columns.Add("Factory"); #endregion for (int i = 0; i < dtInvData.Rows.Count; i++) { dtInvData.Rows[i]["INVDate"] = lsInvLot[0]["USERDEFINECOL17"].ToCimesString(); dtInvData.Rows[i]["ITEM"] = (i + 1).ToCimesString(); dtInvData.Rows[i]["Remark"] = lsInvLot[0]["USERDEFINECOL18"].ToCimesString(); dtInvData.Rows[i]["Loaction"] = lsInvLot[0]["LOCATION"].ToCimesString(); dtInvData.Rows[i]["Factory"] = lsInvLot[0]["FACTORY"].ToCimesString(); var DeviceData = DeviceVersionInfoEx.GetActiveDeviceVersion(dtInvData.Rows[i]["DEVICE"].ToString()).ChangeTo <DeviceVersionInfoEx>(); if (DeviceData != null) { dtInvData.Rows[i]["DeviceDescr"] = DeviceData.Description; } } DataSet dsReportData = new DataSet(); dsReportData.Tables.Add(dtInvData); return(dsReportData); }
/// <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; }
public static List <ToolTypeInfoEx> GetToolTypeByToolClass(string toolCalss) { string sql = @"SELECT * FROM MES_TOOL_TYPE WHERE TOOLCLASS = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, toolCalss); return(InfoCenter.GetList <ToolTypeInfoEx>(sa)); }
/// <summary> /// 型號類型: RUNCARD /// </summary> /// <param name="workOrderLot"></param> /// <returns></returns> public static List <ComponentNonactiveInfo> GetDataByWorkOrderLot(string workOrderLot) { string sql = @"SELECT * FROM MES_WIP_COMP_NONACTIVE WHERE WOLOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, workOrderLot); return(InfoCenter.GetList <ComponentNonactiveInfo>(sa)); }
/// <summary> /// 型號類型: LOT /// </summary> /// <param name="lot"></param> /// <returns></returns> public static List <ComponentNonactiveInfo> GetDataByMaterialLot(string materialLot) { string sql = @"SELECT * FROM MES_WIP_COMP_NONACTIVE WHERE MATERIALLOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, materialLot); return(InfoCenter.GetList <ComponentNonactiveInfo>(sa)); }
public static List <LotInfoEx> GetLotListByStatus(string status) { string sql = @"SELECT * FROM MES_WIP_LOT WHERE STATUS = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, status); return(InfoCenter.GetList <LotInfoEx>(sa)); }
public static List <LotInfoEx> GetLotListByInvertoryLot(string lot) { string sql = @"SELECT * FROM MES_WIP_LOT WHERE INVLOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, lot); return(InfoCenter.GetList <LotInfoEx>(sa)); }
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 List <ToolInfoEx> GetToolListByGroupID(string groupID) { string sql = @"SELECT * FROM MES_TOOL_MAST WHERE GROUPID = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, groupID); return(InfoCenter.GetList <ToolInfoEx>(sa)); }
public static List <QCInspectionObjectInfoEx> GetDataListByQCInspectionSID(string QCInspectionSID) { string sql = @"SELECT * FROM MES_QC_INSP_OBJ WHERE QC_INSP_SID = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, QCInspectionSID); return(InfoCenter.GetList <QCInspectionObjectInfoEx>(sa)); }
public static List <QCInspectionObjectInfoEx> GetDataListByComponentLot(string componentLot) { string sql = @"SELECT * FROM MES_QC_INSP_OBJ WHERE ITEM1 = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, componentLot); return(InfoCenter.GetList <QCInspectionObjectInfoEx>(sa)); }
public static List <QCInspectionInfoEx> GetDataListByBatchIDAndDeviceName(string batchID, string deviceName) { string sql = @"SELECT * FROM MES_QC_INSP WHERE BATCHID = #[STRING] AND DEVICE = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, batchID, deviceName); return(InfoCenter.GetList <QCInspectionInfoEx>(sa)); }
public static List <ComponentInfo> GetDataByCurrentLot(string lot) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE CURRENTLOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, lot); return(InfoCenter.GetList <ComponentInfo>(sa)); }
public static List <ComponentNonactiveInfoEx> GetDataByInvBoxNo(string workOrderLot) { string sql = @"SELECT * FROM MES_WIP_COMP_NONACTIVE WHERE CURRENTLOT IN (SELECT COMPONENTID FROM MES_WIP_COMP_NONACTIVE WHERE CURRENTLOT = #[STRING])"; SqlAgent sa = SQLCenter.Parse(sql, workOrderLot); return(InfoCenter.GetList <ComponentNonactiveInfoEx>(sa)); }
public static List <EquipmentMaterialLotInfoEx> GetEquipmentMaterialLotByMaterialLot(string materialLot) { string sql = @"SELECT * FROM MES_EQP_MLOT WHERE MLOT = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, materialLot); return(InfoCenter.GetList <EquipmentMaterialLotInfoEx>(sa)); }
public static List <QCInspectionInfoEx> GetDataListByEquip(string equip, string QCType) { string sql = @"SELECT * FROM MES_QC_INSP WHERE EQUIPMENT = #[STRING] AND QCTYPE = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, equip, QCType); return(InfoCenter.GetList <QCInspectionInfoEx>(sa)); }
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 List <MaterialLotInfoEx> GetMaterialLotByUserDefineCol02(string udc02) { string sql = @"SELECT * FROM MES_MMS_MLOT WHERE USERDEFINECOL02 = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, udc02); return(InfoCenter.GetList <MaterialLotInfoEx>(sa)); }
/// <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 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)); }
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 List <ToolInfoEx> GetToolByToolTypeAndVendor(string toolType, string vendor) { string sql = @"SELECT * FROM MES_TOOL_MAST WHERE TOOLTYPE = #[STRING] AND VENDOR = #[STRING] ORDER BY TOOLNAME"; SqlAgent sa = SQLCenter.Parse(sql, toolType, vendor); return(InfoCenter.GetList <ToolInfoEx>(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)); }
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 List <ComponentInfoEx> GetComponentListByComponentID(string componentID) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE COMPONENTID = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, componentID); return(InfoCenter.GetList <ComponentInfoEx>(sa)); }
/// <summary> /// 依據傳入檢驗單號取得資料 /// </summary> /// <param name="location"></param> /// <param name="CPF_SN"></param> /// <returns></returns> public static List <ComponentInfoEx> GetDataByInspectionNo(string inspectionNo) { string sql = @"SELECT * FROM MES_WIP_COMP WHERE INSPNO = #[STRING]"; SqlAgent sa = SQLCenter.Parse(sql, inspectionNo); return(InfoCenter.GetList <ComponentInfoEx>(sa)); }
/// <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)); }