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