/// <summary>
/// 读取数据库数据到listbox
/// </summary>
/// <param name="cloum">列名</param>
/// <param name="tab">表名</param>
/// <param name="listbox">listbox名</param>
private void FreshUI(string cloum, string tab, string listbox)
{
/*
* dataset.Clear();
*
* dataset = ServiceContainer.GetService<IGasDAL>().QueryData(cloum, tab);
*
* int j = 0;
* foreach (DataRow dr in dataset.Tables[0].Rows)
* {
* if (listbox == "lbox_Type")
* {
*
* lbox_Type.Items.Add(dataset.Tables[0].Rows[j][0]);
* }
* else if (listbox == "lbox_Equip")
* {
* //dataset = ServiceContainer.GetService<IGasDAL>().QueryData(cloum, tab);
* if (dataset.Tables[0].Rows[j][6].ToString() == "1")
* lbox_Equip.Items.Add(dataset.Tables[0].Rows[j][0]);
* }
* j++;
* }
*/
//if (listbox == "lbox_Gasometer")
//{}
lbox_Gasometer.Items.Clear();
panel1.Controls.Clear();
dataset.Clear();
dataset = ServiceContainer.GetService <IGasDAL>().QueryData(tab);
int j = 0;
foreach (DataRow dr in dataset.Tables[0].Rows)
{
//Listbox
lbox_Gasometer.Items.Add(dataset.Tables[0].Rows[j][cloum]);
//Panel
Panel panelBar = new Panel();
panel1.Controls.Add(panelBar);
panelBar.BorderStyle = BorderStyle.FixedSingle;
panelBar.Location = new Point(10, 10 + panel1.Height * j / 4);
panelBar.Size = new Size(this.ClientRectangle.Width, this.ClientRectangle.Height / 4);
banner bar = new banner();
bar.LabelText = dataset.Tables[0].Rows[j][cloum].ToString() + "数量：";
bar.UDNum = int.Parse(dataset.Tables[0].Rows[j]["GasometerNum"].ToString());
panelBar.Controls.Add(bar);
j++;
}
}
/// <summary>
/// 读取数据库数据到listbox
/// </summary>
/// <param name="cloum">列名</param>
/// <param name="tab">表名</param>
/// <param name="listbox">listbox名</param>
private void FreshUI(string cloum, string tab, string listbox)
{
/*
dataset.Clear();
dataset = ServiceContainer.GetService<IGasDAL>().QueryData(cloum, tab);
int j = 0;
foreach (DataRow dr in dataset.Tables[0].Rows)
{
if (listbox == "lbox_Type")
{
lbox_Type.Items.Add(dataset.Tables[0].Rows[j][0]);
}
else if (listbox == "lbox_Equip")
{
//dataset = ServiceContainer.GetService<IGasDAL>().QueryData(cloum, tab);
if (dataset.Tables[0].Rows[j][6].ToString() == "1")
lbox_Equip.Items.Add(dataset.Tables[0].Rows[j][0]);
}
j++;
}
*/
//if (listbox == "lbox_Gasometer")
//{}
lbox_Gasometer.Items.Clear();
panel1.Controls.Clear();
dataset.Clear();
try
{
dataset = ServiceContainer.GetService<IGasDAL>().QueryData(tab);
}
catch (Exception ex)
{
Console.WriteLine("查询异常" + ex.Message);
return;
}
int j = 0;
foreach (DataRow dr in dataset.Tables[0].Rows)
{
//Listbox
lbox_Gasometer.Items.Add(dataset.Tables[0].Rows[j][cloum]);
//Panel
Panel panelBar = new Panel();
panel1.Controls.Add(panelBar);
panelBar.BorderStyle = BorderStyle.FixedSingle;
panelBar.Location = new Point(10, 10 + panel1.Height * j / 4);
panelBar.Size = new Size(this.ClientRectangle.Width, this.ClientRectangle.Height / 4);
banner bar = new banner();
//从数据库中读取数据存放到控件中显示
bar.LabelText = dataset.Tables[0].Rows[j][cloum].ToString();
bar.UDNum = int.Parse(dataset.Tables[0].Rows[j]["GasometerNum"].ToString());
panelBar.Controls.Add(bar);
j++;
}
}