CYQ. Data framework V3.5 open-source version released (source code for download)

 Let's say a few words: 

 

Recently, I have been busy with Weibo's fan genie + Weibo's popular Weibo genie series software. Simply put, it is Sina Weibo's marketing service that provides various services based on Sina Weibo.
At the same time, I am also looking for online (Weibo) marketing talents to cooperate and start a business. If you are interested, please ask me.
I Weibo address Signature should have, here also mention: http://www.weibo.com/cyqdata

 

Preface:

 

Recently I found that many people have studied the CYQ. Data framework. Although I haven't pushed this framework any more over the past year, I feel that users just like to accumulate more and take a longer time.
Due to the open-source version of V3.0, there may be a small Bug in date-type processing in Access. Although there are source code, some people have asked about it.

In addition, due to my recent absence of the main business framework and time constraints, I seldom wrote articles, so I didn't have much effort to push. I am sorry for the few articles I have written in a year.

 

Due to the influence of some framework researchers, the source code of V3.5 is released and the update records are as follows:

 

Download:

 

CYQ. Data framework V3.5 Source: http://www.cyqdata.com/download/article-detail-426

Update record 

 

V1.3 started
Records from:
1: MAction: automatically calls Close () When Update/Insert/Fill fails ()
2: MAction: added the ResetTable function.
3: MAction: Modify the Fill method: if there are multiple records, return failure. Change to return the first record.
4: OutPutData: Add ExeCreateProc to directly execute the paging storage process.

Records from:
1: MAction: returned result of closed DataSQLHelper
2: MAction: added SetAutoPrefix. Multiple Control prefixes can be uploaded.
3: MAction: The Insert/Update method enables Auto to obtain values.
4: MProce: New Production Class used to execute the Stored Procedure
5: OutPutData: new export of Stored Procedure Enumeration

V1.4 started
Records from:
1: MProc: Modify the ExeScalar Method to the generic method public T ExeScalar <T> ()
2: SQLString: The where condition filters out the "--" comment and ";" Semicolon

Records from 2010-08-23:
1: SQLHelper, DataType, and Log modify the access modifier, which is not open to the outside world.
2: MProc: the modification of access modification by SQLHelper is not open to the outside world, and the inheritance is changed to the built-in class.
3: MProc: Change the returned DataTable to MDataTable to hide the returned SqlDataReader.
4: MDataTable: added the ToDataTable function.

Records from:
1: DataType: the conversion methods for merging data types are GetDbType and GetSqlType, and other additional methods are commented out.
2: Log: Modify the return type of WriteLog to void. An exception is thrown when an exception Log fails to be written to the database.
3: SQLHelper: optimize code and delete useless Methods
4: MAction: adds intelligent detection. The constructor does not need to input database configuration items. For multi-database applications, the rule enumeration is [[U/V/P] _ + database name + Enum], and the configuration file database link configuration item is [database name + Conn].
5: CacheHelper: optimizes the code and reduces the number of lines of code.
6: OutPutData: added the export of multi-database projects, and modified the enumeration export of tables and views to [[U/V/P] _ database name + Enum] format.
7: SQLHelper: added transaction support
8: MAction: by default, transaction support is enabled for all operations until the transaction ends when Close () or EndTransation () is called or an exception occurs.

Records from:
1: CacheHelper: modified several function names.
2: MProc: modify several method names and automatically add the "@" prefix to the parameters.
3: OutPutData: added export of stored procedure parameters
4: add all comments and sample generate documents

Records from:
1: OutPutData: added the log table generation method.

V1.5 started

Records from:
1: MDataTable: optimizes data binding, improving the speed.
2: SQLOutPut: corrected the generation of enumeration and log tables in the SQL 2000 database.
3: DataType: The GetSqlType method adds the ntext type conversion. If you modify the conversion method, the default return value is SqlDbType. NVarChar.

Records from 2010-09-04:
4: added support for Guid-type IDs.
5: MProc added support for SQL statements
6: OutPutData: optimizes the code and deletes unused functions.

Records from 2010-09-05:
7: MDataTable: Correction ToDataTable Method

Records from 2010-09-06:
8: MAction: added support for GetFrom and SetTo in Winform
9: MActionUI: new classes are separated from MAction.

