/// <summary>
/// 取得所有款式信息
/// </summary>
/// <returns></returns>
public static List <款式图片一览Dto> getStyleByIds(List <String> ids)
{
String sql = "SELECT\n" +
" SYS_STYLE_ID,\n"+
" CUSTOMER_COUNT_ID,\n"+
" STYLE_CD,\n"+
" STYLE_CATEGORY_CD,\n"+
" STYLE_DRESS_CATEGORY,\n"+
" STYLE_DESIGN_TYPE,\n"+
" STYLE_PUBLISH_CATEGORY_CD,\n"+
" REF_STYLE_ID,\n"+
" STYLE_NAME_CN,\n"+
" STYLE_NAME_EN,\n"+
" STYLE_FIT_CD,\n"+
" SYTLE_YEAR,\n"+
" SYTLE_SEASON,\n"+
" SYTLE_FABRIC_ID,\n"+
" STYLE_SIZE_GROUP_CD,\n"+
" STYLE_SIZE_CD,\n"+
" STYLE_MAKE_TYPE,\n"+
" STYLE_MATERIAL_NUMBER,\n"+
" STYLE_DESIGN_PRICE,\n"+
" CONCAT( 'https://sshirtmtmbucket.oss-cn-zhangjiakou.aliyuncs.com/sshirtmtm/', SUBSTRING_INDEX( COVER_PHOTO_PATH, '/',- 1 ) ) AS PIC_URL,\n"+
" SUBSTRING_INDEX( COVER_PHOTO_PATH, '/',- 1 ) AS PIC_NAME,\n"+
" ENABLE_FLAG,\n"+
" CREATE_DATE\n"+
"FROM\n" +
" v_style_p\n"+
" where v_style_p.SYS_STYLE_ID in ('" + String.Join("','", ids) + "')" +
" order by CREATE_DATE";
List <款式图片一览Dto> 款式图片一览Dtos = new List <款式图片一览Dto>();
DataTable dataTable = SQLmtm.GetDataTable(sql);
foreach (DataRow dataRow in dataTable.Rows)
{
款式图片一览Dto 款式图片一览Dto = new 款式图片一览Dto(dataRow);
款式图片一览Dtos.Add(款式图片一览Dto);
}
return(款式图片一览Dtos);
}
/// <summary>
/// 取得所有款式信息
/// </summary>
/// <returns></returns>
public static 款式Model getAllStyle(byte ENABLE_FLAG)
{
String sql = "SELECT\n" +
" SYS_STYLE_ID,\n"+
" CUSTOMER_COUNT_ID,\n"+
" STYLE_CD,\n"+
" STYLE_CATEGORY_CD,\n"+
" STYLE_DRESS_CATEGORY,\n"+
" STYLE_DESIGN_TYPE,\n"+
" STYLE_PUBLISH_CATEGORY_CD,\n"+
" REF_STYLE_ID,\n"+
" STYLE_NAME_CN,\n"+
" STYLE_NAME_EN,\n"+
" STYLE_FIT_CD,\n"+
" SYTLE_YEAR,\n"+
" SYTLE_SEASON,\n"+
" SYTLE_FABRIC_ID,\n"+
" STYLE_SIZE_GROUP_CD,\n"+
" STYLE_SIZE_CD,\n"+
" STYLE_MAKE_TYPE,\n"+
" STYLE_MATERIAL_NUMBER,\n"+
" STYLE_DESIGN_PRICE,\n"+
" CONCAT( 'https://sshirtmtmbucket.oss-cn-zhangjiakou.aliyuncs.com/sshirtmtm/', SUBSTRING_INDEX( COVER_PHOTO_PATH, '/',- 1 ) ) AS PIC_URL,\n"+
" SUBSTRING_INDEX( COVER_PHOTO_PATH, '/',- 1 ) AS PIC_NAME,\n"+
" ENABLE_FLAG,\n"+
" CREATE_DATE\n"+
"FROM\n" +
" v_style_p\n"+
" where v_style_p.ENABLE_FLAG = '" + ENABLE_FLAG + "'" +
" order by CREATE_DATE";
List <款式图片一览Dto> 款式图片一览Dtos = new List <款式图片一览Dto>();
List <String> FIT_CDs = new List <string>(); // 版型id
DataTable dataTable = SQLmtm.GetDataTable(sql);
foreach (DataRow dataRow in dataTable.Rows)
{
款式图片一览Dto 款式图片一览Dto = new 款式图片一览Dto(dataRow);
款式图片一览Dtos.Add(款式图片一览Dto);
if (!FIT_CDs.Contains(款式图片一览Dto.STYLE_FIT_CD))
{
FIT_CDs.Add(款式图片一览Dto.STYLE_FIT_CD); // 版型
}
}
款式Model model = new 款式Model(款式图片一览Dtos);
if (FIT_CDs.Count > 0)
{
sql = "SELECT DISTINCT\n" +
" FIT_CD,\n" +
" SIZEGROUP_CD,\n" +
" SIZE_CD \n" +
"FROM\n" +
" a_size_fit_p \n" +
"WHERE\n" +
" FIT_CD IN ( '" + String.Join("','", FIT_CDs) + "' ) \n" +
"ORDER BY\n" +
" FIT_CD,\n" +
" SIZEGROUP_CD,\n" +
" SIZE_CD";
dataTable = SQLmtm.GetDataTable(sql);
//List<String> EGS_GROUP_SIZEs = new List<string>(); // 数字尺码
//List<String> IGS_GROUP_SIZEs = new List<string>(); // 英文尺码
model.buildSizeFit(dataTable);
}
return(model.buildView());
}
