public string ExecutePagedDataList(PagedRecordParameter prp)
{
long t = DateTime.Now.Ticks;
try
{
DAC dac = new DAC(prp.ConnectionString);
List<DbParameter> pars = new List<DbParameter>();
pars.Add(dac.CreateParameter("TableName", prp.TableName));
pars.Add(dac.CreateParameter("Fields", prp.Fields));
pars.Add(dac.CreateParameter("OrderBy", prp.OrderBy));
pars.Add(dac.CreateParameter("PageIndex", prp.PageIndex));
pars.Add(dac.CreateParameter("PageSize", prp.PageSize));
pars.Add(dac.CreateParameter("RecordCount", prp.RecordCount));
pars.Add(dac.CreateParameter("Where", prp.Where));
string s = dac.ExecuteDataList("PagedRecordSP", CommandType.StoredProcedure, pars.ToArray());
Log.Write(LogAction.Dac, className, "ExecutePagedDataSetWraped", prp.ConnectionString, "PagedRecordSP", DateTime.Now.Ticks - t, "执行成功");
return s;
}
catch (Exception e)
{
Log.Write(LogAction.Error, className, "ExecutePagedDataSetWraped", prp.ConnectionString, "PagedRecordSP", DateTime.Now.Ticks - t, "执行出错:cmdText:PagedRecordSP;" + e.Message);
}
return string.Empty;
}
public DataSet ExecutePagedDataSet(string connString, string dsTableName, string tableName, string fields, string orderBy, long pageIndex, long pageSize, long recordCount, string where)
{
long t = DateTime.Now.Ticks;
try
{
DAC dac = new DAC(connString);
List<DbParameter> pars = new List<DbParameter>();
pars.Add(dac.CreateParameter("TableName", tableName));
pars.Add(dac.CreateParameter("Fields", fields));
pars.Add(dac.CreateParameter("OrderBy", orderBy));
pars.Add(dac.CreateParameter("PageIndex", pageIndex));
pars.Add(dac.CreateParameter("PageSize", pageSize));
pars.Add(dac.CreateParameter("RecordCount", recordCount));
pars.Add(dac.CreateParameter("Where", where));
DataSet ds = dac.ExecuteDataSet(tableName, "PagedRecordSP", CommandType.StoredProcedure, pars.ToArray());
Log.Write(LogAction.Dac, className, "ExecutePagedDataSet", connString, "PagedRecordSP", DateTime.Now.Ticks - t, "执行成功");
return ds;
}
catch (Exception e)
{
Log.Write(LogAction.Error, className, "ExecutePagedDataSet", connString, "PagedRecordSP", DateTime.Now.Ticks - t, "执行出错:cmdText:PagedRecordSP;" + e.Message);
}
return new DataSet();
}
