| 메소드 | 설명 | |
|---|---|---|
| CreateLogFiles ( ) : string |
create and set the Name of the log file.
|
|
| ErrorLog ( string sPathName, string sErrMsg ) : int |
Error Log
|
|
| Form1 ( ) : System | ||
| GetOperatorID ( string OperatorName ) : int |
it validate the database credential and get the operator ID. It makes an entry to Error log in case of any error.
|
|
| OperatorID ( string operatorName ) : int | ||
|
RemoveColumn ( string fname ) : |
||
| SaveParsedRecord ( string file ) : bool |
It call the store procedue "s_AddBvDSubsidiary" and save the parsed record into the database. It make an entry into the Success log in case of success and also make an enty to error log in case of any error.
|
|
| SuccessLog ( string SuccessFile ) : void |
It create a success log in the specified directory and write the entries into success log accoringly if file is successfully imported into the database. It also move successfully moved Files to Archieve Directoy.
|
|
| directorySelection ( ) : void |
This function select the directory of Patent Excell files and shows the number of files. In case of any error it writes the error in the Error log and skip that file and if file is successfully imported then it make an entry to the successlog accordingly.
|
|
|
excelSaveinArray ( string filename ) : |
||
|
parserResult ( string f ) : |
| 메소드 | 설명 | |
|---|---|---|
| Dispose ( bool disposing ) : void |
Clean up any resources being used.
|
| 메소드 | 설명 | |
|---|---|---|
| CheckHeadersAndValidateData ( string f ) : int | ||
| Form1_Load ( object sender, EventArgs e ) : void |
This is the starging point of the EXGovt.Dataportals Excel 2 sql parser!
|
|
| Import_To_Grid ( string FilePath, string Extension, string isHDR ) : void | ||
| InitializeComponent ( ) : void |
Required method for Designer support - do not modify the contents of this method with the code editor.
|
|
| btnCheckConnection_Click ( object sender, EventArgs e ) : void | ||
| btnSaveRecord_Click ( object sender, EventArgs e ) : void |
It save the parsed Record into the database
|
|
| btnSelectDirectory_Click ( object sender, EventArgs e ) : void |
It check the connection before browsing the directoy. if connection or its credential is ok then open file browser dialog to brows the directory of Patent files.
|
|
| btnShowResult_Click ( object sender, EventArgs e ) : void |
this is parse file button. That check the file before parsing it and then parse that files if there is no error in column and data validation of File. it also shows the parsed record into a gridview.
|
|
| button1_Click ( object sender, EventArgs e ) : void | ||
| checkConnection ( ) : int |
This function check the connection and validate credentials.It also call a function to get the operator id
|
|
| groupBox1_Enter ( object sender, EventArgs e ) : void | ||
| rdbtnFile_CheckedChanged ( object sender, EventArgs e ) : void |
| protected Dispose ( bool disposing ) : void | ||
| disposing | bool | true if managed resources should be disposed; otherwise, false. |
| 리턴 | void | |
| public ErrorLog ( string sPathName, string sErrMsg ) : int | ||
| sPathName | string | |
| sErrMsg | string | |
| 리턴 | int | |
| public GetOperatorID ( string OperatorName ) : int | ||
| OperatorName | string | |
| 리턴 | int | |
|
public RemoveColumn ( string fname ) : |
||
| fname | string | |
| 리턴 | ||
|
public excelSaveinArray ( string filename ) : |
||
| filename | string | |
| 리턴 | ||
|
public parserResult ( string f ) : |
||
| f | string | |
| 리턴 | ||