public string ExecuteDataList(string connString, string cmdText, CommandType cmdType, params DatabaseParameter[] parameters) { long t = DateTime.Now.Ticks; try { DbParameter[] ps = ConvertParameter(parameters); DAC dac = new DAC(connString); string list = dac.ExecuteDataList(cmdText, cmdType, ps); Log.Write(LogAction.Svc, className, "ExecuteDataList", connString, cmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行成功:" + parameters.ToKeyString() + ";数据:" + list); return list; } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecuteDataList", connString, cmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行出错:cmdText:" + cmdText + ";" + parameters.ToKeyString() + ";" + e.ToString()); } return "[]"; }
public string ExecuteDataList(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); string list = dac.ExecuteDataList(parms.CmdText, (CommandType)parms.CmdType, ps); Log.Write(LogAction.Svc, className, "ExecuteDataListWraped", parms.ConnectionString, parms.CmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行成功:" + (CommandType)parms.CmdType + " " + pars.ToKeyString()); return list; } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecuteDataListWraped", parms.ConnectionString, parms.CmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行出错:" + (CommandType)parms.CmdType + " " + parms + ";" + e.ToString()); } return "[]"; }
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; }