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