/// <summary>
/// 新增模块
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMemberPageModule(SqlConnection conn, MemberPageModuleModel model)
{
#region SQL
string sql = @"
INSERT INTO [Configuration]..[MemberPageModule]
([MemberPageID]
,[ModuleName]
,[ModuleType]
,[MarginTop]
,[DisplayIndex]
,[Status]
,[Creator])
VALUES
(@MemberPageID
,@ModuleName
,@ModuleType
,@MarginTop
,@DisplayIndex
,@Status
,@Creator);
SELECT CAST(SCOPE_IDENTITY() as int);";
#endregion
model.PKID = conn.Query <int>(sql, model).FirstOrDefault();
if (model.PKID > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改模块
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMemberPageModule(MemberPageModuleModel model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(moduleDAL.UpdateMemberPageModule(conn, model));
}
}
public JsonResult AddMemberPageModule(MemberPageModuleModel model)
{
bool flag = false;
var memberPageManager = new MemberPageManager();
var moduleManager = new MemberPageModuleManager();
if (model.PKID == 0)//新建
{
var memberPageInfo = memberPageManager.GetMemberPageByPageCode(model.PageCode);
if (memberPageInfo != null)
{
model.MemberPageID = memberPageInfo.PKID;
}
model.Creator = User.Identity.Name;
flag = moduleManager.AddMemberPageModule(model);
#region 日志记录
using (var client = new ConfigLogClient())
{
var response = client.InsertDefaultLogQueue("CommonConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = model.PKID,
ObjectType = "MemberPageModule",
BeforeValue = "",
AfterValue = JsonConvert.SerializeObject(model),
Remark = "创建",
Creator = User.Identity.Name,
}));
}
#endregion
}
else//编辑
{
var moduleInfo = moduleManager.GetMemberPageModuleInfo(model.PKID);
flag = moduleManager.UpdateMemberPageModule(model);
#region 日志记录
using (var client = new ConfigLogClient())
{
var response = client.InsertDefaultLogQueue("CommonConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = model.PKID,
ObjectType = "MemberPageModule",
BeforeValue = JsonConvert.SerializeObject(moduleInfo),
AfterValue = JsonConvert.SerializeObject(model),
Remark = "编辑",
Creator = User.Identity.Name,
}));
}
#endregion
}
//等待1秒，写库同步到读库
Thread.Sleep(1000);
moduleManager.RefreshMemberPageCache();
return(Json(flag));
}
/// <summary>
/// 修改模块
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMemberPageModule(SqlConnection conn, MemberPageModuleModel model)
{
#region SQL
string sql = @"
UPDATE [Configuration]..[MemberPageModule] WITH(ROWLOCK)
SET [MemberPageID] = @MemberPageID
,[ModuleName] = @ModuleName
,[ModuleType] = @ModuleType
,[MarginTop] = @MarginTop
,[DisplayIndex] = @DisplayIndex
,[Status] = @Status
,[LastUpdateDateTime] = GETDATE()
WHERE PKID=@PKID";
#endregion
return(conn.Execute(sql, model) > 0);
}
