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); }
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); }
public void Update(PowerGroupInfo entity) { CommonDataProvider.Instance().UpdatePowerGroup(entity); }
public void Add(PowerGroupInfo entity) { CommonDataProvider.Instance().AddPowerGroup(entity); }
public abstract void AddPowerGroup(PowerGroupInfo entity);
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); }
public void Update(PowerGroupInfo entity) { CommonDataProvider.Instance().UpdatePowerGroup(entity); }
public void Add(PowerGroupInfo entity) { CommonDataProvider.Instance().AddPowerGroup(entity); }
public abstract void UpdatePowerGroup(PowerGroupInfo entity);
public abstract void AddPowerGroup(PowerGroupInfo entity);
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; }