mysql 模板 存储_动软MySQL存储过程模板

TableHost host = (TableHost)(Host);

host.Fieldlist.Sort(CodeCommon.CompareByintOrder);

int columnCount=host.Fieldlist.Count;

string IdentityStr="id";

string specStr="datetime";

foreach (ColumnInfo c in host.Fieldlist)

{

if(c.IsIdentity)

{

IdentityStr=c.ColumnName.ToString().ToLower();

break;

}

}

#>

DROP procedure IF EXISTS _GetMaxId;

CREATE PROCEDURE _GetMaxId()

BEGIN

SELECT MAX(Id) FROM ;

END;

DROP procedure IF EXISTS _Exists;

CREATE PROCEDURE _Exists

($_Id int)

BEGIN

SELECT count(1) FROM WHERE Id=$_Id ;

END;

DROP procedure IF EXISTS _ADD;

CREATE PROCEDURE _ADD(

{ if(c.IsIdentity) { #>OUT $_ (),$_ $_ (),)

BEGIN

INSERT INTO (

{ if(c.IsIdentity) { updateI++;continue;} #>,

)VALUES(

{ if(c.IsIdentity) { updateI++;continue;} #>

$_,

);

set $_=last_insert_id();

END;

DROP procedure IF EXISTS _Update;

CREATE PROCEDURE _Update(

{ #>

$_

$_ ()

,

)

BEGIN

UPDATE SET

{ if(c.IsIdentity) { updateI++;continue;}#>

=$_,

WHERE Id=$_Id ;

END;

DROP procedure IF EXISTS _Delete;

CREATE PROCEDURE _Delete(

$_Id int)

BEGIN

DELETE from

WHERE Id=$_Id ;

END;

DROP procedure IF EXISTS _GetModel;

CREATE PROCEDURE _GetModel(

$_Id int)

BEGIN

SELECT

{ #>

,

FROM

WHERE Id=$_Id ;

END;

DROP procedure IF EXISTS _GetColumnInfo;

CREATE PROCEDURE _GetColumnInfo(

$_Id int,

$_ColumnName varchar(20))

BEGIN

set @sqlStr=CONCAT('SELECT ',$_ColumnName , ' FROM WHERE Id= ',$_Id);

PREPARE count_stmt FROM @sqlStr;

EXECUTE count_stmt;

END;

DROP procedure IF EXISTS _GetList;

CREATE PROCEDURE _GetList()

BEGIN

SELECT

{ #>

,

FROM ;

END;