/// <summary> /// 获取EasyUiDataGrid数据集 /// </summary> /// <param name="entity"></param> /// <returns></returns> public EasyUiDataGrid <Re_Organization> GetEasyUiDataList(Re_Organization entity, int pageIndex, int pageSize, string order) { return(new EasyUiDataGrid <Re_Organization>() { Total = GetRecordCount(entity), Rows = GetList(entity, pageIndex, pageSize, order) }); }
/// <summary> /// 分页获取列表 /// </summary> /// <param name="entity">查询实体</param> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">一页显示条数</param> /// <param name="order">排序</param> /// <returns></returns> public List <Re_Organization> GetList(Re_Organization entity, int pageIndex, int pageSize, string order = EquipmentConst.Order) { StringBuilder sql = new StringBuilder($" SELECT * FROM [dbo].[{tableName}] "); Dictionary <string, object> parameters = new Dictionary <string, object>(); LoadCondition(entity, sql, ref parameters); return(DataHelper.GetList <Re_Organization>(db, sql.ToString(), parameters, delegate(IDataReader reader, Re_Organization dataModel) { BuildTenant(reader, dataModel); }, pageIndex, pageSize, order)); }
/// <summary> /// 映射 /// </summary> /// <param name="reader"></param> /// <param name="entity"></param> private void BuildTenant(IDataReader reader, Re_Organization entity) { entity.Id = reader.GetValue <Guid>("Id"); entity.TenantId = reader.GetValue <Guid>("TenantId"); entity.OrganizationId = reader.GetValue <Guid>("OrganizationId"); entity.AssetsId = reader.GetValue <Guid>("AssetsId"); entity.EquipmentId = reader.GetValue <Guid>("EquipmentId"); entity.CreateBy = reader.GetValue <Guid>("CreateBy"); entity.CreateTime = reader.GetValue <DateTime>("CreateTime"); entity.ModifyBy = reader.GetValue <Guid>("ModifyBy"); entity.ModifyTime = reader.GetValue <DateTime>("ModifyTime"); }
/// <summary> /// 根据条件获取 /// </summary> /// <param name="entity"></param> /// <returns></returns> public Re_Organization Get(Re_Organization searchEntity) { var list = Re_OrganizationDao.Instance.GetList(searchEntity); if (list != null && list.Count > 0) { return(list[0]); } else { return(null); } }
/// <summary> /// 创建 /// </summary> /// <param name="entity"></param> public void Create(Re_Organization entity) { var fields = new Dictionary <string, object>() { { "Id", entity.Id }, { "TenantId", entity.TenantId }, { "OrganizationId", entity.OrganizationId }, { "AssetsId", entity.AssetsId }, { "EquipmentId", entity.EquipmentId }, { "CreateBy", entity.CreateBy }, { "CreateTime", entity.CreateTime }, { "ModifyBy", entity.ModifyBy }, { "ModifyTime", entity.ModifyTime } }; DataHelper.Add(db, tableName, fields); }
/// <summary> /// 加载条件 /// </summary> /// <param name="entity">查询实体</param> /// <param name="sql">SQL命令</param> /// <param name="parameters">参数</param> private void LoadCondition(Re_Organization entity, StringBuilder sql, ref Dictionary <string, object> parameters) { if (entity == null) { return; } sql.AppendFormat(" WHERE 1=1 "); if (entity.Id != Guid.Empty) { sql.AppendFormat(" AND [Id]=@Id "); parameters.Add("@Id", entity.Id); } if (entity.TenantId != Guid.Empty) { sql.AppendFormat(" AND [TenantId]=@TenantId "); parameters.Add("@TenantId", entity.TenantId); } if (entity.OrganizationId != Guid.Empty) { sql.AppendFormat(" AND [OrganizationId]=@OrganizationId "); parameters.Add("@OrganizationId", entity.OrganizationId); } if (entity.AssetsId != Guid.Empty) { sql.AppendFormat(" AND [AssetsId]=@AssetsId "); parameters.Add("@AssetsId", entity.AssetsId); } if (entity.EquipmentId != Guid.Empty) { sql.AppendFormat(" AND [EquipmentId]=@EquipmentId "); parameters.Add("@EquipmentId", entity.EquipmentId); } if (entity.CreateBy != Guid.Empty) { sql.AppendFormat(" AND [CreateBy]=@CreateBy "); parameters.Add("@CreateBy", entity.CreateBy); } if (entity.ModifyBy != Guid.Empty) { sql.AppendFormat(" AND [ModifyBy]=@ModifyBy "); parameters.Add("@ModifyBy", entity.ModifyBy); } }
/// <summary> /// 创建 /// </summary> /// <param name="entity"></param> public void Create(Re_Organization entity) { Re_OrganizationDao.Instance.Create(entity); }
/// <summary> /// 更新 /// </summary> /// <param name="entity"></param> public void Update(Re_Organization entity) { Re_OrganizationDao.Instance.Update(entity); }
/// <summary> /// 获取记录总数 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int GetRecordCount(Re_Organization searchEntity) { var list = GetList(searchEntity); return(list == null ? 0 : list.Count); }
/// <summary> /// 分页获取列表 /// </summary> /// <param name="entity">查询实体</param> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">一页显示条数</param> /// <param name="order">排序</param> /// <returns></returns> public List <Re_Organization> GetList(Re_Organization entity, int pageIndex, int pageSize, string order = EquipmentConst.Order) { return(Re_OrganizationDao.Instance.GetList(entity, pageIndex, pageSize, order)); }
/// <summary> /// 获取列表 /// </summary> /// <param name="entity"></param> /// <returns></returns> public List <Re_Organization> GetList(Re_Organization entity) { return(Re_OrganizationDao.Instance.GetList(entity)); }