CN101419628A - Data general-purpose leading-in method based on excel file format - Google Patents

Abstract

The invention provides a general data importing method based on an Excel file format, which comprises the following steps: the database is adopted to save a data format definition, the data format definition is uploaded into a web server through a browser and then returned to the front end of the browser through a tabbed way; after the data matching relations are determined through artificial modification, the server verifies the data and returns the verified data, and the data is imported into an appointed form in the database after no abnormal data is determined to exist, and finally, the background business rule verification and treatment of the data are carried out through definable database storage process after the data is imported.

Description

A kind of data general-purpose leading-in method based on the Excel file layout

Technical field

The present invention relates to a kind of Computer Applied Technology, use, can efficiently carry out a technology of business datum typing rapidly, and can utilize general Excel file to carry out the off-line data processing and sorting towards amateur or professional technique terminal operation personnel.

Background technology

At present in the day to day operation of enterprise, needing to collect all kinds of marketing data diseases will be entered in the management system, this class data volume is general bigger, data acquisition cycle is shorter, the mobile work of business personnel is comparatively frequent, so system need provide the data importing function when data W EB input function is provided, to alleviate operating personnel's data typing pressure, carry out off-line data add mode scatter operation personnel's data typing pressure by the Excel file.

Summary of the invention

The objective of the invention is to break through traditional hard coded mode, a kind of general-purpose service data introduction method is provided.

Of the present invention day realize in the following manner, utilize the information description of data hold function realization to the business paper field, upload to Web server putting ground Excel file in order earlier, backstage assembly Excel file on the Web server is saved in the temporary table of database, and returns to browser.The user carries out fields match in the field description information of browser section according to business paper with the data of reality.Submit to the back data to be handled according to the information of coupling by the web server and imported in the corresponding database table by business rule.

Of the present invention have function and a beneficial effect

1. solved the manual typing problem of business paper big data quantity.

2. flexible by the configuration information of database definition obligation document.

3. unique identification and the definable database store process by importing can be made unified business rule to the data that import and handle, and adaptability is strong.

Description of drawings

Fig. 1 is Fig. 1-1 business paper static class figure.

Embodiment

Business paper defined function in the treasure case that provides by system can increase the modification business paper.By the descriptor to business paper, system provides the data importing function of acquiescence.

The data importing function TeledataInport.aspx of system default? BILLID=010, wherein BILLID represents the ID of business paper, can increase and use this function easily by the invoke user to this address.

The main program assembly:

The main functional based method of the TeleDataInport of data importing

public?static?string?GetFileName(string?sPath)

public?static?DataSet?ExcelToDS(string?Path)

public?static?DataSet?ExcelToDS(string?Path，int?pSheetIndex)

public?static?string?GenerateBillNo(string?sLogicTName，string?s_bh，stringsDate，string?flag，string?DJBH，Database?MyDatabase)

The data importing procedure function:

private?void?btnInport_Click(object?sender，System.EventArgs?e)

{ // variable-definition

try

{ // start-of-record time dt1

Whether the inspection of // misdata surpasses the misdata bar number of system's regulation

// obtain the document object

The inspection of // data permission

The correctness of // verifying logic data

The SQL field information that // extraction is inserted

ArrayList inserSQL=new ArrayList (); // insertion SQL

// judge whether data-frozen

// initial statement the information of inserting

// record imports pre-treatment time dt2

Try

{

// obtain the data after the checking

vssql=″select*from″……；

reader=data.RunSqlReturndR(vssql)；

while(reader.Read())

{ // insert gauge outfit information // insertion table body information }

reader.Close()；}

catch(Exception?ex)

{ // fault processing }

// record import statement generates processing time dt3

// data importing database

try

{for(int?i=0；i<inserSQL.Count；i++)

{ // carry out data parenthesis sentence }

if(MyBill0bject.DREXECUT.Trim()!=″″)

{ // carry out storing process manage business logic }

}

catch(Exception?ex)

{ // fault processing }

// record imports database time dt4

Prompting of // data importing quantity and time prompting

}

catch(Exception?ex)

{ // fault processing }

finally

{ // close data connect }

}。

Claims (1)

1. data general-purpose leading-in method based on the Excel file layout, it is characterized in that, be to adopt the data database storing formal definition, after uploading to the web server by browser, mode by paging turns back to the browser front end, after confirming Data Matching relation by the manual amendment, server is verified data, and return data after the checking, confirming not have behind the abnormal data can be in the table of data importing appointment in the database again, by definable database store process, data are carried out the business rule checking and the processing on backstage after importing, the data importing treatment step is as follows:

// start-of-record time dt1

Whether the inspection of // misdata surpasses the misdata bar number of system's regulation

// obtain the document object

The inspection of // data permission

The correctness of // verifying logic data

The SQL field information that // extraction is inserted

ArrayList inserSQL=new ArrayLi st (); // insertion SQL

// judge whether data-frozen

// initial statement the information of inserting

// record imports pre-treatment time dt2

try

Data after { // the obtain checking

vssql＝″select*from″……；

reader＝data.RunSqlReturndR(vssql)；

while(reader.Read())

{ // insert gauge outfit information // insertion table body information }

reader.Close()；

}

catch(Exception?ex)

{ // fault processing }

// record import statement generates processing time dt3

// data importing database

try

{ for(int?i＝0；i<inserSQL.Count；i++)

{ // carry out data parenthesis sentence }

if(MyBi?llObject.DREXECUT.Trim()！＝″″)

{ // carry out storing process manage business logic }

}

catch(Exception?ex)

{ // fault processing }

// record imports database time dt4

Prompting of // data importing quantity and time prompting.

Images