private void btnReasonSelect_Click(object sender, EventArgs e)
{
// ранее введеные значения
Pass oPassTemp = new Pass();
oPassTemp.FilterDateEnd = DateTime.Now.Date.AddMonths(-1);
oPassTemp.FilterDateEnd = DateTime.Now.Date;
oPassTemp.FillData();
if (oPassTemp.ErrorNumber != 0 || oPassTemp.MainTable == null)
{
return;
}
if (oPassTemp.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных...");
return;
}
DataTable dtReasonDistinct = new DataTable();
dtReasonDistinct.Columns.Add("Reason");
System.Collections.Hashtable hash = new System.Collections.Hashtable();
foreach (DataRow row in oPassTemp.MainTable.Rows)
{
hash[row["Reason"]] = row["Reason"];
}
foreach (object name in hash.Values)
{
dtReasonDistinct.Rows.Add(name);
}
DataTable tdReason = CopyTable(dtReasonDistinct, "tdReason", "Reason > ''", "Reason");
if (StartForm(new frmSelectID(this, tdReason, "Reason", "Назначение", false)) == DialogResult.Yes)
{
if (_SelectedID == null)
{
return;
}
txtReason.Text = _SelectedText;
}
_SelectedID = null;
_SelectedText = "";
return;
}
private void btnCarSelect_Click(object sender, EventArgs e)
{
_SelectedID = null;
_SelectedText = "";
// ранее введеные значения
Pass oPassTemp = new Pass();
oPass.FilterDateBeg = dtpDatePass.Value.Date.AddMonths(-12);
oPassTemp.FillData();
if (oPassTemp.ErrorNumber != 0 || oPassTemp.MainTable == null)
{
return;
}
if (oPassTemp.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных...");
return;
}
DataTable tdCars = CopyTable(oPassTemp.MainTable, "tdCars", "", "CarName");
if (StartForm(new frmSelectID(this, tdCars, "DatePass, CarName, CarNumber, DriverName, Reason", "Дата, Машина, Гос.номер, Водитель, Назначение", false)) == DialogResult.Yes)
{
if (_SelectedID == null)
{
return;
}
oPassTemp.ClearData();
oPassTemp.ReFillOne((int)_SelectedID);
txtCarNаme.Text = oPassTemp.CarName;
txtCarTypeName.Text = oPassTemp.CarTypeName;
txtCarNumber.Text = oPassTemp.CarNumber;
txtTrailerNumber.Text = oPassTemp.TrailerNumber;
txtDriverName.Text = oPassTemp.DriverName;
txtDriverDocument.Text = oPassTemp.DriverDocument;
txtDriverPhone.Text = oPassTemp.DriverPhone;
txtReason.Text = oPassTemp.Reason;
}
_SelectedID = null;
_SelectedText = "";
}
private bool grdData_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oPassCur.ClearOne();
oPassList.ClearError();
oPassList.ClearFilters();
oPassList.ID = null;
oPassList.IDList = null;
// собираем условия
// даты
if (!dtrDates.dtpBegDate.IsEmpty)
{
oPassList.FilterDateBeg = dtrDates.dtpBegDate.Value.Date;
}
if (!dtrDates.dtpEndDate.IsEmpty)
{
oPassList.FilterDateEnd = dtrDates.dtpEndDate.Value.Date;
}
// машины, типы, водители
// контексты
if (txtCarTypeNameContext.Text.Trim().Length > 0)
{
oPassList.FilterCarTypeNameContext = txtCarTypeNameContext.Text.Trim().ToUpper();
}
if (txtCarNameContext.Text.Trim().Length > 0)
{
oPassList.FilterCarNameContext = txtCarNameContext.Text.Trim().ToUpper();
}
if (txtCarNumberContext.Text.Trim().Length > 0)
{
oPassList.FilterCarNumberContext = txtCarNumberContext.Text.Trim().ToUpper();
}
if (txtDriverNameContext.Text.Trim().Length > 0)
{
oPassList.FilterDriverNameContext = txtDriverNameContext.Text.Trim().ToUpper();
}
if (txtReasonContext.Text.Trim().Length > 0)
{
oPassList.FilterReasonContext = txtReasonContext.Text.Trim().ToUpper();
}
// состояние машины
if (optPassesStatusNotInNotOut.Checked)
{
oPassList.FilterDateBegFull = false;
oPassList.FilterDateEndFull = false;
}
if (optPassesStatusInNotOut.Checked)
{
oPassList.FilterDateBegFull = true;
oPassList.FilterDateEndFull = false;
}
if (optPassesStatusInOut.Checked)
{
oPassList.FilterDateBegFull = true;
oPassList.FilterDateEndFull = true;
}
// подтверждение
if (optIsConfirmed.Checked)
{
oPassList.FilterIsConfirmed = true;
}
if (optIsConfirmedNot.Checked)
{
oPassList.FilterIsConfirmed = false;
}
// разрешение
if (optIsPermitted.Checked)
{
oPassList.FilterIsPermitted = true;
}
if (optIsPermittedNot.Checked)
{
oPassList.FilterIsPermitted = false;
}
//
grdTrips.DataSource = null;
grdData.GetGridState();
oPassList.FillData();
grdData.IsLockRowChanged = true;
grdData.Restore(oPassList.MainTable);
tmrRestore.Enabled = true;
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oPassList.ErrorNumber == 0);
}
private void frmPassesEdit_Load(object sender, EventArgs e)
{
bool bResult = true;
// классификаторы
if (!cboPartner_Restore() ||
!cboCarrierPartner_Restore())
{
bResult = false;
}
if (bResult)
{
oPass.ID = nPassID;
oPass.FillData();
if (oPass.ErrorNumber != 0 || oPass.MainTable == null)
{
bResult = false;
}
if (bResult)
{
if (nPassID.HasValue && oPass.MainTable.Rows.Count != 1)
{
RFMMessage.MessageBoxError("Ошибка при получении данных о пропуске...");
bResult = false;
}
}
}
if (bResult)
{
cboPartner.SelectedIndex =
cboCarrierPartner.SelectedIndex =
-1;
txtPartnerName.Text =
txtCarrierPartnerName.Text =
"";
if (nPassID.HasValue)
{
// существующий пропуск
oPass.FillOne();
dtpDatePass.Value = oPass.DatePass;
txtReason.Text = oPass.Reason;
txtCarNаme.Text = oPass.CarName;
txtCarTypeName.Text = oPass.CarTypeName;
txtCarNumber.Text = oPass.CarNumber;
txtTrailerNumber.Text = oPass.TrailerNumber;
txtDriverName.Text = oPass.DriverName;
txtDriverDocument.Text = oPass.DriverDocument;
txtDriverPhone.Text = oPass.DriverPhone;
numBrutto.Value = oPass.Brutto;
numPalletsQnt.Value = oPass.PalletsQnt;
if (oPass.PartnerID.HasValue)
{
cboPartner.SelectedValue = (int)oPass.PartnerID;
}
txtPartnerName.Text = oPass.PartnerName;
if (oPass.CarrierPartnerID.HasValue)
{
cboCarrierPartner.SelectedValue = (int)oPass.CarrierPartnerID;
}
txtCarrierPartnerName.Text = oPass.CarrierPartnerName;
if (oPass.DateBegPlan.HasValue)
{
chkArrivalPlan.Checked = true;
chkArrivalPlan_CheckedChanged(null, null);
dtpArrivalPlan.Value = (DateTime)oPass.DateBegPlan;
}
else
{
dtpArrivalPlan.HideControl(false);
}
if (oPass.DateEndPlan.HasValue)
{
chkDeparturePlan.Checked = true;
chkDeparturePlan_CheckedChanged(null, null);
dtpDeparturePlan.Value = (DateTime)oPass.DateEndPlan;
}
else
{
dtpDeparturePlan.HideControl(false);
}
if (oPass.DateBeg.HasValue)
{
chkArrivalFact.Checked = true;
chkArrivalFact_CheckedChanged(null, null);
dtpArrivalFact.Value = (DateTime)oPass.DateBeg;
}
else
{
dtpArrivalFact.HideControl(false);
}
if (oPass.DateEnd.HasValue)
{
chkDepartureFact.Checked = true;
chkDepartureFact_CheckedChanged(null, null);
dtpDepartureFact.Value = (DateTime)oPass.DateEnd;
}
else
{
dtpDepartureFact.HideControl(false);
}
txtNote.Text = oPass.Note;
}
else
{
dtpDatePass.Value = DateTime.Now;
dtpArrivalPlan.HideControl(false);
dtpDeparturePlan.HideControl(false);
dtpArrivalFact.HideControl(false);
dtpDepartureFact.HideControl(false);
}
}
if (!bResult)
{
Dispose();
}
}