摘要: 先看效果:楼盘那是个txtbox,单击时出现txtbox覆盖原来的名称,然后出现自动匹配的DataGridView;代码: dataProject 知道匹配的DataGridView ,datacase显示数据的DataGridView #region 楼盘自动匹配 /// <summary> /// 自动匹配楼盘 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private 阅读全文
posted @ 2011-05-23 17:36 lice 阅读(619) 评论(0) 推荐(1) 编辑
摘要: 今天下午做一个分组统计查询,select count(caseid) as nm,ar.AreaName,p.ProjectName,sp.codename as Purpose from dat_case c inner join DAT_Project p on c.Projectid=p.Projectid left join SYS_Area ar on ar.AreaId=P.AreaId inner join sys_code sp on c.PurposeCode=sp.codewhere CaseDate between '2011-05-23' and  阅读全文
posted @ 2011-05-23 17:30 lice 阅读(281) 评论(0) 推荐(0) 编辑