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