#region
|
|
using System;
|
using System.Data;
|
using System.Text;
|
using CSFrameworkV5.Common;
|
using CSFrameworkV5.Core;
|
using CSFrameworkV5.Core.CodeGenerator;
|
using CSFrameworkV5.Interfaces.Bridge;
|
using CSFrameworkV5.Models;
|
|
#endregion
|
|
/*===================================================================
|
* 程序说明: AdvancedFormConfig的数据访问层源码
|
* 作者资料: 孙中吕
|
* 创建日期: 2017/02/12 04:35:26
|
* 最后修改: 2017/02/12 04:35:26
|
*
|
* 注: 本代码由代码生成器(Code Generator)自动生成
|
* (此源码文件请放置在DataAccess模块)
|
* 版权所有 copyright 2006~2017, C/S框架网(www.cscode.net)
|
*===================================================================*/
|
|
namespace CSFrameworkV5.DataAccess
|
{
|
/// <summary>
|
/// DAL数据层:dalAdvancedFormConfig
|
/// </summary>
|
[DefaultORM_UpdateMode(typeof(sys_AdvancedFormConfig), true)]
|
public class dalAdvancedFormConfig : dalBaseDataDict,
|
IBridge_AdvancedFormConfig
|
{
|
/// <summary>
|
/// 构造器
|
/// </summary>
|
/// <param name="loginer">当前登录用户</param>
|
public dalAdvancedFormConfig(Loginer loginer) : base(loginer)
|
{
|
_KeyName = sys_AdvancedFormConfig.__KeyName; //主键字段
|
_TableName = sys_AdvancedFormConfig.__TableName; //表名
|
_ModelType = typeof(sys_AdvancedFormConfig); //指定ORM模型
|
_UpdateSummaryKeyMode = UpdateKeyMode.None;
|
_Database = DatabaseProvider.SystemDatabase;
|
}
|
|
public string ExistsConfig(string systemID, string programID,
|
string configName, string applyType, string IDs)
|
{
|
var 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);
|
var o = _Database.ExecuteScalar(sp.Command);
|
return ConvertEx.ToString(o);
|
}
|
|
public DataTable GetFormConfig(string systemID, string programID,
|
string userID)
|
{
|
var sp = _Database.CreateSqlProc("usp_GetFormConfig");
|
sp.AddParam("SystemID", DbType.String, systemID);
|
sp.AddParam("ProgramID", DbType.String, programID);
|
sp.AddParam("UserID", DbType.String, userID);
|
sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
|
return DatabaseProvider.SystemDatabase.GetTable(sp.Command,
|
sys_AdvancedFormConfig.__TableName);
|
}
|
|
public DataTable Search(string SystemID, string ProgramID,
|
string StyleID)
|
{
|
//构建CommandHelper实例，用于动态创建参数对象
|
var cmd = _Database.CreateCommand("");
|
|
var sb = new StringBuilder();
|
sb.Append("SELECT * FROM sys_AdvancedFormConfig WHERE 1=1 ");
|
|
var p = _Database.ParamSymboName;
|
|
if (!string.IsNullOrEmpty(SystemID))
|
{
|
sb.Append($" AND SystemID ={p}SystemID");
|
cmd.AddParam("SystemID", SystemID);
|
}
|
|
if (!string.IsNullOrEmpty(ProgramID))
|
{
|
sb.Append($" AND ProgramID ={p}ProgramID");
|
cmd.AddParam("ProgramID", ProgramID);
|
}
|
|
if (!string.IsNullOrEmpty(StyleID))
|
{
|
sb.Append($" AND StyleID ={p}StyleID");
|
cmd.AddParam("StyleID", StyleID);
|
}
|
|
sb.Append(" ORDER BY " + sys_AdvancedFormConfig.__KeyName + ";");
|
|
cmd.Command.CommandText =
|
CodeSafeHelper.GetSafeSQL(sb.ToStringEx());
|
|
return _Database.GetTable(cmd.Command,
|
sys_AdvancedFormConfig.__TableName);
|
}
|
|
/// <summary>
|
/// 根据表名获取该表的SQL命令生成器
|
/// </summary>
|
/// <param name="tableName">表名</param>
|
/// <returns></returns>
|
protected override IGenerateSqlCommand CreateSqlGenerator(
|
DataTable table)
|
{
|
Type ORM = null;
|
if (table.TableName == sys_AdvancedFormConfig.__TableName)
|
ORM = typeof(sys_AdvancedFormConfig); //指定表与ORM模型的对应关系
|
|
if (ORM == null) throw new Exception(table.TableName + "表没有ORM模型！");
|
|
return new GenerateSqlCmdByTableFields(ORM, table,
|
GeneratorFactory);
|
}
|
} //public class
|
} //namespace
|
