某君的部分SqlHelper

///
 
<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
  成员方法


    }

}