using HH.MData;
|
using HH.WMS.DAL;
|
using HH.WMS.Entitys.Algorithm;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.Common;
|
using HW.Utility.Data;
|
using MongoDB.Driver;
|
using MongoDB.Driver.Builders;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.Common;
|
using System.Linq;
|
using System.Text;
|
|
namespace HW.DAL
|
{
|
/// <summary>
|
/// 同步记录表数据处理层
|
/// </summary>
|
/// <returns></returns>
|
/// <history>[HanHe(XDL)] CREATED 2018/06/12</history>
|
public class TN_AB_B_SYNCH_LOGDAL : BaseDAL
|
{
|
#region 获取同步记录集合
|
/// <summary>
|
/// 根据表名获取同步记录集合
|
/// </summary>
|
/// <param name="tableName">表名</param>
|
/// <returns>同步记录集合</returns>
|
/// <history>[HanHe(XDL)] CREATED 2018/06/12</history>
|
public List<TN_AB_B_SYNCH_LOGEntity> GetsynchLogList(string tableName)
|
{
|
string sql = "select * from TN_AB_B_SYNCH_LOG where CN_S_TABLE_NAME='" + tableName + "'";
|
DbCommand cmd = DataAccess.GetSqlStringCommand(sql);
|
List<TN_AB_B_SYNCH_LOGEntity> list = DataAccessExtensive.ExecuteListEntity<TN_AB_B_SYNCH_LOGEntity>(this.DataAccess, cmd, SetEntity);
|
return list;
|
}
|
|
/// <summary>
|
/// 设置实体的各列
|
/// <summary>
|
private void SetEntity(TN_AB_B_SYNCH_LOGEntity entity, IDataReader reader)
|
{
|
SetEntityUti(entity, "CN_S_GUID", "CN_S_GUID", reader);
|
SetEntityUti(entity, "CN_S_TABLE_NAME", "CN_S_TABLE_NAME", reader);
|
SetEntityUti(entity, "CN_N_OP_FLAG", "CN_N_OP_FLAG", reader);
|
SetEntityUti(entity, "CN_T_CREATE", "CN_T_CREATE", reader);
|
|
}
|
#endregion
|
|
#region 获取需要删除的数据
|
/// <summary>
|
///
|
/// </summary>
|
/// <returns></returns>
|
public List<TN_AB_B_SYNCH_LOGEntity> GetRemoveDataList()
|
{
|
List<string> removeDataList = new List<string>();
|
string sql = "SELECT * FROM TN_AB_B_SYNCH_LOG WHERE CN_N_OP_FLAG=4";
|
DbCommand cmd = DataAccess.GetSqlStringCommand(sql);
|
List<TN_AB_B_SYNCH_LOGEntity> synchLogList = DataAccessExtensive.ExecuteListEntity<TN_AB_B_SYNCH_LOGEntity>(this.DataAccess, cmd, SetEntity);
|
|
return synchLogList;
|
}
|
#endregion
|
|
#region 获取中间表需要同步的数据
|
|
public List<TN_AB_B_SYNCH_LOGEntity> GetSynchDataList()
|
{
|
List<string> removeDataList = new List<string>();
|
string sql = "SELECT TOP 1 * FROM TN_AB_B_SYNCH_LOG";
|
DbCommand cmd = DataAccess.GetSqlStringCommand(sql);
|
List<TN_AB_B_SYNCH_LOGEntity> synchLogList = DataAccessExtensive.ExecuteListEntity<TN_AB_B_SYNCH_LOGEntity>(this.DataAccess, cmd, SetEntity);
|
|
return synchLogList;
|
}
|
#endregion
|
|
#region 根据条件删除Mongo数据
|
/// <summary>
|
/// 根据条件删除Mongo数据
|
/// </summary>
|
/// <typeparam name="T">实体</typeparam>
|
/// <param name="fieldValue">字段值</param>
|
/// <param name="fieldName">字段名称</param>
|
/// <param name="collectionName">表名</param>
|
/// <returns></returns>
|
public bool RemoveDataByCode<T>(string fieldValue, string fieldName, string collectionName)
|
{
|
MongoDBHelper dbHelper = new MongoDBHelper();
|
IMongoQuery query = Query.EQ(fieldName, fieldValue);
|
bool result = dbHelper.Remove<T>(query, collectionName);
|
return result;
|
}
|
#endregion
|
|
#region 删除中间表标识为已删除的数据
|
/// <summary>
|
/// 删除中间表标识为已删除的数据
|
/// </summary>
|
/// <param name="stockRemoveList"></param>
|
/// <param name="tableName"></param>
|
/// <history>[HanHe(XDL)] CREATED 2018/06/13</history>
|
public SqlExecuteResult RemoveData(List<TN_AB_B_SYNCH_LOGEntity> stockRemoveList, string tableName)
|
{
|
string sql = "DELETE FROM TN_AB_B_SYNCH_LOG WHERE CN_S_GUID=@CN_S_GUID AND CN_S_TABLE_NAME=@CN_S_TABLE_NAME ";
|
|
List<DbCommand> cmds = new List<DbCommand>();
|
foreach (TN_AB_B_SYNCH_LOGEntity entity in stockRemoveList)
|
{
|
DbCommand cmd = DataAccess.GetSqlStringCommand(sql);
|
DataAccess.AddInParameter(cmd, "CN_S_GUID", ComDbType.CHAR, entity.CN_S_GUID);
|
DataAccess.AddInParameter(cmd, "CN_S_TABLE_NAME", ComDbType.CHAR, entity.CN_S_TABLE_NAME);
|
cmds.Add(cmd);
|
}
|
return ExecuteCommands(cmds, null);
|
}
|
#endregion
|
|
public bool RemoveDataByCodeSafty<T>(TN_AB_B_ITEM_SAFETYEntity tN_AB_B_ITEM_SAFETYEntity, string collectionName)
|
{
|
MongoDBHelper dbHelper = new MongoDBHelper();
|
IMongoQuery query = Query.EQ("CN_S_ITEM_CODE", tN_AB_B_ITEM_SAFETYEntity.CN_S_ITEM_CODE);
|
query = Query.And(query, Query.EQ("CN_S_AREA_CODE", tN_AB_B_ITEM_SAFETYEntity.CN_S_AREA_CODE));
|
bool result = dbHelper.Remove<T>(query, collectionName);
|
return result;
|
}
|
|
public bool IsExistsMongoSafty<T>(TN_AB_B_ITEM_SAFETYEntity tN_AB_B_ITEM_SAFETYEntity, string collectionName)
|
{
|
MongoDBHelper dbHelper = new MongoDBHelper();
|
IMongoQuery query = Query.EQ("CN_S_ITEM_CODE", tN_AB_B_ITEM_SAFETYEntity.CN_S_ITEM_CODE);
|
query = Query.And(query, Query.EQ("CN_S_AREA_CODE", tN_AB_B_ITEM_SAFETYEntity.CN_S_AREA_CODE));
|
long count = dbHelper.FindCount<T>(query, collectionName);
|
if (count > 0) return true;
|
return false;
|
}
|
|
#region 判断记录是否存在
|
/// <summary>
|
/// 判断记录是否存在
|
/// </summary>
|
/// <typeparam name="T">实体</typeparam>
|
/// <param name="fieldValue">字段值</param>
|
/// <param name="fieldName">字段名称</param>
|
/// <param name="collectionName">表名</param>
|
/// <returns></returns>
|
public bool IsExistsMongo<T>(string fieldValue, string fieldName, string collectionName)
|
{
|
MongoDBHelper dbHelper = new MongoDBHelper();
|
IMongoQuery query = Query.EQ(fieldName, fieldValue);
|
long count = dbHelper.FindCount<T>(query, collectionName);
|
if (count > 0) return true;
|
return false;
|
}
|
#endregion
|
|
|
#region 新增一个集合到mongo数据库
|
/// <summary>
|
/// 新增一个集合到mongo数据库
|
/// </summary>
|
/// <typeparam name="T">实体类</typeparam>
|
/// <param name="lstEntity">实体类集合数据</param>
|
/// <param name="CollectionName">对象名称</param>
|
/// <returns></returns>
|
public bool AddList<T>(List<T> lstEntity, string collectionName)
|
{
|
try
|
{
|
MongoDBHelper dbHelper = new MongoDBHelper();
|
bool result = dbHelper.Insert<T>(lstEntity, collectionName);
|
return result;
|
}
|
catch (Exception ex)
|
{
|
HanHe.Service.Log.Info("mongo error", ex.Message);
|
return false;
|
}
|
}
|
#endregion
|
|
#region 删除已同步数据
|
/// <summary>
|
/// 删除已同步数据
|
/// </summary>
|
/// <param name="tableName">集合名称</param>
|
/// <returns></returns>
|
public SqlExecuteResult RemoveSynchLogData(string tableName)
|
{
|
string sql = "DELETE FROM TN_AB_B_SYNCH_LOG WHERE CN_N_OP_FLAG IN (1,2) AND CN_S_TABLE_NAME='" + tableName + "' ";
|
|
DbCommand cmd = DataAccess.GetSqlStringCommand(sql);
|
return ExecuteCommand(cmd, null);
|
}
|
#endregion
|
|
|
internal object ClearMongo(string date)
|
{
|
return null;
|
//MongoDBHelper dbHelper = new MongoDBHelper();
|
|
//DateTime dt =DateTime.Parse(date);
|
//DateTime now = DateTime.Now;
|
|
//dt = dt.AddMinutes(1);
|
|
//IMongoQuery query = Query.In("CN_T_TIME",dt.Year + "/");
|
//bool result = dbHelper.Remove<TN_SYS_LOGEntity>(query, "TN_SYS_LOG");
|
//return result;
|
}
|
|
public bool ClearMongoCollection(string collectionName)
|
{
|
MongoDBHelper dbHelper = new MongoDBHelper();
|
IMongoQuery query = Query.EQ("Type", "4");
|
bool result = dbHelper.Remove<MONGO_KEYTYPE_MAP>(query, collectionName);
|
return result;
|
}
|
|
}
|
}
|
