using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
namespace SiaSun.LMS.WPFClient.UC
{
/// <summary>
/// ucSplitPropertyPanel.xaml 的交互逻辑
/// </summary>
public partial class ucSplitPropertyPanel : UserControl
{
#region ------拆分组合列属性
private DataTable tableSplit = null;
private string strSplitGroupHeader = string.Empty;
private string strSplitGroupColumn = string.Empty;
private string strSplitPropertyColumn = string.Empty;
private string strSplitPropertyType = string.Empty;
/// <summary>
/// 不同TapPage页显示的数据不同的分组依据,如：表V_PLAN_LIST中的GOODS_TYPE_ID
/// </summary>
public string U_SplitGroupColumn
{
get { return strSplitGroupColumn; }
set { strSplitGroupColumn = value; }
}
/// <summary>
/// 不同TapPage页显示的标题,如：表GOODS_TYPE中的GOODS_TYPE_NAME
/// </summary>
public string U_SplitGroupHeader
{
get { return strSplitGroupHeader; }
set { strSplitGroupHeader = value; }
}
/// <summary>
/// 数据源中所对应的拆分属性列名，如：PLAN_LIST表中的GOODS_PROPERTY
/// </summary>
public string U_SplitPropertyColumn
{
get { return strSplitPropertyColumn; }
set { strSplitPropertyColumn = value; }
}
/// <summary>
/// 属性划分依据类别,不同类型对应显示的属性不同，如：表GOODS_TYPE
/// </summary>
public string U_SplitPropertyType
{
get { return strSplitPropertyType; }
set { strSplitPropertyType = value; }
}
#endregion
public ucSplitPropertyPanel()
{
InitializeComponent();
}
/// <summary>
/// 获得拆分属性数据源
/// </summary>
private DataTable GetSplitTable(string SplitPropertyKey)
{
//获得拆分列数据源
DataTable tableSplitSource = MainApp._I_BaseService.GetList(string.Format("select * from goods_property where goods_property_flag='1'and goods_type_id = {0} order by goods_property_order", SplitPropertyKey));
//设置别名
tableSplitSource.Columns["GOODS_PROPERTY_FIELD"].ColumnName = "Column";
tableSplitSource.Columns["GOODS_PROPERTY_NAME"].ColumnName = "Header";
tableSplitSource.Columns["GOODS_PROPERTY_DATASOURCE"].ColumnName = "DataBind";
tableSplitSource.Columns["GOODS_PROPERTY_FIELDTYPE"].ColumnName = "ControlType";
tableSplitSource.Columns["GOODS_PROPERTY_VALID"].ColumnName = "Validation";
return tableSplitSource;
}
/// <summary>
/// 初始化控件
/// </summary>
public void U_InitControl()
{
//检查是否设置拆分列
if (strSplitGroupColumn.Length == 0 || strSplitGroupHeader.Length == 0 || strSplitPropertyColumn.Length == 0 || strSplitPropertyType.Length == 0)
return;
//设置数据源属性
cmbGroup.DisplayMemberPath = strSplitGroupHeader;
cmbGroup.SelectedValuePath = strSplitGroupColumn;
try
{
using (DataTable tableSource = MainApp._I_BaseService.GetList(string.Format("SELECT {0},{1} FROM {2}", strSplitGroupColumn, strSplitGroupHeader, strSplitPropertyType)))
{
//插入新值
DataRow rowNew = tableSource.NewRow();
rowNew[0] = 0;
rowNew[1] = "全部";
tableSource.Rows.InsertAt(rowNew,0);
cmbGroup.ItemsSource = tableSource.DefaultView;
if (cmbGroup.HasItems)
{
cmbGroup.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MainApp._MessageDialog.ShowException(ex);
}
}
//类型更改显示不同的属性信息
private void cmbGroup_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//清空
this.U_Clear();
//获得拆分数据源
tableSplit = GetSplitTable(cmbGroup.SelectedValue.ToString());
//判断是否设置了该种类型的物料拆分列的信息
if (tableSplit.Rows.Count > 0)
{
//转化为数组
DataRow[] arSplitRow = tableSplit.Rows.Cast<DataRow>().ToArray<DataRow>();
//排序
var query = from rowSplit in arSplitRow select rowSplit;
StringBuilder strBuilderSplit = new StringBuilder();
try
{
//添加控件
foreach (DataRow rowSplit in query)
{
switch (rowSplit["ControlType"].ToString().ToLower())
{
case "bool":
AddCheckBoxControl(rowSplit);
break;
case "combox":
AddComboBoxControl(rowSplit);
break;
case "element":
AddElementComboBoxControl(rowSplit);
break;
default:
AddTextBoxControl(rowSplit);
break;
}
}
}
catch (Exception ex)
{
MainApp._MessageDialog.ShowException(ex);
}
}
}
#region ------Add Controls
//添加标题
private void AddHeader(string Header,StackPanel panel)
{
TextBlock txtHeader = new TextBlock();
txtHeader.Text = string.Format("{0}：",Header);
txtHeader.VerticalAlignment = System.Windows.VerticalAlignment.Center;
txtHeader.Margin = new Thickness(5);
panel.Children.Add(txtHeader);
}
//Add CheckBox
private void AddCheckBoxControl(DataRow rowSplit)
{
StackPanel panel = new StackPanel();
panel.Orientation = Orientation.Horizontal;
panel.Tag = rowSplit;
this.panelItem.Children.Add(panel);
//添加标题
this.AddHeader(rowSplit["header"].ToString(),panel);
//添加控件
CheckBox chkBox = new CheckBox();
chkBox.Margin = new Thickness(5);
chkBox.IsChecked = (rowSplit.IsNull("defaultvalue") && Convert.ToInt32(rowSplit["defaultvalue"].ToString()) == 0) ? false : true;
panel.Children.Add(chkBox);
}
//Add TextBox Control
private void AddTextBoxControl(DataRow rowSplit)
{
StackPanel panel = new StackPanel();
panel.Orientation = Orientation.Horizontal;
panel.Tag = rowSplit;
this.panelItem.Children.Add(panel);
//添加标题
this.AddHeader(rowSplit["header"].ToString(), panel);
//添加控件
TextBox textBox = new TextBox();
textBox.Width = 150;
textBox.Margin = new Thickness(5,0,5,5);
//textBox.Text = rowSplit["defaultvalue"].ToString();
panel.Children.Add(textBox);
}
//Add ComboBox Control
private void AddComboBoxControl(DataRow rowSplit)
{
StackPanel panel = new StackPanel();
panel.Orientation = Orientation.Horizontal;
panel.Tag = rowSplit;
this.panelItem.Children.Add(panel);
//添加标题
this.AddHeader(rowSplit["header"].ToString(), panel);
//添加控件
ComboBox cmb = new ComboBox();
cmb.Width = 150;
cmb.Margin = new Thickness(5, 0, 5, 5);
cmb.DisplayMemberPath = "NAME".ToLower();
cmb.SelectedValuePath = "VALUE".ToLower();
panel.Children.Add(cmb);
//设置数据源
cmb.ItemsSource = new CustomerDescriptions().GetComboBoxDataTable(rowSplit["key"].ToString()).DefaultView;
//默认值
//if (rowSplit.IsNull("defaultvalue"))
// cmb.SelectedIndex = -1;
//else
// cmb.SelectedValue = rowSplit["defaultvalue"];
}
//Add ElementBox Control
private void AddElementComboBoxControl(DataRow rowSplit)
{
StackPanel panel = new StackPanel();
panel.Orientation = Orientation.Horizontal;
panel.Tag = rowSplit;
this.panelItem.Children.Add(panel);
//添加标题
this.AddHeader(rowSplit["header"].ToString(), panel);
//添加控件
ComboBox cmb = new ComboBox();
cmb.Margin = new Thickness(5, 0, 5, 5);
cmb.Width = 150;
panel.Children.Add(cmb);
//解析Item
foreach (string s in rowSplit["key"].ToString().Split('|'))
{
//分解字符串添加ITEM数据
if (s.TrimEnd().Length > 0)
{
cmb.Items.Add(s.TrimEnd());
}
}
//默认值
//if (rowSplit.IsNull("defaultvalue"))
// cmb.SelectedIndex = -1;
//else
// cmb.SelectedValue = rowSplit["defaultvalue"];
}
#endregion
/// <summary>
/// 清空控件
/// </summary>
public void U_Clear()
{
this.panelItem.Children.Clear();
}
/// <summary>
/// 获得拆分属性组合值
/// </summary>
public string U_GetSplitPropertyValue()
{
StringBuilder strSql = new StringBuilder();
foreach (DependencyObject control in this.panelItem.Children)
{
if (control is StackPanel)
{
StackPanel panel = control as StackPanel;
if (panel.Children.Count == 2)
{
DataRow rowSplit = panel.Tag as DataRow;
if (rowSplit != null)
{
//获得控件类型
string strControlType = rowSplit["ControlType"].ToString().ToLower();
//判断控件类型
switch (strControlType)
{
case "bool":
CheckBox chkBox = panel.Children[1] as CheckBox;
if (chkBox != null)
{
//if (strSql.Length == 0)
// strSql.Append(Convert.ToInt32(chkBox.IsChecked.ToString()));
//else
// strSql.Append("|").Append(Convert.ToInt32(chkBox.IsChecked.ToString()));
strSql.Append(string.Format(" AND {0} {1}",
rowSplit["Column"].ToString(),
string.IsNullOrEmpty(chkBox.IsChecked.ToString()) ? " like '%'" : string.Format(" = '{0}'", Convert.ToInt32(chkBox.IsChecked.ToString()))));
}
break;
case "combox":
case "element":
ComboBox cmbBox = panel.Children[1] as ComboBox;
if (cmbBox != null)
{
string strValue = strControlType == "combox" ? cmbBox.SelectedValue.ToString() : cmbBox.Text;
//if (strSql.Length == 0)
// strSql.Append(strValue);
//else
// strSql.Append("|").Append(strValue);
strSql.Append(string.Format(" AND {0} {1}",
rowSplit["Column"].ToString(),
string.IsNullOrEmpty(strValue) ? " like '%'" : string.Format(" = '{0}'", strValue)));
}
break;
default:
TextBox textBox = panel.Children[1] as TextBox;
if (textBox != null)
{
//if (strSql.Length == 0)
// strSql.Append(textBox.Text);
//else
// strSql.Append("|").Append(textBox.Text);
strSql.Append( string.Format(" AND {0} {1}",
rowSplit["Column"].ToString(),
string.IsNullOrEmpty(textBox.Text) ? " like '%'" : string.Format(" = '{0}'", textBox.Text)));
}
break;
}
}
}
}
}
return strSql.Length == 0 ? "" : strSql.ToString();
}
/// <summary>
/// 获得组合属性查询条件
/// </summary>
public string U_GetSplitPropertyWhere()
{
string strWhere = Convert.ToInt32(this.cmbGroup.SelectedValue) == 0 ? "1=1" : string.Format("{0}='{1}'",strSplitGroupColumn,this.cmbGroup.SelectedValue.ToString());
return string.Format("{0} {1}", strWhere, this.U_GetSplitPropertyValue());
}
}
}