调用DataAccess可如下代码:
public bool Create(String name,String shortName,Int32 universityId,String code)
{
SqlParameter[] prams = {
Database.MakeInParam("@Name",System.Data.SqlDbType.VarChar,60,name),
Database.MakeInParam("@ShortName",System.Data.SqlDbType.VarChar,30,shortName),
Database.MakeInParam("@UniversityId",System.Data.SqlDbType.Int,4,universityId),
Database.MakeInParam("@Code",System.Data.SqlDbType.VarChar,30,code)
};
int reval = Database.RunProc("BSCollege_Create",prams);
if(reval != -1)
{
return true;
}
else
{
return false;
}
}
如果需要缓存支持,则采用如下调用方法:
public void SelectSubNodes(int universityId,int codeLength,String code,out OfficiateCollection list)
{
SqlDataReader reader = null;
list = new OfficiateCollection();
SqlParameter[] prams;
if(ParamsCache.GetCachedParameterSet(Database.ConnectionString,"BSOfficiate_SelectSubNodes",out prams))
{
Database.AssignParameterValues(prams,universityId,codeLength,code);
}
else
{
prams = new SqlParameter[3]{
Database.MakeInParam("@UniversityId",System.Data.SqlDbType.Int,4,universityId),
Database.MakeInParam("@CodeLength",System.Data.SqlDbType.Int,4,codeLength),
Database.MakeInParam("@Code",System.Data.SqlDbType.VarChar,300,code)
};
ParamsCache.CacheParameterSet(Database.ConnectionString,"BSOfficiate_SelectSubNodes",prams);
}
Database.RunProc("BSOfficiate_SelectSubNodes",prams,out reader);
while(reader.Read())
{
OfficiateInfo officiateInfo = new OfficiateInfo();
officiateInfo.ID = Int32.Parse(reader["ID"].ToString());
officiateInfo.Name = reader["Name"].ToString();
officiateInfo.Code = reader["Code"].ToString();
officiateInfo.Ordinal = Int32.Parse(reader["Ordinal"].ToString());
list.Add(officiateInfo);
}
reader.Close();
}
基于这个Data Access ,我们的新版 CodePlus 代码生成器 即可自动生成以上的调用代码。有关CodePlus新版详情可以在这里找到:
http://blog.csdn.net/wintle/archive/2004/08/09/68851.aspx
对于这个DataAccess,各位如果有什么好的建议,请告诉我,谢谢。