博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

ASP.NET中自定义提示对话框

Posted on 2006-09-23 16:48  张明  阅读(660)  评论(0编辑  收藏  举报
1.在需要的地方调用下面的方法:
CommonScript.MessageBox(
"100006",this) ; 
 
2.上面用到的CommonScript类里的MessageBox方法:
public static void MessageBox(string str_ErrCode, Page page)
            

                  IDataReader ErrMsg
= DatabaseAccess.executeDataReader("ImportAndExport","Select ErrMessage from ErrMessage where ErrCode='" + str_ErrCode + "'");
                  
while (ErrMsg.Read())
                  
{
                        String ErrMessage
=ErrMsg["ErrMessage"].ToString();
                        page.RegisterStartupScript(
"","<script>alert('"+ ErrMessage +"');</script>");
                        
break ;
                  }

            }

 
3. 上面用到的DatabaseAccess类里的executeDataReader方法
public static IDataReader executeDataReader(String connectionString, String Sqlstr )
            

                  Database db
= DatabaseFactory.CreateDatabase(connectionString);
                  IDataReader dr;
                  DBCommandWrapper wrap 
= db.GetSqlStringCommandWrapper(Sqlstr);
                  dr
=db.ExecuteReader(wrap);
                  
return dr;
            }

 
4.上面用到的连接串ImportAndExport在dataconfiguration.config里的内容(粗体部分):
<?xmlversion="1.0"encoding="utf-8"?>
<dataConfiguration>
 
<xmlSerializerSectiontype="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null">
    
<enterpriseLibrary.databaseSettingsxmlns:xsd="http://www.w3.org/2001/XMLSchema"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"defaultInstance="ImportAndExport"xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">
      
<databaseTypes>
        
<databaseTypename="Oracle Database"type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null"/>
        
<databaseTypename="Sql Database"type="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null"/>
      
</databaseTypes>
      
<instances>
        
<instancename="EA21SG3T"type="Oracle Database"connectionString="EA21SG3T"/>
        
<instancename="ImportAndExport"type="Sql Database"connectionString="ImportAndExport"/>
        
<instancename="Sql Instance"type="Sql Database"connectionString="Sql Connection String"/>
      
</instances>
      
<connectionStrings>
        
<connectionStringname="ImportAndExport">
          
<parameters>
            
<parametername="data source"value="192.168.1.59"isSensitive="false"/>
            
<parametername="database"value="ImportAndExport"isSensitive="false"/>
            
<parametername="pwd"value="sa"isSensitive="false"/>
            
<parametername="uid"value="sa"isSensitive="false"/>
          
</parameters>
        
</connectionString>
        
<connectionStringxsi:type="OracleConnectionStringData"name="EA21SG3T">
          
<parameters>
            
<parametername="data source"value="EA21SG3T"isSensitive="false"/>
            
<parametername="Password"value="developer"isSensitive="false"/>
            
<parametername="User Id"value="developer"isSensitive="false"/>
          
</parameters>
          
<packages/>
        
</connectionString>
        
<connectionStringname="Sql Connection String">
          
<parameters>
            
<parametername="data source"value="192.168.1.59"isSensitive="false"/>
            
<parametername="database"value="ImportAndExport"isSensitive="false"/>
            
<parametername="pwd"value="sa"isSensitive="false"/>
            
<parametername="uid"value="sa"isSensitive="false"/>
          
</parameters>
        
</connectionString>
      
</connectionStrings>
    
</enterpriseLibrary.databaseSettings>
 
</xmlSerializerSection>
</dataConfiguration>
 
5.数据库:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ErrMessage]') and OBJECTPROPERTY(id, N'IsUserTable'= 1)
drop table [dbo].[ErrMessage]
GO
 
CREATE TABLE [dbo].[ErrMessage] (
      [ErrID] [
int] NOT NULL ,
      [ErrCode] [varchar] (
50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
      [ErrModul] [varchar] (
50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [ErrSubModul] [varchar] (
50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [ErrMessage] [nvarchar] (
200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO