Пример #1
0
        public int DeleteHospitalizations(int Code)
        {
            DAHospitalizations DAH    = new DAHospitalizations();
            ListDictionary     Params = new ListDictionary();

            Params.Add("@Code", Code);
            int result = DAH.DeleteHospitalizations(Params);

            return(result);
        }
Пример #2
0
        public List <string> GetNameHospital(string Num)
        {
            DAHospitalizations DAH    = new DAHospitalizations();
            ListDictionary     Params = new ListDictionary();

            Params.Add("@Num", Num);
            DataSet       ds = DAH.GetNameHospital(Params);
            string        S;
            List <string> MyNameHospital = new List <string>();

            S = BLCtrl.getString(ds.Tables[0].Rows[0], "Hospital", "");
            MyNameHospital.Add(S);
            return(MyNameHospital);
        }
Пример #3
0
        public List <Hospitalizations> GetAllHspitalization(string Id)
        {
            DAHospitalizations DAH    = new DAHospitalizations();
            ListDictionary     Params = new ListDictionary();

            Params.Add("@MyId", Id);
            DataSet                 ds  = DAH.GetAllHspitalization(Params);
            Hospitalizations        H   = new Hospitalizations();
            List <Hospitalizations> MyH = new List <Hospitalizations>();

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                H.Code        = BLCtrl.getInt(item, "Code", 0);
                H.Year        = BLCtrl.getInt(item, "Year", 0);
                H.Hospital    = BLCtrl.getString(item, "Hospital", "");
                H.MyProperty  = BLCtrl.getInt(item, "MyProperty", 0);
                H.Department  = BLCtrl.getString(item, "Department", "");
                H.Reason      = BLCtrl.getString(item, "Reason", "");
                H.By          = BLCtrl.getInt(item, "By", 0);
                H.PatiantCode = BLCtrl.getString(item, "PatiantCode", "");
                MyH.Add(H);
            }
            return(MyH);
        }