public static IInputDocument LoadDocument(int docnum, IGlobalValues data)
{
var sql = new SqlConnection(data.ConnectionString);
string sqlcmd = @"SELECT DocTypeID FROM " + data.ActiveSchema +
".DocumentHead WHERE DocumentHead.DocumentID = " + docnum.ToString();
SqlCommand cmd = new SqlCommand(sqlcmd, sql);
int type;
try
{
sql.Open();
type = (int)cmd.ExecuteScalar();
sql.Close();
}
catch (Exception exception)
{
//return null;
throw new Exception("Ошибка загрузки свойств документа.", exception);
}
switch (type)
{
case 1:
case 3:
return(PlanDocument.LoadDocument(docnum, data.ActiveSchema + ".DocumentHead", data.ActiveSchema + ".DocumentBody", data.ConnectionString));
case 2:
case 4:
return(DeviceDocument.LoadDocument(docnum, data.ActiveSchema + ".DocumentHead", data.ActiveSchema + ".DocumentBody", data.ConnectionString, new List <int>(data.ProductGroups[DEVICES].Keys)));
default:
throw new Exception("Неверный тип документа.");
}
}
private bool KBK(DateTime date)
{
InputDocumentHead head = new InputDocumentHead();
head.DocType = PLAN;
head.DocumentDate = date;
head.Factory = 4; //идентификатор КБК
PlanDocument doc = null;
var connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
//var rplist = new int[6] { 0, 1, 2, 3, 4, 5, 6, 7, 8 };
var cmd = new SqlCommand();
cmd = new SqlCommand(string.Format("Select dbo.FindPlan({0}, '{1}')", 4, date.ToString("yyyyMMdd")), connection);
connection.Open();
//проверка наличия плана производства
int num = (int)cmd.ExecuteScalar();
if (num > 0)
{
doc = PlanDocument.LoadDocument(num, GlobalValues.Instance.ActiveSchema + ".DocumentHead", GlobalValues.Instance.ActiveSchema + ".DocumentBody", GlobalValues.Instance.ConnectionString);
doc.DeleteDocument();
doc = null;
}
doc = PlanDocument.CreateDocument(head, GlobalValues.Instance.ActiveSchema + ".DocumentHead", GlobalValues.Instance.ActiveSchema + ".DocumentBody", GlobalValues.Instance.ConnectionString);
doc.BeginEdit();
doc.DocumentBody.Clear();
//var lastdate = date.Subtract(new TimeSpan(4, 0, 0, 0));
cmd.Connection = connection;
for (int j = 1; j <= 8; ++j)
{
cmd.CommandText = "SELECT fdb.DataHour as h, fdb.DataValue FROM dbo.vRP rp INNER JOIN " +
" dbo.vForecastDocumentHead fdh ON rp.RPID = fdh.RPID INNER JOIN " +
" dbo.vForecastDocumentBody fdb ON fdh.DocumentID = fdb.DocumentID" +
" WHERE (fdh.DocumentDate = '" + date.ToString("yyyyMMdd") + "') " +
" AND (fdh.DocTypeID = 2) AND " +
" (rp.RPID = " + j.ToString() + ")";
var adapter = new SqlDataAdapter(cmd);
var data = new DataTable();
adapter.Fill(data);
data.Columns["h"].DataType = typeof(int);
DataColumn key = data.Columns["h"];
data.PrimaryKey = new DataColumn[] { key };
if (data.Rows.Count != 24)
{
doc.EndEdit();
connection.Close();
ErrorMessage = string.Format("отсутствует одна из заявок на {0}", date.ToString("dd.MM.yyyy"));
doc.DeleteDocument();
return(false);
}
for (int i = 1; i <= 24; ++i)
{
DataRow row = data.Rows.Find(i);
DataRow add = doc.DocumentBody.NewRow();
add["DocumentID"] = doc.Head.DocumentNumber;
add["ProductID"] = j;
add["DataHour"] = i;
add["DataValue1"] = row["DataValue"];
doc.DocumentBody.Rows.Add(add);
}
}
doc.UpdateDocument();
doc.EndEdit();
connection.Close();
cmd = new SqlCommand(string.Format("Select dbo.FindPlan({0}, '{1}')", 4, date.ToString("yyyyMMdd")), connection);
connection.Open();
bool result = true;
//проверка наличия плана производства
if ((int)cmd.ExecuteScalar() > 0)
{
//загруска плана производства в таблицу TempPlan
SqlCommand plan = new SqlCommand(string.Format("exec dbo.LoadPlan {0},'{1}'", 4, date.ToString("yyyyMMdd")), connection);
plan.ExecuteNonQuery();
connection.Close();
//запуск скрипта дедуктора
Process prc = null;
string output = string.Empty;
try
{
// Устанавливаем параметры запуска процесса
prc = new Process();
prc.StartInfo.FileName = ConfigurationManager.AppSettings["DeductorString"];
prc.StartInfo.Arguments = Scripts[4] + " /run";
// Старт
prc.Start();
// Ждем пока процесс не завершится
prc.WaitForExit();
if (prc.ExitCode == -1)
{
result = false;
ErrorMessage = "Ошибка серваера прогнозирования.";
}
}
finally
{
if (prc != null)
{
prc.Close();
}
}
}
else
{
ErrorMessage = string.Format("отсутствует план производства на {0}", date);
result = false;
}
return(result);
}
private bool OtherFactory(DateTime date)
{
InputDocumentHead head = new InputDocumentHead();
head.DocType = PLAN;
head.DocumentDate = date;
head.Factory = 3; // остальные потребители
PlanDocument doc = null;
var connection = new SqlConnection(GlobalValues.Instance.ConnectionString);
var rplist = new int[6] {
0, 4, 5, 6, 7, 8
};
var cmd = new SqlCommand();
cmd = new SqlCommand(string.Format("Select dbo.FindPlan({0}, '{1}')", 3, date.ToString("yyyyMMdd")), connection);
connection.Open();
bool result = true;
//проверка наличия плана производства
int num = (int)cmd.ExecuteScalar();
if (num > 0)
{
doc = PlanDocument.LoadDocument(num, GlobalValues.Instance.ActiveSchema + ".DocumentHead", GlobalValues.Instance.ActiveSchema + ".DocumentBody", GlobalValues.Instance.ConnectionString);
doc.DeleteDocument();
doc = null;
}
doc = PlanDocument.CreateDocument(head, GlobalValues.Instance.ActiveSchema + ".DocumentHead", GlobalValues.Instance.ActiveSchema + ".DocumentBody", GlobalValues.Instance.ConnectionString);
doc.BeginEdit();
doc.DocumentBody.Clear();
var lastdate = date.Subtract(new TimeSpan(4, 0, 0, 0));
cmd.Connection = connection;
for (int j = 1; j <= 5; ++j)
{
cmd.CommandText = "Select DATEPART(hour, e.DataDate) as h, e.DataValue FROM dbo.Energy e WHERE e.RPID = " + rplist[j].ToString() +
" AND ((CONVERT(char(8), e.DataDate, 112) = '" + lastdate.ToString("yyyyMMdd") + "' AND DATEPART(hour, e.DataDate) <> 0) OR " +
"(CONVERT(char(8), e.DataDate, 112) = '" + lastdate.AddDays(1).ToString("yyyyMMdd") + "' AND DATEPART(hour, e.DataDate) = 0))";
var adapter = new SqlDataAdapter(cmd);
var data = new DataTable();
adapter.Fill(data);
data.Columns["h"].DataType = typeof(int);
DataColumn key = data.Columns["h"];
data.PrimaryKey = new DataColumn[] { key };
for (int i = 1; i <= 24; ++i)
{
DataRow row = data.Rows.Find(i % 24);
DataRow add = doc.DocumentBody.NewRow();
add["DocumentID"] = doc.Head.DocumentNumber;
add["ProductID"] = j;
add["DataHour"] = i;
add["DataValue1"] = row["DataValue"];
doc.DocumentBody.Rows.Add(add);
}
}
doc.UpdateDocument();
doc.EndEdit();
connection.Close();
cmd = new SqlCommand(string.Format("Select dbo.FindPlan({0}, '{1}')", 3, date.ToString("yyyyMMdd")), connection);
connection.Open();
//проверка наличия плана производства
if ((int)cmd.ExecuteScalar() > 0)
{
//загруска плана производства в таблицу TempPlan
SqlCommand plan = new SqlCommand(string.Format("exec dbo.LoadPlan {0},'{1}'", 3, date.ToString("yyyyMMdd")), connection);
plan.ExecuteNonQuery();
//запуск скрипта дедуктора
Process prc = null;
string output = string.Empty;
try
{
// Устанавливаем параметры запуска процесса
prc = new Process();
prc.StartInfo.FileName = ConfigurationManager.AppSettings["DeductorString"];
prc.StartInfo.Arguments = Scripts[3] + " /run";
// Старт
prc.Start();
// Ждем пока процесс не завершится
prc.WaitForExit();
if (prc.ExitCode == -1)
{
result = false;
ErrorMessage = "Ошибка серваера прогнозирования.";
}
}
finally
{
if (prc != null)
{
prc.Close();
}
}
}
else
{
ErrorMessage = string.Format("отсутствует план производства на {0}", date.ToString("dd.MM.yyyy"));
result = false;
}
return(result);
}