public int FnBl_CancelPosting(ClsCancelPosting CP)
{
try
{
sql = "Exec Isp_AVS0086 @Flag = '" + CP.Flag + "', @Brcd = '" + CP.Brcd + "', @Edt = '" + CP.Conn.ConvertDate(Edt) + "', @Setno = '" + CP.Setno + "', @Mid = '" + CP.Mid + "'";
Res = Conn.sExecuteQuery(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(Res);
}
public string FnBl_GetData(ClsCancelPosting CP)
{
try
{
sql = "Exec Isp_AVS0086 @Flag = '" + CP.Flag + "', @Brcd = '" + CP.Brcd + "', @Edt = '" + CP.Conn.ConvertDate(Edt) + "', @Setno = '" + CP.Setno + "', @Mid = '" + CP.Mid + "'";
STR = Conn.sExecuteScalar(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(STR);
}
