private DataSet GetDataSetForThread(string storedProcName, string connectionStringName, List <SqlParameter> param, int level = 0)
{
// Метод используется для получения данных для потоков. Не проверяютя параметры сессии.
if ((storedProcName.Trim() == "") || (connectionStringName.Trim() == ""))
{
return(null);
}
string parentMethod = CRMUtil.getParentMethodName(level);
using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString))
using (SqlDataAdapter da = new SqlDataAdapter(storedProcName, c))
using (DataSet ds = new DataSet(parentMethod + "Data"))
{
da.SelectCommand.CommandTimeout = 120;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
if (param != null)
{
foreach (SqlParameter p in param)
{
da.SelectCommand.Parameters.Add(p);
}
}
da.Fill(ds, parentMethod + "Table");
da.SelectCommand.Parameters.Clear();
return(ds);
}
}
private DataSet Error(string Message)
{
string parentMethod = CRMUtil.getParentMethodName(0);
DataSet erds = new DataSet(parentMethod + "Data");
erds.Tables.Add("ErrorTable");
erds.Tables["ErrorTable"].Columns.Add("ErrorMessage", typeof(string));
DataRow r = erds.Tables["ErrorTable"].NewRow();
r["ErrorMessage"] = Message;
erds.Tables["ErrorTable"].Rows.Add(r);
return(erds);
}
private DataSet GetDataSet(string storedProcName, string connectionStringName, List <SqlParameter> param = null, int level = 0)
{
if (!isOp())
{
throw new Exception("Неверный идентификатор сессии");
}
// return null;
if ((storedProcName.Trim() == "") || (connectionStringName.Trim() == ""))
{
return(null);
}
if (Session["ClientID"] == null)
{
Session["ClientID"] = "0";
}
if (Session["ClientDiscount"] == null)
{
Session["ClientDiscount"] = "0";
}
string parentMethod = CRMUtil.getParentMethodName(level);
SqlConnection c;
try
{
c = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString);
}
catch
{
string ErrMsg = "Ошибка соединения " + connectionStringName;
Logger logger = LogManager.GetCurrentClassLogger();
logger.Info("Error: {0}", ErrMsg);
LogManager.Flush();
EventLog.WriteEntry("CRMAutoInfo", ErrMsg, EventLogEntryType.Error);
DataSet erds = new DataSet("ErrorData");
erds.Tables.Add("ErrorTable");
erds.Tables["ErrorTable"].Columns.Add("ErrorMessage", typeof(string));
DataRow r = erds.Tables["ErrorTable"].NewRow();
return(erds);
}
using (SqlDataAdapter da = new SqlDataAdapter(storedProcName, c))
using (DataSet ds = new DataSet(parentMethod + "Data"))
{
da.SelectCommand.CommandTimeout = 120;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
if (param != null)
{
foreach (SqlParameter p in param)
{
da.SelectCommand.Parameters.Add(p);
}
}
da.Fill(ds, parentMethod + "Table");
da.SelectCommand.Parameters.Clear();
return(ds);
}
}
