/// <summary>
/// 根据油漆PID获取油漆已配置城市
/// </summary>
/// <returns></returns>
public static IEnumerable <CityPaintModel> SelectPaintCityListByPid(string pid, int pkid)
{
DataTable resulTable = DalCityPaint.SelectPaintCityListByPid(pid, pkid);
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new CityPaintModel(dr)));
}
else
{
return(new CityPaintModel[0]);
}
}
/// <summary>
/// 获取已有油漆产品
/// </summary>
/// <returns></returns>
public static IEnumerable <PaintModel> SelectPaintList()
{
DataTable resulTable = DalCityPaint.SelectPaintList();
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new PaintModel(dr)));
}
else
{
return(new PaintModel[0]);
}
}
/// <summary>
/// 根据城市ID获取城市信息
/// </summary>
/// <returns></returns>
public static IEnumerable <RegionCityModel> SelectCityRegionList(string pkids)
{
DataTable resulTable = DalCityPaint.SelectCityRegionList(pkids);
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new RegionCityModel(dr)));
}
else
{
return(new RegionCityModel[0]);
}
}
/// 根据PID和城市ID获取油漆产品特殊价
public static IEnumerable <PaintInfoModel> GetCityPaintByPIDAndCityId(string pid, int cityId, int pkid)
{
DataTable resulTable = DalCityPaint.GetCityPaintByPIDAndCityId(pid, cityId, pkid);
if (resulTable != null && resulTable.Rows.Count > 0)
{
return(resulTable.Rows.Cast <DataRow>().Select(dr => new PaintInfoModel(dr)));
}
else
{
return(new PaintInfoModel[0]);
}
}
/// <summary>
/// 添加油漆产品全国价
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertCountryPaintModelModel(PaintInfoModel model)
{
var result = DalCityPaint.InsertCountryPaint(model);
return(result);
}
/// <summary>
/// 更新油漆产品全国价信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateCountryPaintModel(PaintInfoModel model)
{
return(DalCityPaint.UpdateCountryPaint(model));
}
/// 根据PID获取油漆产品全国价信息
public static PaintInfoModel GetCountryPaintByPID(string pid)
{
var dr = DalCityPaint.GetCountryPaintByPID(pid);
return(new PaintInfoModel(dr));
}
/// 根据PKID获取油漆产品全国价信息
public static PaintInfoModel GetCountryPaintByPKID(int pkid)
{
var dr = DalCityPaint.GetCountryPaintByPKID(pkid);
return(new PaintInfoModel(dr));
}
/// <summary>
/// 批量油漆产品特殊价关联城市
/// </summary>
/// <returns></returns>
public static bool BulkSaveCityPaint(DataTable dt)
{
var result = DalCityPaint.BulkSaveCityPaint(dt);
return(result);
}
/// <summary>
/// 根据PKIDs删除已关联城市
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static bool DeleteCityPaintByList(List <CityPaintModel> list)
{
return(DalCityPaint.DeleteCity(list));
}
/// <summary>
/// 根据PKID删除油漆产品特殊价
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public static bool DeleteCityPaintModelByPkid(int pkid)
{
return(DalCityPaint.DeleteCityPaintByPkid(pkid));
}