/// <summary> /// 修改主键值一致的记录,并返回受影响行数 /// </summary> public static Int32 Modify(EtBaseStation etBaseStation) { Int32 result = 0; DynamicParameters p = new DynamicParameters(); p.Add("@StationGUID", etBaseStation.StationGUID); p.Add("@TaskID", etBaseStation.TaskID); p.Add("@StationAlias", etBaseStation.StationAlias); p.Add("@Lng", etBaseStation.Lng); p.Add("@Lat", etBaseStation.Lat); p.Add("@StationType", etBaseStation.StationType); p.Add("@MastSave", etBaseStation.MastSave); p.Add("@CoverType", etBaseStation.CoverType); p.Add("@PlanLevel", etBaseStation.PlanLevel); p.Add("@StationID", etBaseStation.StationID); p.Add("@Rows", 0, DbType.Int32, ParameterDirection.Output); using (var cnn = new SqlConnection(SQLDBHelper.ConnectionString)) { cnn.Open(); cnn.Execute("[dbo].[usp_UpdateBaseStation]", p, null, null, CommandType.StoredProcedure); result = p.Get <int>("@Rows"); cnn.Close(); } return(result); }
/// <summary> /// 修改主键值一致的记录,并返回受影响行数 /// </summary> /// <param name="entityPdt">数据库相对应的对象实例</param> public static int Modify(EtBaseStation etBaseStation) { return(DALBaseStation.Modify(etBaseStation)); }
/// <summary> /// 添加一个对象,返回新对象ID号 /// </summary> /// <param name="entityPdt"></param> /// <returns></returns> public static Int32 Add(EtBaseStation etBaseStation) { return(DALBaseStation.Add(etBaseStation)); }