Ejemplo n.º 1
0
        string getRecodeStatusQuery(RecLogItem.RecodeStatuses recodeStatuse0, string tableNameAbbr0 = TABLE_NAME_ABBR)
        {
            if (recodeStatuse0 == RecLogItem.RecodeStatuses.ALL)
            {
                return(null);
            }

            StringBuilder sb1            = new StringBuilder();
            string        tableNameAbbr1 = null;

            if (!string.IsNullOrEmpty(tableNameAbbr0))
            {
                tableNameAbbr1 = tableNameAbbr0 + ".";
            }
            if (127 < (int)RecLogItem.RecodeStatuses.ALL)
            {
                throw new NotImplementedException("RecLogItem.RecodeStatuses Item");
            }
            foreach (var item1 in new RecLogItem.RecodeStatuses[] {
                RecLogItem.RecodeStatuses.予約済み,
                RecLogItem.RecodeStatuses.視聴済み,
                RecLogItem.RecodeStatuses.録画完了,
                RecLogItem.RecodeStatuses.録画異常,
                RecLogItem.RecodeStatuses.無効登録,
                RecLogItem.RecodeStatuses.放送中止,
                RecLogItem.RecodeStatuses.明
            })
            {
                if (recodeStatuse0.HasFlag(item1))
                {
                    if (0 < sb1.Length)
                    {
                        sb1.Append(" OR ");
                    }

                    sb1.Append(tableNameAbbr1 + COLUMN_recodeStatus + "=" + (int)item1);
                }
            }

            return("(" + sb1.ToString() + ")");
        }