private CompanyAuditQueryCondition getCondition()
{
CompanyAuditQueryCondition parameter = new CompanyAuditQueryCondition();
if (!string.IsNullOrWhiteSpace(this.txtAccount.Text))
{
parameter.UserNo = this.txtAccount.Text.Trim();
}
if (!string.IsNullOrWhiteSpace(this.ddlRoleType.SelectedValue))
{
parameter.CompanyType = (CompanyType)byte.Parse(this.ddlRoleType.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(this.ddlAccountType.SelectedValue))
{
parameter.AccountType = (AccountBaseType)byte.Parse(this.ddlAccountType.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(this.txtCompayName.Text))
{
parameter.CompanyName = this.txtCompayName.Text.Trim();
}
parameter.ApplyTimeStart = DateTime.Parse(this.txtBeginTime.Text);
parameter.ApplyTimeEnd = DateTime.Parse(this.txtEndTime.Text).AddDays(1).AddMilliseconds(-3);
if (!string.IsNullOrWhiteSpace(this.ddlAuditType.SelectedValue))
{
parameter.AuditType = this.ddlAuditType.SelectedValue.Trim();
}
if (!string.IsNullOrWhiteSpace(this.ddlRegisterType.SelectedValue))
{
parameter.SourceType = this.ddlRegisterType.SelectedValue.Trim();
}
return(parameter);
}
public IEnumerable <DataTransferObject.Organization.CompanyAuditInfo> QueryNeedAuditCompanies(CompanyAuditQueryCondition condition, Pagination pagination)
{
var result = new List <DataTransferObject.Organization.CompanyAuditInfo>();
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
if (!string.IsNullOrWhiteSpace(condition.UserNo))
{
dbOperator.AddParameter("@i_UserNo", condition.UserNo);
}
if (condition.CompanyType.HasValue)
{
dbOperator.AddParameter("@i_CompanyType", (byte)condition.CompanyType);
}
if (condition.AccountType.HasValue)
{
dbOperator.AddParameter("@i_AccountType", (byte)condition.AccountType);
}
if (condition.ApplyTimeStart.HasValue)
{
dbOperator.AddParameter("@i_ApplyTimeStart", condition.ApplyTimeStart);
}
if (condition.ApplyTimeEnd.HasValue)
{
dbOperator.AddParameter("@i_ApplyTimeEnd", condition.ApplyTimeEnd);
}
if (!string.IsNullOrWhiteSpace(condition.CompanyName))
{
dbOperator.AddParameter("@i_CompanyName", condition.CompanyName);
}
if (!string.IsNullOrWhiteSpace(condition.AuditType))
{
dbOperator.AddParameter("@i_AuditType", condition.AuditType);
}
if (!string.IsNullOrWhiteSpace(condition.SourceType))
{
dbOperator.AddParameter("@i_SourceType", condition.SourceType);
}
dbOperator.AddParameter("@i_Pagesize", pagination.PageSize);
dbOperator.AddParameter("@i_PageIndex", pagination.PageIndex);
var totalCount = dbOperator.AddParameter("@o_RowCount");
totalCount.DbType = System.Data.DbType.Int32;
totalCount.Direction = System.Data.ParameterDirection.Output;
using (var reader = dbOperator.ExecuteReader("dbo.P_CompanyAuditPagination", System.Data.CommandType.StoredProcedure))
{
while (reader.Read())
{
result.Add(new CompanyAuditInfo()
{
CompanyId = reader.GetGuid(0),
UserNo = reader.GetString(1),
AbbreviateName = reader.GetString(2),
CompanyType = (CompanyType)reader.GetByte(3),
AccountType = (AccountBaseType)reader.GetByte(4),
ApplyTime = reader.GetDateTime(5),
AuditType = reader.GetString(6),
SourceType = reader.GetString(7),
SpreadId = reader.GetGuid(8)
});
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
