/// <summary>
/// 获得商品的属性以及值
/// </summary>
/// <returns></returns>
private List <Model.wx_shop_productAttr_value> AddAttr()
{
List <Model.wx_shop_productAttr_value> attrvlist = new List <Model.wx_shop_productAttr_value>();
string attrStr = hidAttrValueStr.Value;
if (attrStr == null || attrStr.Trim() == "")
{
return(null);
}
string[] attrStrArr = Utils.SplitString(attrStr, "||");
string[] tmpattrValue;
Model.wx_shop_productAttr_value attrEntity = new Model.wx_shop_productAttr_value();
foreach (string attr in attrStrArr)
{
if (attr.Length <= 0)
{
continue;
}
tmpattrValue = Utils.SplitString(attr, "_");
if (tmpattrValue != null && tmpattrValue.Length > 0)
{
attrEntity = new Model.wx_shop_productAttr_value();
attrEntity.attributeId = MyCommFun.Str2Int(tmpattrValue[1]);
attrEntity.paValue = MyCommFun.ObjToStr(tmpattrValue[3]);
attrvlist.Add(attrEntity);
}
}
return(attrvlist);
}
/// <summary>
/// 得到商品的属性列表(属性名称—属性值)
/// </summary>
public List <XCWeiXin.Model.wx_shop_productAttr_value> GetAttrModelList(int productId)
{
List <XCWeiXin.Model.wx_shop_productAttr_value> pAttrList = new List <Model.wx_shop_productAttr_value>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select v.id,v.attributeId,v.productId,v.paValue,a.aName from wx_shop_productAttr_value v,wx_shop_catalog_attribute a where v.attributeId=a.id ");
strSql.Append(" and v.productId=@productId");
SqlParameter[] parameters =
{
new SqlParameter("@productId", SqlDbType.Int, 4)
};
parameters[0].Value = productId;
XCWeiXin.Model.wx_shop_productAttr_value model = new XCWeiXin.Model.wx_shop_productAttr_value();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Model.wx_shop_productAttr_value pAttr = new Model.wx_shop_productAttr_value();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
pAttr = DataRowToModel(ds.Tables[0].Rows[i]);
pAttrList.Add(pAttr);
}
}
return(pAttrList);
}
/// <summary>
/// 得到商品的属性列表(属性名称—属性值)
/// </summary>
public List<WechatBuilder.Model.wx_shop_productAttr_value> GetAttrModelList(int productId)
{
List<WechatBuilder.Model.wx_shop_productAttr_value> pAttrList = new List<Model.wx_shop_productAttr_value>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select v.id,v.attributeId,v.productId,v.paValue,a.aName from wx_shop_productAttr_value v,wx_shop_catalog_attribute a where v.attributeId=a.id ");
strSql.Append(" and v.productId=@productId");
SqlParameter[] parameters = {
new SqlParameter("@productId", SqlDbType.Int,4)
};
parameters[0].Value = productId;
WechatBuilder.Model.wx_shop_productAttr_value model = new WechatBuilder.Model.wx_shop_productAttr_value();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
Model.wx_shop_productAttr_value pAttr = new Model.wx_shop_productAttr_value();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
pAttr = DataRowToModel(ds.Tables[0].Rows[i]);
pAttrList.Add(pAttr);
}
}
return pAttrList;
}
}//end:function
/// <summary>
/// 获得商品的属性以及值
/// </summary>
/// <returns></returns>
private List<Model.wx_shop_productAttr_value> AddAttr()
{
List<Model.wx_shop_productAttr_value> attrvlist = new List<Model.wx_shop_productAttr_value>();
string attrStr = hidAttrValueStr.Value;
if (attrStr == null || attrStr.Trim() == "")
{
return null;
}
string[] attrStrArr = Utils.SplitString(attrStr, "||");
string[] tmpattrValue;
Model.wx_shop_productAttr_value attrEntity = new Model.wx_shop_productAttr_value();
foreach (string attr in attrStrArr)
{
if (attr.Length <= 0)
{
continue;
}
tmpattrValue = Utils.SplitString(attr,"_");
if (tmpattrValue != null && tmpattrValue.Length>0)
{
attrEntity = new Model.wx_shop_productAttr_value();
attrEntity.attributeId =MyCommFun.Str2Int(tmpattrValue[1]);
attrEntity.paValue = MyCommFun.ObjToStr(tmpattrValue[3]);
attrvlist.Add(attrEntity);
}
}
return attrvlist;
}
