public DataTable getFenYeList(FenyeM FM)
{
SqlParameter[] prams ={new SqlParameter("@tblName",SqlDbType .NVarChar ),
new SqlParameter ("@fldName",SqlDbType .NVarChar ),
new SqlParameter ("@pageSize",SqlDbType.Int),
new SqlParameter ("@page",SqlDbType.Int),
new SqlParameter ("@pageCount",SqlDbType.Int),
new SqlParameter ("@Counts",SqlDbType.Int),
new SqlParameter("@ID",SqlDbType .NVarChar ),
new SqlParameter("@fldSort",SqlDbType .NVarChar ),
new SqlParameter("@Sort",SqlDbType .Int ),
new SqlParameter("@strCondition",SqlDbType.NVarChar ) };
prams[0].Value = FM.Tblname;
prams[1].Value = FM.Fldname;
prams[2].Value = FM.PageSize;
prams[3].Value = FM.Page;
prams[4].Direction = ParameterDirection.Output;
prams[5].Direction = ParameterDirection.Output;
prams[6].Value = FM.Id;
prams[7].Value = FM.FldSort;
prams[8].Value = FM.Sort;
prams[9].Value = FM.StrCondition;
try
{
DataTable dt = SqlHelper.ExecuteDataTable(SqlHelper.ConnectionString, CommandType.StoredProcedure, "SP_SqlFenYe", prams);
FM.PageCount = int.Parse(prams[4].Value.ToString());
FM.Counts = int.Parse(prams[5].Value.ToString());
return dt;
}
catch (Exception ex)
{
throw;
}
}