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); } } }
//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; }
public static dataFromOINS GetEqCard(string id) { dataFromOINS dataOINS = new dataFromOINS(); //List<dataFromOINS> serviceCallsArr = new List<dataFromOINS>(); using (HanaCommand command = new HanaCommand() { Connection = connection }) { command.CommandText = @"select * from ""OINS"""; command.CommandText += string.Format(@"where ""insID""='{0}'", id); connection.Open(); using (HanaDataAdapter da = new HanaDataAdapter(command.CommandText, connection)) { using (DataTable dt = new DataTable()) { da.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { dataOINS.customer = dt.Rows[i]["customer"].ToString(); dataOINS.itemCode = dt.Rows[i]["itemCode"].ToString(); dataOINS.internalSN = dt.Rows[i]["internalSN"].ToString(); dataOINS.custmrName = dt.Rows[i]["custmrName"].ToString(); dataOINS.itemName = dt.Rows[i]["itemName"].ToString(); dataOINS.createDate = dt.Rows[i]["createDate"].ToString(); dataOINS.docEntry = dt.Rows[i]["U_DocEntry"].ToString(); dataOINS.insID = dt.Rows[i]["insID"].ToString(); } } } connection.Close(); return(dataOINS); } }