/// <summary>
/// 删除
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int DeleteSdkSetupModel(SdkSetupModel model)
{
if (model != null && model.Id > 0)
{
string sql = "delete from ipvt_sdkinfotable where SdkID=?id";
return(CustomMySqlHelper.ExecuteNonQuery(sql,
new[] { new MySqlParameter("?id", model.Id) }));
}
return(-1);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertSdkSetupModel(SdkSetupModel model)
{
if (model == null)
{
return(-1);
}
string sql = "insert into ipvt_sdkinfotable(SdkIP,SdkPort) values(?ip,?port);SELECT @@IDENTITY;";
return(EvaluationHelper.ObjectToInt(CustomMySqlHelper.ExecuteScalar(sql,
new[] { new MySqlParameter("?ip", model.Ip), new MySqlParameter("?port", model.Port) })));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateSdkSetupModel(SdkSetupModel model)
{
if (model != null && model.Id > 0)
{
string sql = "update ipvt_sdkinfotable set SdkIP=?ip,SdkPort=?port where SdkID=?id";
return(CustomMySqlHelper.ExecuteNonQuery(sql,
new[]
{
new MySqlParameter("?ip", model.Ip),
new MySqlParameter("?port", model.Port),
new MySqlParameter("?id", model.Id)
}));
}
return(-1);
}
