?? checksdao.cs
字號:
using System;
using System.Data .SqlClient;
using System.Data ;
namespace AdminGoods
{
/// <summary>
/// ChecksDAO 的摘要說明。
/// </summary>
public class ChecksDAO
{
public ChecksDAO()
{
//
// TODO: 在此處添加構造函數邏輯
//
}
public DataTable listAllAssets()
{
System.Data.SqlClient.SqlConnection conn;
SqlDataAdapter dp;
string sql;
DataSet ds = new DataSet();
Database db = new Database();
DataTable last = new DataTable();
try
{
sql = "select c.*,a.name,w.realname from checks as c , assets as a ,worker as w where c.assetsID = a.id and c.workerID = w.id";
conn = db.openConn();
dp = new System.Data.SqlClient.SqlDataAdapter(sql,conn);
dp.Fill(ds,"worker");
last = ds.Tables["worker"];
}
catch
{
last = null;
}
finally
{
db.closeConn();
}
return last;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -