コード例 #1
0
        /// <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);
        }
コード例 #2
0
 /// <summary>
 /// 修改主键值一致的记录,并返回受影响行数
 /// </summary>
 /// <param name="entityPdt">数据库相对应的对象实例</param>
 public static int Modify(EtAntennalnfo etAntennalnfo)
 {
     return(DALAntennalnfo.Modify(etAntennalnfo));
 }
コード例 #3
0
 /// <summary>
 /// 添加一个对象,返回新对象ID号
 /// </summary>
 /// <param name="entityPdt"></param>
 /// <returns></returns>
 public static Int32 Add(EtAntennalnfo etAntennalnfo)
 {
     return(DALAntennalnfo.Add(etAntennalnfo));
 }