本文整理汇总了C#中IConnection.exeQuery方法的典型用法代码示例。如果您正苦于以下问题：C# IConnection.exeQuery方法的具体用法？C# IConnection.exeQuery怎么用？C# IConnection.exeQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IConnection的用法示例。
在下文中一共展示了IConnection.exeQuery方法的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: open
public DataTable open(string pSortBy, IConnection pConn)
{
string SqlStr;
SqlStr = "SELECT * "
+ " FROM goods_types"
+ " ORDER BY " + pSortBy;
_Tbl = pConn.exeQuery(SqlStr);
return _Tbl;
}示例2: open
public void open(int pGroupID, IConnection pConn)
{
string SqlStr;
SqlStr = " SELECT * FROM goods_groups WHERE GroupID = " + pGroupID.ToString() ;
DataTable Tbl = pConn.exeQuery(SqlStr);
if (Tbl.Rows.Count == 1)
this.BindData(Tbl.Rows[0]);
else
throw new LEKException(113, "Not found object {0}", "GroupID = " + pGroupID.ToString() );
}示例3: openExist
public bool openExist(int pGroupID, IConnection pConn)
{
string SqlStr;
SqlStr = " SELECT * FROM goods_groups WHERE GroupID = " + pGroupID.ToString() ;
DataTable Tbl = pConn.exeQuery(SqlStr);
if (Tbl.Rows.Count == 1){
this.BindData(Tbl.Rows[0]);
return true;
}else
return false;
}示例4: open
public DataTable open(IConnection pConn)
{
string SqlStr;
SqlStr = "SELECT * "
+ " FROM goods"
+ " ORDER BY GoodsCode ";
_Tbl = pConn.exeQuery(SqlStr);
return _Tbl;
}示例5: open
public DataTable open(string pSearchBy, string pCriteria, IConnection pConn)
{
string SqlStr;
string WhereStr = _WhereStr;
if (pCriteria.Length > 0)
WhereStr = " AND " + pSearchBy + DbMgr.formatDbPatialSearchString(pCriteria);
SqlStr = "SELECT * "
+ " FROM goods_groups"
+ WhereStr;
_Tbl = pConn.exeQuery(SqlStr);
return _Tbl;
}示例6: openExist
public bool openExist(string pGoodsCode, IConnection pConn)
{
string SqlStr;
SqlStr = " SELECT * FROM goods WHERE GoodsCode = " + DbMgr.formatDbString(pGoodsCode) ;
DataTable Tbl = pConn.exeQuery(SqlStr);
if (Tbl.Rows.Count == 1){
this.BindData(Tbl.Rows[0]);
return true;
}else
return false;
}示例7: open
public void open(string pGoodsCode, IConnection pConn)
{
string SqlStr;
SqlStr = " SELECT * FROM goods WHERE GoodsCode = " + DbMgr.formatDbString(pGoodsCode) ;
DataTable Tbl = pConn.exeQuery(SqlStr);
if (Tbl.Rows.Count == 1)
this.BindData(Tbl.Rows[0]);
else
throw new LEKException(113, "Not found object {0}", "GoodsCode = " + DbMgr.formatDbString(pGoodsCode) );
}