/// <summary> /// 得到一个对象实体 /// </summary> public Model.ThumbnailsSetting GetModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,ThumbnailsWidth,ThumbnailsHeight,ImageWidth,ImageHeight,Type,WatermarkPicturePath,Characters,ImgTransparent,CharTransparent,WatermarkPosition from yxs_ThumbnailsSetting "); Model.ThumbnailsSetting model = new Model.ThumbnailsSetting(); DataSet ds = ExecuteDataSet(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.ThumbnailsWidth = ds.Tables[0].Rows[0]["ThumbnailsWidth"].ToString(); model.ThumbnailsHeight = ds.Tables[0].Rows[0]["ThumbnailsHeight"].ToString(); model.ImageWidth = ds.Tables[0].Rows[0]["ImageWidth"].ToString(); model.ImageHeight = ds.Tables[0].Rows[0]["ImageHeight"].ToString(); model.Type = ds.Tables[0].Rows[0]["Type"].ToString(); model.WatermarkPicturePath = ds.Tables[0].Rows[0]["WatermarkPicturePath"].ToString(); model.Characters = ds.Tables[0].Rows[0]["Characters"].ToString(); model.ImgTransparent = ds.Tables[0].Rows[0]["ImgTransparent"].ToString(); if (ds.Tables[0].Rows[0]["CharTransparent"].ToString() != "") { model.CharTransparent = int.Parse(ds.Tables[0].Rows[0]["CharTransparent"].ToString()); } model.WatermarkPosition = ds.Tables[0].Rows[0]["WatermarkPosition"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.ThumbnailsSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update yxs_ThumbnailsSetting set "); strSql.Append("ThumbnailsWidth=@ThumbnailsWidth,"); strSql.Append("ThumbnailsHeight=@ThumbnailsHeight,"); strSql.Append("ImageWidth=@ImageWidth,"); strSql.Append("ImageHeight=@ImageHeight,"); strSql.Append("Type=@Type,"); strSql.Append("WatermarkPicturePath=@WatermarkPicturePath,"); strSql.Append("Characters=@Characters,"); strSql.Append("ImgTransparent=@ImgTransparent,"); strSql.Append("CharTransparent=@CharTransparent,"); strSql.Append("WatermarkPosition=@WatermarkPosition"); strSql.Append(" where Id=@Id "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Id", DbType.Int32, model.Id); db.AddInParameter(dbCommand, "ThumbnailsWidth", DbType.AnsiString, model.ThumbnailsWidth); db.AddInParameter(dbCommand, "ThumbnailsHeight", DbType.AnsiString, model.ThumbnailsHeight); db.AddInParameter(dbCommand, "ImageWidth", DbType.AnsiString, model.ImageWidth); db.AddInParameter(dbCommand, "ImageHeight", DbType.AnsiString, model.ImageHeight); db.AddInParameter(dbCommand, "Type", DbType.AnsiString, model.Type); db.AddInParameter(dbCommand, "WatermarkPicturePath", DbType.AnsiString, model.WatermarkPicturePath); db.AddInParameter(dbCommand, "Characters", DbType.AnsiString, model.Characters); db.AddInParameter(dbCommand, "ImgTransparent", DbType.AnsiString, model.ImgTransparent); db.AddInParameter(dbCommand, "CharTransparent", DbType.Int32, model.CharTransparent); db.AddInParameter(dbCommand, "WatermarkPosition", DbType.AnsiString, model.WatermarkPosition); return(0 < db.ExecuteNonQuery(dbCommand)); }
public SysParameter() { string cc_WebSetting = "WebSetting"; string cc_CustomerSetting = "CustomerSetting"; string cc_ThumbnailsSetting = "ThumbnailsSetting"; string cc_ShopSetting = "ShopSetting"; #region 系统参数设置 object objWebSetting = GetObject(cc_WebSetting); Model.WebSetting wsmodel = null; if (objWebSetting != null) { wsmodel = (Model.WebSetting)objWebSetting; } else { BLL.WebSetting wsbll = new BLL.WebSetting(); wsmodel = wsbll.GetModel(); SetObject(cc_WebSetting, wsmodel); } if (wsmodel != null) { imageSize = wsmodel.Filesize; _isopensite = wsmodel.CloseWebSite == 1 ? true : false; _isopenshops = wsmodel.CloseShop == 1 ? true : false; _isopenbbs = wsmodel.CloseBBS == 1 ? true : false; _sitehttp = wsmodel.WebSiteDomain; _dummypath = wsmodel.WebSitePath; _websitename = wsmodel.WebSiteName; _websitetitle = wsmodel.WebSiteTitle; _websitedescription = wsmodel.MeteInfo; _websitekey = wsmodel.MeteKey; _websitetemplatepath = wsmodel.TmplatePath; _websitelogo = wsmodel.LogoPath; _websitebanner = wsmodel.BannerPath; _isrewrite = wsmodel.PublicMethod == 0 ? true : false; _staticpagefiletype = wsmodel.StaticPageFileType; _isclosestation = wsmodel.CloseStation == 1 ? true : false; _sitetel = wsmodel.Tel; _sitefax = wsmodel.Fax; _siteemail = wsmodel.Email; _copyright = wsmodel.CopyRight; _issession = wsmodel.LoginMothod == 0 ? true : false; _colecsitedescription = wsmodel.CloseWebSiteInfo; _statisticalCode = wsmodel.Statisticscode; } #endregion #region 用户参数设置 object objCustomerSetting = GetObject(cc_CustomerSetting); Model.CustomerSetting csmodel = null; if (objCustomerSetting != null) { csmodel = (Model.CustomerSetting)objCustomerSetting; } else { BLL.CustomerSetting csbll = new BLL.CustomerSetting(); csmodel = csbll.GetModel(); SetObject(cc_CustomerSetting, csmodel); } if (csmodel != null) { _isregistered = csmodel.AllowRegister.Trim() == "1" ? true : false; _sameemailregister = csmodel.SameEmailRegister == 1 ? true : false; _adminvalidate = csmodel.AdminValidate == 1 ? true : false; _emailvalidate = csmodel.EmailValidate == 1 ? true : false; _emailvalidatecontent = csmodel.EmailValidateContent.Trim(); _handselcoupons = csmodel.HandselCoupons == 1 ? true : false; _handselcouponsnumber = Convert.ToInt32(csmodel.HandselCouponsNumber); _handselcouponsbegintime = Convert.ToDateTime(csmodel.HandselCouponsBeginTime); _handselcouponsendtime = Convert.ToDateTime(csmodel.HandselCouponsEndTime); _handselpoint = csmodel.HandselPoint; _forbiduserid = csmodel.ForbidUserId; _userdefaultgroup = csmodel.UserDefaultGroup; _loginpoint = Convert.ToDecimal(csmodel.LoginPoint); _isloginvalidate = csmodel.LoginIsNeedCheckCode == 1 ? true : false; _ismultilogin = csmodel.AllowOtherLogin == 1 ? true : false; } #endregion #region 缩略图参数设置 object objThumbnailsSetting = GetObject(cc_ThumbnailsSetting); Model.ThumbnailsSetting tsmodel = null; if (objThumbnailsSetting != null) { tsmodel = (Model.ThumbnailsSetting)objThumbnailsSetting; } else { BLL.ThumbnailsSetting tsbll = new BLL.ThumbnailsSetting(); tsmodel = tsbll.GetModel(); SetObject(cc_ThumbnailsSetting, tsmodel); } if (tsmodel != null) { _thumbnailsheight = Convert.ToInt32(tsmodel.ThumbnailsHeight); _thumbnailswidth = Convert.ToInt32(tsmodel.ThumbnailsWidth); _imagesthumbnailsheight = Convert.ToInt32(tsmodel.ImageHeight); _imagesthumbnailswidth = Convert.ToInt32(tsmodel.ImageWidth); _imagewatermarktransparent = Convert.ToInt32(tsmodel.ImgTransparent); _textwatermarktransparent = Convert.ToInt32(tsmodel.CharTransparent); _watermarktext = tsmodel.Characters; _watermarkimage = tsmodel.WatermarkPicturePath; _watermarkposition = tsmodel.WatermarkPosition; _textorimageswatermark = tsmodel.Type; } #endregion #region 商铺参数设置 object objShopSetting = GetObject(cc_ShopSetting); Model.ShopSetting ssmodel = null; if (objShopSetting != null) { ssmodel = (Model.ShopSetting)objShopSetting; } else { BLL.ShopSetting ssbll = new BLL.ShopSetting(); ssmodel = ssbll.GetModel(); SetObject(cc_ShopSetting, ssmodel); } if (ssmodel != null) { _isthumbnails = ssmodel.Thumbnails == 1 ? true : false; _iswatermark = ssmodel.WaterMark == 1 ? true : false; _allowgroupbuydeposit = ssmodel.AllowGroupbuyDeposit == 1 ? true : false; _allowauctiondeposit = ssmodel.AllowAuctionDeposit == 1 ? true : false; _ispaymentweboperation = ssmodel.OrdersReceive == 1 ? true : false; _ordersText = ssmodel.OrdersText; } #endregion }