最新修改：DAL层支持MySQL/MsSQL/Oracle三种数据库|C/S框架网

最新修改：DAL层支持MySQL/MsSQL/Oracle三种数据库

作者:C/S框架网|www.csframewo 发布日期:2021/12/29 13:59:01

最新修改：DAL层支持MySQL/MsSQL/Oracle三种数据库

dalBase类定义：

C# Code:

/// <summary>
/// 数据访问层基类定义
/// </summary>
public class dalBase
{

protected IDatabase _Database;

/// <summary>
/// 建立连接的数据库（预设为当前账套对应的数据库）
/// </summary>
public IDatabase Database { get { return _Database; } set { _Database = value; } }
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

IDatabase接口使用方法1：

C# Code:

public DataTable GetData(string DBID)
{
IDatabase db = DatabaseProvider.GetDatabase(DBID);
string sql = "SELECT * FROM sys_DocNoRule ORDER BY DocCode; ";
CommandHelper cmd = db.CreateCommand(sql);
return db.GetTable(cmd.Command, sys_DocNoRule.__TableName);
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

IDatabase接口使用方法2：

C# Code:

public string ExistsConfig(string systemID, string programID, string configName, string applyType, string IDs)
{
CommandHelper sp = _Database.CreateSqlProc("usp_ValidateFormConfig");
sp.AddParam("SystemID", DbType.String, systemID);
sp.AddParam("ProgramID", DbType.String, programID);
sp.AddParam("ConfigName", DbType.String, configName);
sp.AddParam("ApplyType", DbType.String, applyType);
sp.AddParam("IDs", DbType.String, IDs);
object o = _Database.ExecuteScalar(sp.Command);
return ConvertEx.ToString(o);
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

IDatabase接口使用方法3：

C# Code:

/// <summary>
/// 获取指定单据的附件数据
/// </summary>
/// <param name="docID">单据号码</param>
/// <returns></returns>
public DataTable GetData(string docID)
{
string sql = $"SELECT * FROM tb_AttachFile WHERE DocID={_Database.ParamSymboName}DocID;";
CommandHelper cmd = _Database.CreateCommand(sql);
cmd.AddParam("DocID", DbType.String, docID);
DataTable dt = _Database.GetTable( cmd.Command, tb_AttachFile.__TableName);
return dt;
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

扫一扫加作者微信

旗舰版V5.1
(作者推荐)

轻量框架V2.1
(2021 release)