public ActionResult AddGoodsCategory(GoodsCategoryModel model) { JsonModel jm = new JsonModel(); //如果表单模型验证成功 if (ModelState.IsValid) { IGoodsCategoryBLL goodsCategoryTypeBll = BLLFactory <IGoodsCategoryBLL> .GetBLL("GoodsCategoryBLL"); T_GoodsCategory goodsCategory = new T_GoodsCategory() { Name = model.Name, ShopId = GetCurrentShopId().Value }; // 保存 goodsCategoryTypeBll.Save(goodsCategory); //日志记录 jm.Content = PropertyUtils.ModelToJsonString(model); } else { // 保存异常日志 jm.Msg = ConstantParam.JSON_RESULT_MODEL_CHECK_ERROR; } return(Json(jm, JsonRequestBehavior.AllowGet)); }
public ApiResult GetGoodsCategory() { var list = _goodsCategoryServices.GetCategories(); List <GoodsCategoryModel> typeList = new List <GoodsCategoryModel>(); foreach (var item in list.Where(me => me.ParentId == Guid.Empty).OrderByDescending(me => me.Sort)) { var type = new GoodsCategoryModel(); type.Id = item.Id; type.Name = item.Name; type.ChildGoodsCategorys = setTypeTree(type, list); var mainImage = _storageFileService.GetFiles(item.Id, MallModule.Key, "CategoryImage").FirstOrDefault(); type.CategoryImage = mainImage?.Simplified(); typeList.Add(type); } var result = new ApiResult(); var data = new { GoodsCategorys = typeList }; result.SetData(data); return(result); }
public JsonResult EditGoodsCategory(GoodsCategoryModel model) { JsonModel jm = new JsonModel(); //如果表单模型验证成功 if (ModelState.IsValid) { IGoodsCategoryBLL goodsCategoryBll = BLLFactory <IGoodsCategoryBLL> .GetBLL("GoodsCategoryBLL"); T_GoodsCategory goodsCategory = goodsCategoryBll.GetEntity(m => m.Id == model.Id); if (goodsCategory != null) { goodsCategory.Name = model.Name; //保存到数据库 if (goodsCategoryBll.Update(goodsCategory)) { //日志记录 jm.Content = PropertyUtils.ModelToJsonString(model); } else { jm.Msg = "编辑失败"; } } else { jm.Msg = "该类别不存在"; } } else { jm.Msg = ConstantParam.JSON_RESULT_MODEL_CHECK_ERROR; } return(Json(jm, JsonRequestBehavior.AllowGet)); }
public ActionResult GoodsCategoryList(GoodsCategoryModel model) { IGoodsCategoryBLL goodsCategoryBll = BLLFactory <IGoodsCategoryBLL> .GetBLL("GoodsCategoryBLL"); var shopId = GetCurrentShopId().Value; Expression <Func <T_GoodsCategory, bool> > where = u => (string.IsNullOrEmpty(model.Name) ? true : u.Name.Contains(model.Name)) && u.ShopId == shopId; //查询条件 //排序 var sortModel = this.SettingSorting("Id", false); //将查询到的数据赋值传到页面 model.DataList = goodsCategoryBll.GetPageList(where, sortModel.SortName, sortModel.IsAsc, model.PageIndex) as PagedList <T_GoodsCategory>; return(View(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> private GoodsCategoryModel DataRowToModel(DataRow row) { GoodsCategoryModel model = new GoodsCategoryModel(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["CategoryName"] != null) { model.CategoryName = row["CategoryName"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["CreatePerson"] != null) { model.CreatePerson = row["CreatePerson"].ToString(); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["UpdatePerson"] != null) { model.UpdatePerson = row["UpdatePerson"].ToString(); } if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "") { model.UpdateDate = DateTime.Parse(row["UpdateDate"].ToString()); } if (row["DeleteMark"] != null && row["DeleteMark"].ToString() != "") { if ((row["DeleteMark"].ToString() == "1") || (row["DeleteMark"].ToString().ToLower() == "true")) { model.DeleteMark = true; } else { model.DeleteMark = false; } } } return(model); }
/// <summary> /// 递归商品分类树结构 /// </summary> /// <param name="toType"></param> /// <param name="types"></param> /// <returns></returns> private List <GoodsCategoryModel> setTypeTree(GoodsCategoryModel toType, List <Models.GoodsCategory> types) { var childTypes = types.Where(me => me.ParentId == toType.Id).OrderByDescending(me => me.Sort); toType.ChildGoodsCategorys = new List <GoodsCategoryModel>(); foreach (var child in childTypes) { var item = new GoodsCategoryModel(); item.Id = child.Id; item.Name = child.Name; item.ChildGoodsCategorys = setTypeTree(item, types); var mainImage = _storageFileService.GetFiles(child.Id, MallModule.Key, "CategoryImage").FirstOrDefault(); item.CategoryImage = mainImage?.Simplified(); toType.ChildGoodsCategorys.Add(item); } return(toType.ChildGoodsCategorys); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateGoodsCategory(GoodsCategoryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_GoodsCategory set "); strSql.Append("CategoryName=@CategoryName,"); strSql.Append("Remark=@Remark,"); strSql.Append("CreatePerson=@CreatePerson,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("UpdatePerson=@UpdatePerson,"); strSql.Append("UpdateDate=@UpdateDate,"); strSql.Append("DeleteMark=@DeleteMark"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@CategoryName", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 100), new SqlParameter("@CreatePerson", SqlDbType.VarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@UpdatePerson", SqlDbType.VarChar, 50), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@DeleteMark", SqlDbType.Bit, 1), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.CategoryName; parameters[1].Value = model.Remark; parameters[2].Value = model.CreatePerson; parameters[3].Value = model.CreateDate; parameters[4].Value = model.UpdatePerson; parameters[5].Value = model.UpdateDate; parameters[6].Value = model.DeleteMark; parameters[7].Value = model.Id; object obj = DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.financialMgrConn, CommandType.Text, strSql.ToString(), parameters); if (Convert.ToInt32(obj) > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool AddGoodsCategory(GoodsCategoryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_GoodsCategory("); strSql.Append("CategoryName,Remark,CreatePerson,CreateDate,UpdatePerson,UpdateDate,DeleteMark)"); strSql.Append(" values ("); strSql.Append("@CategoryName,@Remark,@CreatePerson,@CreateDate,@UpdatePerson,@UpdateDate,@DeleteMark)"); SqlParameter[] parameters = { new SqlParameter("@CategoryName", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 100), new SqlParameter("@CreatePerson", SqlDbType.VarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@UpdatePerson", SqlDbType.VarChar, 50), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@DeleteMark", SqlDbType.Bit, 1) }; parameters[0].Value = model.CategoryName; parameters[1].Value = model.Remark; parameters[2].Value = model.CreatePerson; parameters[3].Value = model.CreateDate; parameters[4].Value = model.UpdatePerson; parameters[5].Value = model.UpdateDate; parameters[6].Value = model.DeleteMark; int rows = DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.financialMgrConn, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public ActionResult EditGoodsCategory(int id) { IGoodsCategoryBLL goodsCategoryBll = BLLFactory <IGoodsCategoryBLL> .GetBLL("GoodsCategoryBLL"); var shopId = GetCurrentShopId().Value; //获取要编辑的物业账户 T_GoodsCategory goodsCategory = goodsCategoryBll.GetEntity(m => m.Id == id && m.ShopId == shopId); if (goodsCategory != null) { //初始化返回页面的模型 GoodsCategoryModel model = new GoodsCategoryModel() { Id = goodsCategory.Id, Name = goodsCategory.Name }; return(View(model)); } else { return(RedirectToAction("GoodsCategoryList")); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GoodsCategoryModel GetGoodsCategoryModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,CategoryName,Remark,CreatePerson,CreateDate,UpdatePerson,UpdateDate,DeleteMark from tb_GoodsCategory "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = id; GoodsCategoryModel model = new GoodsCategoryModel(); DataSet ds = DriveMgr.Common.SqlHelper.GetDataset(DriveMgr.Common.SqlHelper.financialMgrConn, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public ActionResult AddGoodsCategory(GoodsCategoryModel model) { var result = _goodsCategoryService.AddService.AddCategory(model); return(BoolResult(result)); }