/// <summary> /// 网站基本信息管理 /// </summary> /// <returns></returns> public ActionResult websitemsg() { WebSettingsModel model = new WebSettingsModel(); model = websetbll.GetWebSiteModel(); return(View(model)); }
public ActionResult websitemsg(WebSettingsModel model) { if (model != null) { int row = websetbll.UpdateWebSetting(model); } return(View(model)); }
/// <summary> /// 更新一条数据 /// </summary> public static int UpdateWebSetting(WebSettingsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WebSettings set "); strSql.Append(" WebFax = @WebFax , "); strSql.Append(" WebMobile = @WebMobile , "); strSql.Append(" WebPhone = @WebPhone , "); strSql.Append(" WebEmail = @WebEmail , "); strSql.Append(" WebAboutUs = @WebAboutUs , "); strSql.Append(" IsOpen = @IsOpen , "); strSql.Append(" DomainName = @DomainName , "); strSql.Append(" WebName = @WebName , "); strSql.Append(" WebDescription = @WebDescription , "); strSql.Append(" WebType = @WebType , "); strSql.Append(" WebPutonrecord = @WebPutonrecord , "); strSql.Append(" WebDefaultKey = @WebDefaultKey , "); strSql.Append(" WebAddress = @WebAddress "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@WebFax", SqlDbType.NVarChar), new SqlParameter("@WebMobile", SqlDbType.NVarChar), new SqlParameter("@WebPhone", SqlDbType.NVarChar), new SqlParameter("@WebEmail", SqlDbType.NVarChar), new SqlParameter("@WebAboutUs", SqlDbType.NVarChar), new SqlParameter("@IsOpen", SqlDbType.Int), new SqlParameter("@DomainName", SqlDbType.NVarChar), new SqlParameter("@WebName", SqlDbType.NVarChar), new SqlParameter("@WebDescription", SqlDbType.NVarChar), new SqlParameter("@WebType", SqlDbType.NVarChar), new SqlParameter("@WebPutonrecord", SqlDbType.NVarChar), new SqlParameter("@WebDefaultKey", SqlDbType.NVarChar), new SqlParameter("@WebAddress", SqlDbType.NVarChar) }; parameters[0].Value = model.ID; parameters[1].Value = model.WebFax; parameters[2].Value = model.WebMobile; parameters[3].Value = model.WebPhone; parameters[4].Value = model.WebEmail; parameters[5].Value = model.WebAboutUs; parameters[6].Value = model.IsOpen; parameters[7].Value = model.DomainName; parameters[8].Value = model.WebName; parameters[9].Value = model.WebDescription; parameters[10].Value = model.WebType; parameters[11].Value = model.WebPutonrecord; parameters[12].Value = model.WebDefaultKey; parameters[13].Value = model.WebAddress; int rows = helper.ExecuteSql(strSql.ToString(), parameters); return(rows); }
/// <summary> /// 新增网站信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int AddWebSite(WebSettingsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WebSettings("); strSql.Append("WebFax,WebMobile,WebPhone,WebEmail,WebAboutUs,IsOpen,DomainName,WebName,WebDescription,WebType,WebLogoAlt,WebLogo,WebPutonrecord,WebDefaultKey,WebAddress"); strSql.Append(") values ("); strSql.Append("@WebFax,@WebMobile,@WebPhone,@WebEmail,@WebAboutUs,@IsOpen,@DomainName,@WebName,@WebDescription,@WebType,@WebLogoAlt,@WebLogo,@WebPutonrecord,@WebDefaultKey,@WebAddress"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@WebFax", SqlDbType.NVarChar), new SqlParameter("@WebMobile", SqlDbType.NVarChar), new SqlParameter("@WebPhone", SqlDbType.NVarChar), new SqlParameter("@WebEmail", SqlDbType.NVarChar), new SqlParameter("@WebAboutUs", SqlDbType.NVarChar), new SqlParameter("@IsOpen", SqlDbType.Int), new SqlParameter("@DomainName", SqlDbType.NVarChar), new SqlParameter("@WebName", SqlDbType.NVarChar), new SqlParameter("@WebDescription", SqlDbType.NVarChar), new SqlParameter("@WebType", SqlDbType.NVarChar), new SqlParameter("@WebLogoAlt", SqlDbType.NVarChar), new SqlParameter("@WebLogo", SqlDbType.NVarChar), new SqlParameter("@WebPutonrecord", SqlDbType.NVarChar), new SqlParameter("@WebDefaultKey", SqlDbType.NVarChar), new SqlParameter("@WebAddress", SqlDbType.NVarChar) }; parameters[0].Value = model.WebFax; parameters[1].Value = model.WebMobile; parameters[2].Value = model.WebPhone; parameters[3].Value = model.WebEmail; parameters[4].Value = model.WebAboutUs; parameters[5].Value = model.IsOpen; parameters[6].Value = model.DomainName; parameters[7].Value = model.WebName; parameters[8].Value = model.WebDescription; parameters[9].Value = model.WebType; parameters[10].Value = model.WebLogoAlt; parameters[11].Value = model.WebLogo; parameters[12].Value = model.WebPutonrecord; parameters[13].Value = model.WebDefaultKey; parameters[14].Value = model.WebAddress; object obj = helper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ActionResult webfooter() { webfooterViewModel model = new webfooterViewModel(); WebSettingsModel setting = webbll.GetWebSiteModel(); MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel; if (logmember == null) { model.Linkurl = setting.DomainName; } else { model.Linkurl = setting.DomainName + Url.Action("Index", "Register", new { area = "WebFrontArea", msd = logmember.MobileNum }); } return(View(model)); }
public override void OnActionExecuted(ActionExecutedContext ctx) { //部分视图不做验证 if (ctx.IsChildAction) { return; } //判断是否当前系统状态为false,系统自动跳转至登录页面 WebSettingsBLL bll = new WebSettingsBLL(); WebSettingsModel sitemodel = bll.GetWebSiteModel(); if (sitemodel.IsOpen == 0) { ctx.Result = new RedirectResult("/Home/CommingSoon"); return; } if (ctx.ActionDescriptor.ControllerDescriptor.ControllerName == "Login") { return; } if (ctx.ActionDescriptor.ControllerDescriptor.ControllerName == "Register") { return; } if (ctx.ActionDescriptor.ControllerDescriptor.ControllerName == "public") { return; } string logurl = "/login.html"; if (AppContent.TempleteName == "NewTemplateArea") { logurl = "/user/login.html"; } if (ctx.HttpContext.Session[AppContent.SESSION_WEB_LOGIN] == null) { var url = ctx.RequestContext.HttpContext.Request == null ? "" : ctx.RequestContext.HttpContext.Request.Url.ToString(); ctx.Result = new RedirectResult(logurl); return; } }
/// <summary> /// 得到网站的基础配置信息 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static WebSettingsModel GetWebSiteModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID, WebFax, WebMobile, WebPhone, WebEmail, WebAboutUs, IsOpen, DomainName, WebName, WebDescription, WebType, WebLogoAlt, WebLogo, WebPutonrecord, WebDefaultKey, WebAddress "); strSql.Append(" from WebSettings "); strSql.Append(" where IsUsed=1"); strSql.Append(" Order By ID DESC "); WebSettingsModel model = new WebSettingsModel(); DataSet ds = helper.Query(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.WebFax = ds.Tables[0].Rows[0]["WebFax"].ToString(); model.WebMobile = ds.Tables[0].Rows[0]["WebMobile"].ToString(); model.WebPhone = ds.Tables[0].Rows[0]["WebPhone"].ToString(); model.WebEmail = ds.Tables[0].Rows[0]["WebEmail"].ToString(); model.WebAboutUs = ds.Tables[0].Rows[0]["WebAboutUs"].ToString(); if (ds.Tables[0].Rows[0]["IsOpen"].ToString() != "") { model.IsOpen = int.Parse(ds.Tables[0].Rows[0]["IsOpen"].ToString()); } model.DomainName = ds.Tables[0].Rows[0]["DomainName"].ToString(); model.WebName = ds.Tables[0].Rows[0]["WebName"].ToString(); model.WebDescription = ds.Tables[0].Rows[0]["WebDescription"].ToString(); model.WebType = ds.Tables[0].Rows[0]["WebType"].ToString(); model.WebLogoAlt = ds.Tables[0].Rows[0]["WebLogoAlt"].ToString(); model.WebLogo = ds.Tables[0].Rows[0]["WebLogo"].ToString(); model.WebPutonrecord = ds.Tables[0].Rows[0]["WebPutonrecord"].ToString(); model.WebDefaultKey = ds.Tables[0].Rows[0]["WebDefaultKey"].ToString(); model.WebAddress = ds.Tables[0].Rows[0]["WebAddress"].ToString(); return(model); } else { return(null); } }
public ActionResult newwebmenu() { MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel; if (logmember == null) { return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" })); } WebSettingsModel setting = webbll.GetWebSiteModel(); WebIndexModel webmodel = memberbll.GetIndexNeeddata(logmember.ID); NewWebMenuViewModel model = new NewWebMenuViewModel(); model.ActionCodeCount = webmodel.activecodeCount; model.CurrencyCodeCount = webmodel.paidancodeCount; model.DynamicMoney = webmodel.zijinmodel.DynamicFunds; model.StaticMoney = webmodel.zijinmodel.StaticCapital; model.UserName = logmember.TruethName; model.UserPhone = logmember.MobileNum; model.TeamPersonCount = webmodel.members; model.linkurl = setting.DomainName + Url.Action("Index", "Register", new { area = "WebFrontArea", msd = logmember.MobileNum }); return(View(model)); }
public LoginController() { web = webbll.GetWebSiteModel(); }
public WebHomeController() { web = webbll.GetWebSiteModel(); }
public RegisterController() { web = webbll.GetWebSiteModel(); }
/// <summary> /// 添加新的网站信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddWebSite(WebSettingsModel model) { return(WebSettingsDAL.AddWebSite(model)); }
/// <summary> /// 更新一条数据 /// </summary> public int UpdateWebSetting(WebSettingsModel model) { return(WebSettingsDAL.UpdateWebSetting(model)); }