private void barButtonItem3PrintAll_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (_current == null)
{
return;
}
//if (_changed)
//{
// XtraMessageBox.Show("Salvare il documento prima di effettuare la stampa!", "Messaggio", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
DocumentReport c = new DocumentReport();
ArrayList l = new ArrayList();
l.Add(CreateDummyDocument());
c.DataSource = l;
c.ShowPreviewDialog();
}
catch (Exception ex)
{
ErrorHandler.Show(ex);
}
}
public ActionResult DocReportEdit(int id, DocumentReport dr)
{
try
{
if (docreport.ChangeReport(id, dr))
{
return(RedirectToAction("DocReportIndex"));
}
else
{
return(View("DocReportEdit"));
}
}
catch
{
return(View("DocReportEdit"));
}
}
public ActionResult DocReportCreate(DocumentReport dr)
{
try
{
if (docreport.AddReport(dr))
{
return(RedirectToAction("DocReportIndex"));
}
else
{
return(View("DocReportCreate"));
}
}
catch
{
return(View("DocReportCreate"));
}
}
public List <DocumentReport> GetAllReports()
{
Connect();
List <DocumentReport> DList = new List <DocumentReport>();
try
{
SqlCommand command = new SqlCommand("select * from Document, DocumentReport where Document.documentID=DocumentReport.documentID", Connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DocumentReport report = new DocumentReport();
report.documentID = Convert.ToInt32(reader["documentID"]);
report.name = Convert.ToString(reader["name"]);
report.creationdate = Convert.ToDateTime(reader["creationdate"]);
report.authorID = Convert.ToInt32(reader["authorID"]);
report.status = Convert.ToString(reader["status"]);
report.comment = Convert.ToString(reader["comment"]);
report.shelflife = Convert.ToDateTime(reader["shelflife"]);
report.signerID = Convert.ToInt32(reader["signerID"]);
report.type = Convert.ToString(reader["type"]);
report.startdate = Convert.ToDateTime(reader["startdate"]);
report.enddate = Convert.ToDateTime(reader["enddate"]);
report.stats = Convert.ToString(reader["stats"]);
DList.Add(report);
}
reader.Close();
}
catch (Exception)
{
// Обработка исключения
}
finally
{
Disconnect();
}
return(DList);
}
public bool AddReport(DocumentReport report)
{
bool result = true;
Connect();
try
{
SqlCommand addparent = new SqlCommand("insert into Document (name, creationdate, authorID, status, comment, shelflife, signerID, type) "
+ "VALUES (@name, @creationdate, @authorID, @status, @comment, @shelflife, @signerID, @type)", Connection);
SqlCommand addheir = new SqlCommand("insert into DocumentReport (startdate, enddate, stats, documentID)"
+ "values (@startdate, @enddate, @stats, @documentID)", Connection);
addparent.Parameters.Add(new SqlParameter("@name", report.name));
addparent.Parameters.Add(new SqlParameter("@creationdate", report.creationdate));
addparent.Parameters.Add(new SqlParameter("@authorID", report.authorID));
addparent.Parameters.Add(new SqlParameter("@status", "Создан"));
addparent.Parameters.Add(new SqlParameter("@comment", ""));
addparent.Parameters.Add(new SqlParameter("@shelflife", report.shelflife));
addparent.Parameters.Add(new SqlParameter("@signerID", report.signerID));
addparent.Parameters.Add(new SqlParameter("@type", "Отчет"));
addparent.ExecuteNonQuery();
addparent.CommandText = "Select @@Identity";
int id = Convert.ToInt32(addparent.ExecuteScalar());
addheir.Parameters.Add(new SqlParameter("@startdate", report.startdate));
addheir.Parameters.Add(new SqlParameter("@enddate", report.enddate));
addheir.Parameters.Add(new SqlParameter("@stats", report.stats));
addheir.Parameters.Add(new SqlParameter("@documentID", id));
addheir.ExecuteNonQuery();
}
catch (Exception)
{
result = false;
}
finally { Disconnect(); }
return(result);
}
//public bool DropReport(int id)
//{
// bool result = true;
// Connect();
// try
// {
// string forheir = string.Format("Delete from DocumentReport where documentID='{0}'", id);
// string forparent = string.Format("Delete from Document where documentID='{0}'", id);
// SqlCommand dropheir = new SqlCommand(forheir, Connection);
// SqlCommand dropparent = new SqlCommand(forparent, Connection);
// dropheir.ExecuteNonQuery();
// dropparent.ExecuteNonQuery();
// }
// catch (Exception)
// {
// result = false;
// }
// finally { Disconnect(); }
// return result;
//}
public bool ChangeReport(int id, DocumentReport report)
{
bool result = true;
Connect();
try
{
string forheir = string.Format("update DocumentReport set startdate=@startdate, enddate=@enddate, stats=@stats where documentID='{0}'", id);
string forparent = string.Format("update Document set name=@name, creationdate=@creationdate, authorID=@authorID," +
" status=@status, shelflife=@shelflife, signerID=@signerID, type=@type where documentID='{0}'", id);
SqlCommand changeheir = new SqlCommand(forheir, Connection);
SqlCommand changeparent = new SqlCommand(forparent, Connection);
changeheir.Parameters.AddWithValue("@startdate", report.startdate);
changeheir.Parameters.AddWithValue("@enddate", report.enddate);
changeheir.Parameters.AddWithValue("@stats", report.stats);
changeparent.Parameters.AddWithValue("@name", report.name);
changeparent.Parameters.AddWithValue("@creationdate", report.creationdate);
changeparent.Parameters.AddWithValue("@authorID", report.authorID);
changeparent.Parameters.AddWithValue("@status", "Создан");
changeparent.Parameters.AddWithValue("@shelflife", report.shelflife);
changeparent.Parameters.AddWithValue("@signerID", report.signerID);
changeparent.Parameters.AddWithValue("@type", report.type);
changeheir.ExecuteNonQuery();
changeparent.ExecuteNonQuery();
}
catch (Exception)
{
result = false;
}
finally { Disconnect(); }
return(result);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
DocumentReport c = new DocumentReport();
ArrayList l = new ArrayList();
if (gridView2.FocusedRowHandle >= 0)
{
WIN.SCHEDULING_APPLICATION.DOMAIN.Document label = gridView2.GetRow(gridView2.FocusedRowHandle) as WIN.SCHEDULING_APPLICATION.DOMAIN.Document;
if (label != null)
{
l.Add(label);
c.DataSource = l;
c.ShowPreviewDialog();
}
}
}
catch (Exception ex)
{
ErrorHandler.Show(ex);
}
}
