/// <summary> /// 得到一个对象实体 /// </summary> public Model.ShopSetting GetModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ShopId,AllowVisitorBuy,Coupon,Thumbnails,WaterMark,NumberLimit,OrdersReceive,OrdersText,Tel,Adress,Zip,allowgroupbuydeposit,allowauctiondeposit from yxs_ShopSetting "); Model.ShopSetting model = new Model.ShopSetting(); DataSet ds = ExecuteDataSet(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ShopId"].ToString() != "") { model.ShopId = int.Parse(ds.Tables[0].Rows[0]["ShopId"].ToString()); } if (ds.Tables[0].Rows[0]["AllowVisitorBuy"].ToString() != "") { model.AllowVisitorBuy = int.Parse(ds.Tables[0].Rows[0]["AllowVisitorBuy"].ToString()); } if (ds.Tables[0].Rows[0]["Coupon"].ToString() != "") { model.Coupon = int.Parse(ds.Tables[0].Rows[0]["Coupon"].ToString()); } if (ds.Tables[0].Rows[0]["Thumbnails"].ToString() != "") { model.Thumbnails = int.Parse(ds.Tables[0].Rows[0]["Thumbnails"].ToString()); } if (ds.Tables[0].Rows[0]["WaterMark"].ToString() != "") { model.WaterMark = int.Parse(ds.Tables[0].Rows[0]["WaterMark"].ToString()); } if (ds.Tables[0].Rows[0]["NumberLimit"].ToString() != "") { model.NumberLimit = int.Parse(ds.Tables[0].Rows[0]["NumberLimit"].ToString()); } if (ds.Tables[0].Rows[0]["OrdersReceive"].ToString() != "") { model.OrdersReceive = int.Parse(ds.Tables[0].Rows[0]["OrdersReceive"].ToString()); } model.OrdersText = ds.Tables[0].Rows[0]["OrdersText"].ToString(); model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString(); model.Adress = ds.Tables[0].Rows[0]["Adress"].ToString(); model.Zip = ds.Tables[0].Rows[0]["Zip"].ToString(); if (ds.Tables[0].Rows[0]["allowgroupbuydeposit"].ToString() != "") { model.AllowGroupbuyDeposit = int.Parse(ds.Tables[0].Rows[0]["allowgroupbuydeposit"].ToString()); } if (ds.Tables[0].Rows[0]["allowauctiondeposit"].ToString() != "") { model.AllowAuctionDeposit = int.Parse(ds.Tables[0].Rows[0]["allowauctiondeposit"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.ShopSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update yxs_ShopSetting set "); strSql.Append("AllowVisitorBuy=@AllowVisitorBuy,"); strSql.Append("Coupon=@Coupon,"); strSql.Append("Thumbnails=@Thumbnails,"); strSql.Append("WaterMark=@WaterMark,"); strSql.Append("NumberLimit=@NumberLimit,"); strSql.Append("OrdersReceive=@OrdersReceive,"); strSql.Append("OrdersText=@OrdersText,"); strSql.Append("Tel=@Tel,"); strSql.Append("Adress=@Adress,"); strSql.Append("Zip=@Zip,"); strSql.Append("allowgroupbuydeposit=@allowgroupbuydeposit,"); strSql.Append("allowauctiondeposit=@allowauctiondeposit"); strSql.Append(" where ShopId=@ShopId "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ShopId", DbType.Int32, model.ShopId); db.AddInParameter(dbCommand, "AllowVisitorBuy", DbType.Int32, model.AllowVisitorBuy); db.AddInParameter(dbCommand, "Coupon", DbType.Int32, model.Coupon); db.AddInParameter(dbCommand, "Thumbnails", DbType.Int32, model.Thumbnails); db.AddInParameter(dbCommand, "WaterMark", DbType.Int32, model.WaterMark); db.AddInParameter(dbCommand, "NumberLimit", DbType.Int32, model.NumberLimit); db.AddInParameter(dbCommand, "OrdersReceive", DbType.Int32, model.OrdersReceive); db.AddInParameter(dbCommand, "OrdersText", DbType.AnsiString, model.OrdersText); db.AddInParameter(dbCommand, "Tel", DbType.AnsiString, model.Tel); db.AddInParameter(dbCommand, "Adress", DbType.AnsiString, model.Adress); db.AddInParameter(dbCommand, "Zip", DbType.AnsiString, model.Zip); db.AddInParameter(dbCommand, "allowgroupbuydeposit", DbType.Int32, model.AllowGroupbuyDeposit); db.AddInParameter(dbCommand, "allowauctiondeposit", DbType.Int32, model.AllowAuctionDeposit); 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 }