Ejemplo n.º 1
0
        /// <summary>
        /// 将记录集转为Model_Employees实体类 (Model_Employees)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="fileds">字段名列表</param>
        /// <returns>Model_Employees</returns>
        protected Owen.Model.Model_Employees Populate_Employees(IDataReader reader, Dictionary<string, string> fileds)
        {
            Owen.Model.Model_Employees model = new Owen.Model.Model_Employees();
            if (fileds.ContainsKey("EmployeesID") && !Convert.IsDBNull(reader["EmployeesID"]))
            {
                model.EmployeesID = Convert.ToInt32(reader["EmployeesID"]);
            }
            if (fileds.ContainsKey("DistributorID") && !Convert.IsDBNull(reader["DistributorID"]))
            {
                model.DistributorID = Convert.ToInt32(reader["DistributorID"]);
                Model.Model_Distributor mDistributor = new DAL_Distributor().GetEntity(model.DistributorID);
                if (mDistributor != null)
                    model.Distributor = mDistributor;
            }

            if (fileds.ContainsKey("EmployeesName") && !Convert.IsDBNull(reader["EmployeesName"]))
                model.EmployeesName = reader["EmployeesName"].ToString();


            if (fileds.ContainsKey("Address") && !Convert.IsDBNull(reader["Address"]))
                model.Address = reader["Address"].ToString();
            if (fileds.ContainsKey("Mobile") && !Convert.IsDBNull(reader["Mobile"]))
                model.Mobile = reader["Mobile"].ToString();
            if (fileds.ContainsKey("Sex") && !Convert.IsDBNull(reader["Sex"]))
                model.Sex = Convert.ToInt32(reader["Sex"]);
            if (fileds.ContainsKey("NativePlace") && !Convert.IsDBNull(reader["NativePlace"]))
                model.NativePlace = reader["NativePlace"].ToString();
            if (fileds.ContainsKey("Status") && !Convert.IsDBNull(reader["Status"]))
                model.Status = Convert.ToInt32(reader["Status"]);
            if (fileds.ContainsKey("Memo") && !Convert.IsDBNull(reader["Memo"]))
                model.Memo = reader["Memo"].ToString();
            return model;
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 将记录集转为Model_Doctor实体类 (Model_Doctor)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="fileds">字段名列表</param>
        /// <returns>Model_Doctor</returns>
        protected Owen.Model.Model_Doctor Populate_Doctor(IDataReader reader, Dictionary<string, string> fileds)
        {
            Owen.Model.Model_Doctor model = new Owen.Model.Model_Doctor();
            if (fileds.ContainsKey("DoctorID") && !Convert.IsDBNull(reader["DoctorID"]))
            {
                model.DoctorID = Convert.ToInt32(reader["DoctorID"]);
            }
            if (fileds.ContainsKey("HospitalID") && !Convert.IsDBNull(reader["HospitalID"]))
            {
                model.HospitalID = Convert.ToInt32(reader["HospitalID"]);
                Model.Model_Hospital mHospital = new DAL_Hospital().GetEntity(model.HospitalID);
                if (mHospital != null)
                    model.Hospital = mHospital;
            }
            if (fileds.ContainsKey("DistributorID") && !Convert.IsDBNull(reader["DistributorID"]))
            {
                model.DistributorID = Convert.ToInt32(reader["DistributorID"]);
                Model.Model_Distributor mDistributor = new DAL_Distributor().GetEntity(model.DistributorID);
                if (mDistributor != null)
                    model.Distributor = mDistributor;
            }

            if (fileds.ContainsKey("Name") && !Convert.IsDBNull(reader["Name"]))
                model.Name = reader["Name"].ToString();
            if (fileds.ContainsKey("DepartmentID") && !Convert.IsDBNull(reader["DepartmentID"]))
            {
                model.DepartmentID = Convert.ToInt32(reader["DepartmentID"]);
                Model.Model_Dictionary mDic = new DAL_Dictionary().GetEntity(model.DepartmentID);
                if (mDic != null)
                    model.Department = mDic.DicName;
            }
                
            if (fileds.ContainsKey("JobTitle") && !Convert.IsDBNull(reader["JobTitle"]))
                model.JobTitle = reader["JobTitle"].ToString();
            if (fileds.ContainsKey("Mobile") && !Convert.IsDBNull(reader["Mobile"]))
                model.Mobile = reader["Mobile"].ToString();
            if (fileds.ContainsKey("Sex") && !Convert.IsDBNull(reader["Sex"]))
                model.Sex = Convert.ToInt32(reader["Sex"]);
            if (fileds.ContainsKey("NativePlace") && !Convert.IsDBNull(reader["NativePlace"]))
                model.NativePlace = reader["NativePlace"].ToString();
            if (fileds.ContainsKey("Status") && !Convert.IsDBNull(reader["Status"]))
                model.Status = Convert.ToInt32(reader["Status"]);
            if (fileds.ContainsKey("EmployeesID") && !Convert.IsDBNull(reader["EmployeesID"]))
                model.EmployeesID = Convert.ToInt32(reader["EmployeesID"]);
            return model;
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 将记录集转为Model_SysLog实体类 (Model_SysLog)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="fileds">字段名列表</param>
        /// <returns>Model_SysLog</returns>
        protected Owen.Model.Model_Hospital Populate_Hospital(IDataReader reader, Dictionary<string, string> fileds)
        {
            Owen.Model.Model_Hospital entity = new Owen.Model.Model_Hospital();
            if (fileds.ContainsKey("HospitalID") && !Convert.IsDBNull(reader["HospitalID"]))
                entity.HospitalID = Convert.ToInt32(reader["HospitalID"]);

            if (fileds.ContainsKey("DistributorID") && !Convert.IsDBNull(reader["DistributorID"]))
            {
                entity.DistributorID = Convert.ToInt32(reader["DistributorID"]);
                Model.Model_Distributor mDistributor = new DAL_Distributor().GetEntity(entity.DistributorID);
                if (mDistributor != null)
                    entity.Distributor = mDistributor;
            }
            if (fileds.ContainsKey("CityID") && !Convert.IsDBNull(reader["CityID"]))
            {
                entity.CityID = Convert.ToInt32(reader["CityID"]);
                Model.Model_City mCity = new DAL_City().GetEntity(string.Format(" CityID = {0} ", entity.CityID));
                if (mCity != null)
                    entity.CityName = mCity.Name;

            }
            if (fileds.ContainsKey("Name") && !Convert.IsDBNull(reader["Name"]))
                entity.Name = reader["Name"].ToString();
            if (fileds.ContainsKey("HosType") && !Convert.IsDBNull(reader["HosType"]))
            {
                entity.HosType = Convert.ToInt32(reader["HosType"]);
                Model.Model_Dictionary mDic = new DAL_Dictionary().GetEntity(entity.HosType);
                if (mDic != null)
                    entity.HosTypeStr = mDic.DicName;
            }

            if (fileds.ContainsKey("Address") && !Convert.IsDBNull(reader["Address"]))
                entity.Address = reader["Address"].ToString();
            if (fileds.ContainsKey("Phone") && !Convert.IsDBNull(reader["Phone"]))
                entity.Phone = reader["Phone"].ToString();
            if (fileds.ContainsKey("Memo") && !Convert.IsDBNull(reader["Memo"]))
                entity.Memo = reader["Memo"].ToString();
            return entity;
        }