判断数据库中的表记录是否为空

判断数据库中的表记录是否为空

select count(*) from Table

public bool IsNoWorkSheetID(string OriOrderID)

        {

              string   sql =   "select count(*) from WorkSheet where OriOrderID = '"   + OriOrderID +   "'"   ;

              Database   db =   DatabaseFactory   .CreateDatabase();

              DBCommandWrapper   cmd = db.GetSqlStringCommandWrapper(sql);

              DataSet   dt =   new   DataSet ();

            dt = db.ExecuteDataSet(cmd);

              DataTable   dta = dt.Tables[0];

              string   id = dta.Rows[0][0].ToString();

              if   (id ==   "0"   )

                  return   true   ;

              else

                  return   false   ;

        }