public DataSet ExecuteDataSet(WrapedDatabaseParameter parms) { long t = DateTime.Now.Ticks; try { DatabaseParameter[] pars = parms.DatabaseParameters ?? new DatabaseParameter[] { }; DbParameter[] ps = ConvertParameter(pars); DAC dac = new DAC(parms.RoutingKey, parms.ConnectionString); DataSet ds = dac.ExecuteDataSet(parms.TableName ?? "DataSet", parms.CmdText, (CommandType)parms.CmdType, ps); Log.Write(LogAction.Svc, className, "ExecuteDataSetWraped", parms.ConnectionString, parms.CmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行成功:" + (CommandType)parms.CmdType + " " + pars.ToKeyString()); return ds; } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecuteDataSetWraped", parms.ConnectionString, parms.CmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行出错:" + (CommandType)parms.CmdType + " " + parms + ";" + e.ToString()); } return new DataSet(); }
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(); }
public DataSet ExecutePagedDataSet(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)); DataSet ds = dac.ExecuteDataSet(prp.DSTableName, "PagedRecordSP", CommandType.StoredProcedure, pars.ToArray()); Log.Write(LogAction.Dac, className, "ExecutePagedDataSetWraped", prp.ConnectionString, "PagedRecordSP", DateTime.Now.Ticks - t, "执行成功"); return ds; } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecutePagedDataSetWraped", prp.ConnectionString, "PagedRecordSP", DateTime.Now.Ticks - t, "执行出错:cmdText:PagedRecordSP;" + e.Message); } return new DataSet(); }
public DataSet ExecuteDataSet(string tableName, string connString, string cmdText, CommandType cmdType, params DatabaseParameter[] parameters) { long t = DateTime.Now.Ticks; try { DbParameter[] ps = ConvertParameter(parameters); DAC dac = new DAC(connString); DataSet ds = dac.ExecuteDataSet(tableName, cmdText, cmdType, ps); Log.Write(LogAction.Svc, className, "ExecuteDataSet", connString, cmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行成功:" + parameters.ToKeyString()); return ds; } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecuteDataSet", connString, cmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行出错:cmdText:" + cmdText + ";" + parameters.ToKeyString() + ";" + e.ToString()); } return new DataSet(); }