public ActionResult <object> Update([FromBody] b_productVM model) { b_product_Entity entity = model.ConvertToT <b_product_Entity>(); this.SetUpdateUserInfo(entity); CacheFactory.CacheInstance.RemovePrefix(Constant.Cache_Product_Prefix); return(this._repository.Update(entity, model.Product_ID).ResponseSuccess()); }
public ActionResult <object> GetList([FromBody] b_productVM model, int pageindex = 1, int pagesize = 24) { b_product_Entity entity = model.ConvertToT <b_product_Entity>(); var(list, total) = this._repository.GetList(entity, pageindex, pagesize); return(list.ResponseSuccess("", total)); }
/// <summary> /// 修改 /// <summary> public bool Update(b_product_Entity model, int Product_ID) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic["Product_ID"] = Product_ID; if (model.Category_ID != 0) { dic["Category_ID"] = model.Category_ID; } if (model.Product_Name_CH != null) { dic["Product_Name_CH"] = model.Product_Name_CH; } if (model.Product_Name_HK != null) { dic["Product_Name_HK"] = model.Product_Name_HK; } if (model.Product_New != null && model.Product_New.HasValue) { dic["Product_New"] = model.Product_New; } if (model.Product_Hot != null && model.Product_Hot.HasValue) { dic["Product_Hot"] = model.Product_Hot; } if (model.Product_Recommend != null && model.Product_Recommend.HasValue) { dic["Product_Recommend"] = model.Product_Recommend; } if (model.Product_Status != null && model.Product_Status.HasValue) { dic["Product_Status"] = model.Product_Status; } if (model.Product_Seq >= 0) { dic["Product_Seq"] = model.Product_Seq; } if (model.Update_Time != null && model.Update_Time.HasValue) { dic["Update_Time"] = model.Update_Time; } if (model.Update_UserId != null) { dic["Update_UserId"] = model.Update_UserId; } if (model.Update_User != null) { dic["Update_User"] = model.Update_User; } return(SQLHelperFactory.Instance.ExecuteNonQuery("Update_b_product", dic) > 0); }
/// <summary> /// 获取列表 /// <summary> public (IEnumerable <b_product_Entity>, int) GetList(b_product_Entity model, int pageindex, int pagesize) { Dictionary <string, object> dic = new Dictionary <string, object>(); if (model.Product_ID != 0) { dic["Product_ID"] = model.Product_ID; } if (model.Category_ID != 0) { dic["Category_ID"] = model.Category_ID; } if (model.Product_Name_CH != null) { dic["Product_Name"] = model.Product_Name_CH; } if (model.Product_Name_HK != null) { dic["Product_Name"] = model.Product_Name_HK; } if (model.Product_New != null && model.Product_New.HasValue) { dic["Product_New"] = model.Product_New; } if (model.Product_Hot != null && model.Product_Hot.HasValue) { dic["Product_Hot"] = model.Product_Hot; } if (model.Product_Recommend != null && model.Product_Recommend.HasValue) { dic["Product_Recommend"] = model.Product_Recommend; } if (model.Product_Status != null && model.Product_Status.HasValue) { dic["Product_Status"] = model.Product_Status; } if (pageindex >= 0) { dic["StartIndex"] = pageindex <= 1 ? 0 : (pageindex - 1) * pagesize; } if (pagesize > 0) { dic["SelectCount"] = pagesize; } var list = SQLHelperFactory.Instance.QueryMultipleByPage <b_product_Entity>("Select_b_product_List", dic, out int total); return(list, total); }
/// <summary> /// 新增 /// <summary> public int Insert(b_product_Entity model) { Dictionary <string, object> dic = new Dictionary <string, object>(); if (model.Category_ID != 0) { dic["Category_ID"] = model.Category_ID; } if (model.Product_Name_CH != null) { dic["Product_Name_CH"] = model.Product_Name_CH; } if (model.Product_Name_HK != null) { dic["Product_Name_HK"] = model.Product_Name_HK; } if (model.Product_New != null && model.Product_New.HasValue) { dic["Product_New"] = model.Product_New; } if (model.Product_Hot != null && model.Product_Hot.HasValue) { dic["Product_Hot"] = model.Product_Hot; } if (model.Product_Recommend != null && model.Product_Recommend.HasValue) { dic["Product_Recommend"] = model.Product_Recommend; } if (model.Product_Status != null && model.Product_Status.HasValue) { dic["Product_Status"] = model.Product_Status; } if (model.Product_Seq >= 0) { dic["Product_Seq"] = model.Product_Seq; } if (model.Create_UserId != null) { dic["Create_UserId"] = model.Create_UserId; } if (model.Create_User != null) { dic["Create_User"] = model.Create_User; } return(SQLHelperFactory.Instance.ExecuteScalarByT <int>("Insert_b_product", dic)); }