|
|
|
|
|
/*
|
|
|
|
|
|
简介：负责存取数据的类
|
|
|
|
|
|
创建时间：2002-10
|
|
|
|
|
|
最后修改时间：2002-10
|
|
|
|
|
|
*/
|
|
|
|
|
|
using System;
|
|
|
|
|
|
using System.Data;
|
|
|
|
|
|
using System.Diagnostics;
|
|
|
|
|
|
using System.Configuration;
|
|
|
|
|
|
using System.Data.SqlClient;
|
|
|
|
|
|
using System.Collections;
|
|
|
|
|
|
using System.Collections.Specialized;
|
|
|
|
|
|
using System.Web;
|
|
|
|
|
|
using BP.DA;
|
|
|
|
|
|
using BP.Pub;
|
|
|
|
|
|
using BP.Sys;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
namespace BP.En
|
|
|
|
|
|
{
|
|
|
|
|
|
public class EntityDBAccess
|
|
|
|
|
|
{
|
|
|
|
|
|
#region 对实体的基本操作
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 删除
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
/// <param name="en"></param>
|
|
|
|
|
|
/// <returns></returns>
|
|
|
|
|
|
public static int Delete(Entity en)
|
|
|
|
|
|
{
|
|
|
|
|
|
if (en.EnMap.EnType == EnType.View)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
|
|
|
|
|
|
switch (en.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
return DBAccess.RunSQL(en.SQLCash.Delete, SqlBuilder.GenerParasPK(en));
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 更新
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
/// <param name="en">产生要更新的语句</param>
|
|
|
|
|
|
/// <param name="keys">要更新的属性(null,认为更新全部)</param>
|
|
|
|
|
|
/// <returns>sql</returns>
|
|
|
|
|
|
public static int Update(Entity en, string[] keys)
|
|
|
|
|
|
{
|
|
|
|
|
|
if (en.EnMap.EnType == EnType.View)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
|
|
|
|
|
|
var paras = SqlBuilder.GenerParas(en, keys);
|
|
|
|
|
|
string sql = en.SQLCash.GetUpdateSQL(en, keys);
|
|
|
|
|
|
try
|
|
|
|
|
|
{
|
|
|
|
|
|
switch (en.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
switch (BP.Difference.SystemConfig.AppCenterDBType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBType.MSSQL:
|
|
|
|
|
|
case DBType.Oracle:
|
|
|
|
|
|
case DBType.MySQL:
|
|
|
|
|
|
case DBType.PostgreSQL:
|
|
|
|
|
|
case DBType.UX:
|
|
|
|
|
|
case DBType.KingBaseR3:
|
|
|
|
|
|
case DBType.KingBaseR6:
|
|
|
|
|
|
return DBAccess.RunSQL(sql, paras);
|
|
|
|
|
|
default:
|
|
|
|
|
|
//return DBAccess.RunSQL(en.SQLCash.GetUpdateSQL(en, keys),
|
|
|
|
|
|
// SqlBuilder.GenerParas(en, keys));
|
|
|
|
|
|
if (keys != null)
|
|
|
|
|
|
{
|
|
|
|
|
|
Paras ps = new Paras();
|
|
|
|
|
|
Paras myps = SqlBuilder.GenerParas(en, keys);
|
|
|
|
|
|
foreach (Para p in myps)
|
|
|
|
|
|
{
|
|
|
|
|
|
foreach (string s in keys)
|
|
|
|
|
|
{
|
|
|
|
|
|
if (s == p.ParaName)
|
|
|
|
|
|
{
|
|
|
|
|
|
ps.Add(p);
|
|
|
|
|
|
break;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
return DBAccess.RunSQL(en.SQLCash.GetUpdateSQL(en, keys), ps);
|
|
|
|
|
|
}
|
|
|
|
|
|
else
|
|
|
|
|
|
{
|
|
|
|
|
|
return DBAccess.RunSQL(en.SQLCash.GetUpdateSQL(en, keys),
|
|
|
|
|
|
SqlBuilder.GenerParas(en, keys));
|
|
|
|
|
|
}
|
|
|
|
|
|
break;
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
//case DBUrlType.DBAccessOfMSSQL1:
|
|
|
|
|
|
// return DBAccessOfMSSQL1.RunSQL(SqlBuilder.Update(en, keys));
|
|
|
|
|
|
//case DBUrlType.DBAccessOfMSSQL2:
|
|
|
|
|
|
// return DBAccessOfMSSQL2.RunSQL(SqlBuilder.Update(en, keys));
|
|
|
|
|
|
//case DBUrlType.DBAccessOfOracle1:
|
|
|
|
|
|
// return DBAccessOfOracle1.RunSQL(SqlBuilder.Update(en, keys));
|
|
|
|
|
|
//case DBUrlType.DBAccessOfOracle2:
|
|
|
|
|
|
// return DBAccessOfOracle2.RunSQL(SqlBuilder.Update(en, keys));
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
catch (Exception ex)
|
|
|
|
|
|
{
|
|
|
|
|
|
if (BP.Difference.SystemConfig.IsDebug)
|
|
|
|
|
|
en.CheckPhysicsTable();
|
|
|
|
|
|
throw ex;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
#region 产生序列号码方法
|
|
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
public static int RetrieveV2(Entity en, string sql, Paras paras)
|
|
|
|
|
|
{
|
|
|
|
|
|
try
|
|
|
|
|
|
{
|
|
|
|
|
|
DataTable dt = new DataTable();
|
|
|
|
|
|
switch (en.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
dt = DBAccess.RunSQLReturnTable(sql, paras);
|
|
|
|
|
|
break;
|
|
|
|
|
|
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置DB类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (dt.Rows.Count == 0)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
Attrs attrs = en.EnMap.Attrs;
|
|
|
|
|
|
EntityDBAccess.fullDate(dt, en, attrs);
|
|
|
|
|
|
int i = dt.Rows.Count;
|
|
|
|
|
|
dt.Dispose();
|
|
|
|
|
|
return i;
|
|
|
|
|
|
}
|
|
|
|
|
|
catch (System.Exception ex)
|
|
|
|
|
|
{
|
|
|
|
|
|
throw ex;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
public static int Retrieve(Entity en, string sql, Paras paras)
|
|
|
|
|
|
{
|
|
|
|
|
|
DataTable dt;
|
|
|
|
|
|
switch (en.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
dt = DBAccess.RunSQLReturnTable(sql, paras);
|
|
|
|
|
|
break;
|
|
|
|
|
|
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置DB类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (dt.Rows.Count == 0)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
Attrs attrs = en.EnMap.Attrs;
|
|
|
|
|
|
EntityDBAccess.fullDate(dt, en, attrs);
|
|
|
|
|
|
int num = dt.Rows.Count;
|
|
|
|
|
|
dt.Dispose();
|
|
|
|
|
|
return num;
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 查询
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
/// <param name="en">实体</param>
|
|
|
|
|
|
/// <param name="sql">组织的查询语句</param>
|
|
|
|
|
|
/// <returns></returns>
|
|
|
|
|
|
public static int Retrieve(Entity en, string sql)
|
|
|
|
|
|
{
|
|
|
|
|
|
try
|
|
|
|
|
|
{
|
|
|
|
|
|
DataTable dt = new DataTable();
|
|
|
|
|
|
switch (en.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
|
|
|
break;
|
|
|
|
|
|
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置DB类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (dt.Rows.Count == 0)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
Attrs attrs = en.EnMap.Attrs;
|
|
|
|
|
|
EntityDBAccess.fullDate(dt, en, attrs);
|
|
|
|
|
|
int i = dt.Rows.Count;
|
|
|
|
|
|
dt.Dispose();
|
|
|
|
|
|
return i;
|
|
|
|
|
|
}
|
|
|
|
|
|
catch (System.Exception ex)
|
|
|
|
|
|
{
|
|
|
|
|
|
throw ex;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
private static void fullDate(DataTable dt, Entity en, Attrs attrs)
|
|
|
|
|
|
{
|
|
|
|
|
|
//判断是否加密.
|
|
|
|
|
|
if (en.EnMap.IsJM == false)
|
|
|
|
|
|
{
|
|
|
|
|
|
string parafields = en.EnMap.ParaFields;
|
|
|
|
|
|
if (parafields == null)
|
|
|
|
|
|
{
|
|
|
|
|
|
foreach (Attr attr in attrs)
|
|
|
|
|
|
{
|
|
|
|
|
|
en.Row.SetValByKey(attr.Key, dt.Rows[0][attr.Key]);
|
|
|
|
|
|
}
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (dt.Columns.Contains("AtPara") == false)
|
|
|
|
|
|
throw new Exception("err@实体类[" + en.EnMap.EnDesc + "_" + en.ToString() + "] 缺少AtPara字段.");
|
|
|
|
|
|
|
|
|
|
|
|
AtPara ap = new AtPara(dt.Rows[0]["AtPara"].ToString());
|
|
|
|
|
|
foreach (Attr attr in attrs)
|
|
|
|
|
|
{
|
|
|
|
|
|
//如果是参数字段.
|
|
|
|
|
|
if (parafields.Contains(attr.Key + ",") == true)
|
|
|
|
|
|
{
|
|
|
|
|
|
en.Row.SetValByKey(attr.Key, ap.GetValStrByKey(attr.Key));
|
|
|
|
|
|
continue;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
//判断枚举字段是否是参数字段.
|
|
|
|
|
|
if (attr.IsRefAttr == true && dt.Columns.Contains(attr.Key) == false)
|
|
|
|
|
|
{
|
|
|
|
|
|
string key = attr.Key.Replace("Text", "");
|
|
|
|
|
|
Attr enumAttr = attrs.GetAttrByKey(key);
|
|
|
|
|
|
|
|
|
|
|
|
AtPara apcfg = new AtPara(enumAttr.UITag);
|
|
|
|
|
|
string enumVal = en.Row[key].ToString();
|
|
|
|
|
|
en.Row.SetValByKey(attr.Key, apcfg.GetValStrByKey(enumVal));
|
|
|
|
|
|
continue;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
en.Row.SetValByKey(attr.Key, dt.Rows[0][attr.Key]);
|
|
|
|
|
|
}
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
//执行解密.
|
|
|
|
|
|
foreach (Attr attr in attrs)
|
|
|
|
|
|
{
|
|
|
|
|
|
var val = dt.Rows[0][attr.Key];
|
|
|
|
|
|
|
|
|
|
|
|
if (attr.IsPK == false && attr.MyDataType == DataType.AppString)
|
|
|
|
|
|
val = val;
|
|
|
|
|
|
|
|
|
|
|
|
en.Row.SetValByKey(attr.Key, val);
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
public static int Retrieve(Entities ens, string sql)
|
|
|
|
|
|
{
|
|
|
|
|
|
try
|
|
|
|
|
|
{
|
|
|
|
|
|
DataTable dt = new DataTable();
|
|
|
|
|
|
switch (ens.GetNewEntity.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
|
|
|
break;
|
|
|
|
|
|
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置DB类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (dt.Rows.Count == 0)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
|
|
|
|
|
|
Map enMap = ens.GetNewEntity.EnMap;
|
|
|
|
|
|
Attrs attrs = enMap.Attrs;
|
|
|
|
|
|
|
|
|
|
|
|
//Entity en1 = ens.GetNewEntity;
|
|
|
|
|
|
foreach (DataRow dr in dt.Rows)
|
|
|
|
|
|
{
|
|
|
|
|
|
Entity en = ens.GetNewEntity;
|
|
|
|
|
|
//Entity en = en1.CreateInstance();
|
|
|
|
|
|
foreach (Attr attr in attrs)
|
|
|
|
|
|
{
|
|
|
|
|
|
en.Row.SetValByKey(attr.Key, dr[attr.Key]);
|
|
|
|
|
|
}
|
|
|
|
|
|
ens.AddEntity(en);
|
|
|
|
|
|
}
|
|
|
|
|
|
int i = dt.Rows.Count;
|
|
|
|
|
|
dt.Dispose();
|
|
|
|
|
|
return i;
|
|
|
|
|
|
//return dt.Rows.Count;
|
|
|
|
|
|
}
|
|
|
|
|
|
catch (System.Exception ex)
|
|
|
|
|
|
{
|
|
|
|
|
|
// ens.GetNewEntity.CheckPhysicsTable();
|
|
|
|
|
|
throw new Exception("@在[" + ens.GetNewEntity.EnDesc + "]查询时出现错误:" + ex.Message);
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
public static int Retrieve(Entities ens, string sql, Paras paras, string[] fullAttrs)
|
|
|
|
|
|
{
|
|
|
|
|
|
DataTable dt = null;
|
|
|
|
|
|
switch (ens.GetNewEntity.EnMap.EnDBUrl.DBUrlType)
|
|
|
|
|
|
{
|
|
|
|
|
|
case DBUrlType.AppCenterDSN:
|
|
|
|
|
|
dt = DBAccess.RunSQLReturnTable(sql, paras);
|
|
|
|
|
|
break;
|
|
|
|
|
|
|
|
|
|
|
|
default:
|
|
|
|
|
|
throw new Exception("@没有设置DB类型。");
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (dt.Rows.Count == 0)
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
|
|
|
|
|
|
//设置查询.
|
|
|
|
|
|
QueryObject.InitEntitiesByDataTable(ens, dt, fullAttrs);
|
|
|
|
|
|
|
|
|
|
|
|
int i = dt.Rows.Count;
|
|
|
|
|
|
dt.Dispose();
|
|
|
|
|
|
return i;
|
|
|
|
|
|
//return dt.Rows.Count;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
}
|