Records from 2010-09-07:
Records from 2010-09-08:
10: MDataTable: supports binding the Winform DataGridView control.

V1.6-V2.0 version to support multi-database version of the major changes
Records from 2010-09-09:
1: added support for Access databases.
Records from:
2: SQLString: FormatWhere is not formatted to lowercase
3: Maction: optimizes the code for accessing database operations
4: OutPutData: re-adjust the internal code, add Access support, and remove the output enumeration description.
5: The auxiliary tool V1.6 was born to support the generation of Access enumeration.
Records from:
6: DbBase: the return value of a stored procedure cannot be a name index or a digital index.
7: MDataColumn: add and delete columns.
8: MDataTable: Modify the constructor
Records from:
9: OutPutData database 2000 output shielding system-provided [tables/views/stored procedures]

Records from:
10: Add parameters for SQL2000 parameter execution.
11: SQL2000 paging Stored Procedure correction.
12: corrected the use of transactions in SQL2000.
Records from:
13: added Aop to separate permissions, operation logs, exceptions, and other independent processes.
Records from:
14: MDataTable fixed index unreset errors when multiple bindings
Records from:
15: The Dynamic Loading Function is added to Aop. The configuration file is required: <add key = "Aop" value = "assembly name, namespace. Aop class name"/>
Records from 2010-09-27:
16: added support for Oracle, and added and deleted updates.
Records from:
17: Compile the paging stored procedure and call it. You can also use the enumeration export function to create a log table.

Records from:
18: Create a log table.
19: auxiliary tools are implemented.

Records from:
20: Bind method added to MDataTable
21: added ToJson output for MDataTable
22: added the JsonHelper class.

V3.0 starts
Records from:
1: add the Bind method to MAction.
2: corrected the MAction Debug attribute [Close is automatically called upon failure, and DbBase error information cannot be obtained for the attribute]
3: added the IDisponse interface implementation for MProc.
Records from:
4: MAction: Aop modifies Fill to return the id value

Records from:
Added Xml-related operation classes:
XmlBase
XmlHelper
XhtmlurlResolver
MutilLanguage
HtmlTagType

Records from:
1: MAction: Add _ DataSqlHelper. ClearParameters () for Insert/Update/Delete/Fill/GetCount ();
2: added an Orm base class.
3: added the ToList <T> generic method to the MDataTable.
4: DbBase adds the transaction shutdown Mechanism
5: OrmBase does not enable transactions by default.
Records from:
6: MAction: when the transaction is closed, the link is not automatically closed when the default operation fails.

Records from:
6: MAction: fixed the error caused by ResetTable/Fill not rewriting the table name.

Records from->:
1: AppConfig is added to facilitate viewing all configuration file items [except for the default database connection Conn]
2: added [# true] and [# false] Replace in FormatWhere, supporting multi-database applications.
3: Modify the Return Statement of the table structure and process the uniqueidentifier, ntext, and text types.
4: Access type operation. transactions are disabled by default.
5: Access Data Type DateTime type parameters are processed as Date type.
6. DalAction format the Access database link.
7: Add method of cache class adds cache dependent file path and time input.
8: add custom tags for the cache class [whether the cache is modified or not]
9: added processing for the Image type.
10: An error occurred while querying the table name of the Access custom statement.

Description of all configuration items:
Default database link:
<Add name = "Conn" connectionString = "server =.; database = Chat; uid = sa; pwd = 123456"/>
Default exception log database link:
<Add name = "LogConn" connectionString = "Conn"/>
Whether the exception log is Enabled:
<Add key = "IsWriteLog" value = "true"/>
Enable custom Aop?
<Add key = "Aop" value = "CYQ. Data. Test, CYQ. Data. Test. MyAop"/>
Oracle Auto-incrementing sequence name. The default built-in name is "AutoID ".

<Add key = "AutoID" value = "MyAutoID"/>

I don't want to talk about anything else. I'm interested in personal occasions, but I'm not interested in them. If I have something to say, leave a shadow. If I want to pass by, I will buy soy sauce, do not shake the recommended hand, or be soft if you want to oppose it!

 

In the end, I wish everyone a step-by-step increase in technology, with different salaries every year.