/// <summary>
        /// Initializes a new instance of the <see cref="SpssCasesCollection"/> class.
        /// </summary>
        /// <param name="document">The hosting document.</param>
        internal SpssCasesCollection(SpssDataDocument document)
        {
            if (document == null)
            {
                throw new ArgumentNullException("document");
            }

            this.Document = document;
        }
        /// <summary>
        /// Creates a new SPSS data document, initializing its dictionary 
        /// by copying the dictionary from an existing SPSS data file.
        /// </summary>
        /// <param name="filename">
        /// The filename of the new document to create.
        /// </param>
        /// <param name="copyDictionaryFromFileName">
        /// The filename of the existing SPSS data file to copy the dictionary from.
        /// </param>
        /// <returns>
        /// The newly created <see cref="SpssDataDocument">SPSS data document</see>.
        /// </returns>
        public static SpssDataDocument Create(string filename, string copyDictionaryFromFileName)
        {
            if (File.Exists(filename))
            {
                throw new InvalidOperationException("File to create already exists.");
            }
            if (!File.Exists(copyDictionaryFromFileName))
            {
                throw new FileNotFoundException("File to copy does not exist.", copyDictionaryFromFileName);
            }
            using (SpssDataDocument read = SpssDataDocument.Open(copyDictionaryFromFileName, SpssFileAccess.Read))
            {
                SpssDataDocument toReturn = new SpssDataDocument(filename, SpssFileAccess.Create);

                foreach (SpssVariable var in read.Variables)
                {
                    toReturn.Variables.Add(var.Clone());
                }

                toReturn.CommitDictionary();
                return toReturn;
            }
        }
        /// <summary>
        /// 创建Spss文件
        /// </summary>
        /// <param name="doc"></param>
        public void CreateSpssData(SpssDataDocument doc)
        {
            //// Define dictionary
            //SpssStringVariable v1 = new SpssStringVariable();
            //v1.Name = "v1";
            //v1.Label = "What is your name?";
            //doc.Variables.Add(v1);
            //SpssNumericVariable v2 = new SpssNumericVariable();
            //v2.Name = "v2";
            //v2.Label = "How old are you?";
            //doc.Variables.Add(v2);
            //SpssNumericVariable v3 = new SpssNumericVariable();
            //v3.Name = "v3";
            //v3.Label = "What is your gender?";
            //v3.ValueLabels.Add(1, "Male");
            //v3.ValueLabels.Add(2, "Female");
            //doc.Variables.Add(v3);
            //SpssDateVariable v4 = new SpssDateVariable();
            //v4.Name = "v4";
            //v4.Label = "What is your birthdate?";
            //doc.Variables.Add(v4);
            //// Add some data
            //doc.CommitDictionary();

            string dataBase = string.Format("data source={0}", SourcePath);

            #region 输出变量名
            //建立题号与题型、字段对应的字典
            Dictionary<string, int> dicQType = new Dictionary<string, int>();
            Dictionary<string, int> dicDataType = new Dictionary<string, int>();
            Dictionary<string, int> dicOther = new Dictionary<string, int>();
            Dictionary<string, string> dicQField = new Dictionary<string, string>();
            using (SQLiteConnection conn = new SQLiteConnection(dataBase))
            {
                Visibility = "Visible";
                using (SQLiteCommand cmd = new SQLiteCommand())
                {
                    cmd.Connection = conn;
                    conn.Open();
                    SQLiteHelper sh = new SQLiteHelper(cmd);
                    DataTable dtField = sh.Select("select Q_Num,TypeID,Q_Field,Q_Lable,Q_OptionsCount,Q_OtherOption,Q_ValueLable,DataTypeID from QuestionInfo");
                    foreach (DataRow dr in dtField.Rows)
                    {
                        string QNum = dr["Q_Num"].ToString();
                        string QField = dr["Q_Field"].ToString();
                        string QLable = dr["Q_Lable"].ToString();
                        string TypeID = dr["TypeID"].ToString();
                        string QOptionsCount = dr["Q_OptionsCount"].ToString();
                        dicQType[QNum] = Convert.ToInt32(TypeID);
                        dicDataType[QNum] = Convert.ToInt32(dr["DataTypeID"]);
                        dicOther[QNum] = Convert.ToInt32(dr["Q_OtherOption"]);
                        if (TypeID == "0" || TypeID == "2")
                        {
                            //var err=SpssDioInterface.spssSetVarName(fh,dr["Q_Field"].ToString(),0);
                            dicQField[QNum] = dr["Q_Field"].ToString();
                            SpssNumericVariable v = new SpssNumericVariable();
                            v.Name = QField;
                            v.Label = QLable;
                            v.ValueLabels.Add(-1, "缺失");
                            v.Alignment = AlignmentCode.SPSS_ALIGN_CENTER;
                            v.MeasurementLevel = MeasurementLevelCode.SPSS_MLVL_RAT;
                            if (TypeID == "2")
                            {
                                v.ValueLabels.Add(0, "错");
                                v.ValueLabels.Add(1, "对");
                            }
                            else
                            {
                                if (!string.IsNullOrEmpty(dr["Q_ValueLable"].ToString()))
                                {
                                    string[] lables = dr["Q_ValueLable"].ToString().Split(',');
                                    for (int i = 1; i <= int.Parse(QOptionsCount); i++)
                                    {
                                        v.ValueLabels.Add(i, lables[i - 1]);
                                    }
                                }
                            }
                            doc.Variables.Add(v);
                        }
                        else if (TypeID == "1")
                        {
                            string[] lables = new string[Convert.ToInt32(QOptionsCount)];
                            if (!string.IsNullOrEmpty(QLable))
                            {
                                lables = QField.Split(',');
                            }
                            for (int i = 1; i <= Convert.ToInt32(QOptionsCount); i++)
                            {
                                //var err = SpssDioInterface.spssSetVarName(fh, string.Format("{0}_{1}", dr["Q_Field"], i), 0);
                                dicQField[QNum + "_" + i.ToString()] = string.Format("{0}_{1}", QField, i);
                                SpssNumericVariable v = new SpssNumericVariable();
                                v.Name = string.Format("{0}_{1}", QField, i);
                                v.Label = lables[i - 1];
                                v.ValueLabels.Add(0, "未选");
                                v.ValueLabels.Add(1, "选中");
                                v.Alignment = AlignmentCode.SPSS_ALIGN_CENTER;
                                v.MeasurementLevel = MeasurementLevelCode.SPSS_MLVL_RAT;
                                doc.Variables.Add(v);
                            }
                        }
                        else
                        {
                            dicQField[QNum] = QField;
                            switch (dr["DataTypeID"].ToString())
                            {
                                case "0":
                                    {
                                        SpssNumericVariable v = new SpssNumericVariable();
                                        v.Name = QField;
                                        v.Label = QLable;
                                        v.ColumnWidth = GetFNumberLength(dataBase);
                                        v.PrintWidth = v.ColumnWidth;
                                        v.PrintDecimal = GetFNumDecimal(dataBase);
                                        v.Alignment = AlignmentCode.SPSS_ALIGN_CENTER;
                                        v.MeasurementLevel = MeasurementLevelCode.SPSS_MLVL_RAT;
                                        doc.Variables.Add(v);
                                    }
                                    break;
                                case "1":
                                    {
                                        SpssStringVariable v = new SpssStringVariable();
                                        v.Name = QField;
                                        v.Label = QLable;
                                        v.Length = GetStringlength(dataBase, "A_FText");
                                        v.ColumnWidth = v.Length;
                                        v.Alignment = AlignmentCode.SPSS_ALIGN_CENTER;
                                        v.MeasurementLevel = MeasurementLevelCode.SPSS_MLVL_NOM;
                                        doc.Variables.Add(v);
                                    }
                                    break;
                                case "2":
                                    {
                                        SpssDateVariable v = new SpssDateVariable();
                                        v.Name = QField;
                                        v.Label = QLable;
                                        v.Alignment = AlignmentCode.SPSS_ALIGN_CENTER;
                                        v.PrintFormat = FormatTypeCode.SPSS_FMT_SDATE;
                                        v.MeasurementLevel = MeasurementLevelCode.SPSS_MLVL_RAT;
                                        doc.Variables.Add(v);
                                    }
                                    break;
                                default:
                                    break;
                            }
                        }
                        if (dr["Q_OtherOption"].ToString() == "1")
                        {
                            //var err = SpssDioInterface.spssSetVarName(fh, dr["Q_Field"].ToString() + "_Other", 1);
                            dicQField[QNum + "_Other"] = QField + "_Other";
                            SpssStringVariable v = new SpssStringVariable();
                            v.Name = QField + "_Other";
                            v.Label = QLable + "(其他选项)";
                            if (TypeID == "0")
                            {
                                v.Length = GetStringlength(dataBase, "A_SingleOther");
                            }
                            if (TypeID == "1")
                            {
                                v.Length = GetStringlength(dataBase, "A_MultiOther");
                            }
                            v.ColumnWidth = v.Length;
                            v.Alignment = AlignmentCode.SPSS_ALIGN_CENTER;
                            v.MeasurementLevel = MeasurementLevelCode.SPSS_MLVL_NOM;
                            doc.Variables.Add(v);
                        }
                    }
                    doc.CommitDictionary();
                    conn.Close();
                }
            }
            #endregion

            #region 输出数据
            using (SQLiteConnection conn = new SQLiteConnection(dataBase))
            {
                using (SQLiteCommand cmd = new SQLiteCommand())
                {
                    cmd.Connection = conn;
                    conn.Open();
                    SQLiteHelper sh = new SQLiteHelper(cmd);
                    //try
                    //{
                    int i = 1;
                    int k = 0;
                    int countRecord = sh.ExecuteScalar<int>("select max(A_Record) from QuestionAnwser");
                    int countQNum = sh.ExecuteScalar<int>("select count(*) from QuestionInfo");
                    DataTable dtData = sh.Select("select * from QuestionAnwser order by A_Record");
                    SpssCase[] cases = new SpssCase[countRecord];
                    for (int m = 0; m < cases.Length; m++)
                    {
                        cases[m] = doc.Cases.New();
                    }
                    foreach (DataRow dr in dtData.Rows)
                    {
                        string QNum = dr["Q_Num"].ToString();
                        switch (dicQType[QNum])
                        {
                            //单选题
                            case 0:
                                {
                                    cases[k][dicQField[QNum]] = int.Parse(dr["A_Single"].ToString());
                                    if (dicOther[QNum] == 1)
                                    {
                                        cases[k][dicQField[QNum + "_Other"]] = dr["A_SingleOther"].ToString();
                                    }
                                }
                                break;
                            //多选题
                            case 1:
                                {
                                    if (!string.IsNullOrEmpty(dr["A_Multi"].ToString()))
                                    {
                                        string[] nums = dr["A_Multi"].ToString().Split('-');
                                        for (int j = 0; j < nums.Length; j++)
                                        {
                                            cases[k][dicQField[QNum + "_" + (j + 1).ToString()]] = int.Parse(nums[j]);
                                        }
                                    }
                                    if (dicOther[QNum] == 1)
                                    {
                                        cases[k][dicQField[QNum + "_Other"]] = dr["A_MultiOther"].ToString();
                                    }
                                }
                                break;
                            //判断题
                            case 2:
                                {
                                    cases[k][dicQField[QNum]] = int.Parse(dr["A_TrueOrFalse"].ToString());
                                }
                                break;
                            //填空题
                            case 3:
                                {
                                    switch (dicDataType[QNum])
                                    {
                                        //数字
                                        case 0:
                                            {
                                                cases[k][dicQField[QNum]] = Decimal.Parse(dr["A_FNumber"].ToString());
                                            }
                                            break;
                                        //文本
                                        case 1:
                                            {
                                                cases[k][dicQField[QNum]] = dr["A_FText"].ToString();
                                            }
                                            break;
                                        //日期
                                        case 2:
                                            {
                                                if (string.IsNullOrEmpty(dr["A_FDateTime"].ToString()) || dr["A_FDateTime"].ToString() == DateTime.MinValue.ToString())
                                                {
                                                    cases[k][dicQField[QNum]] = null;
                                                }
                                                else
                                                {
                                                    cases[k][dicQField[QNum]] = DateTime.Parse(Convert.ToDateTime(dr["A_FDateTime"]).ToString("yyyy/MM/dd"));
                                                }
                                            }
                                            break;
                                        default:
                                            break;
                                    }
                                }
                                break;
                            default:
                                break;
                        }
                        if (i % countQNum == 0)
                        {
                            cases[k].Commit();
                            Progress = (k + 1) * 100.0 / countRecord;
                            ProgressMessage = string.Format("已完成 {0:0.0}%", Progress);
                            k++;
                        }
                        i++;
                    }
                    //for (int l = 0; l < cases.Length; l++)
                    //{
                    //    cases[l].Commit();
                    //}
                    //}
                    //catch (Exception)
                    //{
                    //    throw;
                    //}
                    conn.Close();
                }
                Visibility = "Hidden";
            }
            #endregion
        }
