using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?AnySellByCross
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????SqlConnection?con?=?new?SqlConnection（“Server=（local）;database=db_09;Uid=sa;Pwd=“）;
????????????SqlDataAdapter?dap?=?new?SqlDataAdapter（“SELECT?所在部門?“
????????????????+?“SUM（CASE?員工姓名?WHEN?‘明日‘?THEN?銷售業績?ELSE?NULL?END）AS?[明日]“
????????????????+?“SUM（CASE?員工姓名?WHEN?‘科技‘?THEN?銷售業績?ELSE?NULL?END）as?[科技]?“
????????????????+?“SUM（CASE?員工姓名?WHEN?‘明日科技‘?THEN?銷售業績?ELSE?NULL?END）AS?[明日科技]“
????????????????+?“SUM（CASE?員工姓名?WHEN?‘明日科技公司‘?THEN?銷售業績?ELSE?NULL?END）AS?[明日科技公司]“
????????????????+?“SUM（CASE?員工姓名?WHEN?‘明日科技有限公司‘?THEN?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????932??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross.sln
?????文件???????26624??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross.suo
?????文件????????3774??2009-02-11?11:25??sj\01\AnySellByCross\AnySellByCross\AnySellByCross.csproj
?????文件????????1436??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\Form1.cs
?????文件????????3191??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\Form1.Designer.cs
?????文件????????5814??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\Form1.resx
?????文件?????????495??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross\Program.cs
?????文件????????9728??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\bin\Debug\AnySellByCross.exe
?????文件???????19968??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\bin\Debug\AnySellByCross.pdb
?????文件???????14328??2009-02-11?11:25??sj\01\AnySellByCross\AnySellByCross\bin\Debug\AnySellByCross.vshost.exe
?????文件?????????490??2007-07-21?01:33??sj\01\AnySellByCross\AnySellByCross\bin\Debug\AnySellByCross.vshost.exe.manifest
?????文件?????????861??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\obj\Debug\AnySellByCross.csproj.FileListAbsolute.txt
?????文件?????????847??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\obj\Debug\AnySellByCross.csproj.GenerateResource.Cache
?????文件????????9728??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\obj\Debug\AnySellByCross.exe
?????文件?????????180??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\obj\Debug\AnySellByCross.Form1.resources
?????文件???????19968??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\obj\Debug\AnySellByCross.pdb
?????文件?????????180??2009-02-11?11:26??sj\01\AnySellByCross\AnySellByCross\obj\Debug\AnySellByCross.Properties.Resources.resources
?????文件????????1384??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross\Properties\AssemblyInfo.cs
?????文件????????2878??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross\Properties\Resources.Designer.cs
?????文件????????5612??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross\Properties\Resources.resx
?????文件????????1099??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross\Properties\Settings.Designer.cs
?????文件?????????249??2009-02-11?11:05??sj\01\AnySellByCross\AnySellByCross\Properties\Settings.settings
?????文件?????????950??2009-02-11?11:26??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross.sln
?????文件???????25600??2009-02-11?12:55??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross.suo
?????文件????????3786??2009-02-11?11:43??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\AnyYGBirthdayByCross.csproj
?????文件????????3043??2009-02-11?11:44??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\Form1.cs
?????文件????????6187??2009-02-11?11:41??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\Form1.Designer.cs
?????文件????????5814??2009-02-11?11:41??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\Form1.resx
?????文件?????????501??2009-02-11?11:26??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\Program.cs
?????文件???????11776??2009-02-11?11:44??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\bin\Debug\AnyYGBirthdayByCross.exe
?????文件???????22016??2009-02-11?11:44??sj\02\AnyYGBirthdayByCross\AnyYGBirthdayByCross\bin\Debug\AnyYGBirthdayByCross.pdb
............此處省略35個文件信息