/// <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); }