/// <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, "操作失败"))); }