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();
}
