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); } }