7,713
社区成员
发帖
与我相关
我的任务
分享
SELECT *,datediff('s',SampleDate,'2011-9-21 13:50:57') FROM Report_ChineseCheck
ORDER BY ID DESC
//查询结果
Expr1000 ID SampleDate SampleID PatientName CHNO
-1 1920 2011-9-21 13:50:57 005 0914 003
14 1919 2011-9-21 13:50:42 004 0914 003
1822 1918 2011-9-21 13:20:35 003 245 001
1831 1917 2011-9-21 13:20:25 002 245 001
49857 1916 2011-9-21 0:00:00 001 245 001
OleDbParameter[] parameters = {
new OleDbParameter("OLEDBSampleDate", OleDbType.Date),
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM Report_ChineseCheck ");
if (strWhere.Trim() != "")
{
strSql.Append(" where 1=1 and " + strWhere);
}
return DBHelperOleDb.Query(strSql.ToString());
}
DataSet ds = new Report_ChineseCheckManager().GetList(strWhere);
dgvPatientList.DataSource = ds.Tables[0];