// GET: Goods public ActionResult GoodsIndex(int?tid_1, int?typeid_1, int?typeid_2, string txt = "") { //清空session数据 Session.Remove("Goods"); Session.Remove("Goods_tid"); Session.Remove("Goods_typeid"); //获得所有分类数据 ViewBag.Type = TypeTableBll.SelectAllType(); ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto(); if (tid_1 != null) { //根据tid查询 Session["Goods_tid"] = GoodsBll.SelectTidGoods(tid_1 ?? 0); //ViewBag.tid = tid_1 ?? 0; } else if (typeid_1 != null) { //根据tiyeid查询 Session["Goods_typeid"] = GoodsBll.SelectTypeidGoods(typeid_1 ?? 0); } else if (typeid_2 != null) { Session["Goods_typeid_2"] = GoodsBll.SelectType1Goods(typeid_2 ?? 0); } else { Session["Goods"] = GoodsBll.SelectAllGoods().Where(p => p.GoodsName.Contains(txt) && p.IsDelte == 0).OrderBy(p => p.GoodsHot).ToList(); } return(View()); }
/// <summary> /// 商品列表分布视图 /// </summary> /// <returns></returns> public ActionResult GoodsIndexPartial(int?pageindex, int typeid, string text = "") { List <GoodsTable> list = null; if (typeid == 0) { list = GoodsBll.SelectAllGoods().Where(p => p.GoodsName.Contains(text)).ToList(); } else { //查询第一大类的商品 list = GoodsBll.SelectType1GoodsAdmin(typeid).Where(p => p.GoodsName.Contains(text)).ToList(); //查询所有分类 List <TypeTable> typelist = TypeTableBll.SelectAllType(); //防止错误赋值给typetable导航属性 list.ForEach(p => p.TypeTable = typelist.Where(a => a.TypeID == p.TID).ToList()[0]); } if (list != null && list.Count() > 0) { Session["goodscount"] = list.Count(); } else { Session["goodscount"] = 0; } Session["goodpagecount"] = Math.Ceiling(list.Count() / 8.0); ViewBag.pageindex = pageindex; ViewBag.text = text; ViewBag.typeid = typeid; Session["allgoods"] = list.Skip(((pageindex ?? 1) - 1) * 8).Take(8).ToList(); return(PartialView("GoodsIndexPartial")); }
/// <summary> /// 修改商品信息 /// </summary> /// <param name="goodsfile">商品图片(多选)</param> /// <param name="good">商品对象</param> /// <param name="pageindex">当前页</param> /// <param name="typeid">分类id</param> /// <param name="text">查询内容</param> /// <returns></returns> public ActionResult GoodsUpdate(GoodsTable good, int?pageindex, int typeid, string text = "") { //添加商品图片 if (Request.Files.Count > 0) { string[] fileTypeStr = { "image/gif", "image/png", "image/jpeg", "image/jpg", "image/bmp" }; List <string> strlist = new List <string>(); for (int i = 0; i < Request.Files.Count; i++) { if (fileTypeStr.Contains(Request.Files[i].ContentType)) { string fileName = Path.GetFileName(Request.Files[i].FileName); strlist.Add(fileName); } } if (GoodsPhotoBll.AddGoodsPhoto(good.GoodsID, strlist)) { //保存文件 //应用程序需要有服务器UploadFile文件夹的读写权限 for (int i = 0; i < Request.Files.Count; i++) { Request.Files[i].SaveAs(Server.MapPath("~/Content/GoodImgs/" + Request.Files[i].FileName)); } } } //修改商品信息 GoodsBll.UpdateGoods(good); return(RedirectToAction("GoodsIndexPartial", "BacksTage", new { pageindex = pageindex, text = text, typeid = typeid })); }
/// <summary> /// 根据typeid查询商品信息的分布视图 /// </summary> /// <param name="pageindex">当前页</param> /// <returns></returns> public ActionResult Show_typeid(int?pageindex, int?typeid) { ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto(); List <GoodsTable> list = null; if (typeid == null) { list = Session["Goods_typeid"] as List <GoodsTable>; ViewBag.count = Math.Ceiling(list.Count() / 12.0); } else { list = GoodsBll.SelectTypeidGoods(typeid ?? 0); if (list == null) { ViewBag.isnull = true; return(PartialView("Show", null)); } else { ViewBag.count = Math.Ceiling(list.Count() / 12.0); } } ViewBag.pageindex = pageindex; return(PartialView("Show", list.Skip(((pageindex ?? 1) - 1) * 12).Take(12).ToList())); }
protected void Page_Load(object sender, EventArgs e) { goodsId = Request.QueryString["goodsId"] == null ? 0 : Int32.Parse(Request.QueryString["goodsId"]); GoodsIdInput.Text = "<input type='hidden' id='formGooodsId' name='formGooodsId' value='" + goodsId.ToString() + "' />"; GoodsBll gb = new GoodsBll(); List <Sort> sortList = gb.GetSort(); string html = ""; foreach (Sort sort in sortList) { html += "<option value='" + sort.SortId.ToString() + "'>" + sort.SortName + "</option>"; } SortListSelect.Text = html; if (goodsId != 0) { Goods currentGoods = gb.GetSingleGoods(goodsId); goodsName = currentGoods.GoodsName; sortId = currentGoods.SortId; goodsPrice = currentGoods.Price.ToString("f2"); goodsCost = currentGoods.Cost.ToString("f2"); goodsOnsales = currentGoods.Onsale; } }
/// <summary> /// 新增商品 /// </summary> /// <param name="Arr">图片数组</param> /// <param name="GoodsPrice">现价</param> /// <param name="GoodsName">名称</param> /// <param name="OldGoodsPrice">原价</param> /// <param name="GoodsInventory">库存</param> /// <param name="TID">分类id</param> /// <param name="GoodsDescribe">描述</param> /// <returns></returns> public JsonResult AddGoodsAjax() { GoodsTable good = new GoodsTable() { GoodsName = Request.Form["goodsname"], GoodsPrice = Convert.ToDecimal(Request.Form["goodsprice"]), OldGoodsPrice = Convert.ToDecimal(Request.Form["oldgoodsprice"]), TID = Convert.ToInt32(Request.Form["tid"]), GoodsInventory = Convert.ToInt32(Request.Form["goodsinventory"]), GoodsDescribe = Request.Form["goodsdescribe"] }; List <string> list = new List <string>(); for (int i = 0; i < Request.Files.Count; i++) { list.Add(Path.GetFileName(Request.Files[i].FileName)); } //调用新增方法 if (GoodsBll.AddGoods(good)) { //查询最后一条商品 GoodsTable lastgood = GoodsBll.SelectAllGoods().LastOrDefault(); //调用新增商品图片方法 if (GoodsPhotoBll.AddGoodsPhoto(lastgood.GoodsID, list)) { //保存图片 for (int i = 0; i < Request.Files.Count; i++) { Request.Files[i].SaveAs(Server.MapPath("~/Content/GoodImgs/" + Request.Files[i].FileName)); } return(Json(1, JsonRequestBehavior.AllowGet)); } } return(Json(0, JsonRequestBehavior.AllowGet)); }
public void GetAreaInfo() { GoodsModel model1 = new GoodsModel(); GoodsBll bll1 = new GoodsBll(); model = bll.GetModel1(_Pid); model1 = bll1.GetModel(_Pid); this.txtname.Text = model1.serviceName; if (model != null) { //this.txtID.Text = model.sysnumber; this.txtPrice.Text = model.Price.ToString(); this.txtValue.Text = model.value; //this.txtsysnumber.Visible =false ; //this.txtID.Visible = true; if (model.IsDefault == 1) { this.CheckDefault.SelectedValue = "1"; } else { this.CheckDefault.SelectedValue = "0"; } } }
public JsonResult GetGoods(int page, int rows, long catId = 0, string searchName = "") { var pager = GoodsBll.GetPager(page, rows, UserContext.CurrentUser.HotelId, catId, searchName); //var pager = GoodsBll.GetPager(page, rows, UserContext.CurrentUser.HotelId, catId, searchName); return(Json(pager)); }
protected void GetFormateInfo() { //new TableObject("T_Goods_Formate").Util_DeleteBat("goodsId='" + this.goodsId + "'"); string strSQL = "delete T_Goods_Formate where goodsId='" + goodsId + "';"; AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance); adohelper.ExecuteSqlNonQuery(strSQL); GoodsFormateBll bll = new GoodsFormateBll(); for (int i = 1; i < 100; i++) { if (Request["formate_code_" + i] == null) { break; } GoodsModel modGoods = new GoodsBll().GetModel(goodsId); postage = modGoods.Postage.Value; GoodsFormateModel mod = new GoodsFormateModel(); mod.sysnumber = Guid.NewGuid().ToString(); mod.GoodsCode = Request["formate_code_" + i]; mod.GoodsId = this.goodsId; mod.Price = decimal.Parse(Request["formate_price_" + i]); mod.Stock = int.Parse(Request["formate_stock_" + i]); mod.GoodsFormateValues = Request["formate_info_" + i]; //mod.Postage = this.postage; //mod.vipPrice1 = Convert.ToDecimal(Request["formate_vip1_" + i]); //mod.vipPrice2 = Convert.ToDecimal(Request["formate_vip2_" + i]); mod.GoodsFormateNames = Request["formateAllNames"]; bll.Add(mod); } }
protected void InitFormate2(string goodsId) { string html = ""; string html2 = ""; DataTable dt = new GoodsBll().GetMorePropertyInfo(goodsId); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { if (row["porpertyFlag"].ToString() == "select") { string uid = "MorePropertyId_" + row["propertyId"].ToString(); html2 += uid + "$" + row["propertyName"].ToString() + ","; if (row["propertyOptions"].ToString() != "") { string vs = ""; foreach (string s in row["propertyOptions"].ToString().Split(',')) { string vid = Guid.NewGuid().ToString(); vs += "<input type='checkbox' id='" + vid + "' onclick=\"selectPropertyValue('" + uid + "','" + vid + "','" + s + "')\" >" + s + " "; } html += "<div>" + row["propertyName"].ToString() + ":" + vs + "<input type='hidden' id='" + uid + "' name='" + uid + "'></div>"; } } } if (html2 != "") { html2 = "<input type='hidden' id='MorePropertyInfo' name='MorePropertyInfo' value='" + html2.TrimEnd(',') + "'>"; } this.ltHtml.Text = html + html2; } }
protected void InitFormate(string goodsId) { GoodsModel modGoods = new GoodsBll().GetModel(goodsId); postage = modGoods.Postage.Value; if (modGoods != null) { string html = ""; string html2 = ""; string strSQL = "select * from T_Goods_MoreProperty where typeId='" + modGoods.GoodsToTypeId + "' and flag='select' order by orderBy asc;"; AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance); DataTable dt = adohelper.ExecuteSqlDataset(strSQL).Tables[0]; //DataTable dt = new TableObject("T_Goods_TypeProperty").Util_GetList("*", "typeId='" + modGoods.GoodsToTypeId + "' and flag='select'", "orderBy asc"); foreach (DataRow row in dt.Rows) { string uid = "MorePropertyId_" + row["propertyId"].ToString(); html2 += uid + "$" + row["propertyName"].ToString() + ","; if (row["propertyValues"].ToString() != "") { string vs = ""; foreach (string s in row["propertyValues"].ToString().Split(',')) { string vid = Guid.NewGuid().ToString(); vs += "<input type='checkbox' id='" + vid + "' onclick=\"selectPropertyValue('" + uid + "','" + vid + "','" + s + "')\" >" + s + " "; } html += "<div>" + row["propertyName"].ToString() + ":" + vs + "<input type='hidden' id='" + uid + "' name='" + uid + "'></div>"; } } if (html2 != "") { html2 = "<input type='hidden' id='MorePropertyInfo' name='MorePropertyInfo' value='" + html2.TrimEnd(',') + "'>"; } this.ltHtml.Text = html + html2; } }
/// <summary> /// 商品出售或停售 /// </summary> /// <param name="GoodsID">商品id</param> /// <returns></returns> public JsonResult GoodsDel(string GoodsID) { if (GoodsBll.GoodsDel(Convert.ToInt32(GoodsID))) { return(Json(1, JsonRequestBehavior.AllowGet)); } return(Json(0, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询所有商品信息的分布视图 /// </summary> /// <param name="pageindex"></param> /// <returns></returns> public ActionResult Show(int?pageindex) { ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto(); List <GoodsTable> list = GoodsBll.SelectAllGoods().Where(p => p.IsDelte == 0).ToList(); ViewBag.count = Math.Ceiling(list.Count() / 12.0); ViewBag.pageindex = pageindex; return(PartialView("Show", list.Skip(((pageindex ?? 1) - 1) * 12).Take(12).ToList())); }
public ActionResult Edit(long id = 0) { if (id == 0) { return(View(new Hotel.Model.Goods() { HotelId = UserContext.CurrentUser.HotelId })); } var info = GoodsBll.GetById(id); return(View(info)); }
protected void Page_Load(object sender, EventArgs e) { int sortId = Request.QueryString["sortId"] == null ? 0 : Int32.Parse(Request.QueryString["sortId"]); SortIdInput.Text = "<input type='hidden' id='formSortId' name='formSortId' value='" + sortId.ToString() + "' />"; sortName = ""; if (sortId != 0) { GoodsBll gb = new GoodsBll(); Sort currentSort = gb.GetSingleSort(sortId); sortName = currentSort.SortName; } }
/// <summary> /// 查询一个商品的详情 /// </summary> /// <param name="GoodsID">商品id</param> /// <returns></returns> public JsonResult GoodsDesc(string GoodsID) { //查询商品的信息 GoodsTable good = GoodsBll.SelectAllGoods().SingleOrDefault(p => p.GoodsID == Convert.ToInt32(GoodsID)); //查询商品对应的所有图片 var goodsphoto = GoodsPhotoBll.SelectAllGoodsPhoto().Where(p => p.GoodsID == Convert.ToInt32(GoodsID)).Select(p => new { RID = p.RID, GoodsID = p.GoodsID, PhotoPath = p.PhotoPath }).ToList(); //查询所有最小的分类 var typelist = TypeTableBll.SelectSmallType().Select(p => new { typeid = p.TypeID, typename = p.TypeName }); JsonSerializerSettings jsonstring = new JsonSerializerSettings(); jsonstring.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; string list_1 = JsonConvert.SerializeObject(good, jsonstring); string list_2 = JsonConvert.SerializeObject(goodsphoto, jsonstring); string list_3 = JsonConvert.SerializeObject(typelist, jsonstring); return(Json(new { Good = list_1, GoodPhoto = list_2, GoodType = list_3 }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 商城首页 /// </summary> /// <returns></returns> public ActionResult Index() { //获取导航栏的分类数据 Session["Type"] = TypeTableBll.SelectTypeTable(); //获得所有分类数据 ViewBag.Type = TypeTableBll.SelectAllType(); //获取图片 ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto(); ViewBag.goods_1 = GoodsBll.SelectType1Goods(1).OrderBy(p => p.GoodsHot).Take(8); ViewBag.goods_2 = GoodsBll.SelectType1Goods(2).OrderBy(p => p.GoodsHot).Take(8); ViewBag.goods_3 = GoodsBll.SelectType1Goods(3).OrderBy(p => p.GoodsHot).Take(8); ViewBag.goods_4 = GoodsBll.SelectType1Goods(4).OrderBy(p => p.GoodsHot).Take(8); if (Session["userid"] != null) { Session["carcount"] = ShopingCarBll.SelectAllShopCar(Convert.ToInt32(Session["userid"])).Count(); } return(View(GoodsBll.SelectAllGoods().Where(p => p.IsDelte == 0).ToList())); }
protected void Page_Load(object sender, EventArgs e) { int goodsId = Request.QueryString["goodsId"] != null?Int32.Parse(Request.QueryString["goodsId"]) : 0; if (goodsId != 0) { GoodsBll gb = new GoodsBll(); int rows = gb.DeleteGoods(goodsId); if (rows > 0) { Msg.Text = "删除成功!"; } else { Msg.Text = "删除失败!存在与之相关联的商品销售或进货记录。"; } } }
public ActionResult Delete(long id) { var apiResult = new APIResult(); try { GoodsBll.Delete(id); } catch (Exception ex) { apiResult.Ret = -1; apiResult.Msg = ex.Message; if (!(ex is OperationExceptionFacade)) { LogFactory.GetLogger().Log(LogLevel.Error, ex); } } return(Json(apiResult)); }
public JsonResult Edit(Hotel.Model.Goods model) { var apiResult = new APIResult(); try { GoodsBll.AddOrUpdate(model, UserContext.CurrentUser.HotelId); } catch (Exception ex) { apiResult.Ret = -1; apiResult.Msg = ex.Message; if (!(ex is OperationExceptionFacade)) { LogFactory.GetLogger().Log(LogLevel.Error, ex); } } return(Json(apiResult)); }
protected void Page_Load(object sender, EventArgs e) { int sortId = Request.QueryString["sortId"] != null?Int32.Parse(Request.QueryString["sortId"]) : 0; int rows = 0; if (sortId != 0) { GoodsBll gb = new GoodsBll(); rows = gb.DeleteSort(sortId); } if (rows == 0) { Msg.Text = "存在与之相关联的商品记录,未删除成功!"; } else { Msg.Text = "删除成功!"; } }
/// <summary> /// 后台商品管理 /// </summary> /// <returns></returns> public ActionResult BackGoodsIndex() { Session["li_1"] = 1; Session["li_2"] = 0; //商品的图片 Session["GoodsPhoto"] = GoodsPhotoBll.SelectAllGoodsPhoto(); //查询所有商品 List <GoodsTable> list = GoodsBll.SelectAllGoods(); if (list != null && list.Count() > 0) { Session["goodscount"] = list.Count(); } else { Session["goodscount"] = 0; } Session["goodpagecount"] = Math.Ceiling(list.Count() / 8.0); Session["allgoods"] = list.Take(8).ToList(); return(View()); }
protected void Page_Load(object sender, EventArgs e) { GoodsBll gb = new GoodsBll(); List <Sort> sortList = gb.GetSort(); List <Goods> goodsList = gb.GetAllGoodsOrderByName(); string html = ""; foreach (Sort tempSort in sortList) { html += "<option value='" + tempSort.SortId.ToString() + "'>" + tempSort.SortName + "</option>"; } FormSortIdSelect.Text = html; html = ""; foreach (Goods tempGoods in goodsList) { html += "<option sortTag='" + tempGoods.SortId.ToString() + "' price='" + tempGoods.Price.ToString("f2") + "' value='" + tempGoods.GoodsId.ToString() + "'>" + tempGoods.GoodsName + "</option>"; } FormGoodsIdSelect.Text = html; int saleId = Request.QueryString["saleId"] == null ? 0 : Int32.Parse(Request.QueryString["saleId"]); SaleIdInput.Text = "<input type='hidden' id='formSaleId' name='formSaleId' value='" + saleId.ToString() + "' />"; frontSaleId = saleId; if (saleId != 0) { SaleBll sb = new SaleBll(); Sale saleObj = sb.GetSingleSale(saleId); SaleNumberInput.Text = "<input type='hidden' id='formSaleNumber' name='formSaleNumber' value='" + saleObj.SaleNumber + "' />"; frontSortId = saleObj.SortId; frontGoodsId = saleObj.GoodsId; frontSalePrice = saleObj.SalePrice; frontSaleCount = saleObj.SaleCount; frontSaleUnit = saleObj.SaleUnit; frontSaleDate = saleObj.SaleDate; } else { SaleNumberInput.Text = "<input type='hidden' id='formSaleNumber' name='formSaleNumber' value='' />"; } }
protected void Page_Load(object sender, EventArgs e) { Goods goodsObj = new Goods(); goodsObj.GoodsId = Int32.Parse(Request.Form["formGooodsId"]); goodsObj.GoodsName = Request.Form["formGoodsName"]; goodsObj.SortId = Int32.Parse(Request.Form["formSortId"]); goodsObj.Price = Double.Parse(Request.Form["formGoodsPrice"]); goodsObj.Cost = Double.Parse(Request.Form["formGoodsCost"]); goodsObj.Onsale = Int32.Parse(Request.Form["formGoodsOnsale"]) == 1 ? true : false; GoodsBll gb = new GoodsBll(); bool success = false; if (goodsObj.GoodsId == 0) { success = gb.InsertGoods(goodsObj); if (success) { Msg.Text = "添加成功!"; } else { Msg.Text = "添加失败!该商品已存在。"; } } else { success = gb.UpdateGoods(goodsObj); if (success) { Msg.Text = "修改成功!"; } else { Msg.Text = "修改失败!"; } } }
/// <summary> /// 商品详情 /// </summary> /// <param name="goodsid">商品id</param> /// <returns></returns> public ActionResult GoodsDesc(int goodsid) { //商品图片 ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto().Where(p => p.GoodsID == goodsid).ToList(); //商品的所有评价(置顶排序) List <CommentTable> list = CommentBll.SelectGoodsComment(goodsid).OrderByDescending(p => p.IsTop).ToList(); Session["GoodsComment"] = list; //用户是否收藏商品 ViewBag.iscollection = CollectionBll.SelectOneCollection(Convert.ToInt32(Session["userid"]), goodsid); //加载或更新用户购物车数量 if (Session["userid"] != null) { Session["carcount"] = ShopingCarBll.SelectAllShopCar(Convert.ToInt32(Session["userid"])).Count(); } //获取到的该商品的信息 GoodsTable good = GoodsBll.SelectGoodsIdGoods(goodsid); //相关商品的推荐(3条) ViewBag.GetGoods = GoodsBll.SelectGetGoods(good.TID ?? 0).Where(p => p.GoodsID != good.GoodsID).OrderBy(p => Guid.NewGuid()).Take(3).ToList(); Session["GoodsPhoto"] = GoodsPhotoBll.SelectAllGoodsPhoto(); return(View(good)); }
protected void Page_Load(object sender, EventArgs e) { GoodsBll gb = new GoodsBll(); List <Goods> goodsList = gb.GetAllGoods(true); int showCount = 15; string url = HttpContext.Current.Request.Url.AbsolutePath; int page = Request.QueryString["page"] == null ? 1 : Int32.Parse(Request.QueryString["page"]); int maxPage = goodsList.Count % showCount == 0 ? goodsList.Count / showCount : goodsList.Count / showCount + 1; string html = ""; if (goodsList.Count != 0) { GoodsPageNum.Text = HtmlHelper.PageNumAdminControl(url, "rightFrame", page, maxPage); int startIndex = (page - 1) * showCount; int endIndex = page == maxPage ? goodsList.Count - 1 : page * showCount - 1; bool tbg = true; for (int i = startIndex; i <= endIndex; i++) { html += tbg ? "<tr class='tbg1'>" : "<tr class='tbg2'>"; html += "<td>" + goodsList[i].GoodsName + "</td>"; html += "<td>" + goodsList[i].SortName + "</td>"; html += "<td>" + goodsList[i].Price.ToString("f2") + "</td>"; html += "<td>" + goodsList[i].Cost.ToString("f2") + "</td>"; html += "<td>" + (goodsList[i].Onsale ? "是" : "否") + "</td>"; html += "<td><a href='/Basic/GoodsEdit.aspx?goodsId=" + goodsList[i].GoodsId.ToString() + "' target='rightFrame'>编辑</a>"; html += " | <a href='/Basic/GoodsDelete.aspx?goodsId=" + goodsList[i].GoodsId.ToString() + "' target='rightFrame' onclick=\"javascript:return confirm('确定要删除吗?')\">删除</a>"; html += "</tr>"; tbg = !tbg; } GoodsListTable.Text = html; } else { GoodsListTable.Text = "<tr class='tbg1'><td colspan='6'>暂无记录</td></tr>"; } }
protected void CreateInfo(string goodsId) { DataTable dt = new GoodsBll().GetMorePropertyInfo(goodsId); if (dt != null && dt.Rows.Count > 0) { string html = ""; string allIds = ""; string strSQL = "select * from T_Goods_MoreProperty where goodsid='" + goodsId + "';;"; AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance); DataTable dtValue = adohelper.ExecuteSqlDataset(strSQL).Tables[0]; //DataTable dtValue = new TableObject("T_Goods_MoreProperty").Util_GetList("*", "goodsid='" + goodsId + "'"); foreach (DataRow row in dt.Rows) { if (row["porpertyFlag"].ToString() == "input") { string v = (dtValue.Select("PropertyId='" + row["propertyId"].ToString() + "'").Length > 0) ? dtValue.Select("PropertyId='" + row["propertyId"].ToString() + "'")[0]["PropertyValue"].ToString() : ""; string uid = "MorePropertyId_" + row["propertyId"].ToString(); html += "<tr><td class='td_title' style='width:100px;'>" + row["propertyName"].ToString() + ":</td><td class='td_info1' style='width:330px;'><input type='text' id='" + uid + "' name='" + uid + "' value='" + v + "' style='width:300px;height:16px;'></td></tr>"; allIds += uid + ","; } } if (allIds != "") { allIds = allIds.TrimEnd(','); } html += "<input type='hidden' name='MorePropertyId_AllIds' value='" + allIds + "'>"; this.ltHtml.Text = html; } else { this.btn_1.Visible = false; this.btn_2.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { int sortId = Int32.Parse(Request.Form["formSortId"]); string sortName = Request.Form["formSortName"]; Sort sortEdit = new Sort(); sortEdit.SortId = sortId; sortEdit.SortName = sortName; GoodsBll gb = new GoodsBll(); bool success = false; if (sortId == 0) { success = gb.InsertSort(sortEdit.SortName); if (success) { Msg.Text = "添加成功!"; } else { Msg.Text = "添加失败!“" + sortEdit.SortName + "”已存在。"; } } else { success = gb.UpdateSort(sortEdit); if (success) { Msg.Text = "修改成功!"; } else { Msg.Text = "修改失败!"; } } }
///// <summary> ///// 获取会员折扣 ///// </summary> //protected void GetVipPrice() //{ // string strSQL = "select * from T_Member_Level;"; // AdoHelper adohelper = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance); // DataSet ds = adohelper.ExecuteSqlDataset(strSQL); // if (ds == null || ds.Tables.Count <= 0) // return; // for (int i = 0; i < ds.Tables[0].Rows.Count; i++) // { // if (ds.Tables[0].Rows[i]["levelname"].ToString() == "金牌") // vipDs1 = ds.Tables[0].Rows[i]["shoppingDiscount"].ToString(); // if (ds.Tables[0].Rows[i]["levelname"].ToString() == "银牌") // vipDs2 = ds.Tables[0].Rows[i]["shoppingDiscount"].ToString(); // } //} public string ajaxList(string goodsId, string itemInfo) { //最多支持3组规格信息 string html = ""; string f1 = ""; string f2 = ""; string f3 = ""; string propertyNames = ""; GoodsModel modGoods = new GoodsBll().GetModel(goodsId); ArrayList list = new ArrayList(); if (modGoods != null) { itemInfo = itemInfo.TrimEnd('|').Replace(",,", ","); foreach (string item in itemInfo.Split('|')) { string[] propertyArr = item.Split('$'); if (f1 == "") { f1 = propertyArr[1].TrimEnd(',').TrimStart(','); propertyNames += propertyArr[0] + ","; } else if (f2 == "") { f2 = propertyArr[1].TrimEnd(',').TrimStart(','); propertyNames += propertyArr[0] + ","; } else if (f3 == "") { f3 = propertyArr[1].TrimEnd(',').TrimStart(','); propertyNames += propertyArr[0] + ","; } } #region computer string computer = ""; foreach (string fv1 in f1.Split(',')) { computer = fv1 + ","; if (f2 != "") { foreach (string fv2 in f2.Split(',')) { computer = fv1 + "," + fv2 + ","; if (f3 != "") { foreach (string fv3 in f3.Split(',')) { computer += fv3 + ","; list.Add(computer.TrimEnd(',')); computer = fv1 + "," + fv2 + ","; } } else { list.Add(computer.TrimEnd(',')); computer = fv1 + ","; } } } else { list.Add(computer.TrimEnd(',')); } } #endregion if (list != null && list.Count > 0) { int flagI = 1; foreach (object s in list) { html += "<div class='parDiv' postage='" + modGoods.Postage + "'><input id='formate_code_" + flagI + "' name='formate_code_" + flagI + "' type='text' style='width:120px;' value='" + modGoods.GoodsCode + "-" + flagI + "'> <input id='formate_info_" + flagI + "' name='formate_info_" + flagI + "' type='text' style='width:200px;' value='" + s.ToString() + "'> <input class='price' id='formate_price_" + flagI + "' name='formate_price_" + flagI + "' type='text' style='width:80px;' value='" + modGoods.SalePrice + "'> <input class='vipPrice1' id='formate_vip1_" + flagI + "' name='formate_vip1_" + flagI + "' value='" + modGoods.vipPrice1 + "' style='width:80px;display:none' /> <input class='vipPrice2' id='formate_vip2_" + flagI + "' value='" + modGoods.vipPrice2 + "' name='formate_vip2_" + flagI + "' style='width:80px;display:none;' /> <input id='formate_stock_" + flagI + "' name='formate_stock_" + flagI + "' type='text' style='width:80px;' value='" + modGoods.Sotck + "'></div>"; flagI++; } } } return(html + "<input type='hidden' value='" + propertyNames.TrimEnd(',') + "' name='formateAllNames'>"); }
public string GetPager(int page, int rows, long catId = 0, string searchName = null) { var pager = GoodsBll.GetPager(page, rows, UserContext.CurrentUser.HotelId, catId, searchName); return(JsonConvert.SerializeObject(pager)); }