private void frmReportOutputsQntDifferences_Load(object sender, EventArgs e)
{
grcQntWished.AgrType =
grcQntSelected.AgrType =
grcQntPicked.AgrType =
grcQntConfirmed.AgrType =
EnumAgregate.Sum;
lblInfo.Text = lblInfo.Text.Replace("#", RFMUtilities.Occurs(sOutputsList, ",").ToString().Trim());
opt1_CheckedChanged(null, null);
//btnFilter_Click(null, null);
}
private void cboStoresZones_SelectedIndexChanged(object sender, EventArgs e)
{
sStoreZonePrefix = sStoreZoneSuffix = sAddressMask = "";
nBuildingLen = nLineLen = nRackLen = nLevelLen = nPlaceLen = 0;
DataRow r = oStoreZone.MainTable.Rows.Find(cboStoresZones.SelectedValue);
if (r != null)
{
cboStoresZonesTypes.SelectedValue = (int)r["StoreZoneTypeID"];
sStoreZonePrefix = r["NamePrefix"].ToString();
sStoreZoneSuffix = r["NameSuffix"].ToString();
// длина и наличие составляющих адреса
if (!Convert.IsDBNull(r["AddressMask"]) && r["AddressMask"].ToString() != "")
{
sAddressMask = r["AddressMask"].ToString();
}
if (sAddressMask.Length > 0)
{
nBuildingLen = RFMUtilities.Occurs(sAddressMask, "B");
nLineLen = RFMUtilities.Occurs(sAddressMask, "L");
nRackLen = RFMUtilities.Occurs(sAddressMask, "R");
nLevelLen = RFMUtilities.Occurs(sAddressMask, "V");
nPlaceLen = RFMUtilities.Occurs(sAddressMask, "C");
string sChar = "";
for (int i = 0; i < sAddressMask.Length; i++)
{
sChar = sAddressMask.Substring(i, 1);
if (sChar.CompareTo("A") >= 0 && sChar.CompareTo("Z") <= 0 &&
!"BLRVC".Contains(sChar))
{
RFMMessage.MessageBoxError("Неверная структура маски адреса: " + sAddressMask);
return;
}
}
if (nBuildingLen + nLineLen + nRackLen + nLevelLen + nPlaceLen == 0)
{
RFMMessage.MessageBoxError("Неверная структура маски адреса: " + sAddressMask);
return;
}
lblAddressMask.Text = sStoreZonePrefix + sAddressMask + sStoreZoneSuffix;
}
AddressPartsEnabled();
}
else
{
cboStoresZonesTypes.SelectedIndex = -1;
sStoreZonePrefix = sStoreZoneSuffix = "";
lblAddressMask.Text = "";
}
btnAddressBuild_Click(null, null);
}
private void btnGo_Click(object sender, EventArgs e)
{
// возвращаем код выбранного товара/упаковки в родительскую форму, поле _SelectedPackingID
string _SelectedPackingsIDList = null;
int? _SelectedPackingID = null;
string _SelectedPackingsAliasText = "";
if (grdData.Rows.Count > 0)
{
if (ucSelect != null)
{
ucSelect.SaveData(grdData, "GoodAlias", useCheck);
}
else
{
if (useCheck && grdData.IsCheckerShow)
{
// список ID
_SelectedPackingsIDList = "";
_SelectedPackingsAliasText = "";
DataView dMarked = new DataView(oGoods.MainTable);
dMarked.RowFilter = "IsMarked = true";
dMarked.Sort = grdData.GridSource.Sort;
int i = 0;
int nFirstCntRecords = 3; // количество первых записей дл¤ наборного текстового значени¤
foreach (DataRowView r in dMarked)
{
if (!Convert.IsDBNull(r["PackingID"]))
{
_SelectedPackingsIDList += r["PackingID"].ToString() + ",";
if (i < nFirstCntRecords)
{
_SelectedPackingsAliasText += r["PackingAlias"].ToString().Trim() + ", ";
}
else
{
if (i == nFirstCntRecords)
{
_SelectedPackingsAliasText += "...";
}
}
i++;
}
}
if (_SelectedPackingsIDList.Length == 0)
{
// нет отметок - берем текущую запись
if (grdData.CurrentRow != null)
{
_SelectedPackingsIDList = grdData.CurrentRow.Cells["grcPackingID"].Value.ToString() + ",";
_SelectedPackingsAliasText = grdData.CurrentRow.Cells["grcGoodAlias"].Value.ToString().Trim();
}
}
// приводим наборное текстовое поле к виду: (5) раз, два, три, ...
if (_SelectedPackingsIDList.Length == 0)
{
_SelectedPackingsIDList = null;
_SelectedPackingsAliasText = "";
}
else
{
_SelectedPackingsAliasText = _SelectedPackingsAliasText.Trim();
if (_SelectedPackingsAliasText.Substring(_SelectedPackingsAliasText.Length - 1, 1) == ",")
{
_SelectedPackingsAliasText = _SelectedPackingsAliasText.Substring(0, _SelectedPackingsAliasText.Length - 1);
}
_SelectedPackingsAliasText = "(" + RFMUtilities.Occurs(_SelectedPackingsIDList, ",").ToString() + "): " +
_SelectedPackingsAliasText;
}
if (bFromParentForm && parentForm != null)
{
RFMUtilities.SetFormField(parentForm, "_SelectedPackingsIDList", _SelectedPackingsIDList);
RFMUtilities.SetFormField(parentForm, "_SelectedPackingsAliasText", _SelectedPackingsAliasText);
}
}
else
{
// ID текущей строки
if (grdData.CurrentRow != null)
{
_SelectedPackingID = (int)grdData.CurrentRow.Cells["grcPackingID"].Value;
_SelectedPackingsAliasText = grdData.CurrentRow.Cells["grcGoodAlias"].Value.ToString().Trim();
}
if (bFromParentForm && parentForm != null)
{
RFMUtilities.SetFormField(parentForm, "_SelectedPackingID", _SelectedPackingID);
RFMUtilities.SetFormField(parentForm, "_SelectedPackingsAliasText", _SelectedPackingsAliasText);
}
}
}
}
else
{
RFMMessage.MessageBoxInfo("Ќе выбрано ни одного товара...");
}
DialogResult = DialogResult.Yes;
Dispose();
}
private void SetStartTerms()
{
// начальные условия
if (oOutputDocument != null)
{
// даты диапазона можно менять
if (oOutputDocument.FilterDateBeg != null)
{
dtrDates.dtpBegDate.Value = Convert.ToDateTime(oOutputDocument.FilterDateBeg);
}
if (oOutputDocument.FilterDateEnd != null)
{
dtrDates.dtpEndDate.Value = Convert.ToDateTime(oOutputDocument.FilterDateEnd);
}
// другие условия менять нельзя
if (oOutputDocument.FilterDateOutput != null)
{
dtrDates.dtpBegDate.Value =
dtrDates.dtpEndDate.Value =
Convert.ToDateTime(oOutputDocument.FilterDateOutput);
dtrDates.Enabled = false;
}
if (oOutputDocument.FilterDeliveryNeed != null)
{
if ((bool)oOutputDocument.FilterDeliveryNeed)
{
optDeliveryNeed.Checked = true;
}
else
{
optDeliveryNeedNot.Checked = true;
}
pnlDeliveryNeed.Enabled = false;
}
if (oOutputDocument.FilterOwnersList != null)
{
ucSelectRecordID_Owners.LstMarked = oOutputDocument.FilterOwnersList.ToString();
ucSelectRecordID_Owners.Enabled = false;
}
if (oOutputDocument.FilterPartnersSourceList != null)
{
ucSelectRecordID_PartnersSource.LstMarked = oOutputDocument.FilterPartnersSourceList.ToString();
ucSelectRecordID_PartnersSource.Enabled = false;
}
if (oOutputDocument.FilterPartnersTargetList != null)
{
ucSelectRecordID_PartnersTarget.LstMarked = oOutputDocument.FilterPartnersTargetList.ToString();
ucSelectRecordID_PartnersTarget.Enabled = false;
}
if (oOutputDocument.FilterIsBrought != null)
{
if ((bool)oOutputDocument.FilterIsBrought)
{
optOutputsDocumentsIsBrought.Checked = true;
}
else
{
optOutputsDocumentsIsBroughtNot.Checked = true;
}
pnlOutputsDocumentsIsBrought.Enabled = false;
}
if (oOutputDocument.FilterIsConfirmed != null)
{
if ((bool)oOutputDocument.FilterIsConfirmed)
{
optOutputsDocumentsIsConfirmed.Checked = true;
}
else
{
optOutputsDocumentsIsConfirmedNot.Checked = true;
}
pnlOutputsDocumentsIsConfirmed.Enabled = false;
}
if (oOutputDocument.FilterIsOutputExists != null)
{
if ((bool)oOutputDocument.FilterIsOutputExists)
{
optOutputExists.Checked = true;
}
else
{
optOutputExistsNot.Checked = true;
}
pnlOutputExists.Enabled = false;
}
if (oOutputDocument.FilterTripExists != null)
{
if ((bool)oOutputDocument.FilterTripExists)
{
optTripExists.Checked = true;
}
else
{
optTripExistsNot.Checked = true;
}
pnlTripExists.Enabled = false;
}
if (oOutputDocument.FilterTripsList != null)
{
if (RFMUtilities.Occurs(RFMUtilities.NormalizeList(oOutputDocument.FilterTripsList), ",") == 0 &&
oOutputDocument.FilterTripsList != "")
{
try
{
numTripID.Value = Convert.ToInt32(RFMUtilities.NormalizeList(oOutputDocument.FilterTripsList));
}
finally { }
}
numTripID.Enabled =
lblAliasContext.Enabled =
false;
}
if (oOutputDocument.FilterPackingsList != null)
{
sSelectedPackingsIDList = oOutputDocument.FilterPackingsList.ToString();
pnlPackings.Enabled = false;
}
if (oOutputDocument.FilterHostsList != null)
{
ucSelectRecordID_Hosts.LstMarked = oOutputDocument.FilterHostsList.ToString();
ucSelectRecordID_Hosts.Enabled = false;
}
if (nUserHostID.HasValue)
{
ucSelectRecordID_Hosts.LstMarked = nUserHostID.ToString();
}
}
}
private void btnGo_Click(object sender, EventArgs e)
{
// возвращаем код/список кодов заказов в родительскую форму
string _SelectedOutputsDocumentsIDList = null;
int? _SelectedOutputDocumentID = null;
string _SelectedOutputsDocumentsText = "";
if (grdOutputsDocuments.Rows.Count > 0)
{
if (useCheck && grdOutputsDocuments.IsCheckerShow)
{
// список ID
_SelectedOutputsDocumentsIDList = "";
_SelectedOutputsDocumentsText = "";
DataView dMarked = new DataView(oOutputDocumentList.MainTable);
dMarked.RowFilter = "IsMarked = true";
dMarked.Sort = grdOutputsDocuments.GridSource.Sort;
int i = 0;
foreach (DataRowView r in dMarked)
{
if (!Convert.IsDBNull(r["ID"]))
{
_SelectedOutputsDocumentsIDList += r["ID"].ToString() + ",";
if (i < nFirstCntRecords)
{
_SelectedOutputsDocumentsText += Convert.ToDateTime(r["DateOutput"]).ToString("dd.MM.yyyy") + " " + r["PartnerTargetName"].ToString() + ", ";
}
else
{
if (i == nFirstCntRecords)
{
_SelectedOutputsDocumentsText += "...";
}
}
i++;
}
}
if (_SelectedOutputsDocumentsIDList.Length == 0)
{
// нет отметок - берем текущую запись
if (grdOutputsDocuments.CurrentRow != null)
{
_SelectedOutputsDocumentsIDList = grdOutputsDocuments.CurrentRow.Cells["grcOutputsDocuments_ID"].Value.ToString() + ",";
_SelectedOutputsDocumentsText = grdOutputsDocuments.CurrentRow.Cells["grcOutputsDocuments_DateOutput"].Value.ToString().Substring(0, 10) + " " +
grdOutputsDocuments.CurrentRow.Cells["grcOutputsDocuments_PartnerTargetName"].Value.ToString().Trim();
}
}
// приводим наборное текстовое поле к виду: (5) раз, два, три, ...
if (_SelectedOutputsDocumentsIDList.Length == 0)
{
_SelectedOutputsDocumentsIDList = null;
_SelectedOutputsDocumentsText = "";
}
else
{
_SelectedOutputsDocumentsText = _SelectedOutputsDocumentsText.Trim();
if (_SelectedOutputsDocumentsText.Substring(_SelectedOutputsDocumentsText.Length - 1, 1) == ",")
{
_SelectedOutputsDocumentsText = _SelectedOutputsDocumentsText.Substring(0, _SelectedOutputsDocumentsText.Length - 1);
}
_SelectedOutputsDocumentsText = "(" + RFMUtilities.Occurs(_SelectedOutputsDocumentsIDList, ",").ToString() + "): " +
_SelectedOutputsDocumentsText;
}
RFMUtilities.SetFormField(parentForm, "_SelectedOutputsDocumentsIDList", _SelectedOutputsDocumentsIDList);
RFMUtilities.SetFormField(parentForm, "_SelectedOutputsDocumentsText", _SelectedOutputsDocumentsText);
}
else
{
// ID текущей строки
if (grdOutputsDocuments.CurrentRow != null)
{
_SelectedOutputDocumentID = Convert.ToInt32(grdOutputsDocuments.CurrentRow.Cells["grcOutputsDocuments_ID"].Value);
_SelectedOutputsDocumentsText = grdOutputsDocuments.CurrentRow.Cells["grcOutputsDocuments_DateOutput"].Value.ToString().Substring(0, 10) + " " +
grdOutputsDocuments.CurrentRow.Cells["grcOutputsDocuments_PartnerTargetName"].Value.ToString().Trim();
}
RFMUtilities.SetFormField(parentForm, "_SelectedOutputDocumentID", _SelectedOutputDocumentID);
RFMUtilities.SetFormField(parentForm, "_SelectedOutputsDocumentsText", _SelectedOutputsDocumentsText);
}
}
else
{
RFMMessage.MessageBoxInfo("Не выбрано ни одного расходного документа...");
}
DialogResult = DialogResult.Yes;
Dispose();
}
private void cboStoresZones_SelectedIndexChanged(object sender, EventArgs e)
{
sStoreZonePrefix = sStoreZoneSuffix = sAddressMask = "";
nBuildingLen = nLineLen = nRackLen = nLevelLen = nPlaceLen = 0;
DataRow r = oStoreZone.MainTable.Rows.Find(cboStoresZones.SelectedValue);
if (r != null)
{
cboStoresZonesTypes.SelectedValue = (int)r["StoreZoneTypeID"];
sStoreZonePrefix = r["NamePrefix"].ToString();
sStoreZoneSuffix = r["NameSuffix"].ToString();
// длина и наличие составл¤ющих адреса
if (Convert.IsDBNull(r["AddressMask"]) || r["AddressMask"].ToString() == "")
{
// если маска адресов ¤чеек не указана:
// дл¤ массовых ¤чеек - по умолчальной маске, дл¤ одиночных - без маски
if (!Convert.IsDBNull(r["ForStorage"]) && Convert.ToBoolean(r["ForStorage"]))
{
Setting oSet = new Setting();
sAddressMask = oSet.FillVariable("cAddressMask");
if (sAddressMask == "")
{
RFMMessage.MessageBoxError("Ќе определена маска адресов ¤чеек...");
return;
}
}
}
else
{
sAddressMask = r["AddressMask"].ToString();
}
if (sAddressMask.Length > 0)
{
nBuildingLen = RFMUtilities.Occurs(sAddressMask, "B");
nLineLen = RFMUtilities.Occurs(sAddressMask, "L");
nRackLen = RFMUtilities.Occurs(sAddressMask, "R");
nLevelLen = RFMUtilities.Occurs(sAddressMask, "V");
nPlaceLen = RFMUtilities.Occurs(sAddressMask, "C");
string sChar = "";
for (int i = 0; i < sAddressMask.Length; i++)
{
sChar = sAddressMask.Substring(i, 1);
if (sChar.CompareTo("A") >= 0 && sChar.CompareTo("Z") <= 0 &&
!"BLRVC".Contains(sChar))
{
RFMMessage.MessageBoxError("Ќеверна¤ структура маски адреса: " + sAddressMask);
return;
}
}
if (nBuildingLen + nLineLen + nRackLen + nLevelLen + nPlaceLen == 0)
{
RFMMessage.MessageBoxError("Ќеверна¤ структура маски адреса: " + sAddressMask);
return;
}
lblAddressMask.Text = sStoreZonePrefix + sAddressMask + sStoreZoneSuffix;
}
AddressPartsEnabled();
}
else
{
cboStoresZonesTypes.SelectedIndex = -1;
sStoreZonePrefix = sStoreZoneSuffix = "";
lblAddressMask.Text = "";
}
btnAddressBuild_Click(null, null);
}
private void SetStartTerms()
{
// начальные условия
if (oInput != null)
{
// даты можно менять
if (oInput.FilterDateBeg != null)
{
dtrDates.dtpBegDate.Value = Convert.ToDateTime(oInput.FilterDateBeg);
}
if (oInput.FilterDateEnd != null)
{
dtrDates.dtpEndDate.Value = Convert.ToDateTime(oInput.FilterDateEnd);
}
// остальные условия менять нельзя
if (oInput.FilterDeliveryNeed != null)
{
if ((bool)oInput.FilterDeliveryNeed)
{
optDeliveryNeed.Checked = true;
}
else
{
optDeliveryNeedNot.Checked = true;
}
pnlDeliveryNeed.Enabled = false;
}
if (oInput.FilterOwnersList != null)
{
ucSelectRecordID_Owners.LstMarked = oInput.FilterOwnersList.ToString();
ucSelectRecordID_Owners.Enabled = false;
}
if (oInput.FilterInputsTypesList != null)
{
ucSelectRecordID_InputsTypes.LstMarked = oInput.FilterInputsTypesList.ToString();
ucSelectRecordID_InputsTypes.Enabled = false;
}
if (oInput.FilterPartnersList != null)
{
ucSelectRecordID_InputsPartners.LstMarked = oInput.FilterPartnersList.ToString();
ucSelectRecordID_InputsPartners.Enabled = false;
}
if (oInput.FilterIsConfirmed != null)
{
if ((bool)oInput.FilterIsConfirmed)
{
optIsConfirmed.Checked = true;
}
else
{
optIsConfirmedNot.Checked = true;
}
pnlIsConfirmed.Enabled = false;
}
if (oInput.FilterReadyForWMS != null)
{
if ((bool)oInput.FilterReadyForWMS)
{
optReadyForWMS.Checked = true;
}
else
{
optReadyForWMSNot.Checked = true;
}
pnlReadyForWMS.Enabled = false;
}
if (oInput.FilterTripExists != null)
{
if ((bool)oInput.FilterTripExists)
{
optTripExists.Checked = true;
}
else
{
optTripExistsNot.Checked = true;
}
pnlTripExists.Enabled = false;
}
if (oInput.FilterTripsList != null)
{
if (RFMUtilities.Occurs(RFMUtilities.NormalizeList(oInput.FilterTripsList), ",") == 0 &&
oInput.FilterTripsList != "")
{
try
{
numTripID.Value = Convert.ToInt32(RFMUtilities.NormalizeList(oInput.FilterTripsList));
}
finally { }
}
numTripID.Enabled =
lblAliasContext.Enabled =
false;
}
if (oInput.FilterPackingsList != null)
{
sSelectedPackingsIDList = oInput.FilterPackingsList.ToString();
pnlPackings.Enabled = false;
}
if (oInput.FilterHostsList != null)
{
ucSelectRecordID_Hosts.LstMarked = oInput.FilterHostsList.ToString();
ucSelectRecordID_Hosts.Enabled = false;
}
if (nUserHostID.HasValue)
{
ucSelectRecordID_Hosts.LstMarked = nUserHostID.ToString();
}
}
}
private void btnOutputsChoose_Click(object sender, EventArgs e)
{
_SelectedIDList = null;
_SelectedText = "";
Output oOutput = new Output();
WaitOn(this);
// фильтры
//oOutput.FilterConfirmed = false;
oOutput.FilterDateBeg = DateTime.Now.Date.AddDays(-2);
oOutput.FillData();
WaitOff(this);
if (oOutput.ErrorNumber != 0 || oOutput.MainTable == null)
{
RFMMessage.MessageBoxError("Ошибка при получении данных...");
return;
}
if (oOutput.MainTable.Rows.Count == 0)
{
RFMMessage.MessageBoxError("Нет данных...");
return;
}
if (StartForm(new frmSelectID(this, oOutput.MainTable,
"DateOutput, ERPCode, DateConfirm, OutputTypeName, PartnerName, CarAlias, BackDoor, Note, CellAddress, OutputID",
"Дата, ERPCode, Подтв., Тип, Клиент, Машина, ЗД, Примечание, Ячейка отгр., ID", true)) == DialogResult.Yes)
{
if (_SelectedIDList == null || !_SelectedIDList.Contains(","))
{
btnOutputsClear_Click(null, null);
return;
}
sSelectedOutputsIDList = "," + _SelectedIDList;
_SelectedText = "";
oOutput.IDList = sSelectedOutputsIDList;
oOutput.FillData();
// список ERP-кодов показать
int nFirstCntRecords = 3;
int i = 0;
foreach (DataRow r in oOutput.MainTable.Rows)
{
if (i < nFirstCntRecords)
{
_SelectedText += r["ERPCode"].ToString() + ", ";
}
else
{
if (i == nFirstCntRecords)
{
_SelectedText += "...";
}
}
i++;
}
_SelectedText = _SelectedText.Trim();
if (_SelectedText.Substring(_SelectedText.Length - 1, 1) == ",")
{
_SelectedText = _SelectedText.Substring(0, _SelectedText.Length - 1);
}
if (_SelectedText.Length > 0)
{
_SelectedText = "(" + RFMUtilities.Occurs(_SelectedIDList, ",").ToString() + "): " +
_SelectedText.Trim();
}
txtOutputsChoosen.Text = _SelectedText;
ttToolTip.SetToolTip(txtOutputsChoosen, txtOutputsChoosen.Text);
}
_SelectedIDList = null;
_SelectedText = "";
}
