// 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));
}
