public IList <ProductTypeInfo> GetProductTypesList()
{
using (MyContext db = new MyContext())
{
var items = db.ProductType.ToList();
IList <ProductTypeInfo> ProductTypeInfos = new List <ProductTypeInfo>();
foreach (var item in items)
{
ProductTypeInfo info = new ProductTypeInfo();
info.ID = item.ID;
info.ProductTypeName = item.ProductTypeName;
info.Description = item.Description;
ProductTypeInfos.Add(info);
}
return(ProductTypeInfos);
}
}
public void CreateProductTypeTest()
{
Random rand = new Random();
String createString = "Super deep v turtle neck " + rand.Next(1000);
List <string> errors = new List <string>(); // TODO: Initialize to an appropriate value
List <string> errorsExpected = new List <string>(); // TODO: Initialize to an appropriate value
int result = BLProductType.CreateProductType(createString, ref errors);
Assert.AreNotEqual(result, -1);
AsynchLog.LogNow(errors);
ProductTypeInfo ProductType = BLProductType.ReadProductType(result, ref errors);
AsynchLog.LogNow(errors);
Assert.AreEqual(ProductType.product_type_id, result);
Assert.AreEqual(ProductType.product_type_name, createString);
}
public static int AddProductType(ProductTypeInfo productType)
{
if (productType == null)
{
return(0);
}
Globals.EntityCoding(productType, true);
int typeId = new ProductTypeDao().AddProductType(productType);
if (typeId > 0)
{
if (productType.Brands.Count > 0)
{
new ProductTypeDao().AddProductTypeBrands(typeId, productType.Brands);
}
EventLogs.WriteOperationLog(Privilege.AddProductType, string.Format(CultureInfo.InvariantCulture, "创建了一个新的商品类型:”{0}”", new object[] { productType.TypeName }));
}
return(typeId);
}
public int AddProductType(ProductTypeInfo productType)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Ecshop_ProductTypes(TypeName, Remark) VALUES (@TypeName, @Remark); SELECT @@IDENTITY");
this.database.AddInParameter(sqlStringCommand, "TypeName", DbType.String, productType.TypeName);
this.database.AddInParameter(sqlStringCommand, "Remark", DbType.String, productType.Remark);
object obj = this.database.ExecuteScalar(sqlStringCommand);
int result;
if (obj != null)
{
result = Convert.ToInt32(obj);
}
else
{
result = 0;
}
return(result);
}
public static bool UpdateProductType(ProductTypeInfo productType)
{
if (productType == null)
{
return(false);
}
Globals.EntityCoding(productType, true);
bool flag = new ProductTypeDao().UpdateProductType(productType);
if (flag)
{
if (new ProductTypeDao().DeleteProductTypeBrands(productType.TypeId))
{
new ProductTypeDao().AddProductTypeBrands(productType.TypeId, productType.Brands);
}
EventLogs.WriteOperationLog(Privilege.EditProductType, string.Format(CultureInfo.InvariantCulture, "修改了编号为”{0}”的商品类型", new object[] { productType.TypeId }));
}
return(flag);
}
//修改产品类型
public void EditProductType()
{
int ProductType_ID = tools.CheckInt(Request.Form["ProductType_ID"]);
string ProductType_Name = tools.CheckStr(Request.Form["ProductType_Name"]);
int ProductType_Sort = tools.CheckInt(Request.Form["ProductType_Sort"]);
int ProductType_IsActive = tools.CheckInt(Request.Form["ProductType_IsActive"]);
string ProductType_Site = Public.GetCurrentSite();
string brand_select = tools.CheckStr(Request.Form["ProductType_Brand"]) + ",";
string[] Product_Brand = brand_select.Split(',');
if (ProductType_Name == "")
{
Public.Msg("error", "错误信息", "请填写类型名称！", false, "{back}");
}
ProductTypeInfo entity = new ProductTypeInfo();
entity.ProductType_ID = ProductType_ID;
entity.ProductType_Name = ProductType_Name;
entity.ProductType_Sort = ProductType_Sort;
entity.ProductType_IsActive = ProductType_IsActive;
entity.ProductType_Site = ProductType_Site;
if (MyProductType.EditProductType(entity, Public.GetUserPrivilege()))
{
MyProductType.DelProductType_Brand(entity.ProductType_ID, Public.GetUserPrivilege());
foreach (string i in Product_Brand)
{
if (tools.CheckInt(i) > 0)
{
MyProductType.AddProductType_Brand(entity.ProductType_ID, tools.CheckInt(i), Public.GetUserPrivilege());
}
}
Public.Msg("positive", "操作成功", "操作成功", true, "ProductType.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual ProductTypeInfo GetProductTypeByID(int ID)
{
ProductTypeInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM ProductType WHERE ProductType_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new ProductTypeInfo();
entity.ProductType_ID = Tools.NullInt(RdrList["ProductType_ID"]);
entity.ProductType_Name = Tools.NullStr(RdrList["ProductType_Name"]);
entity.ProductType_Sort = Tools.NullInt(RdrList["ProductType_Sort"]);
entity.ProductType_IsActive = Tools.NullInt(RdrList["ProductType_IsActive"]);
entity.ProductType_Site = Tools.NullStr(RdrList["ProductType_Site"]);
}
RdrList.Close();
RdrList = null;
if (entity != null)
{
entity.BrandInfos = GetProductBrands(entity.ProductType_ID);
entity.ProductTypeExtendInfos = MyProductTypeExtend.GetProductTypeExtends(entity.ProductType_ID);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public void CreateTypeMethodTest()
{
var type = new ProductTypeInfo
{
IsSupportColor = true,
IsSupportSize = true,
IsSupportVersion = false,
Name = "鞋子",
SpecificationValueInfo = new List <SpecificationValueInfo> {
new SpecificationValueInfo {
Specification = SpecificationType.Color, Value = "红色,蓝色"
},
new SpecificationValueInfo {
Specification = SpecificationType.Size, Value = "S,M,XX"
}
},
AttributeInfo = new List <AttributeInfo> {
new AttributeInfo {
Name = "a", IsMulti = true, DisplaySequence = 1, AttributeValueInfo = new List <AttributeValueInfo>
{
new AttributeValueInfo {
Value = "aa", DisplaySequence = 1
},
new AttributeValueInfo {
Value = "aaa", DisplaySequence = 1
},
}
}
},
TypeBrandInfo = new List <TypeBrandInfo>
{
new TypeBrandInfo {
BrandId = 1
},
new TypeBrandInfo {
BrandId = 11
}
}
};
ServiceProvider.Instance <ITypeService> .Create.AddType(type);
}
public void UpdateType(ProductTypeInfo model)
{
//更新品牌
ProcessingBrand(model);
//更新的属性、属性值
ProcessingAttr(model);
//更新规格
ProcessingSpecificationValues(model);
//更新常用属性
ProcessingCommon(model);
//提交保存
Context.SaveChanges();
Cache.Remove(CacheKeyCollection.CACHE_ATTRIBUTE_LIST);
Cache.Remove(CacheKeyCollection.CACHE_ATTRIBUTEVALUE_LIST);
}
private void ProcessingSpecificationValues(ProductTypeInfo model)
{
if (model.IsSupportColor)
{
this.UpdateSpecificationValues(model, SpecificationType.Color);
}
if (model.IsSupportSize)
{
this.UpdateSpecificationValues(model, SpecificationType.Size);
}
if (model.IsSupportVersion)
{
this.UpdateSpecificationValues(model, SpecificationType.Version);
}
ProductTypeInfo isSupportVersion = this.context.ProductTypeInfo.FindById <ProductTypeInfo>(model.Id);
isSupportVersion.IsSupportVersion = model.IsSupportVersion;
isSupportVersion.IsSupportColor = model.IsSupportColor;
isSupportVersion.IsSupportSize = model.IsSupportSize;
}
public override IList <ProductTypeInfo> GetProductTypes()
{
IList <ProductTypeInfo> list = new List <ProductTypeInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_ProductTypes");
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
while (reader.Read())
{
ProductTypeInfo item = new ProductTypeInfo
{
TypeId = (int)reader["TypeId"],
TypeName = (string)reader["TypeName"],
Remark = (string)reader["Remark"]
};
list.Add(item);
}
}
return(list);
}
private static MvcHtmlString GenerateSize(ProductTypeInfo model)
{
StringBuilder htmlTag = new StringBuilder();
//string input = "<label class=\"label-custom\"><input class=\"specCheckbox\" type=\"checkbox\" value=\"{0}\" {1} name=\"IsSupportSize\" />尺寸</label>";
string input = "<label class=\"label-custom\"><input class=\"specCheckbox\" type=\"checkbox\" value=\"{0}\" {1} name=\"IsSupportSize\" /><input type=\"text\" class=\"form-control input-sm\" name=\"SizeAlias\" value=\"{2}\" maxlength=\"10\" {3} /></label>";
//string input = "<label class=\"label-custom\"><input class=\"specCheckbox\" type=\"checkbox\" value=\"{0}\" {1} name=\"IsSupportSize\" /><textarea class=\"input-sm\" name=\"SizeAlias\" rows=\"1\">{2}</textarea></label>";
string text = "<textarea class=\"form-control input-sm\" {0} name=\"SizeValue\" rows=\"2\">{1}</textarea>";
if (model.IsSupportSize)
{
htmlTag.Append(string.Format(input, true, "checked", string.IsNullOrEmpty(model.SizeAlias) ? "尺寸" : model.SizeAlias, ""));
htmlTag.Append(string.Format(text, "", model.SizeValue));
}
else
{
htmlTag.Append(string.Format(input, false, "", string.IsNullOrEmpty(model.SizeAlias) ? "尺寸" : model.SizeAlias, "disabled"));
htmlTag.Append(string.Format(text, "disabled", model.SizeValue));
}
return(new MvcHtmlString(htmlTag.ToString()));
}
/// <summary>
/// 根据提货码取订单
/// </summary>
/// <param name="pickcode"></param>
/// <returns></returns>
public object GetShopBranchOrder(string pickcode)
{
CheckUserLogin();
var order = Application.OrderApplication.GetOrderByPickCode(pickcode);
if (order == null)
{
return(Json(new { success = false, msg = "该提货码无效" }));
}
if (order.ShopBranchId.Value != CurrentShopBranch.Id)
{
return(Json(new { success = false, msg = "非本门店提货码，请买家核对提货信息" }));
}
if (order.OrderStatus == Himall.Model.OrderInfo.OrderOperateStatus.Finish && order.DeliveryType == CommonModel.Enum.DeliveryType.SelfTake)
{
return(Json(new { success = false, msg = "该提货码于" + order.FinishDate.ToString() + "已核销" }));
}
var orderItem = Application.OrderApplication.GetOrderItemsByOrderId(order.Id);
foreach (var item in orderItem)
{
item.ThumbnailsUrl = Core.HimallIO.GetRomoteProductSizeImage(item.ThumbnailsUrl, 1, (int)Himall.CommonModel.ImageSize.Size_100);
ProductTypeInfo typeInfo = ServiceProvider.Instance <ITypeService> .Create.GetTypeByProductId(item.ProductId);
item.ColorAlias = (typeInfo == null || string.IsNullOrEmpty(typeInfo.ColorAlias)) ? SpecificationType.Color.ToDescription() : typeInfo.ColorAlias;
item.SizeAlias = (typeInfo == null || string.IsNullOrEmpty(typeInfo.SizeAlias)) ? SpecificationType.Size.ToDescription() : typeInfo.SizeAlias;
item.VersionAlias = (typeInfo == null || string.IsNullOrEmpty(typeInfo.VersionAlias)) ? SpecificationType.Version.ToDescription() : typeInfo.VersionAlias;
}
//退款状态
var refundobjs = OrderApplication.GetOrderRefunds(orderItem.Select(e => e.Id));
//小于4表示商家未确认；与平台未审核，都算退款、退货中
var refundProcessing = refundobjs.Where(e => (int)e.SellerAuditStatus < 4 || e.ManagerConfirmStatus == OrderRefundInfo.OrderRefundConfirmStatus.UnConfirm);
if (refundProcessing.Count() > 0)
{
order.RefundStats = 1;
}
return(Json(new { success = true, order = order, orderItem = orderItem }));
}
private void UpdateSpecificationValues(ProductTypeInfo model, SpecificationType specEnum)
{
var newSpec = model.SpecificationValueInfo.Where(s => s.Specification == specEnum);
var actual = Context.SpecificationValueInfo
.Where(s => s.TypeId.Equals(model.Id) && s.Specification == specEnum).AsEnumerable();
var deleteSpec = actual.Except(newSpec, new SpecValueComparer());
foreach (var specV in deleteSpec.ToList())
{
Context.SpecificationValueInfo.Remove(specV);
}
var addSpec = newSpec.Except(actual, new SpecValueComparer());
foreach (var specV in addSpec.ToList())
{
Context.SpecificationValueInfo.Add(specV);
}
}
public static List <ProductTypeInfo> ReadProductTypeList(ref List <string> errors)
{
SqlConnection conn = new SqlConnection(connection_string);
ProductTypeInfo ProductType = null;
List <ProductTypeInfo> ProductTypeList = new List <ProductTypeInfo>();
try
{
string strSQL = "read_all_product_type";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet myDS = new DataSet();
mySA.Fill(myDS);
if (myDS.Tables[0].Rows.Count == 0)
{
return(null);
}
for (int i = 0; i < myDS.Tables[0].Rows.Count; i++)
{
ProductType = new ProductTypeInfo(int.Parse(myDS.Tables[0].Rows[i]["product_type_id"].ToString()),
myDS.Tables[0].Rows[i]["product_type_name"].ToString());
ProductTypeList.Add(ProductType);
}
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
return(ProductTypeList);
}
private void btnEditProductType_Click(object sender, EventArgs e)
{
ProductTypeInfo productType = new ProductTypeInfo();
productType.TypeId = typeId;
productType.TypeName = txtTypeName.Text;
productType.Remark = txtRemark.Text;
IList <int> list = new List <int>();
foreach (ListItem item in chlistBrand.Items)
{
if (item.Selected)
{
list.Add(int.Parse(item.Value));
}
}
productType.Brands = list;
if (ValidationProductType(productType) && ProductTypeHelper.UpdateProductType(productType))
{
ShowMsg("修改成功", true);
}
}
private void btnAddProductType_Click(object sender, EventArgs e)
{
ProductTypeInfo productTypeInfo = new ProductTypeInfo();
productTypeInfo.TypeName = Globals.StripHtmlXmlTags(Globals.StripScriptTags(this.txtTypeName.Text).Replace("，", ",").Replace("\\", ""));
if (string.IsNullOrEmpty(productTypeInfo.TypeName))
{
this.ShowMsg("类型名称不能为空，不允许包含脚本标签、HTML标签和\\，系统会自动过滤", false);
}
else if (ProductTypeHelper.HasSameProductTypeName(productTypeInfo.TypeName, 0))
{
this.ShowMsg("不能有重复的类型名称", false);
}
else
{
productTypeInfo.Remark = this.txtRemark.Text;
IList <int> list = new List <int>();
foreach (ListItem item in this.chlistBrand.Items)
{
if (item.Selected)
{
list.Add(int.Parse(item.Value));
}
}
productTypeInfo.Brands = list;
if (this.ValidationProductType(productTypeInfo))
{
int num = ProductTypeHelper.AddProductType(productTypeInfo);
if (num > 0)
{
base.Response.Redirect(Globals.GetAdminAbsolutePath("/product/AddAttribute.aspx?typeId=" + num), true);
}
else
{
this.ShowMsg("添加商品类型失败", false);
}
}
}
}
private void ProcessingAttrUpdate(ProductTypeInfo model)
{
ProductTypeInfo productTypeInfo = context.ProductTypeInfo.FindById <ProductTypeInfo>(model.Id);
foreach (AttributeInfo list in model.AttributeInfo.ToList())
{
if (!productTypeInfo.AttributeInfo.Any((AttributeInfo a) => {
if (!a.Id.Equals(list.Id))
{
return(false);
}
return(list.Id != 0);
}))
{
continue;
}
AttributeInfo name = productTypeInfo.AttributeInfo.FirstOrDefault((AttributeInfo a) => a.Id.Equals(list.Id));
name.Name = list.Name;
name.IsMulti = list.IsMulti;
IEnumerable <AttributeValueInfo> attributeValueInfos = name.AttributeValueInfo.Except <AttributeValueInfo>(list.AttributeValueInfo, new AttrValueComparer());
if (attributeValueInfos != null && 0 < attributeValueInfos.Count())
{
foreach (AttributeValueInfo attributeValueInfo in attributeValueInfos.ToList())
{
context.AttributeValueInfo.Remove(attributeValueInfo);
}
}
IEnumerable <AttributeValueInfo> attributeValueInfos1 = list.AttributeValueInfo.Except <AttributeValueInfo>(name.AttributeValueInfo, new AttrValueComparer());
if (attributeValueInfos1 == null || 0 >= attributeValueInfos1.Count())
{
continue;
}
foreach (AttributeValueInfo id in attributeValueInfos1.ToList())
{
id.AttributeId = list.Id;
context.AttributeValueInfo.Add(id);
}
}
}
public static ProductTypeInfo ReadProductTypeDetail(int product_type_id, ref List <string> errors)
{
SqlConnection conn = new SqlConnection(connection_string);
ProductTypeInfo ProductType = null;
try
{
string strSQL = "read_product_type";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
mySA.SelectCommand.Parameters.Add(new SqlParameter("@product_type_id", SqlDbType.Int));
mySA.SelectCommand.Parameters["@product_type_id"].Value = product_type_id;
DataSet myDS = new DataSet();
mySA.Fill(myDS);
if (myDS.Tables[0].Rows.Count == 0)
{
return(null);
}
ProductType = new ProductTypeInfo(int.Parse(myDS.Tables[0].Rows[0]["product_type_id"].ToString()),
myDS.Tables[0].Rows[0]["product_type_name"].ToString());
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
return(ProductType);
}
private void btnEditProductType_Click(object sender, System.EventArgs e)
{
ProductTypeInfo productType = new ProductTypeInfo
{
TypeId = this.typeId,
TypeName = this.txtTypeName.Text,
Remark = this.txtRemark.Text
};
System.Collections.Generic.IList <int> list = new System.Collections.Generic.List <int>();
foreach (System.Web.UI.WebControls.ListItem item in this.chlistBrand.Items)
{
if (item.Selected)
{
list.Add(int.Parse(item.Value));
}
}
productType.Brands = list;
if (this.ValidationProductType(productType) && ProductTypeHelper.UpdateProductType(productType))
{
this.ShowMsg("修改成功", true);
}
}
private void UpdateSpecificationValues(ProductTypeInfo model, SpecificationType specEnum)
{
IEnumerable <SpecificationValueInfo> specificationValueInfo =
from s in model.SpecificationValueInfo
where s.Specification == specEnum
select s;
IEnumerable <SpecificationValueInfo> specificationValueInfos = (
from s in context.SpecificationValueInfo
where s.TypeId.Equals(model.Id) && (int)s.Specification == (int)specEnum
select s).AsEnumerable <SpecificationValueInfo>();
IEnumerable <SpecificationValueInfo> specificationValueInfos1 = specificationValueInfos.Except <SpecificationValueInfo>(specificationValueInfo, new SpecValueComparer());
foreach (SpecificationValueInfo list in specificationValueInfos1.ToList())
{
context.SpecificationValueInfo.Remove(list);
}
IEnumerable <SpecificationValueInfo> specificationValueInfos2 = specificationValueInfo.Except <SpecificationValueInfo>(specificationValueInfos, new SpecValueComparer());
foreach (SpecificationValueInfo list1 in specificationValueInfos2.ToList())
{
context.SpecificationValueInfo.Add(list1);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (isPValid())
{
try
{
int OpId = Convert.ToInt32(Request["OfferPriceId"].ToString());
ProductTypeInfo product = new ProductTypeInfo();
product.OfferPriceId = OpId;
product.ProductName = txtName.Text.ToString();
product.Model = txtModel.Text.ToString();
product.Num = txtNum.Text.ToString();
product.Price = txtPrice.Text.ToString();
product.Unit = ddlPUnit.SelectedItem.Text;
float fNum = float.Parse(txtNum.Text.ToString());
float fPrice = float.Parse(txtPrice.Text.ToString());
float fSum = fNum * fPrice;
product.Sums = fSum.ToString();
product.Save();
gvProductBind();
string str = OfferPriceInfo.GetProductMoneySum(OpId);
if (str == "")
{
lblMoneySum.Text = "0元";
}
else
{
lblMoneySum.Text = OfferPriceInfo.GetProductMoneySum(OpId) + "元";
}
Clear();
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('新增失败：" + Ex.Message + "');", true);
}
}
}
public IList <ProductTypeInfo> GetProductTypesList(int pageIndex, int pageSize, out int Total)
{
using (MyContext db = new MyContext())
{
Total = (from c in db.ProductType
orderby c.ID
select c).Count();
var items = (from c in db.ProductType
orderby c.ID
select c).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
IList <ProductTypeInfo> ProductTypeInfos = new List <ProductTypeInfo>();
foreach (var item in items)
{
ProductTypeInfo info = new ProductTypeInfo();
info.ID = item.ID;
info.ProductTypeName = item.ProductTypeName;
info.Description = item.Description;
ProductTypeInfos.Add(info);
}
return(ProductTypeInfos);
}
}
public static int AddProductType(ProductTypeInfo productType)
{
if (productType == null)
{
return(0);
}
ProductTypeDao productTypeDao = new ProductTypeDao();
Globals.EntityCoding(productType, true);
int num = (int)productTypeDao.Add(productType, null);
if (num > 0)
{
if (productType.Brands.Count > 0)
{
productTypeDao.AddProductTypeBrands(num, productType.Brands);
}
EventLogs.WriteOperationLog(Privilege.AddProductType, string.Format(CultureInfo.InvariantCulture, "创建了一个新的商品类型:”{0}”", new object[1]
{
productType.TypeName
}), false);
}
return(num);
}
/// <summary>
/// 根据选择分类获取对应的品牌列表
/// </summary>
protected void GetBrandList()
{
int classId = RequestHelper.GetQueryString <int>("classId");
string brandname = RequestHelper.GetQueryString <string>("brandname");
int proTypeID = ProductClassBLL.GetProductClassType(classId);
ProductTypeInfo aci = ProductTypeBLL.Read(proTypeID);
List <ProductBrandInfo> productBrandList = new List <ProductBrandInfo>();
if (aci.Id > 0)
{
string[] strArray = aci.BrandIds.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
int[] intArray;
intArray = Array.ConvertAll <string, int>(strArray, s => int.Parse(s));
productBrandList = ProductBrandBLL.ReadList(intArray);
if (!string.IsNullOrEmpty(brandname))
{
productBrandList = productBrandList.Where(k => k.Name.ToLower().Contains(brandname.ToLower())).ToList();
}
}
Response.Clear();
ResponseHelper.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { count = productBrandList.Count, dataList = productBrandList }));
Response.End();
}
private void ProcessingAttrDeleteAndAdd(ProductTypeInfo model)
{
ProductTypeInfo productTypeInfo = this.context.ProductTypeInfo.FindById <ProductTypeInfo>(model.Id);
List <AttributeInfo> list = productTypeInfo.AttributeInfo.Except <AttributeInfo>(model.AttributeInfo, new AttrComparer()).ToList <AttributeInfo>();
foreach (AttributeInfo attributeInfo in list)
{
IQueryable <AttributeValueInfo> attributeValueInfos = this.context.AttributeValueInfo.FindBy <AttributeValueInfo>((AttributeValueInfo a) => a.AttributeId.Equals(attributeInfo.Id));
foreach (AttributeValueInfo attributeValueInfo in attributeValueInfos.ToList <AttributeValueInfo>())
{
this.context.AttributeValueInfo.Remove(attributeValueInfo);
}
this.context.AttributeInfo.Remove(attributeInfo);
}
List <AttributeInfo> attributeInfos = model.AttributeInfo.Except <AttributeInfo>(productTypeInfo.AttributeInfo, new AttrComparer()).ToList <AttributeInfo>();
if ((attributeInfos == null ? false : attributeInfos.Count <AttributeInfo>() > 0))
{
foreach (AttributeInfo attributeInfo1 in attributeInfos)
{
this.context.AttributeInfo.Add(attributeInfo1);
}
}
}
public virtual ProductTypeInfo GetProductTypeMax()
{
ProductTypeInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT top 1 * FROM ProductType order by ProductType_ID desc";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new ProductTypeInfo();
entity.ProductType_ID = Tools.NullInt(RdrList["ProductType_ID"]);
entity.ProductType_Name = Tools.NullStr(RdrList["ProductType_Name"]);
entity.ProductType_Sort = Tools.NullInt(RdrList["ProductType_Sort"]);
entity.ProductType_IsActive = Tools.NullInt(RdrList["ProductType_IsActive"]);
entity.ProductType_Site = Tools.NullStr(RdrList["ProductType_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditProductType(ProductTypeInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM ProductType WHERE ProductType_ID = " + entity.ProductType_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["ProductType_ID"] = entity.ProductType_ID;
DrAdd["ProductType_Name"] = entity.ProductType_Name;
DrAdd["ProductType_Sort"] = entity.ProductType_Sort;
DrAdd["ProductType_IsActive"] = entity.ProductType_IsActive;
DrAdd["ProductType_Site"] = entity.ProductType_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
public virtual bool EditProductType(ProductTypeInfo entity, RBACUserInfo UserPrivilege)
{
return(MyDAL.EditProductType(entity));
}
public object GetCartProduct(string openId = "")
{
CheckUserLogin();
var cartHelper = ServiceProvider.Instance <ICartService> .Create;
var cart = cartHelper.GetCart(CurrentUser.Id);
var productService = ServiceProvider.Instance <IProductService> .Create;
var shopService = ServiceProvider.Instance <IShopService> .Create;
var vshopService = ServiceProvider.Instance <IVShopService> .Create;
var siteSetting = ServiceProvider.Instance <ISiteSettingService> .Create.GetSiteSettings();
var typeservice = ServiceProvider.Instance <ITypeService> .Create;
List <CartProductModel> products = new List <CartProductModel>();
//会员折扣
decimal discount = 1.0M;//默认折扣为1（没有折扣）
if (CurrentUser != null)
{
discount = CurrentUser.MemberDiscount;
}
decimal prodPrice = 0.0M; //优惠价格
var limitProducts = LimitTimeApplication.GetPriceByProducrIds(cart.Items.Select(e => e.ProductId).ToList()); //限时购价格
foreach (var item in cart.Items)
{
var product = productService.GetProduct(item.ProductId);
var shop = shopService.GetShop(product.ShopId);
if (null != shop)
{
var vshop = vshopService.GetVShopByShopId(shop.Id);
SKUInfo sku = productService.GetSku(item.SkuId);
if (sku == null)
{
continue;
}
//处理限时购、会员折扣价格
var prod = limitProducts.FirstOrDefault(e => e.ProductId == item.ProductId);
prodPrice = sku.SalePrice;
if (prod != null)
{
prodPrice = prod.MinPrice;
}
else
{
if (shop.IsSelf)
{//官方自营店才计算会员折扣
prodPrice = sku.SalePrice * discount;
}
}
ProductTypeInfo typeInfo = typeservice.GetType(product.TypeId);
string colorAlias = (typeInfo == null || string.IsNullOrEmpty(typeInfo.ColorAlias)) ? SpecificationType.Color.ToDescription() : typeInfo.ColorAlias;
string sizeAlias = (typeInfo == null || string.IsNullOrEmpty(typeInfo.SizeAlias)) ? SpecificationType.Size.ToDescription() : typeInfo.SizeAlias;
string versionAlias = (typeInfo == null || string.IsNullOrEmpty(typeInfo.VersionAlias)) ? SpecificationType.Version.ToDescription() : typeInfo.VersionAlias;
if (sku != null)
{
var _tmp = new CartProductModel
{
CartItemId = item.Id.ToString(),
SkuId = item.SkuId,
Id = product.Id.ToString(),
ImgUrl = Core.HimallIO.GetRomoteProductSizeImage(product.RelativePath, 1, (int)Himall.CommonModel.ImageSize.Size_150),
Name = product.ProductName,
Price = prodPrice.ToString("F2"),
Count = item.Quantity.ToString(),
ShopId = shop.Id.ToString(),
Size = sku.Size,
Color = sku.Color,
Version = sku.Version,
VShopId = vshop == null ? "0" : vshop.Id.ToString(),
ShopName = shop.ShopName,
ShopLogo = vshop == null ? "" : Core.HimallIO.GetRomoteImagePath(vshop.Logo),
Url = Core.HimallIO.GetRomoteImagePath("/m-IOS/product/detail/") + item.ProductId,
IsValid = (product.AuditStatus == ProductInfo.ProductAuditStatus.Audited && product.SaleStatus == ProductInfo.ProductSaleStatus.OnSale) ? 1 : 0,
ColorAlias = colorAlias,
SizeAlias = sizeAlias,
VersionAlias = versionAlias,
AddTime = item.AddTime
};
products.Add(_tmp);
}
}
}
products = products.OrderBy(item => item.ShopId).ThenByDescending(o => o.AddTime).ToList();
var cartShop = products.GroupBy(item => item.ShopId);
var cartModel = new { Status = "OK", Data = cartShop };
return(Json(cartModel));//原api返回
}