void ConditionSetResult_LoadingDataSource(object sender, LoadingDataEventArgs e)
{
List <AccessoriesQueryCondition> tempList = new List <AccessoriesQueryCondition>();
facade.GetAccessoriesQueryConditionBySysNo(SysNo, (obj, arg) =>
{
if (arg.FaultsHandle())
{
return;
}
this.ConditionSetResult.ItemsSource = arg.Result.Rows;
tempList.Add(new AccessoriesQueryCondition()
{
ConditionName = "--请选择--", SysNo = 0
});
foreach (var item in arg.Result.Rows)
{
tempList.Add(new AccessoriesQueryCondition()
{
ConditionName = item.ConditionName, Priority = (PriorityType)item.Level, SysNo = item.SysNo
});
}
dynamic d = this.ConditionSetResult.ItemsSource as dynamic;
list = new List <ProductAccessoriesQueryConditionVM>();
foreach (var item in d)
{
list.Add(new ProductAccessoriesQueryConditionVM()
{
Condition = new AccessoriesQueryCondition()
{
ConditionName = item.ConditionName, Priority = (PriorityType)item.Level, SysNo = item.SysNo
},
ParentCondition = new AccessoriesQueryCondition()
{
ConditionName = item.ParentConditionName, SysNo = item.ParentSysNo
},
Priority = (PriorityType)item.Level
});
}
model.ParentConditionList = tempList;
cboParentConditionList.SelectedIndex = 0;
});
}
public ProductAccessoriesQueryConditionPreView()
{
InitializeComponent();
this.Loaded += (sender, e) =>
{
facade = new ProductAccessoriesFacade();
ConditionList = new List <ProductAccessoriesQueryConditionVM>();
ConditionValueList1 = new List <AccessoriesConditionValue>();
ConditionValueList2 = new List <AccessoriesConditionValue>();
ConditionValueList3 = new List <AccessoriesConditionValue>();
ConditionValueList4 = new List <AccessoriesConditionValue>();
IsTreeQuery = false;
facade.GetAccessoriesQueryConditionBySysNo(MaterSysNo, (obj, arg) =>
{
if (arg.FaultsHandle())
{
return;
}
foreach (var item in arg.Result.Rows)
{
IsTreeQuery = item.IsTreeQuery == "Y";
ConditionList.Add(new ProductAccessoriesQueryConditionVM()
{
Condition = new AccessoriesQueryCondition()
{
ConditionName = item.ConditionName, Priority = (PriorityType)item.Level, SysNo = item.SysNo
},
ParentCondition = new AccessoriesQueryCondition()
{
ConditionName = item.ParentConditionName, SysNo = item.ParentSysNo
},
Priority = (PriorityType)item.Level
});
}
BingControl();
});
};
}
public ProductAccessoriesQueryConditionValueMaintain()
{
InitializeComponent();
ConditionValueSetResult.LoadingDataSource += new EventHandler <LoadingDataEventArgs>(ConditionValueSetResult_LoadingDataSource);
this.Loaded += (sender, e) =>
{
model = new ProductAccessoriesConditionValueQueryVM();
ConditionList = new List <AccessoriesQueryCondition>()
{
new AccessoriesQueryCondition()
{
ConditionName = "--全部--", SysNo = 0
}
};
model.MasterSysNo = MaterSysNo;
facade = new ProductAccessoriesFacade();
facade.GetAccessoriesQueryConditionBySysNo(MaterSysNo, (obj, arg) =>
{
if (arg.FaultsHandle())
{
return;
}
dynamic d = arg.Result.Rows;
foreach (var item in d)
{
ConditionList.Add(new AccessoriesQueryCondition()
{
ConditionName = item.ConditionName, SysNo = item.SysNo, MasterSysNo = MaterSysNo, ParentSysNo = item.ParentSysNo
});
}
model.ConditionList = ConditionList;
this.DataContext = model;
cboCondition.SelectedIndex = 0;
this.ConditionValueSetResult.Bind();
});
};
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnExcelExporter_Click(object sender, RoutedEventArgs e)
{
dynamic d = this.ProductAccessoriesResult.SelectedItem as dynamic;
bool IsTreeQuery = d.IsTreeQuery == "Y";
ColumnSet col = new ColumnSet();
List <ProductAccessoriesQueryConditionVM> ConditionList = new List <ProductAccessoriesQueryConditionVM>();
//根据SysNo得到所有条件，动态生成列名
facade.GetAccessoriesQueryConditionBySysNo((int)d.SysNo, (obj, arg) =>
{
if (arg.FaultsHandle())
{
return;
}
foreach (var item in arg.Result.Rows)
{
ConditionList.Add(new ProductAccessoriesQueryConditionVM()
{
Condition = new AccessoriesQueryCondition()
{
ConditionName = item.ConditionName, Priority = (PriorityType)item.Level, SysNo = item.SysNo
},
ParentCondition = new AccessoriesQueryCondition()
{
ConditionName = item.ParentConditionName, SysNo = item.ParentSysNo
},
Priority = (PriorityType)item.Level
});
}
int index = 0;
if (IsTreeQuery)
{
foreach (var item in ConditionList)
{
string title = item.Condition.ConditionName + "编号";
if (index == 0)
{
col.Insert(0, "FirstSysNo", title, 15);
col.Insert(1, "FirstValue", item.Condition.ConditionName, 25);
}
if (index == 1)
{
col.Insert(2, "SecondSysNo", title, 15);
col.Insert(3, "SecondValue", item.Condition.ConditionName, 25);
}
if (index == 2)
{
col.Insert(4, "ThirdSysNo", title, 15);
col.Insert(5, "ThirdValue", item.Condition.ConditionName, 25);
}
if (index == 3)
{
col.Insert(6, "FourthSysNo", title, 15);
col.Insert(7, "FourthValue", item.Condition.ConditionName, 25);
}
index = index + 1;
}
}
else
{
col.Insert(0, "ConditionSysNo", "条件编号");
col.Insert(1, "ConditionName", "条件");
col.Insert(2, "ConditionValueSysNo", "选项值编号");
col.Insert(3, "ConditionValue", "选项值");
col.Insert(4, "Producut", "商品");
}
if (ConditionList.Count > 0 && IsTreeQuery)
{
col.Insert(ConditionList.Count * 2, "Producut", "商品");
}
facade.GetAccessoriesQueryExcelOutput((int)d.SysNo, (string)d.IsTreeQuery, new ColumnSet[] { col });
});
}