private void AddAccruedByPeriodParameters(AccruedQueryFilter filter, CustomDataCommand cmd, DynamicQuerySqlBuilder sb)
{
string dateConvert = string.Empty;
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "accrued.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
if (filter.CycleStart.HasValue)
{
dateConvert = filter.CycleStart.Value.Year.ToString() + filter.CycleStart.Value.Month.ToString().PadLeft(2, '0');
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.AccruePeriod",
DbType.String,
"@CycleStart",
QueryConditionOperatorType.MoreThanOrEqual,
dateConvert);
}
if (filter.CycleEnd.HasValue)
{
dateConvert = filter.CycleEnd.Value.Year.ToString() + filter.CycleEnd.Value.Month.ToString().PadLeft(2, '0');
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.AccruePeriod",
DbType.String,
"@CycleEnd",
QueryConditionOperatorType.LessThanOrEqual,
dateConvert);
}
cmd.CommandText = sb.BuildQuerySql();
}
/// <summary>
/// 应计返利报表查询（PM）
/// </summary>
/// <param name="filter">查询条件集合</param>
/// <param name="callback">回调函数</param>
public void AccruedByPM(AccruedQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "ExternalSYSService/ExternalSYS/QueryAccruedByPM";
filter.CompanyCode = CPApplication.Current.CompanyCode;
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
public DataTable AccruedByVendor(AccruedQueryFilter filter, out int totalCount)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_AccruedByVendor");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "accrued.AccruePeriod ASC"))
{
AddAccruedByVendorParameters(filter, cmd, sb);
DataTable dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public DataTable AccruedByRule(AccruedQueryFilter filter, out int totalCount)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_AccruedByRule");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "accrued.AccruePeriod ASC,accrued.AssignedCode ASC"))
{
AddAccruedByRuleParameters(filter, cmd, sb);
DataTable dt = cmd.ExecuteDataTable();
EnumColumnList enumColList = new EnumColumnList();
CodeNamePairColumnList codeNameColList = new CodeNamePairColumnList();
codeNameColList.Add("EIMSType", "ExternalSYS", "EIMSType");
codeNameColList.Add("RuleStatus", "ExternalSYS", "RuleStatus");
cmd.ConvertColumn(dt, enumColList, codeNameColList);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public override void OnPageLoad(object sender, EventArgs e)
{
base.OnPageLoad(sender, e);
this.SearchCondition.DataContext = m_queryRequest = new AccruedQueryFilter();
BindComboBoxData();
}
public void ExportAccruedByPM(AccruedQueryFilter filter, ColumnSet[] columns)
{
filter.CompanyCode = CPApplication.Current.CompanyCode;
restClient.ExportFile("/ExternalSYSService/ExternalSYS/QueryAccruedByPM", filter, columns);
}
private void AddAccruedByRuleParameters(AccruedQueryFilter filter, CustomDataCommand cmd, DynamicQuerySqlBuilder sb)
{
string dateConvert = string.Empty;
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "accrued.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
if (filter.CycleStart.HasValue)
{
dateConvert = filter.CycleStart.Value.Year.ToString() + filter.CycleStart.Value.Month.ToString().PadLeft(2, '0');
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.AccruePeriod",
DbType.String,
"@CycleStart",
QueryConditionOperatorType.MoreThanOrEqual,
dateConvert);
}
if (filter.CycleEnd.HasValue)
{
dateConvert = filter.CycleEnd.Value.Year.ToString() + filter.CycleEnd.Value.Month.ToString().PadLeft(2, '0');
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.AccruePeriod",
DbType.String,
"@CycleEnd",
QueryConditionOperatorType.LessThanOrEqual,
dateConvert);
}
if (filter.VendorSysNo.HasValue)
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.VendorNumber",
DbType.Int32,
"@VendorSysNo",
QueryConditionOperatorType.Equal,
filter.VendorSysNo);
}
if (!string.IsNullOrEmpty(filter.EIMSType))
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.EIMSType",
DbType.String,
"@EIMSType",
QueryConditionOperatorType.Equal,
filter.EIMSType);
}
if (!string.IsNullOrEmpty(filter.RuleNo))
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"ruleInfo.AssignedCode",
DbType.String,
"@RuleNo",
QueryConditionOperatorType.Equal,
filter.RuleNo);
}
if (filter.EndBalance == null ||
(filter.EndBalance.HasValue && filter.EndBalance == 0))
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"accrued.EndBalance",
DbType.Int32,
"@EndBalance",
QueryConditionOperatorType.NotEqual, 0);
}
cmd.CommandText = sb.BuildQuerySql();
}
public QueryResult QueryAccruedByPM(AccruedQueryFilter filter)
{
return(QueryList <AccruedQueryFilter>(filter, ObjectFactory <IAccruedReportDA> .Instance.AccruedByPM));
}
