linuxredhat

C# Code

using System;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Data;
using System.Data.SqlClient;

namespace wang.lx
{
class HXGL_HXGL:Window
{
ListView lv;
dbHelper db = new dbHelper();
GridView gv;
GridViewColumn gvc;
public HXGL_HXGL()
{
Title = "橫向項目管理";
Grid grid = new Grid();
SizeToContent = SizeToContent.Height;
Width = 750;
grid.Margin = new Thickness(10);
Content = grid;

RowDefinition rd = new RowDefinition();
rd.Height = GridLength.Auto;
grid.RowDefinitions.Add(rd);

rd = new RowDefinition();
rd.Height = GridLength.Auto;
grid.RowDefinitions.Add(rd);

WrapPanel wrap = new WrapPanel();
Button btn1 = new Button();
btn1.Content = "增加";
btn1.Click += HXGL_btnOnClick;
btn1.Height = btn1.Width = 40;
wrap.Children.Add(btn1);

Button btn2 = new Button();
btn2.Height = btn2.Width = 40;
btn2.Content = "修改";
wrap.Children.Add(btn2);

Button btn3 = new Button();
btn3.Height = btn3.Width = 40;
btn3.Content = "刪除";
wrap.Children.Add(btn3);

grid.Children.Add(wrap);

ScrollViewer sv = new ScrollViewer();
sv.HorizontalScrollBarVisibility = ScrollBarVisibility.Auto;
sv.Height = this.Height - btn1.Height - 10;
grid.Children.Add(sv);
Grid.SetRow(sv, 1);
lv = new ListView();
sv.Content = lv;
Data_Init();

gv = new GridView();
gv.AllowsColumnReorder = true;
gv.ColumnHeaderToolTip = "橫向項目管理";
lv.View = gv;

//可以向如下方式添加，但相當繁瑣，代碼重復次數超過兩次，最好寫成函數
//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("name");
//gvc.Header = "項目名稱";
//gvc.Width = 100;
//gv.Columns.Add(gvc);

//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("XMXH");
//gvc.Header = "項目序號";
//gvc.Width = 100;
//gv.Columns.Add(gvc);

//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("fzr");
//gvc.Header = "負責人";
//gvc.Width = 100;
//gv.Columns.Add(gvc);

//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("HTJF");
//gvc.Header = "合同經費";
//gvc.Width = 100;
//gv.Columns.Add(gvc);

//gvc = new GridViewColumn();
//gvc.DisplayMemberBinding = new Binding("DKJE");
//gvc.Header = "到款金額";
//gvc.Width = 100;
//gv.Columns.Add(gvc);

//利用數組批量添加，注意，此處必須和讀取的字段大小寫保持一致，否則無法顯示
string[] bstr = {"Name","XMXH","FZR","HTJF","DKJE", "HTBH", "FZRYB", "SBJF", "DKSJ", "XMLB", "LXSJ", "QDRQ", "JTSJ", "WTDW", "YXQX", "XMJJ","XMWCQKJJ", "XMCJZ" };
string[] headstr = {"項目名稱","項目序號","負責人","合同經費","到款金額", "合同編號", "負責人院別", "設備經費", "到款時間", "項目類別", "立項時間", "簽訂日期", "結題時間", "委托單位", "有效期限", "項目簡介","項目完成情況簡介", "項目參加者"};
AddColumn(bstr, headstr);
}
//批量添加函數
protected void AddColumn(string[] bstr, string[] headstr)
{
for(int i=0;i<bstr.Length;i++)
{
gvc = new GridViewColumn();
gvc.DisplayMemberBinding = new Binding(bstr[i]);
gvc.Header = headstr[i];
//gvc.Width = 100;
gv.Columns