//获得数据库数据
private void GetUserData()
{
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string type = MainWindow.wfmodel.WFModel_Type;
string sql = "select name, description,type from template where type = '"+type+"'";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
TemplateModel um = new TemplateModel();
um.name = dr["name"].ToString();
um.desc = dr["description"].ToString();
um.type = dr["type"].ToString();
models.Add(um);
}
view.Source = models;
this.listView1.DataContext = view;
}
//打开操作
private void Confirm_Click(object sender, RoutedEventArgs e)
{
//得到新的添加项
selected = listView1.SelectedItem as TemplateModel;
if (selected == null)
{
return;
}
this.Visibility = System.Windows.Visibility.Hidden;
}
