private void ShowPermit()
{
Appoint appoint = (Appoint)bindingSourceAppoints.Current;
Permit permit = appoint.GetPermit(database);
permit.Print();
}
/// <summary>
/// создает объект на основе строки БД
/// </summary>
/// <param name="reader">строка БД</param>
/// <param name="apnt">Транспорт</param>
/// <param name="docStates">набор возможных состояний</param>
public AppointState(DbDataReader reader, Appoint apnt, Enumeration docStates)
{
appoint = apnt;
docState = docStates.Find((int)reader["docState"]);
date = (DateTime)reader["dateState"];
reason = (string)reader["reason"];
}
/// <summary>
/// создает новое состояние для транспорта
/// </summary>
/// <param name="apnt">транспорт</param>
/// <param name="dcSt">новое состояние</param>
public AppointState(Appoint apnt, EnumerationItem dcSt)
{
appoint = apnt;
docState = dcSt;
date = DateTime.Now;
reason = "";
Insert();
}
public FormRepointAppoint(EPVDatabase _database, Appoint appoint, Point _fromPoint)
: this()
{
database = _database;
Appoint = appoint;
fromPoint = _fromPoint;
Text = Appoint.TrackInfo;
}
private void buttonSetOut_Click(object sender, EventArgs e)
{
Appoint appoint = (Appoint)bindingSourceAppoints.Current;
if (appoint != null)
{
appoint.GetOut(database, User);
}
toolStripButtonRefresh_Click(sender, e);
}
private void buttonOk_Click(object sender, EventArgs e)
{
if (CheckPoint(cboxPoint.SelectedItem) &&
CheckComment(tboxComment.Text))
{
UpdatePermitComment(tboxComment.Text);
Appoint.SetToPoint(database, Appoint.Unit, (Point)cboxPoint.SelectedItem, DateTime.Now, User);
DialogResult = DialogResult.OK;
}
}
private void MoveTrackToOtherPoint(Appoint appoint)
{
FormRepointAppoint form = new FormRepointAppoint(database, appoint, Point);
if (form.ShowDialog(FindForm().MdiParent) == DialogResult.OK)
{
FormAccepting parentForm = (FormAccepting)this.FindForm();
parentForm.RefreshData();
}
}
private void dataGridViewAppoints_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
Appoint appoint = ((Appoints)bindingSourceAppoints.DataSource)[e.RowIndex];
dataGridViewAppoints.Rows[e.RowIndex].DefaultCellStyle.BackColor = appoint.Color;
if (appoint.Color != SystemColors.Window)
{
dataGridViewAppoints.Rows[e.RowIndex].DefaultCellStyle.SelectionBackColor = Color.Green;
dataGridViewAppoints.Rows[e.RowIndex].DefaultCellStyle.SelectionForeColor = appoint.Color;
dataGridViewAppoints.Rows[e.RowIndex].DefaultCellStyle.Font
= new Font(dataGridViewAppoints.DefaultCellStyle.Font, FontStyle.Bold);
}
}
public AppointStates(EPVDatabase database, Appoint apnt)
{
appoint = apnt;
querySelect = "select * from docAppointStates where appoint = @appoint order by dateState";
QueryParameters parameters = new QueryParameters("appoint", appoint.Id);
docStates = new Enumeration(database, "docState");
DbDataReader reader = database.ExecuteReader(querySelect, parameters);
while (reader.Read())
{
Add(new AppointState(reader, appoint, docStates));
}
reader.Close();
}
private void FormRepointAppoint_Load(object sender, EventArgs e)
{
Permit permit = Appoint.GetPermit(database);
if (permit == null)
{
MessageBox.Show(DispatcherService.Resources.Error.PermitNotFound);
Close();
}
currentComment = permit.GetComment(database);
tboxComment.Text = currentComment;
Points points = new DispatcherService.Points(database, Appoint.Unit);
cboxPoint.DataSource = points;
}
private void dataGridViewAppoints_CellClick(object sender, DataGridViewCellEventArgs e)
{
Appoint appoint = ((Appoints)dataGridViewAppoints.DataSource)[e.RowIndex];
if (e.ColumnIndex == 2 &&
MessageBox.Show(DispatcherService.Resources.Message.EndPoint,
dataGridViewAppoints[0, e.RowIndex].Value.ToString(),
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
appoint.EndPoint(database, User);
RefreshData();
}
if (e.ColumnIndex == 3)
{
MoveTrackToOtherPoint(appoint);
}
}
private void CreateAppoint()
{
Appoint appoint = new Appoint(PlanAppoint);
appoint.Citizen = (State)cboxCountry.SelectedItem;
appoint.SetComingDate(pickComingTime.Value);
appoint.Unit = (Unit)cboxUnit.SelectedItem;
appoint.Warrant = tboxWarrant.Text;
appoint.Trailer = tboxTrailer.Text;
appoint.Save(Database);
string query = DispatcherService.Resources.Doc.PlanAppoint.LinkToAppoint;
QueryParameters parameters = new QueryParameters("plan", PlanAppoint.Id);
parameters.Add("id", appoint.Id);
Database.ExecuteQuery(query, parameters);
FindForm().Close();
}
public Appoint(EPVDatabase database, Appoint copy, Units units, States states)
{
id = copy.Id;
string query = "select a.*, ";
query += "(select dateState from docAppointStates where appoint = a.id and docState = 0) as dateComing ";
query += ", (select PERMIT from docPlanAppoint where id = a.planAppoint) as permitId ";
query += "from docAppoints a where a.id = @id";
QueryParameters parameters = new QueryParameters("id", id);
DbDataReader reader = database.ExecuteReader(query, parameters);
reader.Read();
unit = units.Find((int)reader["idUnit"]);
trackMark = (string)(DBNull.Value.Equals(reader["trackMark"]) ? string.Empty : reader["trackMark"]);
licensePlate = (string)reader["licensePlate"];
trailer = (string)(DBNull.Value.Equals(reader["trailer"]) ? string.Empty : reader["trailer"]);
citizen = states.Find((int)reader["state"]);
driverName = (string)(DBNull.Value.Equals(reader["driverName"]) ? string.Empty : reader["driverName"]);
driverPhone = (string)(DBNull.Value.Equals(reader["driverPhone"]) ? string.Empty : reader["driverPhone"]);
warrant = (string)(DBNull.Value.Equals(reader["warrant"]) ? string.Empty : reader["warrant"]);
whereTo = (string)(DBNull.Value.Equals(reader["whereTo"]) ? string.Empty : reader["whereTo"]);
cargo = (string)(DBNull.Value.Equals(reader["cargo"]) ? string.Empty : reader["cargo"]);
idleReason = (string)(DBNull.Value.Equals(reader["idleReason"]) ? string.Empty : reader["idleReason"]);
dateComing = (DateTime)reader["dateComing"];
docState = copy.DocState;
docStateDate = copy.docStateDate;
if (DBNull.Value.Equals(reader["permitId"]))
{
HasPermit = false;
}
else
{
HasPermit = ((int)reader["permitId"] > 0);
permitId = (int)reader["permitId"];
}
reader.Close();
}
private void dataGridViewDispatcher_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
Appoint appoint = ((Appoints)dataGridViewDispatcher.DataSource)[e.RowIndex];
dataGridViewDispatcher.Rows[e.RowIndex].DefaultCellStyle.BackColor = appoint.Color;
}
private void UpdatePermitComment(string text)
{
Permit permit = Appoint.GetPermit(database);
permit.UpdateComment(database, text);
}