//获得数据库数据
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;
}
