/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EccmDeviceTypeModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update eccm_device_type set ");
strSql.Append("device_type_code=@device_type_code,");
strSql.Append("devide_type_name=@devide_type_name");
strSql.Append(" where type_id=@type_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@device_type_code", MySqlDbType.VarChar, 50),
new MySqlParameter("@devide_type_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@type_id", MySqlDbType.Int32)
};
parameters[0].Value = model.device_type_code;
parameters[1].Value = model.devide_type_name;
parameters[2].Value = model.type_id;
int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EccmDeviceTypeModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into eccm_device_type(");
strSql.Append("device_type_code,devide_type_name)");
strSql.Append(" values (");
strSql.Append("@device_type_code,@devide_type_name)");
MySqlParameter[] parameters =
{
new MySqlParameter("@device_type_code", MySqlDbType.VarChar, 50),
new MySqlParameter("@devide_type_name", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.device_type_code;
parameters[1].Value = model.devide_type_name;
int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EccmDeviceTypeModel DataRowToModel(DataRow row)
{
EccmDeviceTypeModel model = new EccmDeviceTypeModel();
if (row != null)
{
if (row["type_id"] != null && row["type_id"].ToString() != "")
{
model.type_id = int.Parse(row["type_id"].ToString());
}
if (row["device_type_code"] != null)
{
model.device_type_code = row["device_type_code"].ToString();
}
if (row["devide_type_name"] != null && row["devide_type_name"].ToString() != "")
{
model.devide_type_name = row["devide_type_name"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新设备类型
/// </summary>
private string UpdateDeviceType(HttpContext context)
{
//设备类型ID
string id = context.Request.Params["id"];
//设备类型编码
string code = context.Request.Params["code"];
//设备类型名字
string name = context.Request.Params["name"];
//设备类型
EccmDeviceTypeModel model = new EccmDeviceTypeModel();
model.type_id = int.Parse(id);
model.device_type_code = code;
model.devide_type_name = name;
try
{
var jr = new JsonResultModel <int>()
{
IsSucceed = false,
Data = 0,
Msg = "修改设备类型失败",
RedirectUrl = ""
};
if (bll.Update(model))
{
jr.IsSucceed = true;
jr.Msg = "修改设备类型成功";
}
return(JsonConvert.SerializeObject(jr));
}
catch (Exception err)
{
LogHelper.Debug("修改设备类型（UpdateDeviceType）---" + err.Message);
throw err;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EccmDeviceTypeModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EccmDeviceTypeModel model)
{
return(dal.Add(model));
}
