public static int Insert(int DeptID, int TicketID, int RelatedTicketID, TicketRelationType RelationType)
{
SqlParameter _pRVAL = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
_pRVAL.Direction = ParameterDirection.ReturnValue;
UpdateData("sp_InsertRelatedTicket", new SqlParameter[] { _pRVAL, new SqlParameter("@DId", DeptID), new SqlParameter("@TicketId", TicketID), new SqlParameter("@RelatedTicketId", RelatedTicketID), new SqlParameter("@RelationType", (byte)RelationType)});
if (_pRVAL.Value != DBNull.Value) return (int)_pRVAL.Value;
else return 0;
}
public static int Insert(int DeptID, int TicketID, int RelatedTicketID, TicketRelationType RelationType)
{
SqlParameter _pRVAL = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
_pRVAL.Direction = ParameterDirection.ReturnValue;
UpdateData("sp_InsertRelatedTicket", new SqlParameter[] { _pRVAL, new SqlParameter("@DId", DeptID), new SqlParameter("@TicketId", TicketID), new SqlParameter("@RelatedTicketId", RelatedTicketID), new SqlParameter("@RelationType", (byte)RelationType) });
if (_pRVAL.Value != DBNull.Value)
{
return((int)_pRVAL.Value);
}
else
{
return(0);
}
}
