private static void UpdateSystemConfig() { SystemConfigFacade sf = new SystemConfigFacade(); DataSet sysConfigData = sf.FindAll(); ArrayList sysConfigCollection = new ArrayList(); Skynet.Framework.Common.SystemConfig sysConfig = null; foreach (DataRow row in sysConfigData.Tables[0].Rows) { sysConfig = new Skynet.Framework.Common.SystemConfig(); //配置编号 sysConfig.ConfigureNo = row["CONFIGURENO"].ToString().Trim(); //设置类型 sysConfig.SetType = row["SETTYPE"].ToString().Trim(); //设置内容 sysConfig.SetContent = row["SETCONTENT"].ToString().Trim(); //设置值 sysConfig.DefaultValue = row["DEFAULTVALUE"].ToString().Trim(); //说明 sysConfig.Detail = row["DETAIL"].ToString().Trim(); //可选参数 sysConfig.OptionalPara = row["OPTIONALPARA"].ToString().Trim(); sysConfigCollection.Add(sysConfig); } SystemInfo.SystemConfigs = new SystemConfigCollection(); SystemInfo.SystemConfigs.Init(sysConfigCollection); }
protected void btnUpDatePic_Click(object sender, EventArgs e) { RetrieveCriteria rcGoodsPics = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity)); rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO); rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__NAME); rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL); Condition c = rcGoodsPics.GetNewCondition(); c.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1); c.AddNotEqualTo(XiHuan_UserGoodsEntity.__DEFAULTPHOTO, "images/none.jpg"); rcGoodsPics.OrderBy(XiHuan_UserGoodsEntity.__CREATEDATE, false); rcGoodsPics.Top = 6; EntityContainer ecGoods = rcGoodsPics.AsEntityContainer(); string pics = "var pics=\""; string links = "var links=\""; string texts = "var texts=\""; foreach (XiHuan_UserGoodsEntity goods in ecGoods) { pics += goods.DefaultPhoto.Replace(GlobalVar.DefaultPhotoSize, GlobalVar.BigPhotoSize) + "|"; links += goods.DetailUrl + "|"; texts += ValidatorHelper.SafeSql(goods.Name) + "|"; } pics = pics.TrimEnd('|') + "\";"; links = links.TrimEnd('|') + "\";"; texts = texts.TrimEnd('|') + "\";"; Query.ProcessSqlNonQuery(string.Format("update xihuan_systemconfig set configvalue='{0}' where configkey='HomeRounPics'", pics + links + texts), GlobalVar.DataBase_Name); SystemConfigFacade.Refresh(); Alert("幻灯片成功更新!"); }
protected override void Page_PreLoad() { GenerateMeta("Content-Type", string.Empty, "text/html;charset=GB2312", 0); //开启IE8兼容模式 GenerateMeta("X-UA-Compatible", string.Empty, "IE=EmulateIE7", 1); GenerateMeta(string.Empty, "keywords", GoodDetail.UserName + "的换铺," + SystemConfigFacade.Instance().WebSiteKeyWords, 2); GenerateMeta(string.Empty, "description", GoodDetail.UserName + "的换铺,换客,交换,物品交换,喜换网换客换铺是换客的免费交换平台,供换客用来展示换品最快最好的完成交换。", 3); GenerateMeta(string.Empty, "Robots", "All", 4); GenerateMeta(string.Empty, "GOOGLEBOT", "All", 5); GenerateMeta(string.Empty, "verify-v1", "2WI+gttAG3Vgo7KoaYDT/7Fb1mXT6UGwvFpYYrVkUkU=", 6); GenerateMeta(string.Empty, "y_key", "f00a394915068b18", 7); HtmlLink maincss = new HtmlLink(); maincss.Attributes["type"] = "text/css"; maincss.Attributes["href"] = SrcRootPath + "App_Themes/Default/style.css"; maincss.Attributes["rel"] = "stylesheet"; Header.Controls.AddAt(8, maincss); HtmlLink ymcss = new HtmlLink(); ymcss.Attributes["type"] = "text/css"; ymcss.Attributes["href"] = SrcRootPath + "Js/ymPromot/skin/qq/ymPrompt.css"; ymcss.Attributes["rel"] = "stylesheet"; Header.Controls.AddAt(9, ymcss); GenerateScript(SrcRootPath + "Js/ymPromot/ymPrompt.js", 10); GenerateScript(SrcRootPath + "Js/common.js", 11); GenerateScript("http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js", 12); HtmlLink favicon = new HtmlLink(); favicon.Attributes["rel"] = "shortcut icon'"; favicon.Attributes["href"] = SrcRootPath + "images/favicon.ico"; Header.Controls.AddAt(13, favicon); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { base.Page_Load(); txtFFZF.Text = SystemConfigFacade.Instance().FFZF; rbtIsGoodsAddNeedCheck.SelectedValue = SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? "1" : "0"; txtStartDate.Text = DateTime.Now.AddMonths(-3).ToShortDateString(); txtEndDate.Text = DateTime.Now.ToShortDateString(); } }
private void InitPage() { int id = CommonMethod.ConvertToInt(Request["id"], 0); XiHuan_NewsEntity news = new XiHuan_NewsEntity(); news.Id = id; news.Retrieve(); if (news.IsPersistent) { lblType.Text = Enum.GetName(typeof(XiHuan_NewsFacade.NewsType), news.Type); lblTitle.Text = lblTitle2.Text = news.Title; lblTime.Text = news.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"); lblContent.Text = news.Content; Header.Title = news.Title + "-" + SystemConfigFacade.Instance().WebSiteTitle; hidId.Value = id.ToString(); } string sql = string.Format(@"select top 1 Title,NewsUrl from XiHuan_News with(nolock) where Id<{0} order by Id desc; select top 1 Title,NewsUrl from XiHuan_News with(nolock) where Id>{0} ; select Top 10 Title,NewsUrl from XiHuan_News with(nolock) order by ViewCount desc; ", id); DataSet ds = Query.ProcessMultiSql(sql, GlobalVar.DataBase_Name); DataTable dtpre = ds.Tables[0]; string url = string.Empty; if (dtpre != null && dtpre.Rows.Count > 0) { url = CommonMethod.FinalString(dtpre.Rows[0][1]); bool res = (url.ToLower().IndexOf("http") > -1); lblPre.Text = string.Format("<a title=\"{0}\" href=\"{1}\" target=\"{2}\">{0}</a>", dtpre.Rows[0][0], res ? url : SrcRootPath + url, res ? "_blank" : "_self"); } else { lblPre.Text = "没有了"; } DataTable dtnext = ds.Tables[1]; if (dtnext != null && dtnext.Rows.Count > 0) { url = CommonMethod.FinalString(dtnext.Rows[0][1]); bool res = (url.ToLower().IndexOf("http") > -1); lblNext.Text = string.Format("<a title=\"{0}\" href=\"{1}\">{0}</a>", dtnext.Rows[0][0], res ? url : SrcRootPath + url, res ? "_blank" : "_self"); } else { lblNext.Text = "没有了"; } rptHotNews.DataSource = ds.Tables[2]; rptHotNews.DataBind(); }
protected override void Page_PreLoad() { Header.Title = GoodDetail.Name + "--" + SystemConfigFacade.Instance().WebSiteTitle; GenerateMeta("Content-Type", string.Empty, "text/html;charset=GB2312", 0); //开启IE8兼容模式 GenerateMeta("X-UA-Compatible", string.Empty, "IE=EmulateIE7", 1); GenerateMeta(string.Empty, "keywords", GoodDetail.Name + "," + XiHuan_UserGoodsFacade.GetTypeNameById(GoodDetail.TypeId.ToString()) + "," + XiHuan_UserGoodsFacade.GetSecondTypeNameById(GoodDetail.TypeId.ToString(), GoodDetail.ChildId.ToString()), 2); GenerateMeta(string.Empty, "description", GoodDetail.Name + "," + SystemConfigFacade.Instance().WebSiteDescription, 3); GenerateMeta(string.Empty, "Robots", "All", 4); GenerateMeta(string.Empty, "GOOGLEBOT", "All", 5); GenerateMeta(string.Empty, "verify-v1", "2WI+gttAG3Vgo7KoaYDT/7Fb1mXT6UGwvFpYYrVkUkU=", 6); GenerateMeta(string.Empty, "y_key", "f00a394915068b18", 7); HtmlLink maincss = new HtmlLink(); maincss.Attributes["type"] = "text/css"; maincss.Attributes["href"] = SrcRootPath + "App_Themes/Default/style.css"; maincss.Attributes["rel"] = "stylesheet"; Header.Controls.AddAt(8, maincss); HtmlLink ymcss = new HtmlLink(); ymcss.Attributes["type"] = "text/css"; ymcss.Attributes["href"] = SrcRootPath + "Js/ymPromot/skin/qq/ymPrompt.css"; ymcss.Attributes["rel"] = "stylesheet"; Header.Controls.AddAt(9, ymcss); int i = 9; if (GoodDetail.DefaultPhoto != null && GoodDetail.DefaultPhoto.Trim().Length > 0 && !GoodDetail.DefaultPhoto.Trim().Equals("images/none.jpg")) { HtmlLink highslidecss = new HtmlLink(); highslidecss.Attributes["type"] = "text/css"; highslidecss.Attributes["href"] = SrcRootPath + "Js/highslide/highslide.css"; highslidecss.Attributes["rel"] = "stylesheet"; Header.Controls.AddAt(10, highslidecss); i = 10; } GenerateScript(SrcRootPath + "Js/ymPromot/ymPrompt.js", i + 1); GenerateScript(SrcRootPath + "Js/common.js", i + 2); GenerateScript("http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js", i + 3); HtmlLink favicon = new HtmlLink(); favicon.Attributes["rel"] = "shortcut icon'"; favicon.Attributes["href"] = SrcRootPath + "images/favicon.ico"; Header.Controls.AddAt(i + 4, favicon); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!IsUserAlreadyLogin) { MemberCenterPageRedirect("", "goodsadd.aspx" + (IsEdit ? "?id=" + CommonMethod.FinalString(Request["id"]) : "")); } else { #region 务器端验证 以后完善 #endregion #region 保存换品信息 Transaction t = new Transaction(); XiHuan_UserGoodsEntity newgoods = null; if (IsEdit) { newgoods = XiHuan_UserGoodsEntityAction.RetrieveAXiHuan_UserGoodsEntity(CommonMethod.ConvertToInt(Request["id"], 0)); } else { newgoods = new XiHuan_UserGoodsEntity(); } newgoods.OwnerId = CurrentUserId; newgoods.OwnerName = CurrentUserName; newgoods.Name = txtGoodName.Text.Trim(); newgoods.IsTJ = chkTJ.Checked ? (byte)1 : (byte)0; newgoods.TypeId = CommonMethod.ConvertToInt(ddlGoodType.SelectedValue, 0); newgoods.ChildId = CommonMethod.ConvertToInt(ddlGoodChildType.SelectedValue, 0); newgoods.IsHavePhoto = rbtYes.Checked ? (byte)XiHuan_UserGoodsFacade.IsGoodHavePhoto. : (byte)XiHuan_UserGoodsFacade.IsGoodHavePhoto.无; newgoods.Description = txtGoodDesc.Value.Trim(); newgoods.NewDeep = byte.Parse(ddlNewOldDeep.SelectedValue.Trim()); newgoods.OnlyCityChange = chkValidCity.Checked ? (byte)1 : (byte)0; newgoods.OnlySchoolChange = chkValidSchool.Checked ? (byte)1 : (byte)0; newgoods.HopeToChangeTypeId = CommonMethod.ConvertToInt(ddlGoodType1.SelectedValue, 0); newgoods.HopeToChangeChildTypeId = CommonMethod.ConvertToInt(ddlGoodChildType1.SelectedValue, 0); newgoods.HopeToChangeDesc = txtHopeToChangeDesc.Text.Trim(); newgoods.ProvinceId = CurrentUser.ProvinceId; newgoods.ProvinceName = CurrentUser.ProvinceName; newgoods.CityId = CurrentUser.CityId; newgoods.CityName = CurrentUser.CityName; newgoods.AreaId = CurrentUser.AreaId; newgoods.AreaName = CurrentUser.AreaName; newgoods.SchoolId = CurrentUser.SchoolId; newgoods.SchoolName = CurrentUser.SchoolName; if (!IsEdit) { newgoods.CreateDate = DateTime.Now; newgoods.ViewCount = new Random().Next(10, 30); newgoods.GoodState = (byte)XiHuan_UserGoodsFacade.GoodsState.新登记; } newgoods.IsChecked = (byte)(SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? 0 : 1); t.DoSaveObject(newgoods); if (!IsEdit) { #region 换品图片上传 string gooddefaultphoto = string.Empty; if (rbtYes.Checked) { string extention = string.Empty; int filesize = 0; string filepath = string.Empty; string savepath = string.Empty; string filename = string.Empty; HttpFileCollection goodimages = HttpContext.Current.Request.Files; for (int i = 0; i < goodimages.Count; i++) { HttpPostedFile currentfile = goodimages[i]; extention = Path.GetExtension(currentfile.FileName); filesize = currentfile.ContentLength; filepath = "images/userupload/goodsimage/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day + "/"; //不符合条件的直接跳过,不进行保存 if (!(currentfile.FileName.Length > 0) || filesize == 0 || !CommonMethod.IsUploadImageValid("", extention) || filesize > 500 * 1024) { continue; } else { if (!Directory.Exists(Server.MapPath(filepath))) { Directory.CreateDirectory(Server.MapPath(filepath)); } filename = newgoods.Id.ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssfff"); currentfile.SaveAs(Server.MapPath(filepath + filename + extention)); XiHuan_GoodsImageEntity newgoodimage = new XiHuan_GoodsImageEntity(); newgoodimage.GoodsId = newgoods.Id; newgoodimage.GoodsName = newgoods.Name; newgoodimage.ImgSrc = filepath + filename + extention; newgoodimage.CreateDate = DateTime.Now; if (i == 0) { gooddefaultphoto = filepath + filename + GlobalVar.DefaultPhotoSize + extention; newgoodimage.IsDefaultPhoto = 1; //生成不同规格的图片 PicHelper.MakeThumbnail(Server.MapPath(filepath + filename + extention), Server.MapPath(filepath + filename + GlobalVar.DefaultPhotoSize + extention), 85, 85); PicHelper.MakeThumbnail(Server.MapPath(filepath + filename + extention), Server.MapPath(filepath + filename + GlobalVar.BigPhotoSize + extention), 200, 220); } t.DoSaveObject(newgoodimage); } } } #endregion #region 默认图片保存 string sql = string.Format("update XiHuan_UserGoods set DefaultPhoto='{0}' where Id={1} ", gooddefaultphoto.Length > 0 ? gooddefaultphoto : "images/none.jpg", newgoods.Id); t.DoSqlNonQueryString(sql, GlobalVar.DataBase_Name); #endregion #region 更新用户换品数量和积分,换币 string updategoodsnumber = string.Format(@"update XiHuan_UserInfo set GoodsNumber=GoodsNumber+1, Score=Score+{0},HuanBi=HuanBi+{1} where Id={2}" , SystemConfigFacade.Instance().AddScoreByAddGoods(), SystemConfigFacade.Instance().AddHBByAddGoods(), CurrentUser.ID); t.DoSqlNonQueryString(updategoodsnumber, GlobalVar.DataBase_Name); #endregion #region 浏览人 XiHuan_GoodsViewUserEntity view = new XiHuan_GoodsViewUserEntity(); view.GoodsId = newgoods.Id; view.Type = 0; view.VisitDate = DateTime.Now; view.VisitorName = "喜换网"; view.VisitorId = 1; view.VisitorHeadImage = "images/userupload/20092113032102_1.png"; t.DoSaveObject(view); #endregion } try { string detailurl = "goods/" + newgoods.CreateDate.Year + "/" + newgoods.CreateDate.Month + "/" + newgoods.CreateDate.Day + "/goods" + newgoods.Id + ".html"; t.DoSqlNonQueryString("update XiHuan_UserGoods set DetailUrl='" + detailurl + "' where Id=" + newgoods.Id, GlobalVar.DataBase_Name); t.Commit(); if (!SystemConfigFacade.Instance().IsGoodsAddNeedCheck) { DataTable dt = Query.ProcessSql("select Id,DetailUrl,GoodState from XiHuan_UserGoods with(nolock) where OwnerId= " + CurrentUserId + " and IsChecked=1 ", GlobalVar.DataBase_Name); foreach (DataRow dr in dt.Rows) { CommonMethod.readAspxAndWriteHtmlSoruce("showdetail.aspx?id=" + dr["Id"], dr["DetailUrl"].ToString()); } } if (IsEdit) { Alert("恭喜:换品信息保存成功" + (SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? ",我们会尽快进行审核" : string.Empty) + "^_^!"); } else { Alert("恭喜:换品登记成功" + (SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? ",我们会尽快进行审核" : string.Empty) + "^_^!"); SendMailFacade.sendEmail("[email protected],[email protected]", "有人在喜换网发换品了", "有人在喜换网发换品:" + txtGoodName.Text); } ExecScript("window.location='goodlist.aspx?s='+Math.random();"); } catch (Exception ex) { t.RollBack(); Alert("抱歉:换品保存出错," + ex.Message); return; } #endregion } }
protected void lnkSubmit_Click(object sender, EventArgs e) { #region 务器端验证 int provinceid = CommonMethod.ConvertToInt(ddlProvince.SelectedValue, 0); int cityid = CommonMethod.ConvertToInt(ddlCity.SelectedValue, 0); int areaid = CommonMethod.ConvertToInt(ddlArea.SelectedValue, 0); int schoolid = CommonMethod.ConvertToInt(ddlSchool.SelectedValue, 0); if (txtUserName.Text.Trim().Length == 0) { Alert(" 请您填写换客名!"); Select(txtUserName); return; } else if (XiHuan_UserFacade.IsUserNameAlreayUse(txtUserName.Text)) { Alert("您填写的换客名已经被占用,请您换个换客名重试!"); Select(txtUserName); return; } if (txtPassWord.Text.Trim().Length == 0) { Alert("请您填写密码!"); Select(txtPassWord); return; } if (txtPassWord2.Text.Trim().Length == 0) { Alert("请您再次输入密码!"); Select(txtPassWord2); return; } if (!txtPassWord.Text.Trim().Equals(txtPassWord2.Text.Trim())) { Alert("两次密码输入不一致,请重新输入!"); Select(txtPassWord2); return; } if (txtEmail.Text.Trim().Length > 0) { Regex reg = new Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"); if (!reg.IsMatch(txtEmail.Text.Trim())) { Alert("您的邮箱格式填写不正确!"); Select(txtEmail); return; } } if (provinceid == 0) { Alert("请您选择省份!"); return; } if (cityid == 0) { Alert("请您选择城市!"); return; } if (txtQuestion.Text.Trim().Length == 0) { Alert("请您填写安全提问问题!"); Select(txtQuestion); return; } if (txtAnswer.Text.Trim().Length == 0) { Alert("请您填写安全提问答案!"); Select(txtAnswer); return; } #endregion #region 用户基本信息 Transaction t = new Transaction(); XiHuan_UserInfoEntity NewUser = new XiHuan_UserInfoEntity(); NewUser.UserType = (int)XiHuan_UserFacade.UserType.个人注册; NewUser.UserName = txtUserName.Text.Trim(); NewUser.OrignalPwd = txtPassWord.Text.Trim(); NewUser.Md5Pwd = CommonMethod.MD5Encrypt(txtPassWord.Text.Trim()); NewUser.Email = txtEmail.Text.Trim(); NewUser.Gender = Rad_sex_0.Checked ? (byte)1 : (byte)0; NewUser.ProvinceId = provinceid; NewUser.ProvinceName = ddlProvince.SelectedItem.Text; NewUser.CityId = cityid; if (cityid > 0) { NewUser.CityName = CommonMethodFacade.GetCityNameById(cityid.ToString()); } NewUser.AreaId = areaid; if (areaid > 0) { NewUser.AreaName = CommonMethodFacade.GetAreaNameById(areaid.ToString()); } if (schoolid > 0) { NewUser.SchoolId = schoolid; NewUser.SchoolName = CommonMethodFacade.GetSchoolNameById(provinceid.ToString(), cityid.ToString(), schoolid.ToString()); } NewUser.HuanBi = SystemConfigFacade.Instance().RegisterAddHuanBi(); NewUser.Score = SystemConfigFacade.Instance().RegisterAddScore(); NewUser.RegisterDate = NewUser.LastLoginTime = DateTime.Now; NewUser.Question = txtQuestion.Text.Trim(); NewUser.Answer = txtAnswer.Text.Trim(); NewUser.HeadImage = "images/nophoto.gif"; t.DoSaveObject(NewUser); #endregion #region 推荐人积分换币更新 if (txtTuiJianMember.Text.Trim().Length > 0) { string updateTJ = string.Format("update XiHuan_UserInfo set Score=Score+{0},HuanBi=HuanBi+{1} where UserName='******' ", SystemConfigFacade.Instance().TuiJianAddScore(), SystemConfigFacade.Instance().TuiJianAddHuanBi(), txtTuiJianMember.Text.Trim()); t.DoSqlNonQueryString(updateTJ, GlobalVar.DataBase_Name); } #endregion #region 给新注册用户发送短消息 XiHuan_MessageFacade.SendNewMessage(1, NewUser.ID, "喜换网", NewUser.UserName, "尊敬的会员" + NewUser.UserName + "," + SystemConfigFacade.Instance().RegMesContent(), t, true); #endregion try { t.Commit(); #region 注册完成后自动登陆调转到个人管理中心 Alert("恭喜:您的注册信息已成功提交!"); CommonMethod.AddLoginCookie(NewUser.ID, NewUser.UserName, DateTime.MinValue); SendMailFacade.sendEmail(CommonMethodFacade.GetConfigValue("NoticeEmail"), "有人在喜换网注册了", "有人在喜换网注册了:" + txtUserName.Text); Response.Redirect("membercenter.aspx?action=" + Server.UrlEncode("membermanageindex.aspx")); #endregion } catch (Exception ex) { t.RollBack(); Alert("抱歉:注册信息提交失败," + ex.Message + "请重试!"); return; } }
protected void btnSystemConfig_Click(object sender, EventArgs e) { SystemConfigFacade.Refresh(); Alert("刷新成功!"); }
protected void btnSetGoodsAdd_Click(object sender, EventArgs e) { Query.ProcessSql("update XiHuan_SystemConfig set ConfigValue='" + rbtIsGoodsAddNeedCheck.SelectedValue + "' where ConfigKey='IsGoodsAddNeedCheck' ", GlobalVar.DataBase_Name); SystemConfigFacade.Refresh(); Alert("设置成功!"); }
protected void btnSaveFFZF_Click(object sender, EventArgs e) { Query.ProcessSql("update XiHuan_SystemConfig set ConfigValue='" + txtFFZF.Text.Trim() + "' where ConfigKey='FFZF' ", GlobalVar.DataBase_Name); SystemConfigFacade.Refresh(); Alert("设置成功!"); }