private void QueryData() { //若有輸入查詢條件,且使用Like方式Query資料 sql = "SELECT * FROM MES_TOOL_TYPE WHERE TOOLCLASS = 'CUTTER' "; if (ttbToolType.Text.Trim() != "") { sql += " AND UPPER(TYPE) LIKE UPPER(#[STRING]) ORDER BY TYPE"; ToolTypeList = InfoCenter.GetList <ToolTypeInfo>(sql, ttbToolType.Text.Trim() + "%"); } else { sql += " ORDER BY TYPE"; ToolTypeList = InfoCenter.GetList <ToolTypeInfo>(sql); } if (ToolTypeList.Count == 0) //資料找不到 { gvQuery.SetDataSource(null, true); throw new Exception(TextMessage.Error.T00060("")); } gvQuery.SetDataSource(ToolTypeList, true); gvQuery.EditItemIndex = -1; gvQuery.CurrentPageIndex = 0; uscAttributeSetupGrid.ClearField(); }
public static List <EquipGroupEquipInfoEx> GetEquipGroupByGroupSID(string groupSID) { string sSQL = @"SELECT * FROM MES_EQP_GROUP_EQP WHERE EQP_GROUP_SID = #[STRING]"; return(InfoCenter.GetList <EquipGroupEquipInfoEx>(sSQL, groupSID)); }
public static List <OperationResourceInfoEx> GetDataByOperSID(string operSID) { string sSQL = @"SELECT * FROM MES_PRC_OPER_RESO WHERE PRC_OPER_SID = #[STRING]"; return(InfoCenter.GetList <OperationResourceInfoEx>(sSQL, operSID)); }
public static List <CSTToolDeviceDetailInfo> GetDataListByToolDeviceSID(string toolDeviceSID) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE_DETAIL WHERE TOOL_DEVICE_SID = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceDetailInfo>(sSQL, toolDeviceSID)); }
/// <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)); }
public static List <CSTWIPCMMDataInfo> GetDataByWIPCMMSID(string WIPCMMSID) { string sSQL = @" SELECT * FROM CST_WIP_CMM_DATA WHERE WIP_CMM_SID = #[STRING]"; return(InfoCenter.GetList <CSTWIPCMMDataInfo>(sSQL, WIPCMMSID)); }
public static List <CSTToolDeviceDetailInfo> GetDataListByDeviceAndEquipmantName(string deviceName, string equipmentName) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE_DETAIL WHERE DEVICE = #[STRING] AND EQP = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceDetailInfo>(sSQL, deviceName, equipmentName)); }
/// <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)); }
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="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); }
public static List <CSTToolDeviceInfo> GetDataListByEquipmentName(string equipmentName) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE WHERE EQP = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceInfo>(sSQL, equipmentName)); }
public static List <CSTToolDeviceInfo> GetDataListByDeviceName(string deviceName) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE WHERE DEVICE = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceInfo>(sSQL, deviceName)); }
private void LoadEquipGroupControl() { EquipmentGroupInfo equipGroup = null; ddlEquipGroup.Items.Clear(); ttbEquipGroupFilter.Text = ttbEquipGroupFilter.Text.Trim(); if (ttbEquipGroupFilter.Text.IsNullOrTrimEmpty() == false) { equipGroup = EquipmentGroupInfo.GetEquipmentGroupByName(ttbEquipGroupFilter.Text); } if (equipGroup != null) { ddlEquipGroup.Items.Add(new ListItem(equipGroup.GroupName, equipGroup.ID)); ddlEquipGroup_SelectedIndexChanged(ddlEquipGroup, EventArgs.Empty); } else { List <string> pars = new List <string>(); sql = @" SELECT {0} FROM MES_EQP_GROUP P"; if (ttbEquipGroupFilter.Text.IsNullOrTrimEmpty() == false) { sql += @" WHERE P.GROUPNAME LIKE #[STRING]"; pars.Add(ttbEquipGroupFilter.Text + "%"); } //取得機台群組 if (DBCenter.GetSingleResult <int>(string.Format(sql, "COUNT(P.GROUPNAME)"), pars.ToArray()) > maxReturnQty) { ddlEquipGroup.Items.Add(new ListItem(GetUIResource("InputRequired", lblEquipment.Text), string.Empty)); } else { List <EquipmentGroupInfo> equipGroupList = InfoCenter.GetList <EquipmentGroupInfo>(string.Format(sql + " ORDER BY P.GROUPNAME ", "P.GROUPNAME, P.EQP_GROUP_SID"), pars.ToArray()); ddlEquipGroup.DataSource = equipGroupList; ddlEquipGroup.DataTextField = "GroupName"; ddlEquipGroup.DataValueField = "EquipmentGroupSID"; ddlEquipGroup.DataBind(); if (equipGroupList.Count == 0) { ddlEquipGroup.Items.Add(new ListItem(TextMessage.Error.T00550(""), string.Empty)); } if (equipGroupList.Count == 1) { ddlEquipGroup_SelectedIndexChanged(ddlEquipGroup, EventArgs.Empty); } if (equipGroupList.Count > 1) { ddlEquipGroup.Items.Insert(0, ""); } } } }
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)); }
/// <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 List <CSTToolTypePictureInfo> GetDataListByToolType(string toolType) { string sSQL = @" SELECT * FROM CST_TOOL_TYPE_PICT WHERE TOOLTYPE = #[STRING] ORDER BY FILENAME"; return(InfoCenter.GetList <CSTToolTypePictureInfo>(sSQL, toolType)); }
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 <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 <CSTWipAssemblyFileInfo> GetAssemblyFile(string equipment, string location) { string sSQL = @" SELECT * FROM CST_WIP_ASSEMBLY_FILE WHERE EQUIPMENT = #[STRING] AND LOCATION = #[STRING] "; return(InfoCenter.GetList <CSTWipAssemblyFileInfo>(sSQL, equipment, location)); }
public static List <CSTToolTypeLifeInfo> GetDataListByToolType(string toolType) { string sSQL = @" SELECT * FROM CST_TOOL_TYPE_LIFE WHERE TOOLTYPE = #[STRING] ORDER BY SUPPLIER"; return(InfoCenter.GetList <CSTToolTypeLifeInfo>(sSQL, toolType)); }
public static List <QCInspectionInfoEx> GetInspDataListByEquipmentAndDevice(string equipment, string device) { string sql = @"SELECT * FROM MES_QC_INSP WHERE EQUIPMENT = #[STRING] AND DEVICE = #[STRING] AND QCTYPE IN ('FAI', 'PQC') ORDER BY CREATETIME DESC"; return(InfoCenter.GetList <QCInspectionInfoEx>(sql, equipment, device)); }
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)); }
public static List <CSTWIPReserveCheckInInfo> GetDataByLotAndOper(string lot, string operation) { string sSQL = @" SELECT * FROM CST_WIP_RESERVE_CHECKIN_INFO WHERE LOT = #[STRING] AND OPERATION = #[STRING] AND OUTTIME IS NULL ORDER BY INTIME DESC"; return(InfoCenter.GetList <CSTWIPReserveCheckInInfo>(sSQL, lot, operation)); }
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> 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)); }