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