protected void btnSave_Click(object sender, EventArgs e) { Cms.Model.ProductInfo model = new Cms.Model.ProductInfo(); string strErr = ""; if (!PageValidate.IsDateTime(txtPubTime.Text)) { strErr += "发布时间格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } if (this.ddlTypeId.SelectedValue == "") { MessageBox.Show(this, "请选择商品类型!"); return; } if (this.ddlBrandId.SelectedValue == "") { MessageBox.Show(this, "请选择商品品牌!"); return; } if (this.ddlNameId.SelectedValue == "") { MessageBox.Show(this, "请选择商品名称!"); return; } Cms.DAL.ProductInfo dal = new Cms.DAL.ProductInfo(); model.Specifications = txtSpec.Text.Trim(); model.ImgUrl = txtImgUrl.Text.Trim(); model.SmallImgUrl = txtImgUrl.Text.Trim(); model.Description = Cms.Common.Utils.ToHtml(ProductDetail.Text); model.Click = int.Parse(txtClick.Text.Trim()); model.PubTime = DateTime.Parse(txtPubTime.Text); model.IsTop = 0; if (cblItem.Items[0].Selected == true) { model.IsTop = 1; } model.TypeId = int.Parse(this.ddlTypeId.SelectedValue.Trim()); model.BrandId = int.Parse(this.ddlBrandId.SelectedValue.Trim()); model.NameId = int.Parse(this.ddlNameId.SelectedValue.Trim()); int ReId = dal.Add(model); if (ReId > 0) { MessageBox.Show(this, "产品型号信息添加成功!"); //Coolite.Ext.Web.Ext.MessageBox.Alert("提示", "产品型号信息修改成功").Show(); } else { MessageBox.Show(this, "添加过程中发生错误!"); //Coolite.Ext.Web.Ext.MessageBox.Alert("提示", "发布过程中发生错误").Show(); } }
protected void lbtnImport_Click(object sender, EventArgs e) { string fullPath = HttpContext.Current.Server.MapPath(importFilePath.Text); if (!File.Exists(fullPath)) { //保存日志 MessageBox.Show(this, "请上传导入文件!"); return; } DataSet ds = ExcelToDS( fullPath ); DataTable tb = ds.Tables[0]; if (tb.Rows.Count > 0) { Cms.DAL.Channel dal = new Cms.DAL.Channel(); Cms.DAL.ProductInfo proDAL = new Cms.DAL.ProductInfo(); for (int i = 0; i < tb.Rows.Count; i++) { DataRow proRow = tb.Rows[i]; string type = proRow["商品类型"].ToString(); string brand = proRow["商品品牌"].ToString(); string name = proRow["商品名称"].ToString(); string spec = proRow["商品型号"].ToString(); int procNum = int.Parse(proRow["数量"].ToString()); int typeID = dal.GetProductTypeID(type); if (typeID == -1) typeID = dal.AddProductType(type); int brandID = dal.GetProductBrandID(brand, typeID); if (brandID == -1) brandID = dal.AddProductBrand(brand, typeID); int nameID = dal.GetProductNameID(name, typeID, brandID); if (nameID == -1) nameID = dal.AddProductName(name, typeID, brandID); int specID = 0; if (!proDAL.Exists(spec, typeID, brandID, nameID)) { Cms.Model.ProductInfo model = new Cms.Model.ProductInfo(); model.Specifications = spec; model.ImgUrl = ""; model.SmallImgUrl = ""; model.Description = ""; model.Click = 0; model.PubTime = DateTime.Now; model.IsTop = 0; model.TypeId = typeID; model.BrandId = brandID; model.NameId = nameID; specID = proDAL.Add(model); } if (specID > 0) { proDAL.AddStock(typeID, brandID, nameID, specID, procNum, procNum); } } } File.Delete( fullPath ); //保存日志 MessageBox.Show(this, "数据导入成功!"); }
protected void lbtnImport_Click(object sender, EventArgs e) { string fullPath = HttpContext.Current.Server.MapPath(importFilePath.Text); if (!File.Exists(fullPath)) { //保存日志 MessageBox.Show(this, "请上传导入文件!"); return; } DataSet ds = ExcelToDS(fullPath); DataTable tb = ds.Tables[0]; if (tb.Rows.Count > 0) { Cms.DAL.Channel dal = new Cms.DAL.Channel(); Cms.DAL.ProductInfo proDAL = new Cms.DAL.ProductInfo(); for (int i = 0; i < tb.Rows.Count; i++) { DataRow proRow = tb.Rows[i]; string type = proRow["商品类型"].ToString(); string brand = proRow["商品品牌"].ToString(); string name = proRow["商品名称"].ToString(); string spec = proRow["商品型号"].ToString(); int procNum = int.Parse(proRow["数量"].ToString()); int typeID = dal.GetProductTypeID(type); if (typeID == -1) { typeID = dal.AddProductType(type); } int brandID = dal.GetProductBrandID(brand, typeID); if (brandID == -1) { brandID = dal.AddProductBrand(brand, typeID); } int nameID = dal.GetProductNameID(name, typeID, brandID); if (nameID == -1) { nameID = dal.AddProductName(name, typeID, brandID); } int specID = 0; if (!proDAL.Exists(spec, typeID, brandID, nameID)) { Cms.Model.ProductInfo model = new Cms.Model.ProductInfo(); model.Specifications = spec; model.ImgUrl = ""; model.SmallImgUrl = ""; model.Description = ""; model.Click = 0; model.PubTime = DateTime.Now; model.IsTop = 0; model.TypeId = typeID; model.BrandId = brandID; model.NameId = nameID; specID = proDAL.Add(model); } if (specID > 0) { proDAL.AddStock(typeID, brandID, nameID, specID, procNum, procNum); } } } File.Delete(fullPath); //保存日志 MessageBox.Show(this, "数据导入成功!"); }