| | |
|---|
| | | throw new NotImplementedException(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public IEnumerable<Model.OA_GoodsInfo> SelectModelPage(Pagination pa, Guid FirmId, string GoodsName, string CommodityName) |
|---|
| | | public IEnumerable<Model.OA_GoodsInfo> SelectModelPage(Pagination pa, Guid FirmId, string GoodsName, string CommodityName ,string selGoodsStatus) |
|---|
| | | { |
|---|
| | | |
|---|
| | | string Condition = " where a.FirmId='" + FirmId + "' "; |
|---|
| | |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(CommodityName)) |
|---|
| | | { |
|---|
| | | Condition += " and e.CommodityName like '%" + CommodityName + "%' "; |
|---|
| | | Condition += " and a.GoodsTypeId = " + CommodityName + " "; |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(selGoodsStatus)) |
|---|
| | | { |
|---|
| | | Condition += " and a.StatusId = " + selGoodsStatus + " "; |
|---|
| | | } |
|---|
| | | string selTarget = "a.* ,b.Name AS brandName,c.Name as SpecificationName,d.Name as StatusName,e.CommodityName as CommodityName"; |
|---|
| | | |
|---|
