formtemplateaccessor.cs.svn-base

MIED是用于个人帐务管理的小型软件

using System.Collections;
using System.Data.Common;
using DatabaseUtil;
using Mied.BusinessObject;
using Mied.BusinessObject.FormTemplates;
using Mied.DAL.TableSchema;
using SqlcePlugin;

namespace Mied.DAL.Accesses
{
    public class FormTemplateAccessor : AccessorSelect
    {
        internal FormTemplateAccessor(MiedDatabase database)
            : base(database, FormTemplateSchema.TableName)
        {
        }

        public IList SelectList(TemplateType type)
        {
            return base.SelectList(FormTemplateSchema.FieldType, (int)type);
        }

        public TemplateRecord SelectTemplateRecord(int id)
        {
            TemplateRecord record = (TemplateRecord)base.Select(id);
            return record;
        }

        public string CaculateNewName(TemplateType type)
        {
            IList list = SelectList(type);

            int i = 0;
            while (true)
            {
                string newName = "Template" + i.ToString();

                bool founded = false;
                foreach (TemplateRecord record in list)
                {
                    if (newName == record.Name)
                    {
                        founded = true;
                        break;
                    }
                }

                if (!founded)
                {
                    return newName;
                }

                i++;
            }
        }

        protected override void CommandSaveSupplement(DbCommand command)
        {
            SqlCECommandHelper.SetParameterType_Image(command, "@" + FormTemplateSchema.FieldXml);
            SqlCECommandHelper.SetParameterType_Image(command, "@" + FormTemplateSchema.FieldImage);
        }

        protected override CommandFieldValueList BuildPairList(Entity entity)
        {
            TemplateRecord record = (TemplateRecord)entity;
            CommandFieldValueList pairList = new CommandFieldValueList(record.ID);
            pairList.Add(FormTemplateSchema.FieldName, record.Name);
            pairList.Add(FormTemplateSchema.FieldImage, record.Image);
            pairList.Add(FormTemplateSchema.FieldDescription, record.Description);
            pairList.Add(FormTemplateSchema.FieldType, (int)record.Type);
            pairList.AddZip(FormTemplateSchema.FieldXml, record.Xml);
            return pairList;
        }

        protected override Mied.BusinessObject.Entity ReadEntity(RecordReader reader)
        {
            TemplateRecord record = new TemplateRecord();
            record.ID = reader.GetInt32(FormTemplateSchema.FieldID);
            record.Name = reader.GetString(FormTemplateSchema.FieldName);
            record.Image = reader.GetByte(FormTemplateSchema.FieldImage);
            record.Description = reader.GetString(FormTemplateSchema.FieldDescription);
            record.Type = (TemplateType)reader.GetInt32(FormTemplateSchema.FieldType);
            record.Xml = reader.GetZipBytes(FormTemplateSchema.FieldXml);
            return record;
        }
    }
}