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