Exemple #1
0
        private string SquirrelMemberList()
        {
            StringBuilder sb  = new StringBuilder();
            ExportManager oEM = new ExportManager();
            DataTable     dt  = ExportDataDAL.SquirrelMemberList();

            if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    string strOutput = "";

                    string memberNumber   = Convert.ToString(dr["MemberNumber"]) == "" ? "" : (Convert.ToString(dr["MemberNumber"]) + new string(' ', 8));
                    string lastNameSuffix = (Convert.ToString(dr["LastName"]) == "" ? "" : Convert.ToString(dr["LastName"])) + " " + (Convert.ToString(dr["Suffix"]) == "" ? "" : Convert.ToString(dr["Suffix"])) + new string(' ', 15);
                    string firstMiddle    = (Convert.ToString(dr["FirstName"]) == "" ? "" : Convert.ToString(dr["FirstName"])) + " " + (Convert.ToString(dr["MiddleName"]) == "" ? "" : Convert.ToString(dr["MiddleName"])) + new string(' ', 20);

                    strOutput  = memberNumber.Substring(0, 8) + "0";
                    strOutput += lastNameSuffix.Substring(0, 15);
                    strOutput += firstMiddle.Substring(0, 20) + "A0" + new string(' ', 59) + "0";

                    sb.AppendLine(strOutput);
                }
            }


            return(sb.ToString());
        }