public ActionResult Add(int id)
{
VInfoModel vModel = new VInfoModel();
vModel.ChannelId = id;
return(View(vModel));
}
public ActionResult Add(VInfoModel vModel)
{
if (vModel.ChannelId == 0)
{
return(FailResult("栏目分类不能为空！"));
}
try
{
MSQL infoFacade = new MSQL();
infoFacade.DAL.Title = vModel.Title;
infoFacade.DAL.ChannelId = vModel.ChannelId;
infoFacade.DAL.SqlContext = vModel.SqlContext;
infoFacade.DAL.State = vModel.State;
infoFacade.DAL.OperaotId = SysUser.UserId;
infoFacade.DAL.Remark = vModel.Remark;
if (!infoFacade.Add())
{
return(FailResult(infoFacade.PromptInfo.MessageStack));
}
return(SuccessResult());
}
catch (Exception ex)
{
return(FailResult("SQL出现异常：" + ex.Message));
}
}
public ActionResult Update(int Id)
{
MSQL sql = new MSQL(Id);
if (!sql.IsExist)
{
return(FailResult("会员不存在"));
}
VInfoModel model = new VInfoModel
{
Id = sql.DAL.Id,
Title = sql.DAL.Title,
ChannelId = sql.DAL.ChannelId,
SqlContext = sql.DAL.SqlContext,
State = sql.DAL.State,
Remark = sql.DAL.Remark
};
return(View(model));
}
public ActionResult Update(VInfoModel vModel)
{
try
{
MSQL sql = new MSQL(vModel.Id);
sql.DAL.Title = vModel.Title;
vModel.ChannelId = sql.DAL.ChannelId;
sql.DAL.SqlContext = vModel.SqlContext;
sql.DAL.State = vModel.State;
sql.DAL.Remark = vModel.Remark;
sql.DAL.OperaotId = SysUser.UserId;
if (!sql.Update())
{
return(FailResult(sql.PromptInfo.MessageStack));
}
return(SuccessResult());
}
catch (Exception ex)
{
return(FailResult("SQL出现异常：" + ex.Message));
}
}
