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 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 EquipGroupEquipInfoEx GetEquipGroupByEquipmentName(string equipmentName) { string sSQL = @"SELECT * FROM MES_EQP_GROUP_EQP WHERE EQUIPMENT = #[STRING]"; return(InfoCenter.GetBySQL <EquipGroupEquipInfoEx>(sSQL, equipmentName)); }
/// <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)); }
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(); }
protected void btnAdd_Click(object sender, EventArgs e) { try { CurrentToolData = InfoCenter.Create <ToolInfoEx>(); ClearData(); EnableTab(); ddlState.ClearSelection(); var li = ddlState.Items.FindByText("IDLE"); if (li == null) { throw new CimesException(GetUIResource("ToolInitialStateUnSet")); } li.Selected = true; ToolAttributeSetup.BindData("ToolCutterAttribute", CurrentToolData.ID); PMCounterSetupInterface.BindUserControl(PMSType.ToolID, CurrentToolData.ID); //UserDefineColumnSet1.SetControl(BindType.Tool, null); btnSave.Visible = true; btnCancel.Visible = true; Action = "A"; } catch (Exception ex) { HandleError(ex); } }
/// <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> GetDataListByDeviceName(string deviceName) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE WHERE DEVICE = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceInfo>(sSQL, deviceName)); }
public static List <CSTToolDeviceInfo> GetDataListByEquipmentName(string equipmentName) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE WHERE EQP = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceInfo>(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)); }
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)); }
/************************以上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 List <CSTToolDeviceDetailInfo> GetDataListByToolDeviceSID(string toolDeviceSID) { string sSQL = @" SELECT * FROM CST_TOOL_DEVICE_DETAIL WHERE TOOL_DEVICE_SID = #[STRING]"; return(InfoCenter.GetList <CSTToolDeviceDetailInfo>(sSQL, toolDeviceSID)); }
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)); }
/// <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; }
/// <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)); }
public static CSTToolTypePictureInfo GetDataByFileName(string fileName) { string sSQL = @" SELECT * FROM CST_TOOL_TYPE_PICT WHERE FILENAME = #[STRING] "; return(InfoCenter.GetBySQL <CSTToolTypePictureInfo>(sSQL, fileName)); }
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 <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 <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 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 <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 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 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)); }
/// <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 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 <CSTToolTypePictureInfo> GetDataListByToolType(string toolType) { string sSQL = @" SELECT * FROM CST_TOOL_TYPE_PICT WHERE TOOLTYPE = #[STRING] ORDER BY FILENAME"; return(InfoCenter.GetList <CSTToolTypePictureInfo>(sSQL, toolType)); }