예제 #1
0
        private string GroveMapNameList()
        {
            StringBuilder sb  = new StringBuilder();
            ExportManager oEM = new ExportManager();
            DataTable     dt  = ExportDataDAL.GroveMapNameList();



            if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    string strOutput = "";
                    strOutput += Convert.ToString(dr["LastName"]) == "" ? "" : Convert.ToString(dr["LastName"]);
                    strOutput += Convert.ToString(dr["FirstName"]) == "" ? "" : " " + Convert.ToString(dr["FirstName"]);
                    strOutput += Convert.ToString(dr["MiddleName"]) == "" ? "" : " " + Convert.ToString(dr["MiddleName"]);
                    strOutput += Convert.ToString(dr["Suffix"]) == "" ? "" : " " + Convert.ToString(dr["Suffix"]);
                    strOutput += Convert.ToString(dr["CampName"]) == "" ? "" : (((char)9).ToString() + Convert.ToString(dr["CampName"]));

                    sb.AppendLine(strOutput);
                }
            }



            return(sb.ToString());
        }