/// <summary>
/// 新增控制器信息
/// <para>包括 控制名称、所属区域、控制器描述</para>
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static OperationResult AddController(ControllerAddModel model, int CreateUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ControllerName", SqlDbType.NVarChar, 50),
new SqlParameter("@AreaID", SqlDbType.Int),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateUserID", SqlDbType.Int),
};
paras[0].Value = model.ControllerName.Trim();
paras[1].Value = model.AreaID;
if (string.IsNullOrWhiteSpace(model.Description))
{
paras[2].Value = DBNull.Value;
}
else
{
paras[2].Value = model.Description;
}
paras[3].Value = CreateUserID;
string sql = @"INSERT INTO dbo.Controllers
( ControllerName, AreaID,Description,CreateUserID )
VALUES ( @ControllerName,@AreaID,@Description,@CreateUserID )";
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
public ActionResult AddControllerInfo()
{
ControllerAddModel model = new ControllerAddModel();
model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName");
return(PartialView("_AddControllerInfo", model));
}
public ActionResult AddControllerInfo(ControllerAddModel model)
{
if (ModelState.IsValid)
{
var result = ControllerBLL.AddController(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Add, result, "ControllerName:" + model.ControllerName);
return(Json(result));
}
else
{
model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName");
return(PartialView("_AddControllerInfo", model));
}
}
