C# Class HYPDM.WinUI.Document.DocQuery

Show file Open project: huayancreate/HYPDM

Public Methods

Method Description
GetQueryResult ( string queryStr ) : IList
GetQueryResultForDataTable ( string queryStr ) : DataTable
getDataTableBySql ( String fields, string where, string tableName ) : DataTable

给定列名,where条件,及表明返回datatable

Method Details

GetQueryResult() public method

public GetQueryResult ( string queryStr ) : IList
queryStr string
return IList

GetQueryResultForDataTable() public method

public GetQueryResultForDataTable ( string queryStr ) : DataTable
queryStr string
return System.Data.DataTable

getDataTableBySql() public static method

给定列名,where条件,及表明返回datatable
public static getDataTableBySql ( String fields, string where, string tableName ) : DataTable
fields String 需要查询出来的字段,sample:fields1,field2,field3
where string 查询条件,sample: where 1=1 and a1='jjj' order by CreateDate asc
tableName string 查询的表名,sample:DOC_FILE_LIST
return System.Data.DataTable