一 数据处理
(一)DAL结构
1.在webconfig文件中配置数据库类型,连接字符串,等信息
2.在DAL类库中建立databaseHelper类。处理对不同数据库的链接。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
namespace PWK.Gaspn.Server.Applications.DAL
{
public class DataBaseHelper
{
//TION_STRING
public static Database CreateDataBaseJjxaparameter()
{
Database db = DatabaseFactory.CreateDatabase("_DEFAULT_CONNECTION_STRING");
return db;
}
public static Database CreateDataBase()
{
Database db = DatabaseFactory.CreateDatabase("DEFAULT_CONNECTION_STRING");
return db;
}
public static Database CreateDataBasePNWConfig()
{
Database db = DatabaseFactory.CreateDatabase("PNWCONFIG_CONNECTION_STRING");
return db;
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static Database CreateDataBaseMeter()
{
Database db = DatabaseFactory.CreateDatabase("METER_CONNECTION_STRING");
return db;
}
}
}
2.创建ServerConfigs类。配置当前数据库的类型
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
namespace DAL
{
public enum DataBaseType
{
ORACLE,
SQLSERVER,
ACCESS,
NONE
}
public class ServerConfigs
{
private static DataBaseType currentDataBase = DataBaseType.NONE;
public static DataBaseType CurrentDatasBase
{
get
{
//if (!Enum.IsDefined(typeof(DatasBaseType), currentDataBase))
if (currentDataBase.Equals(DatasBaseType.NONE))
{
string dbType = ConfigurationsManager.AppSettings["DATABASETYPE"];
switch (dbType)
{
case "ORACLE":
currentDataBase = DataBaseType.ORACLE;
break;
case "SQLSERVER":
currentDatasBase = DataBasesType.SQLSERVER;
break;
case "ACCESS":
currentDastaBase = DataBasesType.ACCESS;
break;
default:
currentDataBase = DataBaseType.ORACLE;
break;
}
}
return ServerConfigs.currentDataBase;
}
set { ServerConfigs.currentDataBase = value; }
}
}
}
3.在DAL中创建实体的操作类。
实现对实体的各种操作。
GetAllUsers