/// <summary>
/// 新增、修改外部注册接口参数
/// </summary>
/// <returns></returns>
public bool EditInterfaceParam(InterfaceParam param)
{
try
{
using (var db = new DbContext())
{
if (string.IsNullOrEmpty(param.id))
{
return(db.Insert(param).Execute() > 0);
}
return(db.Update(param).Execute() > 0);
}
}
catch (Exception ex)
{
Logger.Instance.Error("编辑外部接口参数时发生异常：", ex);
return(false);
}
}
// public override bool UploadTestResult(string SerialNumber, string Model, string TesterID, UInt16 errorcode, string SocketId, string TestResult, string TestStation, string MFI_ID
//)
// {
// SqlConnection Con;
// string adoCon;
// string adoConEncrypted;
// string sql;
// string site;
// int IntErrorCdoe = errorcode;
// SocketId = SocketId + "Socket#";
// if (!IsValidSerialNumber("UploadTestResult " + GetType().ToString(), SerialNumber))
// {
// return false;
// }
// try
// {
//#if SAVE_AdoCon_In_AppSettings
// site = ConfigurationManager.AppSettings["Site"];
// //MessageBox.Show(site);
// adoConEncrypted = ConfigurationManager.AppSettings["AdoCon"]
//#else
// site = CyBLE_MTK_Application.Properties.Settings.Default.Site;
// adoConEncrypted = CyBLE_MTK_Application.Properties.Settings.Default.AdoCon;
//#endif
// adoCon = StrOperator.Decrypt(adoConEncrypted);
// //MessageBox.Show(adoCon);
// Con = new SqlConnection(adoCon);
// Con.Open();
// sql = "INSERT INTO if_check(if_site,if_barcode,if_result,if_mfi_id) VALUES (@Site,@BarCode,@Result,@MFiID)";
// SqlCommand sqlCmd = new SqlCommand(sql, Con);
// sqlCmd.Parameters.AddWithValue("@Site", site);
// sqlCmd.Parameters.AddWithValue("@BarCode", SerialNumber);
// sqlCmd.Parameters.AddWithValue("@Result", IntErrorCdoe);
// sqlCmd.Parameters.AddWithValue("@MFiID", MFI_ID);
// sqlCmd.ExecuteNonQuery();
// Con.Close();
// return true;
// }
// catch (Exception ex)
// {
// LastError = "Failed to connect log server. (" + ex.Message + ")";
// MessageBox.Show(LastError, "Shopfloor error");
// }
// return false;
// }
public override bool UploadTestResult(string SerialNumber, string Model, string TesterID, UInt16 errorcode, string SocketId, string TestResult, string TestStation, string MFI_ID
)
{
int res = -1;
try
{
Fittec.InterfaceParam interfaceParam = new InterfaceParam();
Fittec.MesInterface mesInterface = new Fittec.MesInterface();
interfaceParam.BatchTestRunCycleTime = double.Parse(CyBLE_MTK.TestProgramRunCycleTimeForBatch);
interfaceParam.SerialNumber = SerialNumber;
interfaceParam.ModelName = Model;
interfaceParam.MTK_App = Assembly.GetExecutingAssembly().GetName().Name.ToString() + " v" + Assembly.GetExecutingAssembly().GetName().Version.ToString();
interfaceParam.OverallTestResult = TestResult;
interfaceParam.TestErrorCode = errorcode.ToString("X4");
interfaceParam.TestSocketNo = int.Parse(SocketId);
interfaceParam.TestXMLFileName = CyBLE_MTK.CurrentTestXMLFile;
interfaceParam.SFCS_Entity = this.GetType().Name;
interfaceParam.Remarks = "";
interfaceParam.MFi_ID = "";
//Log.PrintLog(this, String.Format(this.GetType().Name + " MES Interface {0}: UploadTestResult ==>DUT#({5}) SN: {1} Model: {2} OverallTestResult: {3} ErrorCode: {4}",
// mesInterface.MyVersion(), interfaceParam.SerialNumber, interfaceParam.ModelName, interfaceParam.OverallTestResult, interfaceParam.TestErrorCode, interfaceParam.TestSocketNo
// ), LogDetailLevel.LogRelevant);
try
{
res = mesInterface.MESDataUpload(interfaceParam);
}
catch (Exception ex)
{
Log.PrintLog(this, String.Format(this.GetType().Name + " MESDataUpload Error: UploadTestResult ==>DUT#({0}) SN: {1} Failure due to {2}",
SocketId.ToString(), SerialNumber, ex.Message
), LogDetailLevel.LogRelevant);
}
if (res == 0)
{
Log.PrintLog(this, String.Format("MES Interface (ver: {0}): UploadTestResult (Successful:{6}) ==>DUT#({5}) SN: {1} Model: {2} OverallTestResult: {3} ErrorCode: {4}.",
mesInterface.MyVersion(), interfaceParam.SerialNumber, interfaceParam.ModelName, interfaceParam.OverallTestResult, interfaceParam.TestErrorCode, interfaceParam.TestSocketNo, res
), LogDetailLevel.LogRelevant);
}
else if (res == 404)
{
Log.PrintLog(this, String.Format("MES Interface (ver: {0}): UploadTestResult (Failure:{6}) ==>DUT#({5}) SN: {1} Model: {2} OverallTestResult: {3} ErrorCode: {4}.",
mesInterface.MyVersion(), interfaceParam.SerialNumber, interfaceParam.ModelName, interfaceParam.OverallTestResult, interfaceParam.TestErrorCode, interfaceParam.TestSocketNo, res
), LogDetailLevel.LogRelevant);
MessageBox.Show(String.Format("MES Interface (ver: {0}): UploadTestResult (Failure:{6}) ==>DUT#({5}) SN: {1} Model: {2} OverallTestResult: {3} ErrorCode: {4}. 该条测试记录上传MES失败，请停止测试，联系工程师检查系统工作状态！",
mesInterface.MyVersion(), interfaceParam.SerialNumber, interfaceParam.ModelName, interfaceParam.OverallTestResult, interfaceParam.TestErrorCode, interfaceParam.TestSocketNo, res
), "MESUploadResult Error");
}
else
{
Log.PrintLog(this, String.Format("MES Interface (ver: {0}): UploadTestResult (Failure:{6}) ==>DUT#({5}) SN: {1} Model: {2} OverallTestResult: {3} ErrorCode: {4}.",
mesInterface.MyVersion(), interfaceParam.SerialNumber, interfaceParam.ModelName, interfaceParam.OverallTestResult, interfaceParam.TestErrorCode, interfaceParam.TestSocketNo, res
), LogDetailLevel.LogRelevant);
}
}
catch (Exception ex)
{
Log.PrintLog(this, String.Format("MES Interface: UploadTestResult ==>DUT#({0}) SN: {1} Failure due to {2}",
SocketId.ToString(), SerialNumber, ex.Message
), LogDetailLevel.LogRelevant);
MessageBox.Show(String.Format("MES Interface: UploadTestResult ==>DUT#({0}) SN: {1} Failure due to {2} 该条测试记录上传MES失败，请停止测试，联系工程师检查系统工作状态！",
SocketId.ToString(), SerialNumber, ex.Message), "MESUploadResult Error");
}
return(false);
}
/// <summary>
/// 新增、修改外部注册接口参数
/// </summary>
/// <returns></returns>
public Task <ResponseModel> EditInterfaceParam(InterfaceParam param)
{
return(Logic.EditInterfaceParam(param) ?
Task.FromResult(new ResponseModel(ResponseCode.Success, "操作成功"))
: Task.FromResult(new ResponseModel(ResponseCode.Error, "操作失败")));
}
