C# MySqlDataReader.GetChar方法代码示例

        private TrackingEntry readEntry(MySqlDataReader reader)
        {
            TrackingEntry currentEntry = new TrackingEntry();

            currentEntry.entryID = reader.GetInt32(0);
            currentEntry.taggerID = reader.GetInt32(1);
            currentEntry.type = reader.GetChar(2);
            currentEntry.isTagged = reader.GetBoolean(3);
            currentEntry.taggerName = reader.GetString(4);
            currentEntry.entryDate = ((DateTime)reader.GetMySqlDateTime(5)).ToString("yyyy-MM-dd HH:mm:ss");

            if (reader.IsDBNull(6))
                currentEntry.tagNumber = -1;
            else
                currentEntry.tagNumber = reader.GetInt32(6);

            currentEntry.species = reader.GetString(7);

            if (reader.IsDBNull(8))
                currentEntry.city = "";
            else
                currentEntry.city = reader.GetString(8);

            if (reader.IsDBNull(9))
                currentEntry.state = "";
            else
                currentEntry.state = reader.GetString(9);

            if (reader.IsDBNull(10))
                currentEntry.country = "";
            else
                currentEntry.country = reader.GetString(10);

            if (reader.IsDBNull(11))
                currentEntry.longitude = "";
            else
                currentEntry.longitude = reader.GetString(11);

            if (reader.IsDBNull(12))
                currentEntry.latitude = "";
            else
                currentEntry.latitude = reader.GetString(12);

            if (reader.IsDBNull(13))
                currentEntry.temperature = "";
            else
                currentEntry.temperature = reader.GetString(13);

            if (reader.IsDBNull(14))
                currentEntry.precipitation = "";
            else
                currentEntry.precipitation = reader.GetString(14);

            if (reader.IsDBNull(15))
                currentEntry.windSpeed = "";
            else
                currentEntry.windSpeed = reader.GetString(15);

            if (reader.IsDBNull(16))
                currentEntry.windDirection = "";
            else
                currentEntry.windDirection = reader.GetString(16);

            return currentEntry;
        }

 private Employee constructEmployee(MySqlDataReader staffReader)
 {
     Employee newEmployee = new Employee();
     newEmployee.NINo = staffReader.GetString("National_Insurance_Number");
     newEmployee.FirstName = staffReader.GetString("First_Name");
     newEmployee.LastName = staffReader.GetString("Last_Name");
     newEmployee.Position = staffReader.GetString("Position");
     newEmployee.Gender = staffReader.GetChar("Gender");
     newEmployee.DateStarted = staffReader.GetDateTime("Date_Started");
     newEmployee.DateFinished = SafeGetDateTime(staffReader, "Date_Finished");
     newEmployee.PVGDate = staffReader.GetDateTime("PVG_Date");
     newEmployee.HolidaysEntitled = staffReader.GetInt16("Holidays_Entitled");
     newEmployee.HolidaysTaken = staffReader.GetInt16("Holidays_Taken");
     newEmployee.WeeksHours = staffReader.GetInt16("Hours");
     newEmployee.Address = constructAddress(staffReader);
     newEmployee.DOB = staffReader.GetDateTime("DOB");
     newEmployee.Salary = staffReader.GetDecimal("Salary");
     newEmployee.HomePhone = staffReader.GetString("Home_Phone");
     newEmployee.MobilePhone = staffReader.GetString("Mobile_Phone");
     newEmployee.Email = staffReader.GetString("Email");
     newEmployee.Training = SafeGetString(staffReader, "Training");
     newEmployee.Medical = constructMedical(staffReader);
     //EC...
     return newEmployee;
 }

        private Parent constructParent(MySqlDataReader parentReader)
        {
            Parent newParent = new Parent();
            newParent.ParentID = parentReader.GetInt32("Parent_ID");
            newParent.FirstName = parentReader.GetString("First_Name");
            newParent.LastName = parentReader.GetString("Last_Name");
            newParent.Title = parentReader.GetString("Title");
            newParent.Gender = parentReader.GetChar("Gender");
            newParent.HomePhone = parentReader.GetString("Home_Phone");
            newParent.WorkPhone = parentReader.GetString("Work_Phone");
            newParent.MobilePhone = parentReader.GetString("Mobile_Phone");
            newParent.HomeAddress = constructMultipleAddress(parentReader, "home");
            newParent.WorkAddress = constructMultipleAddress(parentReader, "work");
            //newParent.Spouse = childReader.GetInt16(10);
            newParent.Email = SafeGetString(parentReader, "Email");

            //Neglecting list of children?

            return newParent;
        }

        private EmergencyContact constructEmergencyContact(MySqlDataReader ECReader)
        {
            EmergencyContact newEC = new EmergencyContact();
            newEC.ContactID = ECReader.GetInt32("Contact_ID");
            newEC.Title = ECReader.GetString("Title");
            newEC.FirstName = ECReader.GetString("First_Name");
            newEC.LastName = ECReader.GetString("Last_Name");
            newEC.Relationship = ECReader.GetString("Relationship");
            newEC.HomePhone = ECReader.GetString("Home_Phone");
            newEC.WorkPhone = ECReader.GetString("Work_Phone");
            newEC.MobilePhone = ECReader.GetString("Mobile_Phone");
            newEC.HomeAddress = constructMultipleAddress(ECReader, "home");
            newEC.WorkAddress = constructMultipleAddress(ECReader, "work");
            newEC.Gender = ECReader.GetChar("Gender");
            newEC.Email = ECReader.GetString("Email");

            return newEC;
        }

        private Child constructChild(MySqlDataReader childrenReader)
        {
            Child newChild = new Child();
            newChild.ChildID = childrenReader.GetInt32("Child_Id");
            newChild.FirstName = childrenReader.GetString("First_Name");
            newChild.LastName = childrenReader.GetString("Last_Name");
            newChild.Gender = childrenReader.GetChar("Gender");
            newChild.DOB = childrenReader.GetDateTime("DOB");

            newChild.FirstLanguage = childrenReader.GetString("First_Language");
            newChild.RoomAttending = childrenReader.GetString("Room_Attending");
            //newChild.Sibling = SafeGetInt(childrenReader, "Sibling");
            newChild.DateApplied = childrenReader.GetDateTime("Date_Applied");
            newChild.DateLeft = SafeGetDateTime(childrenReader, "Date_Left");
            newChild.Attendance = constructAttendance(childrenReader);
            newChild.ExtraDays = childrenReader.GetInt16("Extra_Days");
            newChild.Teas = childrenReader.GetInt16("Teas");
            newChild.MedicalInfo = constructMedical(childrenReader);

            //newChild.ParentsIDs.Add(childrenReader.GetInt16(16));
            //newChild.EmergencyContactsIDs.Add(childrenReader.GetInt16(16));
            //Get parents
            //foreach (int parentID in selectChildsParentIDs(newChild.ChildID))
            //    newChild.Parents.Add(constructParent(childrenReader, 16));

            ////Get Emergency Contacts
            //foreach (int contactID in selectChildsContactIDs(newChild.ChildID))
            //    newChild.EmergencyContacts.Add(selectEmergencyContact(contactID), 30);
            return newChild;
        }

        private void LoadLine(MySqlDataReader rdr)
        {
            string temp = "";

            if(!rdr.IsDBNull(0)) { line_no = rdr.GetInt32(0); ORDER_ARRAY[rowCount, CONST_LINE_NO] = line_no.ToString(); }
            if (!rdr.IsDBNull(1)) { part_id = rdr.GetString(1); ORDER_ARRAY[rowCount, CONST_PARTID] = part_id; }
            if (!rdr.IsDBNull(2)) { desc = rdr.GetString(2); ORDER_ARRAY[rowCount, CONST_DESC] = desc; }
            if (!rdr.IsDBNull(3)) { ordered_qty = rdr.GetInt32(3); ORDER_ARRAY[rowCount, CONST_ORDERED] = ordered_qty.ToString(); }
            if (!rdr.IsDBNull(4)) { unit_price = rdr.GetFloat(4); ORDER_ARRAY[rowCount, CONST_PRICE] = unit_price.ToString(); }
            if (!rdr.IsDBNull(5)) { mod = rdr.GetChar(5); ORDER_ARRAY[rowCount, CONST_MOD] = mod.ToString(); }
            if (!rdr.IsDBNull(6)) { gst = Math.Round(rdr.GetDouble(6), 2); ORDER_ARRAY[rowCount, CONST_GST] = gst.ToString(); }
            if (!rdr.IsDBNull(7)) { pst = Math.Round(rdr.GetDouble(7), 2); ORDER_ARRAY[rowCount, CONST_PST] = pst.ToString(); }
            if (!rdr.IsDBNull(8)) { notes = rdr.GetString(8); ORDER_ARRAY[rowCount, CONST_NOTES] = notes; }

            bool cust = false;
            if (mod == 'C')
                cust = true;
            DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
            checkColumn.Name = "X";
            checkColumn.HeaderText = "X";
            checkColumn.Width = 50;
            checkColumn.ReadOnly = false;
            checkColumn.FillWeight = 10; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values

            dgOrderForm.Rows.Add(line_no.ToString(), cust, part_id, "", desc, ordered_qty.ToString(), unit_price.ToString(), gst.ToString(), pst.ToString(), notes);

            MAX_LINE = Convert.ToInt32(line_no);
        }

 private static List<Object> DescomponerPersona(MySqlDataReader personaBD)
 {
     List<Object> listaPersona = new List<Object>();
     while (personaBD.Read())
     {
         listaPersona.Add(personaBD.GetInt32(0));
         listaPersona.Add(personaBD.GetString(1));
         listaPersona.Add(personaBD.GetString(2));
         listaPersona.Add(personaBD.GetString(3));
         if (personaBD.IsDBNull(4))
         {
             listaPersona.Add(null);
         }
         else
         {
             listaPersona.Add(personaBD.GetInt32(4));
         }
         listaPersona.Add(personaBD.GetChar(5));
     }
     return listaPersona;
 }

        private static List<Object> DescomponerPersonas(MySqlDataReader personaBD)
        {
            List<Object> listaPersona = new List<Object>();
            while (personaBD.Read())
            {
                Persona persona = new Persona();
                persona.IdPersona = personaBD.GetInt32(0);
                persona.NombreCompleto = personaBD.GetString(1);
                persona.ApellidoPaterno = personaBD.GetString(2);
                if (personaBD.IsDBNull(3))
                {
                    persona.ApellidoMaterno = "";
                }
                else {
                    persona.ApellidoMaterno = personaBD.GetString(3);
                }
                if (personaBD.IsDBNull(5))
                {
                    persona.Sexo = ' ';
                }
                else
                {
                    persona.Sexo = personaBD.GetChar(5);
                }


                listaPersona.Add(persona);
            }
            return listaPersona;
        }