using System;
using System.Drawing;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using sbsit;
using sbsit.forms;
using sbsit.db;
using Npgsql;
using NpgsqlTypes;

namespace cito.spr
{
    public class prep : sbsit.forms.DataForm
    {
        dbo_prep prep_dbo;

        protected override void MkForm()
        {
            base.MkForm();
            ToolsMenuAddItem("Найти в прайсах (F3)", Pictures.page_find1, new EventHandler(fnd_in_ppr_Click));
        }
        void Grid_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e)
        {
            if (e.KeyData == Keys.F3) { fnd_in_ppr_Click(null, EventArgs.Empty); }
        }
        void fnd_in_ppr_Click(object sender, EventArgs e)
        {
            if (CurrentDataRow == null) { MessageBox.Show("Выберите позицию для поиска."); return; }
            cito.zak.post_prices prices = new cito.zak.post_prices(dbo.connection);
            prices.ShowForSelect(frm, (int)CurrentDataRow[Cols.id]);
        }

        public prep(NpgsqlConnection con):base(con)
        {
            Grid.PreviewKeyDown += new PreviewKeyDownEventHandler(Grid_PreviewKeyDown);
        }
        protected override Type ColsList { get { return typeof(Cols); } }
        protected override sbsit.db.DbObjectAutoEdit dbo { get { return this.prep_dbo; } }
        protected override string FormCaption { get { return "Препараты"; } }
        protected override void MkDbo(NpgsqlConnection con)
        {
            prep_dbo = new dbo_prep(con);
        }
        protected override System.Drawing.Bitmap MenuImage { get { return Pictures.pill; } }

        //Cols:
        [CmdInsert("spr.prep_ins", new string[] { Cols.fk_grp, Cols.prep,Cols.max_nac,Cols.nds,Cols.fnd_prep, Cols.fnd_proizv,Cols.atc,Cols.anotashka}),
         CmdUpdate("spr.prep_upd", new string[] { Cols.id, Cols.fk_grp, Cols.prep, Cols.max_nac, Cols.nds, Cols.fnd_prep, Cols.fnd_proizv, Cols.atc, Cols.anotashka }),
         CmdDelete("spr.prep_del", new string[] { Cols.id })]
        public static class Cols
        {
            [Hidden,PrimaryKey(true),Param(NpgsqlDbType.Integer)]
            public const string id = "id";

            [Caption("Группа"), Filter("spr.grp","grp")]
            public const string grp = "grp";

            [SelSpr("cito.spr.grp", new string[]{"grp"}),Param(NpgsqlDbType.Integer)]
            public const string fk_grp = "fk_grp";

            [Caption("Препарат"), Filter(),Param(NpgsqlDbType.Text)]
            public const string prep = "prep";

            [Caption("Макс.Нац."), NumFormat(NumFmt.fDec),Param(NpgsqlDbType.Integer)]
            public const string max_nac = "max_nac";

            [Caption("НДС"),Param(NpgsqlDbType.Boolean)]
            public const string nds = "nds";

            [Caption("Поиск"),Param(NpgsqlDbType.Text)]
            public const string fnd_prep = "fnd_prep";

            [Caption("Поиск Произв."),Param(NpgsqlDbType.Text)]
            public const string fnd_proizv = "fnd_proizv";

            [Caption("ATC-группа"), Filter(),Param(NpgsqlDbType.Text)]
            public const string atc = "atc";

            [Caption("Аннотация"),Param(NpgsqlDbType.Text)]
            public const string anotashka = "anotashka";
        }

        //dbo:
        public class dbo_prep : sbsit.db.DbObjectAutoEdit
        {
            public dbo_prep(NpgsqlConnection con)
                :base("spr.prep_schema","spr.prep_sel",typeof(Cols),con)
            {
                ;
            }
        }
    }
}