///
<summary>
///
向数据集表中添加一行
///
</summary>
public
void
fnAddRow(System.Data.DataTable table, Sn.Model.KuCun.clstemp model,
bool
AcceptChanged)
{
System.Data.DataRow dr
=
table.NewRow();
if
(model
!=
null
)
{
dr[
"
id
"
]
=
model.id;
dr[
"
name
"
]
=
model.name;
table.Rows.Add(dr);
if
(AcceptChanged)
{
table.AcceptChanges();
}
}
}
///
<summary>
///
更新表中的一行
///
</summary>
public
void
fnSetRow(System.Data.DataRow dr, Sn.Model.KuCun.clstemp model)
{
if
(model
!=
null
)
{
dr[
"
id
"
]
=
model.id;
dr[
"
name
"
]
=
model.name;
}
}
///
<summary>
///
获得数据列表
///
</summary>
public
DataSet GetList(
string
strWhere)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
"
select id,name
"
);
strSql.Append(
"
FROM temp with(nolock)
"
);
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
return
DbHelperSQL.Query(strSql.ToString());
}
///
<summary>
///
获得数据列表
///
</summary>
public
DataSet GetList(
string
strWhere,
string
strselect)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
"
select
"
+
strselect);
strSql.Append(
"
FROM temp with(nolock)
"
);
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
return
DbHelperSQL.Query(strSql.ToString());
}
///
<summary>
///
获得数据列表
///
</summary>
public
DataSet GetList(
string
strWhere,StringBuilder sbfield,StringBuilder sbon)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
@"
select T.id,
T.name
"
);
if
(sbfield.ToString ()
!=
string
.Empty )
{
strSql.Append(
"
,
"
+
sbfield.ToString()) ;
}
strSql.Append(
"
FROM temp AS T WITH (NOLOCK)
"
);
if
(sbon.ToString ()
!=
string
.Empty )
{
sbon.ToString ();
}
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
return
DbHelperSQL.Query(strSql.ToString());
}
///
<summary>
///
获得数据列表
///
</summary>
public
DataSet GetList(StringBuilder strSql)
{
return
DbHelperSQL.Query(strSql.ToString());
}
///
<summary>
///
获得前几行数据
///
</summary>
public
DataSet GetList(
int
Top,
string
strWhere,
string
filedOrder)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
"
select
"
);
if
(Top
>
0
)
{
strSql.Append(
"
top
"
+
Top.ToString());
}
strSql.Append(
"
id,name
"
);
strSql.Append(
"
FROM temp with(nolock)
"
);
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
if
(filedOrder
!=
string
.Empty)
{
strSql.Append(
"
order by
"
+
filedOrder);
}
return
DbHelperSQL.Query(strSql.ToString());
}
///
<summary>
///
获得数据列表
///
</summary>
public
int
fnQuery(
string
strWhere,DataTable table,
bool
AutoClear)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
"
select id,name
"
);
strSql.Append(
"
FROM temp with(nolock)
"
);
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
return
fnGetList(strSql.ToString(), table, AutoClear);
}
///
<summary>
///
获得数据列表
///
</summary>
public
int
fnQuery(
string
strWhere,
string
strselect,DataTable table,
bool
AutoClear)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
"
select
"
+
strselect);
strSql.Append(
"
FROM temp with(nolock)
"
);
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
return
fnGetList(strSql.ToString(), table, AutoClear);
}
///
<summary>
///
获得数据列表
///
</summary>
public
int
fnQuery(
string
strWhere,StringBuilder sbfield,StringBuilder sbon,DataTable table,
bool
AutoClear)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
@"
select T.id,
T.name
"
);
if
(sbfield.ToString ()
!=
string
.Empty )
{
strSql.Append(
"
,
"
+
sbfield.ToString()) ;
}
strSql.Append(
"
FROM temp AS T WITH (NOLOCK)
"
);
if
(sbon.ToString ()
!=
string
.Empty )
{
sbon.ToString ();
}
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
return
fnGetList(strSql.ToString(), table, AutoClear);
}
///
<summary>
///
获得数据列表
///
</summary>
public
int
fnQuery(StringBuilder strSql,DataTable table,
bool
AutoClear)
{
return
fnGetList(strSql.ToString(), table, AutoClear);
}
///
<summary>
///
获得前几行数据
///
</summary>
public
int
fnQuery(
int
Top,
string
strWhere,
string
filedOrder,DataTable table,
bool
AutoClear)
{
StringBuilder strSql
=
new
StringBuilder();
strSql.Append(
"
select
"
);
if
(Top
>
0
)
{
strSql.Append(
"
top
"
+
Top.ToString());
}
strSql.Append(
"
id,name
"
);
strSql.Append(
"
FROM temp with(nolock)
"
);
if
(strWhere.Trim()
!=
""
)
{
strSql.Append(
"
where
"
+
strWhere);
}
if
(filedOrder
!=
string
.Empty)
{
strSql.Append(
"
order by
"
+
filedOrder);
}
return
fnGetList(strSql.ToString(), table, AutoClear);
}
///
<summary>
///
通用查询语句
///
</summary>
public
int
fnGetList(
string
sqlstr,DataTable table,
bool
AutoClear)
{
DataSet ds
=
DbHelperSQL.Query(sqlstr);
if
(ds
==
null
)
{
return
-
1
;
}
if
(ds.Tables.Count
<
1
)
{
return
-
1
;
}
if
(AutoClear)
{
table.Clear();
}
table.Merge(ds.Tables[
0
]);
return
ds.Tables[
0
].Rows.Count;
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "temp";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}
*/
#endregion
成员方法
}
}
分享到:
相关推荐
// SQLHelper.cs // // This file contains the implementations of the SqlHelper and SqlHelperParameterCache // classes. 这个文件实现了SqlHelper类和SqlHelperParameterCache类 //其中SqlHelper类执行各种方式...
SqlHelper 类实现详细信息SqlHelper 类用于通过一组静态方法来封装数据访问功能。
SQLHelper类(含完整中文注释)-免费共享
SqlHelper是一个基于.NET Framework的数据库操作组件。组件中包含数据库操作方法,SqlHelper有很多版本,主要以微软一开始发布的SqlHelper类,后面包含进了Enterprise Library开源包中了。还有一个主要版本是...
Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容
C# Sqlhelper 简单的sqlhelper 类
SqlHelper.cs 微软的SQLHelper类 微软的SQLHelper类(含完整中文注释) 非常好的SQLHelper
SQLHelper中文翻译版本 SQLHelper中文翻译版本 SQLHelper中文翻译版本
C# sqlhelper多类库C# sqlhelper多类库C# sqlhelper多类库
2,所以数据库操作只需要调用SQLHelper中的方法即可.DataAccess类是在SQLHelper类内部调用的类. 3,使用前请先执行以下方法,以进行类初始化: string DBConnectionString = "data source=.;database=Northwind;user id...
sqlhelper
SqlHelper学习实例SqlHelper学习实例SqlHelper学习实例SqlHelper学习实例SqlHelper学习实例SqlHelper学习实例
微软提供的的SQLHelper类,封装了最常用的数据操作,为了方便初学的朋友,上传一个带详细中文注释的SqlHelper。
Visual C++源代码 114 如何使用SqlHelper查询数据库记录Visual C++源代码 114 如何使用SqlHelper查询数据库记录Visual C++源代码 114 如何使用SqlHelper查询数据库记录Visual C++源代码 114 如何使用SqlHelper查询...
sqlHelper 中文注释版,sqlHelper 中文注释版,sqlHelper 中文注释版
韩顺平Sqlhelper.java
sqlhelper类,可以在做项目时参考,这个类里没有什么错误,适合.net+SQL
微软官方C# SqlHelper类 ,内带有注释说明,供大家参考
在GridView中使用SqlHelper分页
SqlHelper ExecuteNonQuery ExecuteScalar ExecuteDataTable