/// <summary>
/// 添加产品类别
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(ProductCategoryEntity entity)
{
entity.IncludeAll();
int line = this.ProductCategory.Add(entity);
if (line > 0)
{
CacheHelper.Remove(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE);
}
return line;
}
public static ProductCategory_CE ToCE(ProductCategoryEntity item)
{
ProductCategory_CE target = new ProductCategory_CE();
target.ID=item.ID;
target.CateNum=item.CateNum;
target.CateName=item.CateName;
target.IsDelete=item.IsDelete;
target.CreateTime=item.CreateTime;
target.CreateUser=item.CreateUser;
target.Remark=item.Remark;
return target;
}
/// <summary>
/// 批量删除产品类型
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int DelBat(List<string> list)
{
using (TransactionScope ts = new TransactionScope())
{
int line = 0;
foreach (string cateNum in list)
{
ProductCategoryEntity entity = new ProductCategoryEntity();
entity.Where(a => a.CateNum == cateNum);
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
line += this.ProductCategory.Update(entity);
}
ts.Complete();
if (line > 0)
{
CacheHelper.Remove(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE);
}
return line;
}
}
/// <summary>
/// 修改产品类别
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(ProductCategoryEntity entity)
{
entity.IncludeCateName(true).IncludeRemark(true)
.Where(a => a.CateNum == entity.CateNum)
;
int line = this.ProductCategory.Update(entity);
if (line > 0)
{
CacheHelper.Remove(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE);
}
return line;
}
/// <summary>
/// 查询产品类别分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<ProductCategoryEntity> GetList(ProductCategoryEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity.OrderBy(a => a.ID, EOrderBy.DESC);
int rowCount = 0;
List<ProductCategoryEntity> list = this.ProductCategory.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
if (!list.IsNullOrEmpty())
{
AdminProvider adminProvider = new AdminProvider();
foreach (ProductCategoryEntity item in list)
{
if (!item.CreateUser.IsEmpty())
{
AdminEntity admin = adminProvider.GetAdmin(item.CreateUser);
item.CreateUser = admin.IsNotNull() ? admin.UserName : item.CreateUser;
}
}
}
return list;
}
/// <summary>
/// 查询所有的产品类别
/// </summary>
/// <returns></returns>
public List<ProductCategoryEntity> GetList()
{
List<ProductCategoryEntity> list = CacheHelper.Get(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE) as List<ProductCategoryEntity>;
if (!list.IsNullOrEmpty())
{
return list;
}
ProductCategoryEntity entity = new ProductCategoryEntity();
entity.OrderBy(a => a.ID, EOrderBy.DESC);
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
list = this.ProductCategory.GetList(entity);
if (!list.IsNullOrEmpty())
{
CacheHelper.Insert(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE, list);
}
return list;
}
/// <summary>
/// 根据产品类别删除删除
/// </summary>
/// <param name="cateNum"></param>
/// <returns></returns>
public int Delete(string cateNum)
{
ProductCategoryEntity entity = new ProductCategoryEntity();
entity.Where(a => a.CateNum == cateNum);
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
int line = this.ProductCategory.Update(entity);
if (line > 0)
{
CacheHelper.Remove(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE);
}
return line;
}
private static void GetProCatInfo(System.Data.DataSet dataset, List<ProductEntity> list)
{
var rows = dataset.Tables[0].Rows;
if (rows.Count > 2)
{
ProductCategoryProvider ProductCategory = new ProductCategoryProvider();
for (var i = 2; i < rows.Count; i++)
{
ProductEntity entity = new ProductEntity();
ProductCategoryEntity PCEntity = new ProductCategoryEntity();
var row = rows[i];
entity.SnNum = row[1].ToString();
if (string.IsNullOrEmpty(entity.SnNum)) continue;
entity.BarCode = row[2].ToString();
entity.ProductName = row[3].ToString();
entity.CateName = row[4].ToString();
PCEntity = ProductCategory.GetSingleCateName(entity.CateName);
if (PCEntity.IsNotNull())
{
entity.CateNum = PCEntity.CateNum;
}
else
{
entity.CateNum = "";
}
entity.Num = ConvertHelper.ToType<int>(row[5].ToString());
entity.MinNum = ConvertHelper.ToType<int>(row[6].ToString());
entity.MaxNum = ConvertHelper.ToType<int>(row[7].ToString());
entity.UnitName = row[8].ToString();
entity.UnitNum = entity.UnitNum;
entity.AvgPrice = ConvertHelper.ToType<double>(row[9].ToString());
entity.InPrice = ConvertHelper.ToType<double>(row[10].ToString());
entity.OutPrice = ConvertHelper.ToType<double>(row[11].ToString());
entity.NetWeight = ConvertHelper.ToType<double>(row[12].ToString());
entity.GrossWeight = ConvertHelper.ToType<double>(row[13].ToString());
entity.Remark = row[14].ToString();
entity.IsDelete = (int)EIsDelete.NotDelete;
entity.CreateTime = DateTime.Now;
list.Add(entity);
}
}
}
public ActionResult Edit()
{
string cateNum = WebUtil.GetFormValue<string>("num", string.Empty);
string cateName = WebUtil.GetFormValue<string>("name", string.Empty);
string remark = WebUtil.GetFormValue<string>("remark", string.Empty);
if (cateNum.IsEmpty())
{
ProductCategoryEntity entity = new ProductCategoryEntity();
entity.CateNum = SequenceProvider.GetSequence(typeof(ProductCategoryEntity));
entity.CateName = cateName;
entity.IsDelete = (int)EIsDelete.NotDelete;
entity.CreateTime = DateTime.Now;
entity.Remark = remark;
entity.CreateUser = this.LoginUserCode;
ProductCategoryProvider provider = new ProductCategoryProvider();
int line = provider.Add(entity);
if (line > 0)
{
this.ReturnJson.AddProperty("d", "success");
}
}
else
{
ProductCategoryEntity entity = new ProductCategoryEntity();
entity.CateNum = cateNum;
entity.CateName = cateName;
entity.Remark = remark;
ProductCategoryProvider provider = new ProductCategoryProvider();
int line = provider.Update(entity);
if (line > 0)
{
this.ReturnJson.AddProperty("d", "success");
}
}
return Content(this.ReturnJson.ToString());
}
public ActionResult CateList()
{
string cateName = WebUtil.GetFormValue<string>("cateName", string.Empty);
int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0);
int pageSize = WebUtil.GetFormValue<int>("pageSize", 0);
ProductCategoryProvider provider = new ProductCategoryProvider();
ProductCategoryEntity entity = new ProductCategoryEntity();
if (!cateName.IsEmpty())
{
entity.Begin<ProductCategoryEntity>()
.Where<ProductCategoryEntity>("CateNum", ECondition.Like, "%" + cateName + "%")
.Or<ProductCategoryEntity>("CateName", ECondition.Like, "%" + cateName + "%")
.End<ProductCategoryEntity>()
;
}
PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize };
List<ProductCategoryEntity> list = provider.GetList(entity, ref pageInfo);
list = list.IsNull() ? new List<ProductCategoryEntity>() : list;
string json = ConvertJson.ListToJson<ProductCategoryEntity>(list, "data");
JsonObject jsonObject = new JsonObject(json);
this.ReturnJson.AddProperty("list", jsonObject);
this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount);
return Content(this.ReturnJson.ToString());
}