62,248
社区成员




using (DataTable objDataSet = w_system.GetTypeListc(tables, zd, id, where, desc, pxid, mypage, page.ToString(), out cc, out dd))
{
for (int i = 0, pagezs = objDataSet.Rows.Count; i < pagezs; i++)
{
生成html表格数据
}
objDataSet.Clear();
objDataSet.Dispose();
return t;
}
public static DataTable GetTypeListc(string tables, string zd, string id, string where, string desc, string pxid, string mypage, string page, out string aa, out string bb)//分页
{
string strDataset = "exec sp_ys_PageTable @tables,@zd,@id,@where,@desc,@pxid,0,@mypage,@page,@TotalCount OUTPUT,@TotalPageCount OUTPUT";
aa = null;
bb = null;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@tables",SqlDbType.VarChar),
new SqlParameter("@zd",SqlDbType.VarChar),
new SqlParameter("@id",SqlDbType.VarChar),
new SqlParameter("@where",SqlDbType.VarChar),
new SqlParameter("@desc",SqlDbType.VarChar),
new SqlParameter("@pxid",SqlDbType.Int),
new SqlParameter("@mypage",SqlDbType.Int),
new SqlParameter("@page",SqlDbType.Int),
new SqlParameter("@TotalCount",SqlDbType.Int),
new SqlParameter("@TotalPageCount",SqlDbType.Int)
};
parms[0].Value = tables;
parms[1].Value = zd;
parms[2].Value = id;
parms[3].Value = where;
parms[4].Value = desc;
parms[5].Value = Int32.Parse(pxid);
parms[6].Value = Int32.Parse(mypage);
parms[7].Value = Int32.Parse(page);
parms[8].Value = 0;
parms[8].Direction = ParameterDirection.Output;
parms[9].Value = 0;
parms[9].Direction = ParameterDirection.Output;
string ww = "0", yy = "0";
using (DataTable datatable = w_SqlHelper.ExecuteReaderfhz(w_SqlHelper.strConn, CommandType.Text, strDataset, out ww, out yy, parms))
{
aa = ww;
bb = yy;
return datatable;
}
}
public static DataTable ExecuteReaderfhz(string connectionString, CommandType cmdType, string cmdText, out string ww, out string yy, params SqlParameter[] commandParameters)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
using (DataTable datatable = new DataTable())
{
for (int i = 0; i < rdr.FieldCount; i++)
{
DataColumn myDataColumn = new DataColumn();
myDataColumn.DataType = rdr.GetFieldType(i);
myDataColumn.ColumnName = rdr.GetName(i);
datatable.Columns.Add(myDataColumn);
}
while (rdr.Read())
{
DataRow myDataRow = datatable.NewRow();
for (int i = 0; i < rdr.FieldCount; i++)
{
myDataRow[i] = rdr[i].ToString();
}
datatable.Rows.Add(myDataRow);
myDataRow = null;
}
//if (rdr != null && rdr.HasRows && rdr.Read())
// datatable.Load(rdr);
rdr.Close();
rdr.Dispose();
ww = commandParameters[8].Value.ToString();
yy = commandParameters[9].Value.ToString();
cmd.Parameters.Clear();
conn.Close();
return datatable;
}
}
}
}
catch
{
conn.Close();
throw;
}
}
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
// 填充DataSet.
da.Fill(ds);
return ds;
}
if (rdr != null && rdr.HasRows && rdr.Read())
datatable.Load(rdr);
using (DataTable datatable = new DataTable())
{
for (int i = 0; i < rdr.FieldCount; i++)
{
DataColumn myDataColumn = new DataColumn();
myDataColumn.DataType = rdr.GetFieldType(i);
myDataColumn.ColumnName = rdr.GetName(i);
datatable.Columns.Add(myDataColumn);
}
while (rdr.Read())
{
DataRow myDataRow = datatable.NewRow();
for (int i = 0; i < rdr.FieldCount; i++)
{
myDataRow[i] = rdr[i].ToString();
}
datatable.Rows.Add(myDataRow);
myDataRow = null;
}