摘要:
先看效果:楼盘那是个txtbox,单击时出现txtbox覆盖原来的名称,然后出现自动匹配的DataGridView;代码: dataProject 知道匹配的DataGridView ,datacase显示数据的DataGridView #region 楼盘自动匹配 /// <summary> /// 自动匹配楼盘 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private 阅读全文
摘要:
今天下午做一个分组统计查询,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 阅读全文