public ActionResult AddProductConsultType(ProductConsultTypeModel model) { if (ModelState.IsValid) { ProductConsultTypeInfo productConsultTypeInfo = new ProductConsultTypeInfo() { Title = model.Title, DisplayOrder = model.DisplayOrder }; AdminProductConsults.CreateProductConsultType(productConsultTypeInfo); AddMallAdminLog("添加商品咨询类型", "添加商品咨询类型,商品咨询类型为:" + model.Title.Trim()); return PromptView("商品咨询类型添加成功"); } ViewData["referer"] = MallUtils.GetMallAdminRefererCookie(); return View(model); }
/// <summary> /// 获得商品咨询类型列表 /// </summary> /// <returns></returns> public static ProductConsultTypeInfo[] GetProductConsultTypeList() { DataTable dt = BrnMall.Core.BMAData.RDBS.GetProductConsultTypeList(); ProductConsultTypeInfo[] productConsultTypeList = new ProductConsultTypeInfo[dt.Rows.Count]; int index = 0; foreach (DataRow row in dt.Rows) { ProductConsultTypeInfo productConsultTypeInfo = new ProductConsultTypeInfo(); productConsultTypeInfo.ConsultTypeId = TypeHelper.ObjectToInt(row["consulttypeid"]); productConsultTypeInfo.Title = row["Title"].ToString(); productConsultTypeInfo.DisplayOrder = TypeHelper.ObjectToInt(row["displayorder"]); productConsultTypeList[index] = productConsultTypeInfo; index++; } return productConsultTypeList; }
/// <summary> /// 更新商品咨询类型 /// </summary> public void UpdateProductConsultType(ProductConsultTypeInfo productConsultTypeInfo) { DbParameter[] parms = { GenerateInParam("@title", SqlDbType.NChar,30,productConsultTypeInfo.Title), GenerateInParam("@displayorder", SqlDbType.Int,4,productConsultTypeInfo.DisplayOrder), GenerateInParam("@consulttypeid", SqlDbType.TinyInt, 1, productConsultTypeInfo.ConsultTypeId) }; string commandText = string.Format("UPDATE [{0}productconsulttypes] SET [title]=@title,[displayorder]=@displayorder WHERE [consulttypeid]=@consulttypeid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 创建商品咨询类型 /// </summary> public void CreateProductConsultType(ProductConsultTypeInfo productConsultTypeInfo) { DbParameter[] parms = { GenerateInParam("@title", SqlDbType.NChar,30,productConsultTypeInfo.Title), GenerateInParam("@displayorder", SqlDbType.Int,4,productConsultTypeInfo.DisplayOrder) }; string commandText = string.Format("INSERT INTO [{0}productconsulttypes]([title],[displayorder]) VALUES(@title,@displayorder)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新商品咨询类型 /// </summary> public static void UpdateProductConsultType(ProductConsultTypeInfo productConsultTypeInfo) { BrnMall.Data.ProductConsults.UpdateProductConsultType(productConsultTypeInfo); BrnMall.Core.BMACache.Remove(CacheKeys.MALL_PRODUCTCONSULTTYPE_LIST); }
/// <summary> /// 更新商品咨询类型 /// </summary> public static void UpdateProductConsultType(ProductConsultTypeInfo productConsultTypeInfo) { BrnMall.Core.BMAData.RDBS.UpdateProductConsultType(productConsultTypeInfo); }