protected void ttbDeviceName_TextChanged(object sender, EventArgs e) { try { // 清除資料與使用者介面 ClearField(); // 取得輸入的料號 string sDeviceName = ttbDeviceName.Text.Trim(); #region 輸入料號客製屬性檢查 var deviceVersionInfo = DeviceVersionInfo.GetActiveDeviceVersion(sDeviceName); if (deviceVersionInfo == null) { throw new CimesException(TextMessage.Error.T00030(lblDeviceName.Text, sDeviceName)); } // 檢查生產型態系統屬性是否有設定 var prodTypeAttr = deviceVersionInfo["PRODTYPE"].ToString(); if (prodTypeAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sDeviceName, "PRODTYPE")); } _ProdType = prodTypeAttr; // 檢查包裝方式系統屬性是否有設定 var packTypeAttr = deviceVersionInfo["PACKTYPE"].ToString(); if (packTypeAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sDeviceName, "PACKTYPE")); } _PackType = packTypeAttr; // 檢查包裝滿箱數量是否有設定 var maxPackSizeAttr = deviceVersionInfo["MAX_PACK_SIZE"].ToString(); if (maxPackSizeAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sDeviceName, "MAX_PACK_SIZE")); } #endregion string relativeDeviceAttr = ""; // 包裝方式為Mix(左右手)須設定與檢查對應料號 if (packTypeAttr == "Mix") { // 若設定為混合,則滿箱數必須為雙數 //if (maxPackSizeAttr.ToDecimal() % 2 != 0) //{ // throw new CimesException(RuleMessage.Error.C10036(sDeviceName, maxPackSizeAttr.ToString())); //} // 檢查對應料號系統屬性是否有設定 relativeDeviceAttr = deviceVersionInfo["RELATIVE_DEVICE"].ToCimesString(); if (relativeDeviceAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(relativeDeviceAttr, "RELATIVE_DEVICE")); } #region 應檢查 string sRelativeDeviceName = relativeDeviceAttr; _RelativeDeviceName = sRelativeDeviceName; // 檢查對應的料號是否存在 var relativeDeviceIfno = DeviceVersionInfo.GetActiveDeviceVersion(sRelativeDeviceName); if (relativeDeviceIfno == null) { throw new CimesException(RuleMessage.Error.C10037(sDeviceName, sRelativeDeviceName)); } // 檢查對應的料號生產型態系統屬性是否有設定 var relativeProdTypeAttr = relativeDeviceIfno["PRODTYPE"].ToString(); if (relativeProdTypeAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sRelativeDeviceName, "PRODTYPE")); } // 檢查對應的料號包裝方式系統屬性是否有設定 var relativePackTypeAttr = relativeDeviceIfno["PACKTYPE"].ToString(); if (relativePackTypeAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sRelativeDeviceName, "PACKTYPE")); } // 檢查對應的料號包裝滿箱數量是否有設定 var relativeMaxPackSizeAttr = relativeDeviceIfno["MAX_PACK_SIZE"].ToString(); if (relativeMaxPackSizeAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sRelativeDeviceName, "MAX_PACK_SIZE")); } // 檢查對應的料號對應料號系統屬性 var relativeRelativeDeviceAttr = relativeDeviceIfno["RELATIVE_DEVICE"].ToString(); if (relativeRelativeDeviceAttr.IsNullOrEmpty()) { throw new CimesException(TextMessage.Error.T00541(sRelativeDeviceName, "RELATIVE_DEVICE")); } // 檢查輸入料號與對應料號生產型態是否相同 if (prodTypeAttr != relativeProdTypeAttr) { throw new CimesException(RuleMessage.Error.C10038(sDeviceName, "PRODTYPE", prodTypeAttr, sRelativeDeviceName, "PRODTYPE", relativeProdTypeAttr)); } // 檢查輸入料號與對應料號包裝方式是否相同 if (packTypeAttr != relativePackTypeAttr) { throw new CimesException(RuleMessage.Error.C10038(sDeviceName, "PACKTYPE", packTypeAttr, sRelativeDeviceName, "PACKTYPE", relativePackTypeAttr)); } // 檢查輸入料號與對應料號滿箱數量是否相同 if (maxPackSizeAttr != relativeMaxPackSizeAttr) { throw new CimesException(RuleMessage.Error.C10038(sDeviceName, "MAX_PACK_SIZE", maxPackSizeAttr, sRelativeDeviceName, "MAX_PACK_SIZE", relativeMaxPackSizeAttr)); } // 檢查輸入料號與對應料號[對應料號]是否相同 if (relativeRelativeDeviceAttr != sDeviceName) { throw new CimesException(RuleMessage.Error.C10039(sRelativeDeviceName, "RELATIVE_DEVICE", relativeRelativeDeviceAttr, sDeviceName)); } #endregion // 只有在包裝方式為Mix(左右手)才顯示右邊表格 gvRelativeWorkpiece.Visible = true; } else { // 包裝方式非Mix(左右手)不顯示右邊表格 gvRelativeWorkpiece.Visible = false; } // 顯示包裝方式 ttbPackType.Text = GetUIResource(packTypeAttr); // 顯示滿箱數量 ttbMaxPackSize.Text = maxPackSizeAttr.ToDecimal().ToString(); // 顯示對應料號 ttbRelativeDevice.Text = relativeDeviceAttr == null ? "" : relativeDeviceAttr; _DeviceName = sDeviceName; // 取得班別資料 _StartTime = DBCenter.GetSystemTime(); var shiftData = CustomizeFunction.GetUserShifeData(_StartTime, false); _ShiftDate = shiftData.First; _Shift = shiftData.Second; AjaxFocus(ttbWorkpiece); } catch (Exception ex) { HandleError(ex, ttbDeviceName.ClientID); } }
private void LoadDeviceControl() { ttbDeviceFilter.Text = ttbDeviceFilter.Text.Trim(); ddlDevice.Items.Clear(); DeviceVersionInfo device = null; if (ttbDeviceFilter.Text.IsNullOrTrimEmpty() == false) { device = DeviceVersionInfo.GetActiveDeviceVersion(ttbDeviceFilter.Text); } if (device != null) { ddlProduct.Items.Clear(); ddlProduct.Items.Insert(0, new ListItem(device.ProductName, device.ProductName)); ddlDevice.Items.Add(new ListItem(device.DeviceName, device.DeviceName)); ddlDevice_SelectedIndexChanged(ddlDevice, EventArgs.Empty); } else { if (ddlProduct.SelectedItem.Text.IsNullOrTrimEmpty() == true) { return; } List <string> paras = new List <string>(); sql = @"SELECT {0} FROM MES_PRC_DEVICE_VER V WHERE V.REVSTATE = 'ACTIVE' AND V.PRODUCT = #[STRING] "; paras.Add(ddlProduct.SelectedItem.Value); if (ttbDeviceFilter.Text.IsNullOrTrimEmpty() == false) { sql += " AND V.DEVICE LIKE #[STRING] "; paras.Add(ttbDeviceFilter.Text + "%"); } //sql += " ORDER BY V.DEVICE"; if (DBCenter.GetSingleResult <int>(string.Format(sql, "COUNT(V.DEVICE)"), paras.ToArray()) > maxReturnQty) { ddlDevice.Items.Add(new ListItem(GetUIResource("InputRequired", lblDevice.Text), string.Empty)); } else { List <DeviceVersionInfo> DeviceList = InfoCenter.GetList <DeviceVersionInfo>(string.Format(sql + " ORDER BY V.DEVICE", "V.DEVICE"), paras.ToArray()); ddlDevice.DataSource = DeviceList; ddlDevice.DataTextField = "DeviceName"; ddlDevice.DataValueField = "DeviceName"; ddlDevice.DataBind(); if (DeviceList.Count == 0) { ddlDevice.Items.Add(new ListItem(TextMessage.Error.T00550(""), string.Empty)); } if (DeviceList.Count == 1) { ddlDevice_SelectedIndexChanged(ddlDevice, EventArgs.Empty); } if (DeviceList.Count > 1) { ddlDevice.Items.Insert(0, ""); } } } }
/// <summary> /// 切換料號 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ddlDevice_SelectedIndexChanged(object sender, EventArgs e) { try { #region 清除資料 ddlFileName.Items.Clear(); ddlPPKReasonCode.Items.Clear(); _CSTWIPCMMList = new List <CSTWIPCMMInfo>(); _QCInspectionObjDataList.Clear(); gvQC.SetDataSource(_QCInspectionObjDataList, true); _CSTWIPCMMDataList = new List <CSTWIPCMMDataInfo>(); gvInspectionData.SetDataSource(_CSTWIPCMMDataList, true); btnOK.Enabled = false; #endregion //確認是否有選擇料號 if (ddlDevice.SelectedItem.Text.IsNullOrTrimEmpty() == false) { //取得料號名稱 string deviceName = ddlDevice.SelectedItem.Text; //清除檢驗清單 _QCInspectionObjDataList.Clear(); List <QCInspectionObjectInfoEx> QCInspectionObjDataListTemp = new List <QCInspectionObjectInfoEx>(); _QCInspectionDataList.ForEach(QCData => { //符合所選的料號才可以加入序號清單 if (QCData.DeviceName == deviceName) { var selectDataList = QCInspectionObjectInfoEx.GetDataListByQCInspectionSID(QCData.QC_INSP_SID); QCInspectionObjDataListTemp.AddRange(selectDataList); } }); //以SID排序 _QCInspectionObjDataList = QCInspectionObjDataListTemp.OrderBy(p => p.ID).ToList(); #region 檢驗資料 //確認料號資料是否在在 _DeviceVersionData = DeviceVersionInfo.GetActiveDeviceVersion(deviceName).ChangeTo <DeviceVersionInfoEx>(); if (_DeviceVersionData == null) { //[00030]{0}:{1}不存在! throw new Exception(TextMessage.Error.T00030(lblDevice.Text, deviceName)); } //清除資料 _CSTWIPCMMList.Clear(); if (_DeviceVersionData.ProdType == CustomizeFunction.ProdType.S.ToCimesString()) { _QCInspectionObjDataList.ForEach(data => { //以機台名稱檢查是否有檢驗結果資料 var CSTWIPCMMListByEquipment = CSTWIPCMMInfo.GetDataListByEquipmantAndFileIDAndDevice(ttbEquip.Text, data.ItemName1, data.ItemName2, data.ItemName3, deviceName); //以OP1機台名稱檢查是否有檢驗結果資料 var CSTWIPCMMListBySEquipment = CSTWIPCMMInfo.GetDataListByEquipmantAndFileIDAndDevice(data.ItemName5, data.ItemName1, data.ItemName2, data.ItemName3, deviceName); //將二組資料合併,去除重覆資料 CSTWIPCMMListBySEquipment.ForEach(WIPCMMdata => { if (CSTWIPCMMListByEquipment.Contains(WIPCMMdata) == false) { CSTWIPCMMListByEquipment.Add(WIPCMMdata); } }); if (CSTWIPCMMListByEquipment.Count == 0) { //PPK 檢驗工件未到齊,無法執行 PPK 判定! throw new Exception(RuleMessage.Error.C10118()); } //再將找到的資料合併,去除重覆資料 CSTWIPCMMListByEquipment.ForEach(WIPCMMdata => { //將[QC_INSP_SID]寫到每一筆檢驗機台資料 WIPCMMdata.QCInspectionSID = data.QC_INSP_SID; if (_CSTWIPCMMList.Contains(WIPCMMdata) == false) { _CSTWIPCMMList.Add(WIPCMMdata); } }); }); } else { //以機台名稱檢查是否有檢驗結果資料 var CSTWIPCMMListByEquipment = CSTWIPCMMInfo.GetDataListByEquipmantAndDevice(ttbEquip.Text, deviceName); if (CSTWIPCMMListByEquipment.Count == 0) { //PPK 檢驗工件未到齊,無法執行 PPK 判定! throw new Exception(RuleMessage.Error.C10118()); } _QCInspectionObjDataList.ForEach(data => { //以OP1機台名稱檢查是否有檢驗結果資料 var CSTWIPCMMListBySEquipment = CSTWIPCMMInfo.GetDataListByEquipmantAndDevice(data.ItemName5, deviceName); //將二組資料合併,去除重覆資料 CSTWIPCMMListBySEquipment.ForEach(WIPCMMdata => { if (CSTWIPCMMListByEquipment.Contains(WIPCMMdata) == false) { CSTWIPCMMListByEquipment.Add(WIPCMMdata); } }); }); //重新依據[FILEID], [SN], [SEQUENCE]執行排序 _CSTWIPCMMList = CSTWIPCMMListByEquipment.OrderBy(data => data.FileID).ThenBy(data => data["SN"]).ToList(); #region 確認檢驗結果主檔筆數是否與檢驗單明細筆數相同 List <NoSNData> NoSNDataList = new List <NoSNData>(); _CSTWIPCMMList.ForEach(data => { NoSNData tempNoSNData = new NoSNData(); tempNoSNData.SN = data["SN"].ToCimesString(); tempNoSNData.FileID = data.FileID; if (NoSNDataList.Contains(tempNoSNData) == false) { NoSNDataList.Add(tempNoSNData); } }); //比對檢驗結果主檔筆數是否與檢驗單明細筆數相同 if (NoSNDataList.Count != _QCInspectionObjDataList.Count) { //檢驗結果主檔筆數({0})與檢驗單明細筆數({1})不相同 throw new Exception(RuleMessage.Error.C10112(NoSNDataList.Count().ToString(), _QCInspectionObjDataList.Count.ToString())); } #endregion for (int i = 0; i < NoSNDataList.Count; i++) { string QCInspectionSID = _QCInspectionObjDataList[i].QC_INSP_OBJ_SID; _CSTWIPCMMList.ForEach(data => { if (data.FileID == NoSNDataList[i].FileID && data["SN"].ToCimesString() == NoSNDataList[i].SN) { //將[QC_INSP_SID]寫到每一筆檢驗機台資料 data.QCInspectionSID = QCInspectionSID; } }); } } //加入機台檢驗檔名稱 _CSTWIPCMMList.ForEach(WIPCMMdata => { ddlFileName.Items.Add(new ListItem(WIPCMMdata["FILENAME"].ToString(), WIPCMMdata.ID)); }); if (ddlFileName.Items.Count > 0) { ddlFileName.Items.Insert(0, ""); } gvQC.SetDataSource(_QCInspectionObjDataList, true); #endregion #region 設置原因碼 //清除原因碼資料 ddlPPKReasonCode.Items.Clear(); rdbNG.Enabled = false; rdbOK.Enabled = false; rdbNG.Enabled = true; rdbOK.Enabled = true; //取得原因碼清單 List <BusinessReason> reason = ReasonCategoryInfo.GetOperationRuleCategoryReasonsWithReasonDescr(ProgramRight, "ALL", "Default", ReasonMode.Category); if (reason.Count > 0) { ddlPPKReasonCode.DataSource = reason; ddlPPKReasonCode.DataTextField = "ReasonDescription"; ddlPPKReasonCode.DataValueField = "ReasonCategorySID"; ddlPPKReasonCode.DataBind(); if (ddlPPKReasonCode.Items.Count != 1) { ddlPPKReasonCode.Items.Insert(0, ""); } else { ddlPPKReasonCode.SelectedIndex = 0; } } else { //[00641]規則:{0} 工作站:{1} 使用的原因碼未設定,請洽IT人員! throw new Exception(TextMessage.Error.T00641(ProgramRight, "ALL")); } #endregion btnOK.Enabled = true; } } catch (Exception ex) { //清除資料 ddlFileName.Items.Clear(); ddlPPKReasonCode.Items.Clear(); _CSTWIPCMMList = new List <CSTWIPCMMInfo>(); _QCInspectionObjDataList.Clear(); gvQC.SetDataSource(_QCInspectionObjDataList, true); _CSTWIPCMMDataList = new List <CSTWIPCMMDataInfo>(); gvInspectionData.SetDataSource(_CSTWIPCMMDataList, true); btnOK.Enabled = false; AjaxFocus(ddlDevice); HandleError(ex); } }