public void SBO_Application_MenuEvent(ref SAPbouiCOM.MenuEvent pVal, out bool BubbleEvent)
{
BubbleEvent = true;
ContextMenu contextMenu = ContextMenu.GetObj;
if (pVal.BeforeAction)
{
if (pVal.MenuUID == "3591")
{
contextMenu.Clear();
contextMenu.CreateMenu(string.Format("Учет запчастей/расходников и краски"));
}
if (pVal.MenuUID == "subMenu0")
{
// Заполнение формы, которая сейчас откроется
string id = ((SAPbouiCOM.EditText)UIApp.Forms.ActiveForm.Items.Item("lab2").Specific).Value;
initData = AdoNetQueries.GetEqCard(id);
//contextMenu.Clear();
SAPbouiCOM.Framework.Application.SBO_Application.ActivateMenuItem("47620");
//var f = new Form1(a);
//f.Show();
//var f = new UDOForm2(a.internalSN, a.custmrName, a.itemName);
}
}
}
private void LinkedButton0_ClickAfter(object sboObject, SAPbouiCOM.SBOItemEventArg pVal)
{
string batchParam = (Matrix1.Columns.Item("batch").Cells.Item(indexRow).Specific as SAPbouiCOM.EditText).Value;
var batch = AdoNetQueries.getAbsEntry(batchParam);
if (batch != null)
{
this.UIApp.OpenForm((SAPbouiCOM.BoFormObjectEnum) 10000044, null, batch);
}
}
//public Grid grid1 { get; set; }
public Form1(dataFromOINS a)
//public Form1(string sn, string bpName, string itemName, string itemCode, string bpCode, string createDate, string docEntry)
{
a.createDate = a.createDate.Substring(0, a.createDate.LastIndexOf(" "));
EditText5.Value = a.internalSN;
EditText3.Value = a.custmrName;
EditText4.Value = a.itemName;
EditText8.Value = a.customer;
EditText10.Value = a.itemCode;
EditText6.Value = a.createDate;
EditText7.Value = a.docEntry;
EditText9.Value = a.insID;
dataForMatrixes = AdoNetQueries.whereFormIsOpenMatrix0(a.insID);
//this.oForm = this.UIApp.Forms.ActiveForm;
}
private void Matrix1_LinkPressedBefore(object sboObject, SAPbouiCOM.SBOItemEventArg pVal, out bool BubbleEvent)
{
if (pVal.ColUID == "batch")
{
string batchParam = (Matrix1.Columns.Item("batch").Cells.Item(indexRow).Specific as SAPbouiCOM.EditText).Value;
var batch = AdoNetQueries.getAbsEntry(batchParam);
if (batch != null)
{
this.UIApp.OpenForm((SAPbouiCOM.BoFormObjectEnum) 10000044, null, batch);
}
}
if (pVal.ColUID == "code")
{
SAPbouiCOM.ISBOChooseFromListEventArg chflarg = (SAPbouiCOM.ISBOChooseFromListEventArg)pVal;
SAPbouiCOM.DataTable dt = chflarg.SelectedObjects;
if (dt == null)
{
this.UIAPIRawForm.Freeze(false);
}
string ItemName = dt.GetValue("ItemName", 0).ToString();
string ItemCode = dt.GetValue("ItemCode", 0).ToString();
this.UIAPIRawForm.Items.Item("Item_33").Click(SAPbouiCOM.BoCellClickType.ct_Regular);
Matrix1.Columns.Item("code").Editable = false;
Matrix1.Columns.Item("title").Editable = false;
(Matrix1.Columns.Item("code").Cells.Item(pVal.Row).Specific as SAPbouiCOM.EditText).Value = ItemCode;
(Matrix1.Columns.Item("title").Cells.Item(pVal.Row).Specific as SAPbouiCOM.EditText).Value = ItemName;
Matrix1.Columns.Item("code").Editable = true;
Matrix1.Columns.Item("title").Editable = true;
Matrix1.Columns.Item("batch").Editable = true;
Matrix1.Columns.Item("batch").ChooseFromListUID = "CFL_BatchNumber";
Matrix1.AddRow();
}
BubbleEvent = true;
}
// Кнопка "Добавить"
private void Button0_ClickBefore(object sboObject, SAPbouiCOM.SBOItemEventArg pVal, out bool BubbleEvent)
{
//bool a = Matrix0.Columns.Item("code1").Visible;
if (Button0.Caption == "Добавить" || Button0.Caption == "Обновить")
{
if (Folder0.Selected)
{
for (var i = 1; i < (Matrix0.RowCount + 1); i++)
{
allFields data = new allFields();
data.code1 = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("code").Cells.Item(i).Specific).Value;
data.title = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("title").Cells.Item(i).Specific).Value;
data.photo = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("photo").Cells.Item(i).Specific).Value;
data.serialNumber = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("serialN").Cells.Item(i).Specific).Value;
data.articul = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("articul").Cells.Item(i).Specific).Value;
data.EAN = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("EAN").Cells.Item(i).Specific).Value;
data.instDate = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("instDate").Cells.Item(i).Specific).Value;
data.srokExpl = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("srokExpl").Cells.Item(i).Specific).Value;
data.snDate = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("snDate").Cells.Item(i).Specific).Value;
data.comment = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("comment").Cells.Item(i).Specific).Value;
data.warning = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("warning").Cells.Item(i).Specific).Value;
data.charact = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("charact").Cells.Item(i).Specific).Value;
data.modif = ((SAPbouiCOM.EditText)Matrix0.Columns.Item("modif").Cells.Item(i).Specific).Value;
data.docEntry = EditText7.Value;
data.lineId = (i - 1).ToString();
data.insID = EditText9.Value;
if (Button0.Caption == "Добавить")
{
AdoNetQueries.addData(data, 1);
Button0.Caption = "Обновить";
}
if (Button0.Caption == "Обновить")
{
AdoNetQueries.updateData(data, 1);
}
}
}
else if (Folder1.Selected)
{
for (var i = 1; i < (Matrix0.RowCount + 1); i++)
{
allFields data = new allFields();
data.code1 = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("code").Cells.Item(i).Specific).Value;
data.title = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("title").Cells.Item(i).Specific).Value;
data.batchNumber = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("batch").Cells.Item(i).Specific).Value;
data.articul = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("articul").Cells.Item(i).Specific).Value;
data.EAN = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("EAN").Cells.Item(i).Specific).Value;
data.createDate = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("create").Cells.Item(i).Specific).Value;
data.srokExpl = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("srokExpl").Cells.Item(i).Specific).Value;
data.shipingDate = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("ship").Cells.Item(i).Specific).Value;
data.comment = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("comment").Cells.Item(i).Specific).Value;
data.warning = ((SAPbouiCOM.EditText)Matrix1.Columns.Item("warning").Cells.Item(i).Specific).Value;
data.docEntry = EditText7.Value;
data.lineId = (i - 1).ToString();
data.insID = EditText9.Value;
if (Button0.Caption == "Добавить")
{
AdoNetQueries.addData(data, 2);
Button0.Caption = "Обновить";
}
if (Button0.Caption == "Обновить")
{
AdoNetQueries.updateData(data, 2);
}
}
}
}
else
if (Button0.Caption == "Ок")
{
UIApp.Forms.ActiveForm.Close();
}
BubbleEvent = true;
}
private void Form_VisibleAfter(SAPbouiCOM.SBOItemEventArg pVal)
{
if (this.UIAPIRawForm.Visible)
{
if (WarningsProject.Menu.initData != null)
{
EditText4.Value = WarningsProject.Menu.initData.createDate.Substring(0, WarningsProject.Menu.initData.createDate.LastIndexOf(" ")); // Create date
EditText5.Value = WarningsProject.Menu.initData.customer; // CodeBP
EditText0.Value = WarningsProject.Menu.initData.custmrName; // BP Name
EditText6.Value = WarningsProject.Menu.initData.itemCode; // Item Code
EditText1.Value = WarningsProject.Menu.initData.itemName; // Item Name
EditText2.Value = WarningsProject.Menu.initData.internalSN; // Serial Number
EditText7.Value = WarningsProject.Menu.initData.insID; // Ins ID
dataForMatrixes = AdoNetQueries.whereFormIsOpenMatrix0(WarningsProject.Menu.initData.insID);
this.UIAPIRawForm.Freeze(true);
if (dataForMatrixes[0].Length == 0)
{
(Matrix0.Columns.Item("insID").Cells.Item(1).Specific as SAPbouiCOM.EditText).Value = EditText7.Value;
}
if (dataForMatrixes[1].Length == 0)
{
(Matrix1.Columns.Item("insID").Cells.Item(1).Specific as SAPbouiCOM.EditText).Value = EditText7.Value;
}
for (var i = 0; i < dataForMatrixes[0].Length; i++)
{
Matrix0.AddRow();
(Matrix0.Columns.Item("code").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].code1;
(Matrix0.Columns.Item("title").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].title;
(Matrix0.Columns.Item("photo").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].photo;
(Matrix0.Columns.Item("serialN").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].serialNumber;
(Matrix0.Columns.Item("articul").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].articul;
(Matrix0.Columns.Item("EAN").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].EAN;
(Matrix0.Columns.Item("instDate").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].instDate;
(Matrix0.Columns.Item("srokExpl").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].srokExpl;
(Matrix0.Columns.Item("snDate").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].snDate;
(Matrix0.Columns.Item("comment").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].comment;
(Matrix0.Columns.Item("warning").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].warning;
(Matrix0.Columns.Item("charact").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].charact;
(Matrix0.Columns.Item("modif").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].modif;
(Matrix0.Columns.Item("insID").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].insID;
if (dataForMatrixes[0][i].track == "1")
{
(Matrix0.Columns.Item("track").Cells.Item(i + 1).Specific as SAPbouiCOM.CheckBox).Checked = false;
}
else
if (dataForMatrixes[0][i].track == "0")
{
(Matrix0.Columns.Item("track").Cells.Item(i + 1).Specific as SAPbouiCOM.CheckBox).Checked = true;
}
//(Matrix0.Columns.Item("track").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[0][i].track;
}
for (var i = 0; i < dataForMatrixes[1].Length; i++)
{
Matrix1.AddRow();
(Matrix1.Columns.Item("code").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].code1;
(Matrix1.Columns.Item("title").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].title;
(Matrix1.Columns.Item("batch").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].batchNumber;
(Matrix1.Columns.Item("articul").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].articul;
(Matrix1.Columns.Item("EAN").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].EAN;
(Matrix1.Columns.Item("create").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].createDate;
(Matrix1.Columns.Item("srokExpl").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].srokExpl;
(Matrix1.Columns.Item("ship").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].shipingDate;
(Matrix1.Columns.Item("comment").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].comment;
(Matrix1.Columns.Item("warning").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].warning;
(Matrix1.Columns.Item("insID").Cells.Item(i + 1).Specific as SAPbouiCOM.EditText).Value = dataForMatrixes[1][i].insID;
if (dataForMatrixes[1][i].track == "1")
{
(Matrix1.Columns.Item("track").Cells.Item(i + 1).Specific as SAPbouiCOM.CheckBox).Checked = false;
}
else
if (dataForMatrixes[1][i].track == "0")
{
(Matrix1.Columns.Item("track").Cells.Item(i + 1).Specific as SAPbouiCOM.CheckBox).Checked = true;
}
}
}
if ((Matrix0.Columns.Item("photo").Cells.Item(1).Specific as SAPbouiCOM.EditText).Value == "" || (Matrix0.Columns.Item("photo").Cells.Item(1).Specific as SAPbouiCOM.EditText).Value == null)
{
Button1.Item.Visible = false;
}
else
{
Button1.Item.Visible = true;
}
this.UIAPIRawForm.Freeze(false);
}
}
