/// <summary>
/// 条件拼接
/// </summary>
/// <param name="SearchCondition"></param>
/// <returns></returns>
private string GenGetRFWhere(LogOperationRFSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(SearchCondition.ReleateNumber))
{
sb.Append(" and ReleateNumber like '%" + SearchCondition.ReleateNumber.Trim() + "%' ");
}
if (!string.IsNullOrEmpty(SearchCondition.PackageNumber))
{
sb.Append(" and PackageNumber like '%" + SearchCondition.PackageNumber.Trim() + "%' ");
}
if (SearchCondition.StartCreateTime != null)
{
sb.Append(" AND CreateTime>='" + SearchCondition.StartCreateTime.ToString() + "'");
}
if (SearchCondition.EndCreateTime != null)
{
sb.Append(" AND CreateTime<='" + SearchCondition.EndCreateTime.ToString() + "'");
}
if (!string.IsNullOrEmpty(SearchCondition.Creator))
{
sb.Append(" AND Creator='").Append(SearchCondition.Creator).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.LogType))
{
sb.Append(" AND LogType='").Append(SearchCondition.LogType).Append("' ");
}
return(sb.ToString());
}
public IEnumerable <WMS_Log_OperationRF> ExportLogOperationRFByCondition(LogOperationRFSearchCondition SearchCondition)
{
string sqlWhere = this.GenGetRFWhere(SearchCondition);
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input)
};
DataTable dt = this.ExecuteDataTable("Proc_WMS_ExportLogOperationRFByCondition", dbParams);
return(dt.ConvertToEntityCollection <WMS_Log_OperationRF>());
}
/// <summary>
/// 查询显示 分页查询
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public IEnumerable <WMS_Log_OperationRF> GetLogOperationRFByCondition(LogOperationRFSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
string sqlWhere = this.GenGetRFWhere(SearchCondition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, pageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, pageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataTable dt = this.ExecuteDataTable("Proc_WMS_GetLogOperationRFByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
return(dt.ConvertToEntityCollection <WMS_Log_OperationRF>());
}
