/// <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
}
