public VWInquiryProductEntity GetVWInquiryProduct(int id) { string sql = @"SELECT [Id],[InquiryOrderCode],[ProductCode],[ClassesId],[ClassesName],ProductId,[ProductName],[ProductNum],[ProductUnitName],[Remark] FROM dbo.[InquiryProduct] WITH(NOLOCK) WHERE [Id]=@id" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, id); VWInquiryProductEntity entity = new VWInquiryProductEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.InquiryOrderCode = StringUtils.GetDbString(reader["InquiryOrderCode"]); entity.ProductCode = StringUtils.GetDbString(reader["ProductCode"]); entity.ClassesId = StringUtils.GetDbInt(reader["ClassesId"]); entity.ClassesName = StringUtils.GetDbString(reader["ClassesName"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.ProductNum = StringUtils.GetDbInt(reader["ProductNum"]); entity.ProductUnitName = StringUtils.GetDbString(reader["ProductUnitName"]); entity.Remark = StringUtils.GetDbString(reader["Remark"]); } } return(entity); }
public VWInquiryProductEntity GetVWInquiryProduct(int id, bool cache) { VWInquiryProductEntity vwproduct = InquiryProductDA.Instance.GetVWInquiryProduct(id); if (vwproduct != null && vwproduct.Id > 0) { vwproduct.ProductSubList = InquiryProductSubBLL.Instance.GetInquiryProductSubAll(vwproduct.InquiryOrderCode, vwproduct.ProductId, false); } return(vwproduct); }
/// <summary> /// 根据询价订单产品明细查找 /// </summary> /// <returns></returns> public string GetProductAndSub() { ResultObj result = new ResultObj(); string _code = FormString.SafeQ("code"); int _orderproid = FormString.IntSafeQ("orderproid"); VWInquiryProductEntity vwproduct = InquiryProductBLL.Instance.GetVWInquiryProduct(_orderproid, false); if (vwproduct != null && vwproduct.Id > 0) { result.Status = (int)CommonStatus.Success; result.Obj = vwproduct; } else { result.Status = (int)CommonStatus.Fail; result.Obj = _orderproid; } return(JsonJC.ObjectToJson(result)); }