예제 #1
0
        public void LoadUFL()
        {
            db            myDb   = new db();
            SqlDataReader reader = null;

            SqlParameter uflDetailIdParam = new SqlParameter("@UFLDetailId", SqlDbType.Int);

            uflDetailIdParam.Value = UFLDetailId;

            myDb.Connect();

            SqlCommand command = new SqlCommand("SpExcelLoadUFLDetail", myDb.Connection);

            command.CommandType = CommandType.StoredProcedure;



            try
            {
                command.Parameters.Add(uflDetailIdParam);
                reader = command.ExecuteReader();
            }
            catch (Exception e)
            {
                string dummy = e.Message;
            }


            while (reader.Read())
            {
                if (reader["UFLDetailId"].ToString() != "")
                {
                    UFLDetailId = int.Parse(reader["UFLDetailId"].ToString());
                }

                PiTowerName = reader["PiTowerName"].ToString();
                FileMask    = reader["FileMask"].ToString();
                Folder      = reader["Folder"].ToString();
                if (reader["Recursive"].ToString() != String.Empty)
                {
                    Recursive = (bool)reader["Recursive"];
                }
                else
                {
                    Recursive = false;
                }
                if (reader["Encrypted"].ToString() != String.Empty)
                {
                    Encrypted = (bool)reader["Encrypted"];
                }
                else
                {
                    Encrypted = false;
                }

                DataType       = reader["DataType"].ToString();
                Delimiter      = reader["Delimitor"].ToString();
                DateTimeFormat = reader["DateTimeFormat"].ToString();
                DateFormat     = reader["DateFormat"].ToString();
                TimeFormat     = reader["TimeFormat"].ToString();

                if (reader["HeaderMarkerRow"].ToString() != "")
                {
                    HeaderMarkerRow = int.Parse(reader["HeaderMarkerRow"].ToString());
                }

                HeaderAdditionalDetailRows.Clear();



                HeaderAdditionalDetailRows.AddRange((reader["HeaderAdditionalDetail"].ToString()).Split('|'));

                if (reader["PiTagRow"].ToString() != "")
                {
                    PiTagRow = int.Parse(reader["PiTagRow"].ToString());
                }

                PiTagList.Clear();
                PiTagList.AddRange((reader["PiTagList"].ToString()).Split('|'));
            }

            reader.Close();
            myDb.Connection.Close();
        }
예제 #2
0
        public void SaveUFL()
        {
            SqlDataReader reader = null;

            SqlParameter uflDetailIdParam = new SqlParameter("@UFLDetailId", SqlDbType.Int);

            uflDetailIdParam.Value = UFLDetailId;

            SqlParameter piTowerNameParam = new SqlParameter("@PiTowerName", SqlDbType.VarChar, 50);

            piTowerNameParam.Value = PiTowerName;

            SqlParameter fileMaskParam = new SqlParameter("@FileMask", SqlDbType.VarChar, 50);

            fileMaskParam.Value = FileMask;

            SqlParameter folderParam = new SqlParameter("@Folder", SqlDbType.VarChar, 255);

            folderParam.Value = Folder;

            SqlParameter recursiveParam = new SqlParameter("@Recursive", SqlDbType.Bit);

            recursiveParam.Value = Recursive;

            SqlParameter encryptedParam = new SqlParameter("@Encrypted", SqlDbType.Bit);

            encryptedParam.Value = Encrypted;

            SqlParameter dataTypeParam = new SqlParameter("@DataType", SqlDbType.Char, 3);

            dataTypeParam.Value = DataType;

            SqlParameter delimiterParam = new SqlParameter("@Delimitor", SqlDbType.VarChar, 10);

            delimiterParam.Value = Delimiter;

            SqlParameter dateTimeFormatParam = new SqlParameter("@DateTimeFormat", SqlDbType.VarChar, 30);

            dateTimeFormatParam.Value = DateTimeFormat;

            SqlParameter dateFormatParam = new SqlParameter("@DateFormat", SqlDbType.VarChar, 20);

            dateFormatParam.Value = DateFormat;

            SqlParameter timeFormatParam = new SqlParameter("@TimeFormat", SqlDbType.VarChar, 20);

            timeFormatParam.Value = TimeFormat;

            SqlParameter headerMarkerRowParam = new SqlParameter("@HeaderMarkerRow", SqlDbType.Int);

            headerMarkerRowParam.Value = HeaderMarkerRow;

            SqlParameter headerAdditionalDetailParam = new SqlParameter("@HeaderAdditionalDetail", SqlDbType.VarChar, 2000);

            headerAdditionalDetailParam.Value = String.Join("|", HeaderAdditionalDetailRows.ToArray());

            SqlParameter piTagRowParam = new SqlParameter("@PiTagRow", SqlDbType.Int);

            piTagRowParam.Value = PiTagRow;

            SqlParameter piTagListParam = new SqlParameter("@PiTagList", SqlDbType.VarChar, 2000);

            piTagListParam.Value = String.Join("|", PiTagList.ToArray());

            db myDb = new db();

            myDb.Connect();

            SqlCommand command = new SqlCommand("SpExcelSaveUFLDetail", myDb.Connection);

            command.CommandType = CommandType.StoredProcedure;



            try
            {
                command.Parameters.Add(uflDetailIdParam);
                command.Parameters.Add(piTowerNameParam);
                command.Parameters.Add(fileMaskParam);
                command.Parameters.Add(folderParam);
                command.Parameters.Add(recursiveParam);
                command.Parameters.Add(encryptedParam);
                command.Parameters.Add(dataTypeParam);
                command.Parameters.Add(delimiterParam);
                command.Parameters.Add(dateTimeFormatParam);
                command.Parameters.Add(dateFormatParam);
                command.Parameters.Add(timeFormatParam);
                command.Parameters.Add(headerMarkerRowParam);
                command.Parameters.Add(headerAdditionalDetailParam);
                command.Parameters.Add(piTagRowParam);
                command.Parameters.Add(piTagListParam);

                reader = command.ExecuteReader();
            }
            catch (Exception e)
            {
                string dummy = e.Message;
            }


            while (reader.Read())
            {
                if (reader["UFLDetailId"].ToString() != "")
                {
                    UFLDetailId = int.Parse(reader["UFLDetailId"].ToString());
                }
            }

            reader.Close();
            myDb.Connection.Close();
        }