private void Button0_PressedAfter(object sboObject, SAPbouiCOM.SBOItemEventArg pVal) { //Approve if (Fr_Authorise) { SAPbobsCOM.Recordset oR_RecordSet = (SAPbobsCOM.Recordset)oCom.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); oR_RecordSet.DoQuery("Select * from [@ADDONCFG]"); string uid = oR_RecordSet.Fields.Item("Code").Value.ToString(); string pwd = oR_RecordSet.Fields.Item("Name").Value.ToString(); SqlConnection conn = new SqlConnection(string.Format("Data Source={0}; Initial Catalog={1}; User id={2}; Password={3};", oCom.Server, oCom.CompanyDB, uid, pwd)); SqlCommand cmd = null; try { cmd = new SqlCommand("Update_Blanket_Post_Level", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AbsID", AbsID); cmd.Parameters.AddWithValue("@Blanket_Type", Blanket_Type); cmd.Parameters.AddWithValue("@Blanket_Level", LVL_Posting); cmd.Parameters.AddWithValue("@Usr", oCom.UserName); cmd.Parameters.AddWithValue("@Approve", 1); cmd.Parameters.AddWithValue("@Usr_Comment", this.EditText3.Value.Trim()); conn.Open(); int row_count = cmd.ExecuteNonQuery(); if (row_count == 0) { Application.SBO_Application.StatusBar.SetText("Approve Failed !"); } else { //Approve after level 5 if (LVL_Posting == 5) { SAPbobsCOM.CompanyService oCompSer = oCom.GetCompanyService(); SAPbobsCOM.BlanketAgreementsService oBAService = (SAPbobsCOM.BlanketAgreementsService)oCompSer.GetBusinessService(SAPbobsCOM.ServiceTypes.BlanketAgreementsService); SAPbobsCOM.BlanketAgreementParams oParams = (SAPbobsCOM.BlanketAgreementParams)oBAService.GetDataInterface(SAPbobsCOM.BlanketAgreementsServiceDataInterfaces.basBlanketAgreementParams); oParams.AgreementNo = int.Parse(AbsID); SAPbobsCOM.BlanketAgreement oBA = oBAService.GetBlanketAgreement(oParams); oBA.Status = SAPbobsCOM.BlanketAgreementStatusEnum.asApproved; oBAService.UpdateBlanketAgreement(oBA); } } } catch (Exception ex) { Application.SBO_Application.MessageBox("Can't approve - Error: " + ex.Message); } finally { conn.Close(); cmd.Dispose(); if (!Check_Parent_Form_Closed(Parent_Form.UniqueID)) { Parent_Form.Select(); Application.SBO_Application.ActivateMenuItem("1304"); } this.UIAPIRawForm.Close(); } } }
void Load_Data() { SAPbobsCOM.Recordset rs = (SAPbobsCOM.Recordset)oCom.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); rs.DoQuery(string.Format("Select AbsID from OOAT where Number ='{0}' and BpType = '{1}' and Status ='D' and Cancelled ='N'", Blanket_Agreement_No, Blanket_Type)); AbsID = rs.Fields.Item("AbsID").Value.ToString(); SAPbobsCOM.CompanyService oCompSer = oCom.GetCompanyService(); SAPbobsCOM.BlanketAgreementsService oBAService = (SAPbobsCOM.BlanketAgreementsService)oCompSer.GetBusinessService(SAPbobsCOM.ServiceTypes.BlanketAgreementsService); SAPbobsCOM.BlanketAgreementParams oParams = (SAPbobsCOM.BlanketAgreementParams)oBAService.GetDataInterface(SAPbobsCOM.BlanketAgreementsServiceDataInterfaces.basBlanketAgreementParams); oParams.AgreementNo = int.Parse(AbsID); SAPbobsCOM.BlanketAgreement oBA = oBAService.GetBlanketAgreement(oParams); EditText1.Value = oBA.UserFields.Item("U_PRJ").Value.ToString(); EditText2.Value = oBA.DocNum.ToString(); }