未分配的局部变量/更改XML格式

Question

我的程序接受用户输入并使用它来创建查询。然后，该查询的结果将根据xelement的选择放入XML文件中。我有一个字符串staff，我设置等于staffType的值。

其中staff声明为w/查询代码片段:

        using (
            var conn = new SqlConnection("Server=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;Database=KUDERDEV;User ID=xxxxxxxxxxxxxxxxxx;Password= xxxxxxxx;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;")
            )
        {
            conn.Open();
            bool quit = false;
            string choice;
            string staff;
            SqlCommand cmd = new SqlCommand();
            while (!quit)
            {
                Console.WriteLine("Sort by staffType: K12Staff, psStaff, WFStaff or none?");
                string staffType = Console.ReadLine();
                staff = staffType;
                if (staffType == "K12Staff")
                {
                    Console.WriteLine("Sort by code, date, both, or none?");
                    choice = Console.ReadLine();
                    switch (choice)
                    {
                        case "code":
                            Console.WriteLine("Sort by code1 or code2?");
                            string codeCol = Console.ReadLine();
                            Console.WriteLine("Enter desired code");
                            string code = Console.ReadLine();
                            cmd = new SqlCommand("SELECT * FROM Staff WHERE (Staff." + @codeCol + "='" + @code + "') AND staffType ='" + @staffType + "' FOR XML PATH('staff'), ROOT('k12Staff')", conn);
                            quit = true;
                            staff = staffType;
                            break;

当查询字符串完成后，我进入另一个using语句，而不关闭第一个语句来写入XML文件。这里我想根据所选择的staffType更改XML (XElement)的格式。

编写XML文件片段:

        using (cmd)
        {
            using (var reader = cmd.ExecuteXmlReader())
            {
                var doc = XDocument.Load(reader);
                string path = @"Staff." + DateTime.Now.ToString("yyyyMMdd") + ".xml";
                using (var writer = new StreamWriter(path))
                {
                    //if (staff == "k12Staff")
                    XNamespace ns = "http://specification.sifassociation.org/Implementation/na/3.2/html/CEDS/K12/K12_k12Staff.html";
                    var root = new XElement(ns + "k12Staff");
                    foreach (var d in doc.Descendants("staff"))
                    {
                        root.Add(new XElement(ns + "staff",
                                    new XElement(ns + "identity",
                                        new XElement(ns + "name",
                                            new XElement(ns + "firstName", first),
                                            new XElement(ns + "lastName", last)
                                            )
                                        ),
                                    new XElement(ns + "employment",
                                        new XElement(ns + "positionTitle", position)
                                            ),
                                    new XElement(ns + "assignment",
                                        new XElement(ns + "leaID", leaID),
                                        new XElement(ns + "schoolID", schoolID)
                                                ),
                                    new XElement(ns + "contact",
                                        new XElement(ns + "phoneNumberList",
                                            new XElement(ns + "number", phone),
                                            new XElement(ns + "phoneNumberIndicator", indicator)
                                        ),
                                        new XElement(ns + "emailList",
                                            new XElement(ns + "email", email)
                                            )
                                            ),
                                    new XElement(ns + "delete", delete)

然后，如果staffType是不同的东西，例如"psStaff"，那么我将更改XML (XElement)的格式，使其具有不同的名称，位置等。

所以就像

 if(staff == "k12Staff"){
         format xml here...
 }
 else if (staff == "psStaff"){
         format xml here....
 }

等等. .

我的问题:

在前面的例子中，我的代码有if(staff == "k12Staff")，但我被告知它是一个赋值的局部变量。我试过在using语句之外声明人员，也试过在using语句中使用staff，比如using(staff)，这就是我使用cmd变量的方式。为什么我的程序可以识别cmd而不能识别staff ?

Answer 1

您没有发布整个代码，所以不可能说，您的变量staff应该得到一个值，为什么它没有。

Not assigned表示:存在但从未得到值…

在你声明变量的地方修改这个:

    string staff="defaultValue";

在处理变量内容的地方修改如下:

 if(staff == "k12Staff"){
         format xml here...
 }
 else if (staff == "psStaff"){
         format xml here....
 }
 else if (staff == "defaultValue"){
      //What ever is to be done if all attempts to set "staff" did not work
      //You must set a stop mark before your `while (!quit)` and step through.
      //There is at least one situation, where `staff` is not set to any value...
      //If there's a bug you must fix this, if this is allowed to happen, solve it here...
 }