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