Example #1
0
        public PowerGroupInfo GetModel(int id, bool fromCache = false)
        {
            PowerGroupInfo entity = null;

            List <PowerGroupInfo> list = GetList(fromCache);

            entity = list.Find(c => c.ID == id);

            return(entity);
        }
Example #2
0
        public static PowerGroupInfo PopulatePowerGroupInfo(IDataReader reader)
        {
            PowerGroupInfo entity = new PowerGroupInfo()
            {
                ID              = (int)reader["ID"],
                GroupName       = reader["GroupName"] as string,
                GroupPower      = reader["GroupPower"] as string,
                MemberCount     = DataConvert.SafeInt(reader["MemberCount"]),
                CorporationID   = DataConvert.SafeInt(reader["CorporationID"]),
                CorporationName = reader["CorporationName"] as string,
                CanviewGroupIds = reader["CanviewGroupIds"] as string,
                LastUpdateTime  = DataConvert.SafeDate(reader["LastUpdateTime"]),
                Sort            = DataConvert.SafeInt(reader["Sort"])
            };

            return(entity);
        }
Example #3
0
 public void Update(PowerGroupInfo entity)
 {
     CommonDataProvider.Instance().UpdatePowerGroup(entity);
 }
Example #4
0
 public void Add(PowerGroupInfo entity)
 {
     CommonDataProvider.Instance().AddPowerGroup(entity);
 }
Example #5
0
 public abstract void AddPowerGroup(PowerGroupInfo entity);
Example #6
0
 public abstract void UpdatePowerGroup(PowerGroupInfo entity);
 public override void UpdatePowerGroup(PowerGroupInfo entity)
 {
     string sql = @"
     UPDATE ComOpp_PowerGroup set
         GroupName = @GroupName
         ,GroupPower = @GroupPower
         ,CanviewGroupIds = @CanviewGroupIds
         ,LastUpdateTime = @LastUpdateTime
     WHERE ID=@ID";
     SqlParameter[] parameters =
     {
         new SqlParameter("@ID", entity.ID),
         new SqlParameter("@GroupName", entity.GroupName),
         new SqlParameter("@GroupPower", entity.GroupPower),
         new SqlParameter("@CanviewGroupIds", entity.CanviewGroupIds),
         new SqlParameter("@LastUpdateTime", entity.LastUpdateTime)
     };
     SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, parameters);
 }
 public override void AddPowerGroup(PowerGroupInfo entity)
 {
     string sql = @"INSERT INTO ComOpp_PowerGroup(
         [GroupName]
         ,[GroupPower]
         ,[CorporationID]
         ,[CanviewGroupIds]
         ,[Sort]
     )VALUES(
         @GroupName
         ,@GroupPower
         ,@CorporationID
         ,@CanviewGroupIds
         ,(SELECT ISNULL(MAX([Sort]),0) + 1 FROM ComOpp_PowerGroup WHERE [CorporationID] = @CorporationID)
     )";
     SqlParameter[] p =
     {
         new SqlParameter("@GroupName",entity.GroupName),
         new SqlParameter("@GroupPower",entity.GroupPower),
         new SqlParameter("@CorporationID",entity.CorporationID),
         new SqlParameter("@CanviewGroupIds",entity.CanviewGroupIds)
     };
     SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p);
 }
Example #9
0
 public void Update(PowerGroupInfo entity)
 {
     CommonDataProvider.Instance().UpdatePowerGroup(entity);
 }
Example #10
0
 public void Add(PowerGroupInfo entity)
 {
     CommonDataProvider.Instance().AddPowerGroup(entity);
 }
Example #11
0
 public abstract void UpdatePowerGroup(PowerGroupInfo entity);
Example #12
0
 public abstract void AddPowerGroup(PowerGroupInfo entity);
Example #13
0
        public static PowerGroupInfo PopulatePowerGroupInfo(IDataReader reader)
        {
            PowerGroupInfo entity = new PowerGroupInfo()
            {
                ID = (int)reader["ID"],
                GroupName = reader["GroupName"] as string,
                GroupPower = reader["GroupPower"] as string,
                MemberCount = DataConvert.SafeInt(reader["MemberCount"]),
                CorporationID = DataConvert.SafeInt(reader["CorporationID"]),
                CorporationName = reader["CorporationName"] as string,
                CanviewGroupIds = reader["CanviewGroupIds"] as string,
                LastUpdateTime = DataConvert.SafeDate(reader["LastUpdateTime"]),
                Sort = DataConvert.SafeInt(reader["Sort"])
            };

            return entity;
        }