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