using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IBaseDAL;
|
using CY.Model;
|
using CY.Infrastructure.Query;
|
using CY.Model.Inquiry;
|
|
namespace CY.IDAL.Inquiry
|
{
|
/// <summary>
|
/// 纸张相关数据库操作接口
|
/// </summary>
|
public interface IPaperInfoDAL : ICommonDAL
|
{
|
/// <summary>
|
/// 分页获取纸张列表
|
/// </summary>
|
/// <param name="paperName">品牌名称</param>
|
/// <param name="pa">分页参数</param>
|
/// <returns></returns>
|
IEnumerable<SysInquiry_PaperInfo> GetPaperListByPaging(string paperName,int paperTypeId,string status, Pagination pa);
|
|
/// <summary>
|
/// 获取纸张类型下的所有有效纸张
|
/// </summary>
|
/// <param name="paperTypeId"></param>
|
/// <returns></returns>
|
IEnumerable<SysInquiry_PaperInfo> GetPaperListByPaperType(int paperTypeId);
|
|
/// <summary>
|
/// 根据paperId获取纸张信息
|
/// </summary>
|
/// <param name="paperId"></param>
|
/// <returns></returns>
|
IEnumerable<SysInquiry_PaperInfo> GetPaperList(int paperId);
|
|
/// <summary>
|
/// 根据paperId获取其对应的品牌列表
|
/// </summary>
|
/// <param name="paperId"></param>
|
/// <returns></returns>
|
IEnumerable<SysInquiry_BrandInfo> GetBrandInfoListByPaper(int paperId);
|
|
/// <summary>
|
/// 判断是否有相同的纸扎名称
|
/// </summary>
|
/// <param name="brandName"></param>
|
/// <returns></returns>
|
bool IsExistspeperName(string peperName);
|
|
/// <summary>
|
/// 获取最新的纸张编号
|
/// </summary>
|
/// <returns></returns>
|
int GetNewPaperId();
|
|
/// <summary>
|
/// 新增纸张
|
/// </summary>
|
/// <param name="modelList"></param>
|
/// <returns></returns>
|
bool InsertPaper(IList<SysInquiry_PaperInfo> modelList,IList<SysInquiry_BrandListByPaper> brandList);
|
|
/// <summary>
|
/// 修改纸张
|
/// </summary>
|
/// <param name="modelList"></param>
|
/// <returns></returns>
|
bool UpdatePaper(IList<SysInquiry_PaperInfo> modelList, IList<SysInquiry_BrandListByPaper> brandList);
|
|
/// <summary>
|
/// 获取有效的纸张列表(不包括自带纸)
|
/// </summary>
|
/// <returns></returns>
|
IEnumerable<SysInquiry_PaperInfo> GetPaperList();
|
/// <summary>
|
/// 获取有效的纸张列表(包括自带纸)
|
/// </summary>
|
/// <returns></returns>
|
IEnumerable<SysInquiry_PaperInfo> GetAllPaperList();
|
|
/// <summary>
|
/// 根据纸张Id和品牌ID获取纸价列表
|
/// </summary>
|
/// <param name="paperId"></param>
|
/// <param name="firmId"></param>
|
/// <param name="customerId"></param>
|
/// <returns></returns>
|
IEnumerable<Inquiry_PaperPriceInfo> GetAllPaperPriceList(int paperId, int brandId, Guid inquiryId);
|
|
/// <summary>
|
/// 根据纸张Id和品牌ID保存纸价
|
/// </summary>
|
/// <param name="modelList"></param>
|
/// <returns></returns>
|
bool SavePaperPrice(List<Inquiry_PaperPriceInfo> modelList, InquiryCondition inquiryCondition);
|
|
/// <summary>
|
/// 获取纸张的吨价
|
/// </summary>
|
/// <param name="paperId"></param>
|
/// <param name="gramWeight"></param>
|
/// <param name="brandId"></param>
|
/// <returns></returns>
|
decimal GetTonsOfPrice(int paperId, int gramWeight, int brandId, Guid inquiryId);
|
|
/// <summary>
|
/// 获取纸张的品牌列表，第一个是默认品牌
|
/// </summary>
|
/// <param name="paperId"></param>
|
/// <returns></returns>
|
IList<SysInquiry_BrandInfo> GetBrandInfoByPaper(int paperId);
|
|
/// <summary>
|
/// 获取最新排序顺序
|
/// </summary>
|
/// <returns></returns>
|
int GetOrderNumByMax(int paperTypeId);
|
}
|
}
|
