/// <summary> /// 修改主键值一致的记录,并返回受影响行数 /// </summary> public static Int32 Modify(EtAntennalnfo etAntennalnfo) { Int32 result = 0; DynamicParameters p = new DynamicParameters(); p.Add("@CELLID", etAntennalnfo.CELLID); p.Add("@AntennaType", etAntennalnfo.AntennaType); p.Add("@Lng", etAntennalnfo.Lng); p.Add("@Lat", etAntennalnfo.Lat); p.Add("@Direction", etAntennalnfo.Direction); p.Add("@DownTilt", etAntennalnfo.DownTilt); p.Add("@Height", etAntennalnfo.Height); p.Add("@CarrierID", etAntennalnfo.CarrierID); p.Add("@RsPower", etAntennalnfo.RsPower); p.Add("@Burthen", etAntennalnfo.Burthen); p.Add("@ModelType", etAntennalnfo.ModelType); p.Add("@RadiusKm", etAntennalnfo.RadiusKm); p.Add("@ResolutionMetres", etAntennalnfo.ResolutionMetres); p.Add("@AntennaID", etAntennalnfo.AntennaID); p.Add("@Rows", 0, DbType.Int32, ParameterDirection.Output); using (var cnn = new SqlConnection(SQLDBHelper.ConnectionString)) { cnn.Open(); cnn.Execute("[dbo].[usp_UpdateAntennalnfo]", p, null, null, CommandType.StoredProcedure); result = p.Get <int>("@Rows"); cnn.Close(); } return(result); }
/// <summary> /// 修改主键值一致的记录,并返回受影响行数 /// </summary> /// <param name="entityPdt">数据库相对应的对象实例</param> public static int Modify(EtAntennalnfo etAntennalnfo) { return(DALAntennalnfo.Modify(etAntennalnfo)); }
/// <summary> /// 添加一个对象,返回新对象ID号 /// </summary> /// <param name="entityPdt"></param> /// <returns></returns> public static Int32 Add(EtAntennalnfo etAntennalnfo) { return(DALAntennalnfo.Add(etAntennalnfo)); }