コード例 #1
0
        public List <Medicines> Draw_GivenKind()
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();
            ListDictionary   Params = new ListDictionary();
            DataSet          ds     = dm.Draw_GivenKind(Params);
            List <Medicines> lg     = new List <Medicines>();
            Medicines        g;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                g          = new Medicines();
                g.Influens = item.Field <int>("Medicine");
                lg.Add(g);
            }
            return(lg);
        }
コード例 #2
0
        public List <Vitamins> Draw_Vitamin()
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();
            ListDictionary  Params = new ListDictionary();
            DataSet         ds     = dm.Draw_Medicine(Params);
            List <Vitamins> lv     = new List <Vitamins>();
            Vitamins        v;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                v         = new Vitamins();
                v.Vitamin = item.Field <string>("Vitamin");
                lv.Add(v);
            }
            return(lv);
        }
コード例 #3
0
        public int Update_Sensitivities(int Sensitivity, int Medicine, string Influensse, DateTime DesicionDate, string Desided)
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();

            ListDictionary Params = new ListDictionary();

            Params.Add("@Sensitivity", BLCtrl.sendInt("Sensitivity", 0));
            Params.Add("@Medicine", BLCtrl.sendInt("Medicine", 0));
            Params.Add("@Influensse", BLCtrl.sendString("Influensse", ""));
            Params.Add("@DesicionDate", BLCtrl.sendDateTime("DesicionDate", new DateTime(01 / 01 / 2018)));
            Params.Add("@Desided", BLCtrl.sendString("Desided", ""));

            int result = dm.Update_Sensitivities(Params);

            return(result);
        }
コード例 #4
0
        public List <Medicines> Draw_Influenss()
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();
            ListDictionary   Params = new ListDictionary();
            DataSet          ds     = dm.Draw_Influenss(Params);
            List <Medicines> li     = new List <Medicines>();
            Medicines        i;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                i          = new Medicines();
                i.Influens = item.Field <int>("Influens");
                li.Add(i);
            }
            return(li);
        }
コード例 #5
0
        public List <MedicinesKind> Draw_MedicineSS()
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();
            ListDictionary       Params = new ListDictionary();
            DataSet              ds     = dm.Draw_MedicineSS(Params);
            List <MedicinesKind> lm     = new List <MedicinesKind>();
            MedicinesKind        m;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                m          = new MedicinesKind();
                m.Medicine = item.Field <string>("Medicine");
                lm.Add(m);
            }
            return(lm);
        }
コード例 #6
0
        //public int Update_MedicineVitamin(int Medicine, int Vitamin, bool Active, string GivenKind, string Quantity, int Days, string GivenOn, string Text)
        //{
        //    DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();

        //    ListDictionary Params = new ListDictionary();
        //    Params.Add("@Medicine", BLCtrl.sendInt("Medicine", 0));
        //    Params.Add("@Vitamin", BLCtrl.sendInt("Vitamin", 0));
        //    Params.Add("@Active", BLCtrl.sendBool("Active", false));
        //    Params.Add("@GivenKind", BLCtrl.sendString("GivenKind", ""));
        //    Params.Add("@Quantity", BLCtrl.sendString("Quantity", ""));
        //    Params.Add("@Days", BLCtrl.sendInt("Days", 0));
        //    Params.Add("@GivenOn", BLCtrl.sendString("GivenOn", ""));
        //    Params.Add("@Text", BLCtrl.sendString("Text", ""));

        //    int result = dm.Update_MedicineVitamin(Params);

        //    return result;
        //}

        //public List<GivenKind> Print_ReceiptMV()
        //{
        //    DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();
        //    ListDictionary Params = new ListDictionary();
        //    DataSet ds = dm.Print_ReceiptMV(Params);
        //    List<GivenKind> lg = new List<GivenKind>();
        //    GivenKind g;
        //    foreach (DataRow item in ds.Tables[0].Rows)
        //    {
        //        g = new GivenKind();
        //        g.GivenKind = item.Field<int>("GivenKind");
        //        lg.Add(g);
        //    }
        //    return lg;
        //}



        public List <Sensitivitieskinds> Draw_KindSS()
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();
            ListDictionary            Params          = new ListDictionary();
            DataSet                   ds = dm.Draw_KindSS(Params);
            List <Sensitivitieskinds> ls = new List <Sensitivitieskinds>();
            Sensitivitieskinds        s;

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                s             = new Sensitivitieskinds();
                s.Sensitivity = item.Field <string>("Sensitivity");
                ls.Add(s);
            }
            return(ls);
        }
コード例 #7
0
        public int Add_MedicineVitamin(int Medicine, int Vitamin, bool Active, string GivenKind, string Quantity, int Days, string GivenOn, string Text)
        {
            DAL_AddMedicineVitaminAndSensitivities dm = new DAL_AddMedicineVitaminAndSensitivities();

            ListDictionary Params = new ListDictionary();

            Params.Add("@Medicine", BLCtrl.sendInt("Medicine", 0));
            Params.Add("@Vitamin", BLCtrl.sendInt("Vitamin", 0));
            Params.Add("@Active", BLCtrl.sendBool("Active", false));
            Params.Add("@GivenKind", BLCtrl.sendString("GivenKind", ""));
            Params.Add("@Quantity", BLCtrl.sendString("Quantity", ""));
            Params.Add("@Days", BLCtrl.sendInt("Days", 0));
            Params.Add("@GivenOn", BLCtrl.sendString("GivenOn", ""));
            Params.Add("@Text", BLCtrl.sendString("Text", ""));

            int result = dm.Add_MedicineVitamin(Params);

            return(result);
        }