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