/// <summary> /// 添加主题 /// </summary> /// <param name="item"></param> /// <returns></returns> public virtual bool Add(MScenicTheme item) { string sql = "INSERT INTO tbl_ScenicTheme(ThemeName) VALUES(@ThemeName)"; DbCommand comm = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(comm, "@ThemeName", DbType.String, item.ThemeName); return(DbHelper.ExecuteSql(comm, this._db) > 0 ? true : false); }
/// <summary> /// 修改主题 /// </summary> /// <param name="item"></param> /// <returns></returns> public virtual bool Update(MScenicTheme item) { string sql = "UPDATE tbl_ScenicTheme SET ThemeName = @ThemeName WHERE ThemeId = @id"; DbCommand comm = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(comm, "@ThemeName", DbType.String, item.ThemeName); this._db.AddInParameter(comm, "@id", DbType.Int32, item.ThemeId); return(DbHelper.ExecuteSql(comm, this._db) > 0 ? true : false); }
/// <summary> /// 添加主题 /// </summary> /// <param name="item"></param> /// <returns></returns> public bool Add(MScenicTheme item) { bool result = false; if (item != null) { result = dal.Add(item); EyouSoft.Cache.Facade.EyouSoftCache.Remove(EyouSoft.CacheTag.System.ScenicTheme); } return(result); }
/// <summary> /// 获取主题 /// </summary> /// <returns></returns> public virtual IList <MScenicTheme> GetList() { string sql = "SELECT ThemeId,ThemeName FROM tbl_ScenicTheme WHERE IsDelete = '0'"; DbCommand comm = this._db.GetSqlStringCommand(sql); IList <MScenicTheme> list = new List <MScenicTheme>(); MScenicTheme item = null; using (IDataReader reader = DbHelper.ExecuteReader(comm, this._db)) { while (reader.Read()) { list.Add(item = new MScenicTheme() { ThemeId = (int)reader["ThemeId"], ThemeName = reader["ThemeName"].ToString() }); } } return(list); }
protected void btnSave_Click(object sender, EventArgs e) { MScenicArea modelScenicArea = new MScenicArea(); if (string.IsNullOrEmpty(ScenicIdAndComId[0])) { modelScenicArea.ScenicId = Guid.NewGuid().ToString(); modelScenicArea.IssueTime = DateTime.Now; } else { modelScenicArea = EyouSoft.BLL.ScenicStructure.BScenicArea.CreateInstance().GetModel(ScenicIdAndComId[0], Utils.GetFormValue(txt_CompanyId.UniqueID)); } modelScenicArea.B2B = (ScenicB2BDisplay)Enum.Parse(typeof(ScenicB2BDisplay), Utils.GetFormValue(DdlB2B.UniqueID), true); modelScenicArea.B2BOrder = Utils.GetInt(Utils.GetFormValue(txt_B2BOrder.UniqueID), 50); modelScenicArea.B2C = (ScenicB2CDisplay)Enum.Parse(typeof(ScenicB2CDisplay), Utils.GetFormValue(DdlB2C.UniqueID), true); modelScenicArea.B2COrder = Utils.GetInt(Utils.GetFormValue(txt_B2COrder.UniqueID), 50); #region 获取用户控件中省市县的数据 modelScenicArea.ProvinceId = Utils.GetInt(Utils.GetFormValue("ddl_ProvinceList")); modelScenicArea.CityId = Utils.GetInt(Utils.GetFormValue("ddl_CityList")); modelScenicArea.CountyId = Utils.GetInt(Utils.GetFormValue("ddl_CountyList")); #endregion #region 公司信息 if (!string.IsNullOrEmpty(Utils.GetFormValue(txt_CompanyId.UniqueID))) { modelScenicArea.Company = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(Utils.GetFormValue("txt_CompanyId")); } else { MessageBox.Show(Page, "请输入公司编号"); } #endregion modelScenicArea.ContactName = ""; modelScenicArea.ContactOperator = Utils.GetFormValue(ScenicContact.UniqueID); modelScenicArea.ClickNum = 0; modelScenicArea.CnAddress = Utils.GetFormValue(txt_CnAddress.UniqueID); modelScenicArea.Description = Utils.EditInputText(this.txt_Description.Value); modelScenicArea.EnAddress = Utils.GetFormValue(txt_EnAddress.UniqueID); modelScenicArea.EnName = Utils.GetFormValue(txt_EnName.UniqueID); modelScenicArea.ExamineOperator = MasterUserInfo.ID; modelScenicArea.Facilities = Utils.GetFormValue(txt_Facilities.UniqueID); modelScenicArea.Img = new List <MScenicImg>(); #region 获取地标 IList <MScenicRelationLandMark> listlank = new List <MScenicRelationLandMark>(); foreach (string item in Utils.GetFormValues("chkboxLankid")) { MScenicRelationLandMark modelMScenicRelationLandMark = new MScenicRelationLandMark(); modelMScenicRelationLandMark.ScenicId = modelScenicArea.ScenicId; modelMScenicRelationLandMark.LandMarkId = Utils.GetInt(item); listlank.Add(modelMScenicRelationLandMark); } modelScenicArea.LankId = listlank; #endregion modelScenicArea.Notes = ""; modelScenicArea.OpenTime = Utils.GetFormValue(txt_OpenTime.UniqueID); //发布用户 modelScenicArea.Operator = this.hid_Operator.Value; modelScenicArea.ScenicName = Utils.GetFormValue(txt_ScenicName.UniqueID); modelScenicArea.SetYear = Utils.GetInt(Utils.GetFormValue(txt_SetYear.UniqueID)); modelScenicArea.Telephone = Utils.GetFormValue(txt_Telephone.UniqueID); modelScenicArea.ScenicLevel = (ScenicLevel)Utils.GetInt(Utils.GetFormValue(DdlHotelStar.UniqueID)); #region 获取主题 IList <MScenicTheme> listi = new List <MScenicTheme>(); foreach (string item in Utils.GetFormValues("chbTheme")) { MScenicTheme modelTheme = new MScenicTheme(); modelTheme.ThemeId = Utils.GetInt(item); modelTheme.ThemeName = ""; listi.Add(modelTheme); } modelScenicArea.ThemeId = listi; #endregion modelScenicArea.Traffic = Utils.GetFormValue(txt_Traffic.UniqueID); modelScenicArea.Status = (ExamineStatus)Utils.GetInt(Utils.GetFormValue(DdlStatus.UniqueID)); modelScenicArea.X = Utils.InputText(this.jingdu.Value); modelScenicArea.Y = Utils.InputText(this.weidu.Value); //新增景区 if (string.IsNullOrEmpty(ScenicIdAndComId[0])) { if (EyouSoft.BLL.ScenicStructure.BScenicArea.CreateInstance().Add(modelScenicArea)) { MessageBox.ShowAndRedirect(Page, "添加成功", "ScenicList.aspx"); } else { MessageBox.Show(Page, "添加失败"); } } else { if (EyouSoft.BLL.ScenicStructure.BScenicArea.CreateInstance().Update(modelScenicArea)) { MessageBox.ShowAndRedirect(Page, "修改成功", "ScenicList.aspx"); } else { MessageBox.Show(Page, "修改失败"); } } }
/// <summary> /// 保存或添加景区 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { EyouSoft.Model.ScenicStructure.MScenicArea Model = new EyouSoft.Model.ScenicStructure.MScenicArea(); Model.ContactOperator = Utils.InputText(Utils.GetFormValue(ContactOperator.UniqueID)); Model.Company = new EyouSoft.Model.CompanyStructure.CompanyInfo(); Model.Company.ID = CompanyId; Model.Operator = this.SiteUserInfo.UserName; Model.ScenicName = Utils.InputText(this.SceniceName.Value.Trim()); Model.EnName = Utils.InputText(this.EnName.Value.Trim()); Model.X = Utils.InputText(this.jingdu.Value); Model.Y = Utils.InputText(this.weidu.Value); Model.Telephone = Utils.InputText(this.Telephone.Value.Trim()); Model.CnAddress = Utils.InputText(this.CnAddress.Value.Trim()); Model.EnAddress = Utils.InputText(this.EnAddress.Value.Trim()); Model.ScenicLevel = (ScenicLevel)Utils.GetInt(Utils.GetFormValue(ScenicLevel.UniqueID)); Model.SetYear = Utils.GetInt(this.SetYear.Value.Trim()); Model.OpenTime = Utils.InputText(this.OpenTime.Value); Model.Description = Utils.EditInputText(this.txtDescription.Text); Model.Traffic = Utils.InputText(this.Traffic.Value); Model.Facilities = Utils.InputText(this.Facilities.Value); Model.Notes = Utils.InputText(this.Notes.Value); Model.ProvinceId = EyouSoft.Common.Utils.GetInt(Utils.GetFormValue(dropProvinceId.UniqueID)); Model.CityId = EyouSoft.Common.Utils.GetInt(Utils.GetFormValue(dropCityId.UniqueID)); Model.CountyId = EyouSoft.Common.Utils.GetInt(Utils.GetFormValue(dropCountyId.UniqueID)); #region //Model.ProvinceId = Utils.GetInt(Utils.GetFormValue(this.ProvinceAndCityAndCounty1.FindControl("ddl_ProvinceList").UniqueID)); //Model.CityId = Utils.GetInt(Utils.GetFormValue(this.ProvinceAndCityAndCounty1.FindControl("ddl_CityList").UniqueID)); //Model.CountyId = Utils.GetInt(Utils.GetFormValue(this.ProvinceAndCityAndCounty1.FindControl("ddl_CountyList").UniqueID)); #endregion #region 获取主题 List <MScenicTheme> listi = new List <MScenicTheme>(); foreach (string item in Utils.GetFormValues("ThemeCheck")) { MScenicTheme modelTheme = new MScenicTheme(); modelTheme.ThemeId = Utils.GetInt(item); modelTheme.ThemeName = ""; listi.Add(modelTheme); modelTheme = null; } Model.ThemeId = listi; #endregion #region 获取地标 List <MScenicRelationLandMark> listland = new List <MScenicRelationLandMark>(); foreach (string item in Utils.GetFormValues("LandMark")) { MScenicRelationLandMark ModelLandMard = new MScenicRelationLandMark(); ModelLandMard.LandMarkId = Utils.GetInt(item); ModelLandMard.ScenicId = ""; listland.Add(ModelLandMard); ModelLandMard = null; } #endregion Model.LankId = listland; #region 判断是添加操作还是修改操作 //判断是添加操作还是修改操作! if (EditId != null && EditId != "") { Model.ScenicId = EditId; EyouSoft.Model.ScenicStructure.MScenicArea oldModel = EyouSoft.BLL.ScenicStructure.BScenicArea.CreateInstance().GetModel(EditId); Model.B2B = oldModel.B2B; Model.B2BOrder = oldModel.B2BOrder; Model.B2C = oldModel.B2C; Model.B2COrder = oldModel.B2COrder; bool resut = EyouSoft.BLL.ScenicStructure.BScenicArea.CreateInstance().Update(Model); if (resut) { MessageBox.ResponseScript(this.Page, "alert(\"修改成功!\");parent.Boxy.getIframeDialog('" + Request.QueryString["iframeId"] + "').hide();parent.topTab.url(parent.topTab.activeTabIndex,'/ScenicManage/MyScenice.aspx');"); } else { MessageBox.ResponseScript(this.Page, "alert('修改失败!');"); } } else { Model.B2B = ScenicB2BDisplay.常规; Model.B2C = ScenicB2CDisplay.常规; bool resut = EyouSoft.BLL.ScenicStructure.BScenicArea.CreateInstance().Add(Model); if (resut) { MessageBox.ResponseScript(this.Page, "alert(\"增加成功!\");parent.Boxy.getIframeDialog('" + Request.QueryString["iframeId"] + "').hide();parent.topTab.url(parent.topTab.activeTabIndex,'/ScenicManage/MyScenice.aspx');"); } else { MessageBox.ResponseScript(this.Page, "alert('增加失败!');"); } } #endregion Model = null; }