public ModelResponse GetModelResponse(string CustSN)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
logger.DebugFormat("BEGIN: {0}(CustSN:{1})", methodName, CustSN);
try
{
//1.检查传进来的参数
Execute.ValidateParameter(CustSN);
//2.获取DB中的数据
ModelResponse modelReponse = Execute.modelResponseMsg(CustSN);
logger.DebugFormat("Reponse data:{0}", modelReponse.ToString());
return modelReponse;
}
catch (Exception e)
{
logger.Error(e.Message, e);
ModelResponse modelReponse = new ModelResponse();
modelReponse.CustSN = CustSN;
modelReponse.ProductID = "";
modelReponse.Model = "";
modelReponse.Family = "";
modelReponse.Customer = "";
modelReponse.ErrorCode = -2;
modelReponse.Message = e.Message;
logger.DebugFormat("Reponse data:{0}", modelReponse.ToString());
return modelReponse;
}
finally
{
logger.DebugFormat("END: {0}()", methodName);
}
}
public static ModelResponse GetModelByCustSN(string sn)
{
string sqlStr = @"select top 1 a.ProductID,a.CUSTSN,a.Model,b.Family,c.CustomerID
from Product a, Model b ,Family c
where a.Model = b.Model and c.Family=b.Family
and (a.CUSTSN =@SN or a.ProductID =@SN)
order by a.Cdt";
DataTable dtcust = SqlHelper.ExecuteDataTable(HistoryDBName, System.Data.CommandType.Text, sqlStr,
new SqlParameter("@SN", sn));
if (dtcust == null || dtcust.Rows.Count == 0)
{
ModelResponse modelResponse = new ModelResponse();
modelResponse.ProductID = "";
modelResponse.CustSN = sn;
modelResponse.Model = "";
modelResponse.Family = "";
modelResponse.Customer = "";
modelResponse.ErrorCode = -1;
modelResponse.Message = "The CustSN: " + sn + " is not exist in DB!";
return modelResponse;
}
else
{
return ToModelResponse(dtcust.Rows[0]);
}
}
private static ModelResponse ToModelResponse(DataRow row)
{
ModelResponse modelResponse = new ModelResponse();
modelResponse.CustSN = (string)row["CustSN"];
modelResponse.ProductID = (string)row["ProductID"];
modelResponse.Model = (string)row["Model"];
modelResponse.Family = (string)row["Family"];
modelResponse.Customer = (string)row["CustomerID"];
modelResponse.ErrorCode = 0;
modelResponse.Message = "";
return modelResponse;
}
