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;
}
