扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
CommonScript.MessageBox("100006",this) ; |
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 ;
}
} |
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;
} |
<?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> |
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 |
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者