时间: 2021-07-31 作者:daque
dataaccess:public interface dataaccess { #region support property & method databasetype databasetype{get;} idbconnection dbconnection{get;} persistencemanager persistencemanager{get;} idbtransaction begintransaction(); void open(); void close(); bool isclosed{get;} #endregion #region executenonquery int executenonquery(commandtype commandtype, string commandtext); int executenonquery(string commandtext); int executenonquery(string commandtext, queryparametercollection commandparameters); int executenonquery(commandtype commandtype, string commandtext, queryparametercollection commandparameters); #endregion executenonquery #region executedataset dataset executedataset(commandtype commandtype, string commandtext); dataset executedataset(string commandtext); dataset executedataset(commandtype commandtype, string commandtext, queryparametercollection commandparameters); dataset executedataset(string commandtext, queryparametercollection commandparameters); dataset executedataset(commandtype commandtype, string commandtext,string tablename); dataset executedataset(string commandtext,string tablename); dataset executedataset(commandtype commandtype, string commandtext, queryparametercollection commandparameters,string tablename); dataset executedataset(string commandtext, queryparametercollection commandparameters,string tablename); dataset executedataset(commandtype commandtype, string commandtext,dataset ds); dataset executedataset(string commandtext,dataset ds); dataset executedataset(commandtype commandtype, string commandtext, queryparametercollection commandparameters,dataset ds); dataset executedataset(string commandtext, queryparametercollection commandparameters,dataset ds); dataset executedataset(commandtype commandtype, string commandtext,dataset ds,string tablename); dataset executedataset(string commandtext,dataset ds,string tablename); dataset executedataset(commandtype commandtype, string commandtext, queryparametercollection commandparameters,dataset ds,string tablename); dataset executedataset(string commandtext, queryparametercollection commandparameters,dataset ds,string tablename); #endregion executedataset #region executereader idatareader executereader(commandtype commandtype, string commandtext); idatareader executereader(string commandtext); idatareader executereader(commandtype commandtype, string commandtext, queryparametercollection commandparameters); idatareader executereader(string commandtext, queryparametercollection commandparameters); #endregion executereader #region executescalar object executescalar(commandtype commandtype, string commandtext); object executescalar(string commandtext); object executescalar(commandtype commandtype, string commandtext, queryparametercollection commandparameters); object executescalar(string commandtext, queryparametercollection commandparameters); #endregion executescalar #region executexmlreader xmlreader executexmlreader(commandtype commandtype, string commandtext); xmlreader executexmlreader(string commandtext); xmlreader executexmlreader(commandtype commandtype, string commandtext, queryparametercollection commandparameters); xmlreader executexmlreader(string commandtext, queryparametercollection commandparameters); #endregion executexmlreader } 附2:运用websharp中央件开拓的demo