public static DeviceDocument CreateDocument(InputDocumentHead head, string headtable, string bodytable, string connection, List <int> devicelist, int parent)
{
DeviceDocument parentDocument;
DeviceDocument result = new DeviceDocument();
result.Head = head;
result.headTable = headtable;
result.bodyTable = bodytable;
result.connectionString = connection;
result.deviceList = devicelist;
result.SetBodySettings();
try
{
parentDocument = DeviceDocument.LoadDocument(parent, headtable, bodytable, connection, devicelist);
}
catch (Exception exception)
{
//return null;
throw new Exception("Ошибка загрузки связанного документа.", exception);
}
result.DocumentBody.Load(parentDocument.DocumentBody.CreateDataReader(), LoadOption.OverwriteChanges);
if (!result.SaveDocument())
{
return(null);
}
return(result);
}
public static DeviceDocument CreateDocument(InputDocumentHead head, string headtable, string bodytable, string connection, List <int> devicelist)
{
var result = new DeviceDocument();
result.Head = head;
result.headTable = headtable;
result.bodyTable = bodytable;
result.connectionString = connection;
result.deviceList = devicelist;
result.SetBodySettings();
for (int i = 1; i <= 24; ++i)
{
DataRow row = result.DocumentBody.NewRow();
row["DataHour"] = i;
foreach (var device in devicelist)
{
row[device.ToString()] = true;
}
result.DocumentBody.Rows.Add(row);
}
result.SaveDocument();
return(result);
}
public bool DeleteDocument()
{
var connection = new SqlConnection(connectionString);
var sql1 = string.Format("DELETE FROM {0} WHERE DocumentID = {1}", bodyTable, Head.DocumentNumber);
var sql2 = string.Format("DELETE FROM {0} WHERE DocumentID = {1}", headTable, Head.DocumentNumber);
SqlTransaction tn = null;;
try
{
connection.Open();
tn = connection.BeginTransaction();
var cmd = new SqlCommand(sql2, connection, tn);
cmd.ExecuteNonQuery();
cmd.CommandText = sql1;
cmd.ExecuteNonQuery();
tn.Commit();
}
catch (Exception exc)
{
error = exc;
tn.Rollback();
return(false);
}
Head = new InputDocumentHead();
DocumentBody.Clear();
return(true);
}
public static PlanDocument CreateDocument(InputDocumentHead head, string headtable, string bodytable, string connection)
{
var result = new PlanDocument();
result.Head = head;
result.headTable = headtable;
result.bodyTable = bodytable;
result.connectionString = connection;
result.DocumentBody.Columns.Add("DocumentID");
result.DocumentBody.Columns["DocumentID"].DataType = Type.GetType("System.Int32");
result.DocumentBody.Columns.Add("DataHour");
result.DocumentBody.Columns["DataHour"].DataType = Type.GetType("System.Int32");
result.DocumentBody.Columns.Add("ProductID");
result.DocumentBody.Columns["ProductID"].DataType = Type.GetType("System.Int32");
result.DocumentBody.Columns.Add("DataValue1");
result.DocumentBody.Columns["DataValue1"].DataType = Type.GetType("System.Double");
result.DocumentBody.Columns.Add("DataValue2");
result.DocumentBody.Columns["DataValue2"].DataType = Type.GetType("System.Double");
result.SetBodySettings();
for (int i = 1; i <= 24; ++i)
{
DataRow row = result.DocumentBody.NewRow();
row["DocumentID"] = result.Head.DocumentNumber;
row["DataHour"] = i;
row["ProductID"] = 0;
row["DataValue1"] = 0;
row["DataValue2"] = 0;
result.DocumentBody.Rows.Add(row);
}
return(result.SaveDocument() ? result : null);
}
public static PlanDocument CreateDocument(InputDocumentHead head, string headtable, string bodytable, string connection, int parent)
{
PlanDocument parentDocument;
PlanDocument result;
try
{
parentDocument = PlanDocument.LoadDocument(parent, headtable, bodytable, connection);
}
catch (Exception exception)
{
throw new Exception("Ошибка загрузки связанного документа.\n" + exception.Message, exception);
//return null;
// Ошибка загрузки связанного документа;
}
result = new PlanDocument();
result.Head = head;
result.headTable = headtable;
result.bodyTable = bodytable;
result.connectionString = connection;
result.DocumentBody.Columns.Add("DocumentID");
result.DocumentBody.Columns["DocumentID"].DataType = Type.GetType("System.Int32");
result.DocumentBody.Columns.Add("DataHour");
result.DocumentBody.Columns["DataHour"].DataType = Type.GetType("System.Int32");
result.DocumentBody.Columns.Add("ProductID");
result.DocumentBody.Columns["ProductID"].DataType = Type.GetType("System.Int32");
result.DocumentBody.Columns.Add("DataValue1");
result.DocumentBody.Columns["DataValue1"].DataType = Type.GetType("System.Double");
result.DocumentBody.Columns.Add("DataValue2");
result.DocumentBody.Columns["DataValue2"].DataType = Type.GetType("System.Double");
result.SetBodySettings();
foreach (DataRow source in parentDocument.DocumentBody.Rows)
{
DataRow destenation = result.DocumentBody.NewRow();
destenation["DocumentID"] = head.DocumentNumber;
destenation["DataHour"] = source["DataHour"];
destenation["ProductID"] = source["ProductID"];
destenation["DataValue1"] = source["DataValue1"];
destenation["DataValue2"] = source["DataValue2"];
result.DocumentBody.Rows.Add(destenation);
}
if (!result.SaveDocument())
{
return(null);
}
return(result);
}
protected InputDocumentBase()
{
Head = new InputDocumentHead();
ReadOnly = true;
}