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("Неверный тип документа.");
}
}
public CreateTender(IGlobalValues data, int parent)
{
InitializeComponent();
Data = data;
ForecastDocument doc = ForecastDocument.LoadDocument(parent, Data.ActiveSchema + ".ForecastDocumentHead", Data.ActiveSchema + ".ForecastDocumentBody", Data.ConnectionString);
parentDoc = doc.Head;
}
public FormInputDoc(IInputDocument document, IGlobalValues data)
{
InitializeComponent();
Document = document;
Data = data;
docInfo.Text = "Документ № " + Document.Head.DocumentNumber.ToString() +
"\nДата: " + Document.Head.DocumentDate.ToString("dd.MM.yyyy") +
"\nФабрика: " + Data.FactoryList[Document.Head.Factory];
this.Text = Data.PlanDocType[Document.Head.DocType] + " № " + Document.Head.DocumentNumber.ToString();
}
public static DataTable SelectAllDocuments(IGlobalValues data, string headtable, string factorytable, DateTime start, DateTime end, string types)
{
var sql = new SqlConnection(data.ConnectionString);
var table = new DataTable();
string query = "SELECT dh.DocumentID, dh.DocumentDate, f.FactoryName, dt.DocTypeName, dh.DocTypeID, dh.FactoryID " +
" FROM " + headtable + " dh INNER JOIN dbo.DocumentType dt ON dh.DocTypeID = dt.DocTypeID INNER JOIN " +
factorytable + " f ON dh.FactoryID = f.FactoryID " +
string.Format(" WHERE (dh.DocumentDate>='{0}') AND ((dh.DocumentDate<='{1}'))", start.ToString("yyyyMMdd"), end.ToString("yyyyMMdd")) +
(types != string.Empty ? " AND dh.DocTypeID in (" + types + ")" : "") + " ORDER BY dh.DocumentDate, dh.DocTypeID";
SqlDataAdapter adapter = new SqlDataAdapter(query, sql);
adapter.Fill(table);
return(table);
}
public CreateInputDoc(IGlobalValues data)
{
InitializeComponent();
Data = data;
cmbDocType.DataSource = new BindingSource(data.PlanDocType, null);
cmbDocType.ValueMember = "Key";
cmbDocType.DisplayMember = "Value";
cmbFactory.DataSource = new BindingSource(data.FactoryList, null);
cmbFactory.DisplayMember = "Value";
cmbFactory.ValueMember = "Key";
cmbFactory.Enabled = (cmbFactory.Items.Count != 1);
}
public static IInputDocument CreateDocument(InputDocumentHead head, IGlobalValues data, int parent)
{
switch (head.DocType)
{
case 1:
case 3:
return(PlanDocument.CreateDocument(head, data.ActiveSchema + ".DocumentHead", data.ActiveSchema + ".DocumentBody", data.ConnectionString, parent));
case 2:
case 4:
return(DeviceDocument.CreateDocument(head, data.ActiveSchema + ".DocumentHead", data.ActiveSchema + ".DocumentBody", data.ConnectionString, new List <int>(data.ProductGroups[DEVICES].Keys), parent));
default:
throw new Exception("Неверный тип документа.");
}
}
public static DataTable SelectAllDocuments(IGlobalValues data, string headtable, string factorytable, string rptable, DateTime start, DateTime end, string types)
{
var sql = new SqlConnection(data.ConnectionString);
var table = new DataTable();
string query = "SELECT fdh.DocumentID, fdh.DocumentDate, rp.RPName, f.FactoryName, fdh.ParentDocument, fdt.DocTypeName, fdh.DocTypeID, fdh.RPID, f.FactoryID" +
" FROM " + headtable + " fdh INNER JOIN dbo.ForecastDocumentType fdt ON fdh.DocTypeID = fdt.DocTypeID INNER JOIN " +
rptable + " rp ON fdh.RPID = rp.RPID INNER JOIN " + factorytable + " f ON rp.FactoryID = f.FactoryID " +
string.Format(" WHERE (fdh.DocumentDate>='{0}') AND ((fdh.DocumentDate<='{1}'))", start.ToString("yyyyMMdd"), end.ToString("yyyyMMdd")) +
(types != string.Empty ? " AND fdh.DocTypeID in (" + types + ") " : "") +
" ORDER BY fdh.DocumentDate, rp.RPID, fdt.DocTypeID";
SqlDataAdapter adapter = new SqlDataAdapter(query, sql);
try
{
adapter.Fill(table);
}
catch (Exception exc)
{
throw new Exception("Ошибка загрузки списка документов.\n" + exc.Message, exc);
//return null;
}
return(table);
}
public FormTender(IForecastDocument document, IGlobalValues data)
{
InitializeComponent();
Data = data;
Document = document;
}
public static ForecastDocument LoadDocument(int docnum, IGlobalValues data)
{
return(ForecastDocument.LoadDocument(docnum, data.ActiveSchema + ".ForecastDocumentHead", data.ActiveSchema + ".ForecastDocumentBody", data.ConnectionString));
}
public static ForecastDocument CreateDocument(ForecastDocumentHead head, IGlobalValues data)
{
return(ForecastDocument.CreateDocument(head, data.ActiveSchema + ".ForecastDocumentHead", data.ActiveSchema + ".ForecastDocumentBody", data.ConnectionString));
}
public ChooseParent(int rp, IGlobalValues data)
{
InitializeComponent();
rpID = rp;
Data = data;
}
public static DataTable SelectAllForecastDocuments(IGlobalValues data, DateTime start, DateTime end, string types)
{
return(ForecastDocumentBase.SelectAllDocuments(data, "dbo.vForecastDocumentHead", "dbo.vFactory", "dbo.vRP", start, end, types));
}
public static DataTable SelectForecastDocuments(IGlobalValues data, DateTime start, DateTime end, string types)
{
return(ForecastDocumentBase.SelectAllDocuments(data, data.ActiveSchema + ".ForecastDocumentHead", data.ActiveSchema + ".Factory", data.ActiveSchema + ".RP", start, end, types));
}
public ChooseParentInputDoc(IGlobalValues data)
{
InitializeComponent();
Data = data;
}
public CreateTender(IGlobalValues data)
{
Data = data;
InitializeComponent();
}