/// <summary>
/// 合同与对应单据
/// </summary>
/// <param name="filter">查询条件集合</param>
/// <param name="callback">回调函数</param>
public void QueryUnbilledRuleList(UnbilledRuleListQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "ExternalSYSService/ExternalSYS/QueryUnbilledRuleList";
filter.CompanyCode = CPApplication.Current.CompanyCode;
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
/// <summary>
/// 查询合同与对应单据
/// </summary>
/// <param name="filter">查询条件集合</param>
/// <param name="totalCount">总记录数</param>
/// <returns>DataTable数据集合</returns>
public DataTable UnbilledRuleListQuery(UnbilledRuleListQueryFilter filter, out int totalCount)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_UnbilledRuleList");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "vendor.SysNo DESC"))
{
AddUnbilledRuleList(filter, sb, cmd);
DataTable dt = cmd.ExecuteDataTable();
EnumColumnList enumColList = new EnumColumnList();
CodeNamePairColumnList codeNameColList = new CodeNamePairColumnList();
codeNameColList.Add("SettleType", "ExternalSYS", "SettleType");
codeNameColList.Add("BillingCycle", "ExternalSYS", "BillingCycle");
codeNameColList.Add("SettleWeeklyDay", "ExternalSYS", "DayOfWeek");
cmd.ConvertColumn(dt, enumColList, codeNameColList);
//添加 合同结算周期列
dt.Columns.Add("RuleBalanceCycle", typeof(string));
foreach (DataRow row in dt.Rows)
{
if (row["SettleType"].ToString().Equals("手动"))
{
row["RuleBalanceCycle"] = row["BillingCycle"].ToString();
}
else if (row["SettleType"].ToString().Equals("自动"))
{
switch (row["BillingCycle"].ToString())
{
case "每周":
row["RuleBalanceCycle"] = row["SettleType"].ToString() + "," + row["BillingCycle"].ToString() + row["SettleWeeklyDay"].ToString();
break;
case "每月":
row["RuleBalanceCycle"] = row["SettleType"].ToString() + "," + row["BillingCycle"].ToString() + row["SettleMonthlyDay"].ToString() + "日";
break;
default:
row["RuleBalanceCycle"] = row["SettleType"].ToString() + "," + row["BillingCycle"].ToString();
break;
}
}
}
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
private void AddUnbilledRuleList(UnbilledRuleListQueryFilter filter, DynamicQuerySqlBuilder sb, CustomDataCommand cmd)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vendor.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode);
if (filter.VendorSysNo.HasValue)
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"vendor.SysNo",
DbType.String,
"@SysNo",
QueryConditionOperatorType.Equal,
filter.VendorSysNo);
}
if (!string.IsNullOrEmpty(filter.EIMSType))
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"ruleMaster.EIMSType",
DbType.String,
"@EIMSType",
QueryConditionOperatorType.Equal,
filter.EIMSType);
}
if (!string.IsNullOrEmpty(filter.PMUserSysNo))
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"ruleMaster.PM",
DbType.String,
"@PMSysNo",
QueryConditionOperatorType.Equal,
filter.PMUserSysNo);
}
cmd.AddInputParameter("@PageSize", DbType.Int32, filter.PagingInfo.PageSize);
cmd.AddInputParameter("@PageIndex", DbType.Int32, filter.PagingInfo.PageIndex);
cmd.CommandText = sb.BuildQuerySql();
}
/// <summary>
/// 初始化
/// </summary>
private void IniPageData()
{
this.SearchCondition.DataContext = m_queryRequest = new UnbilledRuleListQueryFilter();
BindComboBoxData();
}
public QueryResult QueryUnbilledRuleList(UnbilledRuleListQueryFilter filter)
{
return(QueryList <UnbilledRuleListQueryFilter>(filter, ObjectFactory <IComprehensiveReportDA> .Instance.UnbilledRuleListQuery));
}
public void ExportUnbilledRuleList(UnbilledRuleListQueryFilter filter, ColumnSet[] columns)
{
filter.CompanyCode = CPApplication.Current.CompanyCode;
restClient.ExportFile("/ExternalSYSService/ExternalSYS/QueryUnbilledRuleList", filter, columns);
}
