摘要: using System;using System.Collections;using System.Collections.Specialized;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace SQLServerDAL //可以修改成实际项目的命名空间名称 { public abstract class DbHelperSQL { protected static string connectionString = @"Data Source=.;Initial 阅读全文
posted @ 2013-07-05 17:20 qanholas 阅读(10459) 评论(0) 推荐(0)
摘要: --SELECT stuid FROM dbo.BZList WHERE AreaOrganID=-1 AND AreaPointCode=-1 AND DeptOrganID=-1SELECT bzid,stuid, BZKTypeID, BZKTypeName, BZDate, BZData, BZRemark, PointCode FROM dbo.BZList WHERE StuID =338180 ORDER BY BZDateSELECT bzid,stuid, BZKTypeID, BZKTypeName, BZDate, BZData, BZRemark, PointCode 阅读全文
posted @ 2013-07-05 15:35 qanholas 阅读(585) 评论(0) 推荐(0)