//获得数据库数据 void GetTemplateData() { models.Clear(); MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); try { DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string sql = "select model_name,owner,model_content,lastedit_time,model_disc,create_time from wf_model"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { WFModel wfm = new WFModel(); wfm.WFModel_CreateTime = dr["create_time"].ToString(); wfm.WFModel_LasteditTime = dr["lastedit_time"].ToString(); wfm.WFModel_Name = dr["model_name"].ToString(); wfm.WFModel_Owner = dr["owner"].ToString(); string test = dr["model_content"].ToString(); if (dr["model_content"] == null || dr["model_content"].ToString().Length<=0) { wfm.WFModel_Content = ""; }else wfm.WFModel_Content = Encoding.Default.GetString((Byte[])dr["model_content"]); models.Add(wfm); } view.Source = models; this.listView1.DataContext = view; } catch (Exception e) { MessageBox.Show("数据库连接失败,请检查网络连接或者数据库配置"); return; } }
//打开操作 private void Confirm_Click(object sender, RoutedEventArgs e) { //得到新的添加项 WFModel selected = listView1.SelectedItem as WFModel; selectedModel = selected; if (selected == null) { return; } selectName = selected.WFModel_Name; selectContent = selected.WFModel_Content; if (selectContent.Length > 0) { // StreamWriter sw = new StreamWriter("template\\temp.xaml", false, Encoding.UTF8); // sw.WriteLine(content); // sw.Close(); //写文件: StreamWriter sw = new StreamWriter("template\\temp.xaml", false, Encoding.UTF8);// sw.Write(selectContent); // FileStream fs = new FileStream("template\\temp.xaml", FileMode.Create); // String str = new String(selectContent,Encoding.ASCII); // Byte[] decoded = str.getBytes("UTF-8"); //开始写入 // fs.Write(selectContent, 0, selectContent.Length); //清空缓冲区、关闭流 sw.Flush(); sw.Close(); selectPath = "template\\temp.xaml"; } else { selectPath = null; } this.Visibility = System.Windows.Visibility.Hidden; }