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