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