private void btnCreateValueAdd_Click(object sender, EventArgs e)
{
AttributeValueInfo info = new AttributeValueInfo();
IList<AttributeValueInfo> list = new List<AttributeValueInfo>();
int num = int.Parse(this.currentAttributeId.Value);
info.AttributeId = num;
if (!string.IsNullOrEmpty(this.txtValueStr.Text.Trim()))
{
string[] strArray = this.txtValueStr.Text.Trim().Split(new char[] { ',' });
for (int i = 0; i < strArray.Length; i++)
{
if (strArray[i].Length > 100)
{
break;
}
AttributeValueInfo item = new AttributeValueInfo();
if (strArray[i].Length > 15)
{
string str = string.Format("ShowMsg(\"{0}\", {1});", "属性值限制在15个字符以内", "false");
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript2", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>");
return;
}
item.ValueStr = Globals.HtmlEncode(strArray[i]).Replace("+", "");
item.AttributeId = num;
list.Add(item);
}
foreach (AttributeValueInfo info3 in list)
{
ProductTypeHelper.AddAttributeValue(info3);
}
this.txtValueStr.Text = string.Empty;
base.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
}
public bool UpdateAttributeValue(AttributeValueInfo attributeValue)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE Hishop_AttributeValues SET ValueStr=@ValueStr, ImageUrl=@ImageUrl WHERE ValueId=@valueId");
this.database.AddInParameter(sqlStringCommand, "ValueStr", DbType.String, attributeValue.ValueStr);
this.database.AddInParameter(sqlStringCommand, "ValueId", DbType.Int32, attributeValue.ValueId);
this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, attributeValue.ImageUrl);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public override bool AddAttributeValue(AttributeValueInfo attributeValue)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("DECLARE @DisplaySequence AS INT SELECT @DisplaySequence = (CASE WHEN MAX(DisplaySequence) IS NULL THEN 1 ELSE MAX(DisplaySequence) + 1 END) FROM Hishop_AttributeValues; INSERT INTO Hishop_AttributeValues(AttributeId, DisplaySequence, ValueStr, ImageUrl) VALUES(@AttributeId, @DisplaySequence, @ValueStr, @ImageUrl)");
database.AddInParameter(sqlStringCommand, "AttributeId", DbType.Int32, attributeValue.AttributeId);
database.AddInParameter(sqlStringCommand, "ValueStr", DbType.String, attributeValue.ValueStr);
database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, attributeValue.ImageUrl);
return (database.ExecuteNonQuery(sqlStringCommand) > 0);
}
/// <summary>
/// 创建规格值
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCreateValue_Click(object sender, EventArgs e)
{
AttributeValueInfo attributeValue = new AttributeValueInfo();
IList<AttributeValueInfo> list = new List<AttributeValueInfo>();
int num = int.Parse(currentAttributeId.Value);
attributeValue.AttributeId = num;
if (!string.IsNullOrEmpty(txtValueStr.Text.Trim()))
{
string[] strArray = txtValueStr.Text.Trim().Split(new char[] { ',' });
for (int i = 0; i < strArray.Length; i++)
{
if (strArray[i].Length > 100)
{
break;
}
AttributeValueInfo item = new AttributeValueInfo();
if (strArray[i].Length > 15)
{
string str = string.Format("ShowMsg(\"{0}\", {1});", "属性值限制在15个字符以内", "false");
Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript2", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>");
return;
}
item.ValueStr = Globals.HtmlEncode(strArray[i]);
item.AttributeId = num;
list.Add(item);
}
foreach (AttributeValueInfo info3 in list)
{
ProductTypeHelper.AddAttributeValue(info3);
}
txtValueStr.Text = string.Empty;
base.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
if (fileUpload.HasFile)
{
try
{
attributeValue.ImageUrl = ProductTypeHelper.UploadSKUImage(fileUpload.PostedFile);
// if (!string.IsNullOrEmpty(attributeValue.ValueStr))
//{
attributeValue.ValueStr = Globals.HtmlEncode(txtValueDec.Text);
////}
////else
////{
//// throw new Exception("测试抛出的错误：ValueStr为NULL！");
////}
}
catch
{
}
if (ProductTypeHelper.AddAttributeValue(attributeValue))
{
txtValueStr.Text = string.Empty;
base.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
}
}
public int AddAttributeValue(AttributeValueInfo attributeValue)
{
int num = 0;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DECLARE @DisplaySequence AS INT SELECT @DisplaySequence = (CASE WHEN MAX(DisplaySequence) IS NULL THEN 1 ELSE MAX(DisplaySequence) + 1 END) FROM Hishop_AttributeValues; INSERT INTO Hishop_AttributeValues(AttributeId, DisplaySequence, ValueStr, ImageUrl) VALUES(@AttributeId, @DisplaySequence, @ValueStr, @ImageUrl);SELECT @@IDENTITY");
this.database.AddInParameter(sqlStringCommand, "AttributeId", DbType.Int32, attributeValue.AttributeId);
this.database.AddInParameter(sqlStringCommand, "ValueStr", DbType.String, attributeValue.ValueStr);
this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, attributeValue.ImageUrl);
object obj2 = this.database.ExecuteScalar(sqlStringCommand);
if (obj2 != null)
{
num = Convert.ToInt32(obj2.ToString());
}
return num;
}
public override IList<AttributeInfo> GetAttributeInfoByCategoryId(int categoryId)
{
IList<AttributeInfo> list = new List<AttributeInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Hishop_Attributes WHERE TypeId=(SELECT AssociatedProductType FROM distro_Categories WHERE CategoryId=@CategoryId) AND UsageMode <> 2) AND ValueId IN (SELECT ValueId FROM Hishop_ProductAttributes WHERE ProductId IN (SELECT ProductId FROM distro_Products WHERE DistributorUserId = @DistributorUserId)) ORDER BY DisplaySequence DESC; SELECT * FROM Hishop_Attributes WHERE TypeId=(SELECT AssociatedProductType FROM distro_Categories WHERE CategoryId=@CategoryId) AND UsageMode <> 2 AND AttributeId IN (SELECT AttributeId FROM Hishop_ProductAttributes WHERE ProductId IN (SELECT ProductId FROM distro_Products WHERE DistributorUserId = @DistributorUserId)) ORDER BY DisplaySequence DESC");
this.database.AddInParameter(sqlStringCommand, "CategoryId", DbType.Int32, categoryId);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
IList<AttributeValueInfo> list2 = new List<AttributeValueInfo>();
while (reader.Read())
{
AttributeValueInfo item = new AttributeValueInfo();
item.ValueId = (int) reader["ValueId"];
item.AttributeId = (int) reader["AttributeId"];
item.DisplaySequence = (int) reader["DisplaySequence"];
item.ValueStr = (string) reader["ValueStr"];
if (reader["ImageUrl"] != DBNull.Value)
{
item.ImageUrl = (string) reader["ImageUrl"];
}
list2.Add(item);
}
if (!reader.NextResult())
{
return list;
}
while (reader.Read())
{
AttributeInfo info2 = new AttributeInfo();
info2.AttributeId = (int) reader["AttributeId"];
info2.AttributeName = (string) reader["AttributeName"];
info2.DisplaySequence = (int) reader["DisplaySequence"];
info2.TypeId = (int) reader["TypeId"];
info2.UsageMode = (AttributeUseageMode) ((int) reader["UsageMode"]);
info2.UseAttributeImage = (bool) reader["UseAttributeImage"];
foreach (AttributeValueInfo info3 in list2)
{
if (info2.AttributeId == info3.AttributeId)
{
info2.AttributeValues.Add(info3);
}
}
list.Add(info2);
}
}
return list;
}
private void btnAdd_Click(object sender, EventArgs e)
{
AttributeValueInfo attributeValue = new AttributeValueInfo();
if ((this.txtValue.Text.Trim().Length > 15) || (this.txtValue.Text.Trim().Length == 0))
{
this.ShowMsg("属性值必须小于15个字符，不能为空", false);
}
else
{
attributeValue.ValueStr = this.txtValue.Text.Trim().Replace("+", "");
attributeValue.AttributeId = this.attributeId;
if (ProductTypeHelper.AddAttributeValue(attributeValue) > 0)
{
this.BindData();
this.ShowMsg("添加成功", true);
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
AttributeValueInfo attributeValue = new AttributeValueInfo();
if (((txtValue.Text.Trim().Length > 15) || (txtValue.Text.Trim().IndexOf(",") != -1)) || (txtValue.Text.Trim().Length == 0))
{
ShowMsg("属性值必须小于15个字符，不能为空，并且不能包含逗号", false);
}
else
{
attributeValue.ValueStr = txtValue.Text.Trim().Replace("+", "");
attributeValue.AttributeId = attributeId;
if (ProductTypeHelper.AddAttributeValue(attributeValue))
{
BindData();
ShowMsg("添加成功", true);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int num;
if ((!string.IsNullOrEmpty(base.Request["isCallback"]) && (base.Request["isCallback"] == "true")) && int.TryParse(base.Request["ValueId"], out num))
{
if (ProductTypeHelper.DeleteAttributeValue(num))
{
if (!string.IsNullOrEmpty(base.Request["ImageUrl"]))
{
StoreHelper.DeleteImage(base.Request["ImageUrl"]);
base.Response.Clear();
base.Response.ContentType = "application/json";
base.Response.Write("{\"Status\":\"true\"}");
base.Response.End();
}
else
{
base.Response.Clear();
base.Response.ContentType = "application/json";
base.Response.Write("{\"Status\":\"true\"}");
base.Response.End();
}
}
else
{
base.Response.Clear();
base.Response.ContentType = "application/json";
base.Response.Write("{\"Status\":\"false\"}");
base.Response.End();
}
}
if (!string.IsNullOrEmpty(base.Request["isAjax"]) && (base.Request["isAjax"] == "true"))
{
string str = base.Request["Mode"].ToString();
string str2 = "";
string str3 = "false";
string str6 = str;
if (str6 != null)
{
int num2;
if (!(str6 == "Add"))
{
if (str6 == "AddSkuItemValue")
{
str2 = "参数缺少";
if (int.TryParse(base.Request["AttributeId"], out num2))
{
string str5 = "";
str2 = "规格值名不允许为空！";
if (!string.IsNullOrEmpty(base.Request["ValueName"].ToString()))
{
str5 = Globals.HtmlEncode(base.Request["ValueName"].ToString().Replace("+", "").Replace(",", ""));
str2 = "规格值名长度不允许超过15个字符";
if (str5.Length < 15)
{
AttributeValueInfo attributeValue = new AttributeValueInfo {
ValueStr = str5,
AttributeId = num2
};
int num4 = 0;
str2 = "添加规格值失败";
num4 = ProductTypeHelper.AddAttributeValue(attributeValue);
if (num4 > 0)
{
str2 = num4.ToString();
str3 = "true";
}
}
}
}
base.Response.Clear();
base.Response.ContentType = "application/json";
base.Response.Write("{\"Status\":\"" + str3 + "\",\"msg\":\"" + str2 + "\"}");
base.Response.End();
}
}
else
{
num2 = 0;
str2 = "参数缺少";
if (int.TryParse(base.Request["AttributeId"], out num2))
{
string str4 = "";
str2 = "属性名称不允许为空！";
if (!string.IsNullOrEmpty(base.Request["ValueName"].ToString()))
{
str4 = Globals.HtmlEncode(base.Request["ValueName"].ToString());
AttributeValueInfo info = new AttributeValueInfo {
ValueStr = str4,
AttributeId = num2
};
int num3 = 0;
str2 = "添加属性值失败";
num3 = ProductTypeHelper.AddAttributeValue(info);
if (num3 > 0)
{
str2 = num3.ToString();
str3 = "true";
}
}
}
base.Response.Clear();
base.Response.ContentType = "application/json";
base.Response.Write("{\"Status\":\"" + str3 + "\",\"msg\":\"" + str2 + "\"}");
base.Response.End();
}
}
}
this.btnFilish.Click += new EventHandler(this.btnFilish_Click);
}
public IList<AttributeInfo> GetAttributes(int typeId)
{
IList<AttributeInfo> list = new List<AttributeInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_Attributes WHERE TypeId = @TypeId ORDER BY DisplaySequence DESC SELECT * FROM Hishop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Hishop_Attributes WHERE TypeId = @TypeId) ORDER BY DisplaySequence DESC");
this.database.AddInParameter(sqlStringCommand, "TypeId", DbType.Int32, typeId);
using (DataSet set = this.database.ExecuteDataSet(sqlStringCommand))
{
foreach (DataRow row in set.Tables[0].Rows)
{
AttributeInfo item = new AttributeInfo {
AttributeId = (int) row["AttributeId"],
AttributeName = (string) row["AttributeName"],
DisplaySequence = (int) row["DisplaySequence"],
TypeId = (int) row["TypeId"],
UsageMode = (AttributeUseageMode) ((int) row["UsageMode"]),
UseAttributeImage = (bool) row["UseAttributeImage"]
};
if (set.Tables[1].Rows.Count > 0)
{
DataRow[] rowArray = set.Tables[1].Select("AttributeId=" + item.AttributeId.ToString());
foreach (DataRow row2 in rowArray)
{
AttributeValueInfo info2 = new AttributeValueInfo {
ValueId = (int) row2["ValueId"],
AttributeId = item.AttributeId,
ValueStr = (string) row2["ValueStr"]
};
item.AttributeValues.Add(info2);
}
}
list.Add(item);
}
}
return list;
}
public IList<AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode)
{
string str;
IList<AttributeInfo> list = new List<AttributeInfo>();
if (attributeUseageMode == AttributeUseageMode.Choose)
{
str = "UsageMode = 2";
}
else
{
str = "UsageMode <> 2";
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_Attributes WHERE TypeId = @TypeId AND " + str + " ORDER BY DisplaySequence Desc SELECT * FROM Hishop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Hishop_Attributes WHERE TypeId = @TypeId AND " + str + " ) ORDER BY DisplaySequence Desc");
this.database.AddInParameter(sqlStringCommand, "TypeId", DbType.Int32, typeId);
using (DataSet set = this.database.ExecuteDataSet(sqlStringCommand))
{
foreach (DataRow row in set.Tables[0].Rows)
{
AttributeInfo item = new AttributeInfo {
AttributeId = (int) row["AttributeId"],
AttributeName = (string) row["AttributeName"],
DisplaySequence = (int) row["DisplaySequence"],
TypeId = (int) row["TypeId"],
UsageMode = (AttributeUseageMode) ((int) row["UsageMode"]),
UseAttributeImage = (bool) row["UseAttributeImage"]
};
if (set.Tables[1].Rows.Count > 0)
{
DataRow[] rowArray = set.Tables[1].Select("AttributeId=" + item.AttributeId.ToString());
foreach (DataRow row2 in rowArray)
{
AttributeValueInfo info2 = new AttributeValueInfo {
ValueId = (int) row2["ValueId"],
AttributeId = item.AttributeId
};
if (row2["ImageUrl"] != DBNull.Value)
{
info2.ImageUrl = (string) row2["ImageUrl"];
}
info2.ValueStr = (string) row2["ValueStr"];
item.AttributeValues.Add(info2);
}
}
list.Add(item);
}
}
return list;
}
public static AttributeValueInfo PopulateAttributeValue(IDataReader reader)
{
if (reader == null)
{
return null;
}
AttributeValueInfo info = new AttributeValueInfo();
info.ValueId = (int) reader["ValueId"];
info.AttributeId = (int) reader["AttributeId"];
info.ValueStr = (string) reader["ValueStr"];
return info;
}
public abstract bool AddAttributeValue(AttributeValueInfo attributeValue);
public static int GetSpecificationValueId(int attributeId, string valueStr)
{
int specificationValueId = new AttributeValueDao().GetSpecificationValueId(attributeId, valueStr);
if (specificationValueId > 0)
{
return specificationValueId;
}
AttributeValueInfo attributeValue = new AttributeValueInfo {
AttributeId = attributeId,
ValueStr = valueStr
};
return new AttributeValueDao().AddAttributeValue(attributeValue);
}
public static bool AddAttributeValue(AttributeValueInfo attributeValue)
{
return ProductProvider.Instance().AddAttributeValue(attributeValue);
}
public static bool UpdateSku(AttributeValueInfo attributeValue)
{
return ProductProvider.Instance().UpdateSku(attributeValue);
}
void RenderButton(HtmlTextWriter writer)
{
IList<AttributeInfo> attributeInfoByCategoryId = new List<AttributeInfo>();
attributeInfoByCategoryId = ProductBrowser.GetAttributeInfoByCategoryId(this.CategoryId);
if (attributeInfoByCategoryId.Count > 0)
{
for (int i = 0; (i < this.MaxNum) && (i < attributeInfoByCategoryId.Count); i++)
{
WebControl control = new WebControl(HtmlTextWriterTag.Label);
control.Controls.Add(new LiteralControl("<li>"));
control.RenderControl(writer);
WebControl control2 = new WebControl(HtmlTextWriterTag.Label);
control2.Controls.Add(new LiteralControl("<span>" + attributeInfoByCategoryId[i].AttributeName + "：</span>"));
control2.Attributes.Add("class", this.NameCss);
control2.RenderControl(writer);
WebControl control3 = new WebControl(HtmlTextWriterTag.A);
control3.Controls.Add(new LiteralControl("全部"));
if (!this.LinkSelf)
{
control3.Attributes.Add("target", "_blank");
}
string str = "";
if (!string.IsNullOrEmpty(this.ValueStr))
{
string[] strArray = this.ValueStr.Split(new char[] { '-' });
if (strArray.Length >= 1)
{
for (int j = 0; j < strArray.Length; j++)
{
string[] strArray2 = strArray[j].Split(new char[] { '_' });
if ((strArray2.Length > 0) && (strArray2[0].IndexOf(attributeInfoByCategoryId[i].AttributeId.ToString()) != -1))
{
strArray2[1] = "0";
strArray[j] = strArray2[0] + "_" + strArray2[1];
}
if (string.IsNullOrEmpty(str))
{
str = str + strArray[j];
}
else
{
str = str + "-" + strArray[j];
}
}
if (str.IndexOf(attributeInfoByCategoryId[i].AttributeId.ToString()) == -1)
{
object obj2 = str;
str = string.Concat(new object[] { obj2, "-", attributeInfoByCategoryId[i].AttributeId, "_0" });
}
}
}
else
{
str = attributeInfoByCategoryId[i].AttributeId + "_0";
}
if (string.IsNullOrEmpty(this.Page.Request.QueryString["valueStr"]))
{
control3.Attributes.Add("class", this.AllCss);
}
else
{
string str2 = this.Page.Request.QueryString["valueStr"];
if (str2 == str)
{
control3.Attributes.Add("class", this.AllCss);
}
}
control3.Attributes.Add("href", this.CreateUrl(str));
control3.RenderControl(writer);
foreach (AttributeValueInfo info in attributeInfoByCategoryId[i].AttributeValues)
{
WebControl control4 = new WebControl(HtmlTextWriterTag.A);
control4.Controls.Add(new LiteralControl(info.ValueStr));
string str3 = "";
if (!string.IsNullOrEmpty(this.ValueStr))
{
string[] strArray3 = this.ValueStr.Split(new char[] { '-' });
if (strArray3.Length >= 1)
{
for (int k = 0; k < strArray3.Length; k++)
{
string[] strArray4 = strArray3[k].Split(new char[] { '_' });
if ((strArray4.Length > 0) && (strArray4[0].IndexOf(attributeInfoByCategoryId[i].AttributeId.ToString()) != -1))
{
strArray4[1] = info.ValueId.ToString();
strArray3[k] = strArray4[0] + "_" + strArray4[1];
}
if (string.IsNullOrEmpty(str3))
{
str3 = str3 + strArray3[k];
}
else
{
str3 = str3 + "-" + strArray3[k];
}
}
if (str3.IndexOf(attributeInfoByCategoryId[i].AttributeId.ToString()) == -1)
{
object obj3 = str3;
str3 = string.Concat(new object[] { obj3, "-", info.AttributeId, "_", info.ValueId });
}
}
}
else
{
str3 = info.AttributeId + "_" + info.ValueId;
}
bool flag = false;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["valueStr"]))
{
IList<AttributeValueInfo> list2 = new List<AttributeValueInfo>();
string str4 = Globals.UrlDecode(this.Page.Request.QueryString["valueStr"]);
string[] strArray5 = str4.Split(new char[] { '-' });
if (!string.IsNullOrEmpty(str4))
{
for (int m = 0; m < strArray5.Length; m++)
{
string[] strArray6 = strArray5[m].Split(new char[] { '_' });
if (((strArray6.Length > 0) && !string.IsNullOrEmpty(strArray6[1])) && (strArray6[1] != "0"))
{
AttributeValueInfo item = new AttributeValueInfo();
item.AttributeId = Convert.ToInt32(strArray6[0]);
item.ValueId = Convert.ToInt32(strArray6[1]);
if (info.ValueId == Convert.ToInt32(strArray6[1]))
{
control4.Attributes.Add("class", this.SelectCss);
flag = true;
}
list2.Add(item);
}
}
}
}
if (!flag)
{
control4.Attributes.Add("href", this.CreateUrl(str3));
}
if (!this.LinkSelf)
{
control4.Attributes.Add("target", "_blank");
}
control4.RenderControl(writer);
}
WebControl control5 = new WebControl(HtmlTextWriterTag.Label);
control5.Controls.Add(new LiteralControl("</li>"));
control5.RenderControl(writer);
}
}
}
public abstract bool UpdateSku(AttributeValueInfo attributeValue);
protected ProductBrowseQuery GetProductBrowseQuery()
{
int num2;
ProductBrowseQuery entity = new ProductBrowseQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["categoryId"]))
{
int result = 0;
if (int.TryParse(this.Page.Request.QueryString["categoryId"], out result))
{
entity.CategoryId = new int?(result);
}
}
if (int.TryParse(this.Page.Request.QueryString["brand"], out num2))
{
entity.BrandId = new int?(num2);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["valueStr"]))
{
IList<AttributeValueInfo> list = new List<AttributeValueInfo>();
string str = Globals.HtmlEncode(Globals.UrlDecode(this.Page.Request.QueryString["valueStr"]));
string[] strArray = str.Split(new char[] { '-' });
if (!string.IsNullOrEmpty(str))
{
for (int i = 0; i < strArray.Length; i++)
{
string[] strArray2 = strArray[i].Split(new char[] { '_' });
if (((strArray2.Length > 0) && !string.IsNullOrEmpty(strArray2[1])) && (strArray2[1] != "0"))
{
AttributeValueInfo item = new AttributeValueInfo();
item.AttributeId = Convert.ToInt32(strArray2[0]);
item.ValueId = Convert.ToInt32(strArray2[1]);
list.Add(item);
}
}
}
entity.AttributeValues = list;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["isPrecise"]))
{
entity.IsPrecise = bool.Parse(Globals.UrlDecode(this.Page.Request.QueryString["isPrecise"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["keywords"]))
{
entity.Keywords = Globals.HtmlEncode(Globals.UrlDecode(this.Page.Request.QueryString["keywords"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["minSalePrice"]))
{
decimal num4 = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["minSalePrice"]), out num4))
{
entity.MinSalePrice = new decimal?(num4);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["maxSalePrice"]))
{
decimal num5 = 0M;
if (decimal.TryParse(Globals.UrlDecode(this.Page.Request.QueryString["maxSalePrice"]), out num5))
{
entity.MaxSalePrice = new decimal?(num5);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["productCode"]))
{
entity.ProductCode = Globals.HtmlEncode(Globals.UrlDecode(this.Page.Request.QueryString["productCode"]));
}
entity.PageIndex = this.pager.PageIndex;
entity.PageSize = this.rptProducts.PageSize;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrderBy"]))
{
entity.SortBy = Globals.HtmlEncode(this.Page.Request.QueryString["sortOrderBy"]);
}
else
{
entity.SortBy = "DisplaySequence";
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["sortOrder"]))
{
entity.SortOrder = (SortAction) Enum.Parse(typeof(SortAction), Globals.HtmlEncode(this.Page.Request.QueryString["sortOrder"]));
}
else
{
entity.SortOrder = SortAction.Desc;
}
Globals.EntityCoding(entity, true);
return entity;
}
public static bool UpdateAttributeValue(AttributeValueInfo attributeValue)
{
return new AttributeValueDao().UpdateAttributeValue(attributeValue);
}
public override AttributeValueInfo GetAttributeValueInfo(int valueId)
{
AttributeValueInfo info = new AttributeValueInfo();
DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT * FROM Hishop_AttributeValues WHERE ValueId=@ValueId");
database.AddInParameter(sqlStringCommand, "ValueId", DbType.Int32, valueId);
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateAttributeValue(reader);
info.ImageUrl = reader["ImageUrl"].ToString();
info.DisplaySequence = (int)reader["DisplaySequence"];
}
}
return info;
}
public override AttributeInfo GetAttribute(int attributeId)
{
AttributeInfo info = new AttributeInfo();
DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT * FROM Hishop_AttributeValues WHERE AttributeId = @AttributeId ORDER BY DisplaySequence DESC; SELECT * FROM Hishop_Attributes WHERE AttributeId = @AttributeId;");
database.AddInParameter(sqlStringCommand, "AttributeId", DbType.Int32, attributeId);
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
IList<AttributeValueInfo> list = new List<AttributeValueInfo>();
while (reader.Read())
{
AttributeValueInfo item = new AttributeValueInfo();
item.ValueId = (int)reader["ValueId"];
item.AttributeId = (int)reader["AttributeId"];
item.DisplaySequence = (int)reader["DisplaySequence"];
item.ValueStr = (string)reader["ValueStr"];
if (reader["ImageUrl"] != DBNull.Value)
{
item.ImageUrl = (string)reader["ImageUrl"];
}
list.Add(item);
}
if (!reader.NextResult())
{
return info;
}
if (reader.Read())
{
info.AttributeId = (int)reader["AttributeId"];
info.AttributeName = (string)reader["AttributeName"];
info.DisplaySequence = (int)reader["DisplaySequence"];
info.TypeId = (int)reader["TypeId"];
info.UsageMode = (AttributeUseageMode)((int)reader["UsageMode"]);
info.UseAttributeImage = (bool)reader["UseAttributeImage"];
info.AttributeValues = list;
}
}
return info;
}
public static int AddAttributeValue(AttributeValueInfo attributeValue)
{
return new AttributeValueDao().AddAttributeValue(attributeValue);
}
protected void btnCreateValue_Click(object sender, EventArgs e)
{
AttributeValueInfo attributeValue = new AttributeValueInfo();
IList<AttributeValueInfo> list = new List<AttributeValueInfo>();
int num = int.Parse(this.currentAttributeId.Value);
attributeValue.AttributeId = num;
if (!(this.Page.Request.QueryString["action"].ToString().Trim() == "add"))
{
this.valueId = int.Parse(this.Page.Request.QueryString["valueId"]);
attributeValue = ProductTypeHelper.GetAttributeValueInfo(this.valueId);
if (ProductTypeHelper.GetAttribute(attributeValue.AttributeId).UseAttributeImage)
{
if (!string.IsNullOrEmpty(this.txtValueDec.Text))
{
attributeValue.ValueStr = Globals.HtmlEncode(this.txtValueDec.Text);
}
}
else if (!string.IsNullOrEmpty(this.txtValueStr.Text))
{
attributeValue.ValueStr = Globals.HtmlEncode(this.txtValueStr.Text);
}
if (this.fileUpload.HasFile)
{
try
{
StoreHelper.DeleteImage(attributeValue.ImageUrl);
attributeValue.ImageUrl = ProductTypeHelper.UploadSKUImage(this.fileUpload.PostedFile);
}
catch
{
}
}
if (ProductTypeHelper.UpdateAttributeValue(attributeValue))
{
this.CloseWindow();
}
}
else
{
if (!string.IsNullOrEmpty(this.txtValueStr.Text.Trim()))
{
string[] strArray = this.txtValueStr.Text.Trim().Split(new char[] { ',' });
for (int i = 0; i < strArray.Length; i++)
{
if (strArray[i].Trim().Length > 100)
{
break;
}
AttributeValueInfo item = new AttributeValueInfo();
if (strArray[i].Trim().Length > 15)
{
this.ShowMsg("属性值限制在15个字符以内", false);
return;
}
item.ValueStr = Globals.HtmlEncode(strArray[i].Trim());
item.AttributeId = num;
list.Add(item);
}
foreach (AttributeValueInfo info3 in list)
{
ProductTypeHelper.AddAttributeValue(info3);
}
this.CloseWindow();
}
if (this.fileUpload.HasFile)
{
try
{
attributeValue.ImageUrl = ProductTypeHelper.UploadSKUImage(this.fileUpload.PostedFile);
attributeValue.ValueStr = Globals.HtmlEncode(this.txtValueDec.Text);
}
catch
{
}
if (ProductTypeHelper.AddAttributeValue(attributeValue) > 0)
{
this.CloseWindow();
}
}
else
{
this.ShowMsg("属性值限制在15个字符以内", false);
}
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (this.txtName.Text.Trim().Length > 15)
{
string str = string.Format("ShowMsg(\"{0}\", {1});", "属性名称限制在15个字符以内", "false");
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript2", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str + "},300);</script>");
}
else
{
AttributeInfo info3 = new AttributeInfo();
info3.TypeId = this.typeId;
info3.AttributeName = Globals.HtmlEncode(this.txtName.Text.Trim());
AttributeInfo target = info3;
if (this.chkMulti.Checked)
{
target.UsageMode = AttributeUseageMode.MultiView;
}
else
{
target.UsageMode = AttributeUseageMode.View;
}
if (!string.IsNullOrEmpty(this.txtValues.Text.Trim()))
{
string[] strArray = this.txtValues.Text.Trim().Split(new char[] { ',' });
for (int i = 0; i < strArray.Length; i++)
{
if (strArray[i].Length > 100)
{
break;
}
AttributeValueInfo item = new AttributeValueInfo();
if (strArray[i].Length > 15)
{
string str2 = string.Format("ShowMsg(\"{0}\", {1});", "属性值限制在15个字符以内", "false");
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ServerMessageScript2", "<script language='JavaScript' defer='defer'>setTimeout(function(){" + str2 + "},300);</script>");
return;
}
item.ValueStr = Globals.HtmlEncode(strArray[i]);
target.AttributeValues.Add(item);
}
}
ValidationResults results = Hishop.Components.Validation.Validation.Validate<AttributeInfo>(target, new string[] { "ValAttribute" });
string str3 = string.Empty;
if (!results.IsValid)
{
foreach (ValidationResult result in (IEnumerable<ValidationResult>)results)
{
str3 = str3 + Formatter.FormatErrorMessage(result.Message);
}
}
else if (ProductTypeHelper.AddAttribute(target))
{
this.txtName.Text = string.Empty;
this.txtValues.Text = string.Empty;
base.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
}
}
