public MoQueryResponse MoQuery(MoQuery moquery) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); string msgName = "MOQuery"; string responseMsg = "MOQueryResponse"; try { WS.Common.SQL.InsertTxnDataLog(EnumMsgCategory.Receive, msgName, string.IsNullOrEmpty(moquery.MoNumber) ? "" : moquery.MoNumber, "", "", "", "", EnumMsgState.Received, ""); Execute.ValidateParameter(moquery); //Execute.BuildResponseMsg(moquery.MoNumber); //4.Build Response Message MoQueryResponse moresponse = Execute.BuildResponseMsg(moquery.MoNumber); WS.Common.SQL.InsertTxnDataLog(EnumMsgCategory.Send, responseMsg, string.IsNullOrEmpty( moquery.MoNumber)? "":moquery.MoNumber , moresponse.Result, "", "", "", EnumMsgState.Success, moresponse.HoldResult); return moresponse; } catch (Exception e) { logger.Error(MethodBase.GetCurrentMethod(), e); // UTL.SendMail("test", e.Message); //4.Build Response Error Message MoQueryResponse moresponse = new MoQueryResponse() { MoNumber = moquery.MoNumber, HoldResult = "N", Result = "NotFound" }; WS.Common.SQL.InsertTxnDataLog(EnumMsgCategory.Send, responseMsg, string.IsNullOrEmpty( moquery.MoNumber)? "":moquery.MoNumber , "NotFound", "", "", e.Message, EnumMsgState.Fail, "N"); return moresponse; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public static MoQueryResponse GetMoInfo(string monumber) { string strSQL = "select [Status],IsHold from MOStatus where MO=@MO"; DataTable dt= SQLHelper.ExecuteDataFill(SQLHelper.ConnectionString_CFG(), System.Data.CommandType.Text, strSQL, SQLHelper.CreateSqlParameter("@MO", 20, monumber.Trim())); MoQueryResponse moresponse = new MoQueryResponse(); if (dt.Rows.Count == 0) { moresponse.HoldResult=""; moresponse.Result = "NotFound"; moresponse.MoNumber = monumber; } else { moresponse.HoldResult =dt.Rows[0]["IsHold"].ToString().Trim(); moresponse.Result = dt.Rows[0]["Status"].ToString().Trim(); moresponse.MoNumber = monumber; } return moresponse; }