CYQ. Data. ProjectTool project configuration tool released (package source code)

Preface:

I have been reminded by netizens to update CYQ. data enumeration generator. This tool has not released any new version since V4.5. In fact, I have also written an enumeration generator of V4.55, which is not satisfactory to the subject, it hasn't changed much, so it hasn't been released.

Let's take a look at the enumeration Generator interface of V4.55, which looks a little better than V4.5, but is not satisfied yet, and it is still inconvenient to use.

 

Improvements to the concept of use:

Since I have been tossing weibo fan genie software for nearly two years, I have gained a better understanding of the software, and I feel that it is inconvenient to use. How can I use it for users, although there are new versions, they are not released.

 

Idea of VS plug-in:

I used to write the Addin plug-in to integrate it into the VS development environment. However, due to many issues, I failed to write it down, so I did not write it.

Due to the high speed of the netizens, I started to write the Addin plug-in yesterday. I am going to get a demo and look at the basic process of Addin. After reading a few tutorials on the Internet, it is extremely simple, the one that reports an error when running the command.

After several tests, I found that the Bug was caused by the English version of the default code in the Chinese language environment. after hard work, I can also generate a menu and click it to get something out.

 

An external tool is found ":

However, it seems uncomfortable to use Addin for development. The tool menu is too many and you are aware of an "external tool:

 

Click it out:

 

The tool can also be integrated through simple configuration. After confirmation, the "CYQ. Data project configuration" menu is displayed from the previous image.

 

Compare Addin with external tools:

Addin: it can obtain some internal information of the VS environment, including open documents, document class members, and so on, if you want to develop some projects in VS solution, such as adding a header comment to all documents, you can do this.

External tools: they are relatively independent. They can be developed independently by just introducing a link. After they are completed, you can add an external tool for integration. This is suitable for tossing things that have nothing to do with VS internal environment variables, for example, CYQ. data project configuration tool.

 

Confirm the use of external tools:

I don't need to deal with the VS environment too much, so the external tool is just like this. Since it can be developed independently, it is based on the idea of making it easy to use, I gave up the idea of re-developing on the original enumeration generation tool and wrote another one. It took me one day and one night to write this configuration tool.

 

The following figure shows the CYQ. Data. ProjectTool Configuration tool:

 

 

Sample CS code for a table generated by the ORM mode:

Namespace Web. Entity. Demo
{
Public class MyUsers: CYQ. Data. Orm. OrmBase
{
Public MyUsers ()
{
Base. SetInit (this, "MyUsers", "DefaultConn2 ");
}
Private Int32 _ ID;
Public Int32 _ ID
{
Get
{
Return _ ID;
}
Set
{
_ ID = value;
}
}
Private String _ UserName;
Public String _ UserName
{
Get
{
Return _ UserName;
}
Set
{
_ UserName = value;
}
}
Private DateTime _ CreateTime;
Public DateTime _ CreateTime
{
Get
{
Return _ CreateTime;
}
Set
{
_ CreateTime = value;
}
}
}
}

 

Relative improvements to the CYQ. Data project configuration tool:

In this enumeration evolution to the configuration tool, we mainly made some subtraction improvements.

1: view generation and stored procedure enumeration are no longer supported (considering that the usage is not high and it is not convenient to shift values in different databases ).

2: cancel the "generate paging stored procedure" and "generate log table" items in one-time configuration, and improve the function to automatically generate the log table in CYQ. Data V5 according to the actual situation.

3: encoding mode. In addition to Enumeration type, it also supports one more Orm mode.

4: For the enumeration encoding method, a cs file is generated. for the orm mode, each table generates a corresponding entity class (table name. cs)

5: All configurations are automatically saved, and the latest configuration changes are archived as the default configuration to facilitate the next change.

 

Through this improvement, the integration of external tools makes it quite convenient to use. Click Open and then click "generate file" to update the field changes to the data.

 

Download tool:

To facilitate special changes, the configuration tool provides source code download.

: Http://www.cyqdata.com/download/article-detail-426

 

PS: The Configuration tool CYQ. Data. ProjectTool is packaged in the CYQ. Data V5 framework to provide download. the source code of the Configuration tool is provided independently.