public static bool FillData_PartnersDetails(Partner oPartner, int?nPartnerID)
{
if (oPartner == null)
{
return(false);
}
RFMCursorWait.Set(true);
//oPartner.FilterActual = true;
bool bResult = false;
if (nPartnerID.HasValue)
{
bResult = oPartner.FillTablePartnersDetails((int)nPartnerID);
}
else
{
bResult = oPartner.FillTablePartnersDetails();
}
if (!bResult ||
oPartner.ErrorNumber != 0 ||
oPartner.TablePartnersDetails == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении данных (реквизиты партнеров)...");
return(false);
}
RFMCursorWait.Set(false);
if (oPartner.TablePartnersDetails.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (реквизиты партнеров)...");
return(false);
}
return(true);
}
public static bool FillData_ManagerNames(OutputDocument oOutputDocument, DateTime?dDateBeg, DateTime?dDateEnd)
{
if (oOutputDocument == null)
{
return(false);
}
if (!dDateBeg.HasValue)
{
dDateBeg = DateTime.Now;
}
if (!dDateEnd.HasValue)
{
dDateEnd = DateTime.Now;
}
RFMCursorWait.Set(true);
if (!oOutputDocument.FillTableManagerNames(dDateBeg, dDateEnd) ||
oOutputDocument.ErrorNumber != 0 ||
oOutputDocument.TableManagerNames == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении данных (менеджеры)...");
return(false);
}
RFMCursorWait.Set(false);
if (oOutputDocument.TableManagerNames.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (менеджеры)...");
return(false);
}
return(true);
}
private bool grdDetailEnd_Restore()
{
grdDetailEnd.GetGridState();
grdDetailEnd.DataSource = null;
if (grdData.Rows.Count == 0 ||
oCellContentSnapshotCur.ID == null ||
grdData.CurrentRow != null && grdData.IsStatusRow(grdData.CurrentRow.Index))
{
return(true);
}
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oCellContentSnapshotList.ClearError();
oCellContentSnapshotList.FillTableCellsContentsSnapshotsDetails((int)oCellContentSnapshotCur.ID, 1,
false, false,
false, chkInInventoryOnly.Checked);
DataTable tableCellContentSnapshotsDetailsEnd = oCellContentSnapshotList.TableCellsContentsSnapshotsDetails;
grdDetailEnd.Restore(tableCellContentSnapshotsDetailsEnd);
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oCellContentSnapshotList.ErrorNumber == 0);
}
public static bool FillData_PartnersRoots(Partner oPartner)
{
if (oPartner == null)
{
return(false);
}
RFMCursorWait.Set(true);
//oPartner.FilterActual = true;
if (!oPartner.FillTablePartnersRoots() ||
oPartner.ErrorNumber != 0 ||
oPartner.TablePartnersRoots == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении данных (объединения партнеров)...");
return(false);
}
RFMCursorWait.Set(false);
if (oPartner.TablePartnersRoots.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (объединения партнеров)...");
return(false);
}
return(true);
}
private void ucSelectRecordID_Owners_Restore()
{
if (ucSelectRecordID_Owners.sourceData == null)
{
RFMCursorWait.Set(true);
Partner oPartner = new Partner();
oPartner.FilterIsOwner = true;
oPartner.FillData();
RFMCursorWait.Set(false);
if (oPartner.ErrorNumber != 0 || oPartner.MainTable == null)
{
RFMMessage.MessageBoxError("ќшибка при получении данных (владельцы)...");
return;
}
if (oPartner.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Ќет данных (владельцы)...");
return;
}
ucSelectRecordID_Owners.Restore(oPartner.MainTable);
}
else
{
ucSelectRecordID_Owners.Restore();
}
}
private void frmReportCellsFramesHistory_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
bool lResult =
cboCBuilding_Restore() &&
cboCLine_Restore() &&
cboCLevel_Restore() &&
cboCRack_Restore() &&
cboCPlace_Restore();
if (!lResult)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("ќшибка при заполнении существующих значений параметров адреса...");
return;
}
grcQnt.AgrType =
grcBoxQnt.AgrType =
grcPalQnt.AgrType =
EnumAgregate.Sum;
btnClearTerms_Click(null, null);
tcList.Init();
RFMCursorWait.Set(false);
}
private bool grdOutputsDocuments_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oOutputDocumentCur.ClearOne();
oOutputDocumentList.ClearError();
oOutputDocumentList.ClearFilters();
oOutputDocumentList.ID = null;
oOutputDocumentList.IDList = null;
grdOutputsDocuments.GetGridState();
grdOutputsDocumentsGoods.DataSource = null;
oTrip.FillTableOutputsDocumentsInTrip(chkOutputsShowCarried.Checked);
grdOutputsDocuments.IsLockRowChanged = true;
grdOutputsDocuments.Restore(oTrip.TableOutputsDocumentsInTrip);
tmrRestore.Enabled = true;
RecalcSumOutputsDocuments();
ShowTotalInfo("OUTPUTSDOCUMENTS");
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oTrip.ErrorNumber == 0);
}
public static bool FillData_Drivers(Driver oDriver)
{
if (oDriver == null)
{
return(false);
}
RFMCursorWait.Set(true);
//oDriver.FilterActual = true;
if (!oDriver.FillData() ||
oDriver.ErrorNumber != 0 ||
oDriver.MainTable == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении данных (водители)...");
return(false);
}
RFMCursorWait.Set(false);
if (oDriver.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (водители)...");
return(false);
}
return(true);
}
private void ucSelectRecordID_Hosts_Restore()
{
if (ucSelectRecordID_Hosts.sourceData == null)
{
RFMCursorWait.Set(true);
oHost.FillData();
RFMCursorWait.Set(false);
if (oHost.ErrorNumber != 0 || oHost.MainTable == null)
{
RFMMessage.MessageBoxError("Ошибка при получении данных (хосты)...");
return;
}
if (oHost.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (хосты)...");
return;
}
ucSelectRecordID_Hosts.Restore(oHost.MainTable);
}
else
{
ucSelectRecordID_Hosts.Restore();
}
}
private bool grdPrintForms_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oPartnerRootCur.ClearOne();
oPrintFormList.ClearError();
oPrintFormList.ClearFilters();
oPrintFormList.ID = null;
// собираем условия
grdPrintForms_Partners.DataSource = null;
grdPrintForms.GetGridState();
oPrintFormList.FillData();
grdPrintForms.IsLockRowChanged = true;
grdPrintForms.Restore(oPrintFormList.MainTable);
tmrRestore.Enabled = true;
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oPrintFormList.ErrorNumber == 0);
}
private void ucSelectRecordID_PartnersRoots_Restore()
{
if (ucSelectRecordID_PartnersRoots.sourceData == null)
{
RFMCursorWait.Set(true);
Partner oPartner = new Partner();
oPartner.FillTablePartnersRoots();
RFMCursorWait.Set(false);
if (oPartner.ErrorNumber != 0 || oPartner.TablePartnersRoots == null)
{
RFMMessage.MessageBoxError("Ошибка при получении данных (объединения партнеров)...");
return;
}
if (oPartner.TablePartnersRoots.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (объединения партнеров)...");
return;
}
ucSelectRecordID_PartnersRoots.Restore(oPartner.TablePartnersRoots);
}
else
{
ucSelectRecordID_PartnersRoots.Restore();
}
}
private void numFramesCnt_ValueChanged(object sender, EventArgs e)
{
if (dt == null || grdData.DataSource == null || grdData.Rows.Count == 0)
{
return;
}
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
bMarkingByCnt = true;
if (numFramesCnt.Value > grdData.Rows.Count)
{
numFramesCnt.Value = grdData.Rows.Count;
}
decimal nBoxQnt = 0;
if (!bMarkingByCheck)
{
grdData.MarkAllRows(false);
for (int i = 0; i <= numFramesCnt.Value - 1; i++)
{
dt.Rows[i]["IsMarked"] = true;
nBoxQnt += Convert.ToDecimal(dt.Rows[i]["BoxQnt"]);
}
lblBoxQnt.Text = ((decimal)(Math.Ceiling(nBoxQnt))).ToString("#########0").Trim() + " кор.";
}
bMarkingByCnt = false;
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
}
private void btnAddressContextMark_Click(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
if (txtAddress.Text.Trim().Length > 0 && dgvCells.Rows.Count > 0)
{
string sAddress = txtAddress.Text.Trim().ToUpper();
string sCellsList = "";
foreach (DataRow r in oCell.MainTable.Rows)
{
if (r["Address"].ToString().ToUpper().Contains(sAddress))
{
sCellsList += r["ID"].ToString() + ",";
}
}
if (sCellsList.Length > 0)
{
sCellsList = RFMUtilities.NormalizeList(sCellsList);
dgvCells.MarkFromList(sCellsList);
}
}
dgvCells.Refresh();
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
}
private void frmActs_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
nUserHostID = ((RFMFormMain)Application.OpenForms[0]).UserInfo.HostID;
lblHosts.Visible =
ucSelectRecordID_Hosts.Visible =
ucSelectRecordID_Hosts.Enabled =
(oHost.Count() > 1 && !nUserHostID.HasValue);
// назначение суммировани¤ на колонки
foreach (Control ctrl in Controls)
{
Utilities.ctrl_AgrTypeSet(ctrl);
}
btnClearTerms_Click(null, null);
tcList.Init();
dtrDates.dtpBegDate.Select();
RFMCursorWait.Set(false);
}
private void frmFrames_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
bool lResult = cboPalletsTypes_Restore();
if (!lResult)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении фильтров (контейнеры)...");
Dispose();
}
grcQntFramesContents.AgrType =
grcBoxQntFramesContents.AgrType =
grcPalQntFramesContents.AgrType =
grcFramesHistoryQnt.AgrType =
grcFramesHistoryBoxQnt.AgrType =
grcFramesHistoryPalQnt.AgrType =
grcFrameWeight.AgrType =
grcFrames_Qnt.AgrType =
grcFrames_BoxQnt.AgrType =
EnumAgregate.Sum;
btnClearTerms_Click(null, null);
tcList.Init();
txtBarCode.Select();
RFMCursorWait.Set(false);
}
public static bool FillData_Employees(Employee oEmployee)
{
if (oEmployee == null)
{
return(false);
}
RFMCursorWait.Set(true);
//oEmployee.FilterActual = true;
if (!oEmployee.FillData() ||
oEmployee.ErrorNumber != 0 ||
oEmployee.MainTable == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении данных (сотрудники)...");
return(false);
}
RFMCursorWait.Set(false);
if (oEmployee.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных (сотрудники)...");
return(false);
}
return(true);
}
private void frmOutputsInputsCarries_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
// назначение суммирования на колонки
foreach (Control ctrl in Controls)
{
Utilities.ctrl_AgrTypeSet(ctrl);
}
grdOutputs.IsStatusShow =
grdOutputsGoods.IsStatusShow =
grdOutputsDocumentsInOutputs.IsStatusShow =
grdOutputsDocuments.IsStatusShow =
grdOutputsDocumentsGoods.IsStatusShow =
grdInputs.IsStatusShow =
grdInputsGoods.IsStatusShow =
grdInputsDocuments.IsStatusShow =
true;
btnClearTerms_Click(null, null);
tcList.Init();
tcOutputsGoods.Init();
tcOutputsDocumentsGoods.Init();
tcInputsGoods.Init();
btnPrint.ShortCutSet(mnuPrint);
//btnService.ShortCutSet(mnuService);
RFMCursorWait.Set(false);
}
public static bool FillData_CarsTypes(CarType oCarType)
{
if (oCarType == null)
{
return(false);
}
RFMCursorWait.Set(true);
//oCarType.FilterActual = true;
if (!oCarType.FillData() ||
oCarType.ErrorNumber != 0 ||
oCarType.MainTable == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ошибка при получении данных (типы машин)...");
return(false);
}
RFMCursorWait.Set(false);
if (oCarType.MainTable.Rows.Count == 0)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Нет данных (типы машин)...");
return(false);
}
return(true);
}
private bool dgvCarsTasks_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oCarTaskCur.ClearOne();
oCarTaskList.ClearError();
oCarTaskList.ClearFilters();
oCarTaskList.ID = null;
oCarTaskList.IDList = null;
// собираем условия
// даты
if (!dtrDates.dtpBegDate.IsEmpty)
{
oCarTaskList.FilterDateBeg = dtrDates.dtpBegDate.Value.Date;
}
if (!dtrDates.dtpEndDate.IsEmpty)
{
oCarTaskList.FilterDateEnd = dtrDates.dtpEndDate.Value.Date;
}
// владельцы
oCarTaskList.FilterPartnersList = ucSelectRecordID_Owners.GetIdString();
// акт привязан к рейсу
if (optTripExistsNot.Checked)
{
oCarTaskList.FilterTripExists = false;
}
if (optTripExists.Checked)
{
oCarTaskList.FilterTripExists = true;
}
// состояние задания: подтверждение
if (optIsConfirmedNot.Checked)
{
oCarTaskList.FilterIsConfirmed = false;
}
if (optIsConfirmed.Checked)
{
oCarTaskList.FilterIsConfirmed = true;
}
//
dgvCarsTasks.GetGridState();
oCarTaskList.FillData();
dgvCarsTasks.IsLockRowChanged = true;
dgvCarsTasks.Restore(oCarTaskList.MainTable);
tmrRestore.Enabled = true;
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oCarTaskList.ErrorNumber == 0);
}
private bool grdData_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
tableShifts.Clear();
// Получение количества смен в день
int nShiftsPerDay = (chkIfShift3Exits.Checked ? 3 : 2);
int[] aShiftsDuration = new int[nShiftsPerDay];
aShiftsDuration[0] = (int)numShift1Hours.Value;
aShiftsDuration[1] = (int)numShift2Hours.Value;
if (nShiftsPerDay == 3)
{
aShiftsDuration[2] = (int)numShift3Hours.Value;
}
DateTime dDateBeg, dDateEnd;
bool bIsNight;
int nShiftsCount = 0;
// Погнали заполнять таблицу
dDateBeg = dtpDateBeg.Value;
while (true)
{
dDateEnd = dDateBeg.AddHours(aShiftsDuration[nShiftsCount % nShiftsPerDay]);
bIsNight = ((dDateBeg.Day != dDateEnd.Day || dDateBeg.Hour >= 20) ? true : false);
// Заполнение строки данных
DataRow r = tableShifts.NewRow();
r["ID"] = nShiftsCount;
r["DateBeg"] = dDateBeg;
r["DateEnd"] = dDateEnd;
r["MajorName"] = "";
r["IsNight"] = bIsNight;
r["Note"] = "";
tableShifts.Rows.Add(r);
// Проверка на окончание цикла
if (dDateEnd >= dtpDateEnd.Value)
{
break;
}
dDateBeg = dDateEnd;
nShiftsCount++;
}
grdData.GetGridState();
grdData.Restore(tableShifts);
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(true);
}
private void frmTripEfficiency_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(false);
grcExpences.AgrType = grcCleanMarkup.AgrType = RFMBaseClasses.EnumAgregate.Sum;
dgvMain.IsStatusShow = true;
dgvMain.Restore(tableEfficiency);
}
private void frmWarrantsNumbers_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
btnClearTerms_Click(null, null);
tcList.Init();
RFMCursorWait.Set(false);
}
private bool grdData_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oFactureCur.ClearOne();
oFactureList.ClearError();
oFactureList.ClearFilters();
oFactureList.ID = null;
oFactureList.IDList = null;
// собираем условия
// даты
if (!dtrDates.dtpBegDate.IsEmpty)
{
oFactureList.FilterDateBeg = dtrDates.dtpBegDate.Value.Date;
}
if (!dtrDates.dtpEndDate.IsEmpty)
{
oFactureList.FilterDateEnd = dtrDates.dtpEndDate.Value.Date;
}
// номер контекст
if (txtFactureNumberContext.Text.Trim().Length > 0)
{
oFactureList.FilterNumberContext = txtFactureNumberContext.Text.Trim();
}
// партнеры
if (sSelectedPartnersSourceIDList.Length > 0)
{
oFactureList.FilterPartnersSourceList = sSelectedPartnersSourceIDList;
}
if (sSelectedPartnersTargetIDList.Length > 0)
{
oFactureList.FilterPartnersTargetList = sSelectedPartnersTargetIDList;
}
// коды заказов на отгрузку
//
grdData.GetGridState();
oFactureList.FillData();
grdData.IsLockRowChanged = true;
grdData.Restore(oFactureList.MainTable);
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oFactureList.ErrorNumber == 0);
}
private bool grdWayBills_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oWayBillCur.ClearOne();
oWayBillList.ClearError();
oWayBillList.ClearFilters();
oWayBillList.ID = null;
oWayBillList.IDList = null;
// собираем условия
// даты
if (!dtrDates.dtpBegDate.IsEmpty)
{
oWayBillList.FilterDateBeg = dtrDates.dtpBegDate.Value.Date;
}
if (!dtrDates.dtpEndDate.IsEmpty)
{
oWayBillList.FilterDateEnd = dtrDates.dtpEndDate.Value.Date;
}
// закрыт?
if (optIsConfirmed.Checked)
{
oWayBillList.FilterIsConfirmed = true;
}
if (optIsConfirmedNot.Checked)
{
oWayBillList.FilterIsConfirmed = false;
}
// типы машин, машины, водители
oWayBillList.FilterCarsList = ucSelectRecordID_Cars.GetIdString();
oWayBillList.FilterCarsTypesList = ucSelectRecordID_CarsTypes.GetIdString();
oWayBillList.FilterDriversEmployeesList = ucSelectRecordID_Drivers.GetIdString();
//
grdWayBills_Trips.DataSource = null;
grdWayBills_Fillings.DataSource = null;
grdWayBills.GetGridState();
oWayBillList.FillData();
grdWayBills.IsLockRowChanged = true;
grdWayBills.Restore(oWayBillList.MainTable);
tmrRestore.Enabled = true;
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oWayBillList.ErrorNumber == 0);
}
private bool dgvCells_Restore()
{
RFMCursorWait.Set(true);
oCell.ClearFilters();
oCell.IDList = null;
if (trvCells.GetMarkedNodes() > 0)
{
DataTable dtMarkedCells = CopyTable((DataTable)trvCells.TreeSource.DataSource, "MarkedCells", "IsMarked AND NOT IsNode", "", new string[] { "ID" });
string strCells = "";
foreach (DataRow r in dtMarkedCells.Rows)
{
strCells += r["ID"].ToString() + ",";
}
if (strCells != null && strCells.Length > 0)
{
oCell.IDList = strCells;
}
}
if (uctZones.IsSelectedExist)
{
DataTable dt = CopyTable(uctZones.selectData, "MarkedZones", "", "", new string[] { "ID" });
string strZones = "";
foreach (DataRow r in dt.Rows)
{
strZones += r["ID"].ToString() + ",";
}
if (strZones != null && strZones.Length > 0)
{
oCell.FilterStoresZonesList = strZones;
}
}
oCell.FillData();
if (!oCell.MainTable.Columns.Contains("PreRank"))
{
oCell.MainTable.Columns.Add("PreRank", Type.GetType("System.Int32"));
}
foreach (DataRow r in oCell.MainTable.Rows)
{
r["PreRank"] = r["Rank"];
}
dgvCells.Restore(oCell.MainTable);
SetButtonStatus(dgvCells.GridSource.Count > 0);
RFMCursorWait.Set(false);
return(true);
}
private void frmSalaryExtraWorks_Load(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
btnClearTerms_Click(null, null);
tcList.Init();
dtrDates.dtpBegDate.Select();
RFMCursorWait.Set(false);
}
private bool grdData_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oShift.ID = null;
oShift.ClearError();
oShift.ClearFilters();
oShift.ID = null;
oShift.IDList = null;
// собираем условия
// даты
if (!dtrDates.dtpBegDate.IsEmpty)
{
oShift.FilterDateBeg = dtrDates.dtpBegDate.Value.Date;
}
if (!dtrDates.dtpEndDate.IsEmpty)
{
oShift.FilterDateEnd = dtrDates.dtpEndDate.Value.Date;
}
// старшие смен
if (ucSelectRecordID_Majors.IsSelectedExist)
{
oShift.FilterMajorsList = ucSelectRecordID_Majors.GetIdString();
}
// смены
if (optAll.Checked)
{
oShift.FilterIsNight = null;
}
else if (optNight.Checked)
{
oShift.FilterIsNight = true;
}
else if (optDay.Checked)
{
oShift.FilterIsNight = false;
}
grdData.GetGridState();
oShift.FillData();
grdData.Restore(oShift.MainTable);
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oShift.ErrorNumber == 0);
}
private bool grdPartnersRoots_Restore()
{
RFMCursorWait.Set(true);
RFMCursorWait.LockWindowUpdate(FindForm().Handle);
oPartnerRootCur.ClearOne();
oPartnerRootList.ClearError();
oPartnerRootList.ClearFilters();
oPartnerRootList.ID = null;
oPartnerRootList.IDList = null;
// собираем условия
// контексты
if (txtNameContext.Text.Trim().Length > 0)
{
oPartnerRootList.FilterNameContext = txtNameContext.Text.Trim().ToUpper();
}
if (txtInnContext.Text.Trim().Length > 0)
{
oPartnerRootList.FilterInnContext = txtInnContext.Text.Trim().ToUpper();
}
// выбор
oPartnerRootList.FilterPartnersRootsList = ucSelectRecordID_PartnersRoots.GetIdString();
// checks
if (optActual.Checked)
{
oPartnerRootList.FilterActual = true;
}
if (optActualNot.Checked)
{
oPartnerRootList.FilterActual = false;
}
//
grdPartnersRoots_Partners.DataSource = null;
grdPartnersRoots.GetGridState();
oPartnerRootList.FillTablePartnersRoots();
grdPartnersRoots.IsLockRowChanged = true;
grdPartnersRoots.Restore(oPartnerRootList.TablePartnersRoots);
tmrRestore.Enabled = true;
RFMCursorWait.LockWindowUpdate(IntPtr.Zero);
RFMCursorWait.Set(false);
return(oPartnerRootList.ErrorNumber == 0);
}
private void btnGuiltyEmloyeeSelect_Click(object sender, EventArgs e)
{
RFMCursorWait.Set(true);
// ранее введеные значени¤
OutputDocument oOutputDocumentTemp = new OutputDocument();
oOutputDocumentTemp.FilterDateBeg = oOutputDocument.DateOutput.AddMonths(-1);
oOutputDocumentTemp.FilterDateEnd = DateTime.Now.Date;
oOutputDocumentTemp.FillData();
if (oOutputDocumentTemp.ErrorNumber != 0 || oOutputDocumentTemp.MainTable == null)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("ќшибка при получении данных о расходных документах...");
return;
}
if (oOutputDocument.MainTable.Rows.Count == 0)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Ќет данных...");
return;
}
DataView dv = new DataView(oOutputDocumentTemp.MainTable, "GuiltyEmployees > ''", "GuiltyEmployees", DataViewRowState.CurrentRows);
DataTable tdGuiltyEmployees = dv.ToTable(true, "GuiltyEmployees");
/*
* DataTable dtGuiltyEmployeesDistinct = new DataTable();
* dtGuiltyEmployeesDistinct.Columns.Add("GuiltyEmployees");
* System.Collections.Hashtable hash = new System.Collections.Hashtable();
* foreach (DataRow row in oOutputDocumentTemp.MainTable.Rows)
* hash[row["GuiltyEmployees"]] = row["GuiltyEmployees"];
* foreach (object name in hash.Values)
* dtGuiltyEmployeesDistinct.Rows.Add(name);
* DataTable tdGuiltyEmployees = CopyTable(dtGuiltyEmployeesDistinct, "tdGuiltyEmployees", "GuiltyEmployees > ''", "GuiltyEmployees");
*/
RFMCursorWait.Set(false);
if (StartForm(new frmSelectID(this, tdGuiltyEmployees, "GuiltyEmployees", "¬иновник проблем", false)) == DialogResult.Yes)
{
if (_SelectedID == null)
{
return;
}
txtGuiltyEmployees.Text = _SelectedText;
}
_SelectedID = null;
_SelectedText = "";
return;
}
private void mniPrintInventoryEmpty_Click(object sender, EventArgs e)
{
RFMMenuUtilities.MenuClear((ToolStripMenuItem)sender);
if (grdData.CurrentRow == null)
{
return;
}
RFMCursorWait.Set(true);
int nPages = 1;
if (StartForm(new frmInputBoxNumeric("Страниц:", nPages)) == DialogResult.Yes)
{
Refresh();
nPages = Convert.ToInt32(GotParam[0]);
}
Inventory oInventoryPrint = new Inventory();
// получение данных
oInventoryPrint.ID = (int)grdData.CurrentRow.Cells["grcID"].Value;
oInventoryPrint.FillData();
if (oInventoryPrint.ErrorNumber != 0 || oInventoryPrint.MainTable == null || oInventoryPrint.MainTable.Rows.Count != 1)
{
RFMCursorWait.Set(false);
RFMMessage.MessageBoxError("Нет данных о ревизии...");
return;
}
if (nPages > 1)
{
oInventoryPrint.MainTable.PrimaryKey = null;
oInventoryPrint.MainTable.Columns["ID"].Unique = false;
DataRow r = oInventoryPrint.MainTable.Rows[0];
for (int i = 1; i < nPages; i++)
{
oInventoryPrint.MainTable.ImportRow(r);
}
}
RFMCursorWait.Set(false);
// отчет
repInventoryEmpty rep = new repInventoryEmpty();
StartForm(new frmActiveReport(oInventoryPrint.MainTable, rep));
}