public ActionResult AddOrEdit(int?id)
{
var channellist = _syschannelService.LoadAllEnable();
var list = channellist.Select(x => new SelectListItem {
Text = x.Name, Value = x.Id.ToString()
});
ViewBag.ChannelList = list.ToList <SelectListItem>();
//ViewBag.ChannelList = list.Select(x => new SelectListItem { Text=x.Name,Value=x.Id.ToString() });
SysCategory entity = null;
ViewBag.Title = "添加分类";
if (id.HasValue)
{
entity = _syscategoryService.Get(id.Value);
ViewBag.Title = "修改分类";
}
entity = entity ?? new SysCategory
{
Name = string.Empty,
};
ViewBag.CategoryType = ExSelectListItem.ToSelectListItem(typeof(CategoryType));
return(View(entity));
}
/// <summary>
/// 添加站点类别
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddSysCateGory(SysCategory model)
{
string sqlname = ""; string sqlvalue = "";
if (model.ID != null && model.ID != "")
{
sqlname += "ID,"; sqlvalue += "'" + model.ID + "',";
}
if (model.SiteName != null && model.SiteName != "")
{
sqlname += "SiteName,"; sqlvalue += "'" + model.SiteName + "',";
}
if (model.SiteDesc != null && model.SiteDesc != "")
{
sqlname += "SiteDesc,"; sqlvalue += "'" + model.SiteDesc + "',";
}
if (model.SiteOrder > -1)
{
sqlname += "SiteOrder,"; sqlvalue += model.SiteOrder + ",";
}
sqlname += "IsDel"; sqlvalue += (model.IsDel?0:1);
sqlname = "insert into Sys_Category(" + sqlname + ") values(" + sqlvalue + ")";
int rowsAffected = DbHelperSQL.ExecuteSql(sqlname.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新站点类别
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateSysCateGory(SysCategory model)
{
string safesql = " update Sys_Category set ";
if (model.SiteName != null && model.SiteName != "")
{
safesql += " SiteName='" + model.SiteName + "',";
}
if (model.SiteDesc != null && model.SiteDesc != "")
{
safesql += " SiteDesc='" + model.SiteDesc + "',";
}
if (model.SiteOrder > 0)
{
safesql += " SiteOrder=" + model.SiteOrder + ",";
}
safesql += " IsDel=" + (model.IsDel ? 0 : 1) + " where id='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool InsertCategory(CategoryModel model)
{
try
{
if (model == null)
{
return(false);
}
using (var db = new PORTALEntities())
{
var item = new SysCategory
{
ID = model.ID,
Name = model.Name,
Remark = model.Remark,
CreateDate = model.CreateDate,
CreateUid = model.CreateUID
};
db.SysCategories.Add(item);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
LogHelper.Error("CategoryRepository Insert Category: " + ex.Message + " Inner exception: " + ex.InnerException.Message);
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (SiteName.Text.Trim() != null && SiteName.Text.Trim() != "")
{
SysCategory model = new SysCategory();
SysCategoryDAL dal = new SysCategoryDAL();
model.SiteName = SiteName.Text;
model.ID = Guid.NewGuid().ToString("N").ToUpper();
model.IsDel = isstateyes.Checked ? true : false;
model.SiteDesc = hd_SiteDesc.Value;
if (txtOrder.Text.Trim() != null && txtOrder.Text.Trim() != "")
{
model.SiteOrder = Convert.ToInt32(txtOrder.Text);
}
else
{
model.SiteOrder = 1;
}
if (dal.AddSysCateGory(model))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "名称不能为空！");
return;
}
}
public bool HasSysCategory(SysCategory permission)
{
var sysIDs = string.Join("", Role.SysCateIDs).Split(',');
if (sysIDs.Contains(((int)SysCategory.ALL).ToString()))
{
return(true);
}
return(SysCateIDs != null && sysIDs.Any(p => p == ((int)(permission)).ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
if (null != Common.Common.NoHtml(Request.QueryString["action"]))
{
strAction = Common.Common.NoHtml(Request.QueryString["action"]);
}
if (null != Common.Common.NoHtml(Request.QueryString["id"]))
{
strID = Common.Common.NoHtml(Request.QueryString["id"]);
}
SysCategoryDAL dal = new SysCategoryDAL();
int statein = 0;
try
{
statein = Convert.ToInt32(dal.GetSysCategoryByValue("IsDel", strID));
}
catch (Exception)
{
statein = 0;
}
switch (statein)
{
case 0:
statein = 1;
break;
default:
statein = 0;
break;
}
SysCategory model = new SysCategory();
model.ID = strID;
model.IsDel = (statein == 0?true:false);
switch (strAction)
{
case "del":
if (dal.UpdateSysCateGory(model))
{
strMessage = "操作成功！";
}
else
{
strMessage = "操作失败！";
}
break;
default:
break;
}
Response.Write(strMessage);
Response.End();
}
const string dateFileFormat = "yyyyMMdd_"; //文件名中日期字段的格式
//在进行日志系统注册之后，可使用该方法获系统编号
public static SysCategory GetSystemID()
{
try
{
SysCategory sysID = (SysCategory)dataCache.GetCache(AppConfig.GetCacheKey(CacheConst.systemName));
return(sysID);
}
catch
{
return(SysCategory.NoDefined);
}
}
public ActionResult Save(SysCategory entity, int?channelId)
{
if (ModelState.IsValid)
{
var forum = _syschannelService.Get(channelId.Value);
if (forum == null)
{
return(Json(new CommonResult
{
Success = false,
Message = "未选择频道，保存失败！"
}, "text/html", JsonRequestBehavior.AllowGet));
}
if (entity.Id == 0)
{
if (_syscategoryService.IsExist(entity.Name.Trim()))
{
return(Json(new CommonResult
{
Success = false,
Message = "分类名称已经存在，请重新输入！"
}, "text/html", JsonRequestBehavior.AllowGet));
}
entity.Channel = forum;
base._syscategoryService.Save(entity);
}
else
{
var model = base._syscategoryService.Get(entity.Id);
model.Name = entity.Name;
model.OrderNo = entity.OrderNo;
model.IsEnabled = entity.IsEnabled;
model.CategoryType = entity.CategoryType;
model.Content = entity.Content;
model.Url = entity.Url;
entity.Channel = forum;
base._syscategoryService.Update(model);
}
return(Json(new CommonResult {
Success = true, Message = "保存成功"
}, "text/html", JsonRequestBehavior.AllowGet));
}
return(RedirectToAction("AddOrEdit", entity));
}
public void ShowActivityInfo(string strID)
{
SysCategoryDAL dal = new SysCategoryDAL();
DataSet ds = dal.GetSysCateGoryDetail(strID);
SysCategory model = DataConvert.DataRowToModel <SysCategory>(ds.Tables[0].Rows[0]);
SiteName.Text = model.SiteName;
hd_SiteDesc.Value = model.SiteDesc;
txtOrder.Text = model.SiteOrder.ToString();
if (model.IsDel == true)
{
isstateyes.Checked = true;
}
else
{
isstateno.Checked = true;
}
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
/// <summary>
/// 注册日志组件到本系统，为日志组件准备基础信息：服务器IP、服务器主机名，系统名称等
/// </summary>
/// <param name="sys">业务系统类型</param>
/// <param name="application">应用程序的Application对象</param>
/// <param name="bWriteStartLog">是否是启动日志</param>
/// <param name="bLogMonitor">是否写定时监控日志</param>
public static void RegisterLogInitMsg(SysCategory sys, object applicationObj = null, UserCfg userConfig = null, Dictionary <SysCategory, string> webAppName = null, bool bWriteStartLog = true, bool bLogMonitor = true)
{
webAppNames = webAppName ?? new Dictionary <SysCategory, string>();
new HttpCacheHelper().SetCache(AppConfig.GetCacheKey(CacheConst.userCfgInCode), userConfig, expireType: Expire.Month);
userCfg = GetUserConfigItem();
userCfg = userCfg ?? new UserCfg();
dataCache = CacheFac.CacheFactory();
appender = AppenderFac.AppenderFactory();
logLevelCfg = AppConfig.GetFinalConfig("log2NetLevel", LogLevel.Debug, GetLog2NetLevel());
if (logLevelCfg == LogLevel.Off)
{
return;
}
// AutoMapperConfig.Configure();//注册AutoMapper
#if NET
bRegister = true;
ApplicationVisitCount.ApplicationObj = applicationObj;
#endif
//var machineName = System.Web.HttpContext.Current.Server.MachineName;//服务器计算机名
var machineName = Environment.MachineName;//服务器计算机名
var server = ClientServerInfo.ClientInfo.GetIPAccordingHost(machineName);
string serverIP = server.IP;
dataCache.SetCache(AppConfig.GetCacheKey(CacheConst.serverIP), serverIP, expireType: Expire.Month);
dataCache.SetCache(AppConfig.GetCacheKey(CacheConst.serverHost), machineName, expireType: Expire.Month);
dataCache.SetCache(AppConfig.GetCacheKey(CacheConst.systemName), sys, expireType: Expire.Month);
#region 使用EF自动创建数据库
try
{
var initTraceDBWhenOracle = AppConfig.GetFinalConfig("initTraceDBWhenOracle", false, LogApi.IsInitTraceDBWhenOracle());
// initTraceDBWhenOracle = "1";
var traceDBType = ComDBFun.GetDBGeneralInfo(DBType.LogTrace).DataBaseType;
if (traceDBType != DataBaseType.Oracle || (traceDBType == DataBaseType.Oracle && initTraceDBWhenOracle))
{
using (var context = new Log_OperateTraceContext()) //oracle 不建议使用EF，会导致字段名和数据库名必须加引号
{
#if NET
context.Database.Initialize(true); //EF6
#else
context.Database.EnsureCreated(); //EFCore
#endif
}
}
var initMonitorDBWhenOracle = AppConfig.GetFinalConfig("initMonitorDBWhenOracle", false, LogApi.IsInitMonitorDBWhenOracle());
// initMonitorDBWhenOracle = "1";
var monitorDBType = ComDBFun.GetDBGeneralInfo(DBType.LogMonitor).DataBaseType;
if (monitorDBType != DataBaseType.Oracle || (monitorDBType == DataBaseType.Oracle && initMonitorDBWhenOracle))
{
using (var context = new Log_SystemMonitorContext())
{
#if NET
context.Database.Initialize(true); //EF6
#else
context.Database.EnsureCreated(); //EFCore
#endif
}
}
}
catch (Exception ex)
{
WriteExceptToFile(ex);
}
#endregion 使用EF自动创建数据库
if (bWriteStartLog)
{
WriteServerStartupLog();//系统启动的日志
}
StartThreadToWriteFileToAppender(); //开启线程，将备份日志写到Appender中
//在线人数和访客人数的初始化
VisitOnline.VisitCountFactory.GetInstance().SetVisitNumWhenInit();
if (bLogMonitor)
{
WriteMonitorLogThread();
}
}
