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