private void LoadXmlTable()
{
cmb_modelList.ValueMember = "Value";
cmb_modelList.DisplayMember = "Text";
string xmlPath = Application.StartupPath + @"\ExcelModelConfig\TableList.xml";
XmlDocument xmlDoc = new XmlDocument();
if (!File.Exists(xmlPath))
{
throw new Exception("配置文件不存在，路径：" + xmlPath);
}
xmlDoc.Load(xmlPath);
XmlNodeList rootNode = xmlDoc.SelectSingleNode("root").ChildNodes;
List <ComboboxInfo> cmbInfoL = new List <ComboboxInfo>();
foreach (XmlNode node in rootNode)
{
string name = ((XmlElement)node).GetElementsByTagName("name")[0].InnerText.ToString();
string title = ((XmlElement)node).GetElementsByTagName("title")[0].InnerText.ToString();
ComboboxInfo ci = new ComboboxInfo();
ci.Text = title;
ci.Value = name;
cmbInfoL.Add(ci);
}
cmb_modelList.DataSource = cmbInfoL;
if (!string.IsNullOrEmpty(cmb_modelList.SelectedValue.ToString()))
{
table_import = cmb_modelList.SelectedValue.ToString();
LoadXMLTableColumn(table_import);
}
}
/// <summary>
/// 绑定告警类型Combobox3数据源
/// </summary>
private void BindGjlxCombobox3()
{
List <ComboboxInfo> infoList = new List <ComboboxInfo>();
//本地数据
ComboboxInfo info1 = new ComboboxInfo()
{
ID = "1", Name = "初次绑定"
}; //对应AnchorEnum中枚举 ERfid_OperationType
ComboboxInfo info2 = new ComboboxInfo()
{
ID = "2", Name = "物联绑定"
};
ComboboxInfo info3 = new ComboboxInfo()
{
ID = "3", Name = "物资不存在"
};
ComboboxInfo info4 = new ComboboxInfo()
{
ID = "4", Name = "物联解绑"
};
ComboboxInfo info5 = new ComboboxInfo()
{
ID = "5", Name = "丢失"
};
infoList.Add(info1);
infoList.Add(info2);
infoList.Add(info3);
infoList.Add(info4);
infoList.Add(info5);
comboBox3.DataSource = infoList; //combobox3：告警查询tabpage页 告警类型combobox
comboBox3.ValueMember = "ID";
comboBox3.DisplayMember = "Name";
comboBox3.SelectedIndex = -1;
}
/// <summary>
/// 所属单位combobox绑定数据源---暂时默认单项 浦东120
/// </summary>
private void BindSsdwCombobox()
{
List <ComboboxInfo> infoList = new List <ComboboxInfo>();
ComboboxInfo info1 = new ComboboxInfo()
{
ID = "1", Name = "浦东120"
}; //本地数据
infoList.Add(info1);
comboBox1.DataSource = infoList; //comboBox1：告警列表tabpage页 所属单位combobox
comboBox1.ValueMember = "ID";
comboBox1.DisplayMember = "Name";
comboBox1.SelectedIndex = 0;
}
/// <summary>
/// 获取对象名称combobox数据源List
/// </summary>
/// <returns></returns>
public List <ComboboxInfo> GetDxmcComboboxList()
{
List <ComboboxInfo> list = new List <ComboboxInfo>();
StringBuilder sb = new StringBuilder();
sb.Append(" select ID=仓库编码,Name=仓库名称,读写器ID=扫描仪串号 ");
sb.Append(@"
from FIXED_Storage fs");
sb.Append(@"
where 1=1 ");
sb.Append(@"
and 是否有效=1 ");
sb.Append(@"
and 父级仓库编码 in(" + Convert.ToInt32(Utility.AnchorEnum.EParentStorageID.车辆) + ""); //对应车辆下的子仓库
sb.Append(@"
," + Convert.ToInt32(Utility.AnchorEnum.EParentStorageID.分站) + ") "); //对应分站下的子仓库
sb.Append(@"
order by 父级仓库编码,仓库编码 ");
try
{
DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.Text, sb.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ComboboxInfo info = new ComboboxInfo();
info.ID = dr["ID"].ToString();
info.Name = dr["Name"].ToString();
list.Add(info);
}
}
return(list);
}
catch (Exception ex)
{
LogUtility.Error("DealDataGridViewQueryDAL/GetDxmcComboboxList", "获取对象名称下拉列表出错：" + ex.Message);
return(null);
}
}
/// <summary>
/// 获取物品名称combobox数据源list
/// </summary>
/// <returns></returns>
public List <ComboboxInfo> GetWpmcComboboxList()
{
List <ComboboxInfo> list = new List <ComboboxInfo>();
StringBuilder sb = new StringBuilder();
sb.Append(" select ID=编码,Name=资产名称 ");
sb.Append(@"
from FIXED_Matetial fm");
sb.Append(@"
where 1=1 ");
sb.Append(@"
and 是否报废=0 "); //过滤报废物资
sb.Append(@"
and (是否丢失=0 or 是否丢失 is null) "); //过滤丢失物资
sb.Append(@"
order by 购建日期 ");
try
{
DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.Text, sb.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ComboboxInfo info = new ComboboxInfo();
info.ID = dr["ID"].ToString();
info.Name = dr["Name"].ToString();
list.Add(info);
}
}
return(list);
}
catch (Exception ex)
{
LogUtility.Error("DealDataGridViewQueryDAL/GetWpmcComboboxList", "获取物品名称下拉列表出错：" + ex.Message);
return(null);
}
}
/// <summary>
/// 绑定处理状态Combobox数据源
/// </summary>
private void BindClztCombobox()
{
List <ComboboxInfo> infoList = new List <ComboboxInfo>();
//本地数据
ComboboxInfo info1 = new ComboboxInfo()
{
ID = "1", Name = "未处理"
}; //对应AnchorEnum中枚举 ERfid_OperationType
ComboboxInfo info2 = new ComboboxInfo()
{
ID = "2", Name = "已绑定设备"
};
ComboboxInfo info3 = new ComboboxInfo()
{
ID = "3", Name = "已物联绑定"
};
ComboboxInfo info4 = new ComboboxInfo()
{
ID = "4", Name = "已解绑"
};
ComboboxInfo info5 = new ComboboxInfo()
{
ID = "5", Name = "已丢失"
};
infoList.Add(info1);
infoList.Add(info2);
infoList.Add(info3);
infoList.Add(info4);
infoList.Add(info5);
comboBox7.DataSource = infoList; //combobox6：告警列表tabpage页 告警类型combobox
comboBox7.ValueMember = "ID";
comboBox7.DisplayMember = "Name";
comboBox7.SelectedIndex = -1;
}
public static extern Boolean GetComboBoxInfo(
IntPtr hwnd,
ref ComboboxInfo pcbi);
