예제 #1
0
        public static void LoadDB(DataTable dt)
        {
            string text1 = Environment.CurrentDirectory + @"\Data\" + dt.TableName + ".csv";

            dt.BeginLoadData();
            try
            {
                dt.Rows.Clear();
                if (dt.TableName == "Folder")
                {
                    object[] objArray1 = new object[5];
                    objArray1[1] = 0;
                    objArray1[2] = "All";
                    objArray1[3] = DateTime.Now;
                    objArray1[4] = 1;
                    dt.Rows.Add(objArray1);
                    object[] objArray2 = new object[5];
                    objArray2[1] = 0;
                    objArray2[2] = "Scan";
                    objArray2[3] = DateTime.Now;
                    objArray2[4] = 1;
                    dt.Rows.Add(objArray2);
                    object[] objArray3 = new object[5];
                    objArray3[1] = 0;
                    objArray3[2] = "Exchange";
                    objArray3[3] = DateTime.Now;
                    objArray3[4] = 1;
                    dt.Rows.Add(objArray3);
                    object[] objArray4 = new object[5];
                    objArray4[1] = 0;
                    objArray4[2] = "Favorite";
                    objArray4[3] = DateTime.Now;
                    objArray4[4] = 1;
                    dt.Rows.Add(objArray4);
                    object[] objArray5 = new object[5];
                    objArray5[1] = 0;
                    objArray5[2] = "Industry";
                    objArray5[3] = DateTime.Now;
                    objArray5[4] = 1;
                    dt.Rows.Add(objArray5);
                    object[] objArray6 = new object[5];
                    objArray6[1] = 0;
                    objArray6[2] = "Reserved";
                    objArray6[3] = DateTime.Now;
                    objArray6[4] = 0;
                    dt.Rows.Add(objArray6);
                    object[] objArray7 = new object[5];
                    objArray7[1] = 0;
                    objArray7[2] = "Reserved";
                    objArray7[3] = DateTime.Now;
                    objArray7[4] = 0;
                    dt.Rows.Add(objArray7);
                    object[] objArray8 = new object[5];
                    objArray8[1] = 0;
                    objArray8[2] = "Reserved";
                    objArray8[3] = DateTime.Now;
                    objArray8[4] = 0;
                    dt.Rows.Add(objArray8);
                    object[] objArray9 = new object[5];
                    objArray9[1] = 0;
                    objArray9[2] = "Reserved";
                    objArray9[3] = DateTime.Now;
                    objArray9[4] = 0;
                    dt.Rows.Add(objArray9);
                    object[] objArray10 = new object[5];
                    objArray10[1] = 0;
                    objArray10[2] = "Reserved";
                    objArray10[3] = DateTime.Now;
                    objArray10[4] = 0;
                    dt.Rows.Add(objArray10);
                }
                if (!File.Exists(text1))
                {
                    return;
                }
                StreamReader reader1 = File.OpenText(text1);
                try
                {
                    string text2    = reader1.ReadLine();
                    char[] chArray1 = new char[1] {
                        ','
                    };
                    string[] textArray1 = text2.Trim().Split(chArray1);
                    int      num1       = dt.Rows.Count;
                    text2 = string.Empty;
                    if (num1 > 0)
                    {
                        while (num1-- > 0)
                        {
                            if ((text2 = reader1.ReadLine()) == null)
                            {
                                break;
                            }
                        }
                    }
                    while (!string.IsNullOrEmpty(text2 = reader1.ReadLine()))
                    {
                        string[] textArray2 = StockDB.DecodeCSV(text2);
                        DataRow  row1       = dt.NewRow();
                        for (int num2 = 0; (num2 < textArray1.Length) && (num2 < textArray2.Length); num2++)
                        {
                            if (textArray2[num2] != "")
                            {
                                try
                                {
                                    row1[textArray1[num2]] = textArray2[num2];
                                }
                                catch
                                {
                                }
                            }
                        }
                        if (!row1.IsNull(dt.PrimaryKey[0]))
                        {
                            dt.Rows.Add(row1);
                        }
                    }
                }
                finally
                {
                    reader1.Close();
                }
            }
            finally
            {
                dt.EndLoadData();
            }
        }