/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 得到一个对象实体
/// </summary>
public XCWeiXin.Model.wx_book_product GetModel(int id)
{
Model.wx_book_product product = new Model.wx_book_product();
product = dal.GetModel(id);
product.albums = new wx_book_albums().GetModelList("productId=" + id);
product.attrs = new DAL.wx_book_productAttr_value().GetAttrModelList(id);
product.skulist = new DAL.wx_book_sku().GetpSkuModelList(id);
return(product);
}
/// <summary>
/// 绑定预订信息
/// </summary>
/// <param name="id"></param>
private void BindProductInfo(int id)
{
hidid.Value = id.ToString();
Model.wx_book_product product = spBll.GetModel(id);
ddlCategoryId.SelectedValue = product.categoryId.Value.ToString();
ddlCatalog.SelectedValue = product.catalogId.ToString();
hidCatalogId.Value = product.catalogId.ToString();
txtproductName.Text = product.productName;
txtunit.Text = product.unit;
txtsku.Text = product.sku;
if (product.upselling)
{
radType.Items[0].Selected = true;
}
else
{
radType.Items[1].Selected = true;
}
if (product.latest)
{
cblActionType.Items[0].Selected = true;
}
if (product.hotsale)
{
cblActionType.Items[1].Selected = true;
}
if (product.recommended)
{
cblActionType.Items[2].Selected = true;
}
if (product.specialOffer)
{
cblActionType.Items[3].Selected = true;
}
txtcostPrice.Text = product.costPrice.ToString();
txtmarketPrice.Text = product.marketPrice.ToString();
txtsalePrice.Text = product.salePrice.ToString();
txtstock.Text = product.stock.ToString();
txtsort_id.Text = product.sort_id == null ? "99" : product.sort_id.ToString();
txtshortDesc.Text = product.shortDesc;
txtdescription.InnerText = product.description;
rptAlbumList.DataSource = product.albums;
rptAlbumList.DataBind();
//绑定属性html
BindAttrHtml(product.catalogId);
}
/// <summary>
/// 设置操作
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(((HiddenField)e.Item.FindControl("hidId")).Value);
BLL.wx_book_product bll = new BLL.wx_book_product();
Model.wx_book_product model = bll.GetModel(id);
switch (e.CommandName)
{
case "lbtnIslatest": //最新
if (model.latest)
{
bll.UpdateField(id, "latest=0");
}
else
{
bll.UpdateField(id, "latest=1");
}
break;
case "lbtnIshotsale":
if (model.hotsale)
{
bll.UpdateField(id, "hotsale=0");
}
else
{
bll.UpdateField(id, "hotsale=1");
}
break;
case "lbtnIsspecialOffer":
if (model.specialOffer)
{
bll.UpdateField(id, "specialOffer=0");
}
else
{
bll.UpdateField(id, "specialOffer=1");
}
break;
}
this.RptBind(this.category_id, CombSqlTxt(this.keywords), "sort_id asc,id desc");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XCWeiXin.Model.wx_book_product GetModel(int id)
{
Model.wx_book_product product = new Model.wx_book_product();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,categoryId,brandId,sku,productName,shortDesc,unit,weight,description,seo_title,seo_keywords,seo_description,focusImgUrl,thumbnailsUrll,recommended,latest,hotsale,specialOffer,costPrice,marketPrice,salePrice,upselling,stock,addDate,vistiCounts,sort_id,productionDate,ExpiryEndDate,updateDate,catalogId from wx_book_product ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
XCWeiXin.Model.wx_book_product model = new XCWeiXin.Model.wx_book_product();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
product = DataRowToModel(ds.Tables[0].Rows[0]);
}
return(product);
}
public void bookDetailPage()
{
BLL.wx_book_product artDal = new BLL.wx_book_product();
int pid = MyCommFun.RequestInt("pid");
Model.wx_book_product product = artDal.GetModel(pid);
if (product != null)
{
string skuStr = "[";
string availSkuStr = "{";
if (product.skulist != null && product.skulist.Count > 0)
{
// string skuStr = "[{ \"pList\": [\"H\", \"H/VVS/32分/14号\"], \"pName\": \"戒指手寸\" }]";
// string availSku = "{ \"戒指手寸:F-G/VVS/33分/12号\": { \"pid\": 12700, \"stockCount\": \"\", \"stockPrice\": \"1000\", \"maketPrice\": \"0\" }, }";
skuStr += "{ \"pList\": [";
//暂时只支持一种配件
for (int i = 0; i < product.skulist.Count; i++)
{
product.skulist[i].price += product.salePrice;
product.skulist[i].price *= 100;
if (i != (product.skulist.Count - 1))
{
skuStr += "\"" + product.skulist[i].attributeValue + "\",";
availSkuStr += "\"" + product.skulist[0].attrName + ":" + product.skulist[i].attributeValue + "\": { \"pid\": " + product.skulist[i].id + ", \"stockCount\": \"\", \"stockPrice\": \"" + product.skulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" }, ";
}
else
{
skuStr += "\"" + product.skulist[i].attributeValue + "\"";
availSkuStr += "\"" + product.skulist[0].attrName + ":" + product.skulist[i].attributeValue + "\": { \"pid\": " + product.skulist[i].id + ", \"stockCount\": \"\", \"stockPrice\": \"" + product.skulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" }";
}
}
skuStr += "], \"pName\": \"" + product.skulist[0].attrName + "\" }";
//XCWeiXin.DAL.bookSKUDal skuDal = new DAL.bookSKUDal();
//IList<Model.bookSKU> skulist = skuDal.SKUConvert(product.skulist);
//this.Document.SetValue("skulist", skulist[0]);
}
skuStr += "]";
availSkuStr += "}";
if (availSkuStr == "{}")
{
availSkuStr = "{ \"\": { \"pid\": 0, \"stockCount\": \"\", \"stockPrice\": \"" + product.salePrice + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" } }";
}
this.Document.SetValue("skuStr", skuStr);
this.Document.SetValue("availSkuStr", availSkuStr);
this.Document.SetValue("model", product);
}
/*
* BLL.wx_book_product artDal = new BLL.wx_book_product();
* int pid = MyCommFun.RequestInt("pid");
* Model.wx_book_product product = artDal.GetModel(pid);
* int catalogId = product.catalogId;
* BLL.wx_book_catalog_attribute caBll = new BLL.wx_book_catalog_attribute();
* IList<Model.wx_book_catalog_attribute> attrlist = caBll.GetModelList("catalogId=" + catalogId + " order by sort_id asc");
*
* Model.wx_book_catalog_attribute attr = new Model.wx_book_catalog_attribute();
* string skuStr = "{";
* string availSkuStr = "{";
*
* for (int i = 0; i < attrlist.Count; i++)
* {
* attr = attrlist[i];
*
* // attrStr.Append(" <dt>" + attr.aName + "</dt>");
* string[] attrvalueArr = Utils.SplitString(attr.aValue, "\r\n");
*
* if (product != null)
* {
*
* if (attrvalueArr != null && attrvalueArr.Length > 0)
* {
* // string skuStr = "[{ \"pList\": [\"H\", \"H/VVS/32分/14号\"], \"pName\": \"戒指手寸\" }]";
* // string availSku = "{ \"戒指手寸:F-G/VVS/33分/12号\": { \"pid\": 12700, \"stockCount\": \"\", \"stockPrice\": \"1000\", \"maketPrice\": \"0\" }, }";
*
* skuStr += "{ \"pList\": [";
* //暂时只支持一种配件
* for (int j = 0; j < attrvalueArr.Length; j++)
* {
* product.skulist[i].price += product.salePrice;
* product.skulist[i].price *= 100;
* if (i != (product.skulist.Count - 1))
* {
* skuStr += "\"" + product.skulist[i].attributeValue + "\",";
* availSkuStr += "\"" + product.skulist[0].attrName + ":" + product.skulist[i].attributeValue + "\": { \"pid\": " + product.skulist[i].id + ", \"stockCount\": \"\", \"stockPrice\": \"" + product.skulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" }, ";
* }
* else
* {
* skuStr += "\"" + product.skulist[i].attributeValue + "\"";
* availSkuStr += "\"" + product.skulist[0].attrName + ":" + product.skulist[i].attributeValue + "\": { \"pid\": " + product.skulist[i].id + ", \"stockCount\": \"\", \"stockPrice\": \"" + product.skulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" }";
* }
* }
* skuStr += "], \"pName\": \"" + product.skulist[0].attrName + "\" }";
*
* //XCWeiXin.DAL.bookSKUDal skuDal = new DAL.bookSKUDal();
* //IList<Model.bookSKU> skulist = skuDal.SKUConvert(product.skulist);
* //this.Document.SetValue("skulist", skulist[0]);
* }
* skuStr += "]";
* availSkuStr += "}";
* if (availSkuStr == "{}")
* {
* availSkuStr = "{ \"\": { \"pid\": 0, \"stockCount\": \"\", \"stockPrice\": \"" + product.salePrice + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" } }";
* }
* this.Document.SetValue("skuStr", skuStr);
* this.Document.SetValue("availSkuStr", availSkuStr);
* this.Document.SetValue("model", product);
*
* }
* }
*/
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.wx_book_product model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_book_product(");
strSql.Append("wid,categoryId,brandId,sku,productName,shortDesc,unit,weight,description,seo_title,seo_keywords,seo_description,focusImgUrl,thumbnailsUrll,recommended,latest,hotsale,specialOffer,costPrice,marketPrice,salePrice,upselling,stock,addDate,vistiCounts,sort_id,productionDate,ExpiryEndDate,updateDate,catalogId)");
strSql.Append(" values (");
strSql.Append("@wid,@categoryId,@brandId,@sku,@productName,@shortDesc,@unit,@weight,@description,@seo_title,@seo_keywords,@seo_description,@focusImgUrl,@thumbnailsUrll,@recommended,@latest,@hotsale,@specialOffer,@costPrice,@marketPrice,@salePrice,@upselling,@stock,@addDate,@vistiCounts,@sort_id,@productionDate,@ExpiryEndDate,@updateDate,@catalogId)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@categoryId", SqlDbType.Int, 4),
new SqlParameter("@brandId", SqlDbType.Int, 4),
new SqlParameter("@sku", SqlDbType.VarChar, 20),
new SqlParameter("@productName", SqlDbType.VarChar, 500),
new SqlParameter("@shortDesc", SqlDbType.VarChar, 500),
new SqlParameter("@unit", SqlDbType.VarChar, 10),
new SqlParameter("@weight", SqlDbType.Float, 8),
new SqlParameter("@description", SqlDbType.VarChar, 2000),
new SqlParameter("@seo_title", SqlDbType.VarChar, 200),
new SqlParameter("@seo_keywords", SqlDbType.VarChar, 300),
new SqlParameter("@seo_description", SqlDbType.VarChar, 500),
new SqlParameter("@focusImgUrl", SqlDbType.VarChar, 800),
new SqlParameter("@thumbnailsUrll", SqlDbType.VarChar, 800),
new SqlParameter("@recommended", SqlDbType.Bit, 1),
new SqlParameter("@latest", SqlDbType.Bit, 1),
new SqlParameter("@hotsale", SqlDbType.Bit, 1),
new SqlParameter("@specialOffer", SqlDbType.Bit, 1),
new SqlParameter("@costPrice", SqlDbType.Float, 8),
new SqlParameter("@marketPrice", SqlDbType.Float, 8),
new SqlParameter("@salePrice", SqlDbType.Float, 8),
new SqlParameter("@upselling", SqlDbType.Bit, 1),
new SqlParameter("@stock", SqlDbType.Int, 4),
new SqlParameter("@addDate", SqlDbType.DateTime),
new SqlParameter("@vistiCounts", SqlDbType.Int, 4),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@productionDate", SqlDbType.DateTime),
new SqlParameter("@ExpiryEndDate", SqlDbType.DateTime),
new SqlParameter("@updateDate", SqlDbType.DateTime),
new SqlParameter("@catalogId", SqlDbType.Int, 4),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.wid;
parameters[1].Value = model.categoryId;
parameters[2].Value = model.brandId;
parameters[3].Value = model.sku;
parameters[4].Value = model.productName;
parameters[5].Value = model.shortDesc;
parameters[6].Value = model.unit;
parameters[7].Value = model.weight;
parameters[8].Value = model.description;
parameters[9].Value = model.seo_title;
parameters[10].Value = model.seo_keywords;
parameters[11].Value = model.seo_description;
parameters[12].Value = model.focusImgUrl;
parameters[13].Value = model.thumbnailsUrll;
parameters[14].Value = model.recommended;
parameters[15].Value = model.latest;
parameters[16].Value = model.hotsale;
parameters[17].Value = model.specialOffer;
parameters[18].Value = model.costPrice;
parameters[19].Value = model.marketPrice;
parameters[20].Value = model.salePrice;
parameters[21].Value = model.upselling;
parameters[22].Value = model.stock;
parameters[23].Value = model.addDate;
parameters[24].Value = model.vistiCounts;
parameters[25].Value = model.sort_id;
parameters[26].Value = model.productionDate;
parameters[27].Value = model.ExpiryEndDate;
parameters[28].Value = model.updateDate;
parameters[29].Value = model.catalogId;
parameters[30].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
#region //图片相册
if (model.albums != null)
{
StringBuilder strSql2;
foreach (Model.wx_book_albums modelt in model.albums)
{
strSql2 = new StringBuilder();
strSql2.Append("insert into wx_book_albums(");
strSql2.Append("productId,thumb_path,original_path,remark,add_time,wid)");
strSql2.Append(" values (");
strSql2.Append("@productId,@thumb_path,@original_path,@remark,@add_time,@wid)");
SqlParameter[] parameters2 =
{
new SqlParameter("@productId", SqlDbType.Int, 4),
new SqlParameter("@thumb_path", SqlDbType.NVarChar, 255),
new SqlParameter("@original_path", SqlDbType.NVarChar, 255),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@add_time", SqlDbType.DateTime, 30),
new SqlParameter("@wid", SqlDbType.Int, 4)
};
parameters2[0].Direction = ParameterDirection.InputOutput;
parameters2[1].Value = modelt.thumb_path;
parameters2[2].Value = modelt.original_path;
parameters2[3].Value = modelt.remark;
parameters2[4].Value = DateTime.Now.ToString();
parameters2[5].Value = model.wid;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
}
}
#endregion
#region //商品属性
if (model.attrs != null)
{
StringBuilder strSql3;
foreach (Model.wx_book_productAttr_value modelt in model.attrs)
{
strSql3 = new StringBuilder();
strSql3.Append("insert into wx_book_productAttr_value(");
strSql3.Append("productId,attributeId,paValue)");
strSql3.Append(" values (");
strSql3.Append("@productId,@attributeId,@paValue)");
SqlParameter[] parameters3 =
{
new SqlParameter("@productId", SqlDbType.Int, 4),
new SqlParameter("@attributeId", SqlDbType.Int, 4),
new SqlParameter("@paValue", SqlDbType.NVarChar, 300)
};
parameters3[0].Direction = ParameterDirection.InputOutput;
parameters3[1].Value = modelt.attributeId;
parameters3[2].Value = modelt.paValue;
cmd = new CommandInfo(strSql3.ToString(), parameters3);
sqllist.Add(cmd);
}
}
#endregion
#region //商品配件sku|规格
if (model.skulist != null)
{
StringBuilder strSql4;
foreach (Model.wx_book_sku modelt in model.skulist)
{
strSql4 = new StringBuilder();
strSql4.Append("insert into wx_book_sku(");
strSql4.Append("productId,attributeId,attributeValue,price)");
strSql4.Append(" values (");
strSql4.Append("@productId,@attributeId,@attributeValue,@price)");
SqlParameter[] parameters4 =
{
new SqlParameter("@productId", SqlDbType.Int, 4),
new SqlParameter("@attributeId", SqlDbType.Int, 4),
new SqlParameter("@attributeValue", SqlDbType.NVarChar, 300),
new SqlParameter("@price", SqlDbType.Float, 10),
};
parameters4[0].Direction = ParameterDirection.InputOutput;
parameters4[1].Value = modelt.attributeId;
parameters4[2].Value = modelt.attributeValue;
parameters4[3].Value = modelt.price;
cmd = new CommandInfo(strSql4.ToString(), parameters4);
sqllist.Add(cmd);
}
}
#endregion
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[30].Value);
}