示例#4
0
        public static void ToDataTable(SpssDataDocument doc, DataTable dataTable)
        {
            if (doc == null)
            {
                throw new ArgumentNullException("doc");
            }
            if (dataTable == null)
            {
                throw new ArgumentNullException("dataTable");
            }

            // Build initial DataTable up.
            // Fill in the metadata.
            //set up the columns with the metadata
            foreach (SpssVariable var in doc.Variables)
            {
                string nameOfVar = var.Name;

                //add a column of the variable name to the DataTable
                DataColumn dataColumn = dataTable.Columns.Add(nameOfVar);

                //label of the variable is set in "varlabel" and extracted using var.Label 
                dataColumn.Caption = var.Label;

                //set the type of the column
                if (var is SpssNumericVariable)
                {
                    dataColumn.DataType = typeof(double);
                }
                else if (var is SpssStringVariable)
                {
                    dataColumn.DataType = typeof(string);
                }
                else if (var is SpssDateVariable)
                {
                    dataColumn.DataType = typeof(DateTime);
                }
                else
                {
                    throw new NotSupportedException("Variable " + nameOfVar + " is not a string or a numeric variable type.");
                }
            }//end of extraction of metadata

            //add data into the DataTable
            var values = new object[doc.Variables.Count];
            foreach (SpssCase rowCase in doc.Cases)
            {
                for (int i = 0; i < doc.Variables.Count; i++)
                {
                    values[i] = rowCase[i];
                }
                dataTable.Rows.Add(values);
            }
        }