public MBInfoResponse GetMBInfo(string MessageID, string PCBNO, string Remark) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; logger.DebugFormat("BEGIN: {0}(SN:{1})", methodName, PCBNO); string txnId = DateTime.Now.ToString("yyyyMMddhhmmss.fff");//YT135AV try { //1.检查传进来的参数 Execute.ValidateParameter(PCBNO); //2.获取DB中的数据 MBInfoResponse mbinfo = Execute.GetMBInfoRFID(PCBNO); mbinfo.MessageID = txnId; logger.DebugFormat("Reponse data:{0}", mbinfo.ToString()); return mbinfo; } catch (Exception e) { logger.Error(e.Message, e); MBInfoResponse mbinfo = new MBInfoResponse(); mbinfo.MessageID = txnId; mbinfo.MBSN = PCBNO; mbinfo.Status = "F"; mbinfo.ErrorText = e.Message; mbinfo.Remark = ""; logger.DebugFormat("Reponse data:{0}", mbinfo.ToString()); return mbinfo; } finally { logger.DebugFormat("END: {0}()", methodName); } }
/// <summary> /// RFID 获取MB信息 /// </summary> /// <param name="PCBNO"></param> /// <returns></returns> public static MBInfoResponse GetMBInfoRFID(string PCBNO) { string sqlStr = @"SELECT a.PCBNo,a.PCBModelID,c.InfoValue AS MBCT,a.MAC,a.ECR,a.IECVER,b.Line FROM PCB a INNER JOIN dbo.PCBStatus b ON a.PCBNo=b.PCBNo AND a.PCBNo=@PCBNO LEFT JOIN PCBInfo c ON a.PCBNo=c.PCBNo AND c.InfoType='MBCT' "; DataTable dt = SqlHelper.ExecuteDataTable(System.Data.CommandType.Text, sqlStr, new SqlParameter("@PCBNO", PCBNO)); if (dt == null || dt.Rows.Count == 0) { MBInfoResponse mbinfo = new MBInfoResponse(); mbinfo.MBSN = PCBNO; mbinfo.MBPartNo = ""; mbinfo.MBCT = ""; mbinfo.MAC = ""; mbinfo.ECR = ""; mbinfo.Ver = ""; mbinfo.Pdline = ""; mbinfo.Status = "F"; mbinfo.ErrorText = "The PCBNO: " + PCBNO + " is not exist in DB!"; mbinfo.Remark = "The PCBNO: " + PCBNO + " is not exist in DB!"; return mbinfo; } else { MBInfoResponse mbinfo = new MBInfoResponse(); mbinfo.MBSN = PCBNO; mbinfo.MBPartNo =(string) dt.Rows[0]["PCBModelID"]; mbinfo.MBCT = (string)dt.Rows[0]["MBCT"]; mbinfo.MAC = (string)dt.Rows[0]["MAC"]; mbinfo.ECR = (string)dt.Rows[0]["ECR"]; mbinfo.Ver = (string)dt.Rows[0]["IECVER"]; mbinfo.Pdline = (string)dt.Rows[0]["Line"]; mbinfo.Status = "T"; mbinfo.ErrorText = ""; mbinfo.Remark = ""; return mbinfo; } }