/// <summary>
/// 根据控制器编号获取待修改的控制器信息
/// </summary>
/// <param name="controllerID">控制器编号</param>
/// <returns></returns>
public static SelectResult <ControllerEditModel> GetControllerInfoByID(int controllerID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.Int),
};
paras[0].Value = controllerID;
string sql = "SELECT * FROM Controllers WHERE ID=@ID";
List <ControllerEditModel> list = ConvertToList <ControllerEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
ControllerEditModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <ControllerEditModel>()
{
DataResult = data,
Message = msg
});
}
/// <summary>
/// 修改控制器
/// <para>包括控制器名、控制器所属区域、控制器描述</para>
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static OperationResult ModifyController(ControllerEditModel model, int EditUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@AreaID", SqlDbType.Int),
new SqlParameter("@ControllerName", SqlDbType.NVarChar, 50),
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("EditUserID", SqlDbType.Int),
new SqlParameter("EditTime", SqlDbType.DateTime)
};
paras[0].Value = model.AreaID;
paras[1].Value = model.ControllerName.Trim();
paras[2].Value = model.ID;
if (string.IsNullOrWhiteSpace(model.Description))
{
paras[3].Value = DBNull.Value;
}
else
{
paras[3].Value = model.Description;
}
paras[4].Value = EditUserID;
paras[5].Value = DateTime.Now;
string sql = "UPDATE Controllers SET ControllerName=@ControllerName,AreaID=@AreaID,Description=@Description,EditTime=@EditTime,EditUserID=@EditUserID WHERE ID=@ID";
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
public ActionResult EditControllerInfo(ControllerEditModel model)
{
if (ModelState.IsValid)
{
var result = ControllerBLL.ModifyController(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Edit, result, "ControllerID:" + model.ID);
return(Json(result));
}
else
{
model.AreasSelectList = new SelectList(AreaBLL.GetAreas(), "ID", "AreaName");
return(PartialView("_EditControllerInfo", model));
}
}
