/// <summary>
/// 编辑电梯绑定信息
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string EditElevatorInfo(HttpContext context)
{
var jr = new JsonResultModel <int>()
{
IsSucceed = false,
Data = 0,
Msg = "编辑失败",
RedirectUrl = string.Empty
};
string registrationCode = context.Request.Params["registrationCode"];
string elevatorPosition = context.Request.Params["elevatorPosition"];
int eID = string.IsNullOrEmpty(context.Request.Params["eID"]) ? 0 : int.Parse(context.Request.Params["eID"]);
if (_infoBLL.Exists(registrationCode, eID))
{
jr.IsSucceed = false;
jr.Msg = "注册码已经存在";
}
else
{
ElevatorInfoModel model = new ElevatorInfoModel()
{
registrationCode = registrationCode,
elevatorPosition = elevatorPosition,
eID = eID
};
if (_infoBLL.Update(model))
{
jr.IsSucceed = true;
jr.Msg = "编辑成功";
}
}
return(JsonConvert.SerializeObject(jr));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ElevatorInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into elevatorinfo(communityID,registrationCode,elevatorPosition) ");
strSql.Append(" value(@communityID,@registrationCode,@elevatorPosition)");
MySqlParameter[] parameters =
{
new MySqlParameter("@communityID", model.communityID),
new MySqlParameter("@registrationCode", model.registrationCode),
new MySqlParameter("@elevatorPosition", model.elevatorPosition),
};
return(MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ElevatorInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update elevatorinfo set ");
strSql.Append(" registrationCode=@registrationCode ");
strSql.Append(" ,elevatorPosition=@elevatorPosition ");
strSql.Append(" where eID=@eID; ");
MySqlParameter[] parameters =
{
new MySqlParameter("@registrationCode", model.registrationCode),
new MySqlParameter("@elevatorPosition", model.elevatorPosition),
new MySqlParameter("@eID", model.eID)
};
return(MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ElevatorInfoModel model)
{
return(_dal.Update(model));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ElevatorInfoModel model)
{
return(_dal.Add(model));
}
