今天心情不错
经过周末两天时间的不懈努力,工作终于有了迅速的进展,总的工作就剩下地下水等值曲线＆等值面的绘制了.没想到经过两天努力把图表功能给完成了,效果看起来还不错,比较高兴.
这两天主要解决了以下几个难点:
1.图表控件的选择,最终使用了mschart,发现它的功能还是比较强大的,之前太小瞧它了.通过一系列属性设置同样能够让你的图表美观起来.如标签名,网格间隙都是可以在代码里控制的.
2.mschart的datasource属性只能为一个记录集,因此要画多条曲线的画,在记录集里就应该有多列.我的表只有时间,编码,地下水水位四个字段,而我要实现在某个时段内不同编码的站点的对比图.经过一段时间的考虑,我使用交叉表解决了这个问题,在sqlServer中使用交叉表的方法可查下更详细的资料,举个例子:
SELECT TitleOfCourtesy,
SUM(CASE City WHEN 'London' THEN ReportsTo ELSE NULL END) AS [London City],
SUM(CASE City WHEN 'Redmond' THEN ReportsTo ELSE NULL END) AS [Redmond City],
SUM(CASE City WHEN 'Seattle' THEN ReportsTo ELSE NULL END) AS [Seattle City]
FROM Employees GROUP BY TitleOfCourtesy
同时你还可以结合嵌套查询,联合查询等其它条件,我写的一个简单的语句如下,
select substring(CONVERT(varchar(10), YMDHM, 111),3,10) as ymdhm, sum(case STCD when '" & staCode(0) & "' then " & strFieldN & " else 0 end) as [" & staCode(0) & "] from " & strTableN & " where stcd in (" & staCode(0) & ") and ymdhm >= '" & strStartTime & "' and ymdhm <= '" & strEndTime & "' group by ymdhm order by ymdhm asc".
3.mschart还支持数据源为数组类型,这次为了做多个年份,同一个站点的水位对比分析,就使用了这种方法.其中需要用到多个循环,所以执行效率可能低一点.
4.突然间发现vb用类的思想设计框架的话,也能够使效率大大提高,更为关键的是灵活性强,而且也使代码更为简洁,这样就不用成天想着怎么去拷贝代码了.
34 篇评论在 “今天心情不错”
1
11/22 2008, 14:09 Say: [回复]
2
3
4
5
6
7
8
9
10
11
12
13
14
16
17
18
19
20
21
出会いサイト
11/01 2008, 16:12 Say: [回复]
出会い出会い系出会い系サイト出会い喫茶出会い掲示板ナンパ出会いカフェ人妻出会い無料系サイト優良出会い系攻略完全無料。アダルトビデオアダルト動画アダルトアニメアダルト画像アダルトサイト無料DVDアダルト風俗サンプル無料風俗優良アダルトサイト比較海外。人妻画像人妻パラダイス知合い人妻援護会人妻SMコレクション風俗告白。熟女画像東京熟女掲示板動画熟女ビデオおまんこオナニー。エロ画像エロフラッシュアニメエロ動画エロゲームエロ漫画無料エロサイト。エッチ画像エッチ動画エッチ小説写真エッチアニメエッチ0930。セックスアナルセックス画像セックス動画カーセックスセックスフレンドスワッピングSEX写真セックスボランティセックス体位東京セックス仕方SEX。おっぱい画像おっぱい村長おっぱい楽園掲示板おっぱい命おっぱいゲーム。巨乳動画巨乳画像アイドル巨乳掲示板風俗。セフレ募集セフレ掲示板セフレ画像掲示板セフレの作り方出会い無料素人セフレ。童貞狩りエロ漫画童貞狩り童貞喪失童貞オークション素人童貞逆援。不倫パートナー不倫出会い人妻不倫。
23
24
25
26
27
28
29
30
31
匿名
08/01 2008, 13:54 Say: [回复]
I also know that .free online games.Just remember that choosing a Training program
for yourself a.play war games.a college.
free online war games.You will need to know a lot about.
online games.the program and what you really need from a specific Guide Dog
school.
32
匿名
08/01 2008, 13:53 Say: [回复]
soon as possible.level wow.Just remember that .
mp3 mp4 player.You will need to know .mp3 mp4
player.Below are things you wow.Such as,
mp3 players.I’m going to try to cover the dog
mp3 player.Remember , you will be there .sell wow
gold.1.
buy cheap wow gold.Do you have a specific breed in mind.
buy world of warcraft goldDon’t assume that .
buying wow gold.Is the breed important to you
wow billig gold. 2.
wow gold kauf.Do you require ownership of the dog.
wowgold.3.
günstig wow gold.Does the school do
follow up visits for the graduated team.or wow.Do you feel
more secure .gold wow.4.
wow power leveling.Does the school have a good
reputation.wow level.Try talking with people who
have graduated from the programs.lotro gold.Most won’t
mind answering a few questions.power
level.5.power leveling.Are
you eligible for the schools program.
powerleveling wow.Are you
legally blind or totally blind.
wow leveling.Are you physically able to train
with a dog .wow lvl 70..Will the school
accommodate your level of ability.
33
匿名
08/01 2008, 13:51 Say: [回复]
We every know that .wow level service. new level 70
characters .mp3 players.
a week in order to .mp3 player. Welfare epics.
wow. Maybe.mp3
players. but having decent gear makes it easier.mp3 player. for many players to
progress.
wow gold. It make some time .
gold wow. play their classes.wow geld.
in a competitive PvP setting.wow gold
paypal. Despite their prizewinning efforts.wowgold. Blizzard has largely .
wow gold günstig.
the creation of a minor league field with .wow power
leveling. The oginal poster .lwow or. A minor league for PvP might
gold wow. in the field.
world of warcraft power leveling. It would also
earmark elite players to.portable mp3 player. only be bracketed with folks .
portable mp3 players. field reqards.
wow lvl. Other flaws mentioned by responders
included the idea.lecteurs mp3. that players .
34
匿名
08/01 2008, 13:49 Say: [回复]
Once you have the materials.wow gold. you need to sell the items.
wow gold.
This can be the hardest part.wow gold kaufen. or the easiest part.
world of warcraft gold. It all depends on .
wow geld. and what players are wanting.
wow powerlevel. I've found
that .buy wow gold. server until 10 p.m.
wow. server.wow gold.you have scheduled
raids during part of this time.cheap wow gold. That's where the second account comes
in.serveur wow. Make a
macro that.wow europe. You will get a lot
cheapest wow gold. and you'll have stacks of gold .
wow power leveling. When it is not prime time.
wow powerlevelinggold wow. I
recommend that .mp3 players. There are always the odd players .
mp3 player. in the morning.
wow gold. and you want to be able to get to them as
well.mp3 player. Additionally if you have two items the best thing.
zubehoer mp3 player. to do is to put one up on the AH.
wow gold kaufen. and keep the other around to sell via the
trade channel.mp3. netting you a total of 3,000g.
mp4. Do this each week for a month.
wow geld. For me raiding costs
mp3 players. so in the end mp3 player. Not too
bad.
发表评论
出会い出会い系出会い系サイト出会い喫茶出会い掲示板ナンパ出会いカフェ人妻出会い無料系サイト優良出会い系攻略完全無料。アダルトビデオアダルト動画アダルトアニメアダルト画像アダルトサイト無料DVDアダルト風俗サンプル無料風俗優良アダルトサイト比較海外。人妻画像人妻パラダイス知合い人妻援護会人妻SMコレクション風俗告白。熟女画像東京熟女掲示板動画熟女ビデオおまんこオナニー。エロ画像エロフラッシュアニメエロ動画エロゲームエロ漫画無料エロサイト。エッチ画像エッチ動画エッチ小説写真エッチアニメエッチ0930。セックスアナルセックス画像セックス動画カーセックスセックスフレンドスワッピングSEX写真セックスボランティセックス体位東京セックス仕方SEX。おっぱい画像おっぱい村長おっぱい楽園掲示板おっぱい命おっぱいゲーム。巨乳動画巨乳画像アイドル巨乳掲示板風俗。セフレ募集セフレ掲示板セフレ画像掲示板セフレの作り方出会い無料素人セフレ。童貞狩りエロ漫画童貞狩り童貞喪失童貞オークション素人童貞逆援。不倫パートナー不倫出会い人妻不倫。
I also know that .free online games.Just remember that choosing a Training program
for yourself a.play war games.a college.
free online war games.You will need to know a lot about.
online games.the program and what you really need from a specific Guide Dog
school.
soon as possible.level wow.Just remember that .
mp3 mp4 player.You will need to know .mp3 mp4
player.Below are things you wow.Such as,
mp3 players.I’m going to try to cover the dog
mp3 player.Remember , you will be there .sell wow
gold.1.
buy cheap wow gold.Do you have a specific breed in mind.
buy world of warcraft goldDon’t assume that .
buying wow gold.Is the breed important to you
wow billig gold. 2.
wow gold kauf.Do you require ownership of the dog.
wowgold.3.
günstig wow gold.Does the school do
follow up visits for the graduated team.or wow.Do you feel
more secure .gold wow.4.
wow power leveling.Does the school have a good
reputation.wow level.Try talking with people who
have graduated from the programs.lotro gold.Most won’t
mind answering a few questions.power
level.5.power leveling.Are
you eligible for the schools program.
powerleveling wow.Are you
legally blind or totally blind.
wow leveling.Are you physically able to train
with a dog .wow lvl 70..Will the school
accommodate your level of ability.
We every know that .wow level service. new level 70
characters .mp3 players.
a week in order to .mp3 player. Welfare epics.
wow. Maybe.mp3
players. but having decent gear makes it easier.mp3 player. for many players to
progress.
wow gold. It make some time .
gold wow. play their classes.wow geld.
in a competitive PvP setting.wow gold
paypal. Despite their prizewinning efforts.wowgold. Blizzard has largely .
wow gold günstig.
the creation of a minor league field with .wow power
leveling. The oginal poster .lwow or. A minor league for PvP might
gold wow. in the field.
world of warcraft power leveling. It would also
earmark elite players to.portable mp3 player. only be bracketed with folks .
portable mp3 players. field reqards.
wow lvl. Other flaws mentioned by responders
included the idea.lecteurs mp3. that players .
Once you have the materials.wow gold. you need to sell the items.
wow gold.
This can be the hardest part.wow gold kaufen. or the easiest part.
world of warcraft gold. It all depends on .
wow geld. and what players are wanting.
wow powerlevel. I've found
that .buy wow gold. server until 10 p.m.
wow. server.wow gold.you have scheduled
raids during part of this time.cheap wow gold. That's where the second account comes
in.serveur wow. Make a
macro that.wow europe. You will get a lot
cheapest wow gold. and you'll have stacks of gold .
wow power leveling. When it is not prime time.
wow powerlevelinggold wow. I
recommend that .mp3 players. There are always the odd players .
mp3 player. in the morning.
wow gold. and you want to be able to get to them as
well.mp3 player. Additionally if you have two items the best thing.
zubehoer mp3 player. to do is to put one up on the AH.
wow gold kaufen. and keep the other around to sell via the
trade channel.mp3. netting you a total of 3,000g.
mp4. Do this each week for a month.
wow geld. For me raiding costs
mp3 players. so in the end mp3 player. Not too
bad.
