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