/// <summary> /// 得到某城市下的所有推荐产品 /// </summary> /// <param name="CityId"></param> /// <returns></returns> public IList <EyouSoft.Model.AdvStructure.ExtendProductInfo> GetExtendProductList(int CityId) { DbCommand dc = this.DB.GetStoredProcCommand("proc_SelectExtendProduct"); this.DB.AddInParameter(dc, "CityId", DbType.Int32, CityId); IList <EyouSoft.Model.AdvStructure.ExtendProductInfo> items = new List <EyouSoft.Model.AdvStructure.ExtendProductInfo>(); EyouSoft.Model.AdvStructure.ExtendProductInfo item = null; using (IDataReader rdr = DbHelper.ExecuteReader(dc, DB)) { while (rdr.Read()) { item = new EyouSoft.Model.AdvStructure.ExtendProductInfo() { ID = rdr.GetInt32(rdr.GetOrdinal("Id")), SortID = rdr.GetInt32(rdr.GetOrdinal("SortID")), ShowCity = rdr["CityName"].ToString(), ShowCityId = rdr.IsDBNull(rdr.GetOrdinal("ShowCityID")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowCityID")), ShowProId = rdr.IsDBNull(rdr.GetOrdinal("ShowProId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowProId")), CompanyID = rdr["CompanyID"].ToString(), ProductID = rdr["ProductID"].ToString() }; if (!rdr.IsDBNull(rdr.GetOrdinal("ProductInfo"))) { InputProductInfo(item, rdr.GetString(rdr.GetOrdinal("ProductInfo"))); } items.Add(item); } } return(items); }
/// <summary> /// 修改推荐产品 /// </summary> /// <param name="ExtendProductInfo"></param> /// <returns></returns> public bool UpdateExtendProduct(EyouSoft.Model.AdvStructure.ExtendProductInfo ExtendProductInfo) { DbCommand dc = this.DB.GetSqlStringCommand(SQL_UPDATE_ExtendProduct); this.DB.AddInParameter(dc, "ID", DbType.Int32, ExtendProductInfo.ID); this.DB.AddInParameter(dc, "SortID", DbType.Int32, ExtendProductInfo.SortID); this.DB.AddInParameter(dc, "ShowCityID", DbType.Int32, ExtendProductInfo.ShowCityId); this.DB.AddInParameter(dc, "ShowProID", DbType.Int32, ExtendProductInfo.ShowProId); return(DbHelper.ExecuteSql(dc, DB) > 0 ? true : false); }
/// <summary> /// 添加推荐产品 /// </summary> /// <param name="ExtendProductInfo"></param> /// <returns></returns> public bool AddExtendProduct(EyouSoft.Model.AdvStructure.ExtendProductInfo ExtendProductInfo) { if (!string.IsNullOrEmpty(ExtendProductInfo.ProductID) && ExtendProductInfo.ShowCityId != 0 && !IsZixst(ExtendProductInfo.ShowCityId, ExtendProductInfo.ProductID)) { return(dal.AddExtendProduct(ExtendProductInfo)); } else { return(false); } }
/// <summary> /// 设置产品信息 /// </summary> /// <param name="model"></param> private void InputProductInfo(EyouSoft.Model.AdvStructure.ExtendProductInfo model, string ProductInfo) { XElement root = XElement.Parse(ProductInfo).Element("row"); if (root != null) { model.ProductName = EyouSoft.Common.Utility.GetXAttributeValue(root, "RouteName"); model.CompanyName = EyouSoft.Common.Utility.GetXAttributeValue(root, "CompanyName"); model.ContactMQ = EyouSoft.Common.Utility.GetXAttributeValue(root, "TourContacMQ"); model.Price = EyouSoft.Common.Utility.GetDecimal(EyouSoft.Common.Utility.GetXAttributeValue(root, "RetailAdultPrice")); } }
protected void btnSave_Click(object sender, EventArgs e) { //定义推荐产品集合列表 IList <EyouSoft.Model.AdvStructure.ExtendProductInfo> list = new List <EyouSoft.Model.AdvStructure.ExtendProductInfo>(); //城市编号 int CurrCityId = Utils.GetInt(hCurrCityId.Value, 362); //省份编号 int CurrProvinceId = Utils.GetInt(hCurrProvinceId.Value, 33); //省份名称 string CurrCityName = hCurrCityName.Value; //主键ID string[] Ids = Utils.GetFormValues("hKeyId"); //公司Id string[] CompanyIds = Utils.GetFormValues("hCId"); //排序号 string[] SotrNums = Utils.GetFormValues("txt_Sort"); //产品价格 string[] ProductPrices = Utils.GetFormValues("hPrice"); //产品名称 string[] ProductNames = Utils.GetFormValues("hProductName"); //产品编号 string[] ProductIDS = Utils.GetFormValues("hProductId"); //公司名称 string[] CompanyNames = Utils.GetFormValues("hfCompanyName"); //联系MQ string[] ContactMQS = Utils.GetFormValues("hfMQ"); for (int i = 0; i < Ids.Length; i++) { //定义推荐产品实体对象 EyouSoft.Model.AdvStructure.ExtendProductInfo model = new EyouSoft.Model.AdvStructure.ExtendProductInfo(); model.CompanyID = CompanyIds[i]; model.CompanyName = CompanyNames[i]; model.ProductName = ProductNames[i]; model.ContactMQ = ContactMQS[i]; model.Price = Utils.GetDecimal(ProductPrices[i], 0); model.ProductID = ProductIDS[i]; model.ID = int.Parse(Ids[i]); model.ShowCity = CurrCityName; model.ShowCityId = CurrCityId; model.ShowProId = CurrProvinceId; model.SortID = int.Parse(SotrNums[i]); list.Add(model); model = null; } if (list.Count > 0) { bool result = EyouSoft.BLL.AdvStructure.ExtendProduct.CreateInstance().UpdateExtendProduct(list); MessageBox.ShowAndRedirect(this, result ? "保存成功!" : "保存失败!", "/AdManagement/RecommendProductList.aspx"); } }
/// <summary> /// 添加推荐产品 /// </summary> /// <param name="ExtendProductInfo"></param> /// <returns></returns> public bool AddExtendProduct(EyouSoft.Model.AdvStructure.ExtendProductInfo ExtendProductInfo) { DbCommand dc = this.DB.GetSqlStringCommand(SQL_ADD_ExtendProduct); this.DB.AddInParameter(dc, "SortID", DbType.Int32, ExtendProductInfo.SortID); this.DB.AddInParameter(dc, "CompanyID", DbType.AnsiStringFixedLength, ExtendProductInfo.CompanyID); this.DB.AddInParameter(dc, "ProductID", DbType.AnsiStringFixedLength, ExtendProductInfo.ProductID); this.DB.AddInParameter(dc, "ProductName", DbType.String, ExtendProductInfo.ProductName); this.DB.AddInParameter(dc, "Price", DbType.Decimal, ExtendProductInfo.Price); this.DB.AddInParameter(dc, "ShowCityID", DbType.Int32, ExtendProductInfo.ShowCityId); this.DB.AddInParameter(dc, "ShowProID", DbType.Int32, ExtendProductInfo.ShowProId); return(DbHelper.ExecuteSql(dc, DB) > 0 ? true : false); }
/// <summary> /// 得到所有首页推荐产品 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <returns></returns> public IList <EyouSoft.Model.AdvStructure.ExtendProductInfo> GetExtendProductList(int pageSize, int pageIndex, ref int recordCount) { IList <EyouSoft.Model.AdvStructure.ExtendProductInfo> items = new List <EyouSoft.Model.AdvStructure.ExtendProductInfo>(); EyouSoft.Model.AdvStructure.ExtendProductInfo item = null; StringBuilder cmdQuery = new StringBuilder(); string tableName = "tbl_ExtendProduct"; string primaryKey = "Id"; string orderByString = "SortId ASC"; StringBuilder fields = new StringBuilder(); #region 要查询的字段 fields.Append(" *,(select CityName from tbl_SysCity where ID=tbl_ExtendProduct.ShowCityID) as cityname,(select RouteName,CompanyName,TourContacMQ,RetailAdultPrice from tbl_TourList where ID=tbl_ExtendProduct.ProductID FOR XML RAW,ROOT('ROOT')) as ProductInfo "); #endregion #region 拼接查询条件 #endregion using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { item = new EyouSoft.Model.AdvStructure.ExtendProductInfo() { ID = rdr.GetInt32(rdr.GetOrdinal("Id")), SortID = rdr.GetInt32(rdr.GetOrdinal("SortID")), ShowCity = rdr["CityName"].ToString(), ShowCityId = rdr.IsDBNull(rdr.GetOrdinal("ShowCityID")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowCityID")), ShowProId = rdr.IsDBNull(rdr.GetOrdinal("ShowProId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowProId")), CompanyID = rdr["CompanyID"].ToString(), ProductID = rdr["ProductID"].ToString() }; if (!rdr.IsDBNull(rdr.GetOrdinal("ProductInfo"))) { InputProductInfo(item, rdr.GetString(rdr.GetOrdinal("ProductInfo"))); } items.Add(item); } } return(items); }
/// <summary> /// 修改推荐产品 /// </summary> /// <param name="ExtendProductInfo"></param> /// <returns></returns> public bool UpdateExtendProduct(EyouSoft.Model.AdvStructure.ExtendProductInfo ExtendProductInfo) { return(dal.UpdateExtendProduct(ExtendProductInfo)); }
protected void Page_Load(object sender, EventArgs e) { if (!CheckMasterGrant(YuYingPermission.业114广告_管理该栏目)) { Utils.ResponseNoPermit(YuYingPermission.业114广告_管理该栏目, true); return; } #region 异步删除数据 if (Request.QueryString["mode"] != null && Request.QueryString["mode"].ToString() == "del") { bool result = EyouSoft.BLL.AdvStructure.ExtendProduct.CreateInstance().DelExtendProduct(Utils.GetInt(Request.QueryString["id"], 0)); Response.Clear(); if (result) { Response.Write("success"); } else { Response.Write("error"); } Response.End(); } #endregion #region 异步添加数据 if (Request.QueryString["mode"] != null && Request.QueryString["mode"].ToString() == "add") { string strHtml = "error"; Response.Clear(); //产品ID string productId = Request.QueryString["ProductID"]; //产品名称 string productName = Request.QueryString["ProductName"]; ////产品价格 //decimal productPrice = Utils.GetDecimal(Request.QueryString["ProductPrice"], 0); int CityId = Utils.GetInt(Request.QueryString["cityid"], 0); string companyId = Request.QueryString["cid"] == null ? "" : Request.QueryString["cid"].ToString(); if (CityId > 0 && !string.IsNullOrEmpty(companyId)) { EyouSoft.Model.AdvStructure.ExtendProductInfo model = new EyouSoft.Model.AdvStructure.ExtendProductInfo(); model.CompanyID = companyId; model.ShowCityId = CityId; //model.Price = productPrice; model.ProductName = productName; model.ProductID = productId; model.SortID = 0; EyouSoft.BLL.AdvStructure.ExtendProduct.CreateInstance().AddExtendProduct(model); strHtml = JsonConvert.SerializeObject(EyouSoft.BLL.AdvStructure.ExtendProduct.CreateInstance().GetExtendProductList(CityId)); model = null; } Response.Write(strHtml); Response.End(); } #endregion if (Request.QueryString["mode"] != null && (Request.QueryString["mode"].ToString().ToLower() == "getlist" || Request.QueryString["mode"].ToString().ToLower() == "getalllist")) { BindList(); } }