/// <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));
}
