public virtual StoreEntity GetStoreByBPStoreSEQ(string bpStoreSEQ)
{
StoreEntity entity = new StoreEntity();
entity.BpStoreSeq = bpStoreSEQ;
Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity> list = new Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity>();
list = DataAccess.Select<StoreEntity>(entity);
if (list.Count > 0)
return list[0];
else
return null;
}
public static ProductEntity GetEntity(FakeProductEntity fakeEntity, DateTime actionDate)
{
string sqlTemp = "SELECT * from Product_View Where ( Product_StartDate <=CONVERT(datetime,'{0}') AND ISNULL(Product_EndDate,DATEADD(dd,-1,CONVERT(datetime,'{0}'))) > CONVERT(datetime,'{0}') ) ";
string strSelectSql = string.Format(sqlTemp, actionDate.ToString("yyyy-MM-dd"));
if (!string.IsNullOrEmpty(fakeEntity.Gbu))
{
strSelectSql += string.Format(" AND {0} = '{1}'",ProductTable.C_GBU, fakeEntity.Gbu);
}
if (!string.IsNullOrEmpty(fakeEntity.Category))
{
strSelectSql += string.Format(" AND {0} = '{1}'", ProductTable.C_Category, fakeEntity.Category);
}
if (!string.IsNullOrEmpty(fakeEntity.Brand))
{
strSelectSql += string.Format(" AND {0} = '{1}'", ProductTable.C_Brand, fakeEntity.Brand);
}
if (!string.IsNullOrEmpty(fakeEntity.SubCategory))
{
strSelectSql += string.Format(" AND {0} = '{1}'", ProductTable.C_SubCategory, fakeEntity.SubCategory);
}
if (!string.IsNullOrEmpty(fakeEntity.Brandtype))
{
strSelectSql += string.Format(" AND {0} = '{1}'", ProductTable.C_BrandType, fakeEntity.Brandtype);
}
if (!string.IsNullOrEmpty(fakeEntity.DescCn))
{
strSelectSql += string.Format(" AND {0} = '{1}'", ProductTable.C_DESC_CN, fakeEntity.DescCn);
}
if (!string.IsNullOrEmpty(fakeEntity.ProductSize))
{
strSelectSql += string.Format(" AND {0} = '{1}'", ProductTable.C_Product_Size, fakeEntity.ProductSize);
}
//DataTable dt = DataAccess.SelectDataSet(strSelectSql).Tables[0];
Suzsoft.Smart.EntityCore.EntityCollection<ProductEntity> list = new Suzsoft.Smart.EntityCore.EntityCollection<ProductEntity>();
list = DataAccess.Select<ProductEntity>(strSelectSql, null, CommandType.Text);
if (list.Count > 0)
return list[0];
else
return null;
}
//public virtual List<ChkFunctionParamEntity> GetChkFunctionParasByFunctionId(string functionId)
//{
// return SelectByCondition<ChkFunctionParamEntity>(adidas.DataCollection.Common.Utils.QueryCondition.Create().Equals(ChkFunctionParamTable.C_FUNCTION_ID, functionId).Order(ChkFunctionParamTable.C_SORT_ORDER));
//}
//public virtual void InsertChkFUnctionParas(List<ChkFunctionParamEntity> functionParas, DataAccessBroker broker)
//{
// DataAccess.Insert(functionParas, broker);
//}
//public virtual void DeleteChkFunctionParasByCondition(ChkFunctionParamEntity param, DataAccessBroker broker)
//{
// DataAccess.DeleteEntity(param, broker);
//}
public virtual StoreEntity GetStoreEntityById(string storeID, string dmsID)
{
StoreEntity entity = new StoreEntity();
entity.DmsStoreId = storeID;
entity.DmsId = dmsID;
Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity> list = new Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity>();
list = DataAccess.Select<StoreEntity>(entity);
if (list.Count > 0)
return list[0];
else
return null;
}
/// <summary>
/// Get entity by properties of entity
/// </summary>
/// <param name="gbu"></param>
/// <param name="category"></param>
/// <param name="brand"></param>
/// <param name="sub_category"></param>
/// <param name="brand_type"></param>
/// <param name="desc_cn"></param>
/// <param name="size"></param>
/// <returns></returns>
public static ProductEntity GetEntity(string gbu, string category, string brand, string sub_category, string brand_type, string desc_cn, string size)
{
ProductEntity entity = new ProductEntity();
entity.Gbu = gbu;
entity.Category = category;
entity.Brand = brand;
entity.Subcategory = sub_category;
entity.Brandtype = brand_type;
entity.DescCn = desc_cn;
entity.ProductSize = size;
Suzsoft.Smart.EntityCore.EntityCollection<ProductEntity> list = new Suzsoft.Smart.EntityCore.EntityCollection<ProductEntity>();
list = DataAccess.Select<ProductEntity>(entity);
if (list.Count > 0)
return list[0];
else
return null;
}