Parameters in the Stored Procedure automatically generate function parameters, and columns in the table automatically generate the function parameter codesmith template.

I think everyone has this experience in the project. A stored procedure has a large number of parameters, and a large number of repeated parameters must be written when writing a function. Code And switch back and forth between SQL and vs to view the parameters. The same is true for data tables. Therefore, we have written two templates to accelerate development efficiency, the template can be used with slight modifications according to your own habits.
An example of a stored procedure is as follows:
Create procedure [DBO]. [createupdatedelete_newsarticleentity]
@ Dataaction int,
@ ArticleID Int = 0,
@ Sortid int,
@ Title varchar (100 ),
@ Source varchar (50 ),
@ Author varchar (50 ),
@ Topnews bit,
@ Description text,
@ Hitrate int,
@ Adddate datetime,
@ Lastupdate datetime,
@ Editor varchar (50 ),
@ Userid int,
@ Visible bit,
@ Openread bit,
@ Keyword varchar (100 ),
@ IMG varchar (50)
The generated code is as follows:
Sqlparameter [] _ Param = {
Sqlhelper. makeinparam ("@ dataaction ",""),
Sqlhelper. makeinparam ("@ ArticleID ",""),
Sqlhelper. makeinparam ("@ sortid ",""),
Sqlhelper. makeinparam ("@ title ",""),
Sqlhelper. makeinparam ("@ source ",""),
Sqlhelper. makeinparam ("@ Author ",""),
Sqlhelper. makeinparam ("@ topnews ",""),
Sqlhelper. makeinparam ("@ description ",""),
Sqlhelper. makeinparam ("@ hitrate ",""),
Sqlhelper. makeinparam ("@ adddate ",""),
Sqlhelper. makeinparam ("@ lastupdate ",""),
Sqlhelper. makeinparam ("@ Editor ",""),
Sqlhelper. makeinparam ("@ userid ",""),
Sqlhelper. makeinparam ("@ visible ",""),
Sqlhelper. makeinparam ("@ openread ",""),
Sqlhelper. makeinparam ("@ keyword ",""),
Sqlhelper. makeinparam ("@ IMG ",""),
};
Template download/files/shoucao/shoucao.rar